/// <summary>
/// 添加安全日常巡检
/// </summary>
/// <param name="checkDay"></param>
public static void AddCheckDay(Model.Check_CheckDayXA checkDay)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_CheckDayXA newCheckDay = new Model.Check_CheckDayXA
{
CheckDayId = checkDay.CheckDayId,
CheckDayCode = checkDay.CheckDayCode,
ProjectId = checkDay.ProjectId,
NotOKNum = checkDay.NotOKNum,
DutyUnitIds = checkDay.DutyUnitIds,
DutyTeamGroupIds = checkDay.DutyTeamGroupIds,
WorkAreaIds = checkDay.WorkAreaIds,
Unqualified = checkDay.Unqualified,
CompileMan = checkDay.CompileMan,
CompileUnit = checkDay.CompileUnit,
CheckDate = checkDay.CheckDate,
HandleStation = checkDay.HandleStation,
IsOK = checkDay.IsOK,
States = checkDay.States
};
db.Check_CheckDayXA.InsertOnSubmit(newCheckDay);
db.SubmitChanges();
////增加一条编码记录
BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectCheckDayXAMenuId, checkDay.ProjectId, null, checkDay.CheckDayId, checkDay.CheckDate);
}
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.rblIsOK.SelectedValue))
{
ShowNotify("请选择是否闭环！", MessageBoxIcon.Warning);
return;
}
Model.Check_CheckDayXA checkDay = BLL.Check_CheckDayXAService.GetCheckDayByCheckDayId(this.CheckDayId);
if (checkDay != null)
{
checkDay.HandleStation = this.txtHandleStation.Text.Trim();
checkDay.IsOK = Convert.ToBoolean(this.rblIsOK.SelectedValue);
BLL.Check_CheckDayXAService.UpdateCheckDay(checkDay);
}
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
/// <summary>
/// 修改安全日常巡检
/// </summary>
/// <param name="checkDay"></param>
public static void UpdateCheckDay(Model.Check_CheckDayXA checkDay)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_CheckDayXA newCheckDay = db.Check_CheckDayXA.FirstOrDefault(e => e.CheckDayId == checkDay.CheckDayId);
if (newCheckDay != null)
{
newCheckDay.CheckDayCode = checkDay.CheckDayCode;
newCheckDay.NotOKNum = checkDay.NotOKNum;
newCheckDay.DutyUnitIds = checkDay.DutyUnitIds;
newCheckDay.DutyTeamGroupIds = checkDay.DutyTeamGroupIds;
newCheckDay.WorkAreaIds = checkDay.WorkAreaIds;
newCheckDay.Unqualified = checkDay.Unqualified;
newCheckDay.CheckDate = checkDay.CheckDate;
newCheckDay.HandleStation = checkDay.HandleStation;
newCheckDay.IsOK = checkDay.IsOK;
newCheckDay.States = checkDay.States;
db.SubmitChanges();
}
}
/// <summary>
/// 获取受检单位/班组
/// </summary>
/// <param name="WorkStage"></param>
/// <returns></returns>
protected string ConvertUnitOrTeamGroup(object CheckDayId)
{
string name = string.Empty;
if (CheckDayId != null)
{
Model.Check_CheckDayXA checkDay = BLL.Check_CheckDayXAService.GetCheckDayByCheckDayId(CheckDayId.ToString());
if (checkDay != null)
{
if (!string.IsNullOrEmpty(checkDay.DutyUnitIds))
{
string[] unitIds = checkDay.DutyUnitIds.Split(',');
foreach (var item in unitIds)
{
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(item);
name += unit.UnitName + ",";
}
if (!string.IsNullOrEmpty(name))
{
name = name.Substring(0, name.LastIndexOf(","));
}
}
if (!string.IsNullOrEmpty(checkDay.DutyTeamGroupIds))
{
string[] teamGroupIds = checkDay.DutyTeamGroupIds.Split(',');
foreach (var item in teamGroupIds)
{
Model.ProjectData_TeamGroup unit = BLL.TeamGroupService.GetTeamGroupById(item);
name += unit.TeamGroupName + ",";
}
if (!string.IsNullOrEmpty(name))
{
name = name.Substring(0, name.LastIndexOf(","));
}
}
}
}
return(name);
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="type"></param>
private void SaveData(string type)
{
Model.Check_CheckDayXA checkDay = new Model.Check_CheckDayXA
{
CheckDayCode = this.txtCheckDayCode.Text.Trim(),
ProjectId = this.ProjectId,
NotOKNum = Funs.GetNewIntOrZero(this.txtNotOKNum.Text.Trim()),
CheckDate = Funs.GetNewDateTimeOrNow(this.txtCheckDate.Text.Trim())
};
if (this.trUnit.Hidden == false)
{
//受检单位
string unitIds = string.Empty;
foreach (var item in this.drpDutyUnitIds.SelectedValueArray)
{
unitIds += item + ",";
}
if (!string.IsNullOrEmpty(unitIds))
{
unitIds = unitIds.Substring(0, unitIds.LastIndexOf(","));
}
checkDay.DutyUnitIds = unitIds;
}
if (this.trTeamGroup.Hidden == false)
{
//受检班组
string teamGroupIds = string.Empty;
foreach (var item in this.drpDutyTeamGroupIds.SelectedValueArray)
{
teamGroupIds += item + ",";
}
if (!string.IsNullOrEmpty(teamGroupIds))
{
teamGroupIds = teamGroupIds.Substring(0, teamGroupIds.LastIndexOf(","));
}
checkDay.DutyTeamGroupIds = teamGroupIds;
}
//检查区域
string workAreaIds = string.Empty;
foreach (var item in this.drpWorkAreaIds.SelectedValueArray)
{
workAreaIds += item + ",";
}
if (!string.IsNullOrEmpty(workAreaIds))
{
workAreaIds = workAreaIds.Substring(0, workAreaIds.LastIndexOf(","));
}
checkDay.WorkAreaIds = workAreaIds;
checkDay.Unqualified = this.txtUnqualified.Text.Trim();
if (this.drpCheckMan.SelectedValue != BLL.Const._Null)
{
checkDay.CompileMan = this.drpCheckMan.SelectedValue;
}
else
{
checkDay.CompileMan = this.CurrUser.UserId;
}
////单据状态
//checkDay.States = BLL.Const.State_0;
//if (type == BLL.Const.BtnSubmit)
//{
// checkDay.States = this.ctlAuditFlow.NextStep;
//}
if (!string.IsNullOrEmpty(this.CheckDayId))
{
checkDay.CheckDayId = this.CheckDayId;
BLL.Check_CheckDayXAService.UpdateCheckDay(checkDay);
BLL.LogService.AddSys_Log(this.CurrUser, checkDay.CheckDayCode, checkDay.CheckDayId, BLL.Const.ProjectCheckDayXAMenuId, BLL.Const.BtnModify);
}
else
{
checkDay.CheckDayId = SQLHelper.GetNewID(typeof(Model.Check_CheckDayXA));
this.CheckDayId = checkDay.CheckDayId;
checkDay.CompileUnit = this.CurrUser.UnitId;
BLL.Check_CheckDayXAService.AddCheckDay(checkDay);
BLL.LogService.AddSys_Log(this.CurrUser, checkDay.CheckDayCode, checkDay.CheckDayId, BLL.Const.ProjectCheckDayXAMenuId, BLL.Const.BtnAdd);
}
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindGrid()
{
string strSql = @"SELECT CheckDay.CheckDayId,CheckDay.ProjectId,CodeRecords.Code AS CheckDayCode,CheckDay.WorkAreaIds,CheckDay.CheckDate,CheckDay.CompileUnit,Users.UserName as CheckPersonName,CheckDay.NotOKNum,CheckDay.Unqualified,CheckDay.HandleStation"
+ @" ,(CASE WHEN CheckDay.States = " + BLL.Const.State_0 + " OR CheckDay.States IS NULL THEN '待['+OperateUser.UserName+']提交' WHEN CheckDay.States = " + BLL.Const.State_2 + " THEN '审核/审批完成' ELSE '待['+OperateUser.UserName+']办理' END) AS FlowOperateName"
+ @" FROM Check_CheckDayXA AS CheckDay "
+ @" LEFT JOIN Sys_FlowOperate AS FlowOperate ON CheckDay.CheckDayId=FlowOperate.DataId AND FlowOperate.IsClosed <> 1"
+ @" LEFT JOIN Sys_User AS OperateUser ON FlowOperate.OperaterId=OperateUser.UserId "
+ @" LEFT JOIN Sys_User AS Users ON CheckDay.CompileMan=Users.UserId "
+ @" LEFT JOIN Sys_CodeRecords AS CodeRecords ON CheckDay.CheckDayId=CodeRecords.DataId WHERE 1=1 ";
List <SqlParameter> listStr = new List <SqlParameter>();
strSql += " AND CheckDay.ProjectId = @ProjectId";
listStr.Add(new SqlParameter("@ProjectId", this.ProjectId));
if (!string.IsNullOrEmpty(this.txtCheckDayCode.Text.Trim()))
{
strSql += " AND CheckDayCode LIKE @CheckDayCode";
listStr.Add(new SqlParameter("@CheckDayCode", "%" + this.txtCheckDayCode.Text.Trim() + "%"));
}
if (BLL.ProjectUnitService.GetProjectUnitTypeByProjectIdUnitId(this.ProjectId, this.CurrUser.UnitId))
{
strSql += " AND CheckDay.CompileUnit = @UnitId"; ///状态为已完成
listStr.Add(new SqlParameter("@UnitId", this.CurrUser.UnitId));
}
//if (!string.IsNullOrEmpty(this.txtUnitName.Text.Trim()))
//{
// strSql += " AND Area LIKE @UnitName";
// listStr.Add(new SqlParameter("@UnitName", "%" + this.txtUnitName.Text.Trim() + "%"));
//}
//if (!string.IsNullOrEmpty(this.txtWorkAreaName.Text.Trim()))
//{
// strSql += " AND Area LIKE @WorkAreaName";
// listStr.Add(new SqlParameter("@WorkAreaName", "%" + this.txtWorkAreaName.Text.Trim() + "%"));
//}
if (this.drpUnit.SelectedValue != BLL.Const._Null)
{
strSql += " AND CheckDay.CompileUnit = @UnitId2";
listStr.Add(new SqlParameter("@UnitId2", this.drpUnit.SelectedValue));
}
SqlParameter[] parameter = listStr.ToArray();
DataTable tb = SQLHelper.GetDataTableRunText(strSql, parameter);
// 2.获取当前分页数据
//var table = this.GetPagedDataTable(Grid1, tb1);
Grid1.RecordCount = tb.Rows.Count;
tb = GetFilteredTable(Grid1.FilteredData, tb);
var table = this.GetPagedDataTable(Grid1, tb);
Grid1.DataSource = table;
Grid1.DataBind();
for (int i = 0; i < Grid1.Rows.Count; i++)
{
Model.Check_CheckDayXA checkHoliday = BLL.Check_CheckDayXAService.GetCheckDayByCheckDayId(this.Grid1.DataKeys[i][0].ToString());
if (checkHoliday != null)
{
if (checkHoliday.IsOK != true)
{
Grid1.Rows[i].RowCssClass = "yellow";
}
}
}
}
