private void btView_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //frm06sbxsLine frm = new frm06sbxsLine(); //frm.orgcode = btGdsList.EditValue.ToString(); //if (frm.ShowDialog()==DialogResult.OK) //{ // IList<PJ_06sbxs> pj06list = new List<PJ_06sbxs>(); // pj06list = Client.ClientHelper.PlatformSqlMap.GetList<PJ_06sbxs>(" where LineName='" + frm.linename + "'"); // if (pj06list.Count>0) // { // Export06.ExportExcel(pj06list); // } // else // { // MsgBox.ShowTipMessageBox("此线路没有添加巡视情况。"); // return; // } //} if (gridView1.FocusedRowHandle >= 0) { bool xsmxflag = false; //是否有巡视的子表 frmExportYearSelect frm = new frmExportYearSelect(); DataTable dt = new DataTable(); dt.Columns.Add("A", typeof(string)); dt.Columns.Add("B", typeof(bool)); if (frm.ShowDialog() == DialogResult.OK) { DataRow[] dtc = frm.DT1.Select("B=1"); foreach (DataRow dr1 in dtc) { DataRow dr = dt.NewRow(); dr[0] = dr1[0].ToString(); dr[1] = Convert.ToInt32(dr1[1]); dt.Rows.Add(dr); } dtc = frm.DT1.Select("D=1"); foreach (DataRow dr1 in dtc) { DataRow dr = dt.NewRow(); dr[0] = dr1[2].ToString(); dr[1] = Convert.ToInt32(dr1[3]); dt.Rows.Add(dr); } dtc = frm.DT1.Select("F=1"); foreach (DataRow dr1 in dtc) { DataRow dr = dt.NewRow(); dr[0] = dr1[4].ToString(); dr[1] = Convert.ToInt32(dr1[5]); dt.Rows.Add(dr); } Dictionary<string, List<PJ_06sbxs>> diclist = new Dictionary<string, List<PJ_06sbxs>>(); PJ_06sbxs _pj = gridView1.GetRow(gridView1.FocusedRowHandle) as PJ_06sbxs; //添加明细表的信息 IList<PJ_06sbxsmx> ilist = null; if (dt.Rows.Count == 0) { ilist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_06sbxsmx>(" where ParentID='" + _pj.ID + "' order by CreateDate desc"); } else { string sely = "("; for (int i = 0; i < dt.Rows.Count; i++) { if (i < dt.Rows.Count - 1) { sely += "'" + dt.Rows[i][0].ToString() + "',"; } else sely += "'" + dt.Rows[i][0].ToString() + "')"; } ilist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_06sbxsmx>(" where ParentID='" + _pj.ID + "'and year(xssj) in" + sely + "order by CreateDate desc"); } if (ilist.Count == 0) { xsmxflag = false; List<PJ_06sbxs> lispj = new List<PJ_06sbxs>(); lispj.Add(_pj); diclist[_pj.LineID] = lispj; } else { xsmxflag = true; List<PJ_06sbxs> lispj = new List<PJ_06sbxs>(); diclist[_pj.LineID] = lispj; foreach (PJ_06sbxsmx pmx in ilist) { PJ_06sbxs newpj = new PJ_06sbxs(); Type obj = newpj.GetType(); foreach (PropertyInfo p in obj.GetProperties()) { try { p.SetValue(newpj, pmx.GetType().GetProperty(p.Name).GetValue(pmx, null), null); } catch (Exception ex) { } } diclist[_pj.LineID].Add(newpj); } // lispj.Add(_pj); } foreach (KeyValuePair<string, List<PJ_06sbxs>> pp in diclist) { List<PJ_06sbxs> objlist = pp.Value; if (objlist.Count > 0) { Export06.ExportExcel(objlist, xsmxflag); } } } } //for (int i = 0; i < gridView1.RowCount;i++ ) //{ // PJ_06sbxs _pj = gridView1.GetRow(i) as PJ_06sbxs; // if (diclist.ContainsKey(_pj.LineID)) // { // diclist[_pj.LineID].Add(_pj); // } // else // { // List<PJ_06sbxs> lispj = new List<PJ_06sbxs>(); // lispj.Add(_pj); // diclist[_pj.LineID] = lispj; // } // //添加明细表的信息 // IList<PJ_06sbxsmx> ilist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_06sbxsmx>(" where ParentID='" + _pj.ID + "' order by CreateDate desc"); // foreach (PJ_06sbxsmx pmx in ilist) // { // PJ_06sbxs newpj = new PJ_06sbxs(); // Type obj = newpj.GetType(); // foreach (PropertyInfo p in obj.GetProperties()) // { // try // { // p.SetValue(newpj, p.GetValue(pmx, null), null); // } // catch { } // } // diclist[_pj.LineID].Add(newpj); // } //} //foreach (KeyValuePair<string, List<PJ_06sbxs>> pp in diclist) //{ // List<PJ_06sbxs> objlist = pp.Value; // if (objlist.Count > 0) // { // Export06.ExportExcel(objlist); // } //} }
void gridViewOperation_AfterAdd(PJ_06sbxs obj) { //RefreshData("where byqID='" + PSObj.byqID + "'"); if (isWorkflowCall) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = obj.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = obj.GetType().ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PJ_06sbxs 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.xssj = DateTime.Now; try { frmLP.ReadTaskData(newobj, RecordWorkFlowData, ParentTemple, CurrRecord); } catch { } }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PJ_06sbxs 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.xssj = DateTime.Now; }
void ucTop_FocusedRowChanged(object sender, PJ_06sbxs obj) { ucBottom.ParentObj = obj; //splitCC1.Panel2.Text = "测量记录:" + (obj != null ? obj.kymc : ""); }
void gridViewOperation_AfterAdd(PJ_06sbxs newobj) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); if (isWorkflowCall) { mrwt.ModleRecordID = newobj.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = newobj.GetType().ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); //currRecord.DocContent = newobj.BigData; //MainHelper.PlatformSqlMap.Update<LP_Record>(currRecord); } if (newobj.qxlb != "") { PJ_qxfl qxfj = new PJ_qxfl(); qxfj.ID = newobj.ID; qxfj.CreateDate = newobj.CreateDate; qxfj.CreateMan = newobj.CreateMan; qxfj.LineID = newobj.LineID; qxfj.LineName = newobj.LineName; qxfj.OrgCode = newobj.OrgCode; qxfj.OrgName = newobj.OrgName; qxfj.qxlb = newobj.qxlb; qxfj.qxly = "设备巡视"; qxfj.qxnr = newobj.qxnr; qxfj.xcqx = newobj.xcqx; qxfj.xcr = newobj.xcr; qxfj.xlqd = newobj.xlqd; qxfj.xsr = newobj.xsr; qxfj.xssj = newobj.xssj; MainHelper.PlatformSqlMap.Create<PJ_qxfl>(qxfj); Thread.Sleep(new TimeSpan(100000));//0.1毫秒 mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ID = mrwt.CreateID(); mrwt.ModleRecordID = qxfj.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = qxfj.GetType().ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } }
void gridViewOperation_AfterEdit(PJ_06sbxs newobj) { PJ_qxfl qxfj = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(newobj.ID); if (qxfj != null && newobj.qxlb != "") { qxfj.LineID = newobj.LineID; qxfj.LineName = newobj.LineName; qxfj.qxlb = newobj.qxlb; qxfj.qxnr = newobj.qxnr; qxfj.xcqx = newobj.xcqx; qxfj.xcr = newobj.xcr; qxfj.xlqd = newobj.xlqd; qxfj.xsr = newobj.xsr; qxfj.xssj = newobj.xssj; MainHelper.PlatformSqlMap.Update<PJ_qxfl>(qxfj); } else if (qxfj != null) { MainHelper.PlatformSqlMap.Delete<PJ_qxfl>(qxfj); } }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PJ_06sbxs 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.xssj = DateTime.Now; if (isWorkflowCall) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = newobj.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.ModleTableName = newobj.GetType().ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } }
private void btnOK_Click(object sender, EventArgs e) { PJ_06sbxsmx sbxs = RowData as PJ_06sbxsmx; string strmes = ""; object obj = MainHelper.PlatformSqlMap.GetOneByKey<PJ_06sbxsmx>(sbxs.ID); PJ_qxfl qxfj = new PJ_qxfl(); if (obj == null) { obj = MainHelper.PlatformSqlMap.GetOne<PJ_06sbxs>("where OrgCode='" + sbxs.OrgCode + "' and LineID='" + sbxs.LineID + "' and xlqd='" + sbxs.xlqd + "'"); if (obj == null) { PJ_06sbxs sbxstemp = new PJ_06sbxs(); sbxstemp.OrgCode = sbxs.OrgCode; sbxstemp.OrgName = sbxs.OrgName; sbxstemp.LineID = sbxs.LineID; sbxstemp.LineName = sbxs.LineName; sbxstemp.xlqd = sbxs.xlqd; sbxstemp.xsr = sbxs.xsr; sbxstemp.xssj = DateTime.Now; sbxstemp.CreateMan = MainHelper.User.UserName; MainHelper.PlatformSqlMap.Create<PJ_06sbxs>(sbxstemp); sbxs.ParentID = sbxstemp.ID; } else { sbxs.ParentID = (obj as PJ_06sbxs).ID; } MainHelper.PlatformSqlMap.Create<PJ_06sbxsmx>(sbxs); //WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); //mrwt.ModleRecordID = sbxs.ID; //mrwt.RecordID = currRecord.ID; //mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); //mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); //mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); //mrwt.ModleTableName = sbxs.GetType().ToString(); //mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); //mrwt.CreatTime = DateTime.Now; //MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); if (sbxs.qxlb != "") { qxfj.CreateDate = sbxs.CreateDate; qxfj.CreateMan = sbxs.CreateMan; qxfj.LineID = sbxs.LineID; qxfj.LineName = sbxs.LineName; qxfj.OrgCode = sbxs.OrgCode; qxfj.OrgName = sbxs.OrgName; qxfj.qxlb = sbxs.qxlb; qxfj.qxly = "设备巡视"; qxfj.qxnr = sbxs.qxnr; qxfj.xcqx = sbxs.xcqx; qxfj.xcr = sbxs.xcr; qxfj.xlqd = sbxs.xlqd; qxfj.xsr = sbxs.xsr; qxfj.xssj = sbxs.xssj; MainHelper.PlatformSqlMap.Create<PJ_qxfl>(qxfj); } } else { PJ_qxfl qxfltemp = MainHelper.PlatformSqlMap.GetOne<PJ_qxfl>(" where CONVERT(varchar, CreateDate, 120 ) = '" + sbxs.CreateDate + "'" + " and LineID='" + sbxs.LineID + "'" + " and OrgCode='" + sbxs.OrgCode + "'" + " and qxlb='" + sbxs.qxlb + "'" + " and xsr='" + sbxs.xsr + "'" + " and xlqd='" + sbxs.xlqd + "'" ); if (qxfltemp != null) { qxfltemp.LineID = sbxs.LineID; qxfltemp.LineName = sbxs.LineName; qxfltemp.OrgCode = sbxs.OrgCode; qxfltemp.OrgName = sbxs.OrgName; qxfltemp.qxlb = sbxs.qxlb; qxfltemp.qxnr = sbxs.qxnr; qxfltemp.xssj = sbxs.xssj; qxfltemp.xsr = sbxs.xsr; qxfltemp.xcqx = sbxs.xcqx; qxfltemp.xlqd = sbxs.xlqd; ; qxfltemp.xcr = sbxs.xcr; qxfltemp.xcrq = sbxs.xcrq; MainHelper.PlatformSqlMap.Update<PJ_qxfl>(qxfltemp); } MainHelper.PlatformSqlMap.Update<PJ_06sbxsmx>(sbxs); } currRecord.LastChangeTime = DateTime.Now.ToString(); if (RecordWorkTask.CheckOnRiZhi(WorkFlowData)) { RecordWorkTask.CreatRiZhi(WorkFlowData, null, currRecord.ID, new object[] { sbxs, qxfj, currRecord }); } WF_WorkTaskCommands wt; //string[] strtemp = RecordWorkTask.RunNewGZPRecord(currRecord.ID, kind, MainHelper.User.UserID); wt = (WF_WorkTaskCommands)MainHelper.PlatformSqlMap.GetObject("SelectWF_WorkTaskCommandsList", " where WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'"); if (wt != null) { strmes = RecordWorkTask.RunWorkFlow(MainHelper.User.UserID, WorkFlowData.Rows[0]["OperatorInsId"].ToString(), WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(), wt.CommandName); } else { strmes = RecordWorkTask.RunWorkFlow(MainHelper.User.UserID, WorkFlowData.Rows[0]["OperatorInsId"].ToString(), WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(), "提交"); } if (strmes.IndexOf("未提交至任何人") > -1) { MsgBox.ShowTipMessageBox("未提交至任何人,创建失败,请检查流程模板和组织机构配置是否正确!"); return; } else MsgBox.ShowTipMessageBox(strmes); strmes = RecordWorkTask.GetWorkFlowTaskCaption(WorkFlowData.Rows[0]["WorkTaskInsId"].ToString()); if (strmes == "结束节点1") { currRecord.Status = "存档"; } else { currRecord.Status = strmes; } if (currRecord.ImageAttachment == null) { currRecord.ImageAttachment = new byte[0]; } if (currRecord.DocContent == null) { currRecord.DocContent = new byte[0]; } if (currRecord.SignImg == null) { currRecord.SignImg = new byte[0]; } currRecord.LastChangeTime = DateTime.Now.ToString(); if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0]; if (currRecord.SignImg == null) currRecord.SignImg = new byte[0]; MainHelper.PlatformSqlMap.Update("UpdateLP_Record", currRecord); //if (obj == null ) {//&& (sbxs.qxlb != "") // DataTable dttemp = RecordWorkTask.GetRecordWorkFlowData(currRecord.ID); // if (dttemp.Rows.Count > 0) { // Thread.Sleep(new TimeSpan(100000));//0.1毫秒 // WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); // mrwt.ID = mrwt.CreateID(); // mrwt.ModleRecordID = sbxs.ID; // mrwt.RecordID = currRecord.ID; // mrwt.WorkFlowId = dttemp.Rows[0]["WorkFlowId"].ToString(); // mrwt.WorkFlowInsId = dttemp.Rows[0]["WorkFlowInsId"].ToString(); // mrwt.WorkTaskId = dttemp.Rows[0]["WorkTaskId"].ToString(); // mrwt.ModleTableName = sbxs.GetType().ToString(); // mrwt.WorkTaskInsId = dttemp.Rows[0]["WorkTaskInsId"].ToString(); // mrwt.CreatTime = DateTime.Now; // MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); // } //} }
public static void update(PJ_06sbxsmx qxjl) { PJ_06sbxsmx sbxs = qxjl; string strmes = ""; object obj = MainHelper.PlatformSqlMap.GetOneByKey<PJ_06sbxsmx>(sbxs.ID); PJ_qxfl qxfj = new PJ_qxfl(); if (obj == null) { obj = MainHelper.PlatformSqlMap.GetOne<PJ_06sbxs>("where OrgCode='" + sbxs.OrgCode + "' and LineID='" + sbxs.LineID + "' and xlqd='" + sbxs.xlqd + "'"); if (obj == null) { PJ_06sbxs sbxstemp = new PJ_06sbxs(); sbxstemp.OrgCode = sbxs.OrgCode; sbxstemp.OrgName = sbxs.OrgName; sbxstemp.LineID = sbxs.LineID; sbxstemp.LineName = sbxs.LineName; sbxstemp.xlqd = sbxs.xlqd; sbxstemp.xssj = DateTime.Now; sbxstemp.CreateMan = MainHelper.User.UserName; MainHelper.PlatformSqlMap.Create<PJ_06sbxs>(sbxstemp); sbxs.ParentID = sbxstemp.ID; } else { sbxs.ParentID = (obj as PJ_06sbxs).ID; } MainHelper.PlatformSqlMap.Create<PJ_06sbxsmx>(sbxs); } else { PJ_06sbxsmx qxfltemp = obj as PJ_06sbxsmx; qxfltemp.LineID = sbxs.LineID; qxfltemp.LineName = sbxs.LineName; qxfltemp.OrgCode = sbxs.OrgCode; qxfltemp.OrgName = sbxs.OrgName; qxfltemp.qxlb = sbxs.qxlb; qxfltemp.qxnr = sbxs.qxnr; qxfltemp.xssj = sbxs.xssj; qxfltemp.xsr = sbxs.xsr; qxfltemp.xcqx = sbxs.xcqx; qxfltemp.xlqd = sbxs.xlqd; ; qxfltemp.xcr = sbxs.xcr; qxfltemp.xcrq = sbxs.xcrq; MainHelper.PlatformSqlMap.Update<PJ_06sbxsmx>(qxfltemp); } }