public static void CreatRiZhi(sdjl_09pxjl obj) { sdjl_gzrjnr gzr = new sdjl_gzrjnr(); gzr.gzrjID = gzr.CreateID(); gzr.ParentID = obj.ID; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 IList<sdjl_01gzrj> gzrj01 = MainHelper.PlatformSqlMap.GetList<sdjl_01gzrj>("Selectsdjl_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 { sdjl_01gzrj pj = new sdjl_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<sdjl_01gzrj>(pj); } IList<sdjl_gzrjnr> gzrlist = MainHelper.PlatformSqlMap.GetList<sdjl_gzrjnr>("Selectsdjl_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<sdjl_gzrjnr>(gzr); }
void gridViewOperation_AfterAdd(sdjl_09pxjl obj) { CreatRiZhi(obj); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(sdjl_09pxjl obj) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\送电18培训记录.xls"; ex.Open(fname); //每行显示文字长度 int zc = 60; //与会人员之间的间隔符号 char[] jksign = new char[1] { ';' }; int row = 1; int col = 1; //计算页码 int pagecount = 1; //题目 string timustr = Ecommon.Comparestring(obj.tm, "题目") ? "" : "题目:"; List<string> timulist = Ecommon.ResultStrListByPage(timustr,obj.tm, zc,4); if (Ecommon.GetPagecount(timulist.Count,4)>pagecount) { pagecount=Ecommon.GetPagecount(timulist.Count,4); } //活动内容 string hdstr = Ecommon.Comparestring(obj.nr, "内容") ? "" : "内容:"; List<string> hdlist = Ecommon.ResultStrListByPage(hdstr, obj.nr,zc,10); if (Ecommon.GetPagecount(hdlist.Count,10)>pagecount) { pagecount=Ecommon.GetPagecount(hdlist.Count,10); } //领导评语 string ldpystr = Ecommon.Comparestring(obj.py, "领导检查评语") ? "" : "领导检查评语:"; List<string> ldpylist = Ecommon.ResultStrListByPage(ldpystr,obj.py, zc,3); if (Ecommon.GetPagecount(ldpylist.Count,3)>pagecount) { pagecount=Ecommon.GetPagecount(ldpylist.Count,3); } //复制空模板 for (int m = 1; m < pagecount; m++) { ex.CopySheet(1,m); ex.ReNameWorkSheet(m + 1, "Sheet" + (m + 1)); } for (int p = 0; p < pagecount; p++) { ex.ActiveSheet(p + 1); //题目 for (int i = 0; i < 4; i++) { if (p*4+i>=timulist.Count) { break; } string tempstr = timulist[p * 4 + i]; ex.SetCellValue(tempstr, 7 + i, 1); } //活动内容 for (int r = 0; r < 10; r++) { if (p*10+r>=hdlist.Count) { break; } string tempstr = hdlist[p * 10 + r]; ex.SetCellValue(tempstr, 11 + r, 1); } //领导评语 for (int t = 0; t < 3; t++) { if (p * 3 + t >= ldpylist.Count) { break; } string tempstr = ldpylist[p * 3 + t]; ex.SetCellValue(tempstr, 21 + t, 1); } } ex.ActiveSheet(1); //培训时间 row = 2; ex.SetCellValue(obj.rq.Year.ToString(), 4, 2); ex.SetCellValue(obj.rq.Month.ToString(), 4, 4); ex.SetCellValue(obj.rq.Day.ToString(), 4, 6); //学习时数 string[] ary = obj.xxss.Split(jksign); if (ary.Length>=1) { ex.SetCellValue(ary[0], 4, 9); } else { ex.SetCellValue("", 4, 9); } if (ary.Length >= 2) { ex.SetCellValue(ary[1], 4, 11); } else { ex.SetCellValue("", 4, 11); } //参加人数 ex.SetCellValue(obj.cjrs, 4, 14); //主持人 ex.SetCellValue(obj.zcr, 6, 3); ex.SetCellValue(obj.zjr, 6, 9); //会议地点 //ex.SetCellValue(obj.hydd, 6, 14); //签字 // ex.SetCellValue(obj.qz, 24, 3); // if (ComboBoxHelper.CompreDate(obj.qzrq)) // { // ex.SetCellValue(obj.qzrq.Year.ToString(), 24, 8); // ex.SetCellValue(obj.qzrq.Month.ToString(), 24, 10); // ex.SetCellValue(obj.qzrq.Day.ToString(), 24, 12); // } ex.ActiveSheet(1); ex.ShowExcel(); }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(sdjl_09pxjl newobj) { if (parentID == null) return; newobj.OrgCode = parentID; newobj.OrgName = parentObj.OrgName; newobj.CreateDate = DateTime.Now; newobj.qzrq = DateTime.Now; Ebada.Core.UserBase m_UserBase = MainHelper.ValidateLogin(); newobj.CreateMan = m_UserBase.RealName; newobj.rq = DateTime.Now; }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel1(sdjl_09pxjl obj) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\送电18培训记录.xls"; ex.Open(fname); //每行显示文字长度 int zc = 58; //与会人员之间的间隔符号 char[] jksign = new char[1] { ';' }; int row = 1; int col = 1; //计算页码 int pagecount = 1; //题目 string tmstr = Ecommon.Comparestring(obj.tm, "题目") ? "" : "题目:"; List<string> tmlist = Ecommon.ResultStrListByPage(tmstr, obj.tm, zc, 4); //内容 string nrstr = Ecommon.Comparestring(obj.nr, "内容") ? "" : "内容:"; List<string> nrlist = Ecommon.ResultStrListByPage(nrstr, obj.nr, zc, 10); //领导评语 string ldpystr = Ecommon.Comparestring(obj.py, "领导检查评语") ? "" : "领导检查评语:"; List<string> ldpylist = Ecommon.ResultStrListByPage(ldpystr, obj.py, zc, 3); //页数 if (Ecommon.GetPagecount(tmlist.Count + nrlist.Count + ldpylist.Count, 15) > pagecount) { pagecount = Ecommon.GetPagecount(ldpylist.Count + tmlist.Count + nrlist.Count, 15); } //复制空模版 if (pagecount > 1) { for (int i = 1; i < pagecount; i++) { ex.CopySheet(1, i); ex.ReNameWorkSheet(i + 1, "Sheet" + (i + 1)); } } for (int p = 0; p < pagecount; p++) { ex.ActiveSheet(p + 1); //改造后的 for (int i = 0; i < 17; i++) { if (p * 17 + i < tmlist.Count) { string tempstr = tmlist[p * 17 + i]; ex.SetCellValue(tempstr, 7 + i, 1); if (p == 0 && i == 0) { //设定活动内容为粗体 ex.SetFontBold(7 + i, 1, 7 + i, 1, true, 0, 3); } } if (p * 17 + i >= tmlist.Count && p * 17 + i < tmlist.Count + nrlist.Count) { string tempstr = nrlist[p * 17 + i - tmlist.Count]; ex.SetCellValue(tempstr, 7 + i, 1); if (p * 17 + i == tmlist.Count) { ex.SetFontBold(7 + i, 1, 7 + i, 1, true, 0, 3); } //break; } if (p * 17 + i >= tmlist.Count + nrlist.Count && p * 17 + i < tmlist.Count + nrlist.Count + ldpylist.Count) { string tempstr = ldpylist[p * 17 + i - tmlist.Count - nrlist.Count]; ex.SetCellValue(tempstr, 7 + i, 1); if (p * 17 + i == tmlist.Count + nrlist.Count) ex.SetFontBold(7 + i, 1, 7 + i, 1, true, 0, 7); //break; } if (p * 17 + i >= tmlist.Count + nrlist.Count + ldpylist.Count) { break; } } } ex.ActiveSheet(1); //培训时间 ex.SetCellValue(obj.rq.Year.ToString(), 4, 2); ex.SetCellValue(obj.rq.Month.ToString(), 4, 4); ex.SetCellValue(obj.rq.Day.ToString(), 4, 6); //学习时数 string[] ary = obj.xxss.Split(jksign); if (ary.Length >= 1) { ex.SetCellValue(ary[0], 4, 9); } else { ex.SetCellValue("", 4, 9); } if (ary.Length >= 2) { ex.SetCellValue(ary[1], 4, 11); } else { ex.SetCellValue("", 4, 11); } //参加人数 ex.SetCellValue(obj.cjrs, 4, 14); //主持人 ex.SetCellValue(obj.zcr, 6, 3); ex.SetCellValue(obj.zjr, 6, 9); //会议地点 //ex.SetCellValue(obj.hydd, 6, 14); ex.ShowExcel(); }