/// <summary>
/// 添加安全季节性/节假日检查
/// </summary>
/// <param name="checkHoliday"></param>
public static void AddCheckHoliday(Model.Check_CheckHoliday checkHoliday)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_CheckHoliday newCheckHoliday = new Model.Check_CheckHoliday
{
CheckHolidayId = checkHoliday.CheckHolidayId,
CheckHolidayCode = checkHoliday.CheckHolidayCode,
ProjectId = checkHoliday.ProjectId,
Area = checkHoliday.Area,
CheckTime = checkHoliday.CheckTime,
ThisUnitId = checkHoliday.ThisUnitId,
MainUnitPerson = checkHoliday.MainUnitPerson,
SubUnits = checkHoliday.SubUnits,
SubUnitPerson = checkHoliday.SubUnitPerson,
PartInPersonNames = checkHoliday.PartInPersonNames,
MainUnitDeputy = checkHoliday.MainUnitDeputy,
SubUnitDeputy = checkHoliday.SubUnitDeputy,
MainUnitDeputyDate = checkHoliday.MainUnitDeputyDate,
SubUnitDeputyDate = checkHoliday.SubUnitDeputyDate,
AttachUrl = checkHoliday.AttachUrl,
IsCompleted = checkHoliday.IsCompleted,
States = checkHoliday.States,
CompileMan = checkHoliday.CompileMan
};
db.Check_CheckHoliday.InsertOnSubmit(newCheckHoliday);
db.SubmitChanges();
////增加一条编码记录
BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectCheckHolidayMenuId, checkHoliday.ProjectId, null, checkHoliday.CheckHolidayId, checkHoliday.CheckTime);
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindGrid()
{
string strSql = @"SELECT CheckHoliday.CheckHolidayId,CheckHoliday.ProjectId,CodeRecords.Code AS CheckHolidayCode,Unit.UnitId,CheckHoliday.Area,CheckHoliday.CheckTime,CheckHoliday.Evaluate"
+ @" ,(CASE WHEN CheckHoliday.States = " + BLL.Const.State_0 + " OR CheckHoliday.States IS NULL THEN '待['+OperateUser.UserName+']提交' WHEN CheckHoliday.States = " + BLL.Const.State_2 + " THEN '审核/审批完成' ELSE '待['+OperateUser.UserName+']办理' END) AS FlowOperateName"
+ @" FROM Check_CheckHoliday AS CheckHoliday "
+ @" LEFT JOIN Sys_FlowOperate AS FlowOperate ON CheckHoliday.CheckHolidayId=FlowOperate.DataId AND FlowOperate.IsClosed <> 1"
+ @" LEFT JOIN Sys_User AS OperateUser ON FlowOperate.OperaterId=OperateUser.UserId "
+ @" LEFT JOIN Sys_User AS Users ON CheckHoliday.CompileMan=Users.UserId "
+ @" LEFT JOIN Base_Unit AS Unit ON Unit.UnitId=Users.UnitId "
+ @" LEFT JOIN Sys_CodeRecords AS CodeRecords ON CheckHoliday.CheckHolidayId=CodeRecords.DataId WHERE 1=1 ";
List <SqlParameter> listStr = new List <SqlParameter>();
strSql += " AND CheckHoliday.ProjectId = @ProjectId";
listStr.Add(new SqlParameter("@ProjectId", this.ProjectId));
if (!string.IsNullOrEmpty(this.txtCheckHolidayCode.Text.Trim()))
{
strSql += " AND CheckHolidayCode LIKE @CheckHolidayCode";
listStr.Add(new SqlParameter("@CheckHolidayCode", "%" + this.txtCheckHolidayCode.Text.Trim() + "%"));
}
if (this.drpUnitId.SelectedValue != BLL.Const._Null)
{
strSql += " AND Unit.UnitId = @UnitId";
listStr.Add(new SqlParameter("@UnitId", this.drpUnitId.SelectedValue.Trim()));
}
if (!string.IsNullOrEmpty(this.txtWorkAreaName.Text.Trim()))
{
strSql += " AND Area LIKE @HolidayAreaName";
listStr.Add(new SqlParameter("@HolidayAreaName", "%" + this.txtWorkAreaName.Text.Trim() + "%"));
}
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_CheckHoliday checkHoliday = BLL.Check_CheckHolidayService.GetCheckHolidayByCheckHolidayId(this.Grid1.DataKeys[i][0].ToString());
if (checkHoliday != null)
{
if (checkHoliday.IsCompleted != true)
{
Grid1.Rows[i].RowCssClass = "yellow";
}
}
}
}
/// <summary>
/// 修改安全季节性/节假日检查
/// </summary>
/// <param name="checkHoliday"></param>
public static void UpdateCheckHoliday(Model.Check_CheckHoliday checkHoliday)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_CheckHoliday newCheckHoliday = db.Check_CheckHoliday.FirstOrDefault(e => e.CheckHolidayId == checkHoliday.CheckHolidayId);
if (newCheckHoliday != null)
{
newCheckHoliday.Area = checkHoliday.Area;
newCheckHoliday.CheckTime = checkHoliday.CheckTime;
newCheckHoliday.ThisUnitId = checkHoliday.ThisUnitId;
newCheckHoliday.MainUnitPerson = checkHoliday.MainUnitPerson;
newCheckHoliday.SubUnits = checkHoliday.SubUnits;
newCheckHoliday.SubUnitPerson = checkHoliday.SubUnitPerson;
newCheckHoliday.PartInPersonNames = checkHoliday.PartInPersonNames;
newCheckHoliday.MainUnitDeputy = checkHoliday.MainUnitDeputy;
newCheckHoliday.SubUnitDeputy = checkHoliday.SubUnitDeputy;
newCheckHoliday.MainUnitDeputyDate = checkHoliday.MainUnitDeputyDate;
newCheckHoliday.SubUnitDeputyDate = checkHoliday.SubUnitDeputyDate;
newCheckHoliday.AttachUrl = checkHoliday.AttachUrl;
newCheckHoliday.IsCompleted = checkHoliday.IsCompleted;
newCheckHoliday.States = checkHoliday.States;
db.SubmitChanges();
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="type"></param>
private void SaveData(string type)
{
Model.Check_CheckHoliday checkHoliday = new Model.Check_CheckHoliday
{
CheckHolidayCode = this.txtCheckHolidayCode.Text.Trim(),
CheckTime = Funs.GetNewDateTime(this.txtCheckDate.Text.Trim()),
ProjectId = this.ProjectId,
Area = this.txtArea.Text.Trim(),
Evaluate = this.drpEvaluate.SelectedValue
};
if (!string.IsNullOrEmpty(this.drpThisUnit.SelectedValue))
{
checkHoliday.ThisUnitId = this.drpThisUnit.SelectedValue;
}
//本单位人员
string mainUnitPerson = string.Empty;
foreach (var item in this.drpMainUnitPerson.SelectedValueArray)
{
mainUnitPerson += item + ",";
}
if (!string.IsNullOrEmpty(mainUnitPerson))
{
mainUnitPerson = mainUnitPerson.Substring(0, mainUnitPerson.LastIndexOf(","));
}
checkHoliday.MainUnitPerson = mainUnitPerson;
//参与单位
string subUnits = string.Empty;
foreach (var item in this.drpSubUnits.SelectedValueArray)
{
subUnits += item + ",";
}
if (!string.IsNullOrEmpty(subUnits))
{
checkHoliday.SubUnits = subUnits.Substring(0, subUnits.LastIndexOf(","));
}
//参与用户
string subUnitPerson = string.Empty;
foreach (var item in this.drpSubUnitPerson.SelectedValueArray)
{
if (item != BLL.Const._Null)
{
subUnitPerson += item + ",";
}
}
if (!string.IsNullOrEmpty(subUnitPerson))
{
checkHoliday.SubUnitPerson = subUnitPerson.Substring(0, subUnitPerson.LastIndexOf(","));
}
checkHoliday.PartInPersonNames = this.txtPartInPersonNames.Text.Trim();
//if (this.ckbIsCompleted.Checked)
//{
// checkHoliday.IsCompleted = true;
//}
checkHoliday.MainUnitDeputy = this.txtMainUnitDeputy.Text.Trim();
checkHoliday.MainUnitDeputyDate = Funs.GetNewDateTime(this.txtMainUnitDeputyDate.Text.Trim());
checkHoliday.SubUnitDeputy = this.txtSubUnitDeputy.Text.Trim();
checkHoliday.SubUnitDeputyDate = Funs.GetNewDateTime(this.txtSubUnitDeputyDate.Text.Trim());
////单据状态
checkHoliday.States = BLL.Const.State_0;
if (type == BLL.Const.BtnSubmit)
{
checkHoliday.States = this.ctlAuditFlow.NextStep;
}
if (!string.IsNullOrEmpty(this.CheckHolidayId))
{
checkHoliday.CheckHolidayId = this.CheckHolidayId;
BLL.Check_CheckHolidayService.UpdateCheckHoliday(checkHoliday);
BLL.LogService.AddSys_Log(this.CurrUser, checkHoliday.CheckHolidayCode, checkHoliday.CheckHolidayId, BLL.Const.ProjectCheckHolidayMenuId, BLL.Const.BtnModify);
}
else
{
checkHoliday.CheckHolidayId = SQLHelper.GetNewID(typeof(Model.Check_CheckHoliday));
this.CheckHolidayId = checkHoliday.CheckHolidayId;
checkHoliday.CompileMan = this.CurrUser.UserId;
BLL.Check_CheckHolidayService.AddCheckHoliday(checkHoliday);
BLL.LogService.AddSys_Log(this.CurrUser, checkHoliday.CheckHolidayCode, checkHoliday.CheckHolidayId, BLL.Const.ProjectCheckHolidayMenuId, BLL.Const.BtnAdd);
}
////保存流程审核数据
this.ctlAuditFlow.btnSaveData(this.ProjectId, BLL.Const.ProjectCheckHolidayMenuId, this.CheckHolidayId, (type == BLL.Const.BtnSubmit ? true : false), checkHoliday.Area, "../Check/CheckHolidayView.aspx?CheckHolidayId={0}");
}