298 lines
12 KiB
C#
298 lines
12 KiB
C#
using BLL;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using System.Linq;
|
|
using System.Web;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
|
|
namespace FineUIPro.Web.SubPackManage
|
|
{
|
|
public partial class SubPackBlacklistTeam : PageBase
|
|
{
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
if (!IsPostBack)
|
|
{
|
|
Funs.DropDownPageSize(this.ddlTeamPageSize);
|
|
|
|
BLL.BaseBranchTeamListTeamService.DropSelectUnitWork(drpUnit_Team, this.CurrUser.LoginProjectId, true);
|
|
|
|
BLL.SubPackTeamListService.DropSelectTeamWorkUpdate(drpBranchTeamList_Team, "-1", this.CurrUser.LoginProjectId, true);
|
|
|
|
BLL.SubPackLaborTeamService.DropSelectLaborTeamUpdate(drpLaborTeam_Team, "-1", "-1", this.CurrUser.LoginProjectId, true);
|
|
|
|
Team_BindGrid();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 过滤表头
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void GridTeam_FilterChange(object sender, EventArgs e)
|
|
{
|
|
Team_BindGrid();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 分页
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void GridTeam_PageIndexChange(object sender, GridPageEventArgs e)
|
|
{
|
|
GridTeam.PageIndex = e.NewPageIndex;
|
|
Team_BindGrid();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 排序
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void GridTeam_Sort(object sender, GridSortEventArgs e)
|
|
{
|
|
Team_BindGrid();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 分页显示条数下拉框
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void ddlTeamPageSize_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
GridTeam.PageSize = Convert.ToInt32(ddlTeamPageSize.SelectedValue);
|
|
Team_BindGrid();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 绑定数据
|
|
/// </summary>
|
|
|
|
public void Team_BindGrid()
|
|
{
|
|
DataTable tb = BranchTeamListTeamData();
|
|
|
|
GridTeam.RecordCount = tb.Rows.Count;
|
|
|
|
tb = GetFilteredTable(GridTeam.FilteredData, tb);
|
|
var table = this.GetPagedDataTable(GridTeam, tb);
|
|
|
|
GridTeam.DataSource = table;
|
|
GridTeam.DataBind();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 数据查询
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
protected DataTable BranchTeamListTeamData()
|
|
{
|
|
string strSql = @"select a.BranchTeamListTeamId,a.UnitId,a.BranchTeamListId,a.BranchTeamListTeamName,a.Remark,a.SortIndex,isnull(a.State,'0')State,a.MonitorName,a.MonitorIDCard,a.ProjectId,a.LaborTeamId "
|
|
+ @",c.UnitName,b.SubPackTeamListName BranchTeamListName,d.LaborTeamName,e.Remark BackRemark "
|
|
+ @" FROM SubPack_BranchTeamListTeam a(NOLOCK) "
|
|
+ @" left join SubPack_Blacklist e(NOLOCK) on a.BranchTeamListTeamId=e.BlackForeignKey AND e.BlackType=@BlackType"
|
|
+ @" left join View_SubPack_TeamList b(NOLOCK) on a.BranchTeamListId=b.SubPackTeamListDetailID "
|
|
+ @" left join Base_Unit c(NOLOCK) on a.UnitId=c.UnitId "
|
|
+ @" left join SubPack_LaborTeam d(NOLOCK) on a.LaborTeamId=d.LaborTeamId "
|
|
+ @" where a.ProjectId=@ProjectId ";
|
|
|
|
List<SqlParameter> listStr = new List<SqlParameter>();
|
|
listStr.Add(new SqlParameter("@BlackType", Const.SubPackBlackListTeam));
|
|
if (this.CurrUser == null || string.IsNullOrWhiteSpace(this.CurrUser.LoginProjectId))
|
|
{
|
|
strSql += " AND 1<>1 ";
|
|
listStr.Add(new SqlParameter("@ProjectId", ""));
|
|
}
|
|
else
|
|
listStr.Add(new SqlParameter("@ProjectId", this.CurrUser.LoginProjectId));
|
|
|
|
if (drpUnit_Team.SelectedValue != BLL.Const._Null && drpUnit_Team.SelectedValue != null)
|
|
{
|
|
strSql += " AND a.UnitId=@unitId ";
|
|
listStr.Add(new SqlParameter("@unitId", drpUnit_Team.SelectedValue));
|
|
}
|
|
//劳务公司
|
|
if (drpBranchTeamList_Team.SelectedValue != BLL.Const._Null && drpBranchTeamList_Team.SelectedValue != null)
|
|
{
|
|
strSql += " AND a.BranchTeamListId=@branchTeamListId ";
|
|
listStr.Add(new SqlParameter("@branchTeamListId", drpBranchTeamList_Team.SelectedValue));
|
|
}
|
|
//劳务队伍
|
|
if (drpLaborTeam_Team.SelectedValue != BLL.Const._Null && drpLaborTeam_Team.SelectedValue != null)
|
|
{
|
|
strSql += " AND a.LaborTeamId=@LaborTeamId ";
|
|
listStr.Add(new SqlParameter("@LaborTeamId", drpLaborTeam_Team.SelectedValue));
|
|
}
|
|
if (!string.IsNullOrWhiteSpace(txtBranchTeamListTeamName.Text.Trim()))
|
|
{
|
|
strSql += " AND a.BranchTeamListTeamName like '%'+ @branchTeamListTeamName + '%' ";
|
|
listStr.Add(new SqlParameter("@branchTeamListTeamName", txtBranchTeamListTeamName.Text.Trim()));
|
|
}
|
|
|
|
if (rblState.SelectedValue=="0")
|
|
{
|
|
strSql += " AND isnull(a.State,'0')='0' ";
|
|
}
|
|
else if (rblState.SelectedValue == "1")
|
|
{
|
|
strSql += " AND isnull(a.State,'0')='1' ";
|
|
}
|
|
|
|
SqlParameter[] parameter = listStr.ToArray();
|
|
DataTable tb = SQLHelper.GetDataTableRunText(strSql, parameter);
|
|
return tb;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 施工分包商下拉框
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void drpTeamUnit_Team_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
BLL.SubPackTeamListService.DropSelectTeamWorkUpdate(drpBranchTeamList_Team, drpUnit_Team.SelectedValue, this.CurrUser.LoginProjectId, true);
|
|
drpBranchTeamList_Team.SelectedValue = BLL.Const._Null;
|
|
BLL.SubPackLaborTeamService.DropSelectLaborTeamUpdate(drpLaborTeam_Team, drpUnit_Team.SelectedValue, "-1", this.CurrUser.LoginProjectId, true);
|
|
drpLaborTeam_Team.SelectedValue = BLL.Const._Null;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 劳务公司下拉框
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void drpBranchTeamList_Team_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
BLL.SubPackLaborTeamService.DropSelectLaborTeamUpdate(drpLaborTeam_Team, drpUnit_Team.SelectedValue, drpBranchTeamList_Team.SelectedValue, this.CurrUser.LoginProjectId, true);
|
|
drpLaborTeam_Team.SelectedValue = BLL.Const._Null;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 加入黑名单按钮
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void btnMenuTeamBack_Click(object sender, EventArgs e)
|
|
{
|
|
var buttonList = BLL.CommonService.GetAllButtonList(null, this.CurrUser.UserId, BLL.Const.SubPackBlacklistTeamMenuId);
|
|
if (buttonList.Count <= 0 || !buttonList.Contains(BLL.Const.BtnModify))
|
|
{
|
|
Alert.ShowInTop("没有操作此功能权限！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
if (GridTeam.SelectedRowIndexArray.Length == 0)
|
|
{
|
|
Alert.ShowInTop("请至少选择一条记录！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
string id = GridTeam.SelectedRowID.Split(',')[0];
|
|
var item = Funs.DB.SubPack_BranchTeamListTeam.FirstOrDefault(p => p.BranchTeamListTeamId == id);
|
|
if (item == null)
|
|
{
|
|
Alert.ShowInTop("你要加入黑名单的数据在数据库已经不存在了，请重新查询试试！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
//不判断的原因是可以客户要重新修改一下原因
|
|
//if (item.State == "1")
|
|
//{
|
|
// Alert.ShowInTop("此数据已经加入黑名单，请不要重复操作！", MessageBoxIcon.Warning);
|
|
// return;
|
|
//}
|
|
|
|
PageContext.RegisterStartupScript(Window1.GetShowReference(String.Format("SubPackBlackRemark.aspx?BlackForeignKey={0}&IDCard={1}&BlackType={2}&ProjectID={3}", item.BranchTeamListTeamId, item.MonitorIDCard, Const.SubPackBlackListTeam, item.ProjectId)));
|
|
}
|
|
|
|
/// <summary>
|
|
/// 解除黑名单按钮
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void btnMenuNoTeamBack_Click(object sender, EventArgs e)
|
|
{
|
|
var buttonList = BLL.CommonService.GetAllButtonList(null, this.CurrUser.UserId, BLL.Const.SubPackBlacklistTeamMenuId);
|
|
if (buttonList.Count <= 0 || !buttonList.Contains(BLL.Const.BtnModify))
|
|
{
|
|
Alert.ShowInTop("没有操作此功能权限！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
if (GridTeam.SelectedRowIndexArray.Length == 0)
|
|
{
|
|
Alert.ShowInTop("请至少选择一条记录！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
string id = GridTeam.SelectedRowID.Split(',')[0];
|
|
var item = Funs.DB.SubPack_BranchTeamListTeam.FirstOrDefault(p => p.BranchTeamListTeamId == id);
|
|
if (item == null)
|
|
{
|
|
Alert.ShowInTop("你要解除黑名单的数据在数据库已经不存在了，请重新查询试试！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
if (item.State == "0")
|
|
{
|
|
Alert.ShowInTop("此劳务班组已经解除黑名单，请不要重复操作！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
|
|
|
|
BLL.SubPackBlacklistService.DeleteBackTeam(item.BranchTeamListTeamId);
|
|
Team_BindGrid();
|
|
ShowNotify("解除黑名单，操作成功）", MessageBoxIcon.Success);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 查询按钮事件
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void btnTeamQuery_Click(object sender, EventArgs e)
|
|
{
|
|
Team_BindGrid();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 关闭弹出窗口
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void Window1_Close(object sender, WindowCloseEventArgs e)
|
|
{
|
|
Team_BindGrid();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 把状态转换代号为文字形式
|
|
/// </summary>
|
|
/// <param name="state"></param>
|
|
/// <returns></returns>
|
|
protected string ConvertState(object state)
|
|
{
|
|
if (state != null)
|
|
{
|
|
if (state.ToString() == "0")
|
|
{
|
|
return "正常";
|
|
}
|
|
else if (state.ToString() == "1")
|
|
{
|
|
return "黑名单";
|
|
}
|
|
else
|
|
{
|
|
return "";
|
|
}
|
|
}
|
|
return "";
|
|
}
|
|
|
|
protected void rblState_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
Team_BindGrid();
|
|
}
|
|
}
|
|
} |