/// <summary> /// 新的上传采集数据到工管中心的接口 /// </summary> protected void UploadCaiJiData(JZDocument doc, Sys_Module ModuleBase, Guid TestDataID, string MachineCode, int SeriaNumber, string TestData, string UserName, string RealTimeData, string TestRoomCode) { String lineAddress = "net.tcp://" + IPAddress + ":" + Port + "/TransferService.svc"; CallRemoteServerMethod(lineAddress, "Yqun.BO.BusinessManager.dll", "UploadCaiJiData", new Object[] { doc, ModuleBase, TestDataID, MachineCode, SeriaNumber, TestData, UserName, RealTimeData, TestRoomCode }); }
/// <summary> /// 获取压力数据实例对象 /// </summary> /// <param name="doc"></param> /// <param name="moduleID"></param> /// <param name="stadiumID"></param> /// <param name="wtbh"></param> /// <param name="testRoomCode"></param> /// <param name="seriaNumber"></param> /// <param name="userName"></param> /// <param name="cells"></param> /// <param name="realTimeData"></param> /// <param name="machineBH"></param> /// <returns></returns> private EMCServiceReference.PressureData GetPressureDataModel(JZDocument doc, Guid moduleID, Guid stadiumID, String wtbh, String testRoomCode, Int32 seriaNumber, String userName, List <JZTestCell> cells, String realTimeData, string machineBH) { EMCServiceReference.PressureData _PressureDataModel = new EMCServiceReference.PressureData(); try { _PressureDataModel.FGuid = System.Guid.NewGuid().ToString(); _PressureDataModel.FIswjj = "0"; _PressureDataModel.FKylz = Convert.ToDouble(cells[0].Value.ToString()); DataTable _dt = _StadiumHelper.GetStadiumByID(stadiumID); if (_dt != null && _dt.Rows.Count > 0) { string tempRealTimeData = GetYSLZ(realTimeData); _PressureDataModel.FLq = int.Parse(_dt.Rows[0]["DateSpan"].ToString()); _PressureDataModel.FOperator = userName; _PressureDataModel.FQddj = _dt.Rows[0]["F_Added"].ToString(); _PressureDataModel.FRtcode = GetModuleEMCRTCode(moduleID); _PressureDataModel.FSbbh = machineBH; _PressureDataModel.FSjbh = _dt.Rows[0]["F_SJBH"].ToString(); _PressureDataModel.FSjcc = GetSJCCMethod(_dt.Rows[0]["F_SJBH"].ToString()); _PressureDataModel.FSoftcom = "北京金舟神创科技发展有限公司"; _PressureDataModel.FSysj = tempRealTimeData.Split('|')[0]; _PressureDataModel.FVender = "北京金舟神创科技发展有限公司"; _PressureDataModel.FWtbh = wtbh; _PressureDataModel.FYskylz = tempRealTimeData.Split('|')[1]; } } catch (Exception ex) { logger.Error(ex.ToString()); } return(_PressureDataModel); }
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>"); } } } } }
public JZDocument GetDefaultDocument(Guid moduleID) { String sql = @"SELECT a.ID,b.SheetID,c.SheetData,c.Name FROM dbo.sys_module a JOIN dbo.sys_module_sheet b ON a.ID = b.ModuleID JOIN dbo.sys_sheet c ON b.SheetID = c.ID where a.ID='" + moduleID + "' order by b.SortIndex"; JZDocument doc = new JZDocument(); try { DataTable dt = GetDataTable(sql); if (dt != null && dt.Rows.Count > 0) { doc.ID = Guid.Empty; foreach (DataRow row in dt.Rows) { JZSheet sheet = new JZSheet(); sheet.ID = new Guid(row["SheetID"].ToString()); sheet.Name = row["Name"].ToString(); sheet.Cells = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZCell> >(row["SheetData"].ToString()); doc.Sheets.Add(sheet); } } } catch (Exception e) { logger.Error(e.Message); } return(doc); }
/// <summary> /// 旧的上传到工管中心的接口 /// </summary> protected void UploadLabDocBasic(JZDocument doc, Sys_Module ModuleBase, string UserName, string TestRoomCode) { String lineAddress = "net.tcp://" + IPAddress + ":" + Port + "/TransferService.svc"; CallRemoteServerMethod(lineAddress, "Yqun.BO.BusinessManager.dll", "UploadLabDocBasic", new Object[] { doc, ModuleBase, UserName, TestRoomCode }); }
public void SetColumnFromSelector(int row, int sheetColumn, int cellColumn) { if (DocumentCache == null) { DocumentCache = ModuleHelperClient.GetDefaultDocument(SelectionModuleID); if (SheetsCache == null && DocumentCache != null) { SheetsCache = new SheetView[DocumentCache.Sheets.Count]; for (var i = 0; i < SheetsCache.Length; i++) { var xml = ModuleHelperClient.GetSheetXMLByID(DocumentCache.Sheets[i].ID); var sheet = Serializer.LoadObjectXml(typeof(SheetView), xml, "SheetView") as SheetView; sheet.SheetName = DocumentCache.Sheets[i].Name; SheetsCache[i] = sheet; } } } var selector = new CellSelector(CurrentModule.ID, "", Guid.Empty); selector.Preloading(SheetsCache, DocumentCache); if (DialogResult.OK == selector.ShowDialog()) { TableStatistics.ActiveSheet.Cells[row, sheetColumn].Value = selector.SheetName; TableStatistics.ActiveSheet.Cells[row, sheetColumn].Tag = selector.SheetID; TableStatistics.ActiveSheet.Cells[row, cellColumn].Value = selector.CellName; TableStatistics.ActiveSheet.Cells[row, cellColumn].Tag = selector.CellName; } }
/// <summary> /// 旧的上传到工管中心的接口 /// </summary> protected bool UpdateToEMC(JZDocument doc, Guid moduleID, Guid stadiumID, String wtbh, String testRoomCode, Int32 seriaNumber, String userName, List <JZTestCell> cells, String realTimeData, string machineBH) { String lineAddress = "net.tcp://" + IPAddress + ":" + Port + "/TransferService.svc"; bool bSuccess = bool.Parse(CallRemoteServerMethod(lineAddress, "Yqun.BO.BusinessManager.dll", "UpdateToEMC", new Object[] { doc, moduleID, stadiumID, wtbh, testRoomCode, seriaNumber, userName, cells, realTimeData, machineBH }).ToString()); return(bSuccess); }
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); }
public void RoomInfo() { string Sql = "select data from sys_document where moduleid ='E77624E9-5654-4185-9A29-8229AAFDD68B' AND testroomcode='" + "RoomID".RequestStr() + "'"; DataSet Ds = GetDs(Sql); if (Ds.Tables.Count > 0 && Ds.Tables[0].Rows.Count > 0) { doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(Ds.Tables[0].Rows[0][0].ToString()); } else { doc = new JZDocument(); } }
private void TableModules_SelectionChanged(object sender, FarPoint.Win.Spread.SelectionChangedEventArgs e) { DocumentCache = null; SheetsCache = null; SelectionModule = null; NeedSynchronous = false; SelectionModuleID = GetSelectionModuleID(); if (Modules != null) { SelectionModule = Modules.Rows.Find(SelectionModuleID); } SetStatisticsTable(); }
public bool ProcessExtension(JZDocument sheet, StatisticsModuleSetting map, List <StatisticsSetting> columns, DataRow document, Sys_Module module, Dictionary <string, Object> result) { var documentID = new Guid(Convert.ToString(document["ID"])); switch (map.StatisticsItemName) { case "报告日期": return(true); case "厂家名称": return(ProcessFactory(documentID, module, result, sheet)); case "试验人员": case "设备厂家": case "设备型号": case "仪表型号": var device = CallLocalMethod(Uri, DLL, "PickOneAcquisition", new object[] { documentID }) as DataTable; if (device == null || device.Rows.Count == 0) { Logger.Info("获取 " + map.StatisticsItemName + " 到空值"); return(true); } var userName = Convert.ToString(device.Rows[0]["UserName"]); var machineCode = Convert.ToString(device.Rows[0]["MachineCode"]); var item = columns.Find(m => m.ItemName == map.StatisticsItemName); if (item == null) { Logger.Info("在统计项中获取名为 " + map.StatisticsItemName + " 的项为空"); return(true); } switch (map.StatisticsItemName) { case "试验人员": result[item.BindField] = userName; break; default: result[item.BindField] = machineCode; break; } return(true); } return(false); }
public void Qualify(JZDocument document, Sys_Module module) { ThreadParameter p = new ThreadParameter(); p.document = document; p.module = module; p.IsAdministrator = ApplicationContext.Current.IsAdministrator; p.LineID = ApplicationContext.Current.InProject.Index; p.TestRoomCode = ApplicationContext.Current.InTestRoom.Code; p.SegmentName = ApplicationContext.Current.InSegment.Description; p.CompanyName = ApplicationContext.Current.InCompany.Description; p.TestRoomName = ApplicationContext.Current.InTestRoom.Description; p.LineName = ApplicationContext.Current.InProject.Description; ThreadPool.QueueUserWorkItem(new WaitCallback(Execute), p); }
/// <summary> /// 获取万能机数据实例对象 /// </summary> /// <param name="doc"></param> /// <param name="moduleID"></param> /// <param name="stadiumID"></param> /// <param name="wtbh"></param> /// <param name="testRoomCode"></param> /// <param name="seriaNumber"></param> /// <param name="userName"></param> /// <param name="cells"></param> /// <param name="realTimeData"></param> /// <param name="machineBH"></param> /// <returns></returns> private EMCServiceReference.UniversalData GetUniversalDataModel(JZDocument doc, Guid moduleID, Guid stadiumID, String wtbh, String testRoomCode, Int32 seriaNumber, String userName, List <JZTestCell> cells, String realTimeData, string machineBH) { EMCServiceReference.UniversalData _UniversalDataModel = new EMCServiceReference.UniversalData(); try { DataTable _dt = _StadiumHelper.GetStadiumByID(stadiumID); if (_dt != null && _dt.Rows.Count > 0) { string tempRealTimeData = GetYSLZ(realTimeData); _UniversalDataModel.FArea = ((Math.Pow(Convert.ToDouble(_dt.Rows[0]["F_SJSize"].ToString()), 2.0)) / 4 * 3.1415926); _UniversalDataModel.FGczj = int.Parse(_dt.Rows[0]["F_SJSize"].ToString()); _UniversalDataModel.FGuid = System.Guid.NewGuid().ToString(); for (int i = 0; i < cells.Count; i++) { if (cells[i].Name == JZTestEnum.LDZDL) { _UniversalDataModel.FLz = Convert.ToDouble(cells[i].Value.ToString()); } if (cells[i].Name == JZTestEnum.QFL) { _UniversalDataModel.FQflz = Convert.ToDouble(cells[i].Value.ToString()); } if (cells[i].Name == JZTestEnum.DHBJ) { _UniversalDataModel.FScl = (Convert.ToDouble(cells[i].Value.ToString()) - Convert.ToDouble(_dt.Rows[0]["F_SJSize"].ToString()) * 5) / Convert.ToDouble(_dt.Rows[0]["F_SJSize"].ToString()) * 5; } } _UniversalDataModel.FOperator = userName; _UniversalDataModel.FPzcode = ""; _UniversalDataModel.FRtcode = GetModuleEMCRTCode(moduleID); _UniversalDataModel.FSbbh = machineBH; _UniversalDataModel.FSjbh = _dt.Rows[0]["F_SJBH"].ToString(); _UniversalDataModel.FSoftcom = "北京金舟神创科技发展有限公司"; _UniversalDataModel.FSysj = tempRealTimeData.Split('|')[0]; _UniversalDataModel.FVender = "北京金舟神创科技发展有限公司"; _UniversalDataModel.FWtbh = wtbh; _UniversalDataModel.FWy = "0"; _UniversalDataModel.FYskllz = tempRealTimeData.Split('|')[1]; } } catch (Exception ex) { logger.Error(ex.ToString()); } return(_UniversalDataModel); }
public void LoadReport(string DSource, string DName, string UID, string PWD, string TestRoomCode) { try { string _TempStr = @" Select m.reportsheetid,d.Data from [dbo].[sys_document] d join [dbo].[sys_module] m on d.ModuleId = m.ID AND m.ID ='E77624E9-5654-4185-9A29-8229AAFDD68B' where testroomcode ='{0}' "; #region 查询数据 DataSet Ds = new DataSet(); using (SqlConnection _Conn = new SqlConnection("Data Source=" + DSource + ";Initial Catalog=" + DName + ";User ID=" + UID + ";Pwd=" + PWD)) { _Conn.Open(); using (SqlCommand _Cmd = new SqlCommand(string.Format(_TempStr, TestRoomCode), _Conn)) { using (SqlDataAdapter _Adp = new SqlDataAdapter(_Cmd)) { _Adp.Fill(Ds); if (Ds.Tables[0].Rows.Count > 0) { sheetDataAreaCells = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(Ds.Tables[0].Rows[0]["Data"].ToString()); } else { throw new Exception("占无报告数据"); } } } _Conn.Close(); } #endregion } catch (Exception ex) { Response.Write(ex.Message.ToString()); } }
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); } }
private void DealCaiJi(String DBName, Guid DataID, Guid moduleID) { String docString = DBHelper.CallLocalService("Yqun.BO.BusinessManager.dll", "GetDocumentByID", new object[] { DataID }, DBName).ToString(); JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(docString); if (doc != null) { FpSpread sp = ModuleCatch.GetModuleByID(moduleID, doc, DBName); if (sp == null) { return; } List <JZFormulaData> CrossSheetLineFormulaInfos = DBHelper.CallLocalService("Yqun.BO.BusinessManager.dll", "GetLineFormulaByModuleIndex", new object[] { moduleID }, DBName) as List <JZFormulaData>; ProcessDoc(doc, sp, CrossSheetLineFormulaInfos); DBHelper.CallLocalService("Yqun.BO.BusinessManager.dll", "SyncSaveDoc", new object[] { doc, moduleID }, DBName); } else { logger.Info("【" + DBName + "】,[" + DataID + "] DealCaiJi is empty."); } }
/// <summary> /// 上传数据到工管中心 /// </summary> /// <param name="doc"></param> /// <param name="moduleID"></param> /// <param name="stadiumID"></param> /// <param name="wtbh"></param> /// <param name="testRoomCode"></param> /// <param name="seriaNumber"></param> /// <param name="userName"></param> /// <param name="cells"></param> /// <param name="realTimeData"></param> /// <param name="machineBH"></param> /// <returns></returns> public bool UpdateToEMC(JZDocument doc, Guid moduleID, Guid stadiumID, String wtbh, String testRoomCode, Int32 seriaNumber, String userName, List <JZTestCell> cells, String realTimeData, string machineBH) { string tempMachineType = GetModuleTypeByID(moduleID); string _ErrorMsg = string.Empty; EMCServiceReference.DataInterfaceClient _DataInterfaceClient = new Yqun.BO.BusinessManager.EMCServiceReference.DataInterfaceClient(); if (tempMachineType == "1") { if (_DataInterfaceClient.UploadPressureData(out _ErrorMsg, GetPressureDataModel(doc, moduleID, stadiumID, wtbh, testRoomCode, seriaNumber, userName, cells, realTimeData, machineBH)) == -1) { logger.Error("上传工管中心压力机数据错误:" + _ErrorMsg); } } if (tempMachineType == "2") { if (_DataInterfaceClient.UploadUniversalData(out _ErrorMsg, GetUniversalDataModel(doc, moduleID, stadiumID, wtbh, testRoomCode, seriaNumber, userName, cells, realTimeData, machineBH)) == -1) { logger.Error("上传工管中心万能机数据错误:" + _ErrorMsg); } } return(false); }
public void SaveEditLog(JZDocument oldDoc, JZDocument newDoc, String optType, Boolean relationRequestChange, Sys_Document docBase) { ThreadParameter p = new ThreadParameter(); p.OldDoc = oldDoc; p.NewDoc = newDoc; ApplicationContext context = ApplicationContext.Current; p.UserName = context.UserName; p.IsAdministrator = context.IsAdministrator; p.OptType = optType; p.RelationRequestChange = relationRequestChange; p.DocBase = docBase; p.LineID = ApplicationContext.Current.InProject.Index; p.TestRoomCode = ApplicationContext.Current.InTestRoom.Code; p.SegmentName = ApplicationContext.Current.InSegment.Description; p.CompanyName = ApplicationContext.Current.InCompany.Description; p.TestRoomName = ApplicationContext.Current.InTestRoom.Description; p.LineName = ApplicationContext.Current.InProject.Description; ThreadPool.QueueUserWorkItem(new WaitCallback(Execute), p); }
public bool ProcessFactory(Guid documentID, Sys_Module module, Dictionary <string, Object> result, JZDocument document) { var factoryName = ""; var factorySet = module.StatisticsSettings.Find(m => m.BindField == "FactoryName"); if (factorySet == null) { Logger.Error("获取到的厂家名称配置项为空"); return(true); } factoryName = GetCellValue(document.Sheets.Find(m => m.ID == factorySet.SheetID), factorySet.CellName) as string; if (string.IsNullOrEmpty(factoryName)) { Logger.Error("获取到的厂家名称为空, DocumentID:" + documentID); return(true); } Sys_Factory factory = null; if (Factories.ContainsKey(factoryName)) { factory = Factories[factoryName]; } else { var table = CallLocalMethod(Uri, DLL, "GetFactoryByName", new object[] { factoryName }) as DataTable; if (table == null || table.Rows.Count == 0) { factory = new Sys_Factory(); factory.FactoryID = Guid.NewGuid(); factory.FactoryName = factoryName; factory.CreateTime = DateTime.Now; var resultNewFactory = CallLocalMethod(Uri, DLL, "NewFactory", new object[] { factory }) as string; if (string.IsNullOrEmpty(resultNewFactory)) { Factories[factoryName] = factory; } else { Logger.Error("添加厂家时失败, 信息:" + resultNewFactory); } } else { factory = new Sys_Factory(); factory.FactoryID = new Guid(Convert.ToString(table.Rows[0]["FactoryID"])); factory.FactoryName = Convert.ToString(table.Rows[0]["FactoryName"]); } } if (factory != null) { result["FactoryID"] = factory.FactoryID; result["FactoryName"] = factoryName; } return(true); }
public void Preloading(SheetView[] sheets, JZDocument document) { LoadSheets = sheets; LoadDocument = document; }
/// <summary> /// 将要Post给铁道部的数据进行打包 /// </summary> /// <param name="posturl">上传URL</param> /// <param name="documentID">资料ID</param> /// <param name="moduleID">模板ID</param> /// <param name="stadiumID">龄期ID</param> /// <param name="wtbh">委托编号</param> /// <param name="testRoomCode">实验室编码</param> /// <param name="seriaNumber">当前试验组数或根数</param> /// <param name="userName">用户名称</param> /// <param name="testData">试验数据</param> /// <param name="realTimeData">实时数据</param> /// <param name="totalNumber">总组数或根数</param> /// <returns></returns> public string PostDataToTDB(JZDocument doc, Guid moduleID, Guid stadiumID, String wtbh, String testRoomCode, Int32 seriaNumber, String userName, List <JZTestCell> cells, String realTimeData, string machineBH, string UpdloadInfo, string UploadCode) { string postUrl = string.Empty; string json = string.Empty; string QMjson = string.Empty; try { logger.Error("开始执行:PostData方法"); //将具体的试验数据生成json字符串并进行64位加密 string tempRealTimeData = GetYSLZ(realTimeData); if (_StringBuilder.Length > 0) { _StringBuilder.Remove(0, _StringBuilder.Length); } logger.Error("开始拼接字符串"); _StringBuilder.Append("MK=2&"); string tempMachineType = GetModuleTypeByID(moduleID); if (tempMachineType != string.Empty) { logger.Error("开始拼接机器类型和相关的数据JOSN"); if (tempMachineType == "1") { postUrl = System.Configuration.ConfigurationManager.AppSettings["YLJURL"]; _StringBuilder.Append("Gn=1&"); } else { postUrl = System.Configuration.ConfigurationManager.AppSettings["WNJURL"]; _StringBuilder.Append("Gn=2&"); } } else { return(string.Empty); } _StringBuilder.Append("Bbh=1&"); _StringBuilder.Append("kfsbh=北京金舟科技发展有限公司&"); //设备编号 _StringBuilder.Append("sbh=&"); _StringBuilder.Append("fssj=" + DateTime.Now.ToString() + "&"); _StringBuilder.Append("zwcd=" + json.Length + "&"); _StringBuilder.Append("jmfs=1&"); if (UploadCode == "0") { _StringBuilder.Append("sfqm=1&"); } else { _StringBuilder.Append("sfqm=0&"); } _StringBuilder.Append("ylcs=2&"); _StringBuilder.Append("sjjy=123&"); _StringBuilder.Append("sjqm=&"); _StringBuilder.Append("jmzw=" + UpdloadInfo); _StringBuilder.Append("&zsxh="); _StringBuilder.Append("&cfbs=0"); _StringBuilder.Append("&kzbh=" + System.Configuration.ConfigurationManager.AppSettings["kzbh"]); logger.Error("字符串拼接完成"); return(UpdateToInfoCenter(postUrl)); } catch (Exception ex) { logger.Error("拼接字符串错误:" + ex.ToString()); return(string.Empty); } }
private void DataItemSelector_Load(object sender, EventArgs e) { ProgressScreen.Current.ShowSplashScreen(); this.AddOwnedForm(ProgressScreen.Current); try { fpSpread1.Sheets.Clear(); if (LoadDocument == null) { LoadDocument = ModuleHelperClient.GetDefaultDocument(ModuleID); } var sheetsCache = new List <SheetView>(); foreach (var sheet in LoadDocument.Sheets) { ProgressScreen.Current.SetStatus = "正在初始化表单‘" + sheet.Name + "’"; var sheetView = GetLoadedSheet(sheet.Name); if (sheetView == null) { var sheetXML = ModuleHelperClient.GetSheetXMLByID(sheet.ID); sheetView = Serializer.LoadObjectXml(typeof(SheetView), sheetXML, "SheetView") as SheetView; sheetView.SheetName = sheet.Name; } sheetView.Tag = sheet.ID; sheetView.OperationMode = OperationMode.ReadOnly; fpSpread1.Sheets.Add(sheetView); sheetsCache.Add(sheetView); foreach (JZCell dataCell in sheet.Cells) { sheetView.Cells[dataCell.Name].BackColor = Color.LightPink; } } LoadSheets = sheetsCache.ToArray(); //if (CellName != ""&&SheetID!=Guid.Empty) //{ // SheetView s = null; // foreach (SheetView sheet in fpSpread1.Sheets) // { // if (new Guid(sheet.Tag.ToString()) == SheetID) // { // s = sheet; // break; // } // } // if (s != null) // { // fpSpread1.ActiveSheet = s; // } //} } catch (Exception ex) { MessageBox.Show("加载模板出错!\r\n原因:" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.RemoveOwnedForm(ProgressScreen.Current); ProgressScreen.Current.CloseSplashScreen(); 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 = "执行成功"; } } }
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) { } } }
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 } } } } }
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); } }
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); } }
/// <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()); } }
/// <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> /// <param name="doc"></param> /// <param name="files"></param> /// <param name="path"></param> private void ProcessPersonPhoto(DataRow[] drArr, List <String> files, String path) { //logger.Error("ProcessPersonPhoto 0"); foreach (DataRow dr in drArr) { JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(dr["Data"].ToString()); String personID = ""; foreach (var item in doc.Sheets[0].Cells) { if (item.Name == "D10")//身份证 { if (item.Value != null) { personID = item.Value.ToString(); break; } } } //logger.Error("personID:" + personID); if (personID != "") { String photoFile = Path.Combine(path, personID + ".jpg"); if (!files.Contains(photoFile)) { try { Boolean saved = false; foreach (var item in doc.Sheets[0].Cells) { if (item.Name == "L6")//照片 { if (item.Value != null) { if (File.Exists(photoFile)) { try { File.Delete(photoFile); } catch (Exception ex) { logger.Error(ex.Message); } } byte[] bitmapBytes = System.Convert.FromBase64String(item.Value.ToString()); using (MemoryStream memoryStream = new MemoryStream(bitmapBytes)) { Image image = Image.FromStream(memoryStream); image.Save(photoFile, ImageFormat.Jpeg); } saved = true; } break; } } if (saved) { files.Add(photoFile); } } catch (Exception e) { logger.Error(e.Message); } } } } }