/// <summary>
/// 文档格式预定义好的，只填写内容
/// </summary>
/// <param name="obj"></param>
public static void ExportExcel(PJ_25 obj) {
ExcelAccess ex = new ExcelAccess();
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname = Application.StartupPath + "\\00记录模板\\25双自备电源协议书.xls";
ex.Open(fname);
//此处写填充内容代码
ex.ShowExcel();
}
/// <summary>
/// 文档格式预定义好的，只填写内容
/// </summary>
/// <param name="obj"></param>
public static void ExportExcel(PJ_25 obj) {
ExcelAccess ex = new ExcelAccess();
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname = Application.StartupPath + "\\00记录模板\\25双自备电源协议书.xls";
ex.Open(fname);
//此处写填充内容代码
IList<PJ_25zbdymx> list = Client.ClientHelper.PlatformSqlMap.GetList<PJ_25zbdymx>("where ParentID='" + obj.ID + "'and Type='发电机'");
IList<PJ_25zbdymx> list1 = Client.ClientHelper.PlatformSqlMap.GetList<PJ_25zbdymx>("where ParentID='" + obj.ID + "'and Type='原动机'");
ex.SetCellValue("甲 方："+obj.jf, 4, 1);
ex.SetCellValue("乙 方：" + obj.cqdw, 5, 1);
ex.SetCellValue(obj.qdrq.Year.ToString(), 42, 6);
ex.SetCellValue(obj.qdrq.Month.ToString(), 42, 8);
ex.SetCellValue(obj.qdrq.Day.ToString(), 42, 10);
for (int i = 0; i < list.Count; i++)
{
ex.SetCellValue(list[i].xh, 26 + i, 1);
ex.SetCellValue(list[i].gl.ToString() + "/" + list[i].ts.ToString(), 26 + i, 2);
ex.SetCellValue(list[i].dy.ToString(), 26 + i, 3);
ex.SetCellValue(list[i].azrq.ToString("yyyy-MM-dd"), 26 + i, 4);
ex.SetCellValue(list[i].sccj, 26 + i, 5);
}
for (int i = 0; i < list1.Count; i++)
{
ex.SetCellValue(list1[i].xh, 26 + i, 8);
ex.SetCellValue(list1[i].gl.ToString() + "/" + list[i].ts.ToString(), 26 + i, 11);
ex.SetCellValue(list1[i].dy.ToString(), 26 + i, 12);
ex.SetCellValue(list1[i].azrq.ToString("yyyy-MM-dd"), 26 + i, 13);
ex.SetCellValue(list1[i].sccj, 26 + i, 14);
}
ex.SetCellValue(obj.bszz, 30, 2);
ex.SetCellValue(obj.fzcs, 31, 2);
ex.ShowExcel();
}
/// <summary>
/// 新建对象设置Key值
/// </summary>
/// <param name="newobj"></param>
void gridViewOperation_CreatingObjectEvent(PJ_25 newobj)
{
if (parentID == null) return;
newobj.ParentID = parentID;
//newobj.OrgName = parentObj.OrgName;
newobj.CreateDate = DateTime.Now;
Ebada.Core.UserBase m_UserBase = MainHelper.ValidateLogin();
newobj.CreateMan = m_UserBase.RealName;
}
void gridViewOperation_AfterAdd(PJ_25 newobj)
{
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);
currRecord.DocContent = newobj.BigData;
MainHelper.PlatformSqlMap.Update<LP_Record>(currRecord);
}
}
void ucTop_FocusedRowChanged(object sender, PJ_25 obj)
{
ucBottom.ParentObj = obj;
//splitCC1.Panel2.Text = "测量记录：" + (obj != null ? obj.kymc : "");
}