/// <summary>
/// 数据和附件插入到多附件表
/// </summary>
public static void InsertAttachFile(string attachFileId, string dataId, string attachSource, string attachUrl, List <byte[]> fileContext)
{
//多附件
var attachFile = Funs.DB.AttachFile.FirstOrDefault(x => x.ToKeyId == dataId);
if (attachFile == null && !string.IsNullOrEmpty(attachSource))
{
Model.AttachFile newAttachFile = new Model.AttachFile
{
AttachFileId = attachFileId,
ToKeyId = dataId,
AttachSource = attachSource,
AttachUrl = attachUrl
};
Funs.DB.AttachFile.InsertOnSubmit(newAttachFile);
Funs.DB.SubmitChanges();
////插入附件文件
BLL.FileInsertService.FileMoreInsert(fileContext, attachUrl);
}
else
{
if (attachFile.AttachUrl != attachUrl)
{
///删除附件文件
BLL.UploadAttachmentService.DeleteFile(Funs.RootPath, attachFile.AttachUrl);
////插入附件文件
BLL.FileInsertService.FileMoreInsert(fileContext, attachUrl);
attachFile.AttachSource = attachSource;
attachFile.AttachUrl = attachUrl;
Funs.DB.SubmitChanges();
}
}
}
/// <summary>
/// 保存附件
/// </summary>
/// <param name="source"></param>
/// <param name="attachUrl"></param>
/// <param name="menuId"></param>
/// <param name="toKeyId"></param>
public static void SaveAttachUrl(string source, string attachUrl, string menuId, string toKeyId)
{
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
List <Model.AttachFile> sour = (from x in db.AttachFile where x.MenuId == menuId &&
x.ToKeyId == toKeyId select x).ToList();
if (sour.Count() == 0)
{
Model.AttachFile att = new Model.AttachFile
{
AttachFileId = SQLHelper.GetNewID(),
ToKeyId = toKeyId,
AttachSource = source.ToString(),
AttachUrl = attachUrl,
MenuId = menuId,
//AttachPath= attachPath,
};
db.AttachFile.InsertOnSubmit(att);
db.SubmitChanges();
}
else
{
Model.AttachFile att = db.AttachFile.FirstOrDefault(x => x.MenuId == menuId && x.AttachFileId == sour.First().AttachFileId);
if (att != null)
{
att.ToKeyId = toKeyId;
att.AttachSource = source.ToString();
att.AttachUrl = attachUrl;
att.MenuId = menuId;
db.SubmitChanges();
}
}
//if (!string.IsNullOrEmpty(toKeyId))
//{
// List<string> getattachUrlItems = Funs.GetStrListByStr(attachUrl, ',');
// foreach (var item in getattachUrlItems)
// {
// Model.AttachFileItem newItem = new Model.AttachFileItem
// {
// AttachFileItemId = SQLHelper.GetNewID(),
// ToKeyId = toKeyId,
// AttachUrl = item,
// };
// db.AttachFileItem.InsertOnSubmit(newItem);
// db.SubmitChanges();
// }
//}
//else
//{
// var getItems = from x in db.AttachFileItem where x.ToKeyId == toKeyId select x;
// if (getItems.Count() > 0)
// {
// db.AttachFileItem.DeleteAllOnSubmit(getItems);
// db.SubmitChanges();
// }
//}
}
}
/// <summary>
/// 修改附件存储信息
/// </summary>
/// <param name="workArea"></param>
public static void updateAttachFile(Model.AttachFile attachFile)
{
Model.AttachFile newAttachFile = db.AttachFile.FirstOrDefault(x => x.AttachFileId == attachFile.AttachFileId);
newAttachFile.ToKeyId = attachFile.ToKeyId;
newAttachFile.AttachSource = attachFile.AttachSource;
newAttachFile.AttachUrl = attachFile.AttachUrl;
newAttachFile.MenuId = attachFile.MenuId;
db.SubmitChanges();
}
/// <summary>
/// 根据对应Id删除附件信息及文件存放的物理位置
/// </summary>
/// <param name="workAreaId"></param>
public static void DeleteAttachFile(string rootPath, string toKeyId, string menuId)
{
Model.AttachFile att = db.AttachFile.FirstOrDefault(e => e.ToKeyId == toKeyId && e.MenuId == menuId);
if (att != null)
{
BLL.UploadFileService.DeleteFile(rootPath, att.AttachUrl);
db.AttachFile.DeleteOnSubmit(att);
db.SubmitChanges();
}
}
/// <summary>
/// 添加附件存储信息
/// </summary>
/// <param name="workArea"></param>
public static void AddAttachFile(Model.AttachFile attachFile)
{
string newKeyID = SQLHelper.GetNewID(typeof(Model.AttachFile));
Model.AttachFile newAttachFile = new Model.AttachFile();
newAttachFile.AttachFileId = newKeyID;
newAttachFile.ToKeyId = attachFile.ToKeyId;
newAttachFile.AttachSource = attachFile.AttachSource;
newAttachFile.AttachUrl = attachFile.AttachUrl;
newAttachFile.MenuId = attachFile.MenuId;
db.AttachFile.InsertOnSubmit(newAttachFile);
db.SubmitChanges();
}
/// <summary>
///根据主键删除附件
/// </summary>
/// <param name="lawRegulationId"></param>
public static void DeleteAttachFileById(string menuId, string id)
{
Model.SUBHSSEDB db = Funs.DB;
Model.AttachFile attachFile = db.AttachFile.FirstOrDefault(e => e.MenuId == menuId && e.ToKeyId == id);
if (attachFile != null)
{
if (!string.IsNullOrEmpty(attachFile.AttachUrl))
{
BLL.UploadFileService.DeleteFile(Funs.RootPath, attachFile.AttachUrl);
}
db.AttachFile.DeleteOnSubmit(attachFile);
db.SubmitChanges();
}
}
/// <summary>
///根据主键删除附件
/// </summary>
/// <param name="lawRegulationId"></param>
public static void DeleteAttachFileById(string id)
{
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
Model.AttachFile attachFile = db.AttachFile.FirstOrDefault(e => e.ToKeyId == id);
if (attachFile != null)
{
if (!string.IsNullOrEmpty(attachFile.AttachUrl))
{
UploadFileService.DeleteFile(Funs.RootPath, attachFile.AttachUrl);
}
db.AttachFile.DeleteOnSubmit(attachFile);
db.SubmitChanges();
}
}
}
/// <summary>
/// 修改危险观察登记信息
/// </summary>
/// <param name="hazardRegister">危险观察登记实体</param>
public static void UpdateHazardRegister(Model.HSSE_Hazard_HazardRegister hazardRegister)
{
Model.SUBHSSEDB db = Funs.DB;
Model.HSSE_Hazard_HazardRegister newHazardRegister = db.HSSE_Hazard_HazardRegister.FirstOrDefault(e => e.HazardRegisterId == hazardRegister.HazardRegisterId);
if (newHazardRegister != null)
{
newHazardRegister.HazardCode = hazardRegister.HazardCode;
newHazardRegister.RegisterDef = hazardRegister.RegisterDef;
newHazardRegister.Rectification = hazardRegister.Rectification;
newHazardRegister.Place = hazardRegister.Place;
newHazardRegister.ResponsibleUnit = hazardRegister.ResponsibleUnit;
newHazardRegister.Observer = hazardRegister.Observer;
newHazardRegister.RectifiedDate = hazardRegister.RectifiedDate;
newHazardRegister.AttachUrl = hazardRegister.AttachUrl;
newHazardRegister.ProjectId = hazardRegister.ProjectId;
newHazardRegister.States = hazardRegister.States;
newHazardRegister.IsEffective = hazardRegister.IsEffective;
newHazardRegister.ResponsibleMan = hazardRegister.ResponsibleMan;
newHazardRegister.CheckManId = hazardRegister.CheckManId;
//newHazardRegister.CheckTime = hazardRegister.CheckTime;
newHazardRegister.RectificationPeriod = hazardRegister.RectificationPeriod;
newHazardRegister.ImageUrl = hazardRegister.ImageUrl;
newHazardRegister.RectificationImageUrl = hazardRegister.RectificationImageUrl;
newHazardRegister.RectificationTime = hazardRegister.RectificationTime;
newHazardRegister.ConfirmMan = hazardRegister.ConfirmMan;
newHazardRegister.ConfirmDate = hazardRegister.ConfirmDate;
newHazardRegister.HandleIdea = hazardRegister.HandleIdea;
newHazardRegister.CutPayment = hazardRegister.CutPayment;
newHazardRegister.ProblemTypes = hazardRegister.ProblemTypes;
newHazardRegister.DIC_ID = hazardRegister.DIC_ID;
//把附件表的路径复制过来
Model.AttachFile file = BLL.AttachFileService.GetAttachFile(hazardRegister.HazardRegisterId, Const.HSSE_HiddenRectificationListMenuId);
if (file != null)
{
newHazardRegister.ImageUrl = file.AttachUrl;
}
Model.AttachFile fileR = BLL.AttachFileService.GetAttachFile(hazardRegister.HazardRegisterId + "-R", Const.HSSE_HiddenRectificationListMenuId);
if (fileR != null)
{
newHazardRegister.RectificationImageUrl = fileR.AttachUrl;
}
db.SubmitChanges();
}
}
/// <summary>
/// 得到Session
/// </summary>
/// <returns></returns>
private JArray GetSourceData()
{
if (Session[sessionName] == null && !string.IsNullOrEmpty(ToKeyId))
{
Session[sessionName] = new JArray();
Model.AttachFile sour = new Model.AttachFile();
if (this.MenuId == Const.ProjectPunishNoticeMenuId || this.MenuId == Const.ProjectPunishNoticeStatisticsMenuId)
{
sour = Funs.DB.AttachFile.FirstOrDefault(x => x.ToKeyId == ToKeyId && x.MenuId == this.MenuId);
}
else
{
sour = Funs.DB.AttachFile.FirstOrDefault(x => x.ToKeyId == ToKeyId);
}
if (sour != null)
{
string url = sour.AttachUrl.Replace('\\', '/');
List <string> list = Funs.GetStrListByStr(url, ',');
if (list.Count() > 0)
{
int i = 0;
foreach (var item in list)
{
string atturl = Funs.RootPath + item.Replace(';', ' ').Trim();
if (File.Exists(atturl))
{
i += 1;
break;
}
}
if (i > 0)
{
Session[sessionName] = JArray.Parse(sour.AttachSource);
}
}
}
}
return((JArray)Session[sessionName]);
}
/// <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 btnImageMagnify_Click(object sender, EventArgs e)
{
try
{
DeviceManager manager = new DeviceManagerClass();
Device device = null;
foreach (DeviceInfo info in manager.DeviceInfos)
{
if (info.Type != WiaDeviceType.ScannerDeviceType)
{
continue;
}
device = info.Connect();
break;
}
Item item = device.Items[1];
CommonDialogClass cdc = new WIA.CommonDialogClass();
ImageFile imageFile = null;
imageFile = cdc.ShowAcquireImage(WIA.WiaDeviceType.ScannerDeviceType,
WIA.WiaImageIntent.TextIntent,
WIA.WiaImageBias.MaximizeQuality,
"{00000000-0000-0000-0000-000000000000}",
true,
true,
false);
if (imageFile != null)
{
var buffer = imageFile.FileData.get_BinaryData() as byte[];
using (MemoryStream ms = new MemoryStream())
{
ms.Write(buffer, 0, buffer.Length);
string filePath = Server.MapPath("~/") + AttachPath; ///文件夹
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
string name = "\\";
var menu = BLL.SysMenuService.GetSysMenuByMenuId(this.MenuId);
if (menu != null)
{
name += menu.MenuName;
}
name += Funs.GetNewFileName() + ".jpg";
string url = filePath + name;
if (!string.IsNullOrEmpty(url))
{
using (FileStream fs = new FileStream(url, FileMode.Create, FileAccess.Write))
{
ms.WriteTo(fs);
string attachUrl = AttachPath + name;
if (!string.IsNullOrEmpty(attachUrl))
{
attachUrl = attachUrl.Replace('/', '\\');
}
string oldSrouce = string.Empty;
string FullPath = string.Empty;
Model.AttachFile att = Funs.DB.AttachFile.FirstOrDefault(x => x.ToKeyId == this.ToKeyId);
if (att != null && !string.IsNullOrEmpty(att.AttachUrl))
{
FullPath = att.AttachUrl + "," + attachUrl;
oldSrouce = att.AttachSource;
}
else
{
FullPath = attachUrl;
}
string source = BLL.UploadFileService.GetSourceByAttachUrl(attachUrl, buffer.Length, oldSrouce);
//this.SaveData(source, FullPath); ///保存方法
Session[sessionName] = JArray.Parse(source);
}
this.BindGrid();
ShowNotify("扫描完成!", MessageBoxIcon.Success);
}
}
}
}
catch
{
ShowNotify("请检查扫描仪是否连接正确!", MessageBoxIcon.Warning);
}
}
/// <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 btnSave_Click(object sender, EventArgs e)
{
if (ItemSelectedList.Count() > 0)
{
foreach (var item in ItemSelectedList)
{
Model.Law_ManageRule rule = BLL.ManageRuleService.GetManageRuleById(item);
if (rule != null)
{
string newKeyID = SQLHelper.GetNewID(typeof(Model.ActionPlan_ManagerRule));
Model.ActionPlan_ManagerRule newManagerRule = new Model.ActionPlan_ManagerRule
{
ManagerRuleId = newKeyID,
OldManageRuleId = rule.ManageRuleId,
ProjectId = this.CurrUser.LoginProjectId,
ManageRuleName = rule.ManageRuleName,
ManageRuleTypeId = rule.ManageRuleTypeId,
CompileDate = DateTime.Now,
Remark = rule.Remark,
CompileMan = this.CurrUser.UserId,
IsIssue = false,
Flag = true,
State = BLL.Const.State_0,
AttachUrl = rule.AttachUrl,
SeeFile = rule.SeeFile
};
BLL.ActionPlan_ManagerRuleService.AddManageRule(newManagerRule);
////保存流程审核数据
this.ctlAuditFlow.btnSaveData(this.CurrUser.LoginProjectId, BLL.Const.ActionPlan_ManagerRuleMenuId, newManagerRule.ManagerRuleId, true, newManagerRule.ManageRuleName, "../ActionPlan/ManagerRuleView.aspx?ManagerRuleId={0}");
Model.SUBHSSEDB db = Funs.DB;
Model.AttachFile attachFile = db.AttachFile.FirstOrDefault(x => x.ToKeyId == item);
if (attachFile != null)
{
Model.AttachFile newAttachFile = new Model.AttachFile
{
AttachFileId = SQLHelper.GetNewID(typeof(Model.AttachFile)),
ToKeyId = newKeyID
};
string[] urls = attachFile.AttachUrl.Split(',');
foreach (string url in urls)
{
string urlStr = BLL.Funs.RootPath + url;
if (File.Exists(urlStr))
{
string newUrl = urlStr.Replace("ManageRule", "ActionPlanManagerRule");
if (!Directory.Exists(newUrl.Substring(0, newUrl.LastIndexOf("\\"))))
{
Directory.CreateDirectory(newUrl.Substring(0, newUrl.LastIndexOf("\\")));
}
if (!File.Exists(newUrl))
{
File.Copy(urlStr, newUrl);
}
}
}
newAttachFile.AttachSource = attachFile.AttachSource.Replace("ManageRule", "ActionPlanManagerRule");
newAttachFile.AttachUrl = attachFile.AttachUrl.Replace("ManageRule", "ActionPlanManagerRule");
newAttachFile.MenuId = BLL.Const.ActionPlan_ManagerRuleMenuId;
db.AttachFile.InsertOnSubmit(newAttachFile);
db.SubmitChanges();
}
}
}
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
else
{
Alert.ShowInParent("请至少选择一条记录！");
return;
}
}
/// <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;
}
}
}
}
