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