/// <summary>
/// 新建对象设置Key值
/// </summary>
/// <param name="newobj"></param>
void gridViewOperation_CreatingObjectEvent(PJ_04sgzayc newobj) {
if (parentID == null) return;
Ebada.Core.UserBase m_UserBase = MainHelper.ValidateLogin();
newobj.CreateMan = m_UserBase.RealName;
newobj.OrgCode = parentID;
newobj.OrgName = parentObj.OrgName;
newobj.CreateDate = DateTime.Now;
try { frmLP.ReadTaskData(newobj, RecordWorkFlowData, ParentTemple, CurrRecord); } catch { }
}
/// <summary>
/// 文档格式预定义好的，只填写内容
/// </summary>
/// <param name="obj"></param>
public static void ExportExcel(PJ_04sgzayc obj)
{
ExcelAccess ex = new ExcelAccess();
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname = Application.StartupPath + "\\00记录模板\\04事故障碍异常运行记录.xls";
ex.Open(fname);
//与会人员之间的间隔符号
string jksign = "@";
int row = 1;
int col = 1;
//每行显示文字长度
int zc = 33;
//要发生变化的部分
//List<string>[] bhcollect = new List<string>[3] { Ecommon.ResultStrList("三、事故、障碍、异常运行情况及处理经过：" + obj.clqk, zc), Ecommon.ResultStrList("四、主要原因分析：" + obj.yyfx, zc), Ecommon.ResultStrList("五、今后防止对策：" + obj.fzdc, zc) };
//int[] hs = new int[3] { 4, 5, 5 };
//int[] starow = new int[3] { 9, 13, 18 };
//Ecommon.CreatandWritesheet(ex, bhcollect, hs, starow);
List<string> strcol = new List<string>();
string sgyc = Ecommon.Comparestring(obj.clqk, "三") ? "" : "三、事故、障碍、异常运行情况及处理经过：";
string zyyy = Ecommon.Comparestring(obj.yyfx, "四") ? "" : "四、主要原因分析：";
string jhdc = Ecommon.Comparestring(obj.fzdc, "五") ? "" : "五、今后防止对策：";
string sgzyc = sgyc + obj.clqk;
string zyyuy = zyyy + obj.yyfx;
string fzdc = jhdc + obj.fzdc;
//Ecommon.addstring(Ecommon.ResultStrList(sgyc+ obj.clqk, zc), ref strcol);
//Ecommon.addstring(Ecommon.ResultStrList(zyyy + obj.yyfx, zc), ref strcol);
//Ecommon.addstring(Ecommon.ResultStrList(jhdc + obj.fzdc, zc), ref strcol);
//Ecommon.CreatandWritesheet(ex, strcol, 14, 9, 1);
ex.ActiveSheet(1);
//事故异常发生地点
ex.SetCellValue(obj.fsdd, 5, 6);
//发生时间
//停电时间
ex.SetCellValue(obj.tdsj.Month.ToString(), 6, 5);
ex.SetCellValue(obj.tdsj.Day.ToString(), 6, 7);
ex.SetCellValue(obj.tdsj.Hour.ToString(), 6, 9);
ex.SetCellValue(obj.tdsj.Minute.ToString(), 6, 11);
//送电时间
ex.SetCellValue(obj.sdsj.Month.ToString(), 7, 5);
ex.SetCellValue(obj.sdsj.Day.ToString(), 7, 7);
ex.SetCellValue(obj.sdsj.Hour.ToString(), 7, 9);
ex.SetCellValue(obj.sdsj.Minute.ToString(), 7, 11);
//时间间隔
int data1 = (obj.sdsj -obj.tdsj ).Days;
int hour1 = (obj.sdsj -obj.tdsj ).Hours+data1*24;
int min1 = (obj.sdsj-obj.tdsj ).Minutes;
ex.SetCellValue(hour1.ToString(),7, 17);
ex.SetCellValue(min1.ToString(),7, 19);
//损失电量
ex.SetCellValue(obj.ssdl.ToString(),8,5);
//ex.SetCellValue(obj.rq.Month.ToString(), 4, 7);
//ex.SetCellValue(obj.rq.Day.ToString(), 4, 9);
//防治对策执行人
ex.SetCellValue(obj.zxr, 23, 8);
//记录填写人
ex.SetCellValue(obj.CreateMan, 24, 8);
ex.SetCellValue(obj.CreateDate.Month.ToString(), 24, 15);
ex.SetCellValue(obj.CreateDate.Day.ToString(), 24, 17);
//事故障碍异常
//string hdstr = Ecommon.Comparestring(obj.hdnr, "活动内容") ? "" : "活动内容：";
//List<string> hdlist = Ecommon.ResultStrListByPage(hdstr, obj.clqk, zc, 8);
string jd1 = "";
string jd2 = "";
bool flag = true;
if (sgzyc.Contains("处理人"))
{
jd1 = sgzyc.Substring(0, sgzyc.LastIndexOf("处理人"));
jd2 = sgzyc.Substring(sgzyc.LastIndexOf("处理人"));
}
else
jd1 = sgzyc;
//for (int i = 0; i < 4; i++)
//{
// string tempstr = "";
// int startnum = i * zc;
// int endnum = (i + 1) * zc;
// bool ISempty = false;
// if (startnum >= sgzyc.Length)
// {
// ISempty = true;
// }
// else if (endnum >= sgzyc.Length)
// {
// endnum = sgzyc.Length;
// }
// if (!ISempty)
// {
// tempstr = sgzyc.Substring(startnum, endnum - startnum);
// }
// ex.SetCellValue(tempstr, 9 + i, 1);
//}
for (int i = 0; i < 4; i++)
{
string tempstr = "";
int startnum = i * zc;
int endnum = (i + 1) * zc;
bool ISempty = false;
if (sgzyc.Length>3*zc)
{
jd1 = sgzyc;
}
else if (sgzyc.Length<=3 * zc&&!string.IsNullOrEmpty(jd2))
{
ex.SetCellValue(jd2, 12, 1);
}
if (startnum >= jd1.Length)
{
ISempty = true;
}
else if (endnum >= jd1.Length)
{
endnum = jd1.Length;
}
if (!ISempty)
{
tempstr = jd1.Substring(startnum, endnum - startnum);
ex.SetCellValue(tempstr, 9 + i, 1);
}
}
//主要原因分析
for (int i = 0; i < 5; i++)
{
string tempstr = "";
int startnum = i * zc;
int endnum = (i + 1) * zc;
bool ISempty = false;
if (startnum >= zyyuy.Length)
{
ISempty = true;
}
else if (endnum >= zyyuy.Length)
{
endnum = zyyuy.Length;
}
if (!ISempty)
{
tempstr = zyyuy.Substring(startnum, endnum - startnum);
}
ex.SetCellValue(tempstr, 13 + i, 1);
}
//今后放置对策
for (int i = 0; i < 5; i++)
{
string tempstr = "";
int startnum = i * zc;
int endnum = (i + 1) * zc;
bool ISempty = false;
if (startnum >= fzdc.Length)
{
ISempty = true;
}
else if (endnum >= fzdc.Length)
{
endnum = fzdc.Length;
}
if (!ISempty)
{
tempstr = fzdc.Substring(startnum, endnum - startnum);
}
ex.SetCellValue(tempstr, 18 + i, 1);
}
ex.ShowExcel();
}
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;
}
/// <summary>
/// 新建对象设置Key值
/// </summary>
/// <param name="newobj"></param>
void gridViewOperation_CreatingObjectEvent(PJ_04sgzayc newobj) {
if (parentID == null) return;
Ebada.Core.UserBase m_UserBase = MainHelper.ValidateLogin();
newobj.CreateMan = m_UserBase.RealName;
newobj.OrgCode = parentID;
newobj.OrgName = parentObj.OrgName;
newobj.CreateDate = DateTime.Now;
}