private void SponsorModificationDialog_Load(object sender, EventArgs e) { using (DataTable dt = DocumentHelperClient.GetRequestChangeUnOP(DataID)) { if (dt != null && dt.Rows.Count > 0) { Info.ID = new Guid(dt.Rows[0]["ID"].ToString()); Info.Caption = dt.Rows[0]["Caption"].ToString(); Info.Reason = dt.Rows[0]["Reason"].ToString(); Info.IsRequestStadium = int.Parse(dt.Rows[0]["IsRequestStadium"].ToString()); } else { Info.ID = Guid.Empty; Info.Caption = ""; Info.Reason = ""; Info.IsRequestStadium = 0; } Info.DocumentID = DataID; txtContent.Text = Info.Caption; txtReason.Text = Info.Reason; chkIsRequestStadium.Checked = Info.IsRequestStadium == 1 ? true : false; //SponsorModifyInfo.Visible = != Guid.Empty; //ButtonOk.Enabled = !SponsorModifyInfo.Visible; } }
private void ButtonOk_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtContent.Text.Trim())) { txtContent.Focus(); return; } if (string.IsNullOrEmpty(txtReason.Text.Trim())) { txtReason.Focus(); return; } Info.DocumentID = DataID; Info.Caption = txtContent.Text; Info.Reason = txtReason.Text; Info.IsRequestStadium = chkIsRequestStadium.Checked == true ? 1 : 0; Boolean Result = DocumentHelperClient.NewRequestChange(Info); String Message = (Result ? "申请修改成功。" : "申请修改失败!"); MessageBoxIcon Icon = (Result ? MessageBoxIcon.Information : MessageBoxIcon.Error); MessageBox.Show(Message, "提示", MessageBoxButtons.OK, Icon); Close(); }
private void BindTestOverTime(Object c) { try { Yqun.Common.ContextCache.ApplicationContext.Current = c as Yqun.Common.ContextCache.ApplicationContext; this.OverTimeTable = DocumentHelperClient.GetTestOverTimeData(); var table = GroupOverTime(OverTimeTable); this.Invoke(new MethodInvoker(delegate { sheet_test_overtime.Rows.Count = 0; if (table != null) { sheet_test_overtime.Rows.Count = table.Rows.Count; if (table.Rows.Count > 0) { sheet_test_overtime.Rows[0, sheet_test_overtime.Rows.Count - 1].Height = 20; sheet_test_overtime.Rows[0, sheet_test_overtime.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center; } int j; foreach (DataRow Row in table.Rows) { j = table.Rows.IndexOf(Row); sheet_test_overtime.Rows[j].Tag = Row; sheet_test_overtime.Cells[j, 0].Value = Row["DataID"].ToString(); sheet_test_overtime.Cells[j, 1].Value = Row["标段名称"].ToString(); sheet_test_overtime.Cells[j, 2].Value = Row["单位名称"].ToString(); sheet_test_overtime.Cells[j, 3].Value = Row["试验室名称"].ToString(); sheet_test_overtime.Cells[j, 4].Value = Row["模板名称"].ToString(); sheet_test_overtime.Cells[j, 5].Value = Row["WTBH"].ToString(); sheet_test_overtime.Cells[j, 6].Value = Row["TestData"].ToString(); //spread_test_sheet.Cells[j, 5].Value = DateTime.Parse(Row["龄期到期日期"].ToString()).ToString("yyyy-MM-dd"); //spread_test_sheet.Cells[j, 6].Value = Row["试验员"].ToString(); //spread_test_sheet.Cells[j, 7].Value = DateTime.Parse(Row["实际试验日期"].ToString()).ToString("yyyy-MM-dd"); //spread_test_sheet.Cells[j, 8].Value = Row["SerialNumber"].ToString(); } AddView(spread_test_overtime, sheet_test_overtime); ChangeTabTitle(tabPage4, "待审批过期试验【" + spread_test_overtime.Sheets[0].RowCount + "】"); //AddViewDelegate avd = new AddViewDelegate(AddView); //spread_test_overtime.Invoke(avd, spread_test_overtime, sheet_test_overtime); //ChangeTabTitleDelegate cttd = new ChangeTabTitleDelegate(ChangeTabTitle); //tabPage4.Invoke(cttd, tabPage4, "待审批过期试验【" + spread_test_overtime.Sheets[0].RowCount + "】"); } })); } catch { } }
private void TemperatureUseDialog_Load(object sender, EventArgs e) { ComboAllTemperature.DataSource = TemperatureHelperClient.GetTemperatureTypes(TestRoomCode); var table = DocumentHelperClient.GetDocumentExt(DocumentID); if (table != null && table.Rows.Count > 0) { var type = int.Parse(table.Rows[0]["TemperatureType"].ToString()); ComboAllTemperature.SelectedValue = type; } }
private void bt_save_Click(object sender, EventArgs e) { String json = Newtonsoft.Json.JsonConvert.SerializeObject(views).Replace("'", "''"); Boolean flag = DocumentHelperClient.SaveCustomView(moduleID, testRoomCode, json); if (!flag) { MessageBox.Show("保存失败,请稍后再试"); } else { this.Close(); } }
private void bt_save_yyfx_Click(object sender, EventArgs e) { bool flag = false; RequestID = DocumentHelperClient.GetRequestChangeID(new Guid(invalidReportID)); if (chkSGRequest.Checked && RequestID == Guid.Empty && string.IsNullOrEmpty(tb_yyfx.Text.Trim())) { MessageBox.Show("原因分析不能为空!"); return; } if (tb_yyfx.Text.Trim() == "") { if (MessageBox.Show("当前内容为空,您确定保存吗?", "保存确定对话框", MessageBoxButtons.OKCancel) == DialogResult.OK) { flag = true; } else { return; } } else { flag = true; } if (flag) { DepositoryEvaluateDataList.SaveInvalidReportNote(invalidReportID, tb_yyfx.Text.Trim(), 0); if (RequestID == Guid.Empty && chkSGRequest.Checked == true) { Sys_RequestChange Info = new Sys_RequestChange(); Info.DocumentID = new Guid(invalidReportID); Info.Caption = "";// TextBox_Content.Text; Info.Reason = tb_yyfx.Text; Boolean Result = DocumentHelperClient.NewRequestChange(Info); } MessageBox.Show("保存成功"); //this.Close(); } }
private void BindProcess() { DataTable dt = DocumentHelperClient.GetInvalidProcessInfo(invalidReportID); if (dt != null && dt.Rows.Count > 0) { documentTestRoomCode = dt.Rows[0]["TestRoomCode"].ToString(); tb_yyfx.Text = dt.Rows[0]["SGComment"] == DBNull.Value ? "" : dt.Rows[0]["SGComment"].ToString(); tb_jlyj.Text = dt.Rows[0]["JLComment"] == DBNull.Value ? "" : dt.Rows[0]["JLComment"].ToString(); tb_cljg.Text = dt.Rows[0]["DealResult"] == DBNull.Value ? "" : dt.Rows[0]["DealResult"].ToString(); } #region 控制原因分析,监理意见,处理结果的填写顺序 if (string.IsNullOrEmpty(tb_yyfx.Text)) { tb_jlyj.Enabled = false; tb_cljg.Enabled = false; bt_save_jlyj.Enabled = false; bt_save_cljg.Enabled = false; } else { tb_jlyj.Enabled = true; tb_cljg.Enabled = true; bt_save_jlyj.Enabled = true; bt_save_cljg.Enabled = true; } if (string.IsNullOrEmpty(tb_jlyj.Text)) { tb_cljg.Enabled = false; bt_save_cljg.Enabled = false; tb_yyfx.Enabled = true; bt_save_yyfx.Enabled = true; } else { tb_cljg.Enabled = true; bt_save_cljg.Enabled = true; tb_yyfx.Enabled = false; bt_save_yyfx.Enabled = false; } #endregion }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { var sheet = spread_test_overtime.ActiveSheet; var rows = FarPointExtensions.GetSelectionRows(sheet); if (rows == null || rows.Length == 0) { MessageBox.Show("没有选中要删除的数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } var ids = new List <string>(); foreach (var row in rows) { ids.Add(sheet.Cells[row.Index, 0].Value.ToString()); } DocumentHelperClient.DeleteTestOverTime(ids); BindTestOverTime(Yqun.Common.ContextCache.ApplicationContext.Current); }
private void toolStripMenuItem1_Click(object sender, EventArgs e) { if (MessageBox.Show("您是否确定将所选记录的龄期设置到今天提醒?", "确认操作", MessageBoxButtons.YesNo) == DialogResult.Yes) { Row Row = spread_stadium_sheet.ActiveRow; if (Row != null && Row.Tag is String) { String[] Tokens = Row.Tag.ToString().Split(','); Guid stadiumID = new Guid(Tokens[2]); Boolean flag = DocumentHelperClient.ResetStadiumToToday(stadiumID); if (flag) { MessageBox.Show("设置成功!"); } else { MessageBox.Show("设置失败,请稍后再试!"); } } } }
private void btnSave_Click(object sender, EventArgs e) { //if (TextCustomTemerature.Visible) //{ // SaveCustom(); //} //else //{ // SaveChoice(); //} var result = DocumentHelperClient.SaveDocumentTemperatureType(DocumentID, Convert.ToInt32(ComboAllTemperature.SelectedValue)); if (result) { MessageBox.Show("设置成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("设置失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } Close(); //int TemperatureType = 0; //if (rbSDNei.Checked) //{ // TemperatureType = 1; //} //Boolean bResult = DocumentHelperClient.SaveDocumentTemperatureType(DocumentID, TemperatureType); //if (bResult) //{ // MessageBox.Show("设置成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //} //else //{ // MessageBox.Show("设置失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //} //this.Close(); }
private void LoadImage() { DataTable dtImage = DocumentHelperClient.GetInvalidImageList(invalidReportID); if (dtImage != null && dtImage.Rows.Count > 0) { for (int i = 0; i < dtImage.Rows.Count; i++) { MemoryStream _tempMemoryStream = new MemoryStream( (byte[])dtImage.Rows[i]["ImgContent"]); if (dtImage.Rows[i]["ImgRemark"] == DBNull.Value || dtImage.Rows[i]["ImgRemark"].ToString() == "") { AddImage(Image.FromStream(_tempMemoryStream), 0, dtImage.Rows[i]["ImgID"], false); AddImage(Image.FromStream(_tempMemoryStream), 1, dtImage.Rows[i]["ImgID"], false); AddImage(Image.FromStream(_tempMemoryStream), 2, dtImage.Rows[i]["ImgID"], false); } else { switch (dtImage.Rows[i]["ImgRemark"].ToString()) { case "原因分析": AddImage(Image.FromStream(_tempMemoryStream), 0, dtImage.Rows[i]["ImgID"], false); break; case "监理意见": AddImage(Image.FromStream(_tempMemoryStream), 1, dtImage.Rows[i]["ImgID"], false); break; case "处理结果": AddImage(Image.FromStream(_tempMemoryStream), 2, dtImage.Rows[i]["ImgID"], false); break; default: break; } } } } }
private void RequestChange() { RequestID = DocumentHelperClient.GetRequestChangeID(new Guid(invalidReportID)); rdoYes.Enabled = false; rdoNo.Enabled = false; if (RequestID == Guid.Empty) { chkSGRequest.Enabled = true; chkSGRequest.Checked = false; } else { chkSGRequest.Checked = true; chkSGRequest.Enabled = false; dtRequest = DepositoryDataModificationInfo.HaveDataModificationInfoByID(RequestID.ToString()); if (dtRequest != null && dtRequest.Rows.Count > 0) { if (dtRequest.Rows[0]["State"].ToString() == "已提交") { if (Yqun.Common.ContextCache.ApplicationContext.Current.InCompany.Type == "@unit_监理单位" || Yqun.Common.ContextCache.ApplicationContext.Current.IsAdministrator) { rdoYes.Enabled = true; rdoNo.Enabled = true; } } else if (dtRequest.Rows[0]["State"].ToString() == "通过") { rdoYes.Checked = true; } else if (dtRequest.Rows[0]["State"].ToString() == "不通过") { rdoNo.Checked = true; } } } }
private void BindStadiumData() { DataTable Data = DocumentHelperClient.SearchStadiumByWTBH(toolStripTextBox1.Text.Trim()); if (Data != null) { spread_stadium.ShowRow(spread_stadium.GetActiveRowViewportIndex(), 0, VerticalPosition.Top); spread_stadium_sheet.Rows.Count = Data.Rows.Count; if (Data.Rows.Count == 0) { return; } int HiddenColumnCount = 4; spread_stadium_sheet.Columns.Count = Data.Columns.Count - HiddenColumnCount; if (spread_stadium_sheet.Columns.Count > 0) { spread_stadium_sheet.Columns[0].Width = 90; spread_stadium_sheet.Columns[1].Width = 120; spread_stadium_sheet.Columns[2].Width = 140; spread_stadium_sheet.Columns[3].Width = 120; spread_stadium_sheet.Columns[4].Width = 110; spread_stadium_sheet.Columns[5].Width = 80; spread_stadium_sheet.Columns[6].Width = 90; spread_stadium_sheet.Columns[7].Width = 80; spread_stadium_sheet.Columns[8].Width = 120; spread_stadium_sheet.Columns[9].Width = 120; spread_stadium_sheet.Columns[10].Width = 120; spread_stadium_sheet.Columns[0, spread_stadium_sheet.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center; spread_stadium_sheet.Columns[0, spread_stadium_sheet.Columns.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center; } DateTimeCellType datetime = new DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate; FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); text.Multiline = true; text.WordWrap = true; spread_stadium_sheet.Columns[5].CellType = datetime; spread_stadium_sheet.Rows.Count = Data.Rows.Count; if (Data.Rows.Count > 0) { spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].Height = 35; spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].Locked = true; spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center; spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].VerticalAlignment = CellVerticalAlignment.Center; } int i, j; foreach (System.Data.DataColumn Column in Data.Columns) { if (Column.ColumnName == "ID" || Column.ColumnName == "DataID" || Column.ColumnName == "ModuleID" || Column.ColumnName == "DateSpan") { continue; } i = Data.Columns.IndexOf(Column); spread_stadium_sheet.Columns[i - HiddenColumnCount].VerticalAlignment = CellVerticalAlignment.Center; spread_stadium_sheet.Columns[i - HiddenColumnCount].Label = Column.ColumnName; foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); spread_stadium_sheet.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center; spread_stadium_sheet.Cells[j, i - HiddenColumnCount].Value = Row[Column.ColumnName].ToString(); } } foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); spread_stadium_sheet.Rows[j].Tag = Row["DataID"].ToString() + "," + Row["ModuleID"].ToString() + "," + Row["ID"].ToString(); } spread_stadium.CellDoubleClick -= new CellClickEventHandler(spread_stadium_CellDoubleClick); spread_stadium.CellDoubleClick += new CellClickEventHandler(spread_stadium_CellDoubleClick); } if (Data == null || Data.Rows.Count == 0) { MessageBox.Show("未找到数据,请检查委托编号是否正确;或重新保存资料!"); } }
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("图片上传失败"); } } }
private void BindInvalid(Object c) { try { Yqun.Common.ContextCache.ApplicationContext.Current = c as Yqun.Common.ContextCache.ApplicationContext; SheetView spread_invalide_sheet = new SheetView(); spread_invalide_sheet.Rows.Count = 0; spread_invalide_sheet.Columns.Count = 12; spread_invalide_sheet.ColumnHeader.Cells[0, 0].Text = "标段"; spread_invalide_sheet.ColumnHeader.Cells[0, 1].Text = "单位"; spread_invalide_sheet.ColumnHeader.Cells[0, 2].Text = "试验室"; spread_invalide_sheet.ColumnHeader.Cells[0, 3].Text = "试验报告"; spread_invalide_sheet.ColumnHeader.Cells[0, 4].Text = "报告编号"; spread_invalide_sheet.ColumnHeader.Cells[0, 5].Text = "报告日期"; spread_invalide_sheet.ColumnHeader.Cells[0, 6].Text = "试验项目"; spread_invalide_sheet.ColumnHeader.Cells[0, 7].Text = "标准值"; spread_invalide_sheet.ColumnHeader.Cells[0, 8].Text = "实测值"; spread_invalide_sheet.ColumnHeader.Cells[0, 9].Text = "原因分析"; spread_invalide_sheet.ColumnHeader.Cells[0, 10].Text = "监理意见"; spread_invalide_sheet.ColumnHeader.Cells[0, 11].Text = "处理结果"; spread_invalide_sheet.Columns[0].Width = 80; spread_invalide_sheet.Columns[1].Width = 100; spread_invalide_sheet.Columns[2].Width = 100; spread_invalide_sheet.Columns[3].Width = 190; spread_invalide_sheet.Columns[4].Width = 200; spread_invalide_sheet.Columns[5].Width = 90; spread_invalide_sheet.Columns[6].Width = 110; spread_invalide_sheet.Columns[7, 8].Width = 90; spread_invalide_sheet.Columns[9].Width = 200; spread_invalide_sheet.Columns[10].Width = 200; spread_invalide_sheet.Columns[11].Width = 200; FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate; spread_invalide_sheet.Columns[5].CellType = datetime; Boolean isSG = false; if (userType.IndexOf("施工") > 0) { isSG = true; } DataTable Data = DocumentHelperClient.GetUndoInvalidDocumentList(isSG); if (Data != null) { //spread_invalide.ShowRow(spread_invalide.GetActiveRowViewportIndex(), 0, VerticalPosition.Top); spread_invalide_sheet.Rows.Count = Data.Rows.Count; if (Data.Rows.Count > 0) { FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); text.Multiline = true; text.WordWrap = true; spread_invalide_sheet.Columns[0, 2].CellType = text; spread_invalide_sheet.Rows[0, spread_invalide_sheet.Rows.Count - 1].Height = 25; spread_invalide_sheet.Rows[0, spread_invalide_sheet.Rows.Count - 1].Locked = true; spread_invalide_sheet.Columns[0, spread_invalide_sheet.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center; spread_invalide_sheet.Rows[0, spread_invalide_sheet.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center; int i, j; foreach (System.Data.DataColumn Column in Data.Columns) { if (Column.ColumnName == "ID" || Column.ColumnName == "ModuleID") { continue; } i = Data.Columns.IndexOf(Column); spread_invalide_sheet.Columns[i - 2].VerticalAlignment = CellVerticalAlignment.Center; spread_invalide_sheet.Columns[i - 2].Label = Column.ColumnName; foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); spread_invalide_sheet.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center; spread_invalide_sheet.Cells[j, i - 2].Value = Row[Column.ColumnName].ToString(); } } foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); spread_invalide_sheet.Rows[j].Tag = Row["ID"].ToString() + "," + Row["ModuleID"].ToString(); } } } AddViewDelegate avd = new AddViewDelegate(AddView); spread_invalide.Invoke(avd, spread_invalide, spread_invalide_sheet); ChangeTabTitleDelegate cttd = new ChangeTabTitleDelegate(ChangeTabTitle); tabPage2.Invoke(cttd, tabPage2, "待处理不合格报告【" + spread_invalide.Sheets[0].RowCount + "】"); } catch { } }
private void BindRequest(Object c) { try { Yqun.Common.ContextCache.ApplicationContext.Current = c as Yqun.Common.ContextCache.ApplicationContext; SheetView spread_request_sheet = new SheetView(); spread_request_sheet.Columns.Count = 11; spread_request_sheet.Columns[0].Width = 80; spread_request_sheet.Columns[1].Width = 100; spread_request_sheet.Columns[2].Width = 200; spread_request_sheet.Columns[3].Width = 150; spread_request_sheet.Columns[4].Width = 240; spread_request_sheet.Columns[5].Width = 80; spread_request_sheet.Columns[6].Width = 130; spread_request_sheet.Columns[7].Width = 120; spread_request_sheet.Columns[8].Width = 300; spread_request_sheet.Columns[9].Width = 300; spread_request_sheet.Columns[0, spread_request_sheet.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center; TextCellType text = new TextCellType(); text.Multiline = true; text.WordWrap = true; spread_request_sheet.Columns[0, 2].CellType = text; DataTable Data = DocumentHelperClient.GetUnPreocessedRequestList(); spread_request_sheet.Rows.Count = 0; if (Data != null) { //spread_request.ShowRow(spread_request.GetActiveRowViewportIndex(), 0, VerticalPosition.Top); spread_request_sheet.Rows.Count = Data.Rows.Count; if (Data.Rows.Count > 0) { spread_request_sheet.Rows[0, spread_request_sheet.Rows.Count - 1].Height = 20; spread_request_sheet.Rows[0, spread_request_sheet.Rows.Count - 1].Locked = true; spread_request_sheet.Rows[0, spread_request_sheet.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center; } int i, j; foreach (System.Data.DataColumn Column in Data.Columns) { if (Column.ColumnName == "ID" || Column.ColumnName == "DataID" || Column.ColumnName == "ModuleID") { continue; } i = Data.Columns.IndexOf(Column); spread_request_sheet.Columns[i - 3].VerticalAlignment = CellVerticalAlignment.Center; spread_request_sheet.Columns[i - 3].Label = Column.ColumnName; foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); spread_request_sheet.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center; spread_request_sheet.Cells[j, i - 3].Value = Row[Column.ColumnName].ToString(); } } foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); spread_request_sheet.Rows[j].Tag = Row["ID"].ToString() + "," + Row["DataID"].ToString() + "," + Row["ModuleID"].ToString(); } } AddViewDelegate avd = new AddViewDelegate(AddView); spread_request.Invoke(avd, spread_request, spread_request_sheet); ChangeTabTitleDelegate cttd = new ChangeTabTitleDelegate(ChangeTabTitle); tabPage3.Invoke(cttd, tabPage3, "待审批用户申请【" + spread_request.Sheets[0].RowCount + "】"); } catch { } }
private void toolStripButton1_Click_1(object sender, EventArgs e) { Boolean flag = DocumentHelperClient.GeneratePLDTable(); MessageBox.Show(flag.ToString()); }
private void ModelFieldSettingDialog_Load(object sender, EventArgs e) { views = DocumentHelperClient.GetCustomViewList(moduleID, testRoomCode); LoadCustomView(); }
private void bt_apply_Click(object sender, EventArgs e) { DocumentHelperClient.ApplyExtFields(moduleID); MessageBox.Show("完成"); }
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) { } } }
private void DataDialog_Load(object sender, EventArgs e) { ProgressScreen.Current.ShowSplashScreen(); this.AddOwnedForm(ProgressScreen.Current); Dictionary <Guid, SheetView> SheetCollection = new Dictionary <Guid, SheetView>(); JZDocument document = DocumentHelperClient.GetDocumentByID(DataID); JZDocument defaultDocument = ModuleHelperClient.GetDefaultDocument(ModuleID); List <JZFormulaData> CrossSheetFormulaInfos = ModuleHelperClient.GetLineFormulaByModuleIndex(ModuleID); FpSpread.Sheets.Clear(); LoadSpread(FpSpread, ModuleID); #region 初始化表单 foreach (JZSheet sheet in defaultDocument.Sheets) { SheetView SheetView = GetSheet(sheet.ID); 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) { #region 处理单元格 cell.Locked = false; 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 { cell.Value = value; } } 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 { cell.Value = value; } } 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 { cell.Value = value; } } else if (cell.CellType is DeleteLineCellType) {//删除线 DeleteLineCellType CellType = cell.CellType as DeleteLineCellType; CellType.Multiline = true; CellType.WordWrap = true; CellType.MaxLength = CellType.FieldType.Length; cell.CellType = CellType; object objOld = cell.Text; if (hasValue) { cell.Value = new System.Text.RegularExpressions.Regex("'+").Replace(value.ToString(), "'"); //value.ToString(); if (string.IsNullOrEmpty(cell.Text)) { RichTextBox rt = new RichTextBox(); rt.Text = objOld == null ? "" : objOld.ToString(); rt.Font = new Font("宋体", 10.5f, FontStyle.Regular); cell.Value = rt.Rtf; } } else { RichTextBox rt = new RichTextBox(); rt.Text = objOld == null ? "" : objOld.ToString(); rt.Font = new Font("宋体", 10.5f, FontStyle.Regular); cell.Value = rt.Rtf; } } 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; for (int i = CellType.Mask.Length; i < CellType.FieldType.Length; i++) { CellType.Mask += "0"; } if (CellType.CustomMaskCharacters != null && CellType.CustomMaskCharacters.Length > 0) { CellType.CustomMaskCharacters[0] = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-()ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩ()复检"; } if (value == null || value.ToString().Trim() == "") { cell.Value = null; } else { cell.Value = value.ToString().Trim(); } } else if (cell.CellType is ImageCellType) { if (value != null) { cell.Value = JZCommonHelper.StringToBitmap(value.ToString()); } else { cell.Value = null; } } else if (cell.CellType is HyperLinkCellType) { if (value != null) { List <string> lstLink = new List <string>(); HyperLinkCellType hlnkCell = new HyperLinkCellType(); try { lstLink = Newtonsoft.Json.JsonConvert.DeserializeObject <List <string> >(value.ToString()); hlnkCell.Text = lstLink[0]; hlnkCell.Link = lstLink[1]; } catch { hlnkCell.Text = value.ToString(); hlnkCell.Link = ""; } cell.CellType = hlnkCell; //cell.Value = value; } else { HyperLinkCellType hlnkCell = new HyperLinkCellType(); cell.CellType = hlnkCell; } } else { cell.Value = value; } #endregion JZCellProperty p = cell.Tag as JZCellProperty; #region 处理单元格属性 if (p != null) { cell.Locked = false; } else { // logger.Error("未能设置数据区信息:单元格" + dataCellDefault.Name + ",表单:" + sheet.Name); } #endregion } } #region 线路单元格样式 DataTable dtCellStyle = ModuleHelperClient.GetCellStyleBySheetID(sheet.ID); 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); } } } #endregion } #endregion UpdateChart(); UpdateEquation(); //设置只读模式 if (ReadOnly) { foreach (SheetView sheet in FpSpread.Sheets) { sheet.OperationMode = OperationMode.ReadOnly; } } }
private void Button_Query_Click(object sender, EventArgs e) { ProgressScreen.Current.ShowSplashScreen(); ProgressScreen.Current.SetStatus = "正在获取数据..."; String segment = ""; String company = ""; String testroom = ""; if (ComboBox_Segments.SelectedItem is Prjsct) { segment = (ComboBox_Segments.SelectedItem as Prjsct).PrjsctCode; } else { segment = ""; } if (ComboBox_Company.SelectedItem is Orginfo) { company = (ComboBox_Company.SelectedItem as Orginfo).DepCode; } else { company = ""; } if (ComboBox_TestRooms.SelectedItem is PrjFolder) { testroom = (ComboBox_TestRooms.SelectedItem as PrjFolder).FolderCode; } else { testroom = ""; } DateTime StartDate = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", DateTimePicker_Start.Value.Year, DateTimePicker_Start.Value.Month, DateTimePicker_Start.Value.Day)); DateTime EndDate = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", DateTimePicker_End.Value.Year, DateTimePicker_End.Value.Month, DateTimePicker_End.Value.Day)); String sReportName = TextBox_ReportName.Text; String sReportNumber = TextBox_ReportNumber.Text; String sTestItems = TextBox_TestItems.Text; int SameCountSum = 0; DataTable Data = DocumentHelperClient.GetInvalidDocumentList(segment, company, testroom, sReportName, sReportNumber, StartDate, EndDate, sTestItems); if (Data != null) { FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top); FpSpread_Info.Rows.Count = Data.Rows.Count; if (Data.Rows.Count > 0) { FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); text.Multiline = true; text.WordWrap = true; FpSpread_Info.Columns[0, 2].CellType = text; FpSpread_Info.Columns[11].CellType = text; FpSpread_Info.Columns[12].CellType = text; FpSpread_Info.Columns[13].CellType = text; FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Height = 25; FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Locked = true; FpSpread_Info.Columns[0, FpSpread_Info.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center; FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center; int i, j; foreach (System.Data.DataColumn Column in Data.Columns) { if (Column.ColumnName == "ID" || Column.ColumnName == "ModuleID") { continue; } i = Data.Columns.IndexOf(Column); FpSpread_Info.Columns[i - 2].VerticalAlignment = CellVerticalAlignment.Center; FpSpread_Info.Columns[i - 2].Label = Column.ColumnName; foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center; FpSpread_Info.Cells[j, i - 2].Value = Row[Column.ColumnName].ToString(); } } string strIsHeGe, strID; //foreach (DataRow Row in Data.Rows) //{ // j = Data.Rows.IndexOf(Row); // FpSpread_Info.Rows[j].Tag = Row["ID"].ToString() + "," + Row["ModuleID"].ToString(); // strIsHeGe = Row["是否合格"].ToString(); // if (strIsHeGe == "已合格") // { // FpSpread_Info.Rows[j].BackColor = Color.FromArgb(240, 180, 120); // } // else // { // FpSpread_Info.Rows[j].BackColor = Color.White; // } // strInvalidItem = Row["不合格项目"].ToString(); // FpSpread_Info.Rows[j].Height = strInvalidItem.Split('\r').Length * 24; // strID = Row["ID"].ToString(); //} DataRow drRow; int SameCount; for (int m = 0; m < Data.Rows.Count; m++) { FpSpread_Info.Rows[m].Tag = Data.Rows[m]["ID"].ToString() + "," + Data.Rows[m]["ModuleID"].ToString(); strIsHeGe = Data.Rows[m]["是否合格"].ToString(); if (strIsHeGe == "已合格") { FpSpread_Info.Rows[m].BackColor = Color.FromArgb(240, 180, 120); } else { FpSpread_Info.Rows[m].BackColor = Color.White; } drRow = Data.Rows[m]; strID = drRow["ID"].ToString(); SameCount = -1; foreach (DataRow drItem in Data.Rows) { if (strID == drItem["ID"].ToString()) { SameCount++; } } if (SameCount > 0) { foreach (System.Data.DataColumn Column in Data.Columns) { if (Column.ColumnName == "ID" || Column.ColumnName == "ModuleID" || Column.ColumnName == "不合格项目" || Column.ColumnName == "标准规定值" || Column.ColumnName == "实测值") { continue; } i = Data.Columns.IndexOf(Column); FpSpread_Info.Cells[m, i - 2].RowSpan = SameCount + 1; } SameCountSum += SameCount; m += SameCount; } } FpSpread.MouseUp += new MouseEventHandler(FpSpread_MouseUp); } else { FpSpread.MouseUp -= new MouseEventHandler(FpSpread_MouseUp); ProgressScreen.Current.CloseSplashScreen(); this.Activate(); MessageBox.Show("无数据,请重新选择条件!"); } } else { ProgressScreen.Current.CloseSplashScreen(); this.Activate(); FpSpread.MouseUp -= new MouseEventHandler(FpSpread_MouseUp); MessageBox.Show("无数据,请重新选择条件!"); } ProgressScreen.Current.CloseSplashScreen(); this.Activate(); if (Data == null) { TotalCount.Text = string.Format("本次查询共 {0} 条记录", 0); } else { TotalCount.Text = string.Format("本次查询共 {0} 条记录", Data.Rows.Count - SameCountSum); } }
private void Button_Query_Click(object sender, EventArgs e) { ProgressScreen.Current.ShowSplashScreen(); ProgressScreen.Current.SetStatus = "正在获取数据..."; String segment = ""; String company = ""; String testroom = ""; String SelectedState = cb_state.SelectedItem.ToString(); if (ComboBox_Segments.SelectedItem is Prjsct) { segment = (ComboBox_Segments.SelectedItem as Prjsct).PrjsctCode; } if (ComboBox_Company.SelectedItem is Orginfo) { company = (ComboBox_Company.SelectedItem as Orginfo).DepCode; } if (ComboBox_TestRooms.SelectedItem is PrjFolder) { testroom = (ComboBox_TestRooms.SelectedItem as PrjFolder).FolderCode; } DateTime start = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", StartDateTimePicker.Value.Year, StartDateTimePicker.Value.Month, StartDateTimePicker.Value.Day)); DateTime end = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", EndDateTimePicker.Value.Year, EndDateTimePicker.Value.Month, EndDateTimePicker.Value.Day)); DataTable Data = DocumentHelperClient.GetRequestChangeList(segment, company, testroom, start, end, SelectedState, tb_content.Text.Trim(), tb_user.Text.Trim()); if (Data != null) { FpSpread FpSpread = fpSpread1; SheetView FpSpread_Info = fpSpread1_Sheet; FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top); FpSpread_Info.Columns.Count = 12; FpSpread_Info.Columns[0].Width = 60; FpSpread_Info.Columns[1].Width = 60; FpSpread_Info.Columns[2].Width = 80; FpSpread_Info.Columns[3].Width = 80; FpSpread_Info.Columns[4].Width = 240; FpSpread_Info.Columns[5].Width = 160; FpSpread_Info.Columns[6].Width = 80; FpSpread_Info.Columns[7].Width = 50; FpSpread_Info.Columns[8].Width = 120; FpSpread_Info.Columns[9].Width = 300; FpSpread_Info.Columns[10].Width = 300; FpSpread_Info.Columns[0, FpSpread_Info.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center; TextCellType text = new TextCellType(); text.Multiline = true; text.WordWrap = true; FpSpread_Info.Columns[0, 2].CellType = text; FpSpread_Info.Rows.Count = Data.Rows.Count; if (Data.Rows.Count > 0) { FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Height = 20; FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Locked = true; FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center; } int i, j; foreach (System.Data.DataColumn Column in Data.Columns) { if (Column.ColumnName == "ID" || Column.ColumnName == "DataID" || Column.ColumnName == "ModuleID") { continue; } i = Data.Columns.IndexOf(Column); FpSpread_Info.Columns[i - 3].VerticalAlignment = CellVerticalAlignment.Center; FpSpread_Info.Columns[i - 3].Label = Column.ColumnName; foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center; FpSpread_Info.Cells[j, i - 3].Value = Row[Column.ColumnName].ToString(); } } foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); FpSpread_Info.Rows[j].Tag = Row["ID"].ToString() + "," + Row["DataID"].ToString() + "," + Row["ModuleID"].ToString();// Row["ID"].ToString(); } if (Data.Rows.Count == 0) { ProgressScreen.Current.CloseSplashScreen(); this.Activate(); MessageBox.Show("无数据,请重新选择条件!"); } } else { ProgressScreen.Current.CloseSplashScreen(); this.Activate(); MessageBox.Show("无数据,请重新选择条件!"); } ProgressScreen.Current.CloseSplashScreen(); this.Activate(); }
void worker_DoWork(object sender, DoWorkEventArgs e) { BackgroundWorker worker = sender as BackgroundWorker; DataExportClass Params = e.Argument as DataExportClass; Font defaultFont = new Font("宋体", 9f); String Path = Params.path; if (string.IsNullOrEmpty(Path)) { return; } MyCell fpSpread = new MyCell(); fpSpread.Watermark = ModuleHelperClient.GetWatermarkByModuleID(moduleID); //初始化模板样式 List <FarPoint.CalcEngine.FunctionInfo> Infos = FunctionItemInfoUtil.getFunctionItemInfos(); List <JZFormulaData> CrossSheetFormulaInfos = ModuleHelperClient.GetFormulaByModuleIndex(moduleID); Dictionary <Sys_Document, JZDocument> list = DocumentHelperClient.GetDocumentDataListByModuleIDAndTestRoomCode(moduleID, testRoomCode); if (list.Count == 0) { return; } Dictionary <Sys_Document, JZDocument> .Enumerator em = list.GetEnumerator(); int i = 0; while (em.MoveNext()) { Sys_Document docBase = em.Current.Key; JZDocument doc = em.Current.Value; if (i == 0) { foreach (JZSheet sheet in doc.Sheets) { ProgressScreen.Current.SetStatus = string.Format("正在准备表单{0}...", 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); foreach (FarPoint.CalcEngine.FunctionInfo Info in Infos) { SheetView.AddCustomFunction(Info); } } fpSpread.LoadFormulas(true); } i = i + 1; worker.ReportProgress((int)(((float)i / (float)list.Count) * 100)); foreach (JZSheet sheet in doc.Sheets) { SheetView sheetV = null; for (int j = 0; j < fpSpread.Sheets.Count; j++) { if (new Guid(fpSpread.Sheets[j].Tag.ToString()) == sheet.ID) { sheetV = fpSpread.Sheets[j]; break; } } if (sheetV == null) { break; } foreach (JZCell dataCell in sheet.Cells) { Cell cell = sheetV.Cells[dataCell.Name]; if (cell != null) { cell.Font = defaultFont; if (cell.CellType is ImageCellType) { if (dataCell.Value != null) { cell.Value = JZCommonHelper.StringToBitmap(dataCell.Value.ToString()); } } else { cell.Value = dataCell.Value; } } } } try { //保存资料到指定目录 String reportNumber = docBase.BGBH == "" ? "无报告编号" + i.ToString() : docBase.BGBH; ExcelWarningList ewl = new ExcelWarningList(); string fileName = Path + "\\" + moduleName + "-" + reportNumber + ".xls"; fpSpread.SaveExcel(fileName, ExcelSaveFlags.NoFlagsSet, ewl); } catch { } } }