void ucTop_FocusedRowChanged(object sender, PJ_07jdzz obj)
{
ucBottom.ParentObj = obj;
splitCC1.Panel2.Text = " " + (obj != null ? obj.OrgName : "");
}
/// <summary>
/// 新建对象设置Key值
/// </summary>
/// <param name="newobj"></param>
void gridViewOperation_CreatingObjectEvent(PJ_07jdzz newobj) {
if (parentID == null) return;
newobj.OrgCode = parentID;
newobj.OrgName = parentObj.OrgName;
newobj.CreateDate = DateTime.Now;
Ebada.Core.UserBase m_UserBase = MainHelper.ValidateLogin();
newobj.CreateMan = m_UserBase.RealName;
try { frmLP.ReadTaskData(newobj, RecordWorkFlowData, ParentTemple, CurrRecord); } catch { }
}
public static void ExportExcel(PJ_07jdzz jl,string ysl)
{
ExcelAccess ex = new ExcelAccess();
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname = Application.StartupPath + "\\00记录模板\\07接地装置检测记录.xls";
ex.Open(fname);
int row = 1;
int col = 1;
//测量记录
IList<PJ_07jdzzjl> list = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_07jdzzjl>(" where jdzzID='" + jl.jdzzID + "'and year(clrq) in"+ysl+" order by clrq");
int p = Ecommon.GetPagecount(list.Count, 16);
for (int i = 0; i < p - 1; i++)
{
ex.CopySheet(1, 1 + i);
}
ex.ActiveSheet(1);
//线路名称行
ex.SetCellValue(jl.LineName, row + 4, col + 2);
string fzxl = "";
if (jl.fzxl.Contains("支"))
{
fzxl = jl.fzxl.Substring(0, jl.fzxl.LastIndexOf("支"));
}
else
fzxl = jl.fzxl;
ex.SetCellValue(fzxl, row + 4, col + 6);
string gzwz = "";
if (jl.gzwz.Contains("分"))
{
gzwz = jl.gzwz.Substring(0, jl.gzwz.LastIndexOf("分"));
}
else
gzwz = jl.gzwz;
ex.SetCellValue(gzwz, row + 4, col + 11);
ex.SetCellValue("'" + jl.gth, row + 4, col + 15);
//设备名称行
ex.SetCellValue(jl.sbmc, row + 7, col);
//ex.SetCellValue(jl.xhgg, row + 7, col + 3);
string[] str = jl.xhgg.Split('|');
if (str.Length >= 1)
{
ex.SetCellValue(str[0], row + 7, col + 3);
}
if (str.Length >= 2)
{
ex.SetCellValue(str[1], row + 7, col + 4);
}
ex.SetCellValue(jl.jddz.ToString(), row + 7, col + 5);
ex.SetCellValue(jl.tz, row + 7, col + 9);
ex.SetCellValue(jl.trdzr.ToString(), row + 7, col + 11);
for (int page = 1; page <= p; page++)
{
ex.ActiveSheet(page);
if (page == 1)
{
for (int i = 0; i < 16; i++)
{
if (i + (page - 1) * 16 < list.Count)
{
PJ_07jdzzjl obj = list[i + (page - 1) * 16];
ex.SetCellValue(obj.clrq.Year.ToString(), row + 9 + i, col);
ex.SetCellValue(obj.clrq.Month.ToString(), row + 9 + i, col + 1);
ex.SetCellValue(obj.clrq.Day.ToString(), row + 9 + i, col + 2);
ex.SetCellValue(obj.tq, row + 9 + i, col + 3);
ex.SetCellValue(obj.scz.ToString(), row + 9 + i, col + 4);
ex.SetCellValue(obj.hsz.ToString(), row + 9 + i, col + 6);
ex.SetCellValue(obj.jcqk, row + 9 + i, col + 8);
ex.SetCellValue(obj.jr, row + 9 + i, col + 10);
//ex.SetCellValue(obj.jcr, row + 9 + i, col + 12);
string[] jcrstr = obj.jcr.Split(';');
if (jcrstr.Length >= 1)
{
ex.SetCellValue(jcrstr[0], row + 9 + i, col + 12);
}
if (jcrstr.Length >= 2)
{
ex.SetCellValue(jcrstr[1], row + 9 + i, col + 15);
}
}
}
}
else
{
for (int i = 0; i < 16; i++)
{
if (i + (page - 1) * 16 < list.Count)
{
PJ_07jdzzjl obj = list[i + (page - 1) * 16];
ex.SetCellValue(obj.clrq.Year.ToString(), row + 9 + i, col);
ex.SetCellValue(obj.clrq.Month.ToString(), row + 9 + i, col + 1);
ex.SetCellValue(obj.clrq.Day.ToString(), row + 9 + i, col + 2);
ex.SetCellValue(obj.tq, row + 9 + i, col + 3);
ex.SetCellValue(obj.scz.ToString(), row + 9 + i, col + 4);
ex.SetCellValue(obj.hsz.ToString(), row + 9 + i, col + 6);
ex.SetCellValue(obj.jcqk, row + 9 + i, col + 8);
ex.SetCellValue(obj.jr, row + 9 + i, col + 10);
string[] jcrstr = obj.jcr.Split(';');
if (jcrstr.Length >= 1)
{
ex.SetCellValue(jcrstr[0], row + 9 + i, col + 12);
}
if (jcrstr.Length >= 2)
{
ex.SetCellValue(jcrstr[1], row + 9 + i, col + 15);
}
//ex.SetCellValue(obj.jcr, row + 9 + i, col + 12);
}
}
}
}
ex.ActiveSheet(1);
ex.ShowExcel();
}
void gridViewOperation_AfterAdd(PJ_07jdzz obj) {
//RefreshData("where byqID='" + PSObj.byqID + "'");
if (isWorkflowCall) {
WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns();
mrwt.ModleRecordID = obj.jdzzID;
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 = obj.GetType().ToString();
mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
mrwt.CreatTime = DateTime.Now;
MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt);
MainHelper.PlatformSqlMap.Update<LP_Record>(currRecord);
}
}
/// <summary>
/// 新建对象设置Key值
/// </summary>
/// <param name="newobj"></param>
void gridViewOperation_CreatingObjectEvent(PJ_07jdzz newobj)
{
if (parentID == null) return;
newobj.OrgCode = parentID;
newobj.OrgName = parentObj.OrgName;
newobj.CreateDate = DateTime.Now;
Ebada.Core.UserBase m_UserBase = MainHelper.ValidateLogin();
newobj.CreateMan = m_UserBase.RealName;
}