protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { String id = Request.Params["ID"]; if (!String.IsNullOrEmpty(id)) { string SQL = "SELECT * FROM dbo.sys_document WHERE ID='" + id + "'"; DataSet ds = DbHelperSQL.Query(SQL); string str = ds.Tables[0].Rows[0]["Data"].ToString(); JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(str); if (doc != null) { try { string Temp = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "AI".RequestStr()).ToString(); Response.Write("<img src='data:image/gif;base64," + Temp + "' />"); } catch { Response.Write("<div style=\"width:400px;height:300px;line-height:300px; text-align:center;\">无图片或图片有误</div>"); } } } } }
private void NewSheet() { TreeNode Node = FpSheetView.SelectedNode; Boolean IsSheet = Convert.ToBoolean(Node.Tag); if (!IsSheet) { string Code = DepositorySheetCatlog.GetNextCode(Node.Name); string SheetName = DepositorySheetConfiguration.GetSheetName(Node.Name, "新建表单"); Sys_Sheet sheet = new Sys_Sheet(); sheet.ID = Guid.NewGuid(); sheet.CatlogCode = Code; sheet.SheetData = ""; sheet.Name = SheetName; sheet.SheetXML = JZCommonHelper.GZipCompressString(SheetConfiguration.BlankSheet); Boolean Result = ModuleHelperClient.SaveSheet(sheet); if (Result) { TreeNode SubNode = new TreeNode(); SubNode.Name = sheet.ID.ToString(); SubNode.Text = SheetName; SubNode.SelectedImageIndex = 2; SubNode.ImageIndex = 2; SubNode.Tag = true; Node.Nodes.Add(SubNode); Node.Expand(); Node.TreeView.SelectedNode = SubNode; } } }
public string RoomInfo(string Cell) { try { return(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, Cell).ToString()); } catch { return(""); } }
private string ProcessSheetLikeXML(string id, string xml) { if (IsContainerXml(xml)) { var zip = JZCommonHelper.GZipCompressString(xml); ExcuteCommand("UPDATE dbo.sys_sheet SET SheetXML = '" + zip + "' WHERE ID='" + id + "'"); return(zip); } return(xml); }
public string RoomInfo(string Cell) { try { return(JZCommonHelper.GetCellValue(sheetDataAreaCells, sheetDataAreaCells.Sheets[0].ID, Cell).ToString()); } catch { return(""); } }
private void Execute(object paremeter) { ThreadParameter p = paremeter as ThreadParameter; JZDocument document = p.document; Sys_Module module = p.module; String invalidString = ""; if (module != null) { if (module.QualifySettings != null && module.QualifySettings.Count > 0) { foreach (QualifySetting qs in module.QualifySettings) { Object obj = JZCommonHelper.GetCellValue(document, qs.SheetID, qs.CellName); if (obj != null && obj.ToString() != "") { invalidString = obj.ToString().Trim(' ', '\r', '\n'); break; } } } } if (invalidString != "") { try { String[] arr = invalidString.Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (arr.Length < 3) { logger.Error("无效的不合格短信内容,document的ID为" + document.ID + ";短信内容为:" + invalidString); return; } Boolean needSendSMS = false; SMSManager smsManager = new SMSManager(); if (!p.IsAdministrator) { needSendSMS = smsManager.NeedSendSMS(document.ID.ToString(), invalidString); logger.Error(invalidString + "needsendsms=" + needSendSMS); } if (needSendSMS) { smsManager.SendSMS(document.ID.ToString(), invalidString, p.LineID, p.TestRoomCode, p.SegmentName, p.CompanyName, p.TestRoomName, p.LineName); } } catch (Exception ex) { logger.Error("更新合格字段IsQualified失败,原因是" + ex.Message); } } icm.SyncInvalidReport(document.ID, invalidString); }
private void HyperLinkSettingDialog_Load(object sender, EventArgs e) { if (ActiveCell.CellType is FarPoint.Win.Spread.CellType.HyperLinkCellType) { FarPoint.Win.Spread.CellType.HyperLinkCellType hlnkCell = ActiveCell.CellType as FarPoint.Win.Spread.CellType.HyperLinkCellType; var tag = ActiveCell.Value as string; var model = "超链接"; if (!string.IsNullOrEmpty(tag)) { model = tag; } var text = hlnkCell.Text; var link = hlnkCell.Link; switch (model) { case "超链接": txtLinkUrl.Text = link; break; case "附件": Img = new Bitmap(JZCommonHelper.StringToBitmap(Convert.ToString(link))); break; } if (Img == null) { var bitmap = new Bitmap(Preview.Width, Preview.Height); var graphics = Graphics.FromImage(bitmap); var brush = new SolidBrush(Color.Gray); var format = new StringFormat(); format.Alignment = StringAlignment.Center; format.LineAlignment = StringAlignment.Center; graphics.DrawString("当前无预览", this.Font, brush, Preview.ClientRectangle, format); //这里文字以0,0为中心居中 graphics.Dispose(); Preview.Image = bitmap; } else { Preview.Image = Img; } txtShowText.Text = text; RadioAttach.Checked = model == "附件"; RadioLink.Checked = model == "超链接"; } }
/// <summary> /// 通过SheetID找到该Sheet的XML结构 /// </summary> /// <param name="SheetIndex"></param> /// <returns></returns> public static String GetSheetXMLByID(Guid SheetIndex) { String str = Agent.CallService("Yqun.BO.BusinessManager.dll", "GetSheetXMLByID", new object[] { SheetIndex }).ToString(); if (IsContainerXml(str)) { return(str); } else { return(JZCommonHelper.GZipDecompressString(str)); } }
public JZFile GetSpecialFile(Guid moduleID) { String[] files = new String[] { "sys_biz_ModuleCatlog", "sys_biz_SheetCatlog", "sys_dictionary", "sys_formulas", "sys_module", "sys_sheet", "sys_module_sheet", "sys_stadium_config", "sys_module_config" }; List <String> moduleIDs = new List <string>(); moduleIDs.Add(moduleID.ToString()); Boolean flag = true; String moduleIDStr = "'" + String.Join("','", moduleIDs.ToArray()) + "'"; try { String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "update"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } List <String> list = new List <string>(); foreach (String tbName in files) { list.Add(Path.Combine(path, tbName + ".dat")); flag = flag && OutPutFile(tbName, path, moduleIDStr, true); } String zipFile = Path.Combine(path, moduleID + ".zip"); if (File.Exists(zipFile)) { File.Delete(zipFile); } flag = flag && JZCommonHelper.CreateZipFile(list, zipFile); if (flag) { FileStream stream = null; JZFile f = new JZFile(); f.FileName = moduleID + ".zip"; stream = new FileInfo(zipFile).OpenRead(); Byte[] buffer = new Byte[stream.Length]; stream.Read(buffer, 0, Convert.ToInt32(stream.Length)); f.FileType = "all"; f.FileData = buffer; stream.Close(); return(f); } } catch (Exception ex) { logger.Error("generate special file error for module " + moduleID + ": " + ex.Message); } return(null); }
public Boolean RunSpecialUpdate(JZFile file, String server, String userName, String password, Guid moduleID) { String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "update"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } String fName = Path.Combine(path, file.FileName); File.WriteAllBytes(fName, file.FileData); Boolean flag = JZCommonHelper.UnZipFile(fName); if (flag) { String[] files = new String[] { "sys_biz_ModuleCatlog", "sys_biz_SheetCatlog", "sys_dictionary", "sys_formulas", "sys_module", "sys_sheet", "sys_module_sheet", "sys_stadium_config", "sys_module_config" }; foreach (String item in files) { String fPath = Path.Combine(path, item + ".dat"); if (File.Exists(fPath)) { String bcp = "bcp " + Connection.Database + ".dbo." + item + "_update in " + fPath + " -c -S " + server + " -U " + userName + " -P " + password; flag = flag && JZCommonHelper.ExeCommand(bcp); logger.Error(bcp); } } if (flag) { String sql = @"UPDATE dbo.sys_module_update SET ID=b.ID, Name=b.Name, Description=b.Description FROM dbo.sys_module_update a JOIN dbo.sys_module b ON b.ID='" + moduleID + @"' UPDATE dbo.sys_formulas_update SET ModuleID='" + moduleID + @"' UPDATE dbo.sys_module_sheet_update SET ModuleID='" + moduleID + @"' UPDATE dbo.sys_module_config_update SET ModuleID='" + moduleID + @"' UPDATE dbo.sys_stadium_config_update SET ID='" + moduleID + @"'"; ExcuteCommand(sql); int i = RunStoreProcedure("sp_update"); flag = i > 0; } } return(flag); }
public static FpSpread GetModuleByID(Guid moduleID, JZDocument document, String DBName) { if (moduleList.ContainsKey(moduleID)) { return(moduleList[moduleID]); } else { FpSpread fpSpread = new FpSpread(); try { Dictionary <Guid, SheetView> SheetCollection = new Dictionary <Guid, SheetView>(); List <FarPoint.CalcEngine.FunctionInfo> Infos = DBHelper.CallLocalService("Yqun.BO.BusinessManager.dll", "GetFunctionInfosNew", new object[] { }, DBName) as List <FarPoint.CalcEngine.FunctionInfo>; foreach (JZSheet sheet in document.Sheets) { String xml = DBHelper.CallLocalService("Yqun.BO.BusinessManager.dll", "GetSheetXMLByID", new object[] { sheet.ID }, DBName).ToString(); String sheetXML = JZCommonHelper.GZipDecompressString(xml); SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), sheetXML, "SheetView") as SheetView; SheetView.Tag = sheet.ID; SheetView.Cells[0, 0].Value = ""; SheetView.Protect = true; fpSpread.Sheets.Add(SheetView); SheetCollection.Add(sheet.ID, SheetView); foreach (FarPoint.CalcEngine.FunctionInfo Info in Infos) { SheetView.AddCustomFunction(Info); } } moduleList.Add(moduleID, fpSpread); } catch (Exception ex) { logger.Error("采集构造Farpoint组件错误:" + ex.Message); return(null); } return(fpSpread); } }
/// <summary> /// 同步生成相关文件 /// </summary> /// <param name="fpSpread"></param> /// <param name="documentID"></param> /// <param name="reportIndex"></param> public void CreateRalationFilesSync(FpSpread fpSpread, Guid documentID, Int32 reportIndex, string docDateDir) { if (documentID == null || fpSpread == null) { return; } try { String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "source/" + docDateDir); JZCommonHelper.SaveToExcel(documentID, fpSpread, path); JZCommonHelper.FarpointToImage0(documentID, fpSpread, path, reportIndex); //String excelPath = Path.Combine(path,documentID.ToString() + ".xls"); String pdfFilePath = Path.Combine(path, documentID.ToString() + ".pdf"); JZCommonHelper.FarpointToPDF0(fpSpread, pdfFilePath, reportIndex); } catch (Exception ex) { logger.Error("create ralation files:" + ex.Message); } }
private void Execute(object paremeter) { ThreadParameter p = paremeter as ThreadParameter; if (p.documentID == null || p.fpSpread == null) { return; } try { String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "source/" + p.docDateDir); JZCommonHelper.SaveToExcel(p.documentID, p.fpSpread, path); JZCommonHelper.FarpointToImage(p.documentID, p.fpSpread, path); String excelPath = Path.Combine(path, p.documentID.ToString() + ".xls"); String pdfFilePath = Path.Combine(path, p.documentID.ToString() + ".pdf"); JZCommonHelper.FarpointToPDF(p.fpSpread, pdfFilePath, p.reportIndex); } catch (Exception ex) { logger.Error("create ralation files:" + ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtShowText.Text)) { MessageBox.Show("请输入显示文字", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); txtLinkUrl.Focus(); return; } if (ActiveCell.CellType is FarPoint.Win.Spread.CellType.HyperLinkCellType) { FarPoint.Win.Spread.CellType.HyperLinkCellType hlnkCell = ActiveCell.CellType as FarPoint.Win.Spread.CellType.HyperLinkCellType; if (RadioAttach.Checked) { if (Img == null) { MessageBox.Show("请选择附件文件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ActiveCell.Value = "附件"; hlnkCell.Link = JZCommonHelper.BitmapToString(Img); } if (RadioLink.Checked) { ActiveCell.Value = "超链接"; hlnkCell.Link = txtLinkUrl.Text; } hlnkCell.Text = txtShowText.Text; ActiveCell.CellType = hlnkCell; MessageBox.Show("设置成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; } }
/// <summary> ///上传试验室综合情况 /// </summary> public void UploadTestRoomInfo(string strTestRoomCodeMap, String uploadAddress, String jsdwCode) { try { Hashtable testRoomCodeMap = InitTestRoomCodeMap(strTestRoomCodeMap); String moduleID = "E77624E9-5654-4185-9A29-8229AAFDD68B"; //试验室综合情况 String ksign = "01"; //01表示试验室 UploadSetting set = GetUploadSettingByModuleID(moduleID); if (set != null) { String sql = "SELECT TestRoomCode,Data FROM dbo.sys_document WHERE ModuleID='" + moduleID + "' AND Status>0"; DataTable dt = GetDataTable(sql); List <String> files = new List <string>(); if (dt != null && dt.Rows.Count > 0) { String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "Temp/TestDataUpload/试验室基本属性"); DeleteDirAllFile(path); if (!Directory.Exists(path)) { try { Directory.CreateDirectory(path); } catch (Exception ee) { logger.Error(ee.Message); } } for (int i = 0; i < dt.Rows.Count; i++) { String testRoomCode = dt.Rows[i]["TestRoomCode"].ToString(); if (testRoomCodeMap.ContainsKey(testRoomCode)) { testRoomCode = testRoomCodeMap[testRoomCode].ToString(); } JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(dt.Rows[i]["Data"].ToString()); String fileName = Path.Combine(path, testRoomCode + ".xml"); if (CreatXMLFile(set, fileName, doc, testRoomCode)) { files.Add(fileName); } doc = null; Thread.Sleep(3000); } if (files.Count > 0) { String zipFile = Path.Combine(path, "试验室基本属性.zip"); if (File.Exists(zipFile)) { try { File.Delete(zipFile); } catch (Exception ex) { logger.Error(ex.Message); } } if (JZCommonHelper.CreateZipFile(files, zipFile)) { FileStream stream = null; stream = new FileInfo(zipFile).OpenRead(); Byte[] buffer = new Byte[stream.Length]; stream.Read(buffer, 0, Convert.ToInt32(stream.Length)); stream.Close(); String result = UploadToServer(uploadAddress, buffer, ksign, jsdwCode); if (result == "1") { logger.Error("试验室综合情况数据上传成功"); } else { logger.Error("试验室综合情况数据上传失败,返回值为:" + result); } } } } else { logger.Error("未找到试验室综合情况信息"); } } else { logger.Error("未找到该模板对应的上传设置"); } } catch (Exception ex) { logger.Error("UploadTestRoomInfo error:" + ex.ToString()); } }
/// <summary> /// 上传人员信息 /// </summary> public void UploadPersonInfo(string strTestRoomCodeMap, String uploadAddress, String jsdwCode) { try { Hashtable testRoomCodeMap = InitTestRoomCodeMap(strTestRoomCodeMap); String moduleID = "08899BA2-CC88-403E-9182-3EF73F5FB0CE"; //试验人员 String ksign = "02"; //02表示试验人员 UploadSetting set = GetUploadSettingByModuleID(moduleID); if (set != null) { String sql = "SELECT ID,TestRoomCode,Data FROM dbo.sys_document WHERE ModuleID='" + moduleID + "' AND Status>0"; DataTable dt = GetDataTable(sql); List <String> files = new List <String>(); if (dt != null && dt.Rows.Count > 0) { String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "Temp/TestDataUpload/试验室人员"); DeleteDirAllFile(path); if (!Directory.Exists(path)) { try { Directory.CreateDirectory(path); } catch (Exception ee) { logger.Error(ee.Message); } } for (int i = 0; i < dt.Rows.Count; i++) { String testRoomCode = dt.Rows[i]["TestRoomCode"].ToString(); DataRow[] drArr = dt.Select(string.Format("TestRoomCode='{0}'", testRoomCode)); if (testRoomCodeMap.ContainsKey(testRoomCode)) { testRoomCode = testRoomCodeMap[testRoomCode].ToString(); } String fileName = Path.Combine(path, testRoomCode + ".xml"); if (CreatMultiXMLFile(set, fileName, drArr, testRoomCode)) { files.Add(fileName); ProcessPersonPhoto(drArr, files, path); foreach (DataRow row in drArr) { dt.Rows.Remove(row); } } drArr = null; Thread.Sleep(3000); } if (files.Count > 0) { String zipFile = Path.Combine(path, "试验室人员.zip"); if (File.Exists(zipFile)) { try { File.Delete(zipFile); } catch (Exception ex) { logger.Error(ex.Message); } } if (JZCommonHelper.CreateZipFile(files, zipFile)) { FileStream stream = null; stream = new FileInfo(zipFile).OpenRead(); Byte[] buffer = new Byte[stream.Length]; stream.Read(buffer, 0, Convert.ToInt32(stream.Length)); stream.Close(); String result = UploadToServer(uploadAddress, buffer, ksign, jsdwCode); if (result == "1") { logger.Error("试验室人员上传成功"); } else { logger.Error("试验室人员上传失败,返回值为:" + result); } } } } else { logger.Error("未找到试验人员信息"); } } else { logger.Error("未找到该模板对应的上传设置"); } } catch (Exception ex) { logger.Error("UploadPersonInfo error:" + ex.ToString()); } }
public void LoadReport() { string DocumentID = "ID".RequestStr(); string SheetIndex = "SI".RequestStr(); string SheetXML = ""; string sheetData = ""; string SheetName = ""; string SheetID = ""; string ReportSheetID = ""; SheetIndex = SheetIndex.IsNullOrEmpty() ? "0" : SheetIndex; try { JZDocument sheetDataAreaCells; List <JZCell> Cells = new List <JZCell>(); #region 查询数据 DataTable _TempTable = new DataTable(); string _TempStr = @" Select testroomcode, m.reportsheetid,d.Data from [dbo].[sys_document] d left outer join [dbo].[sys_module] m on d.ModuleId = m.ID where d.ModuleID = 'E77624E9-5654-4185-9A29-8229AAFDD68B' ANd TestRoomCode = '{0}'"; _TempStr = string.Format(_TempStr, DocumentID); BLL_Document Bll = new BLL_Document(); _TempTable = Bll.GetDataTable(_TempStr); if (_TempTable.Rows.Count > 0) { sheetData = _TempTable.Rows[SheetIndex.Toint()]["Data"].ToString(); sheetDataAreaCells = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(sheetData); SheetCount = _TempTable.Rows.Count; ReportSheetID = _TempTable.Rows[SheetIndex.Toint()]["reportsheetid"].ToString(); foreach (JZSheet Jzs in sheetDataAreaCells.Sheets) { if (Jzs.ID.ToString() == ReportSheetID) { SheetName = Jzs.Name; SheetID = Jzs.ID.ToString(); Cells = Jzs.Cells; break; } } _TempStr = "select SheetXML ,SheetData from sys_sheet where ID = '{0}'"; SheetXML = Bll.ExcuteScalar(string.Format(_TempStr, ReportSheetID)).ToString(); } else { throw new Exception("占无报告数据"); } _TempTable.Clear(); _TempTable.Dispose(); #endregion #region 创建WIN组件 FarPoint.Win.Spread.FpSpread WinSp = new FarPoint.Win.Spread.FpSpread(); WinSp.Sheets.Clear(); SheetXML = JZCommonHelper.GZipDecompressString(SheetXML); int a = SheetXML.Length; FarPoint.Win.Spread.SheetView SheetView = Serializer.LoadObjectXml(typeof(FarPoint.Win.Spread.SheetView), SheetXML, "SheetView") as FarPoint.Win.Spread.SheetView; SheetView.SheetName = "Document"; if (sheetDataAreaCells != null) { foreach (JZCell cell in Cells) { // if (SheetView.Cells[cell.Name].CellType.ToString() == "图片") { SheetView.Cells[cell.Name].ResetCellType(); SheetView.Cells[cell.Name].Value = "<img src='data:image/gif;base64," + cell.Value.ToString().Replace("\r\n", "") + "' />"; } else if (SheetView.Cells[cell.Name].CellType.ToString() == "文本") { SheetView.Cells[cell.Name].Value = cell.Value; } else if (SheetView.Cells[cell.Name].CellType.ToString() == "长文本") { SheetView.Cells[cell.Name].ResetCellType(); SheetView.Cells[cell.Name].Value = cell.Value; } else if (SheetView.Cells[cell.Name].CellType.ToString() == "超链接") { SheetView.Cells[cell.Name].ResetCellType(); if (cell.Value != null) { try { string[] Temp = Newtonsoft.Json.JsonConvert.DeserializeObject <string[]>(cell.Value.ToString()); SheetView.Cells[cell.Name].Value = Temp[0] + "[" + Temp[2] + "]<img src='data:image/gif;base64," + Temp[1].Replace("\r\n", "") + "' />"; } catch { } } } } } WinSp.Sheets.Add(SheetView); WinSp.LoadFormulas(true); #endregion #region 临时文件 string SitePath = Server.MapPath("~/Temp"); DirectoryInfo Dir = new System.IO.DirectoryInfo(SitePath); if (!Dir.Exists) { Dir.Create(); } #endregion #region Save HTML string FileName = SitePath + "/" + SheetID + DateTime.Now.ToString("yyMMddhhmmss") + ".html"; WinSp.ActiveSheet.SaveHtml(FileName); FileInfo FHtml = new System.IO.FileInfo(FileName); FileStream Fs = FHtml.OpenRead(); byte[] Buuff = new byte[Fs.Length]; Fs.Read(Buuff, 0, (int)Fs.Length); Fs.Close(); Fs.Dispose(); string HTML = ASCIIEncoding.UTF8.GetString(Buuff); File.Delete(FileName); #endregion #region show Element StringBuilder Nav = new StringBuilder(); StringBuilder Cont = new StringBuilder(); Nav.Append("<ul class=\"nav nav-tabs\">"); Cont.Append("<div class=\"tab-content\">"); if (SheetCount.Toint() > 1) { for (int i = 0; i < SheetCount; i++) { Nav.Append("<li class=\"" + (i == SheetIndex.Toint() ? "active" : "") + "\" ><a data=\"testroominfo.aspx?ID=" + DocumentID + "&SI=" + i + "&R=" + new Random().Next(0, 100000) + "\" href=\"#t" + i + "\" data-toggle=\"tab\" >第" + (i + 1).ToString() + "</a></li>"); Cont.Append("<div class=\"tab-pane CPane " + (i == SheetIndex.Toint() ? "active" : "") + " \" id=\"t" + i.ToString() + "\">" + ((i == SheetIndex.Toint()) ? HTML : "") + "</div>"); } Nav.Append("</ul>"); Cont.Append("</div>"); form1.InnerHtml = Nav.ToString() + Cont.ToString(); } else { form1.InnerHtml = HTML; } #endregion } catch (Exception ex) { Response.Write(ex.Message.ToString()); } }
private void ProcessDoc(JZDocument doc, FpSpread sp, List <JZFormulaData> CrossSheetLineFormulaInfos) { foreach (SheetView sheet in sp.Sheets) { for (int i = 0; i < sheet.RowCount; i++) { for (int j = 0; j < sheet.ColumnCount; j++) { Cell cell = sheet.Cells[i, j]; cell.Formula = ""; cell.Value = JZCommonHelper.GetCellValue(doc, new Guid(sheet.Tag.ToString()), cell.Column.Label + cell.Row.Label); } } } sp.LoadFormulas(true); foreach (JZFormulaData formula in CrossSheetLineFormulaInfos) { SheetView Sheet = GetSheetByID(sp, formula.SheetIndex); if (Sheet != null) { Cell cell = Sheet.Cells[formula.RowIndex, formula.ColumnIndex]; if (cell != null) { try { if (formula.Formula.ToUpper().Trim() == "NA()") { cell.Formula = ""; } else { cell.Formula = formula.Formula; } } catch (Exception ex) { logger.Error(ex.Message); } } } } sp.LoadFormulas(true); foreach (JZSheet sheet in doc.Sheets) { SheetView view = GetSheetByID(sp, sheet.ID); if (view == null) { continue; } foreach (JZCell dataCell in sheet.Cells) { Cell cell = view.Cells[dataCell.Name]; if (cell != null) { if (String.IsNullOrEmpty(cell.Formula)) { continue; } IGetFieldType FieldTypeGetter = cell.CellType as IGetFieldType; if (FieldTypeGetter != null && FieldTypeGetter.FieldType.Description == "图片") { continue; } else if (FieldTypeGetter != null && FieldTypeGetter.FieldType.Description == "数字") { if (cell.Value != null) { Decimal d; if (Decimal.TryParse(cell.Value.ToString().Trim(' ', '\r', '\n'), out d)) { dataCell.Value = d; } else { dataCell.Value = null; } } } else { dataCell.Value = cell.Value; } if (dataCell.Value != null && dataCell.Value is String) { dataCell.Value = dataCell.Value.ToString().Trim(' ', '\r', '\n'); } } } } }
public void GenerateDBUpdate(DataTable dt) { if (dt != null && dt.Rows.Count > 0) { List <String> newTB = new List <string>(); newTB.Add("dbo.sys_formulas"); newTB.Add("dbo.sys_line_formulas"); newTB.Add("dbo.sys_module"); newTB.Add("dbo.sys_sheet"); newTB.Add("dbo.sys_stadium_config"); Boolean hasNewUpdate = false; for (int i = 0; i < dt.Rows.Count; i++) { String tbName = dt.Rows[i]["TableName"].ToString().ToLower(); String sql = String.Format("SELECT COUNT(1) FROM {0} WHERE Scts_1>'{1}' ", tbName, Convert.ToDateTime(dt.Rows[i]["LastTime"]).ToString("yyyy-MM-dd HH:mm:ss.fff")); if (newTB.Contains(tbName)) { sql = String.Format("SELECT COUNT(1) FROM {0} WHERE LastEditedTime>'{1}' ", tbName, Convert.ToDateTime(dt.Rows[i]["LastTime"]).ToString("yyyy-MM-dd HH:mm:ss.fff")); } sql = String.Format("SELECT COUNT(1) FROM sys_sheet WHERE LastEditedTime>'{0}' ", Convert.ToDateTime(dt.Rows[i]["LastTime"]).ToString("yyyy-MM-dd HH:mm:ss.fff")); Object obj = ExcuteScalar(sql); if (obj != null && obj != DBNull.Value) { hasNewUpdate = Convert.ToInt32(obj) > 0; if (hasNewUpdate) { break; } } } if (hasNewUpdate) { String userName = "******"; String pw = "wdxlzyn@#830"; String server = "ISSDCPLCDMK"; String valid = " -c -S " + server + " -U " + userName + " -P " + pw; String subFolder = GetSubFolder("3"); String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "update\\" + subFolder); String file = Path.Combine(path, "sys_sheet.dat"); String bcp = "bcp \"SELECT * FROM " + Connection.Database + ".dbo.sys_sheet WHERE LastEditedTime > '" + Convert.ToDateTime(dt.Rows[0]["LastTime"]).ToString("yyyy-MM-dd HH:mm:ss.fff") + "' \" queryout " + file + valid; JZCommonHelper.ExeCommand(bcp); String fileName = Yqun.Common.ContextCache.ApplicationContext.Current.UserName + "_" + Yqun.Common.ContextCache.ApplicationContext.Current.Identification.MacAddress + "_" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-fff") + ".zip"; String zipFile = Path.Combine(path, fileName); if (File.Exists(zipFile)) { File.Delete(zipFile); } List <String> list = new List <string>(); list.Add(file); Boolean flag = JZCommonHelper.CreateZipFile(list, zipFile); SaveUpdateInfo(Guid.NewGuid().ToString(), fileName, "3", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); } } }
public bool CreatReportInfoXMLFile(UploadSetting[] setArr, String path, DataRow[] drArr, String trCode, int[] wucArr) { if (File.Exists(path)) { try { File.Delete(path); } catch (Exception ex) { logger.Error(ex.Message); } } XmlDocument xmldoc = new XmlDocument(); xmldoc.LoadXml("<?xml version=\"1.0\" encoding=\"gb2312\"?><ROOT></ROOT>"); //logger.Error("CreatReportInfoXMLFile 0"); for (int i = 0; i < drArr.Length; i++) { //logger.Error("CreatReportInfoXMLFile drArr i" + i); if (setArr[i] != null && setArr[i].Items != null) { //logger.Error("CreatReportInfoXMLFile setArr i" + i); XmlElement root = xmldoc.CreateElement(setArr[i].Name); xmldoc.DocumentElement.AppendChild(root); JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(drArr[i]["Data"].ToString()); XmlElement ele = null; foreach (var item in setArr[i].Items) { ele = xmldoc.CreateElement(item.Name); String value = ""; if (item.NeedSetting) { Object obj = JZCommonHelper.GetCellValue(doc, item.SheetID, item.CellName); if (obj != null) { value = obj.ToString(); } } else { switch (item.Name) { case "F_TRCODE": //试验室编号 value = trCode; break; case "F_NEWVERSION": //试验室编号 value = wucArr[i].ToString(); break; default: break; } } ele.InnerText = value; root.AppendChild(ele); } } } try { xmldoc.Save(path); return(true); } catch (Exception e) { logger.Error(e.Message); return(false); } }
/// <summary> /// 上传试验数据 /// </summary> public void UploadTestDataInfo(string strTestRoomCodeMap, String uploadAddress, String jsdwCode) { try { Hashtable testRoomCodeMap = InitTestRoomCodeMap(strTestRoomCodeMap); // String sql = @"SELECT top 100 ID,TestRoomCode,Data,WillUploadCount,ModuleID,BGBH,CreatedTime FROM dbo.sys_document WHERE // ModuleID NOT IN ('E77624E9-5654-4185-9A29-8229AAFDD68B','08899BA2-CC88-403E-9182-3EF73F5FB0CE', // 'BA23C25D-7C79-4CB3-A0DC-ACFA6C285295') AND Status>0 AND NeedUpload=1 and BGBH is not null and BGBH<>'' ORDER BY CreatedTime ";//排除人员、设备、试验室 String sql = @"SELECT top 100 ID FROM dbo.sys_document WHERE ModuleID NOT IN ('E77624E9-5654-4185-9A29-8229AAFDD68B','08899BA2-CC88-403E-9182-3EF73F5FB0CE', 'BA23C25D-7C79-4CB3-A0DC-ACFA6C285295') AND Status>0 AND NeedUpload=1 and BGBH is not null and BGBH<>'' ORDER BY CreatedTime ";//排除人员、设备、试验室 DataTable dtIDs = GetDataTable(sql); ModuleHelper mh = new ModuleHelper(); DocumentHelper dh = new DocumentHelper(); if (dtIDs != null && dtIDs.Rows.Count > 0) { String ksign = "05";//05表示试验数据 List <String> files = new List <String>(); #region 创建目录 String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "Temp/TestDataUpload/试验数据"); DeleteDirAllFile(path); if (!Directory.Exists(path)) { try { Directory.CreateDirectory(path); } catch (Exception ee) { logger.Error(ee.Message); } } #endregion #region 回收应用程序池 //string strRealPath = System.Web.Hosting.HostingEnvironment.MapPath("~"); //logger.Error("strRealPath:" + strRealPath); //strRealPath = strRealPath.Substring(0, strRealPath.Length - 1); //int LastIndex = strRealPath.LastIndexOf('\\'); //string AppPoolName = strRealPath.Substring(LastIndex + 1, strRealPath.Length - LastIndex - 1); //logger.Error("AppPoolName:" + AppPoolName); //string method = "Recycle"; //try //{ // DirectoryEntry appPool = new DirectoryEntry("IIS://localhost/W3SVC/AppPools"); // DirectoryEntry findPool = appPool.Children.Find(AppPoolName, "IIsApplicationPool"); // findPool.Invoke(method, null); // appPool.CommitChanges(); // appPool.Close(); // logger.Error("应用程序池名称回收成功"); //} //catch (Exception ex) //{ // logger.Error("回收失败:" + ex.Message); //} #endregion StringBuilder strIDs = new StringBuilder(); UploadSetting[] usArr = new UploadSetting[dtIDs.Rows.Count]; DataRow[] docRowArr = new DataRow[dtIDs.Rows.Count]; int[] wucArr = new int[dtIDs.Rows.Count];//WillUploadCount #region 创建资料列表 for (int i = 0; i < dtIDs.Rows.Count; i++) { string strID = dtIDs.Rows[i]["ID"].ToString(); string strSQL = "SELECT ID,TestRoomCode,Data,WillUploadCount,ModuleID,BGBH,CreatedTime FROM dbo.sys_document where ID='" + strID + "'"; DataTable dt = GetDataTable(strSQL); String testRoomCode = dt.Rows[0]["TestRoomCode"].ToString(); string strModuleID = dt.Rows[0]["ModuleID"].ToString(); string strBGBH = dt.Rows[0]["BGBH"].ToString(); string docDateDir = DateTime.Parse(dt.Rows[0]["CreatedTime"].ToString()).ToString("yyyy/MM/dd"); int WillUploadCount = int.Parse(dt.Rows[0]["WillUploadCount"].ToString()); strIDs.AppendFormat("'{0}'", strID); if (i < dt.Rows.Count - 1) { strIDs.Append(","); } Sys_Module module = mh.GetModuleBaseInfoByID(new Guid(strModuleID)); UploadSetting set = module.UploadSetting; if (set != null) { if (testRoomCodeMap.ContainsKey(testRoomCode)) { testRoomCode = testRoomCodeMap[testRoomCode].ToString(); } string strSourceFile = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), string.Format("source/{0}/{1}.pdf", docDateDir, strID)); string strDestFile = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), string.Format("Temp/TestDataUpload/试验数据/{0}_{1}.pdf", testRoomCode, strBGBH)); if (!File.Exists(strSourceFile)) { //logger.Error(string.Format("{1} ID:{0}不存在,生成文件开始", strID, i)); #region 生成PDF和图片 JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(dt.Rows[0]["Data"].ToString()); FpSpread fpSpread = new FpSpread(); //int rIndex = 0; //foreach (JZSheet sheet in doc.Sheets) //{ //if (rIndex == module.ReportIndex) //{ String sheetXML = JZCommonHelper.GZipDecompressString(mh.GetSheetXMLByID(doc.Sheets[module.ReportIndex].ID));// mh.GetSheetXMLByID(sheet.ID); SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), sheetXML, "SheetView") as SheetView; SheetView.Tag = doc.Sheets[module.ReportIndex].ID; SheetView.Cells[0, 0].Value = ""; SheetView.Protect = true; foreach (JZCell dataCell in doc.Sheets[module.ReportIndex].Cells) { Cell cell = SheetView.Cells[dataCell.Name]; if (cell != null) { cell.Value = dataCell.Value; } } fpSpread.Sheets.Add(SheetView); //} //else //{ // //fpSpread.Sheets.Add(null); //} //sheetXML = null; //SheetView = null; // rIndex++; //} //自动生成Excel,图片和报告页的pdf SourceHelper sourceHelper = new SourceHelper(); sourceHelper.CreateRalationFilesSync(fpSpread, doc.ID, module.ReportIndex, docDateDir); fpSpread.Dispose(); doc = null; #endregion logger.Error(string.Format("{1} ID:{0}不存在,生成文件成功", strID, i)); //Thread.Sleep(10000); } else { logger.Error(string.Format("{1} ID:{0}存在,不需要生成文件", strID, i)); } File.Copy(strSourceFile, strDestFile, true); files.Add(strDestFile); usArr[i] = set; docRowArr[i] = dt.Rows[0]; wucArr[i] = WillUploadCount; //JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject<JZDocument>(dt.Rows[i]["Data"].ToString()); //String fileName = Path.Combine(path, dt.Rows[i]["ID"].ToString() + ".xml"); //if (CreatXMLFile(set, fileName, doc, testRoomCode)) //{ // files.Add(fileName); //} } else { usArr[i] = null; docRowArr[i] = dt.Rows[0]; wucArr[i] = WillUploadCount; logger.Error("未找到该模板对应的上传设置,资料ID:" + strID); } } #endregion //logger.Error("reportInfo 0"); String fileName = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "Temp/TestDataUpload/试验数据/reportInfo.xml"); //生成reportInfo.xml CreatReportInfoXMLFile(usArr, fileName, docRowArr, jsdwCode, wucArr); //logger.Error("reportInfo 1"); files.Add(fileName); #region 资料 if (files.Count > 0) { String zipFile = Path.Combine(path, "试验报告.zip"); if (File.Exists(zipFile)) { try { File.Delete(zipFile); } catch (Exception ex) { logger.Error(ex.Message); } } if (JZCommonHelper.CreateZipFile(files, zipFile)) { FileStream stream = null; stream = new FileInfo(zipFile).OpenRead(); Byte[] buffer = new Byte[stream.Length]; stream.Read(buffer, 0, Convert.ToInt32(stream.Length)); stream.Close(); String result = UploadToServer(uploadAddress, buffer, ksign, jsdwCode); if (result == "1") { logger.Error("试验报告上传成功"); if (strIDs.Length > 0) { dh.UpdateDocumentNeedUpload(strIDs.ToString()); } } else { logger.Error("试验报告上传失败,返回值为:" + result); } } } #endregion } else { logger.Info("未找到试验数据信息"); } } catch (Exception ex) { logger.Error("UploadTestDataInfo error:" + ex.ToString()); } }
private void LogDialog_Load(object sender, EventArgs e) { ProgressScreen.Current.ShowSplashScreen(); this.AddOwnedForm(ProgressScreen.Current); InitLogCategoryInfo(); Dictionary <Guid, SheetView> SheetCollection = new Dictionary <Guid, SheetView>(); try { List <FarPoint.CalcEngine.FunctionInfo> Infos = FunctionItemInfoUtil.getFunctionItemInfos(); FpSpread.Sheets.Clear(); if (dataID == Guid.Empty) { return; } JZDocument document = DocumentHelperClient.GetDocumentByID(dataID); JZDocument defaultDocument = ModuleHelperClient.GetDefaultDocument(moduleID); List <JZFormulaData> CrossSheetFormulaInfos = ModuleHelperClient.GetFormulaByModuleIndex(moduleID); foreach (JZSheet sheet in defaultDocument.Sheets) { ProgressScreen.Current.SetStatus = "正在初始化表单‘" + sheet.Name + "’"; String sheetXML = ModuleHelperClient.GetSheetXMLByID(sheet.ID); SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), sheetXML, "SheetView") as SheetView; SheetView.Tag = sheet.ID; SheetView.SheetName = sheet.Name; SheetView.Cells[0, 0].Value = ""; SheetView.Protect = true; FpSpread.Sheets.Add(SheetView); SheetCollection.Add(sheet.ID, SheetView); foreach (FarPoint.CalcEngine.FunctionInfo Info in Infos) { SheetView.AddCustomFunction(Info); } foreach (JZCell dataCellDefault in sheet.Cells) { Cell cell = SheetView.Cells[dataCellDefault.Name]; Object value = JZCommonHelper.GetCellValue(document, sheet.ID, dataCellDefault.Name); Boolean hasValue = true; if (value == null || value.ToString() == "") { hasValue = false; } if (cell != null) { cell.Font = defaultFont; if (cell.CellType is DownListCellType) { DownListCellType CellType = cell.CellType as DownListCellType; CellType.DropDownButton = false; CellType.DesignMode = false; cell.Value = value; } else if (cell.CellType is TextCellType) { TextCellType CellType = cell.CellType as TextCellType; if (CellType.FieldType.Description == FieldType.Text.Description) { CellType.Multiline = true; CellType.WordWrap = true; } CellType.MaxLength = CellType.FieldType.Length; if (hasValue) { cell.Value = value.ToString().Trim('\r', '\n');; } } else if (cell.CellType is LongTextCellType) { LongTextCellType CellType = cell.CellType as LongTextCellType; if (CellType.FieldType.Description == FieldType.LongText.Description) { CellType.Multiline = true; CellType.WordWrap = true; } CellType.MaxLength = CellType.FieldType.Length; if (hasValue) { cell.Value = value.ToString().Trim('\r', '\n');; } } else if (cell.CellType is DateTimeCellType) { DateTimeCellType CellType = cell.CellType as DateTimeCellType; CellType.MinimumDate = new DateTime(1753, 1, 1); CellType.MaximumDate = new DateTime(9999, 12, 31); cell.Value = value; } else if (cell.CellType is RichTextCellType) { RichTextCellType CellType = cell.CellType as RichTextCellType; CellType.Multiline = false; CellType.WordWrap = false; CellType.MaxLength = CellType.FieldType.Length; if (hasValue) { cell.Value = value.ToString().Trim('\r', '\n');; } } else if (cell.CellType is NumberCellType) { NumberCellType CellType = cell.CellType as NumberCellType; CellType.MaximumValue = 999999999.9999; CellType.MinimumValue = -999999999.9999; cell.Value = value; } else if (cell.CellType is MaskCellType) { MaskCellType CellType = cell.CellType as MaskCellType; CellType.Mask = "00000000000000000000000000000000000"; if (CellType.CustomMaskCharacters != null && CellType.CustomMaskCharacters.Length > 0) { CellType.CustomMaskCharacters[0] = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-()()复检"; } cell.Value = value; } else if (cell.CellType is ImageCellType) { if (value != null) { cell.Value = JZCommonHelper.StringToBitmap(value.ToString()); } } else { cell.Value = value; } } } } ProgressScreen.Current.SetStatus = "正在初始化跨表公式..."; foreach (JZFormulaData formula in CrossSheetFormulaInfos) { SheetView Sheet = SheetCollection[formula.SheetIndex]; try { Sheet.Cells[formula.RowIndex, formula.ColumnIndex].Formula = formula.Formula; } catch { } } FpSpread.LoadFormulas(true); ProgressScreen.Current.SetStatus = "正在显示资料..."; UpdateChart(); UpdateEquation(); SetNotes(); //设置只读模式 if (ReadOnly) { foreach (SheetView sheet in FpSpread.Sheets) { sheet.OperationMode = OperationMode.ReadOnly; } } } catch (TimeoutException ex1) { MessageBox.Show("网络原因造成数据无法访问,请检查本机网络连接,或稍后再试!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show("加载试验模板出错!\r\n原因:" + (ex.InnerException != null ? ex.InnerException.Message : ex.Message), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { try { this.RemoveOwnedForm(ProgressScreen.Current); ProgressScreen.Current.CloseSplashScreen(); this.Activate(); } catch (Exception ex1) { } } }
public void LoadReport(string DSource, string DName, string UID, string PWD, string DocumentID) { try { string SheetXML = ""; string sheetData = ""; string SheetName = ""; string SheetID = ""; string ReportIndex = "0"; JZDocument sheetDataAreaCells; List <JZCell> Cells = new List <JZCell>(); #region 查询数据 DataTable _TempTable = new DataTable(); using (SqlConnection _Conn = new SqlConnection("Data Source=" + DSource + ";Initial Catalog=" + DName + ";User ID=" + UID + ";Pwd=" + PWD)) { _Conn.Open(); string _TempStr = "Select m.reportsheetid,d.Data from [dbo].[sys_document] d left outer join [dbo].[sys_module] m on d.ModuleId = m.ID where d.id = '{0}'"; using (SqlCommand _Cmd = new SqlCommand(string.Format(_TempStr, DocumentID), _Conn)) { using (SqlDataAdapter _Adp = new SqlDataAdapter(_Cmd)) { _Adp.Fill(_TempTable); if (_TempTable.Rows.Count > 0) { sheetData = _TempTable.Rows[0]["Data"].ToString(); //ReportIndex = Convert.ToInt32(_TempTable.Rows[0]["reportsheetid"].ToString()); ReportIndex = _TempTable.Rows[0]["reportsheetid"].ToString(); _TempTable.Clear(); _TempTable = new System.Data.DataTable(); sheetDataAreaCells = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(sheetData); _TempStr = "select Name ,SheetXML ,SheetData from sys_sheet where ID = '{0}'"; _Cmd.CommandText = string.Format(_TempStr, ReportIndex); foreach (JZSheet Jzs in sheetDataAreaCells.Sheets) { if (Jzs.ID.ToString() == ReportIndex) { SheetName = Jzs.Name; SheetID = Jzs.ID.ToString(); Cells = Jzs.Cells; } } _Adp.SelectCommand = _Cmd; _Adp.Fill(_TempTable); SheetXML = _TempTable.Rows[0]["SheetXML"].ToString(); } else { throw new Exception("占无报告数据"); } } } _Conn.Close(); } _TempTable.Clear(); _TempTable.Dispose(); #endregion #region 创建WIN组件 FarPoint.Win.Spread.FpSpread WinSp = new FarPoint.Win.Spread.FpSpread(); WinSp.Sheets.Clear(); SheetXML = JZCommonHelper.GZipDecompressString(SheetXML); int a = SheetXML.Length; FarPoint.Win.Spread.SheetView SheetView = Serializer.LoadObjectXml(typeof(FarPoint.Win.Spread.SheetView), SheetXML, "SheetView") as FarPoint.Win.Spread.SheetView; SheetView.SheetName = SheetName; if (sheetDataAreaCells != null) { //for (int i = 0; i < SheetView.RowCount; i++) //{ // for (int j = 0; j < SheetView.ColumnCount; j++) // { // if (SheetView.Cells[i, j].CellType!=null && SheetView.Cells[i, j].CellType.ToString() == "下拉框") // { // SheetView.Cells[i, j].CellType = null; // } // } //} //SheetView.Columns.Remove(16, 4); foreach (JZCell cell in Cells) { dataCells.Add(SheetView.Cells[cell.Name]); SheetView.Cells[cell.Name].Value = cell.Value; } } WinSp.Sheets.Add(SheetView); //dtCellStyle = ModuleHelperClient.GetCellStyleBySheetID(sheetID); //for (int i = 0; i < dtCellStyle.Rows.Count; i++) //{ // if (dtCellStyle.Rows[i]["CellStyle"] != null) // { // JZCellStyle CurrentCellStyle = Newtonsoft.Json.JsonConvert.DeserializeObject<JZCellStyle>(dtCellStyle.Rows[i]["CellStyle"].ToString()); // if (CurrentCellStyle != null) // { // string strCellName = dtCellStyle.Rows[i]["CellName"].ToString(); // FarPoint.Win.Spread.Cell cell = SheetView.Cells[strCellName]; // cell.ForeColor = CurrentCellStyle.ForColor; // cell.BackColor = CurrentCellStyle.BackColor; // cell.Font = new Font(CurrentCellStyle.FamilyName, CurrentCellStyle.FontSize, CurrentCellStyle.FontStyle); // } // } //} WinSp.LoadFormulas(true); UpdateChart(WinSp); UpdateEquation(WinSp); #endregion #region 临时文件 string SitePath = Server.MapPath("~/Temp"); DirectoryInfo Dir = new System.IO.DirectoryInfo(SitePath); if (!Dir.Exists) { Dir.Create(); } #endregion #region Save HTML string FileName = SitePath + "/" + SheetID + DateTime.Now.ToString("yyMMddhhmmss") + ".html"; WinSp.ActiveSheet.SaveHtml(FileName); FileInfo FHtml = new System.IO.FileInfo(FileName); FileStream Fs = FHtml.OpenRead(); byte[] Buuff = new byte[Fs.Length]; Fs.Read(Buuff, 0, (int)Fs.Length); Fs.Close(); Fs.Dispose(); string HTML = ASCIIEncoding.UTF8.GetString(Buuff); html.InnerHtml = HTML; //WinSp.SaveExcel(SitePath + "/" + SheetID + ".xls"); File.Delete(FileName); #endregion #region Save Excel //WinSp.SaveExcel(SitePath + "/222.xls",FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat); //fp1.OpenExcel(SitePath + "/" + SheetID + ".xls"); //fp1.CommandBar.Visible = false; //fp1.Sheets[0].PageSize = fp1.Sheets[0].Rows.Count; //File.Delete(SitePath + "/" + SheetID + ".xlsx"); //fp1.Visible = true; #endregion } catch (Exception ex) { Response.Write(ex.Message.ToString()); //fp1.Visible = false; } finally { } //Response.Write(stopwatch.ElapsedMilliseconds.ToString()); }
private void ButtonUpload_Click(object sender, EventArgs e) { OpenFileDialog FileDialog = new OpenFileDialog(); FileDialog.Filter = "图片文件(*.bmp,*.jpg,*.png)|*.bmp,*.jpg,*.png|所有文件(*.*)|*.*"; FileDialog.FilterIndex = 2; FileDialog.InitialDirectory = Application.StartupPath; FileDialog.RestoreDirectory = true; if (DialogResult.OK == FileDialog.ShowDialog()) { try { Bitmap bitmap = new Bitmap(FileDialog.FileName); int iCellWidth = 800; // (int)view.Cells[cell.Row.Index, cell.Column.Index, cell.Row.Index + cell.RowSpan, cell.Column.Index + cell.ColumnSpan].Column.Width; int iCellHeight = 600; // (int)view.Cells[cell.Row.Index, cell.Column.Index, cell.Row.Index + cell.RowSpan, cell.Column.Index + cell.ColumnSpan].Row.Height; float fCellRate = (float)iCellHeight / iCellWidth; int imgWidth, imgHeight, imgCutWidth, imgCutHeight; imgWidth = bitmap.Width; imgHeight = bitmap.Height; if (imgWidth <= iCellWidth && imgHeight <= iCellHeight) { imgCutWidth = imgWidth; imgCutHeight = imgHeight; } else { float imgRate; imgRate = (float)imgHeight / imgWidth; if (imgRate < fCellRate) {//高小了 if (imgWidth < iCellWidth) { imgCutWidth = imgWidth; } else { imgCutWidth = iCellWidth; } imgCutHeight = (int)(imgCutWidth * imgRate); } else { if (imgHeight < iCellHeight) { imgCutHeight = imgHeight; } else { imgCutHeight = iCellHeight; } imgCutWidth = (int)(imgCutHeight / imgRate); } } Img = JZCommonHelper.KiResizeImage(bitmap, imgCutWidth, imgCutHeight, 0); Preview.Image = Img; } catch (Exception ex) { MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
public bool CreatXMLFile(UploadSetting set, String path, JZDocument doc, String trCode) { if (File.Exists(path)) { try { File.Delete(path); } catch (Exception ex) { logger.Error(ex.Message); } } XmlDocument xmldoc = new XmlDocument(); xmldoc.LoadXml("<?xml version=\"1.0\" encoding=\"gb2312\"?><ROOT></ROOT>"); XmlElement root = xmldoc.CreateElement(set.Name); xmldoc.DocumentElement.AppendChild(root); if (set.Items != null) { XmlElement ele = null; foreach (var item in set.Items) { ele = xmldoc.CreateElement(item.Name); String value = ""; if (item.NeedSetting) { Object obj = JZCommonHelper.GetCellValue(doc, item.SheetID, item.CellName); if (obj != null) { value = obj.ToString(); } } else { switch (item.Name) { case "F_TRCODE": //试验室编号 value = trCode; break; default: break; } } ele.InnerText = value; root.AppendChild(ele); } } try { xmldoc.Save(path); return(true); } catch (Exception e) { logger.Error(e.Message); return(false); } }
private void SheetDesinger_Load(object sender, EventArgs e) { ProgressScreen.Current.ShowSplashScreen(); this.AddOwnedForm(ProgressScreen.Current); ProgressScreen.Current.SetStatus = "正在初始化表单..."; try { Sys_Sheet sheetItem = ModuleHelperClient.GetSheetItemByID(sheetID); FpSpread.Sheets.Clear(); if (ModuleHelperClient.IsContainerXml(sheetItem.SheetXML)) { sheetItem.SheetXML = sheetItem.SheetXML; } else { sheetItem.SheetXML = JZCommonHelper.GZipDecompressString(sheetItem.SheetXML); } SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), sheetItem.SheetXML, "SheetView") as SheetView; SheetView.SheetName = sheetItem.Name; List <FarPoint.CalcEngine.FunctionInfo> Infos = FunctionItemInfoUtil.getFunctionItemInfos(); foreach (FarPoint.CalcEngine.FunctionInfo Info in Infos) { SheetView.AddCustomFunction(Info); } List <JZCell> sheetDataAreaCells = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZCell> >(sheetItem.SheetData); if (sheetDataAreaCells != null) { foreach (JZCell cell in sheetDataAreaCells) { dataCells.Add(SheetView.Cells[cell.Name]); } } FpSpread.Sheets.Add(SheetView); dtCellStyle = ModuleHelperClient.GetCellStyleBySheetID(sheetID); for (int i = 0; i < dtCellStyle.Rows.Count; i++) { if (dtCellStyle.Rows[i]["CellStyle"] != null) { JZCellStyle CurrentCellStyle = Newtonsoft.Json.JsonConvert.DeserializeObject <JZCellStyle>(dtCellStyle.Rows[i]["CellStyle"].ToString()); if (CurrentCellStyle != null) { string strCellName = dtCellStyle.Rows[i]["CellName"].ToString(); Cell cell = SheetView.Cells[strCellName]; cell.ForeColor = CurrentCellStyle.ForColor; cell.BackColor = CurrentCellStyle.BackColor; cell.Font = new Font(CurrentCellStyle.FamilyName, CurrentCellStyle.FontSize, CurrentCellStyle.FontStyle); } } } FpSpread.LoadFormulas(true); fpSheetEditor1.EnableToolStrip(true); UpdateChart(); UpdateEquation(); } catch (Exception ex) { MessageBox.Show("加载表单出错!\r\n原因:" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { this.RemoveOwnedForm(ProgressScreen.Current); ProgressScreen.Current.CloseSplashScreen(); this.Activate(); } }
protected void Button1_Click(object sender, EventArgs e) { sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line; if (sysBaseLine.IsActive == 1) { string SQL = "SELECT * FROM dbo.sys_document WHERE ModuleID='BA23C25D-7C79-4CB3-A0DC-ACFA6C285295' "; DataSet ds = DbHelperSQL.Query(SQL); SQL = " TRUNCATE TABLE biz_machinelist "; DbHelperSQL.Query(SQL); DateTime d_min = DateTime.Parse(SqlDateTime.MinValue.ToString()); DateTime d_max = DateTime.Parse(SqlDateTime.MaxValue.ToString()); if (ds != null) { List <biz_machinelist> list = new List <biz_machinelist>(); foreach (DataRow dr in ds.Tables[0].Rows) { string str = dr["Data"].ToString(); JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(str); if (doc != null) { #region for (int i = 6; i < 32; i++) { biz_machinelist biz = new biz_machinelist(); biz.SCTS = DateTime.Parse(dr["CreatedTime"].ToString()); biz.SCPT = dr["TestRoomCode"].ToString(); //int n=0; //if (Int32.TryParse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "A" + i).ToString(),out n)) //{ // biz.col_norm_A6 = Int32.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "A" + i).ToString()); //} if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "B" + i) != null) { biz.col_norm_B6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "B" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "C" + i) != null) { biz.col_norm_C6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "C" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D" + i) != null) { biz.col_norm_D6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "E" + i) != null) { biz.col_norm_E6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "E" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "F" + i) != null) { biz.col_norm_F6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "F" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G" + i) != null) { biz.col_norm_G6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "H" + i) != null) { DateTime date = new DateTime(); if (DateTime.TryParse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "H" + i).ToString(), out date) == false) { biz.col_norm_H6 = null; } else { if (DateTime.Compare(d_min, DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "H" + i).ToString())) < 0 && DateTime.Compare(d_max, DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "H" + i).ToString())) >= 0) { biz.col_norm_H6 = DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "H" + i).ToString()); } else { biz.col_norm_H6 = null; } } } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "I" + i) != null) { biz.col_norm_I6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "I" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "J" + i) != null) { biz.col_norm_J6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "J" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K" + i) != null) { biz.col_norm_K6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "L" + i) != null) { biz.col_norm_L6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "L" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "M" + i) != null) { biz.col_norm_M6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "M" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "N" + i) != null) { DateTime date = new DateTime(); if (DateTime.TryParse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "N" + i).ToString(), out date) == false) { biz.col_norm_N6 = null; } else { //biz.col_norm_N6 = DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "N" + i).ToString()); if (DateTime.Compare(d_min, DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "N" + i).ToString())) < 0 && DateTime.Compare(d_max, DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "N" + i).ToString())) >= 0) { biz.col_norm_N6 = DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "N" + i).ToString()); } else { biz.col_norm_N6 = null; } } } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "O" + i) != null) { DateTime date = new DateTime(); if (DateTime.TryParse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "O" + i).ToString(), out date) == false) { biz.col_norm_O6 = null; } else { //biz.col_norm_O6 = DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "O" + i).ToString()); if (DateTime.Compare(d_min, DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "O" + i).ToString())) < 0 && DateTime.Compare(d_max, DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "O" + i).ToString())) >= 0) { biz.col_norm_O6 = DateTime.Parse(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "O" + i).ToString()); } else { biz.col_norm_O6 = null; } } } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "P" + i) != null) { biz.col_norm_P6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "P" + i).ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "Q" + i) != null) { biz.col_norm_Q6 = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "Q" + i).ToString(); } if (biz.col_norm_B6 == null && biz.col_norm_C6 == null && biz.col_norm_D6 == null && biz.col_norm_E6 == null && biz.col_norm_F6 == null) { } else { list.Add(biz); } } #endregion } } #region foreach (var item in list) { long n = 0; n = Add(item); } #endregion SQL = "DELETE dbo.biz_machinelist WHERE col_norm_B6='' AND col_norm_C6='' AND col_norm_D6='' AND col_norm_E6='' AND col_norm_F6='' AND col_norm_G6='' "; DbHelperSQL.Query(SQL); Label1.Text = "执行成功"; } } }
/// <summary> /// 保存表单样式 /// </summary> private void SaveSheetStyle() { try { Sys_Sheet sheet = new Sys_Sheet(); sheet.ID = sheetID; sheet.Name = SheetName; sheet.SheetXML = JZCommonHelper.GZipCompressString(Editor.GetActiveSheetXml()); List <JZCell> cells = new List <JZCell>(); List <CellLogic> cellLogicList = new List <CellLogic>(); List <JZFormulaData> cellFormulasList = new List <JZFormulaData>(); //bool bIsKeyDescEmpty = false; #region CellLogic foreach (Cell cell in dataCells) { if (cell == null) { continue; } JZCell c = new JZCell(); c.Name = cell.Column.Label + cell.Row.Label; c.Value = cell.Value; bool bHasExist = false; foreach (JZCell cc in cells) { if (cc.Name == c.Name) { bHasExist = true; break; } } if (bHasExist == true) { continue; } cells.Add(c); CellLogic cl = new CellLogic(); cl.Name = c.Name; JZCellProperty p = cell.Tag as JZCellProperty; if (p != null) { cl.Description = p.Description; cl.IsKey = p.IsKey; cl.IsNotCopy = p.IsNotCopy; cl.IsNotNull = p.IsNotNull; cl.IsPingxing = p.IsPingxing; cl.IsReadOnly = p.IsReadOnly; cl.IsUnique = p.IsUnique; if (cl.IsKey == true && string.IsNullOrEmpty(cl.Description)) { //bIsKeyDescEmpty = true; MessageBox.Show(string.Format("单元格{0}的描述不能为空", c.Name)); return; } } cellLogicList.Add(cl); } #endregion #region Formulas if (FpSpread.Sheets[0] != null) { for (int j = 0; j < FpSpread.Sheets[0].ColumnCount; j++) { for (int m = 0; m < FpSpread.Sheets[0].RowCount; m++) { Cell c = FpSpread.Sheets[0].Cells[m, j]; JZFormulaData cl = new JZFormulaData(); if (c != null) { if (!string.IsNullOrEmpty(c.Formula)) { //logger.Error(string.Format("Name:{0} ColumnIndex:{1} RowIndex:{2} Formula:{3} ", ((char)('A' + c.Column.Index)).ToString() + (c.Row.Index + 1).ToString(), c.Column.Index, c.Row.Index, c.Formula)); cl.ColumnIndex = c.Column.Index; cl.RowIndex = c.Row.Index; cl.Formula = c.Formula; cellFormulasList.Add(cl); } } } } } #endregion sheet.SheetData = Newtonsoft.Json.JsonConvert.SerializeObject(cells); sheet.CellLogic = JZCommonHelper.GZipCompressString(Newtonsoft.Json.JsonConvert.SerializeObject(cellLogicList)); sheet.Formulas = JZCommonHelper.GZipCompressString(Newtonsoft.Json.JsonConvert.SerializeObject(cellFormulasList)); if (ModuleHelperClient.SaveSheet(sheet)) { MessageBox.Show("保存成功。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("保存失败。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("保存失败。" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void lb_img_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { OpenFileDialog _OpenFileDialog = new OpenFileDialog(); _OpenFileDialog.Filter = "图片文件(*.jpg,*.gif,*.bmp)|*.jpg|*.gif|*.bmp"; //int MAX_IMAGE_SIZE = 100;//图片最大上传大小,单位KB int MAX_IMAGE_WIDTH = 800; //图片最大宽度 int MAX_IMAGE_HEIGHT = 600; //图片最大高度 float MAX_RATE = (float)MAX_IMAGE_HEIGHT / MAX_IMAGE_WIDTH; //高宽比 if (_OpenFileDialog.ShowDialog() == DialogResult.OK) { MemoryStream tempms = new MemoryStream(File.ReadAllBytes(_OpenFileDialog.FileName)); //long size = tempms.Length / 1024; //if (size > MAX_IMAGE_SIZE) //{ // MessageBox.Show(string.Format("图片大小不能超出{0}KB", MAX_IMAGE_SIZE), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} Bitmap bitmap = new Bitmap(tempms); #region 判断要裁剪的图片的高度 int imgWidth, imgHeight, imgCutWidth, imgCutHeight; imgWidth = bitmap.Width; imgHeight = bitmap.Height; if (imgWidth <= MAX_IMAGE_WIDTH && imgHeight <= MAX_IMAGE_HEIGHT) { imgCutWidth = imgWidth; imgCutHeight = imgHeight; } else { float imgRate; imgRate = (float)imgHeight / imgWidth; if (imgRate < MAX_RATE) {//高小了 if (imgWidth < MAX_IMAGE_WIDTH) { imgCutWidth = imgWidth; } else { imgCutWidth = MAX_IMAGE_WIDTH; } imgCutHeight = (int)(imgCutWidth * imgRate); } else { if (imgHeight < MAX_IMAGE_HEIGHT) { imgCutHeight = imgHeight; } else { imgCutHeight = MAX_IMAGE_HEIGHT; } imgCutWidth = (int)(imgCutHeight / imgRate); } } #endregion Bitmap imgCut = JZCommonHelper.KiResizeImage(bitmap, imgCutWidth, imgCutHeight, 0); //ImageCodecInfo jgpEncoder = GetEncoder(ImageFormat.Jpeg); //System.Drawing.Imaging.Encoder myEncoder = // System.Drawing.Imaging.Encoder.Quality; //EncoderParameters myEncoderParameters = new EncoderParameters(1); //EncoderParameter myEncoderParameter = new EncoderParameter(myEncoder, 100L); //myEncoderParameters.Param[0] = myEncoderParameter; //using (MemoryStream stream = new MemoryStream()) //{ // b.Save(stream, jgpEncoder, myEncoderParameters); // b = new Bitmap(stream); //} MemoryStream stream = new MemoryStream(); imgCut.Save(stream, ImageFormat.Jpeg); JZFile file = new JZFile(); file.FileData = stream.ToArray(); String newImgID = DocumentHelperClient.SaveInvalidImage(invalidReportID, file, GetSeletedText()); if (newImgID != "") { //AddImage(new Bitmap(tempms), tabControl1.SelectedIndex, newImgID, true); AddImage(new Bitmap(stream), tabControl1.SelectedIndex, newImgID, true); tempms.Close(); tempms.Dispose(); stream.Close(); stream.Dispose(); } else { MessageBox.Show("图片上传失败"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { String id = Request.Params["id"]; if (!String.IsNullOrEmpty(id)) { sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line; if (sysBaseLine.IsActive == 0) { #region BLL_UserInfo bll = new BLL_UserInfo(); DataTable dt = bll.GetUserInfo(id); if (dt != null && dt.Rows.Count > 0) { lbl_xingming.Text = dt.Rows[0]["col_norm_D6"].ToString(); lbl_xingbie.Text = dt.Rows[0]["col_norm_G6"].ToString(); lbl_nianling.Text = dt.Rows[0]["col_norm_K6"].ToString(); lbl_jishuzhicheng.Text = dt.Rows[0]["col_norm_D7"].ToString(); lbl_zhiwu.Text = dt.Rows[0]["col_norm_G7"].ToString(); lbl_gongzuonianxian.Text = dt.Rows[0]["col_norm_K7"].ToString(); lbl_zhuanye.Text = dt.Rows[0]["col_norm_D8"].ToString(); lbl_xueli.Text = dt.Rows[0]["col_norm_G8"].ToString(); try { lbl_biyeshijian.Text = Convert.ToDateTime(dt.Rows[0]["col_norm_K8"].ToString()).ToShortDateString(); } catch { lbl_biyeshijian.Text = dt.Rows[0]["col_norm_K8"].ToString(); } lbl_lianxidianhua.Text = dt.Rows[0]["col_norm_D9"].ToString(); lbl_biyexuexiao.Text = dt.Rows[0]["col_norm_G9"].ToString(); //dt.Rows[0]["col_norm_L6"].ToString() #region StringBuilder sb1 = new StringBuilder(); if (!string.IsNullOrEmpty(dt.Rows[0]["col_norm_L6"].ToString())) { string pathname = dt.Rows[0]["ID"].ToString(); string fullPath = Server.MapPath("../userphoto/ ") + pathname + ".jpg"; if (!File.Exists(fullPath)) { object o = dt.Rows[0]["col_norm_L6"]; var _tempMemoryStream = new MemoryStream((byte[])o); System.Drawing.Image img = System.Drawing.Image.FromStream(_tempMemoryStream); img.Save(fullPath); _tempMemoryStream.Close(); } else { } sb1.Append("<img width=\"130px\" height=\"165px\" src=\"../userphoto/" + pathname + ".jpg\" />"); } else { sb1.Append("<img width=\"130px\" height=\"165px\" src=\"../images/nohead.png\" />"); } Literal3.Text = sb1.ToString(); #endregion #region if (!String.IsNullOrEmpty(dt.Rows[0]["col_norm_B14"].ToString())) { StringBuilder sb = new StringBuilder(); for (int i = 14; i < 28; i++) { if (!String.IsNullOrEmpty(dt.Rows[0]["col_norm_B" + i + ""].ToString())) { sb.Append("<tr><td colspan=\"2\">" + dt.Rows[0]["col_norm_B" + i + ""].ToString() + "</td>"); sb.Append("<td colspan=\"3\">" + dt.Rows[0]["col_norm_E" + i + ""].ToString() + "</td>"); sb.Append("<td>" + dt.Rows[0]["col_norm_K" + i + ""].ToString() + "</td>"); sb.Append("<td>" + dt.Rows[0]["col_norm_M" + i + ""].ToString() + "</td></tr>"); } } Literal1.Text = sb.ToString(); } else { tr_gzjl.Style["display"] = "none"; tr_gzjl_mx.Style["display"] = "none"; } if (!String.IsNullOrEmpty(dt.Rows[0]["col_norm_B31"].ToString())) { StringBuilder sb = new StringBuilder(); for (int i = 31; i < 37; i++) { if (!String.IsNullOrEmpty(dt.Rows[0]["col_norm_B" + i + ""].ToString())) { sb.Append("<tr><td colspan=\"2\">" + dt.Rows[0]["col_norm_B" + i + ""].ToString() + "</td>"); sb.Append("<td colspan=\"4\">" + dt.Rows[0]["col_norm_E" + i + ""].ToString() + "</td>"); try { string[] Temp = Newtonsoft.Json.JsonConvert.DeserializeObject <string[]>(dt.Rows[0]["col_norm_K" + i + ""].ToString()); sb.Append("<td>" + Temp[0] + "<img src='data:image/gif;base64," + Temp[1] + "' /></td></tr>"); } catch { sb.Append("<td>" + dt.Rows[0]["col_norm_K" + i + ""].ToString() + "' /></td></tr>"); } } } Literal2.Text = sb.ToString(); } else { tr_pxjl.Style["display"] = "none"; tr_pxjl_mx.Style["display"] = "none"; } #endregion } #endregion } else { string SQL = "SELECT * FROM dbo.sys_document WHERE ID='" + id + "'"; DataSet ds = DbHelperSQL.Query(SQL); string str = ds.Tables[0].Rows[0]["Data"].ToString(); JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(str); if (doc != null) { #region if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D6") != null) { lbl_xingming.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D6").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G6") != null) { lbl_xingbie.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G6").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K6") != null) { lbl_nianling.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K6").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D7") != null) { lbl_jishuzhicheng.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D7").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G7") != null) { lbl_zhiwu.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G7").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K7") != null) { lbl_gongzuonianxian.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K7").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D8") != null) { lbl_zhuanye.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D8").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G8") != null) { lbl_xueli.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G8").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K8") != null) { lbl_biyeshijian.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K8").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D9") != null) { lbl_lianxidianhua.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D9").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G9") != null) { lbl_biyexuexiao.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "G9").ToString(); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D10") != null) { lbl_idcard.Text = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "D10").ToString(); } #endregion #region if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "B14") != null) { StringBuilder sb = new StringBuilder(); for (int i = 14; i < 28; i++) { if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "B" + i + "") != null) { sb.Append("<tr><td colspan=\"2\">" + JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "B" + i + "").ToString() + "</td>"); } else { sb.Append("<tr><td colspan=\"2\"></td>"); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "E" + i + "") != null) { sb.Append("<td colspan=\"3\">" + JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "E" + i + "").ToString() + "</td>"); } else { sb.Append("<td colspan=\"3\"></td>"); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K" + i + "") != null) { sb.Append("<td>" + JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K" + i + "").ToString() + "</td>"); } else { sb.Append("<td></td>"); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "M" + i + "") != null) { sb.Append("<td>" + JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "M" + i + "").ToString() + "</td></tr>"); } else { sb.Append("<td></td></tr>"); } } Literal1.Text = sb.ToString(); } else { tr_gzjl.Style["display"] = "none"; tr_gzjl_mx.Style["display"] = "none"; } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "B31") != null) { StringBuilder sb = new StringBuilder(); for (int i = 31; i < 37; i++) { if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "B" + i + "") != null) { sb.Append("<tr><td colspan=\"2\">" + JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "B" + i + "").ToString() + "</td>"); } else { sb.Append("<tr><td colspan=\"2\"></td>"); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "E" + i + "") != null) { sb.Append("<td colspan=\"4\">" + JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "E" + i + "").ToString() + "</td>"); } else { sb.Append("<td colspan=\"4\"></td>"); } if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K" + i + "") != null) { try { string[] Temp = Newtonsoft.Json.JsonConvert.DeserializeObject <string[]>(JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K" + i + "").ToString()); System.Drawing.Image img = BizCommon.JZCommonHelper.StringToBitmap(Temp[1]); sb.Append("<td>" + Temp[0] + " <a title=\"点击查看大图\" href=\"javascript:Show('" + id + "','" + doc.Sheets[0].ID.ToString() + "'," + i + ")\"><img src='data:image/gif;base64," + Temp[1] + "' height=\"30px;\" /></a></td>"); } catch { if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K" + i + "").ToString() != "[null,null,null]") { sb.Append("<td>" + JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "K" + i + "").ToString() + "</td>"); } else { sb.Append("<td></td>"); } } } else { sb.Append("<td></td>"); } } Literal2.Text = sb.ToString(); } else { tr_pxjl.Style["display"] = "none"; tr_pxjl_mx.Style["display"] = "none"; } #endregion #region StringBuilder sb1 = new StringBuilder(); if (JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "L6") != null) { string pathname = id; string fullPath = Server.MapPath("../userphoto/ ") + pathname + ".jpg"; if (!File.Exists(fullPath)) { object o = JZCommonHelper.GetCellValue(doc, doc.Sheets[0].ID, "L6"); System.Drawing.Image img = null; byte[] bitmapBytes = System.Convert.FromBase64String(o.ToString()); using (MemoryStream memoryStream = new MemoryStream(bitmapBytes)) { img = System.Drawing.Image.FromStream(memoryStream); img.Save(fullPath); memoryStream.Close(); } } //else //{ // sb1.Append("<img width=\"130px\" height=\"165px\" src=\"../images/nohead.png\" />"); //} sb1.Append("<img width=\"130px\" height=\"165px\" src=\"../userphoto/" + pathname + ".jpg\" />"); } else { sb1.Append("<img width=\"130px\" height=\"165px\" src=\"../images/nohead.png\" />"); } Literal3.Text = sb1.ToString(); #endregion } } } } }