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