/// <summary>
/// 保存按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
Model.Check_CheckHolidayDetail detail = BLL.Check_CheckHolidayDetailService.GetCheckHolidayDetailByCheckHolidayDetailId(this.CheckHolidayDetailId);
if (detail != null)
{
detail.CheckResult = this.txtCheckResult.Text.Trim();
detail.CheckOpinion = this.txtCheckOpinion.Text.Trim();
detail.HandleResult = this.txtHandleResult.Text.Trim();
detail.CheckStation = this.txtCheckStation.Text.Trim();
detail.CheckContent = this.txtCheckItem.Text.Trim();
BLL.Check_CheckHolidayDetailService.UpdateCheckHolidayDetail(detail);
}
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
/// <summary>
/// 修改季节性/节假日检查明细信息
/// </summary>
/// <param name="CheckHolidayDetail"></param>
public static void UpdateCheckHolidayDetail(Model.Check_CheckHolidayDetail CheckHolidayDetail)
{
Model.SUBHSSEDB db = Funs.DB;
var newCheckHolidayDetail = db.Check_CheckHolidayDetail.FirstOrDefault(x => x.CheckHolidayDetailId == CheckHolidayDetail.CheckHolidayDetailId);
if (newCheckHolidayDetail != null)
{
newCheckHolidayDetail.CheckResult = CheckHolidayDetail.CheckResult;
newCheckHolidayDetail.CheckOpinion = CheckHolidayDetail.CheckOpinion;
newCheckHolidayDetail.CheckStation = CheckHolidayDetail.CheckStation;
newCheckHolidayDetail.HandleResult = CheckHolidayDetail.HandleResult;
newCheckHolidayDetail.CheckContent = CheckHolidayDetail.CheckContent;
newCheckHolidayDetail.WorkArea = CheckHolidayDetail.WorkArea;
db.SubmitChanges();
}
}
/// <summary>
/// 增加季节性/节假日检查明细信息
/// </summary>
/// <param name="CheckHolidayDetail"></param>
public static void AddCheckHolidayDetail(Model.Check_CheckHolidayDetail CheckHolidayDetail)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_CheckHolidayDetail newCheckHolidayDetail = new Model.Check_CheckHolidayDetail
{
CheckHolidayDetailId = CheckHolidayDetail.CheckHolidayDetailId,
CheckHolidayId = CheckHolidayDetail.CheckHolidayId,
CheckItem = CheckHolidayDetail.CheckItem,
CheckResult = CheckHolidayDetail.CheckResult,
CheckOpinion = CheckHolidayDetail.CheckOpinion,
CheckStation = CheckHolidayDetail.CheckStation,
HandleResult = CheckHolidayDetail.HandleResult,
CheckContent = CheckHolidayDetail.CheckContent,
WorkArea = CheckHolidayDetail.WorkArea
};
db.Check_CheckHolidayDetail.InsertOnSubmit(newCheckHolidayDetail);
db.SubmitChanges();
}
/// <summary>
/// Grid1行点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
string checkHolidayDetailId = Grid1.DataKeys[e.RowIndex][0].ToString();
Model.Check_CheckHolidayDetail detail = BLL.Check_CheckHolidayDetailService.GetCheckHolidayDetailByCheckHolidayDetailId(checkHolidayDetailId);
if (e.CommandName == "click")
{
Model.Check_CheckHolidayDetail newDetail = new Model.Check_CheckHolidayDetail
{
CheckHolidayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckHolidayDetail)),
CheckHolidayId = detail.CheckHolidayId,
CheckItem = detail.CheckItem,
CheckContent = detail.CheckContent,
CheckResult = "隐患",
CheckOpinion = "整改"
};
BLL.Check_CheckHolidayDetailService.AddCheckHolidayDetail(newDetail);
checkHolidayDetails = (from x in Funs.DB.View_Check_CheckHolidayDetail where x.CheckHolidayId == this.CheckHolidayId orderby x.CheckItem select x).ToList();
Grid1.DataSource = checkHolidayDetails;
Grid1.DataBind();
ChangeGridColor();
}
}
/// <summary>
/// 确认按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
List <string> newParentIds = new List <string>();
TreeNode[] nodes = this.tvCheckItemSet.GetCheckedNodes();
foreach (var item in nodes)
{
if (item.Nodes.Count == 0)
{
parentIds.Add(item.NodeID); //集合中增加末级节点
if (item.ParentNode != null)
{
newParentIds.Add(item.ParentNode.NodeID); //记录已增加的末级节点的父级节点集合
}
}
}
foreach (var item in nodes)
{
if (item.Nodes.Count > 0)
{
if (!newParentIds.Contains(item.NodeID))
{
parentIds.Add(item.NodeID);
}
}
}
if (parentIds.Count == 0 && list.Count == 0)
{
ShowNotify("请至少选择一项！", MessageBoxIcon.Warning);
return;
}
if (!string.IsNullOrEmpty(Request.Params["CheckDayId"]))
{
foreach (var item in parentIds)
{
Model.Check_CheckDayDetail detail = new Model.Check_CheckDayDetail
{
CheckDayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckDayDetail)),
CheckDayId = Request.Params["CheckDayId"],
CheckItem = item
};
Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (checkItemDetail != null)
{
detail.CheckContent = checkItemDetail.CheckContent;
}
else
{
var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (projectCheckItemDetail != null)
{
detail.CheckContent = projectCheckItemDetail.CheckContent;
}
}
detail.Unqualified = "隐患";
detail.Suggestions = "整改";
detail.CompleteStatus = true;
BLL.Check_CheckDayDetailService.AddCheckDayDetail(detail);
}
}
else if (!string.IsNullOrEmpty(Request.Params["CheckSpecialId"]))
{
foreach (var item in parentIds)
{
Model.Check_CheckSpecialDetail detail = new Model.Check_CheckSpecialDetail
{
CheckSpecialDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckSpecialDetail)),
CheckSpecialId = Request.Params["CheckSpecialId"],
CheckItem = item
};
Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (checkItemDetail != null)
{
detail.CheckContent = checkItemDetail.CheckContent;
}
else
{
var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (projectCheckItemDetail != null)
{
detail.CheckContent = projectCheckItemDetail.CheckContent;
}
}
detail.Unqualified = "隐患";
detail.Suggestions = "整改";
detail.CompleteStatus = true;
BLL.Check_CheckSpecialDetailService.AddCheckSpecialDetail(detail);
}
}
else if (!string.IsNullOrEmpty(Request.Params["CheckColligationId"]))
{
foreach (var item in parentIds)
{
Model.Check_CheckColligationDetail detail = new Model.Check_CheckColligationDetail
{
CheckColligationDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckColligationDetail)),
CheckColligationId = Request.Params["CheckColligationId"],
CheckItem = item
};
Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (checkItemDetail != null)
{
detail.CheckContent = checkItemDetail.CheckContent;
}
else
{
var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (projectCheckItemDetail != null)
{
detail.CheckContent = projectCheckItemDetail.CheckContent;
}
}
detail.Unqualified = "隐患";
detail.Suggestions = "整改";
detail.CompleteStatus = true;
BLL.Check_CheckColligationDetailService.AddCheckColligationDetail(detail);
}
}
else if (!string.IsNullOrEmpty(Request.Params["CheckWorkId"]))
{
foreach (var item in parentIds)
{
Model.Check_CheckWorkDetail detail = new Model.Check_CheckWorkDetail
{
CheckWorkDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckWorkDetail)),
CheckWorkId = Request.Params["CheckWorkId"],
CheckItem = item,
CheckResult = "合格",
};
Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (checkItemDetail != null)
{
detail.CheckContent = checkItemDetail.CheckContent;
detail.SortIndex = checkItemDetail.SortIndex;
}
else
{
var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (projectCheckItemDetail != null)
{
detail.CheckContent = projectCheckItemDetail.CheckContent;
detail.SortIndex = projectCheckItemDetail.SortIndex;
}
}
BLL.Check_CheckWorkDetailService.AddCheckWorkDetail(detail);
}
}
else if (!string.IsNullOrEmpty(Request.Params["CheckHolidayId"]))
{
foreach (var item in parentIds)
{
Model.Check_CheckHolidayDetail detail = new Model.Check_CheckHolidayDetail
{
CheckHolidayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckHolidayDetail)),
CheckHolidayId = Request.Params["CheckHolidayId"],
CheckItem = item,
CheckResult = "合格",
};
Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (checkItemDetail != null)
{
detail.CheckContent = checkItemDetail.CheckContent;
}
else
{
var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (projectCheckItemDetail != null)
{
detail.CheckContent = projectCheckItemDetail.CheckContent;
}
}
BLL.Check_CheckHolidayDetailService.AddCheckHolidayDetail(detail);
}
}
if (!string.IsNullOrEmpty(Request.Params["CheckDayId"]))
{
foreach (var item in list)
{
Model.Check_CheckDayDetail detail = new Model.Check_CheckDayDetail
{
CheckDayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckDayDetail)),
CheckDayId = Request.Params["CheckDayId"],
CheckItem = item
};
Model.Check_ProjectCheckItemSet checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item);
if (checkItemSet != null)
{
detail.CheckContent = checkItemSet.CheckItemName;
}
else
{
var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (projectCheckItemDetail != null)
{
detail.CheckContent = projectCheckItemDetail.CheckContent;
}
}
detail.Unqualified = "隐患";
detail.Suggestions = "整改";
detail.CompleteStatus = true;
BLL.Check_CheckDayDetailService.AddCheckDayDetail(detail);
}
}
else if (!string.IsNullOrEmpty(Request.Params["CheckSpecialId"]))
{
foreach (var item in list)
{
Model.Check_CheckSpecialDetail detail = new Model.Check_CheckSpecialDetail
{
CheckSpecialDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckSpecialDetail)),
CheckSpecialId = Request.Params["CheckSpecialId"],
CheckItem = item
};
Model.Check_ProjectCheckItemSet checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item);
if (checkItemSet != null)
{
detail.CheckContent = checkItemSet.CheckItemName;
}
else
{
var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (projectCheckItemDetail != null)
{
detail.CheckContent = projectCheckItemDetail.CheckContent;
}
}
detail.Unqualified = "隐患";
detail.Suggestions = "整改";
detail.CompleteStatus = true;
BLL.Check_CheckSpecialDetailService.AddCheckSpecialDetail(detail);
}
}
else if (!string.IsNullOrEmpty(Request.Params["CheckColligationId"]))
{
foreach (var item in list)
{
Model.Check_CheckColligationDetail detail = new Model.Check_CheckColligationDetail
{
CheckColligationDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckColligationDetail)),
CheckColligationId = Request.Params["CheckColligationId"],
CheckItem = item
};
Model.Check_ProjectCheckItemSet checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item);
if (checkItemSet != null)
{
detail.CheckContent = checkItemSet.CheckItemName;
}
else
{
var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (projectCheckItemDetail != null)
{
detail.CheckContent = projectCheckItemDetail.CheckContent;
}
}
detail.Unqualified = "隐患";
detail.Suggestions = "整改";
detail.CompleteStatus = true;
BLL.Check_CheckColligationDetailService.AddCheckColligationDetail(detail);
}
}
else if (!string.IsNullOrEmpty(Request.Params["CheckWorkId"]))
{
foreach (var item in list)
{
Model.Check_CheckWorkDetail detail = new Model.Check_CheckWorkDetail
{
CheckWorkDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckWorkDetail)),
CheckWorkId = Request.Params["CheckWorkId"],
CheckItem = item
};
var checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item);
if (checkItemSet != null)
{
detail.CheckContent = checkItemSet.CheckItemName;
}
else
{
var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item);
if (projectCheckItemDetail != null)
{
detail.CheckContent = projectCheckItemDetail.CheckContent;
}
}
detail.CheckResult = "合格";
detail.CheckOpinion = "整改";
BLL.Check_CheckWorkDetailService.AddCheckWorkDetail(detail);
}
}
else if (!string.IsNullOrEmpty(Request.Params["CheckHolidayId"]))
{
foreach (var item in list)
{
Model.Check_CheckHolidayDetail detail = new Model.Check_CheckHolidayDetail
{
CheckHolidayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckHolidayDetail)),
CheckHolidayId = Request.Params["CheckHolidayId"],
CheckItem = item
};
Model.Check_ProjectCheckItemSet checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item);
if (checkItemSet != null)
{
detail.CheckContent = checkItemSet.CheckItemName;
}
detail.CheckResult = "合格";
detail.CheckOpinion = "整改";
BLL.Check_CheckHolidayDetailService.AddCheckHolidayDetail(detail);
}
}
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
/// <summary>
/// 将Dataset的数据导入数据库
/// </summary>
/// <param name="pds">数据集</param>
/// <param name="Cols">数据集行数</param>
/// <returns></returns>
private bool AddDatasetToSQL(DataTable pds)
{
string results = string.Empty;
int ir = pds.Rows.Count;
if (pds != null && ir > 0)
{
var getCheckHoliday = BLL.Check_CheckHolidayService.GetCheckHolidayByCheckHolidayId(this.CheckHolidayId);
if (getCheckHoliday != null)
{
var units = from x in Funs.DB.Base_Unit select x;
var sysConsts = from x in Funs.DB.Sys_Const
where x.GroupId == BLL.ConstValue.Group_HandleStep
select x;
var supCheckSets = from x in Funs.DB.Check_ProjectCheckItemSet
where x.ProjectId == this.CurrUser.LoginProjectId && x.SupCheckItem == "0" && x.CheckType == "5"
select x;
for (int i = 0; i < ir; i++)
{
string result = string.Empty;
string col0 = pds.Rows[i][0].ToString().Trim();
string col1 = pds.Rows[i][1].ToString().Trim();
string col2 = pds.Rows[i][2].ToString().Trim();
string col3 = pds.Rows[i][3].ToString().Trim();
string col4 = pds.Rows[i][4].ToString().Trim();
string col5 = pds.Rows[i][5].ToString().Trim();
if (!string.IsNullOrEmpty(col0) || !string.IsNullOrEmpty(col1))
{
Model.View_Check_CheckHolidayDetail newViewDetail = new Model.View_Check_CheckHolidayDetail
{
CheckHolidayDetailId = SQLHelper.GetNewID(typeof(Model.View_EduTrain_TrainRecordDetail)),
CheckHolidayId = getCheckHoliday.CheckHolidayId,
CheckContent = col1,
CheckResult = col2,
CheckOpinion = col3,
HandleResult = col4,
CheckStation = col5,
};
var checkName = supCheckSets.FirstOrDefault(x => x.CheckItemName == col0);
if (checkName != null)
{
newViewDetail.CheckItem = checkName.CheckItemSetId;
newViewDetail.CheckItemStr = checkName.CheckItemName;
}
else
{
result += "第" + (i + 2).ToString() + "行," + "项目检查项中不存在！" + "|";
}
///判断是否已存在
var addItem = Funs.DB.Check_CheckHolidayDetail.FirstOrDefault(x => x.CheckHolidayId == newViewDetail.CheckHolidayId && x.CheckContent == newViewDetail.CheckContent &&
x.CheckItem == newViewDetail.CheckItem);
if (addItem == null)
{
if (string.IsNullOrEmpty(result))
{
Model.Check_CheckHolidayDetail newDetail = new Model.Check_CheckHolidayDetail
{
CheckHolidayDetailId = newViewDetail.CheckHolidayDetailId,
CheckHolidayId = newViewDetail.CheckHolidayId,
CheckItem = newViewDetail.CheckItem,
CheckContent = newViewDetail.CheckContent,
CheckResult = newViewDetail.CheckResult,
CheckOpinion = newViewDetail.CheckOpinion,
CheckStation = newViewDetail.CheckStation,
HandleResult = newViewDetail.HandleResult,
};
BLL.Check_CheckHolidayDetailService.AddCheckHolidayDetail(newDetail);
///加入
viewDetails.Add(newViewDetail);
}
}
else
{
result += "第" + (i + 2).ToString() + "行," + "导入数据重复" + "|";
}
if (!string.IsNullOrEmpty(result))
{
results += result;
}
}
}
if (viewDetails.Count > 0)
{
viewDetails = viewDetails.Distinct().ToList();
this.Grid1.Hidden = false;
this.Grid1.DataSource = viewDetails;
this.Grid1.DataBind();
}
if (!string.IsNullOrEmpty(results))
{
viewDetails.Clear();
results = "数据导入完成，未成功数据：" + results.Substring(0, results.LastIndexOf("|"));
errorInfos = results;
Alert alert = new Alert
{
Message = results,
Target = Target.Self
};
alert.Show();
}
else
{
errorInfos = string.Empty;
ShowNotify("导入成功！", MessageBoxIcon.Success);
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
}
else
{
Alert.ShowInTop("培训数据为空！", MessageBoxIcon.Warning);
}
}
else
{
Alert.ShowInTop("导入数据为空！", MessageBoxIcon.Warning);
}
BLL.UploadFileService.DeleteFile(Funs.RootPath, initPath + this.hdFileName.Text);
return(true);
}
