/// <summary>
/// 新建对象设置Key值
/// </summary>
/// <param name="newobj"></param>
void gridViewOperation_CreatingObjectEvent(sdjl_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;
}
void ucTop_FocusedRowChanged(object sender, sdjl_07jdzz obj)
{
ucBottom.ParentObj = obj;
splitCC1.Panel2.Text = " " + (obj != null ? obj.OrgName : "");
}
/// <summary>
/// 新建对象设置Key值
/// </summary>
/// <param name="newobj"></param>
void gridViewOperation_CreatingObjectEvent(sdjl_07jdzz newobj)
{
if (parentID == null) return;
if (string.IsNullOrEmpty(this.barxl.EditValue as string))
return;
newobj.OrgCode = parentID;
newobj.OrgName = parentObj.OrgName;
newobj.CreateDate = DateTime.Now;
newobj.LineID = this.barxl.EditValue as string;
sd_xl xl= Client.ClientHelper.PlatformSqlMap.GetOne<sd_xl>("where linecode='" + newobj.LineID + "'");
newobj.LineName = xl.LineName;
Ebada.Core.UserBase m_UserBase = MainHelper.ValidateLogin();
}
public static void ExportExcel(sdjl_07jdzz jl,string ysl)
{
ExcelAccess ex = new ExcelAccess();
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname = Application.StartupPath + "\\00记录模板\\送电08接地装置检测.xls";
ex.Open(fname);
int row = 1;
int col = 1;
//测量记录
IList<sdjl_07jdzzjl> list = Client.ClientHelper.PlatformSqlMap.GetListByWhere<sdjl_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.c1, 5, 11);
//设备名称行
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)
{
sdjl_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)
{
sdjl_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();
}