private void btAddfrm_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (MainHelper.UserOrg == null) return; if (!RecordWorkTask.HaveRunNewGZPRole(strKind, MainHelper.User.UserID)) return; object obj = RecordWorkTask.GetNewWorkTaskModle(strKind, MainHelper.User.UserID); if (obj == null) { MsgBox.ShowWarningMessageBox("出错,未找到对应的模块,请检查模板设置!"); return; } LP_Record lpr = new LP_Record(); lpr.ID = "N" + lpr.CreateID(); lpr.Kind = strKind; lpr.CreateTime = DateTime.Now.ToString(); if (obj is frmLP) { frmLP frm = new frmLP(); frm.Status = "add"; frm.Kind = strKind; string[] strtemp = RecordWorkTask.RunNewGZPRecord(lpr.ID, strKind, MainHelper.User.UserID, false); //frm.ParentTemple = RecordWorkTask.GetNewWorkTaskTemple(strKind, MainHelper.User.UserID); //frm.RecordWorkFlowData = RecordWorkTask.GetGZPRecordSartWorkData(ParentObj.FlowCaption, MainHelper.User.UserID); frm.RecordWorkFlowData = RecordWorkTask.GetRecordWorkFlowData(lpr.ID, MainHelper.User.UserID); if (frm.RecordWorkFlowData == null) { MsgBox.ShowWarningMessageBox("出错,未找到该流程信息,请检查模板设置!"); } frm.ParentTemple = RecordWorkTask.GetWorkTaskTemple(frm.RecordWorkFlowData, lpr); if (frm.ParentTemple == null) { MsgBox.ShowWarningMessageBox("出错,未找到该节点关联的表单,请检查模板设置!"); } lpr.Number = RecordWorkTask.CreatWorkFolwNo(MainHelper.UserOrg, frm.ParentTemple.LPID); lpr.Status = frm.RecordWorkFlowData.Rows[0]["TaskCaption"].ToString(); //lpr.Status = "填票"; //frm.RowData = lpr; frm.CurrRecord = lpr; MainHelper.PlatformSqlMap.Create<LP_Record>(lpr); if (frm.ShowDialog() == DialogResult.OK) { InitData(strSQL); } } else { string[] strtemp = RecordWorkTask.RunNewGZPRecord(lpr.ID, strKind, MainHelper.User.UserID, false); if (strtemp[0].IndexOf("未提交至任何人") > -1) { MsgBox.ShowTipMessageBox("未提交至任何人,创建失败,请检查流程模板和组织机构配置是否正确!"); return; } DataTable recordWorkFlowData = RecordWorkTask.GetRecordWorkFlowData(lpr.ID, MainHelper.User.UserID); if (recordWorkFlowData == null) { MsgBox.ShowWarningMessageBox("出错,未找到该流程信息,请检查模板设置!"); } lpr.Status = recordWorkFlowData.Rows[0]["TaskCaption"].ToString(); MainHelper.PlatformSqlMap.Create<LP_Record>(lpr); if (obj.GetType().GetProperty("IsWorkflowCall") != null) obj.GetType().GetProperty("IsWorkflowCall").SetValue(obj, true, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("CurrRecord") != null) obj.GetType().GetProperty("CurrRecord").SetValue(obj, lpr, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("RecordWorkFlowData") != null) obj.GetType().GetProperty("RecordWorkFlowData").SetValue(obj, recordWorkFlowData, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("ParentTemple") != null) obj.GetType().GetProperty("ParentTemple").SetValue(obj, RecordWorkTask.GetWorkTaskTemple(recordWorkFlowData, lpr), null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj is UserControl) { FormBase dlg = new FormBase(); dlg.Text = ((UserControl)obj).Name; dlg.MdiParent = MainHelper.MainForm; dlg.Controls.Add((UserControl)obj); ((UserControl)obj).Dock = DockStyle.Fill; dlg.Show(); } else if (obj is Form) { if (obj is frmyxfxWorkFlowEdit) { PJ_03yxfx yxfx = new PJ_03yxfx(); yxfx.OrgCode = MainHelper.UserOrg.OrgCode; yxfx.OrgName = MainHelper.UserOrg.OrgName; if (parentObj.FlowCaption.IndexOf("定期分析") > 0) yxfx.type = "定期分析"; else if (parentObj.FlowCaption.IndexOf("专题分析") > 0) yxfx.type = "专题分析"; ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; yxfx.rq = DateTime.Now; ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; } else if (obj is frmsbqxWorkFlowEdit) { PJ_qxfl qxfl = new PJ_qxfl(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; ((frmsbqxWorkFlowEdit)obj).RowData = qxfl; } ((Form)obj).ShowDialog(); } InitData(strSQL); } //获得编辑按钮的状态 this.btEditfrm.Caption = lpr.Status; }
private void btEditfrm_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gridView1.FocusedRowHandle < 0) { return; } DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle); LP_Record currRecord = new LP_Record(); foreach (DataColumn dc in gridtable.Columns) { if (dc.ColumnName != "Image") { if (dc.DataType.FullName.IndexOf("Byte[]") < 0) currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null); else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "") currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null); } } DataTable dt = RecordWorkTask.GetRecordWorkFlowData(currRecord.ID, MainHelper.User.UserID); if (!RecordWorkTask.HaveRunRecordRole(currRecord.ID, MainHelper.User.UserID)) return; object obj = RecordWorkTask.GetWorkTaskModle(dt); if (obj == null) { return; } if (obj is frmLP) { frmLP frm = new frmLP(); frm.Status = "edit"; frm.CurrRecord = currRecord; frm.ParentTemple = RecordWorkTask.GetWorkTaskTemple(dt, currRecord); if (frm.ParentTemple == null) { MsgBox.ShowWarningMessageBox("出错,未找到该节点关联的表单,请检查模板设置!"); //return; } frm.Kind = strKind; frm.RecordWorkFlowData = dt; if (frm.ShowDialog() == DialogResult.OK) { InitData(strSQL); } } else { if (obj.GetType().GetProperty("IsWorkflowCall") != null) obj.GetType().GetProperty("IsWorkflowCall").SetValue(obj, true, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("CurrRecord") != null) obj.GetType().GetProperty("CurrRecord").SetValue(obj, currRecord, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("RecordWorkFlowData") != null) obj.GetType().GetProperty("RecordWorkFlowData").SetValue(obj, dt, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("ParentTemple") != null) obj.GetType().GetProperty("ParentTemple").SetValue(obj, RecordWorkTask.GetWorkTaskTemple(dt, currRecord), null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj is UserControl) { FormBase dlg = new FormBase(); dlg.Text = ((UserControl)obj).Name; dlg.MdiParent = MainHelper.MainForm; dlg.Controls.Add((UserControl)obj); ((UserControl)obj).Dock = DockStyle.Fill; dlg.Show(); } else if (obj is Form) { if (obj is frmyxfxWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_03yxfx yxfx = new PJ_03yxfx(); if (li.Count > 0) { yxfx = MainHelper.PlatformSqlMap.GetOneByKey<PJ_03yxfx>(li[0].ModleRecordID); } else { yxfx = new PJ_03yxfx(); yxfx.OrgCode = MainHelper.UserOrg.OrgCode; yxfx.OrgName = MainHelper.UserOrg.OrgName; if (parentObj.FlowCaption.IndexOf("定期分析") > 0) yxfx.type = "定期分析"; else if (parentObj.FlowCaption.IndexOf("专题分析") > 0) yxfx.type = "专题分析"; ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; yxfx.rq = DateTime.Now; ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; } switch (dt.Rows[0]["TaskInsCaption"].ToString()) { case "填写": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; break; case "领导检查": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 1; break; case "检查人检查": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 2; break; } yxfx.rq = DateTime.Now; ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; } else if (obj is frmsbqxWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_qxfl qxfl = new PJ_qxfl(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); } else { qxfl = new PJ_qxfl(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; } ((frmsbqxWorkFlowEdit)obj).RowData = qxfl; } ((Form)obj).ShowDialog(); } InitData(strSQL); } //获得编辑按钮的状态 this.btEditfrm.Caption = currRecord.Status; }
private void btReEdit_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (MainHelper.UserOrg == null) return; if (gridView1.FocusedRowHandle >= 0) { DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle) ; PJ_03yxfx yxfx=new PJ_03yxfx (); foreach (DataColumn dc in gridtable.Columns) { if (dc.ColumnName != "Image") yxfx.GetType().GetProperty(dc.ColumnName).SetValue(yxfx, dr[dc.ColumnName], null); } //if (!RecordWorkTask.HaveRunRecordRole(yxfx.ID ,MainHelper.User.UserID )) return; //DataTable dt = RecordWorkTask.GetRecordWorkFlowData(yxfx.ID, MainHelper.User.UserID); frmyxfxEdit fm = new frmyxfxEdit(); //switch (dt.Rows[0]["TaskInsCaption"].ToString()) //{ // case "领导检查": // fm.RecordStatus = 1; // break; // case "检查人检查": // fm.RecordStatus = 2; // break; //} //fm.RecordWorkFlowData = dt; fm.RowData = yxfx; if(fm.ShowDialog()== DialogResult.OK) RefreshData("where orgcode='" + btGdsList.EditValue + "'and type like '%" + recordIkind + "%' order by id desc"); } else { return; } }
public static void ExportExcelWorkFlow(ref LP_Record currRecord, PJ_03yxfx obj) { DSOFramerControl dsoFramerWordControl1 = new DSOFramerControl(); string fname = Application.StartupPath + "\\00记录模板\\03运行分析记录.xls"; dsoFramerWordControl1.FileOpen(fname); if (currRecord == null) { currRecord = new LP_Record(); currRecord.Status = "文档生成"; } currRecord.DocContent = dsoFramerWordControl1.FileDataGzip; dsoFramerWordControl1.FileSave(); dsoFramerWordControl1.FileClose(); dsoFramerWordControl1.FileDataGzip = currRecord.DocContent; ExcelAccess ex = new ExcelAccess(); Excel.Workbook wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook; ex.MyWorkBook = wb; ex.MyExcel = wb.Application; //与会人员之间的间隔符号 string jksign = "@"; int row = 1; int col = 1; //每行显示文字长度 int zc = 60; //获得创建的工作表个数 // int pagemax = 1; string zt = Ecommon.Comparestring(obj.zt, "主题") ? "" : "主题:"; List<string> listztstring = Ecommon.ResultStrList(zt + obj.zt, zc); Ecommon.Resultstrbystartbd(ref listztstring); //if (pagemax < Ecommon.GetPagecount(listztstring.Count,2)) //{ // pagemax = Ecommon.GetPagecount(listztstring.Count, 2); //} string jy = Ecommon.Comparestring(obj.jy, "纪要") ? "" : "纪要:"; List<string> listjy = Ecommon.ResultStrList(jy + obj.jy, zc); Ecommon.Resultstrbystartbd(ref listjy); //if (pagemax < Ecommon.GetPagecount(listjy.Count, 7)) //{ // pagemax = Ecommon.GetPagecount(listjy.Count, 7); //} string jr = Ecommon.Comparestring(obj.jr, "结论及对策") ? "" : "结论及对策:"; List<string> listjldc = Ecommon.ResultStrList(jr + obj.jr, zc); Ecommon.Resultstrbystartbd(ref listjldc); //if (pagemax < Ecommon.GetPagecount(listjldc.Count, 6)) //{ // pagemax = Ecommon.GetPagecount(listjldc.Count, 6); //} List<string> listpy = Ecommon.ResultStrList("领导检查评语:" + obj.py, zc); Ecommon.Resultstrbystartbd(ref listpy); int[] strnumcol = { 0, listztstring.Count, listztstring.Count + listjy.Count, listztstring.Count + listjy.Count + listjldc.Count }; int[] statnum = { 3, 3, 6,7 }; List<string> strcol = new List<string>(); Ecommon.addstring(listztstring, ref strcol); Ecommon.addstring(listjy, ref strcol); Ecommon.addstring(listjldc, ref strcol); Ecommon.addstring(listpy, ref strcol); //Ecommon.CreatandWritesheet(ex, strcol, 15, 9, 1); Ecommon.CreatandWritesheet1(ex, strcol, 15, 9, 1, strnumcol, statnum); //进行加粗 ex.ActiveSheet(1); //时间 ex.SetCellValue(obj.rq.Year.ToString(), 4, 5); ex.SetCellValue(obj.rq.Month.ToString(), 4, 7); ex.SetCellValue(obj.rq.Day.ToString(), 4, 9); ////出席人员 string[] ary = obj.cjry.Split(';'); int n = ary.Length % 5; for (int i = 0; i < ary.Length; i++) { int tempcol = col + 1 + i % 5; if (i % 5 == 1 || i % 5 == 2 || i % 5 == 3) { tempcol = col + 1 + i % 5 + 1; } if (i % 5 == 4) { tempcol = col + 1 + i % 5 + 2; } ex.SetCellValue(ary[i], row + 4 + i / 5, tempcol); } //主持人 ex.SetCellValue(obj.zcr, 5, 11); //检查人签字 //ex.CopySheet(1, 2); //ex.ActiveSheet(2); //ex.SetCellValue("kakaka", 24, 4); //ex.ActiveSheet(1); ex.SetCellValue(obj.qz, 24, 4); //签字时间 // if (ComboBoxHelper.CompreDate(obj.qzrq)) // { // ex.SetCellValue(obj.qzrq.Year.ToString(), 24, 5); // ex.SetCellValue(obj.qzrq.Month.ToString(), 24, 9); // ex.SetCellValue(obj.qzrq.Day.ToString(), 24, 11); // } //将固定的写完再创建不固定的。 //添加变动内容 //for (int j = 1; j <= pagemax;j++ ) //{ // if (j>1) // { // ex.CopySheet(1, 1); // } //} //ex.ShowExcel(); //for (int j = 1; j <= pagemax;j++ ) //{ // ex.ActiveSheet(j); // //if (j>1) // //{ // // // ex.CopySheet(1, j); // // ex.ActiveSheet(j); // //} // //ex.ShowExcel(); // int prepageindex = j - 1; // //主题 // int starow = prepageindex * 2 + 1; // int endrow = j * 2; // if (listztstring.Count>endrow) // { // for (int i = 0; i < 2;i++ ) // { // ex.SetCellValue(listztstring[starow - 1 + i], 9 + i, 1); // } // } // else if (listztstring.Count<=endrow&&listztstring.Count>=starow) // { // for (int i = 0; i < listztstring.Count - starow + 1;i++ ) // { // ex.SetCellValue(listztstring[starow - 1 + i], 9 + i, 1); // } // } // //纪要 // starow = prepageindex * 7 + 1; // endrow = j * 7; // if (listjy.Count > endrow) // { // for (int i = 0; i < 7; i++) // { // ex.SetCellValue(listjy[starow - 1 + i], 11 + i, 1); // } // } // else if (listjy.Count <= endrow && listjy.Count >= starow) // { // for (int i = 0; i < listjy.Count - starow + 1; i++) // { // ex.SetCellValue(listjy[starow - 1 + i], 11+ i, 1); // } // } // //结论及对策 // starow = prepageindex * 6 + 1; // endrow = j * 6; // if (listjldc.Count > endrow) // { // for (int i = 0; i < 6; i++) // { // ex.SetCellValue(listjldc[starow - 1 + i], 18 + i, 1); // } // } // else if (listjldc.Count <= endrow && listjldc.Count >= starow) // { // for (int i = 0; i < listjldc.Count - starow + 1; i++) // { // ex.SetCellValue(listjldc[starow - 1 + i], 18 + i, 1); // } // } //} ////主题: //ex.SetCellValue("主题: " + obj.zt, 9, 1); ////纪要 //string jystr = "纪要:" + obj.jy; //for (int i = 0; i < 7; i++) //{ // string tempstr = ""; // int startnum = i * zc; // int endnum = (i + 1) * zc; // bool ISempty=false; // if (startnum>=jystr.Length) // { // ISempty=true; // } // else if (endnum >= jystr.Length) // { // endnum = jystr.Length; // } // if (!ISempty) // { // tempstr = jystr.Substring(startnum,endnum-startnum); // } // ex.SetCellValue(tempstr, 11 + i, 1); //} ////结论及对策: //string jlstr = "结论及对策:" + obj.jr; //for (int j = 0; j < 6; j++) //{ // string tempstr = ""; // int startnum = j * zc; // int endnum = (j + 1) * zc; // bool ISempty = false; // if (startnum >= jlstr.Length) // { // ISempty = true; // } // else if (endnum >= jlstr.Length) // { // endnum = jlstr.Length; // } // if (!ISempty) // { // tempstr = jlstr.Substring(startnum, endnum - startnum); // } // ex.SetCellValue(tempstr, 18 + j, 1); //} //ex.CopySheet(1,2); //ex.CopySheet(1, 3); //ex.CopySheet(2, 4); if (currRecord == null) { currRecord = new LP_Record(); currRecord.Status = "文档生成"; } dsoFramerWordControl1.FileSave(); currRecord.DocContent = dsoFramerWordControl1.FileDataGzip; dsoFramerWordControl1.FileSave(); dsoFramerWordControl1.FileClose(); }
private void btView_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gridView1.FocusedRowHandle >= 0) { PJ_03yxfx yxfx = new PJ_03yxfx(); DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle); foreach (DataColumn dc in gridtable.Columns) { if (dc.ColumnName != "Image") yxfx.GetType().GetProperty(dc.ColumnName).SetValue(yxfx, dr[dc.ColumnName], null); } Export03.ExportExcel(yxfx); } else { return; } }
private void btReAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (MainHelper.UserOrg == null) return; if (btGdsList.EditValue == null) return; //if (!RecordWorkTask.HaveRewNewYXFXRole(recordIkind, MainHelper.User.UserID)) return; frmyxfxEdit fm = new frmyxfxEdit(); PJ_03yxfx yxfx = new PJ_03yxfx(); //yxfx.OrgCode = MainHelper.UserOrg.OrgCode; IList<mOrg> list = Client.ClientHelper.PlatformSqlMap.GetList<mOrg>("where orgcode='" + btGdsList.EditValue + "'"); mOrg org = null; if (list.Count > 0) org = list[0]; yxfx.OrgCode = btGdsList.EditValue.ToString (); yxfx.OrgName = org.OrgName; yxfx.type = recordIkind; yxfx.rq = DateTime.Now; fm.RowData = yxfx; //fm.RecordStatus = 0; fm.ShowDialog(); //InitData(); RefreshData("where orgcode='" + btGdsList.EditValue + "'and type like '%" + recordIkind + "%' order by id desc"); }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmyxfxEdit fm = new frmyxfxEdit(); PJ_03yxfx yxfx = new PJ_03yxfx(); DataRow dr = gridView1.GetFocusedDataRow(); if (dr == null) return; foreach (DataColumn dc in gridtable.Columns) { if (dc.ColumnName != "Image") yxfx.GetType().GetProperty(dc.ColumnName).SetValue(yxfx, dr[dc.ColumnName], null); } fm.RowData = yxfx; fm.RecordStatus = -1; fm.ShowDialog(); //if (MainHelper.UserOrg == null) return; //if (gridView1.FocusedRowHandle >= 0) //{ // DataRow dr = gridView1.GetFocusedDataRow(); // PJ_03yxfx yxfx = new PJ_03yxfx(); // foreach (DataColumn dc in gridtable.Columns) // { // if (dc.ColumnName != "Image") yxfx.GetType().GetProperty(dc.ColumnName).SetValue(yxfx, dr[dc.ColumnName], null); // } // //if (!RecordWorkTask.HaveRunRecordRole(yxfx.ID, MainHelper.User.UserID)) return; // DataTable dt = RecordWorkTask.GetRecordWorkFlowData(yxfx.ID, MainHelper.User.UserID); // frmyxfxEdit fm = new frmyxfxEdit(); // IList<mUser> lm = ClientHelper.PlatformSqlMap.GetList<mUser>(" where usercode in (select UserID from ruserrole where roleID in (select RoleID from mRole where RoleName in ('生产局长','生技部长') ))"); // string usercode = MainHelper.User.UserCode; // for (int i = 0; i < lm.Count; i++) // { // if (lm[i].UserCode == usercode) // { // if (btReEdit.Caption == "领导检查") // { // fm.RecordStatus = 1; // break; // } // else if (btReEdit.Caption == "检查人检查") // { // fm.RecordStatus = 2; // break; // } // } // else if (i == lm.Count - 1 && lm[i].UserCode != usercode) // { // MsgBox.ShowWarningMessageBox("抱歉,您没有检查权限!"); // return; // } // } // fm.RecordWorkFlowData = dt; // fm.RowData = yxfx; // fm.ShowDialog(); // RefreshData("where orgcode='" + btGdsList.EditValue + "'and type='" + recordIkind + "' order by id desc"); //} //else //{ // return; //} }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PJ_03yxfx newobj) { if (parentID == null) return; newobj.OrgCode = parentID; newobj.OrgName = parentObj.OrgName; newobj.CreateDate = DateTime.Now; Ebada.Core.UserBase m_UserBase = MainHelper.ValidateLogin(); newobj.CreateMan = m_UserBase.RealName; newobj.rq = DateTime.Now; newobj.qzrq = DateTime.Now; }
private void btReAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmyxfxEdit fm = new frmyxfxEdit(); PJ_03yxfx yxfx = new PJ_03yxfx(); if (MainHelper.UserOrg == null) return; string orgcode = ""; if (isJu() && barJU.Visibility== DevExpress.XtraBars.BarItemVisibility.Always) { orgcode = barJU.EditValue.ToString(); } else { orgcode = btGdsList.EditValue.ToString(); } IList<mOrg> list = Client.ClientHelper.PlatformSqlMap.GetList<mOrg>("where orgcode='" + orgcode + "'"); mOrg org = null; if (list.Count > 0) org = list[0]; yxfx.OrgCode = orgcode; yxfx.OrgName = org.OrgName; yxfx.type = recordIkind; yxfx.rq = DateTime.Now; fm.RowData = yxfx; fm.RecordStatus = 0; if (fm.ShowDialog() == DialogResult.OK) { RefreshData("where orgcode='" + orgcode + "'and type='" + recordIkind + "' order by id desc"); } }
private void btReEdit_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmyxfxEdit fm = new frmyxfxEdit(); PJ_03yxfx yxfx = new PJ_03yxfx(); DataRow dr = gridView1.GetFocusedDataRow(); if (dr == null) return; foreach (DataColumn dc in gridtable.Columns) { if (dc.ColumnName != "Image") yxfx.GetType().GetProperty(dc.ColumnName).SetValue(yxfx, dr[dc.ColumnName], null); } fm.RowData = yxfx; if (isJu()) { fm.RecordStatus = 4; } else { fm.RecordStatus = 3; } if (fm.ShowDialog() == DialogResult.OK) { RefreshData("where orgcode='" + yxfx.OrgCode + "'and type='" + yxfx.type + "' order by id desc"); } }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PJ_03yxfx newobj) { if (parentID == null) return; newobj.OrgCode = parentID; newobj.OrgName = parentObj.OrgName; newobj.CreateDate = DateTime.Now; Ebada.Core.UserBase m_UserBase = MainHelper.ValidateLogin(); newobj.CreateMan = m_UserBase.RealName; newobj.rq = DateTime.Now; try { frmLP.ReadTaskData(newobj, RecordWorkFlowData, ParentTemple, CurrRecord); } catch { } }
private void contextmenu_Click(object sender, EventArgs e) { int ihand = gridView1.FocusedRowHandle; if (ihand < 0) return; WF_WorkTaskInstance wti = (sender as MenuItem).Tag as WF_WorkTaskInstance; string taskid = wti.WorkTaskId; string workflowid = wti.WorkFlowId; string workflowinsid = wti.WorkFlowInsId; string pwfid = null; DataRow dr = gridView1.GetDataRow(ihand); LP_Record currRecord = new LP_Record(); currRecord = MainHelper.PlatformSqlMap.GetOneByKey<LP_Record>(dr["ID"].ToString()); string strwhere = string.Format(" where recordid='{0}'", currRecord.ID); IList<WFP_RecordWorkTaskIns> wf = MainHelper.PlatformSqlMap.GetList<WFP_RecordWorkTaskIns>("SelectWFP_RecordWorkTaskInsList", strwhere); //if (wf.Count == 0) { // return; //} else { // workflowinsid = wf[0].WorkFlowInsId; //} if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0]; if (currRecord.SignImg == null) currRecord.SignImg = new byte[0]; if (currRecord.DocContent == null) currRecord.DocContent = new byte[0]; //DataTable dtall = RecordWorkTask.GetRecordWorkFlowData(currRecord.ID, MainHelper.User.UserID); DataTable dtall = new DataTable();// RecordWorkTask.GetRecordWorkFlowData(currRecord.ID, MainHelper.User.UserID); DataTable dt = new DataTable(); DataTable dtret = null; dtret = RecordWorkTask.SelectedWorkflowTask(MainHelper.User.UserID, workflowid, workflowinsid, taskid, 1); if (dtret.Rows.Count == 0) { pwfid = wf[0].WorkFlowInsId; //while (dtret.Rows.Count == 0) { strwhere = string.Format(" where workflowid='{0}' and mainWorkFlowInsId='{1}'", workflowid, pwfid); WF_WorkFlowInstance wfi = MainHelper.PlatformSqlMap.GetOne<WF_WorkFlowInstance>(strwhere); if (wfi == null) { return; } workflowinsid = wfi.WorkFlowInsId; workflowid = wfi.WorkFlowId; dtret = RecordWorkTask.SelectedWorkflowTask(MainHelper.User.UserID, workflowid, workflowinsid, taskid, 1); } } if (dtret == null || dtret.Rows.Count == 0) { if (dtall.Rows.Count < 1) { //if (currRecord.Status == "存档") { // //frmTemplate fm0 = new frmTemplate(); // //fm0.ParentTemple = RecordWorkTask.GetWorkTaskTemple(dt, currRecord); // //fm0.CurrRecord = currRecord; // //fm0.Kind = strKind; // //fm0.Status = "edit"; // //fm0.ShowDialog(); // MsgBox.ShowAskMessageBox("已结束的流程不能在此处查阅。"); //} else { if (wf.Count > 0) { //WF_WorkFlowInstance wfi = MainHelper.PlatformSqlMap.GetOneByKey<WF_WorkFlowInstance>(wf[0].WorkFlowInsId); //string struser = RecordWorkTask.GetWorkFlowTaskOperator(wf[0].WorkTaskInsId); MsgBox.ShowTipMessageBox("没有操作此记录的权限,或者此节点没有相关文档 !"); } } return; } if (dtall.Rows.Count == 1 || currRecord.Status.IndexOf("|") == -1) { dt = dtall; } else { WorkFlowTaskSelectForm wfts = new WorkFlowTaskSelectForm(); wfts.RecordWorkFlowData = dtall; if (wfts.ShowDialog() == DialogResult.OK) { dt = wfts.RetWorkFlowData; } else { return; } } } else { dt = dtret; } //if (!RecordWorkTask.HaveRunRecordRole(currRecord.ID, MainHelper.User.UserID)) return; object obj = RecordWorkTask.GetWorkTaskModle(dt); if (obj == null) { return; } if (obj is frmLP) { frmViewTemplate fm = new frmViewTemplate(); //DataTable dt = RecordWorkTask.GetRecordWorkFlowData(currRecord.ID, MainHelper.User.UserID); fm.ParentTemple = RecordWorkTask.GetWorkTaskTemple(dt, currRecord); fm.CurrRecord = currRecord; fm.Kind = strKind; fm.Status = "edit"; fm.RecordWorkFlowData = dt; fm.ShowDialog(); } else { if (obj.GetType().GetProperty("IsWorkflowCall") != null) obj.GetType().GetProperty("IsWorkflowCall").SetValue(obj, true, null); else { MsgBox.ShowWarningMessageBox("模块不支持IsWorkflowCall,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("CurrRecord") != null) obj.GetType().GetProperty("CurrRecord").SetValue(obj, currRecord, null); else { MsgBox.ShowWarningMessageBox("模块不支持CurrRecord,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("ReadOnly") != null) obj.GetType().GetProperty("ReadOnly").SetValue(obj, true, null); else { MsgBox.ShowWarningMessageBox("模块不支持ReadOnly只读属性,所以无法查看!"); return; } if (obj.GetType().GetProperty("ParentTemple") != null) obj.GetType().GetProperty("ParentTemple").SetValue(obj, RecordWorkTask.GetWorkTaskTemple(dt, currRecord), null); else { MsgBox.ShowWarningMessageBox("模块不支持ParentTemple,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("RecordWorkFlowData") != null) obj.GetType().GetProperty("RecordWorkFlowData").SetValue(obj, dt, null); else { MsgBox.ShowWarningMessageBox("模块不支持RecordWorkFlowData,请咨询开发人员!"); return; } if (obj is UserControl) { FormBase dlg = new FormBase(); dlg.Text = ((UserControl)obj).Name; dlg.MdiParent = MainHelper.MainForm; dlg.Controls.Add((UserControl)obj); ((UserControl)obj).Dock = DockStyle.Fill; dlg.Show(); } else if (obj is Form) { if (obj is frmyxfxWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_03yxfx'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_03yxfx yxfx = new PJ_03yxfx(); if (li.Count > 0) { yxfx = MainHelper.PlatformSqlMap.GetOneByKey<PJ_03yxfx>(li[0].ModleRecordID); } else { yxfx = new PJ_03yxfx(); yxfx.OrgCode = MainHelper.UserOrg.OrgCode; yxfx.OrgName = MainHelper.UserOrg.OrgName; if (parentObj.FlowCaption.IndexOf("定期分析") > 0) yxfx.type = "定期分析"; else if (parentObj.FlowCaption.IndexOf("专题分析") > 0) yxfx.type = "专题分析"; ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; yxfx.rq = DateTime.Now; ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; } switch (dt.Rows[0]["TaskInsCaption"].ToString()) { case "填写": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; break; case "领导检查": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 1; break; case "检查人检查": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 2; break; } yxfx.rq = DateTime.Now; ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; } else if (obj is frmsbqxWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'" + " and ModleTableName='Ebada.Scgl.Model.PJ_qxfl'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_qxfl qxfl = new PJ_qxfl(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); } else { qxfl = new PJ_qxfl(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; qxfl.xssj = DateTime.Today; } ((frmsbqxWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frmWorkFlow06sbxsEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and (ModleTableName='Ebada.Scgl.Model.PJ_qxfl' or ModleTableName='Ebada.Scgl.Model.PJ_06sbxsmx' )" + " order by CreatTime desc"); PJ_06sbxsmx qxfl = new PJ_06sbxsmx(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_06sbxsmx>(li[0].ModleRecordID); PJ_qxfl qxfltemp = MainHelper.PlatformSqlMap.GetOne<PJ_qxfl>(" where CreateDate = '" + qxfl.CreateDate + "'" + " and LineID='" + qxfl.LineID + "'" + " and OrgCode='" + qxfl.OrgCode + "'" + " and qxlb='" + qxfl.qxlb + "'" + " and xsr='" + qxfl.xsr + "'" + " and xlqd='" + qxfl.xlqd + "'" ); if (qxfl == null) { qxfl = new PJ_06sbxsmx(); qxfl.CreateDate = qxfltemp.CreateDate; qxfl.LineID = qxfltemp.LineID; qxfl.LineName = qxfltemp.LineName; qxfl.OrgCode = qxfltemp.OrgCode; qxfl.OrgName = qxfltemp.OrgName; qxfl.qxlb = qxfltemp.qxlb; qxfl.qxnr = qxfltemp.qxnr; qxfl.xssj = qxfltemp.xssj; qxfl.xsr = qxfltemp.xsr; qxfl.xcqx = qxfltemp.xcqx; qxfl.xlqd = qxfltemp.xlqd; qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; //MainHelper.PlatformSqlMap.Create<PJ_06sbxs>(qxfl); //WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); //mrwt.ModleRecordID = qxfl.ID; //mrwt.RecordID = lpr.ID; //mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); //mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); //mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); //mrwt.ModleTableName = qxfl.GetType().ToString(); //mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); //mrwt.CreatTime = DateTime.Now; //MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } } else { qxfl = new PJ_06sbxsmx(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; //MainHelper.PlatformSqlMap.Create<PJ_06sbxs>(qxfl); //WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); //mrwt.ModleRecordID = qxfl.ID; //mrwt.RecordID = lpr.ID; //mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); //mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); //mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); //mrwt.ModleTableName = qxfl.GetType().ToString(); //mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); //mrwt.CreatTime = DateTime.Now; //MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } ((frmWorkFlow06sbxsEdit)obj).RowData = qxfl; } else if (obj is frm08SBTDJXWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_08sbtdjx'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_08sbtdjx qxfl = new PJ_08sbtdjx(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_08sbtdjx>(li[0].ModleRecordID); if (qxfl == null) qxfl = new PJ_08sbtdjx(); } else { qxfl = new PJ_08sbtdjx(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; qxfl.CreateDate = DateTime.Now; string str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='类别' order by id"; WF_TableFieldValue mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str ); //qxfl = new PJ_24(); if (mrv != null) { qxfl.tdxz = mrv.ControlValue; } } ((frm08SBTDJXWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frmsgzaycWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and ModleTableName='Ebada.Scgl.Model.PJ_04sgzayc'" + " order by CreatTime desc"); PJ_04sgzayc qxfl = new PJ_04sgzayc(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_04sgzayc>(li[0].ModleRecordID); if (qxfl == null) qxfl = new PJ_04sgzayc(); } else { qxfl = new PJ_04sgzayc(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; } ((frmsgzaycWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frmTDJHWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_tdjh'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_tdjh qxfl = new PJ_tdjh(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_tdjh>(li[0].ModleRecordID); } else { li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_qxfl'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); qxfl = new PJ_tdjh(); if (li.Count > 0) { PJ_qxfl qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); qxfl.OrgCode = qxfltemp.OrgCode; qxfl.SQOrgname = qxfltemp.OrgName; qxfl.OrgName = qxfltemp.OrgName; qxfl.JXNR = qxfltemp.qxnr; qxfl.S1 = "缺陷管理流程"; } else { qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; } } ((frmTDJHWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frm24WorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_24'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_24 qxfl = new PJ_24(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_24>(li[0].ModleRecordID); } else { string str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='申请原因' order by id"; WF_TableFieldValue mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str); //qxfl = new PJ_24(); if (mrv != null) { qxfl.nr = mrv.ControlValue; } str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='供电所名称' order by id"; mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str ); //qxfl = new PJ_24(); if (mrv != null) { mOrg org = MainHelper.PlatformSqlMap.GetOne<mOrg>(" where orgname='" + mrv.ControlValue + "'"); if (org != null) qxfl.ParentID = org.OrgID; } qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; if (qxfl.BigData == null || qxfl.BigData.Length == 0) { qxfl.BigData = new byte[0]; } } ((frm24WorkFlowEdit)obj).RowData = qxfl; } //年度技改工程计划 else if (obj is frmJGGCJHWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'" + " and ModleTableName='Ebada.Scgl.Model.PJ_jggcjh'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_jggcjh qxfl = new PJ_jggcjh(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_jggcjh>(li[0].ModleRecordID); } else { qxfl = new PJ_jggcjh(); qxfl.OrgName = MainHelper.UserCompany; string str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='申请单位' order by id"; WF_TableFieldValue mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str); //qxfl = new PJ_24(); if (mrv != null) { qxfl.OrgName = mrv.ControlValue; } str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='申请改造项目' order by id"; mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str); //qxfl = new PJ_24(); if (mrv != null) { qxfl.ProjectName = mrv.ControlValue; } str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='主要工程量' order by id"; mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str); //qxfl = new PJ_24(); if (mrv != null) { qxfl.ProjecNR = mrv.ControlValue; } } ((frmJGGCJHWorkFlowEdit)obj).RowData = qxfl; } //26电力线路防护通知书 else if (obj is frm26WorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'" + " and ModleTableName='Ebada.Scgl.Model.PJ_26'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_26 qxfl = new PJ_26(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_26>(li[0].ModleRecordID); } else { qxfl = new PJ_26(); } ((frm26WorkFlowEdit)obj).RowData = qxfl; } if (((Form)obj).ShowDialog() == DialogResult.OK) { if (obj is WorkFlowLineSelectForm) { workFlowFormShow(currRecord, ((WorkFlowLineSelectForm)obj).RetWorkFlowData); } } } } //Bitmap objBitmap = RecordWorkTask.WorkFlowBitmap(dr["ID"].ToString(), new Size(1024, 768)); //string tempPath = Path.GetTempPath(); //string tempfile = tempPath + "~" + Guid.NewGuid().ToString() + ".png"; //if (objBitmap != null) //{ // objBitmap.Save(tempfile, System.Drawing.Imaging.ImageFormat.Png); // try // { // //System.Diagnostics.Process.Start("explorer.exe", tempfile); // SelectorHelper.Execute("rundll32.exe %Systemroot%\\System32\\shimgvw.dll,ImageView_Fullscreen " + tempfile); // } // catch // { // } //} }
/// <summary> /// 打开节点窗口 /// </summary> /// <param name="currRecord"></param> /// <param name="dtret"></param> private void workFlowFormShow(LP_Record currRecord, DataTable dtret) { DataTable dtall = RecordWorkTask.GetRecordWorkFlowData(currRecord.ID, MainHelper.User.UserID); DataTable dt = new DataTable(); if (dtret == null) { if (dtall.Rows.Count < 1) { if (currRecord.Status == "存档") { frmTemplate fm = new frmTemplate(); fm.ParentTemple = RecordWorkTask.GetWorkTaskTemple(dt, currRecord); fm.CurrRecord = currRecord; fm.Kind = strKind; fm.Status = "edit"; fm.ShowDialog(); } else { IList<WFP_RecordWorkTaskIns> wf = MainHelper.PlatformSqlMap.GetList<WFP_RecordWorkTaskIns>("SelectWFP_RecordWorkTaskInsList", "where RecordID='" + currRecord.ID + "'"); if (wf.Count > 0) { WF_WorkFlowInstance wfi = MainHelper.PlatformSqlMap.GetOneByKey<WF_WorkFlowInstance>(wf[0].WorkFlowInsId); string struser = RecordWorkTask.GetWorkFlowTaskOperator(wf[0].WorkTaskInsId); MsgBox.ShowTipMessageBox("没有操作此记录的权限,此记录操作者为 " + struser + " !"); } } return; } if (dtall.Rows.Count == 1 || currRecord.Status.IndexOf("|") == -1) { dt = dtall; } else { WorkFlowTaskSelectForm wfts = new WorkFlowTaskSelectForm(); wfts.RecordWorkFlowData = dtall; if (wfts.ShowDialog() == DialogResult.OK) { dt = wfts.RetWorkFlowData; } else { return; } } } else { dt = dtret; } if (!RecordWorkTask.HaveRunRecordRole(currRecord.ID, MainHelper.User.UserID)) return; object obj = RecordWorkTask.GetWorkTaskModle(dt); if (obj == null) { return; } if (obj is frmLP) { frmLP frm = new frmLP(); //frm.Status = "edit"; frm.Status = RecordWorkTask.GetWorkTaskStatus(dt, currRecord); frm.CurrRecord = currRecord; frm.strxiestatus = "edit"; frm.ParentTemple = RecordWorkTask.GetWorkTaskTemple(dt, currRecord); if (frm.ParentTemple == null) { MsgBox.ShowWarningMessageBox("出错,未找到该节点关联的表单,请检查模板设置!"); //return; } frm.Kind = strKind; frm.RecordWorkFlowData = dt; if (frm.ShowDialog() == DialogResult.OK) { InitData(strKind); } } else { LP_Temple lp = RecordWorkTask.GetWorkTaskTemple(dt, currRecord); object readObj = null; if (obj.GetType().GetProperty("IsWorkflowCall") != null) obj.GetType().GetProperty("IsWorkflowCall").SetValue(obj, true, null); else { MsgBox.ShowWarningMessageBox("模块不支持IsWorkflowCall,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("CurrRecord") != null) obj.GetType().GetProperty("CurrRecord").SetValue(obj, currRecord, null); else { MsgBox.ShowWarningMessageBox("模块不支持CurrRecord,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("ParentTemple") != null) obj.GetType().GetProperty("ParentTemple").SetValue(obj, RecordWorkTask.GetWorkTaskTemple(dt, currRecord), null); else { MsgBox.ShowWarningMessageBox("模块不支持ParentTemple,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("RecordWorkFlowData") != null) obj.GetType().GetProperty("RecordWorkFlowData").SetValue(obj, dt, null); else { MsgBox.ShowWarningMessageBox("模块不支持RecordWorkFlowData,请咨询开发人员!"); return; } if (obj is UserControl) { FormBase dlg = new FormBase(); dlg.Text = ((UserControl)obj).Name; dlg.MdiParent = MainHelper.MainForm; dlg.Controls.Add((UserControl)obj); ((UserControl)obj).Dock = DockStyle.Fill; dlg.Show(); } else if (obj is Form) { if (obj is frmyxfxWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_03yxfx'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_03yxfx yxfx = new PJ_03yxfx(); if (li.Count > 0) { yxfx = MainHelper.PlatformSqlMap.GetOneByKey<PJ_03yxfx>(li[0].ModleRecordID); } else { yxfx = new PJ_03yxfx(); yxfx.OrgCode = MainHelper.UserOrg.OrgCode; yxfx.OrgName = MainHelper.UserOrg.OrgName; if (parentObj.FlowCaption.IndexOf("定期分析") > 0) yxfx.type = "定期分析"; else if (parentObj.FlowCaption.IndexOf("专题分析") > 0) yxfx.type = "专题分析"; ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; yxfx.rq = DateTime.Now; ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; readObj = yxfx; } switch (dt.Rows[0]["TaskInsCaption"].ToString()) { case "填写": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; break; case "领导检查": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 1; break; case "检查人检查": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 2; break; } yxfx.rq = DateTime.Now; ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; } else if (obj is frmsbqxWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and (ModleTableName='Ebada.Scgl.Model.PJ_qxfl' or ModleTableName='Ebada.Scgl.Model.PJ_06sbxsmx')" + " order by CreatTime desc"); PJ_qxfl qxfl = new PJ_qxfl(); if (li.Count > 0) { //qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); //PJ_06sbxsmx qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_06sbxsmx>(li[0].ModleRecordID); PJ_qxfl qxfltemp2 = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); if (qxfltemp2 != null) qxfl = qxfltemp2; //qxfl.CreateDate = qxfltemp.CreateDate; //qxfl.LineID = qxfltemp.LineID; //qxfl.LineName = qxfltemp.LineName; //qxfl.OrgCode = qxfltemp.OrgCode; //qxfl.OrgName = qxfltemp.OrgName; //qxfl.qxlb = qxfltemp.qxlb; //qxfl.qxnr = qxfltemp.qxnr; //qxfl.xssj = qxfltemp.xssj; //qxfl.xsr = qxfltemp.xsr; //qxfl.xcqx = qxfltemp.xcqx; //qxfl.xlqd = qxfltemp.xlqd; //qxfl.CreateDate = DateTime.Now; //qxfl.CreateMan = MainHelper.User.UserName; } else { qxfl = new PJ_qxfl(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; qxfl.xssj = DateTime.Today; qxfl.CreateMan = MainHelper.User.UserName; readObj = qxfl; } ((frmsbqxWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frmWorkFlow06sbxsEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and (ModleTableName='Ebada.Scgl.Model.PJ_qxfl' or ModleTableName='Ebada.Scgl.Model.PJ_06sbxsmx' )" + " order by CreatTime desc"); PJ_06sbxsmx qxfl = new PJ_06sbxsmx(); if (li.Count > 0) { PJ_06sbxsmx qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_06sbxsmx>(li[0].ModleRecordID); if (qxfltemp != null) qxfl = qxfltemp; else { //qxfl = qxfltemp; //if (qxfl == null) { // qxfl = new PJ_06sbxsmx(); // qxfl.CreateDate = qxfltemp.CreateDate; // qxfl.LineID = qxfltemp.LineID; // qxfl.LineName = qxfltemp.LineName; // qxfl.OrgCode = qxfltemp.OrgCode; // qxfl.OrgName = qxfltemp.OrgName; // qxfl.qxlb = qxfltemp.qxlb; // qxfl.qxnr = qxfltemp.qxnr; // qxfl.xssj = qxfltemp.xssj; // qxfl.xsr = qxfltemp.xsr; // qxfl.xcqx = qxfltemp.xcqx; // qxfl.xlqd = qxfltemp.xlqd; // qxfl.CreateDate = DateTime.Now; // qxfl.CreateMan = MainHelper.User.UserName; //MainHelper.PlatformSqlMap.Create<PJ_06sbxs>(qxfl); //WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); //mrwt.ModleRecordID = qxfl.ID; //mrwt.RecordID = lpr.ID; //mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); //mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); //mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); //mrwt.ModleTableName = qxfl.GetType().ToString(); //mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); //mrwt.CreatTime = DateTime.Now; //MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); //} } } else { qxfl = new PJ_06sbxsmx(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; MainHelper.PlatformSqlMap.Create<PJ_06sbxs>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = dt.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = dt.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = dt.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = dt.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); readObj = qxfl; } ((frmWorkFlow06sbxsEdit)obj).RowData = qxfl; } else if (obj is frm08SBTDJXWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_qxfl'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_08sbtdjx qxfl = new PJ_08sbtdjx(); if (li.Count > 0) { PJ_qxfl qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_08sbtdjx'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_08sbtdjx>(li[0].ModleRecordID); readObj = qxfl; } else { qxfl.OrgCode = qxfltemp.OrgCode; qxfl.OrgName = qxfltemp.OrgName; qxfl.LineID = qxfltemp.LineID; qxfl.LineName = qxfltemp.LineName; qxfl.jxnr = qxfltemp.qxnr; if (qxfltemp.qxlb == "紧急缺陷") { qxfl.tdxz = "事故停电"; } else if (qxfltemp.qxlb == "重大缺陷") { qxfl.tdxz = "临时停电"; } else if (qxfltemp.qxlb == "一般缺陷") { qxfl.tdxz = "一般缺陷"; } qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; MainHelper.PlatformSqlMap.Create<PJ_08sbtdjx>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = dt.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = dt.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = dt.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = dt.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); readObj = qxfl; } } else { qxfl = new PJ_08sbtdjx(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; qxfl.CreateDate = DateTime.Now; string str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='类别' order by id"; WF_TableFieldValue mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str ); //qxfl = new PJ_24(); if (mrv != null) { qxfl.tdxz = mrv.ControlValue; } MainHelper.PlatformSqlMap.Create<PJ_08sbtdjx>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = dt.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = dt.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = dt.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = dt.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); readObj = qxfl; } ((frm08SBTDJXWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frmsgzaycWorkFlowEdit) { PJ_04sgzayc qxfl = null; IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and ModleTableName='Ebada.Scgl.Model.PJ_04sgzayc'" + " order by CreatTime desc"); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_04sgzayc>(li[0].ModleRecordID); } if (qxfl == null) { li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and ModleTableName='Ebada.Scgl.Model.PJ_08sbtdjx'" + " order by CreatTime desc"); qxfl = new PJ_04sgzayc(); if (li.Count > 0) { PJ_08sbtdjx qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_08sbtdjx>(li[0].ModleRecordID); qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_04sgzayc>(li[0].ModleRecordID); if (qxfl == null) { qxfl = new PJ_04sgzayc(); qxfl.OrgCode = qxfltemp.OrgCode; qxfl.OrgName = qxfltemp.OrgName; qxfl.sdsj = qxfltemp.sdsj; qxfl.tdsj = qxfltemp.tdsj; qxfl.gtdsj = ""; TimeSpan span = qxfl.sdsj.Subtract(qxfl.tdsj); if (span.Days > 0) qxfl.gtdsj += span.Days + "天"; if (span.Hours > 0) qxfl.gtdsj += span.Hours + "时"; if (span.Minutes > -1) qxfl.gtdsj += span.Minutes + "分"; qxfl.fsdd = qxfltemp.jxnr; qxfl.CreateDate = DateTime.Now; qxfl.ID = qxfl.ID; qxfl.CreateMan = MainHelper.User.UserName; MainHelper.PlatformSqlMap.Create<PJ_04sgzayc>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = dt.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = dt.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = dt.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = dt.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); readObj = qxfl; } } else { qxfl = new PJ_04sgzayc(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; qxfl.CreateMan = MainHelper.User.UserName; MainHelper.PlatformSqlMap.Create<PJ_04sgzayc>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = dt.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = dt.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = dt.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = dt.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); readObj = qxfl; } } ((frmsgzaycWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frmTDJHWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_tdjh'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_tdjh qxfl = new PJ_tdjh(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_tdjh>(li[0].ModleRecordID); } else { li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_qxfl'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); qxfl = new PJ_tdjh(); if (li.Count > 0) { PJ_qxfl qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); qxfl.OrgCode = qxfltemp.OrgCode; qxfl.SQOrgname = qxfltemp.OrgName; qxfl.OrgName = qxfltemp.OrgName; qxfl.JXNR = qxfltemp.qxnr; qxfl.S1 = "缺陷管理流程"; } else { qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; } MainHelper.PlatformSqlMap.Create<PJ_tdjh>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = dt.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = dt.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = dt.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = dt.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); readObj = qxfl; } ((frmTDJHWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frm24WorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_24'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_24 qxfl = new PJ_24(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_24>(li[0].ModleRecordID); } else { string str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='申请原因' order by id"; WF_TableFieldValue mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str); //qxfl = new PJ_24(); if (mrv != null) { qxfl.nr = mrv.ControlValue; } str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='供电所名称' order by id"; mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str ); //qxfl = new PJ_24(); if (mrv != null) { mOrg org = MainHelper.PlatformSqlMap.GetOne<mOrg>(" where orgname='" + mrv.ControlValue + "'"); if (org != null) qxfl.ParentID = org.OrgID; } qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; if (qxfl.BigData == null || qxfl.BigData.Length == 0) { qxfl.BigData = new byte[0]; } MainHelper.PlatformSqlMap.Create<PJ_24>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = dt.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = dt.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = dt.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = dt.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); readObj = qxfl; } ((frm24WorkFlowEdit)obj).RowData = qxfl; } //年度技改工程计划 else if (obj is frmJGGCJHWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'" + " and ModleTableName='Ebada.Scgl.Model.PJ_jggcjh'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_jggcjh qxfl = new PJ_jggcjh(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_jggcjh>(li[0].ModleRecordID); } else { qxfl = new PJ_jggcjh(); qxfl.OrgName = MainHelper.UserCompany; string str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='申请单位' order by id"; WF_TableFieldValue mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str); //qxfl = new PJ_24(); if (mrv != null) { qxfl.OrgName = mrv.ControlValue; } str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='申请改造项目' order by id"; mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str); //qxfl = new PJ_24(); if (mrv != null) { qxfl.ProjectName = mrv.ControlValue; } str = " where RecordID='" + currRecord.ID + "'" + " and FieldName='主要工程量' order by id"; mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str); //qxfl = new PJ_24(); if (mrv != null) { qxfl.ProjecNR = mrv.ControlValue; } readObj = qxfl; } ((frmJGGCJHWorkFlowEdit)obj).RowData = qxfl; } //26电力线路防护通知书 else if (obj is frm26WorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'" + " and ModleTableName='Ebada.Scgl.Model.PJ_26'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_26 qxfl = new PJ_26(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_26>(li[0].ModleRecordID); } else { qxfl = new PJ_26(); readObj = qxfl; } ((frm26WorkFlowEdit)obj).RowData = qxfl; } if (readObj != null) frmLP.ReadTaskData(readObj, dt, lp, currRecord); if (((Form)obj).ShowDialog() == DialogResult.OK) { if (obj is WorkFlowLineSelectForm) { workFlowFormShow(currRecord, ((WorkFlowLineSelectForm)obj).RetWorkFlowData); } } } InitData(strKind); } //获得编辑按钮的状态 this.btEditfrm.Caption = currRecord.Status; }
private void btAddfrm_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (MainHelper.UserOrg == null) return; if (!RecordWorkTask.HaveRunNewGZPRole(strKind, MainHelper.User.UserID)) return; DataTable recordWorkFlowData = null; object obj = RecordWorkTask.GetNewWorkTaskModle(strKind, MainHelper.User.UserID); if (obj == null) { MsgBox.ShowWarningMessageBox("出错,未找到对应的模块,请检查模板设置!"); return; } LP_Record lpr = new LP_Record(); lpr.ID = "N" + lpr.CreateID(); lpr.Kind = strKind; lpr.CreateTime = DateTime.Now.ToString(); lpr.OrgName = MainHelper.UserOrg.OrgName; if (obj is frmLP) { frmLP frm = new frmLP(); frm.strxiestatus = "add"; frm.Status = "add"; frm.Kind = strKind; string[] strtemp = RecordWorkTask.RunNewGZPRecord(lpr.ID, strKind, MainHelper.User.UserID, false); //frm.ParentTemple = RecordWorkTask.GetNewWorkTaskTemple(strKind, MainHelper.User.UserID); //frm.RecordWorkFlowData = RecordWorkTask.GetGZPRecordSartWorkData(ParentObj.FlowCaption, MainHelper.User.UserID); frm.RecordWorkFlowData = RecordWorkTask.GetRecordWorkFlowData(lpr.ID, MainHelper.User.UserID); recordWorkFlowData = frm.RecordWorkFlowData; if (frm.RecordWorkFlowData == null) { MsgBox.ShowWarningMessageBox("出错,未找到该流程信息,请检查模板设置!"); } frm.ParentTemple = RecordWorkTask.GetWorkTaskTemple(frm.RecordWorkFlowData, lpr); if (frm.ParentTemple == null) { MsgBox.ShowWarningMessageBox("出错,未找到该节点关联的表单,请检查模板设置!"); } lpr.Number = RecordWorkTask.CreatWorkFolwNo(MainHelper.UserOrg, frm.ParentTemple.LPID, lpr.Kind); lpr.Status = frm.RecordWorkFlowData.Rows[0]["TaskCaption"].ToString(); //lpr.Status = "填票"; //frm.RowData = lpr; frm.CurrRecord = lpr; MainHelper.PlatformSqlMap.Create<LP_Record>(lpr); frm.ShowDialog(); InitData(strKind); } else { string[] strtemp = RecordWorkTask.RunNewGZPRecord(lpr.ID, strKind, MainHelper.User.UserID, false); if (strtemp[0].IndexOf("未提交至任何人") > -1) { MsgBox.ShowTipMessageBox("未提交至任何人,创建失败,请检查流程模板和组织机构配置是否正确!"); return; } recordWorkFlowData = RecordWorkTask.GetRecordWorkFlowData(lpr.ID, MainHelper.User.UserID); if (recordWorkFlowData == null) { MsgBox.ShowWarningMessageBox("出错,未找到该流程信息,请检查模板设置!"); } LP_Temple ParentTemple = RecordWorkTask.GetWorkTaskTemple(recordWorkFlowData, lpr); if (ParentTemple == null) lpr.Number = RecordWorkTask.CreatWorkFolwNo(MainHelper.UserOrg, "", strKind); else lpr.Number = RecordWorkTask.CreatWorkFolwNo(MainHelper.UserOrg, ParentTemple.LPID, strKind); lpr.Status = recordWorkFlowData.Rows[0]["TaskCaption"].ToString(); MainHelper.PlatformSqlMap.Create<LP_Record>(lpr); if (obj.GetType().GetProperty("IsWorkflowCall") != null) obj.GetType().GetProperty("IsWorkflowCall").SetValue(obj, true, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("CurrRecord") != null) obj.GetType().GetProperty("CurrRecord").SetValue(obj, lpr, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("ParentTemple") != null) obj.GetType().GetProperty("ParentTemple").SetValue(obj, ParentTemple, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("RecordWorkFlowData") != null) obj.GetType().GetProperty("RecordWorkFlowData").SetValue(obj, recordWorkFlowData, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj is UserControl) { FormBase dlg = new FormBase(); dlg.Text = ((UserControl)obj).Name; dlg.MdiParent = MainHelper.MainForm; dlg.Controls.Add((UserControl)obj); ((UserControl)obj).Dock = DockStyle.Fill; dlg.Show(); } else if (obj is Form) { if (obj is frmyxfxWorkFlowEdit) { PJ_03yxfx yxfx = new PJ_03yxfx(); yxfx.OrgCode = MainHelper.UserOrg.OrgCode; yxfx.OrgName = MainHelper.UserOrg.OrgName; if (parentObj.FlowCaption.IndexOf("定期分析") > 0) yxfx.type = "定期分析"; else if (parentObj.FlowCaption.IndexOf("专题分析") > 0) yxfx.type = "专题分析"; ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; yxfx.rq = DateTime.Now; ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; } else if (obj is frmsbqxWorkFlowEdit) { PJ_qxfl qxfl = new PJ_qxfl(); qxfl = new PJ_qxfl(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; ((frmsbqxWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frmWorkFlow06sbxsEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + lpr.ID + "'" + " and WorkFlowId='" + recordWorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_06sbxsmx'" + " and WorkFlowInsId='" + recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_06sbxsmx qxfl = new PJ_06sbxsmx(); if (li.Count > 0) { PJ_qxfl qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); qxfl = MainHelper.PlatformSqlMap.GetOne<PJ_06sbxsmx>(" where CONVERT(varchar, CreateDate, 120 ) = '" + qxfltemp.CreateDate + "'" + " and LineID='" + qxfltemp.LineID + "'" + " and OrgCode='" + qxfltemp.OrgCode + "'" + " and qxlb='" + qxfltemp.qxlb + "'" + " and xsr='" + qxfltemp.xsr + "'" + " and xlqd='" + qxfltemp.xlqd + "'" ); if (qxfl == null) { qxfl = new PJ_06sbxsmx(); qxfl.CreateDate = qxfltemp.CreateDate; qxfl.LineID = qxfltemp.LineID; qxfl.LineName = qxfltemp.LineName; qxfl.OrgCode = qxfltemp.OrgCode; qxfl.OrgName = qxfltemp.OrgName; qxfl.qxlb = qxfltemp.qxlb; qxfl.qxnr = qxfltemp.qxnr; qxfl.xssj = qxfltemp.xssj; qxfl.xsr = qxfltemp.xsr; qxfl.xcqx = qxfltemp.xcqx; qxfl.xlqd = qxfltemp.xlqd; qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; //MainHelper.PlatformSqlMap.Create<PJ_06sbxs>(qxfl); //WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); //mrwt.ModleRecordID = qxfl.ID; //mrwt.RecordID = lpr.ID; //mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); //mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); //mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); //mrwt.ModleTableName = qxfl.GetType().ToString(); //mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); //mrwt.CreatTime = DateTime.Now; //MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } } else { qxfl = new PJ_06sbxsmx(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; //MainHelper.PlatformSqlMap.Create<PJ_06sbxs>(qxfl); //WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); //mrwt.ModleRecordID = qxfl.ID; //mrwt.RecordID = lpr.ID; //mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); //mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); //mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); //mrwt.ModleTableName = qxfl.GetType().ToString(); //mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); //mrwt.CreatTime = DateTime.Now; //MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } ((frmWorkFlow06sbxsEdit)obj).RowData = qxfl; } else if (obj is frm08SBTDJXWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + lpr.ID + "'" + " and WorkFlowId='" + recordWorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_qxfl'" + " and WorkFlowInsId='" + recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_08sbtdjx qxfl = new PJ_08sbtdjx(); if (li.Count > 0) { PJ_qxfl qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + lpr.ID + "'" + " and WorkFlowId='" + recordWorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_08sbtdjx'" + " and WorkFlowInsId='" + recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_08sbtdjx>(li[0].ModleRecordID); } else { qxfl.OrgCode = qxfltemp.OrgCode; qxfl.OrgName = qxfltemp.OrgName; qxfl.LineID = qxfltemp.LineID; qxfl.LineName = qxfltemp.LineName; qxfl.jxnr = qxfltemp.qxnr; if (qxfltemp.qxlb == "紧急缺陷") { qxfl.tdxz = "事故停电"; } else if (qxfltemp.qxlb == "重大缺陷") { qxfl.tdxz = "临时停电"; } else if (qxfltemp.qxlb == "一般缺陷") { qxfl.tdxz = "一般缺陷"; } qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; MainHelper.PlatformSqlMap.Create<PJ_08sbtdjx>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = lpr.ID; mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } } else { qxfl = new PJ_08sbtdjx(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; qxfl.CreateDate = DateTime.Now; string str = " where RecordID='" + lpr.ID + "'" + " and FieldName='类别' order by id"; WF_TableFieldValue mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str ); //qxfl = new PJ_24(); if (mrv != null) { qxfl.tdxz = mrv.ControlValue; } MainHelper.PlatformSqlMap.Create<PJ_08sbtdjx>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = lpr.ID; mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } ((frm08SBTDJXWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frmsgzaycWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + lpr.ID + "'" + " and WorkFlowId='" + recordWorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_08sbtdjx'" + " and WorkFlowInsId='" + recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_04sgzayc qxfl = new PJ_04sgzayc(); if (li.Count > 0) { PJ_08sbtdjx qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_08sbtdjx>(li[0].ModleRecordID); qxfl.OrgCode = qxfltemp.OrgCode; qxfl.OrgName = qxfltemp.OrgName; qxfl.sdsj = qxfltemp.sdsj; qxfl.tdsj = qxfltemp.tdsj; qxfl.gtdsj = ""; TimeSpan span = qxfl.sdsj.Subtract(qxfl.tdsj); if (span.Days > 0) qxfl.gtdsj += span.Days + "天"; if (span.Hours > 0) qxfl.gtdsj += span.Hours + "时"; if (span.Minutes > -1) qxfl.gtdsj += span.Minutes + "分"; qxfl.fsdd = qxfltemp.jxnr; qxfl.CreateDate = DateTime.Now; MainHelper.PlatformSqlMap.Create<PJ_04sgzayc>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = lpr.ID; mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } else { qxfl = new PJ_04sgzayc(); qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; MainHelper.PlatformSqlMap.Create<PJ_04sgzayc>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = lpr.ID; mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } ((frmsgzaycWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frmTDJHWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + lpr.ID + "'" + " and WorkFlowId='" + recordWorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_tdjh'" + " and WorkFlowInsId='" + recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_tdjh qxfl = new PJ_tdjh(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_tdjh>(li[0].ModleRecordID); } else { li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + lpr.ID + "'" + " and WorkFlowId='" + recordWorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_qxfl'" + " and WorkFlowInsId='" + recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); qxfl = new PJ_tdjh(); if (li.Count > 0) { PJ_qxfl qxfltemp = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID); qxfl.OrgCode = qxfltemp.OrgCode; qxfl.SQOrgname = qxfltemp.OrgName; qxfl.OrgName = qxfltemp.OrgName; qxfl.JXNR = qxfltemp.qxnr; qxfl.S1 = "缺陷管理流程"; } else { qxfl.OrgCode = MainHelper.UserOrg.OrgCode; qxfl.OrgName = MainHelper.UserOrg.OrgName; } MainHelper.PlatformSqlMap.Create<PJ_tdjh>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = lpr.ID; mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } ((frmTDJHWorkFlowEdit)obj).RowData = qxfl; } else if (obj is frm24WorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + lpr.ID + "'" + " and WorkFlowId='" + recordWorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and ModleTableName='Ebada.Scgl.Model.PJ_24'" + " and WorkFlowInsId='" + recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_24 qxfl = new PJ_24(); if (li.Count > 0) { qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_24>(li[0].ModleRecordID); } else { string str = " where RecordID='" + lpr.ID + "'" + " and FieldName='申请原因' order by id"; WF_TableFieldValue mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str ); //qxfl = new PJ_24(); if (mrv != null) { qxfl.nr = mrv.ControlValue; } str = " where RecordID='" + lpr.ID + "'" + " and FieldName='供电所名称' order by id"; mrv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(str ); //qxfl = new PJ_24(); if (mrv != null) { mOrg org = MainHelper.PlatformSqlMap.GetOne<mOrg>(" where orgname='" + mrv.ControlValue + "'"); if (org != null) qxfl.ParentID = org.OrgID; } qxfl.CreateDate = DateTime.Now; qxfl.CreateMan = MainHelper.User.UserName; if (qxfl.BigData == null || qxfl.BigData.Length == 0) { qxfl.BigData = new byte[0]; } MainHelper.PlatformSqlMap.Create<PJ_24>(qxfl); WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = qxfl.ID; mrwt.RecordID = lpr.ID; mrwt.WorkFlowId = recordWorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = recordWorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = recordWorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfl.GetType().ToString(); mrwt.WorkTaskInsId = recordWorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } ((frm24WorkFlowEdit)obj).RowData = qxfl; } if (((Form)obj).ShowDialog() == DialogResult.OK) { if (obj is WorkFlowLineSelectForm) { workFlowFormShow(lpr); } } } InitData(strKind); } /* IList wfli = MainHelper.PlatformSqlMap.GetList("SelectOneStr", " select distinct tlcid from WF_WorkTastTrans where slcid='" + recordWorkFlowData.Rows[0]["WorkFlowId"] + "' and cdfs like '下拉%' "); foreach (string strwf in wfli) { WF_WorkFlow wf = MainHelper.PlatformSqlMap.GetOneByKey<WF_WorkFlow>(strwf); LP_Record lp = new LP_Record(); lp.ID = "N" + lp.CreateID(); lp.Kind = wf.FlowCaption; lp.CreateTime = DateTime.Now.ToString(); lp.OrgName = MainHelper.UserOrg.OrgName; lp.ParentID = lpr.ID; RecordWorkTask.RunNewGZPRecord(lp.ID, lp.Kind, MainHelper.User.UserID, false); DataTable dttemp = RecordWorkTask.GetRecordWorkFlowData(lp.ID, MainHelper.User.UserID); lp.Number = RecordWorkTask.CreatWorkFolwNo(MainHelper.UserOrg, "", lp.Kind); lp.Status = dttemp.Rows[0]["TaskCaption"].ToString(); MainHelper.PlatformSqlMap.Create<LP_Record>(lp); Thread.Sleep(new TimeSpan(100000));//0.1毫秒 }*/ //获得编辑按钮的状态 this.btEditfrm.Caption = lpr.Status; }
private void repositoryItemHyperLinkEdit1_Click(object sender, EventArgs e) { int ihand = gridTalskView.FocusedRowHandle; if (ihand < 0) return; DataRow dr = gridTalskView.GetDataRow(ihand); //mModule md = MainHelper.PlatformSqlMap.GetOneByKey<mModule>(dr["Modu_ID"]); //if (md != null) //{ // PlatForm.OpenModule(md); //} IList<WFP_RecordWorkTaskIns> rwt = MainHelper.PlatformSqlMap.GetList<WFP_RecordWorkTaskIns>("SelectWFP_RecordWorkTaskInsList", "where WorkFlowId='" + dr["WorkFlowId"] + "' and WorkFlowInsId='" + dr["WorkFlowInsId"] + "'"); if (rwt.Count == 0) return; LP_Record currRecord= MainHelper.PlatformSqlMap.GetOneByKey<LP_Record>(rwt[0].RecordID); if (currRecord == null) { MainHelper.PlatformSqlMap.DeleteByWhere<WF_ModleRecordWorkTaskIns>(" where WorkFlowInsId='" + rwt[0].WorkFlowInsId + "'"); MainHelper.PlatformSqlMap.DeleteByWhere<WF_OperatorInstance>(" where (WorkFlowInsId='" + rwt[0].WorkFlowInsId + "')"); MainHelper.PlatformSqlMap.DeleteByWhere<WF_WorkTaskInstance>(" where (WorkFlowInsId='" + rwt[0].WorkFlowInsId + "')"); MainHelper.PlatformSqlMap.DeleteByWhere<WF_WorkFlowInstance>(" where (WorkFlowInsId='" + rwt[0].WorkFlowInsId + "')"); return; } DataTable dt = RecordWorkTask.GetRecordWorkFlowData(currRecord.ID, MainHelper.User.UserID); object obj = RecordWorkTask.GetWorkTaskModle(dr["WorkFlowId"].ToString(), dr["WorkTaskId"].ToString()); if (obj == null) { return; } if (obj is frmLP) { frmLP frm = new frmLP(); frm.Status = "edit"; frm.CurrRecord = currRecord; frm.ParentTemple = RecordWorkTask.GetWorkTaskTemple(dt, currRecord); if (frm.ParentTemple == null) { MsgBox.ShowWarningMessageBox("未找到该节点关联的表单,请检查模板设置!"); //return; } frm.Kind = dr["FlowCaption"].ToString(); frm.RecordWorkFlowData = dt; frm.ShowDialog(); refreshTreeData(); } else { if (obj.GetType().GetProperty("IsWorkflowCall") != null) obj.GetType().GetProperty("IsWorkflowCall").SetValue(obj, true, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("CurrRecord") != null) obj.GetType().GetProperty("CurrRecord").SetValue(obj, currRecord, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("RecordWorkFlowData") != null) obj.GetType().GetProperty("RecordWorkFlowData").SetValue(obj, dt, null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj.GetType().GetProperty("ParentTemple") != null) obj.GetType().GetProperty("ParentTemple").SetValue(obj, RecordWorkTask.GetWorkTaskTemple(dt, currRecord), null); else { MsgBox.ShowWarningMessageBox("模块不支持,请咨询开发人员!"); return; } if (obj is UserControl) { FormBase dlg = new FormBase(); dlg.Text = ((UserControl)obj).Name; dlg.MdiParent = MainHelper.MainForm; dlg.Controls.Add((UserControl)obj); ((UserControl)obj).Dock = DockStyle.Fill; dlg.Show(); } else if (obj is Form) { if (obj is frmyxfxWorkFlowEdit) { IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'" + " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc"); PJ_03yxfx yxfx = new PJ_03yxfx(); if (li.Count > 0) { yxfx = MainHelper.PlatformSqlMap.GetOneByKey<PJ_03yxfx>(li[0].ModleRecordID); } else { yxfx = new PJ_03yxfx(); yxfx.OrgCode = MainHelper.UserOrg.OrgCode; yxfx.OrgName = MainHelper.UserOrg.OrgName; if (dr["FlowCaption"].ToString().IndexOf("定期分析") > 0) yxfx.type = "定期分析"; else if (dr["FlowCaption"].ToString().IndexOf("专题分析") > 0) yxfx.type = "专题分析"; ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; yxfx.rq = DateTime.Now; ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; } switch (dt.Rows[0]["TaskInsCaption"].ToString()) { case "填写": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 0; break; case "领导检查": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 1; break; case "检查人检查": ((frmyxfxWorkFlowEdit)obj).RecordStatus = 2; break; } ((frmyxfxWorkFlowEdit)obj).RowData = yxfx; } ((Form)obj).ShowDialog(); } } }