public void Show(sdjls_sbpjb obj) { _pjobject = obj; //this.Show(); }
void treeViewOperator_CreatingObject(sdjls_sbpjb newobj) { }
void treeViewOperator_AfterAdd(sdjls_sbpjb newobj) { if (AfterAdd != null) AfterAdd(treeList1, newobj); }
void treeViewOperator_AfterDelete(sdjls_sbpjb newobj) { if (AfterDelete != null) AfterDelete(treeList1, newobj); }
public static int ExportToExcel(string title, string dw, sdjls_sbpjb pj17) { string fname = Application.StartupPath + "\\00记录模板\\送管22送电线路设备评级表.xls"; DSOFramerControl dsoFramerWordControl1 = new DSOFramerControl(); string outfname = Path.GetTempFileName() + ".xls"; File.Copy(fname, outfname); dsoFramerWordControl1.FileOpen(outfname); Microsoft.Office.Interop.Excel.Worksheet xx; Excel.Workbook wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook; ExcelAccess ex = new ExcelAccess(); ex.MyWorkBook = wb; ex.MyExcel = wb.Application; sd_xl xl = MainHelper.PlatformSqlMap.GetOne<sd_xl>(" where LineCode='" + pj17.LineCode + "'"); try { if (xl == null) { MsgBox.ShowWarningMessageBox("数据出错,没找到线路"); return -1; } string strLinexh = xl.WireType;//导线型号 //IList<sd_gt> gtlis = Client.ClientHelper.PlatformSqlMap.GetList<sd_gt>(" Where LineCode='" + xl.LineCode + "' order by gtcode"); int gtcount = Client.ClientHelper.PlatformSqlMap.GetRowCount<sd_gt>(" Where LineCode='" + xl.LineCode + "'"); ex.ActiveSheet(1); //设置线路值 ex.SetCellValue(xl.LineName, 3, 3); ex.SetCellValue(xl.LineVol, 3, 8); ex.SetCellValue(xl.WireLength.ToString(), 3, 11); ex.SetCellValue(xl.InDate.Year + "年" + xl.InDate.Month + "月", 3, 13); //ex.SetCellValue(xl.InDate.Year.ToString(), 4, 9); //ex.SetCellValue(xl.InDate.Month.ToString(), 4, 11); //评级日期 ex.SetCellValue(DateTime.Now.Year + "年" + DateTime.Now.Month + "月" + DateTime.Now.Day + "日", 4, 3); //杆塔 ex.SetCellValue(gtcount.ToString(), 5, 3);//合计 ex.SetCellValue(gtcount.ToString(), 6, 3);//一类 //导地线 ex.SetCellValue(xl.WireLength.ToString(), 9, 3);//合计 ex.SetCellValue(xl.WireLength.ToString(), 10, 3);//一类 //绝缘子 string sql = "in ("; //foreach (sd_gt gt in gtlis) //{ // sql+="'"+gt.gtID+"',"; //} //sql = sql.Substring(0, sql.Length - 1) + ")"; sql = "in (select gtid from sd_gt Where LineCode='" + xl.LineCode + "' )"; string strSQL = "select sbid from sd_gtsb Where gtID " + sql; IList jdzzList = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", strSQL); strSQL += " and ("+getNamesql()+")"; IList jyuzlist = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", strSQL); ex.SetCellValue(jyuzlist.Count.ToString(), 13, 3); ex.SetCellValue(jyuzlist.Count.ToString(), 14, 3); //接地装置 ex.SetCellValue(jdzzList.Count.ToString(), 17, 3); ex.SetCellValue(jdzzList.Count.ToString(), 18, 3); //其它 //评定等级 ex.SetCellValue("一级", 24, 3); //评级负责人 if (MainHelper.User != null) { ex.SetCellValue(MainHelper.User.UserName, 25, 3); } } catch (Exception exmess) { MsgBox.ShowTipMessageBox(exmess.Message.ToString()); } dsoFramerWordControl1.FileSave(); pj17.BigData = dsoFramerWordControl1.FileDataGzip; dsoFramerWordControl1.FileClose(); dsoFramerWordControl1.Dispose(); //#endregion //System.Diagnostics.Process.Start(outfname); return 1; }
private void btReAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (btXlList.EditValue == null || btXlList.EditValue.ToString() == "") { return; } sd_xl xl = btXlList.EditValue as sd_xl; sdjls_sbpjb pj = new sdjls_sbpjb(); pj.pjrq = DateTime.Now; //pj.pddj = "一级"; pj.pjfzr = MainHelper.User.UserName; pj.LineName = xl.LineName; pj.LineCode = xl.LineCode; pj.OrgCode = xl.OrgCode; pj.OrgName = parentObj.OrgName; pj.Remark = ""; MainHelper.PlatformSqlMap.Create<sdjls_sbpjb>(pj); InitData(); //if (MsgBox.ShowAskMessageBox("是否马上生成条图") == DialogResult.OK) { try { if (ExportToExcel("送管22送电线路设备评级表.xls", "", pj) < 1) return; frm22sbpjbTemplate frm = new frm22sbpjbTemplate(); frm.pjobject = pj; if (frm.ShowDialog() == DialogResult.OK) { Client.ClientHelper.PlatformSqlMap.Update<sdjls_sbpjb>(frm.pjobject); //MessageBox.Show("保存成功"); } } catch (Exception ex) { MsgBox.ShowException(ex); } } }