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();
}
}
}
