Esempio n. 1
0
 void ucpJ_14aqgj1_FocusedRowChanged(object sender, sdjl_aqgj obj)
 {
     ucpJ_14aqgjsy1.ParentID = "";
     ucpJ_14aqgjsy1.PSObj = null;
     ucpJ_14aqgjsy1.PSObj = obj;
 }
Esempio n. 2
0
        /// <summary>
        /// 文档格式预定义好的,只填写内容
        /// </summary>
        /// <param name="obj"></param>
        public static void ExportExcel(sdjl_aqgj obj,IList<sdjl_14aqgjsy> objlist)
        {
            //lgm
            ExcelAccess ex = new ExcelAccess();
            SaveFileDialog saveFileDialog1 = new SaveFileDialog();
            string fname = Application.StartupPath + "\\00记录模板\\送电13电力安全工具试验记录.xls";

            ex.Open(fname);
            //计算页码
            int pagecout = Ecommon.GetPagecount(objlist.Count, 17);
            //复制空模板并重命名
            for (int m = 1; m < pagecout; m++)
            {
                ex.CopySheet(1, m);
                ex.ReNameWorkSheet(m + 1, "Sheet" + (m + 1));
            }
            for (int p = 0; p < pagecout; p++)
            {
                ex.ActiveSheet(p + 1);
                for (int i = 0; i < 17; i++)
                {
                    if (p * 17 + i >= objlist.Count)
                    {
                        break;
                    }
                    sdjl_14aqgjsy tempobj = objlist[p * 17 + i];
                    //时间
                    ex.SetCellValue(tempobj.rq.Year.ToString(), 8 + i, 1);
                    ex.SetCellValue(tempobj.rq.Month.ToString(), 8 + i, 2);
                    ex.SetCellValue(tempobj.rq.Day.ToString(), 8 + i, 3);
                    //
                    ex.SetCellValue(tempobj.jr, 8 + i, 4);
                    //送检人
                    //ex.SetCellValue(tempobj.sjr, 8 + i, 5);
                    //实验人
                    ex.SetCellValue(tempobj.syr, 8 + i, 5);
                    //安监签字
                    ex.SetCellValue(tempobj.ajqz, 8 + i, 6);
                     //下次实验日期
                    ex.SetCellValue(tempobj.xcsyrq.Year.ToString(), 8 + i, 7);
                    ex.SetCellValue(tempobj.xcsyrq.Month.ToString(), 8 + i, 8);
                    ex.SetCellValue(tempobj.xcsyrq.Day.ToString(), 8 + i, 9);
                }

            }

            ex.ActiveSheet(1);
           
            ex.SetCellValue(obj.sbName, 5, 1);
            if (obj.sbCode.Contains(obj.sbName))
            {
                ex.SetCellValue(obj.sbCode, 5, 4);
            }
            else
            {
                ex.SetCellValue(obj.sbCode, 5, 4);
            }
          
            ex.SetCellValue(obj.syzq.ToString()+"年", 5, 5);
            ex.SetCellValue(obj.syxm, 5, 6);


            ex.ActiveSheet(1);
           ex.ShowExcel();
        }
Esempio n. 3
0
 /// <summary>
 /// 新建对象设置Key值
 /// </summary>
 /// <param name="newobj"></param>
 void gridViewOperation_CreatingObjectEvent(sdjl_aqgj newobj)
 {
     if (parentID == null) return;
      newobj.OrgID = parentID;
     //newobj.OrgCode = parentID;
     //newobj.OrgName = parentObj.OrgName;
     //newobj.CreateDate = DateTime.Now;
     //newobj.CreateMan = MainHelper.LoginName;
 }