/// <summary>
/// 根据主键删除项目检查项
/// </summary>
/// <param name="checkItemSetId"></param>
public static void DeleteCheckItemSet(string checkItemSetId, string projectId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_ProjectCheckItemSet checkItemSet = db.Check_ProjectCheckItemSet.FirstOrDefault(e => e.CheckItemSetId == checkItemSetId && e.ProjectId == projectId);
if (checkItemSet != null)
{
db.Check_ProjectCheckItemSet.DeleteOnSubmit(checkItemSet);
db.SubmitChanges();
}
}
/// <summary>
/// 是否末级
/// </summary>
/// <param name="checkItemSetId">项目检查项目主键</param>
/// <returns>布尔值</returns>
public static bool IsEndLevel(string checkItemSetId)
{
if (checkItemSetId == "0")
{
return(false);
}
else
{
Model.Check_ProjectCheckItemSet checkItemSet = Funs.DB.Check_ProjectCheckItemSet.FirstOrDefault(e => e.CheckItemSetId == checkItemSetId);
return(Convert.ToBoolean(checkItemSet.IsEndLever));
}
}
/// <summary>
/// 修改项目检查项
/// </summary>
/// <param name="checkItemSet"></param>
public static void UpdateCheckItemSet(Model.Check_ProjectCheckItemSet checkItemSet)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_ProjectCheckItemSet newCheckItemSet = db.Check_ProjectCheckItemSet.FirstOrDefault(e => e.CheckItemSetId == checkItemSet.CheckItemSetId);
if (newCheckItemSet != null)
{
newCheckItemSet.CheckItemName = checkItemSet.CheckItemName;
newCheckItemSet.SupCheckItem = checkItemSet.SupCheckItem;
newCheckItemSet.MapCode = checkItemSet.MapCode;
newCheckItemSet.IsEndLever = checkItemSet.IsEndLever;
newCheckItemSet.SortIndex = checkItemSet.SortIndex;
db.SubmitChanges();
}
}
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string staName = this.txtCheckItemName.Text.Trim();
if (!string.IsNullOrEmpty(staName))
{
if (!BLL.Check_ProjectCheckItemSetService.IsExistCheckItemName(this.ProjectId, this.Type, this.CheckItemSetId, this.SupCheckItem, staName))
{
Model.Check_ProjectCheckItemSet checkItemSet = new Model.Check_ProjectCheckItemSet
{
CheckItemName = staName,
SupCheckItem = this.SupCheckItem,
MapCode = this.txtMapCode.Text.Trim(),
SortIndex = Funs.GetNewIntOrZero(this.txtSortIndex.Text.Trim()),
IsEndLever = Convert.ToBoolean(this.chkIsEndLevel.Checked),
CheckType = Request.Params["checkType"]
};
if (string.IsNullOrEmpty(this.CheckItemSetId))
{
checkItemSet.CheckItemSetId = SQLHelper.GetNewID(typeof(Model.Check_ProjectCheckItemSet));
checkItemSet.ProjectId = this.CurrUser.LoginProjectId;
BLL.Check_ProjectCheckItemSetService.AddCheckItemSet(checkItemSet);
BLL.LogService.AddSys_Log(this.CurrUser, checkItemSet.MapCode, checkItemSet.CheckItemSetId, BLL.Const.ProjectCheckItemSetMenuId, BLL.Const.BtnAdd);
}
else
{
checkItemSet.CheckItemSetId = this.CheckItemSetId;
BLL.Check_ProjectCheckItemSetService.UpdateCheckItemSet(checkItemSet);
BLL.LogService.AddSys_Log(this.CurrUser, checkItemSet.MapCode, checkItemSet.CheckItemSetId, BLL.Const.ProjectCheckItemSetMenuId, BLL.Const.BtnModify);
}
}
else
{
Alert.ShowInTop("检查项目名称已存在！", MessageBoxIcon.Warning);
return;
}
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
else
{
Alert.ShowInTop("检查项目名称不能为空！", MessageBoxIcon.Warning);
return;
}
}
/// <summary>
/// 根据主键获取顶级检查项名称
/// </summary>
/// <param name="checkItemSetId"></param>
/// <returns></returns>
public static string GetCheckItemNameBySupCheckItem(string supCheckItem)
{
string name = string.Empty;
Model.Check_ProjectCheckItemSet checkItemSet = Funs.DB.Check_ProjectCheckItemSet.FirstOrDefault(e => e.CheckItemSetId == supCheckItem);
if (checkItemSet != null)
{
if (checkItemSet.SupCheckItem == "0")
{
name = checkItemSet.CheckItemName;
}
else
{
name = GetCheckItemNameBySupCheckItem(checkItemSet.SupCheckItem);
}
}
return(name);
}
/// <summary>
/// 添加项目检查项
/// </summary>
/// <param name="checkItemSet"></param>
public static void AddCheckItemSet(Model.Check_ProjectCheckItemSet checkItemSet)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_ProjectCheckItemSet newCheckItemSet = new Model.Check_ProjectCheckItemSet
{
CheckItemSetId = checkItemSet.CheckItemSetId,
ProjectId = checkItemSet.ProjectId,
CheckItemName = checkItemSet.CheckItemName,
SupCheckItem = checkItemSet.SupCheckItem,
CheckType = checkItemSet.CheckType,
MapCode = checkItemSet.MapCode,
IsEndLever = checkItemSet.IsEndLever,
SortIndex = checkItemSet.SortIndex,
IsBuiltIn = checkItemSet.IsBuiltIn
};
db.Check_ProjectCheckItemSet.InsertOnSubmit(newCheckItemSet);
db.SubmitChanges();
}
/// <summary>
/// 获取一级节点检查类型
/// </summary>
/// <param name="CheckItem"></param>
/// <returns></returns>
public static string ConvertCheckItemType(object CheckItem)
{
string type = string.Empty;
if (CheckItem != null)
{
Model.Check_ProjectCheckItemDetail detail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(CheckItem.ToString());
if (detail != null)
{
Model.Check_ProjectCheckItemSet item = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(detail.CheckItemSetId);
if (item != null)
{
if (item.SupCheckItem == "0")
{
type = item.CheckItemName;
}
else
{
type = BLL.Check_ProjectCheckItemSetService.GetCheckItemNameBySupCheckItem(item.SupCheckItem);
}
}
}
else
{
Model.Check_ProjectCheckItemSet item = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(CheckItem.ToString());
if (item != null)
{
if (item.SupCheckItem == "0")
{
type = item.CheckItemName;
}
else
{
type = BLL.Check_ProjectCheckItemSetService.GetCheckItemNameBySupCheckItem(item.SupCheckItem);
}
}
}
}
return(type);
}
/// <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>
/// 提取方法
/// </summary>
/// <param name="supCheckItem"></param>
private void InsertProjectCheckItemSet(string supCheckItem, string checkType)
{
var checkItems = from x in Funs.DB.Technique_CheckItemSet where x.SupCheckItem == supCheckItem && x.CheckType == checkType orderby x.SortIndex select x;
if (checkItems.Count() > 0)
{
foreach (var item in checkItems)
{
Model.Check_ProjectCheckItemSet checkItemSet = new Model.Check_ProjectCheckItemSet
{
CheckItemSetId = SQLHelper.GetNewID(typeof(Model.Check_ProjectCheckItemSet)),
ProjectId = this.ProjectId,
CheckItemName = item.CheckItemName
};
//获取项目表中对应上级检查项的Id
if (item.SupCheckItem != "0")
{
var cpItemSet = Funs.DB.Check_ProjectCheckItemSet.FirstOrDefault(x => x.OldCheckItemSetId == item.SupCheckItem && x.ProjectId == this.ProjectId);
if (cpItemSet != null)
{
checkItemSet.SupCheckItem = cpItemSet.CheckItemSetId;
}
else
{
checkItemSet.SupCheckItem = null;
}
}
else //根级检查项
{
checkItemSet.SupCheckItem = "0";
}
checkItemSet.CheckType = item.CheckType;
checkItemSet.MapCode = item.MapCode;
checkItemSet.IsEndLever = item.IsEndLever;
checkItemSet.SortIndex = item.SortIndex;
checkItemSet.IsBuiltIn = item.IsBuiltIn;
checkItemSet.OldCheckItemSetId = item.CheckItemSetId;
Funs.DB.Check_ProjectCheckItemSet.InsertOnSubmit(checkItemSet);
Funs.DB.SubmitChanges();
///如果是末级菜单则查找明细表
if (checkItemSet.IsEndLever == true)
{
var details = from x in Funs.DB.Technique_CheckItemDetail where x.CheckItemSetId == item.CheckItemSetId select x;
foreach (var d in details)
{
Model.Check_ProjectCheckItemDetail detail = new Model.Check_ProjectCheckItemDetail
{
CheckItemDetailId = SQLHelper.GetNewID(typeof(Model.Check_ProjectCheckItemDetail)),
CheckItemSetId = checkItemSet.CheckItemSetId,
CheckContent = d.CheckContent,
SortIndex = d.SortIndex,
IsBuiltIn = d.IsBuiltIn
};
Funs.DB.Check_ProjectCheckItemDetail.InsertOnSubmit(detail);
Funs.DB.SubmitChanges();
}
}
else
{
InsertProjectCheckItemSet(checkItemSet.OldCheckItemSetId, checkType);
}
}
}
}
