/// <summary>
/// 添加单位信息
/// </summary>
/// <param name="unit"></param>
public static void AddUnit(Model.Base_Unit unit)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Base_Unit newUnit = new Model.Base_Unit
{
UnitId = unit.UnitId,
UnitCode = unit.UnitCode,
UnitName = unit.UnitName,
UnitTypeId = unit.UnitTypeId,
Corporate = unit.Corporate,
Address = unit.Address,
Telephone = unit.Telephone,
Fax = unit.Fax,
EMail = unit.EMail,
ProjectRange = unit.ProjectRange,
IsThisUnit = unit.IsThisUnit,
IsBranch = unit.IsBranch,
IsHide = false,
DataSources = unit.DataSources,
FromUnitId = unit.FromUnitId,
SupUnitId = unit.SupUnitId,
};
db.Base_Unit.InsertOnSubmit(newUnit);
db.SubmitChanges();
}
/// <summary>
/// 根据单位ID删除单位信息
/// </summary>
/// <param name="unitId"></param>
public static void DeleteUnitById(string unitId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Base_Unit newUnit = db.Base_Unit.FirstOrDefault(e => e.UnitId == unitId);
if (newUnit != null)
{
newUnit.IsHide = true;
UpdateUnit(newUnit);
}
}
/// <summary>
/// 根据用户UnitId返回对应的UnitId
/// </summary>
/// <returns></returns>
public static string GetUnitId(string unitId)
{
string id = unitId;
if (string.IsNullOrEmpty(unitId))
{
Model.Base_Unit unit = Funs.DB.Base_Unit.FirstOrDefault(e => e.IsThisUnit == true); //本单位
if (unit != null)
{
id = unit.UnitId;
}
}
return(id);
}
/// <summary>
/// 根据用户UnitId判断是否为本单位用户或管理员
/// </summary>
/// <returns></returns>
public static bool IsMainUnitOrAdmin(string userId)
{
bool result = false;
if (userId == Const.sysglyId || userId == Const.hfnbdId || userId == Const.sedinId)
{
result = true;
}
else
{
var user = UserService.GetUserByUserId(userId);
if (user != null)
{
Model.Base_Unit unit = UnitService.GetUnitByUnitId(user.UnitId);
if (unit != null && unit.IsThisUnit == true)
{
result = true;
}
}
}
return(result);
}
/// <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="unit"></param>
public static void UpdateUnit(Model.Base_Unit unit)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Base_Unit newUnit = db.Base_Unit.FirstOrDefault(e => e.UnitId == unit.UnitId);
if (newUnit != null)
{
newUnit.UnitCode = unit.UnitCode;
newUnit.UnitName = unit.UnitName;
newUnit.UnitTypeId = unit.UnitTypeId;
newUnit.Corporate = unit.Corporate;
newUnit.Address = unit.Address;
newUnit.Telephone = unit.Telephone;
newUnit.Fax = unit.Fax;
newUnit.EMail = unit.EMail;
newUnit.ProjectRange = unit.ProjectRange;
newUnit.IsThisUnit = unit.IsThisUnit;
newUnit.IsBranch = unit.IsBranch;
newUnit.IsHide = unit.IsHide;
newUnit.FromUnitId = unit.FromUnitId;
newUnit.SupUnitId = unit.SupUnitId;
db.SubmitChanges();
}
}
/// <summary>
/// 单位下拉选择项（添加其他单位）
/// </summary>
/// <param name="dropName"></param>
/// <param name="projectId"></param>
/// <param name="isShowPlease"></param>
public static void InitUnitOtherDropDownList(FineUIPro.DropDownList dropName, string projectId, bool isShowPlease)
{
dropName.DataValueField = "UnitId";
dropName.DataTextField = "UnitName";
List <Model.Base_Unit> units = new List <Model.Base_Unit>();
units.AddRange(BLL.UnitService.GetUnitListByProjectId(projectId));
Model.Base_Unit other = new Model.Base_Unit
{
UnitName = "其他",
UnitId = "0"
};
units.Add(other);
dropName.DataSource = units;
dropName.DataBind();
if (isShowPlease)
{
Funs.FineUIPleaseSelect(dropName);
}
}
/// <summary>
/// 加载页面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.CheckSpecialId = Request.Params["CheckSpecialId"];
var checkSpecial = BLL.Check_CheckSpecialService.GetCheckSpecialByCheckSpecialId(this.CheckSpecialId);
if (checkSpecial != null)
{
this.txtCheckTime.Text = "检查时间：";
if (checkSpecial.CheckTime != null)
{
this.txtCheckTime.Text += string.Format("{0:yyyy-MM-dd}", checkSpecial.CheckTime);
}
string personStr = "检查人：";
Model.Sys_User user = BLL.UserService.GetUserByUserId(checkSpecial.CheckPerson);
if (user != null)
{
personStr += user.UserName + "、";
}
if (!string.IsNullOrEmpty(checkSpecial.PartInPersonIds))
{
string[] strs = checkSpecial.PartInPersonIds.Split(',');
foreach (var s in strs)
{
Model.Sys_User checkPerson = BLL.UserService.GetUserByUserId(s);
if (checkPerson != null)
{
personStr += checkPerson.UserName + "、";
}
}
}
if (!string.IsNullOrEmpty(personStr))
{
personStr = personStr.Substring(0, personStr.LastIndexOf("、"));
}
if (!string.IsNullOrEmpty(checkSpecial.PartInPersonNames))
{
if (personStr != "检查人：")
{
personStr += "、" + checkSpecial.PartInPersonNames;
}
else
{
personStr += checkSpecial.PartInPersonNames;
}
}
this.txtCheckPerson.Text = personStr;
this.txtCheckType.Text = "检查项目：";
if (checkSpecial.CheckType == "0")
{
this.txtCheckType.Text += "周检";
}
else if (checkSpecial.CheckType == "1")
{
this.txtCheckType.Text += "月检";
}
else if (checkSpecial.CheckType == "2")
{
this.txtCheckType.Text += "其它";
}
var checkSpecialDetails = BLL.Check_CheckSpecialDetailService.GetCheckSpecialDetailByCheckSpecialId(this.CheckSpecialId);
int i = 1;
string str = "<table id='Table3' runat='server' width='100%' cellpadding='0' cellspacing='0' border='0' frame='vsides' bordercolor='#000000'>"
+ "<tr><td align='center' style='width:5%; border: 1px solid #000000; font-size:15px; border-right: none;'>序号</td>"
+ "<td align='center' style='width:30%; border: 1px solid #000000; font-size:15px; border-right: none;'>隐患照片或描述</td>"
+ "<td align='center' style='width:20%; border: 1px solid #000000; font-size:15px; border-right: none;'>整改措施</td>"
+ "<td align='center' style='width:8%; border: 1px solid #000000; font-size:15px; border-right: none;'>整改责任人</td>"
+ "<td align='center' style='width:7%; border: 1px solid #000000; font-size:15px; border-right: none;'>整改时间</td>"
+ "<td align='center' style='width:10%; border: 1px solid #000000; font-size:15px; border-right: none;'>责任单位</td>"
+ "<td align='center' style='width:7%; border: 1px solid #000000; font-size:15px; border-right: none;'>复检人</td>"
+ "<td align='center' style='width:7%; border: 1px solid #000000; font-size:15px; border-right: none;'>复检时间</td>"
+ "<td align='center' style='width:7%; border: 1px solid #000000; font-size:15px; '>复检结果</td></tr>";
foreach (var checkSpecialDetail in checkSpecialDetails)
{
string photo1 = string.Empty;
string photo2 = string.Empty;
Model.AttachFile attachFile = BLL.AttachFileService.GetAttachFile(checkSpecialDetail.CheckSpecialDetailId, BLL.Const.ProjectCheckSpecialMenuId);
if (attachFile != null)
{
List <string> urls = new List <string>();
string[] lists = attachFile.AttachUrl.Split(',');
foreach (var list in lists)
{
if (!string.IsNullOrEmpty(list))
{
urls.Add(list);
}
}
if (urls.Count > 1) //两个附件
{
photo1 = "<img alt='' runat='server' id='img111' width='180' height='180' src='" + "../" + urls[0] + "' />";
photo2 = "<img alt='' runat='server' id='img111' width='180' height='180' src='" + "../" + urls[1] + "' />";
}
else
{
photo1 = "<img alt='' runat='server' id='img111' width='180' height='180' src='" + "../" + urls[0] + "' />";
}
}
string unitName = string.Empty;
string completedDate = string.Empty;
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(checkSpecialDetail.UnitId);
if (unit != null)
{
unitName = unit.UnitName;
}
if (checkSpecialDetail.CompletedDate != null)
{
completedDate = string.Format("{0:yyyy-MM-dd}", checkSpecialDetail.CompletedDate);
}
str += "<tr><td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;'>" + i + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + checkSpecialDetail.Unqualified + "<br/>" + photo1 + "<br/>" + photo2 + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' ></td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' ></td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + completedDate + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + unitName + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' ></td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' ></td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none;' ></td></tr>";
i++;
}
str += "</table>";
this.div3.InnerHtml = str;
}
}
}
/// <summary>
/// 加载页面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
btnClose.OnClientClick = ActiveWindow.GetHideReference();
this.CostSmallDetailId = Request.Params["CostSmallDetailId"];
if (!string.IsNullOrEmpty(this.CostSmallDetailId))
{
Model.CostGoods_CostSmallDetail costSmallDetail = BLL.CostSmallDetailService.GetCostSmallDetailById(this.CostSmallDetailId);
if (costSmallDetail != null)
{
this.txtCostSmallDetailCode.Text = CodeRecordsService.ReturnCodeByDataId(this.CostSmallDetailId);
if (costSmallDetail.Months != null)
{
this.txtMonths.Text = string.Format("{0:yyyy-MM}", costSmallDetail.Months);
}
if (!string.IsNullOrEmpty(costSmallDetail.UnitId))
{
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(costSmallDetail.UnitId);
if (unit != null)
{
this.drpUnitId.Text = unit.UnitName;
}
}
if (costSmallDetail.ReportDate != null)
{
this.txtReportDate.Text = string.Format("{0:yyyy-MM-dd}", costSmallDetail.ReportDate);
}
//this.txtCompileMan.Text = costSmallDetail.CompileMan;
//if (costSmallDetail.CompileDate != null)
//{
// this.txtCompileDate.Text = string.Format("{0:yyyy-MM-dd}", costSmallDetail.CompileDate);
//}
//this.txtCheckMan.Text = costSmallDetail.CheckMan;
//if (costSmallDetail.CheckDate != null)
//{
// this.txtCheckDate.Text = string.Format("{0:yyyy-MM-dd}", costSmallDetail.CheckDate);
//}
//this.txtApproveMan.Text = costSmallDetail.ApproveMan;
//if (costSmallDetail.ApproveDate != null)
//{
// this.txtApproveDate.Text = string.Format("{0:yyyy-MM-dd}", costSmallDetail.ApproveDate);
//}
decimal totalA = 0, totalB = 0, totalProjectA = 0, totalProjectB = 0;
Model.Base_Project project = BLL.ProjectService.GetProjectByProjectId(costSmallDetail.ProjectId);
if (project != null && costSmallDetail.Months.HasValue)
{
List <Model.CostGoods_CostSmallDetailItem> projectDetails = BLL.CostSmallDetailItemService.GetCostDetailsByUnitId(this.CurrUser.LoginProjectId, costSmallDetail.UnitId, project.StartDate, costSmallDetail.Months);
List <Model.CostGoods_CostSmallDetailItem> details = BLL.CostSmallDetailItemService.GetCostSmallDetailItemByCostSmallDetailId(this.CostSmallDetailId);
Model.CostGoods_CostSmallDetailItem a1 = details.FirstOrDefault(x => x.CostType == "A1");
if (a1 != null)
{
this.nbA1.Text = (a1.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA1.Text);
this.nbProjectA1.Text = ((from x in projectDetails where x.CostType == "A1" select x.CostMoney ?? 0).Sum() + a1.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA1.Text);
this.txtDefA1.Text = a1.CostDef;
}
Model.CostGoods_CostSmallDetailItem a2 = details.FirstOrDefault(x => x.CostType == "A2");
if (a2 != null)
{
this.nbA2.Text = (a2.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA2.Text);
this.nbProjectA2.Text = ((from x in projectDetails where x.CostType == "A2" select x.CostMoney ?? 0).Sum() + a2.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA2.Text);
this.txtDefA2.Text = a2.CostDef;
}
Model.CostGoods_CostSmallDetailItem a3 = details.FirstOrDefault(x => x.CostType == "A3");
if (a3 != null)
{
this.nbA3.Text = (a3.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA3.Text);
this.nbProjectA3.Text = ((from x in projectDetails where x.CostType == "A3" select x.CostMoney ?? 0).Sum() + a3.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA3.Text);
this.txtDefA3.Text = a3.CostDef;
}
Model.CostGoods_CostSmallDetailItem a4 = details.FirstOrDefault(x => x.CostType == "A4");
if (a4 != null)
{
this.nbA4.Text = (a4.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA4.Text);
this.nbProjectA4.Text = ((from x in projectDetails where x.CostType == "A4" select x.CostMoney ?? 0).Sum() + a4.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA4.Text);
this.txtDefA4.Text = a4.CostDef;
}
Model.CostGoods_CostSmallDetailItem a5 = details.FirstOrDefault(x => x.CostType == "A5");
if (a5 != null)
{
this.nbA5.Text = (a5.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA5.Text);
this.nbProjectA5.Text = ((from x in projectDetails where x.CostType == "A5" select x.CostMoney ?? 0).Sum() + a5.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA5.Text);
this.txtDefA5.Text = a5.CostDef;
}
Model.CostGoods_CostSmallDetailItem a6 = details.FirstOrDefault(x => x.CostType == "A6");
if (a6 != null)
{
this.nbA6.Text = (a6.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA6.Text);
this.nbProjectA6.Text = ((from x in projectDetails where x.CostType == "A6" select x.CostMoney ?? 0).Sum() + a6.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA6.Text);
this.txtDefA6.Text = a6.CostDef;
}
this.nbA.Text = totalA.ToString();
this.nbProjectA.Text = totalProjectA.ToString();
Model.CostGoods_CostSmallDetailItem b1 = details.FirstOrDefault(x => x.CostType == "B1");
if (b1 != null)
{
this.nbB1.Text = (b1.CostMoney ?? 0).ToString();
totalB += Funs.GetNewDecimalOrZero(this.nbB1.Text);
this.nbProjectB1.Text = ((from x in projectDetails where x.CostType == "B1" select x.CostMoney ?? 0).Sum() + b1.CostMoney ?? 0).ToString();
totalProjectB += Funs.GetNewDecimalOrZero(this.nbProjectB1.Text);
this.txtDefB1.Text = b1.CostDef;
}
Model.CostGoods_CostSmallDetailItem b2 = details.FirstOrDefault(x => x.CostType == "B2");
if (b2 != null)
{
this.nbB2.Text = (b2.CostMoney ?? 0).ToString();
totalB += Funs.GetNewDecimalOrZero(this.nbB2.Text);
this.nbProjectB2.Text = ((from x in projectDetails where x.CostType == "B2" select x.CostMoney ?? 0).Sum() + b2.CostMoney ?? 0).ToString();
totalProjectB += Funs.GetNewDecimalOrZero(this.nbProjectB2.Text);
this.txtDefB2.Text = b2.CostDef;
}
Model.CostGoods_CostSmallDetailItem b3 = details.FirstOrDefault(x => x.CostType == "B3");
if (b3 != null)
{
this.nbB3.Text = (b3.CostMoney ?? 0).ToString();
totalB += Funs.GetNewDecimalOrZero(this.nbB3.Text);
this.nbProjectB3.Text = ((from x in projectDetails where x.CostType == "B3" select x.CostMoney ?? 0).Sum() + b3.CostMoney ?? 0).ToString();
totalProjectB += Funs.GetNewDecimalOrZero(this.nbProjectB3.Text);
this.txtDefB3.Text = b3.CostDef;
}
this.nbB.Text = totalB.ToString();
this.nbProjectB.Text = totalProjectB.ToString();
this.nbAB.Text = (totalA + totalB).ToString();
this.nbProjectAB.Text = (totalProjectA + totalProjectB).ToString();
}
}
///初始化审核菜单
this.ctlAuditFlow.MenuId = BLL.Const.ProjectCostSmallDetailMenuId;
this.ctlAuditFlow.DataId = this.CostSmallDetailId;
}
}
}
/// <summary>
/// 加载页面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadData();
PauseNoticeId = Request.Params["PauseNoticeId"];
if (!string.IsNullOrEmpty(PauseNoticeId))
{
Model.Check_PauseNotice pauseNotice = BLL.Check_PauseNoticeService.GetPauseNoticeByPauseNoticeId(PauseNoticeId);
this.txtPauseNoticeCode.Text = BLL.CodeRecordsService.ReturnCodeByDataId(this.PauseNoticeId);
if (!string.IsNullOrEmpty(pauseNotice.UnitId))
{
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(pauseNotice.UnitId);
if (unit != null)
{
this.txtUnit.Text = unit.UnitName;
}
}
//if (!string.IsNullOrEmpty(pauseNotice.SignMan))
//{
// var signName = BLL.UserService.GetUserNameByUserId(pauseNotice.SignMan);
// if (signName !=null)
// {
// this.txtSignMan.Text = signName;
// }
//}
//if (!string.IsNullOrEmpty(pauseNotice.ApproveMan))
//{
// var approve = BLL.UserService.GetUserNameByUserId(pauseNotice.ApproveMan);
// if (approve!=null)
// {
// this.txtApproveMan.Text = approve;
// }
//}
this.txtProjectPlace.Text = pauseNotice.ProjectPlace;
// this.txtSignPerson.Text = pauseNotice.SignPerson;
if (pauseNotice.CompileDate != null)
{
this.txtComplieDate.Text = string.Format("{0:yyyy-MM-dd}", pauseNotice.CompileDate);
}
this.txtWrongContent.Text = pauseNotice.WrongContent;
if (pauseNotice.PauseTime != null)
{
string strPauseTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", pauseNotice.PauseTime);
int index1 = strPauseTime.IndexOf("-");
int index2 = strPauseTime.Substring(index1 + 1).IndexOf("-");
int index3 = strPauseTime.Substring(index1 + 1 + index2 + 1).IndexOf(" ");
int index4 = strPauseTime.Substring(index1 + 1 + index2 + 1 + index3 + 1).IndexOf(":");
this.txtYear.Text = strPauseTime.Substring(0, index1);
this.txtMonth.Text = strPauseTime.Substring(index1 + 1, index2);
this.txtDay.Text = strPauseTime.Substring(index1 + 1 + index2 + 1, index3);
this.txtHour.Text = strPauseTime.Substring(index1 + 1 + index2 + 1 + index3 + 1, index4);
}
this.txtPauseContent.Text = pauseNotice.PauseContent;
this.txtOneContent.Text = pauseNotice.OneContent;
this.txtSecondContent.Text = pauseNotice.SecondContent;
this.txtThirdContent.Text = pauseNotice.ThirdContent;
//this.txtProjectHeadConfirm.Text = pauseNotice.ProjectHeadConfirm;
//if (pauseNotice.ConfirmDate != null)
//{
// this.txtConfirmDate.Text = string.Format("{0:yyyy-MM-dd}", pauseNotice.ConfirmDate);
//}
this.AttachUrl = pauseNotice.AttachUrl;
this.divFile1.InnerHtml = BLL.UploadAttachmentService.ShowAttachment("../", this.AttachUrl);
if (Request.Params["type"] == "confirm") //签字确认
{
this.txtProjectHeadConfirm.Enabled = true;
this.txtConfirmDate.Enabled = true;
this.txtProjectHeadConfirm.Text = this.CurrUser.UserName;
this.txtConfirmDate.Text = string.Format("{0:yyyy-MM-dd}", DateTime.Now);
}
}
///初始化审核菜单
this.ctlAuditFlow.MenuId = BLL.Const.ProjectPauseNoticeMenuId;
this.ctlAuditFlow.DataId = this.PauseNoticeId;
}
}
/// <summary>
/// 加载页面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.CheckColligationId = Request.Params["CheckColligationId"];
var checkColligation = BLL.Check_CheckColligationService.GetCheckColligationByCheckColligationId(this.CheckColligationId);
if (checkColligation != null)
{
this.txtCheckTime.Text = "检查时间：";
if (checkColligation.CheckTime != null)
{
this.txtCheckTime.Text += string.Format("{0:yyyy-MM-dd}", checkColligation.CheckTime);
}
string personStr = "检查人：";
Model.Sys_User user = BLL.UserService.GetUserByUserId(checkColligation.CheckPerson);
if (user != null)
{
personStr += user.UserName + "、";
}
if (!string.IsNullOrEmpty(checkColligation.PartInPersonIds))
{
string[] strs = checkColligation.PartInPersonIds.Split(',');
foreach (var s in strs)
{
Model.Sys_User checkPerson = BLL.UserService.GetUserByUserId(s);
if (checkPerson != null)
{
personStr += checkPerson.UserName + "、";
}
}
}
if (!string.IsNullOrEmpty(personStr))
{
personStr = personStr.Substring(0, personStr.LastIndexOf("、"));
}
if (!string.IsNullOrEmpty(checkColligation.PartInPersonNames))
{
if (personStr != "检查人：")
{
personStr += "、" + checkColligation.PartInPersonNames;
}
else
{
personStr += checkColligation.PartInPersonNames;
}
}
this.txtCheckPerson.Text = personStr;
this.txtCheckType.Text = "检查项目：";
if (checkColligation.CheckType == "0")
{
this.txtCheckType.Text += "周检";
}
else if (checkColligation.CheckType == "1")
{
this.txtCheckType.Text += "月检";
}
else if (checkColligation.CheckType == "2")
{
this.txtCheckType.Text += "其它";
}
var checkColligationDetails = BLL.Check_CheckColligationDetailService.GetCheckColligationDetailByCheckColligationId(this.CheckColligationId);
int i = 1;
string str = "<table id='Table3' runat='server' width='100%' cellpadding='0' cellspacing='0' border='0' frame='vsides' bordercolor='#000000'>"
+ "<tr><td align='center' style='width:5%; border: 1px solid #000000; font-size:15px; border-right: none;'>序号</td>"
+ "<td align='center' style='width:15%; border: 1px solid #000000; font-size:15px; border-right: none;'>隐患内容</td>"
+ "<td align='center' style='width:10%; border: 1px solid #000000; font-size:15px; border-right: none;'>检查区域</td>"
+ "<td align='center' style='width:8%; border: 1px solid #000000; font-size:15px; border-right: none;'>隐患类型</td>"
+ "<td align='center' style='width:8%; border: 1px solid #000000; font-size:15px; border-right: none;'>隐患级别</td>"
+ "<td align='center' style='width:12%; border: 1px solid #000000; font-size:15px; border-right: none;'>责任单位</td>"
+ "<td align='center' style='width:8%; border: 1px solid #000000; font-size:15px; border-right: none;'>责任人</td>"
+ "<td align='center' style='width:8%; border: 1px solid #000000; font-size:15px; border-right: none;'>整改限时</td>"
+ "<td align='center' style='width:12%; border: 1px solid #000000; font-size:15px; border-right: none;'>整改要求</td>"
+ "<td align='center' style='width:14%; border: 1px solid #000000; font-size:15px; '>处理措施</td></tr>";
foreach (var checkColligationDetail in checkColligationDetails)
{
string photo1 = string.Empty;
string photo2 = string.Empty;
Model.AttachFile attachFile = BLL.AttachFileService.GetAttachFile(checkColligationDetail.CheckColligationDetailId, BLL.Const.ProjectCheckColligationWHMenuId);
if (attachFile != null)
{
List <string> urls = new List <string>();
string[] lists = attachFile.AttachUrl.Split(',');
foreach (var list in lists)
{
if (!string.IsNullOrEmpty(list))
{
urls.Add(list);
}
}
if (urls.Count > 1) //两个附件
{
photo1 = "<img alt='' runat='server' id='img111' width='180' height='180' src='" + "../" + urls[0] + "' />";
photo2 = "<img alt='' runat='server' id='img111' width='180' height='180' src='" + "../" + urls[1] + "' />";
}
else
{
photo1 = "<img alt='' runat='server' id='img111' width='180' height='180' src='" + "../" + urls[0] + "' />";
}
}
string unitName = string.Empty;
string personName = string.Empty;
string handleStepName = string.Empty;
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(checkColligationDetail.UnitId);
if (unit != null)
{
unitName = unit.UnitName;
}
if (!string.IsNullOrEmpty(checkColligationDetail.PersonId))
{
var person = BLL.PersonService.GetPersonById(checkColligationDetail.PersonId);
if (person != null)
{
personName = person.PersonName;
}
}
if (!string.IsNullOrEmpty(checkColligationDetail.HandleStep))
{
List <string> lists = checkColligationDetail.HandleStep.Split('|').ToList();
if (lists.Count > 0)
{
foreach (var item in lists)
{
Model.Sys_Const con = BLL.ConstValue.GetConstByConstValueAndGroupId(item, BLL.ConstValue.Group_HandleStep);
if (con != null)
{
handleStepName += con.ConstText + "|";
}
}
}
if (!string.IsNullOrEmpty(handleStepName))
{
handleStepName = handleStepName.Substring(0, handleStepName.LastIndexOf("|"));
}
}
str += "<tr><td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;'>" + i + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + checkColligationDetail.Unqualified + "<br/>" + photo1 + "<br/>" + photo2 + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + checkColligationDetail.WorkArea + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + checkColligationDetail.HiddenDangerType + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + checkColligationDetail.HiddenDangerLevel + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + unitName + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + personName + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + string.Format("{0:yyyy-MM-dd}", checkColligationDetail.LimitedDate) + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none; border-right: none;' >" + checkColligationDetail.Suggestions + "</td>"
+ "<td align='center' style='border: 1px solid #000000; font-size:15px; border-top: none;' >" + handleStepName + "</td></tr>";
i++;
}
str += "</table>";
this.div3.InnerHtml = str;
}
}
}
/// <summary>
/// 加载页面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
hdAttachUrl.Text = string.Empty;
hdId.Text = string.Empty;
this.btnClose.OnClientClick = ActiveWindow.GetHideReference();
this.ProjectId = this.CurrUser.LoginProjectId;
this.CheckDayId = Request.Params["CheckDayId"];
var checkDay = BLL.Check_CheckDayXAService.GetCheckDayByCheckDayId(this.CheckDayId);
if (checkDay != null)
{
this.ProjectId = checkDay.ProjectId;
this.txtCheckDayCode.Text = BLL.CodeRecordsService.ReturnCodeByDataId(this.CheckDayId);
if (checkDay.CheckDate != null)
{
this.txtCheckDate.Text = string.Format("{0:yyyy-MM-dd}", checkDay.CheckDate);
}
Model.Sys_User checkMan = BLL.UserService.GetUserByUserId(checkDay.CompileMan);
if (checkMan != null)
{
this.txtCheckMan.Text = checkMan.UserName;
}
if (checkDay.NotOKNum != null)
{
this.txtNotOKNum.Text = checkDay.NotOKNum.ToString();
}
if (BLL.ProjectUnitService.GetProjectUnitTypeByProjectIdUnitId(this.ProjectId, checkDay.CompileUnit)) //施工单位
{
this.trTeamGroup.Hidden = false;
if (!string.IsNullOrEmpty(checkDay.DutyTeamGroupIds))
{
string names = string.Empty;
string[] ids = checkDay.DutyTeamGroupIds.Split(',');
foreach (var item in ids)
{
Model.ProjectData_TeamGroup teamGroup = BLL.TeamGroupService.GetTeamGroupById(item);
if (teamGroup != null)
{
names += teamGroup.TeamGroupName + ",";
}
}
if (!string.IsNullOrEmpty(names))
{
names = names.Substring(0, names.LastIndexOf(","));
}
this.drpDutyTeamGroupIds.Text = names;
}
}
else
{
this.trUnit.Hidden = false;
if (!string.IsNullOrEmpty(checkDay.DutyUnitIds))
{
string names = string.Empty;
string[] ids = checkDay.DutyUnitIds.Split(',');
foreach (var item in ids)
{
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(item);
if (unit != null)
{
names += unit.UnitName + ",";
}
}
if (!string.IsNullOrEmpty(names))
{
names = names.Substring(0, names.LastIndexOf(","));
}
this.drpDutyUnitIds.Text = names;
}
}
if (!string.IsNullOrEmpty(checkDay.WorkAreaIds))
{
string names = string.Empty;
string[] ids = checkDay.WorkAreaIds.Split(',');
foreach (var item in ids)
{
Model.ProjectData_WorkArea workArea = BLL.WorkAreaService.GetWorkAreaByWorkAreaId(item);
if (workArea != null)
{
names += workArea.WorkAreaName + ",";
}
}
if (!string.IsNullOrEmpty(names))
{
names = names.Substring(0, names.LastIndexOf(","));
}
this.drpWorkAreaIds.Text = names;
}
this.txtUnqualified.Text = checkDay.Unqualified;
this.txtHandleStation.Text = checkDay.HandleStation;
if (checkDay.IsOK == true)
{
this.txtIsOK.Text = "是";
}
else
{
this.txtIsOK.Text = "否";
}
}
}
}
/// <summary>
/// 插入信息-单位信息 1
/// </summary>
/// <param name="projectId"></param>
/// <param name="arr"></param>
public static bool AddUnit(string projectId, JArray arr, Model.Sys_User user)
{
Model.SUBHSSEDB db = Funs.DB;
bool isOk = true;
try
{
foreach (var item in arr)
{
string fromUnitId = item["ID"].ToString();
string departName = item["DepartName"].ToString(); ///单位名称
string departSir = item["DepartSir"].ToString(); ///单位级别 0：非项目部 1：项目部级 2：项目部下级单位
////单位类型
string unitTypeId = null;
var getUnitType = db.Base_UnitType.FirstOrDefault(x => x.UnitTypeName == item["DepartType"].ToString());
if (getUnitType != null)
{
unitTypeId = getUnitType.UnitTypeId;
}
if (!string.IsNullOrEmpty(fromUnitId) && !string.IsNullOrEmpty(departName) && departSir != "1")
{
if (!string.IsNullOrEmpty(projectId))
{
Model.Base_Unit newUnit = new Model.Base_Unit
{
FromUnitId = fromUnitId,
UnitCode = item["DepartCode"].ToString(),
UnitName = departName,
UnitTypeId = unitTypeId,
Corporate = item["Charge"].ToString(),
Telephone = item["Phone"].ToString(),
IsHide = false,
DataSources = projectId,
};
var getUnit = db.Base_Unit.FirstOrDefault(x => x.FromUnitId == fromUnitId);
if (getUnit == null)
{
var getUnitByName = db.Base_Unit.FirstOrDefault(x => x.UnitName == departName);
if (getUnitByName != null)
{
newUnit.UnitId = getUnitByName.UnitId;
getUnitByName.FromUnitId = fromUnitId;
db.SubmitChanges();
}
else
{
newUnit.UnitId = SQLHelper.GetNewID(typeof(Model.Base_Unit));
UnitService.AddUnit(newUnit);
}
}
else
{
newUnit.UnitId = getUnit.UnitId;
}
var pUnit = db.Project_ProjectUnit.FirstOrDefault(x => x.ProjectId == projectId && x.UnitId == newUnit.UnitId);
if (pUnit == null)
{
Model.Project_ProjectUnit newProjectUnit = new Model.Project_ProjectUnit
{
ProjectId = projectId,
UnitId = newUnit.UnitId,
UnitType = Const.ProjectUnitType_2,
};
ProjectUnitService.AddProjectUnit(newProjectUnit);
BLL.LogService.AddSys_Log(user, null, newProjectUnit.ProjectUnitId, BLL.Const.ProjectUnitMenuId, BLL.Const.BtnModify);
}
}
}
}
}
catch (Exception ex)
{
isOk = false;
ErrLogInfo.WriteLog(string.Empty, ex);
}
return(isOk);
}
private void getQRUrl()
{
if (!string.IsNullOrEmpty(Request.Params["PersonId"]))
{
////人员
var person = BLL.PersonService.GetPersonById(Request.Params["PersonId"]);
if (person != null && !string.IsNullOrEmpty(person.QRCodeAttachUrl))
{
this.imgPhoto.Src = "../" + person.QRCodeAttachUrl;
this.lbWedCode.Text = "人员卡号：" + person.CardNo;
this.lbWedName.Text = "人员姓名：" + person.PersonName;
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(person.UnitId);
string unitName = string.Empty;
if (unit != null)
{
unitName = unit.UnitName;
}
this.lbUnitName.Text = "人员单位：" + unitName;
}
}
else if (!string.IsNullOrEmpty(Request.Params["EquipmentQualityId"]))
{
////设备
var equipmentQuality = BLL.EquipmentQualityService.GetEquipmentQualityById(Request.Params["EquipmentQualityId"]);
if (equipmentQuality != null && !string.IsNullOrEmpty(equipmentQuality.QRCodeAttachUrl))
{
this.imgPhoto.Src = "../" + equipmentQuality.QRCodeAttachUrl;
this.lbWedCode.Text = "出厂编号：" + equipmentQuality.FactoryCode;
this.lbWedName.Text = "设备名称：" + equipmentQuality.EquipmentQualityName;
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(equipmentQuality.UnitId);
string unitName = string.Empty;
if (unit != null)
{
unitName = unit.UnitName;
}
this.lbUnitName.Text = "所属单位：" + unitName;
}
}
else if (!string.IsNullOrEmpty(Request.Params["GeneralEquipmentQualityId"]))
{
///一般设备
var generalEquipmentQuality = BLL.GeneralEquipmentQualityService.GetGeneralEquipmentQualityById(Request.Params["GeneralEquipmentQualityId"]);
if (generalEquipmentQuality != null && !string.IsNullOrEmpty(generalEquipmentQuality.QRCodeAttachUrl))
{
this.imgPhoto.Src = "../" + generalEquipmentQuality.QRCodeAttachUrl;
this.lbWedCode.Text = "编号：" + BLL.CodeRecordsService.ReturnCodeByDataId(generalEquipmentQuality.GeneralEquipmentQualityId);
string equipmentTypeName = string.Empty;
Model.Base_SpecialEquipment equipmentType = BLL.SpecialEquipmentService.GetSpecialEquipmentById(generalEquipmentQuality.SpecialEquipmentId);
if (equipmentType != null)
{
equipmentTypeName = equipmentType.SpecialEquipmentName;
}
this.lbWedName.Text = "设备名称：" + equipmentTypeName;
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(generalEquipmentQuality.UnitId);
string unitName = string.Empty;
if (unit != null)
{
unitName = unit.UnitName;
}
this.lbUnitName.Text = "所属单位：" + unitName;
}
}
else if (!string.IsNullOrEmpty(Request.Params["ConstructSolutionId"]))
{
///施工方案
var constructSolution = BLL.ConstructSolutionService.GetConstructSolutionById(Request.Params["ConstructSolutionId"]);
if (constructSolution != null && !string.IsNullOrEmpty(constructSolution.QRCodeAttachUrl))
{
this.imgPhoto.Src = "../" + constructSolution.QRCodeAttachUrl;
string code = string.Empty;
if (!string.IsNullOrEmpty(constructSolution.ConstructSolutionCode))
{
code = constructSolution.ConstructSolutionCode;
}
else
{
code = BLL.CodeRecordsService.ReturnCodeByDataId(constructSolution.ConstructSolutionId);
}
this.lbWedCode.Text = "编号：" + code;
this.lbWedName.Text = "方案名称：" + constructSolution.ConstructSolutionName;
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(constructSolution.UnitId);
string unitName = string.Empty;
if (unit != null)
{
unitName = unit.UnitName;
}
this.lbUnitName.Text = "所属单位：" + unitName;
}
}
else if (!string.IsNullOrEmpty(Request.Params["TrainingPlanId"]))
{
///培训计划
var trainingPlan = BLL.TrainingPlanService.GetPlanById(Request.Params["TrainingPlanId"]);
if (trainingPlan != null && !string.IsNullOrEmpty(trainingPlan.QRCodeUrl))
{
this.imgPhoto.Src = "../" + trainingPlan.QRCodeUrl;
string code = string.Empty;
if (!string.IsNullOrEmpty(trainingPlan.PlanCode))
{
code = trainingPlan.PlanCode;
}
else
{
code = BLL.CodeRecordsService.ReturnCodeByDataId(trainingPlan.PlanId);
}
this.lbWedCode.Text = "编号：" + code;
this.lbWedName.Text = "名称：" + trainingPlan.PlanName;
this.lbUnitName.Text = "培训时间：" + string.Format("{0:yyyy-MM-dd}", trainingPlan.TrainStartDate) + "；培训地点：" + trainingPlan.TeachAddress;
}
}
else if (!string.IsNullOrEmpty(Request.Params["TestPlanId"]))
{
///培训计划
var testPlan = BLL.TestPlanService.GetTestPlanById(Request.Params["TestPlanId"]);
if (testPlan != null && !string.IsNullOrEmpty(testPlan.QRCodeUrl))
{
this.imgPhoto.Src = "../" + testPlan.QRCodeUrl;
string code = string.Empty;
if (!string.IsNullOrEmpty(testPlan.PlanCode))
{
code = testPlan.PlanCode;
}
else
{
code = BLL.CodeRecordsService.ReturnCodeByDataId(testPlan.PlanId);
}
this.lbWedCode.Text = "编号：" + code;
this.lbWedName.Text = "名称：" + testPlan.PlanName;
this.lbUnitName.Text = "考试扫码时间：" + string.Format("{0:yyyy-MM-dd}", testPlan.TestStartTime) + "；考试地点：" + testPlan.TestPalce;
}
}
else if (!string.IsNullOrEmpty(Request.Params["ServerTestPlanId"]))
{
///知识竞赛
var testPlan = BLL.ServerTestPlanService.GetTestPlanById(Request.Params["ServerTestPlanId"]);
if (testPlan != null && !string.IsNullOrEmpty(testPlan.QRCodeUrl))
{
this.imgPhoto.Src = "../" + testPlan.QRCodeUrl;
this.lbWedCode.Text = "编号：" + testPlan.PlanCode;
this.lbWedName.Text = "名称：" + testPlan.PlanName;
this.lbUnitName.Text = "扫码考试时间：" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", testPlan.TestStartTime) + "；至：" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", testPlan.TestEndTime);
}
}
}
/// <summary>
/// 加载页面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var thisUnit = BLL.CommonService.GetIsThisUnit();
if (thisUnit != null)
{
this.Label8.Text = thisUnit.UnitName + this.Label8.Text;
this.Label18.Text = thisUnit.UnitName + this.Label18.Text;
this.Label19.Text = thisUnit.UnitName + this.Label19.Text;
}
this.RectifyNoticeId = Request.Params["RectifyNoticeId"];
var rectifyNotice = BLL.RectifyNoticesService.GetRectifyNoticesById(this.RectifyNoticeId);
if (rectifyNotice != null)
{
this.txtRectifyNoticeCode.Text = BLL.CodeRecordsService.ReturnCodeByDataId(this.RectifyNoticeId);
Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(rectifyNotice.UnitId);
if (unit != null)
{
this.txtUnitName.Text = unit.UnitName;
this.txtUnitNameProject.Text = unit.UnitName + "项目部：";
}
this.txtDutyPerson1.Text = rectifyNotice.DutyPerson;
if (rectifyNotice.CheckedDate != null)
{
this.txtCheckedDate.Text = string.Format("{0:yyyy-MM-dd}", rectifyNotice.CheckedDate);
this.txtCheckedDate2.Text = rectifyNotice.CheckedDate.Value.Year + "年" + rectifyNotice.CheckedDate.Value.Month + "月" + rectifyNotice.CheckedDate.Value.Day + "日";
}
if (!string.IsNullOrEmpty(rectifyNotice.WrongContent))
{
this.txtWrongContent.Text = rectifyNotice.WrongContent;
}
Model.Sys_User user = BLL.UserService.GetUserByUserId(rectifyNotice.SignPerson);
if (user != null)
{
this.txtSignPerson.Text = user.UserName;
}
if (rectifyNotice.SignDate != null)
{
this.txtSignDate.Text = string.Format("{0:yyyy-MM-dd}", rectifyNotice.SignDate);
}
if (!string.IsNullOrEmpty(rectifyNotice.CompleteStatus))
{
this.txtCompleteStatus.Text = rectifyNotice.CompleteStatus;
}
this.txtDutyPerson2.Text = rectifyNotice.DutyPerson;
if (rectifyNotice.CompleteDate != null)
{
this.txtCompleteDate.Text = string.Format("{0:yyyy-MM-dd}", rectifyNotice.CompleteDate);
}
Model.AttachFile attachFile = BLL.AttachFileService.GetAttachFile(this.RectifyNoticeId, BLL.Const.ProjectRectifyNoticeMenuId);
if (attachFile != null)
{
List <string> urls = new List <string>();
string[] lists = attachFile.AttachUrl.Split(',');
foreach (var list in lists)
{
if (!string.IsNullOrEmpty(list))
{
urls.Add(list);
}
}
string str = string.Empty;
str = "<table id='Table3' runat='server' width='100%' cellpadding='0' cellspacing='0' border='0' bordercolor='#000000'>";
if (urls.Count > 1) //两个附件
{
string photo1 = "<img alt='' runat='server' id='img111' width='280' height='280' src='" + "../" + urls[0] + "' />";
string photo2 = "<img alt='' runat='server' id='img111' width='280' height='280' src='" + "../" + urls[1] + "' />";
str += "<tr><td align='center' colspan='2'>" + photo1 + "</td>";
str += "<td align='center' colspan='2'>" + photo2 + "</td></tr>";
}
else if (urls.Count == 1)
{
string photo1 = "<img alt='' runat='server' id='img111' width='250' height='250' src='" + "../" + urls[0] + "' />";
str += "<td align='center' colspan='4'>" + photo1 + "</td></tr>";
}
str += "</table>";
this.div3.InnerHtml = str;
}
}
}
}
