public static void CreatRiZhi(PJ_13dlbhjl obj) { PJ_gzrjnr gzr = new PJ_gzrjnr(); gzr.gzrjID = gzr.CreateID(); gzr.ParentID = obj.ID; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 IList<PJ_01gzrj> gzrj01 = MainHelper.PlatformSqlMap.GetList<PJ_01gzrj>("SelectPJ_01gzrjList", "where GdsCode='" + MainHelper.User.OrgCode + "' and rq between '" + DateTime.Now.ToString("yyyy-MM-dd 00:00:00") + "' and '" + DateTime.Now.ToString("yyyy-MM-dd 23:59:59") + "'"); if (gzrj01.Count > 0) { gzr.gzrjID = gzrj01[0].gzrjID; } else { PJ_01gzrj pj = new PJ_01gzrj(); pj.gzrjID = pj.CreateID(); pj.GdsCode = MainHelper.User.OrgCode; pj.GdsName = MainHelper.User.OrgName; pj.CreateDate = DateTime.Now; pj.CreateMan = MainHelper.User.UserName; gzr.gzrjID = pj.gzrjID; pj.rq = DateTime.Now.Date; pj.xq = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(DateTime.Now.DayOfWeek); pj.rsaqts = (DateTime.Today - MainHelper.UserOrg.PSafeTime.Date).Days; pj.sbaqts = (DateTime.Today - MainHelper.UserOrg.DSafeTime.Date).Days; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 MainHelper.PlatformSqlMap.Create<PJ_01gzrj>(pj); } IList<PJ_gzrjnr> gzrlist = MainHelper.PlatformSqlMap.GetList<PJ_gzrjnr>("SelectPJ_gzrjnrList", "where gzrjID = '" + gzr.gzrjID + "' order by seq "); if (gzrlist.Count > 0) { gzr.seq = gzrlist[gzrlist.Count - 1].seq + 1; } else gzr.seq = 1; gzr.gznr = "全所目前运行的×个台区剩余电流动作保护期测试"; gzr.fzr = "配电班长"; string[] strli = obj.csr.Split(';'); if (strli.Length < 3) gzr.cjry = obj.csr; else { gzr.cjry = strli[0] + "、" + strli[1] + "等" + strli.Length + "人"; } gzr.CreateDate = DateTime.Now; gzr.CreateMan = MainHelper.User.UserName; gzr.fssj = DateTime.Now; MainHelper.PlatformSqlMap.Create<PJ_gzrjnr>(gzr); }
public static void CreatRiZhi(PJ_09pxjl obj) { PJ_gzrjnr gzr = new PJ_gzrjnr(); gzr.gzrjID = gzr.CreateID(); gzr.ParentID = obj.ID; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 IList<PJ_01gzrj> gzrj01 = MainHelper.PlatformSqlMap.GetList<PJ_01gzrj>("SelectPJ_01gzrjList", "where GdsCode='" + MainHelper.User.OrgCode + "' and rq between '" + obj.rq.ToString("yyyy-MM-dd 00:00:00") + "' and '" + obj.rq.ToString("yyyy-MM-dd 23:59:59") + "'"); if (gzrj01.Count > 0) { gzr.gzrjID = gzrj01[0].gzrjID; } else { PJ_01gzrj pj = new PJ_01gzrj(); pj.gzrjID = pj.CreateID(); pj.GdsCode = obj.OrgCode; pj.GdsName = obj.OrgName; pj.CreateDate = obj.rq; pj.CreateMan = MainHelper.User.UserName; gzr.gzrjID = pj.gzrjID; pj.rq = obj.rq; pj.xq = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(DateTime.Now.DayOfWeek); pj.rsaqts = (DateTime.Today - MainHelper.UserOrg.PSafeTime.Date).Days; pj.sbaqts = (DateTime.Today - MainHelper.UserOrg.DSafeTime.Date).Days; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 MainHelper.PlatformSqlMap.Create<PJ_01gzrj>(pj); } IList<PJ_gzrjnr> gzrlist = MainHelper.PlatformSqlMap.GetList<PJ_gzrjnr>("SelectPJ_gzrjnrList", "where gzrjID = '" + gzr.gzrjID + "' order by seq "); if (gzrlist.Count > 0) { gzr.seq = gzrlist[gzrlist.Count - 1].seq + 1; } else gzr.seq = 1; gzr.gznr =obj.hydd+ "职工培训"; gzr.fzr = obj.zcr; gzr.cjry = obj.zcr + "等" + gzr.cjry + "人"; gzr.CreateDate = obj.rq; gzr.CreateMan = MainHelper.User.UserName; gzr.fssj = obj.rq; MainHelper.PlatformSqlMap.Create<PJ_gzrjnr>(gzr); }
private void btnOK_Click(object sender, EventArgs e) { //if (recordStatus == 0) //{ PJ_gzrjnr gzr = new PJ_gzrjnr(); PJ_03yxfx yxfx = RowData as PJ_03yxfx; object obj = MainHelper.PlatformSqlMap.GetOneByKey<PJ_03yxfx>(yxfx.ID); if (obj == null) { rowData.gznrID = gzr.gznrID; gzr.ParentID = yxfx.ID; yxfx.CreateDate = DateTime.Now; yxfx.CreateMan = MainHelper.User.UserName; IList<PJ_01gzrj> gzrj01 = MainHelper.PlatformSqlMap.GetList<PJ_01gzrj>("SelectPJ_01gzrjList", "where rq between '" + rowData.rq.ToString("yyyy-MM-dd 00:00:00") + "' and '" + rowData.rq.ToString("yyyy-MM-dd 23:59:59") + "'"); if (gzrj01.Count > 0) { gzr.gzrjID = gzrj01[0].gzrjID; } else { PJ_01gzrj pj = new PJ_01gzrj(); pj.gzrjID = pj.CreateID(); pj.GdsCode = rowData.OrgCode; pj.GdsName = rowData.OrgName; pj.CreateDate = rowData.rq; pj.CreateMan = MainHelper.User.UserName; gzr.gzrjID = pj.gzrjID; pj.rq = rowData.rq; pj.xq = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(DateTime.Now.DayOfWeek); pj.rsaqts = (DateTime.Today - MainHelper.UserOrg.PSafeTime.Date).Days; pj.sbaqts = (DateTime.Today - MainHelper.UserOrg.DSafeTime.Date).Days; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 MainHelper.PlatformSqlMap.Create<PJ_01gzrj>(pj); } IList<PJ_gzrjnr> gzrlist = MainHelper.PlatformSqlMap.GetList<PJ_gzrjnr>("SelectPJ_gzrjnrList", "where ParentID = '" + gzr.ParentID + "' order by seq "); if (gzrlist.Count > 0) { gzr.seq = gzrlist[gzrlist.Count - 1].seq + 1; } else gzr.seq = 1; gzr.gznr = yxfx.hydd + "运行分析-" + yxfx.type; gzr.fzr = yxfx.zcr; gzr.fssj = yxfx.rq; string[] ss = yxfx.cjry.Split(';'); if (ss.Length >= 1) { gzr.cjry = ss[0] + ss[1]; if (ss.Length > 2) gzr.cjry = gzr.cjry + "等"; gzr.cjry = gzr.cjry + ss.Length + "人"; } else { gzr.cjry = gzr.fzr; } MainHelper.PlatformSqlMap.Create<PJ_gzrjnr>(gzr); MainHelper.PlatformSqlMap.Create<PJ_03yxfx>(yxfx); } else { yxfx.CreateDate = yxfx.rq; MainHelper.PlatformSqlMap.Update<PJ_03yxfx>(RowData); } //string strmes = RecordWorkTask.RunNewYXFXRecord(rowData.ID, yxfx.type,MainHelper.User.UserID ); //if (strmes.IndexOf("未提交至任何人") > -1) //{ // MsgBox.ShowTipMessageBox("未提交至任何人,创建失败,请检查流程模板和组织机构配置是否正确!"); // return; //} //else // MsgBox.ShowTipMessageBox(strmes); //if (gzrj01.Count > 0) // MainHelper.PlatformSqlMap.Create<PJ_gzrjnr>(gzr); //MainHelper.PlatformSqlMap.Create<PJ_03yxfx>(yxfx); //this.Close(); //} //else //{ // //try // //{ // // string 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); // //} // //catch (System.Exception ex) // //{ // //} // MainHelper.PlatformSqlMap.Update<PJ_03yxfx>(RowData); //} //this.Close(); }
/// <summary> /// 获了内容记录 /// </summary> /// <param name="pid"></param> /// <returns></returns> private static IList<PJ_gzrjnr> getRjnrList(string pid) { IList<PJ_gzrjnr> list = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_gzrjnr>(" where gzrjID='" + pid + "' order by seq"); IList<PJ_gzrjnr> list2 = new List<PJ_gzrjnr>(); int nrows = 0; for (int i = 0; i < list.Count; i++) { PJ_gzrjnr nr = list[i]; List<string> lines = Ecommon.ResultStrList(nr.gznr, 34); //string[] lines = nr.gznr.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries); nr.gznr = ""; int j = 0; foreach (string line in lines) { j++; nrows++; if (j == 1) { nr.gznr = line; list2.Add(nr); } else { PJ_gzrjnr newnr = new PJ_gzrjnr(); newnr.gznr = line; list2.Add(newnr); } } } return list2; }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PJ_gzrjnr newobj) { if (parentID == null) return; newobj.gzrjID = parentID; newobj.CreateDate = DateTime.Now; newobj.fssj = DateTime.Now; newobj.seq = getSeq(); }
/// <summary> /// 生成日志记录 /// </summary> /// <param name="WorkFlowData">流程数据信息</param> /// <param name="dsoFramerWordControl1">Excel控件</param> /// <param name="recordID">记录ID</param> /// <param name="modlecordlist">模块相关记录集</param> public static void CreatRiZhi(DataTable WorkFlowData, DSOFramerControl dsoFramerWordControl1, string recordID, params object[] modlecordlist) { WF_TaskVar tvAddress = RecordWorkTask.GetWorkTaskRiZhi(WorkFlowData, "工作地点"); WF_TaskVar tvProject = RecordWorkTask.GetWorkTaskRiZhi(WorkFlowData, "项目"); WF_TaskVar tvCharMan = RecordWorkTask.GetWorkTaskRiZhi(WorkFlowData, "负责人"); WF_TaskVar tvAttendMan = RecordWorkTask.GetWorkTaskRiZhi(WorkFlowData, "参加人员"); PJ_gzrjnr gzr = new PJ_gzrjnr(); gzr.gzrjID = gzr.CreateID(); gzr.ParentID = recordID; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 IList<PJ_01gzrj> gzrj01 = MainHelper.PlatformSqlMap.GetList<PJ_01gzrj>("SelectPJ_01gzrjList", "where GdsCode='" + MainHelper.User.OrgCode + "' and rq between '" + DateTime.Now.ToString("yyyy-MM-dd 00:00:00") + "' and '" + DateTime.Now.ToString("yyyy-MM-dd 23:59:59") + "'"); if (gzrj01.Count > 0) { gzr.gzrjID = gzrj01[0].gzrjID; //gzrj01[0].GdsCode = MainHelper.User.OrgCode; //gzrj01[0].GdsName = MainHelper.User.OrgName; //MainHelper.PlatformSqlMap.Update<PJ_01gzrj>(gzrj01[0]); } else { PJ_01gzrj pj = new PJ_01gzrj(); pj.gzrjID = pj.CreateID(); pj.GdsCode = MainHelper.User.OrgCode; pj.GdsName = MainHelper.User.OrgName; pj.CreateDate = DateTime.Now; pj.CreateMan = MainHelper.User.UserName; gzr.gzrjID = pj.gzrjID; pj.rq = DateTime.Now.Date; pj.xq = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(DateTime.Now.DayOfWeek); pj.rsaqts = (DateTime.Today - MainHelper.UserOrg.PSafeTime.Date).Days; pj.sbaqts = (DateTime.Today - MainHelper.UserOrg.DSafeTime.Date).Days; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 MainHelper.PlatformSqlMap.Create<PJ_01gzrj>(pj); //MsgBox.ShowWarningMessageBox("未填写今日工作日记"); //return; } IList<PJ_gzrjnr> gzrlist = MainHelper.PlatformSqlMap.GetList<PJ_gzrjnr>("SelectPJ_gzrjnrList", "where gzrjID = '" + gzr.gzrjID + "' order by seq "); if (gzrlist.Count > 0) { gzr.seq = gzrlist[gzrlist.Count - 1].seq + 1; } else gzr.seq = 1; gzr.gznr = GetTaskVarRiZhiValue(tvAddress, dsoFramerWordControl1, recordID, GetModleRecordObj(tvAddress, modlecordlist)) + GetTaskVarRiZhiValue(tvProject, dsoFramerWordControl1, recordID, GetModleRecordObj(tvProject, modlecordlist)); gzr.fzr = GetTaskVarRiZhiValue(tvCharMan, dsoFramerWordControl1, recordID, GetModleRecordObj(tvCharMan, modlecordlist)); gzr.cjry = GetTaskVarRiZhiValue(tvAttendMan, dsoFramerWordControl1, recordID, GetModleRecordObj(tvAttendMan, modlecordlist)); gzr.CreateDate = DateTime.Now; gzr.CreateMan = MainHelper.User.UserName; gzr.fssj = DateTime.Now; MainHelper.PlatformSqlMap.Create<PJ_gzrjnr>(gzr); }
private void btnOK_Click(object sender, EventArgs e) { string strmes = ""; PJ_03yxfx yxfx = RowData as PJ_03yxfx; object obj = MainHelper.PlatformSqlMap.GetOneByKey<PJ_03yxfx>(yxfx.ID); if (obj == null) { yxfx.CreateDate = DateTime.Now; yxfx.CreateMan = MainHelper.User.UserName; MainHelper.PlatformSqlMap.Create<PJ_03yxfx>(yxfx); if (isWorkflowCall) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = yxfx.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 = yxfx.GetType().ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } PJ_gzrjnr gzr = new PJ_gzrjnr(); gzr.ParentID = yxfx.ID; IList<PJ_01gzrj> gzrj01 = MainHelper.PlatformSqlMap.GetList<PJ_01gzrj>("SelectPJ_01gzrjList", "where GdsCode='" + MainHelper.User.OrgCode + "' and rq between '" + DateTime.Now.ToString("yyyy-MM-dd 00:00:00") + "' and '" + DateTime.Now.ToString("yyyy-MM-dd 23:59:59") + "'"); if (gzrj01.Count > 0) { gzr.gzrjID = gzrj01[0].gzrjID; } else { PJ_01gzrj pj = new PJ_01gzrj(); pj.gzrjID = pj.CreateID(); pj.GdsCode = MainHelper.User.OrgCode; pj.GdsName = MainHelper.User.OrgName; pj.CreateDate = DateTime.Now; pj.CreateMan = MainHelper.User.UserName; gzr.gzrjID = pj.gzrjID; pj.rq = DateTime.Now.Date; pj.xq = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(DateTime.Now.DayOfWeek); pj.rsaqts = (DateTime.Today - MainHelper.UserOrg.PSafeTime.Date).Days; pj.sbaqts = (DateTime.Today - MainHelper.UserOrg.DSafeTime.Date).Days; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 MainHelper.PlatformSqlMap.Create<PJ_01gzrj>(pj); } IList<PJ_gzrjnr> gzrlist = MainHelper.PlatformSqlMap.GetList<PJ_gzrjnr>("SelectPJ_gzrjnrList", "where ParentID = '" + gzr.ParentID + "' order by seq "); if (gzrlist.Count > 0) { gzr.seq = gzrlist[gzrlist.Count - 1].seq + 1; } else gzr.seq = 1; gzr.gznr = yxfx.hydd + "运行分析-" + yxfx.type; gzr.fzr = yxfx.zcr; gzr.fssj = yxfx.rq; string[] ss = yxfx.cjry.Split(';'); if (ss.Length >= 1) { gzr.cjry = ss[0] + "、" + ss[1]; if (ss.Length > 2) gzr.cjry = gzr.cjry + "等"; gzr.cjry = gzr.cjry + ss.Length + "人"; } else { gzr.cjry = gzr.fzr; } MainHelper.PlatformSqlMap.Create<PJ_gzrjnr>(gzr); } else { MainHelper.PlatformSqlMap.Update<PJ_03yxfx>(RowData); } //currRecord.ImageAttachment = bt; //currRecord.SignImg = bt; currRecord.LastChangeTime = DateTime.Now.ToString(); if (RecordWorkTask.CheckOnRiZhi(WorkFlowData)) { RecordWorkTask.CreatRiZhi(WorkFlowData, null, currRecord.ID, new object[] { yxfx, 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]; } Export03.ExportExcelWorkFlow(ref currRecord, (PJ_03yxfx)RowData); if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0]; if (currRecord.SignImg == null) currRecord.SignImg = new byte[0]; currRecord.LastChangeTime = DateTime.Now.ToString(); MainHelper.PlatformSqlMap.Update("UpdateLP_Record", currRecord); //this.Close(); }