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