void dataBind() {
PJ_18gysbpj temp = new PJ_18gysbpj();
this.dateEdit1.DataBindings.Add("EditValue", rowData, "rq");
//this.dateEdit2.DataBindings.Add("EditValue", rowData, "CreateDate");
this.comboBoxEdit1.DataBindings.Add("EditValue", rowData, "fzr");
this.comboBoxEdit3.DataBindings.Add("EditValue", rowData, "zbr");
}
/// <summary>
/// 文档格式预定义好的，只填写内容
/// </summary>
/// <param name="obj"></param>
public static void ExportExcel(PJ_18gysbpj obj)
{
//lgm
ExcelAccess ex = new ExcelAccess();
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname0 = Application.StartupPath + "\\00记录模板\\18高压设备评级表.xls";
string fname = Path.GetTempPath() + obj.OrgName + "设备评级表.xls";
try {
File.Copy(fname0, fname, true);
} catch { }
IList<PJ_18gysbpjmx> objlist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_18gysbpjmx>("SelectPJ_18gysbpjmxList", "where PJ_ID='" + obj.PJ_ID + "'");
ex.Open(fname);
//此处写填充内容代码
int pagecout = Ecommon.GetPagecount(objlist.Count, 29);
//复制空模板并重命名
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);
ex.SetCellValue(Ebada.Client.Platform.MainHelper.UserCompany+" " + obj.OrgName, 4, 1);
for (int i = 0; i < 29; i++)
{
if (p*29+i>=objlist.Count)
{
break;
}
PJ_18gysbpjmx tempobj = objlist[p * 29 + i];
//ex.SetCellValue((p * 29 + i).ToString(), 7 + i, 1);
ex.SetCellValue(tempobj.xh.ToString(), 7 + i, 1);
ex.SetCellValue(tempobj.sbdy, 7 + i, 2);
if (tempobj.one > 1) {
ex.SetCellValue(Math.Round(tempobj.one / 1000d, 2).ToString(), 7 + i, 5);
ex.SetCellValue(Math.Round(tempobj.two / 1000d, 2).ToString(), 7 + i, 6);
ex.SetCellValue(Math.Round(tempobj.three / 1000d, 2).ToString(), 7 + i, 9);
} else {
ex.SetCellValue(tempobj.one.ToString(), 7 + i, 5);
ex.SetCellValue(tempobj.two.ToString(), 7 + i, 6);
ex.SetCellValue(tempobj.three.ToString(), 7 + i, 9);
}
ex.SetCellValue(tempobj.whl*100 + "%", 7 + i, 12);
ex.SetCellValue(tempobj.qxnr==""?"无":tempobj.qxnr, 7 + i, 13);
ex.SetCellValue(tempobj.fzdw, 7 + i, 14);
}
// ex.SetCellValue(obj.fzr, 36, 2);
ex.SetCellValue(obj.zbr, 36, 4);
ex.SetCellValue(obj.rq.Year.ToString(), 36, 6);
ex.SetCellValue(obj.rq.Month.ToString(), 36, 8);
ex.SetCellValue(obj.rq.Day.ToString(), 36, 10);
}
ex.ActiveSheet(1);
ex.ShowExcel();
}
void ucpJ_18gysbpj1_FocusedRowChanged(object sender, PJ_18gysbpj obj)
{
ucpJ_18gysbpjmx1.PSObj = obj;
}
/// <summary>
/// 新建对象设置Key值
/// </summary>
/// <param name="newobj"></param>
void gridViewOperation_CreatingObjectEvent(PJ_18gysbpj 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 gridViewOperation_AfterAdd(PJ_18gysbpj obj) {
IList<PS_xl> listxl = Client.ClientHelper.PlatformSqlMap.GetList<PS_xl>("where orgcode='" + btGdsList.EditValue + "'and ParentID = ''");
int bh = 0;
string fzdw = parentObj.OrgName;
string loginname = MainHelper.User.UserName;
foreach (PS_xl pl in listxl)
{
bh++;
//线路
PJ_18gysbpjmx pjmx = new PJ_18gysbpjmx();
pjmx.PJ_ID = obj.PJ_ID;
pjmx.xh = bh;
pjmx.sbdy = pl.LineName;
pjmx.CreateDate = DateTime.Now;
pjmx.CreateMan = MainHelper.User.UserName;
pjmx.fzdw = fzdw;
int line1 = Convert.ToInt32(Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "SELECT SUM(WireLength) FROM PS_xl WHERE linevol='10' and SUBSTRING(LineCode, 1, 6) = '" + pl.LineCode + "'AND (lineKind = '一类')"));
int line2 = Convert.ToInt32(Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "SELECT SUM(WireLength) FROM PS_xl WHERE linevol='10' and SUBSTRING(LineCode, 1, 6) = '" + pl.LineCode + "'AND (lineKind = '二类')"));
int line3 = Convert.ToInt32(Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "SELECT SUM(WireLength) FROM PS_xl WHERE linevol='10' and SUBSTRING(LineCode, 1, 6) = '" + pl.LineCode + "'AND (lineKind = '三类')"));
pjmx.one = line1;
pjmx.two = line2;
pjmx.three = line3;
if ((line1 + line2 + line3) != 0) {
pjmx.whl = Convert.ToDecimal((line1 + line2) / (line1 + line2 + line3));
}
#region 生成缺陷
string xlsqlwhere=string.Format(" where xlid='{0}' and xcr='' order by qxlb",pl.LineID);
IList<PJ_qxfl> qxlist = MainHelper.PlatformSqlMap.GetList<PJ_qxfl>(xlsqlwhere);
if (qxlist.Count>0)
{
if (qxlist[0].qxlb=="一般缺陷")
{
pjmx.qxlb = qxlist[qxlist.Count - 1].qxlb;
pjmx.qxnr = qxlist[qxlist.Count - 1].qxnr;
}
else
{
pjmx.qxlb = qxlist[0].qxlb;
pjmx.qxnr = qxlist[0].qxnr;
}
}
#endregion
Client.ClientHelper.PlatformSqlMap.Create<PJ_18gysbpjmx>(pjmx);
//台区
IList<PS_tq> listtq = Client.ClientHelper.PlatformSqlMap.GetList<PS_tq>("where SUBSTRING(xlCode, 1, 6) ='" + pl.LineCode + "'");
foreach (PS_tq pq in listtq) {
bh++;
pjmx = new PJ_18gysbpjmx();
pjmx.ID += bh;
pjmx.xh = bh;
pjmx.PJ_ID = obj.PJ_ID;
pjmx.sbdy = pq.tqName + "台区";
pjmx.CreateDate = DateTime.Now;
pjmx.CreateMan = loginname;
pjmx.fzdw = fzdw;
switch (pq.btKind) {
case "一类":
pjmx.one = 1;
pjmx.whl = 1;
break;
case "二类":
pjmx.two = 1;
pjmx.whl = 1;
break;
case "三类":
pjmx.three = 1;
pjmx.whl = 0;
break;
}
#region 生成缺陷
xlsqlwhere = string.Format(" where tqid='{0}' and xcr='' order by qxlb", pq.tqID);
qxlist = MainHelper.PlatformSqlMap.GetList<PJ_qxfl>(xlsqlwhere);
if (qxlist.Count > 0) {
sbpj(qxlist,pjmx);
}
#endregion
Client.ClientHelper.PlatformSqlMap.Create<PJ_18gysbpjmx>(pjmx);
}
//开关
IList<PS_kg> listkg = Client.ClientHelper.PlatformSqlMap.GetList<PS_kg>("WHERE (gtID IN(SELECT gtID FROM PS_gt WHERE (SUBSTRING(LineCode, 1, 6) = '" + pl.LineCode + "')))");
foreach (PS_kg pq in listkg)
{
bh++;
pjmx = new PJ_18gysbpjmx();
pjmx.ID += bh;
pjmx.xh = bh;
pjmx.PJ_ID = obj.PJ_ID;
pjmx.sbdy = pq.kgName + "开关";
pjmx.CreateDate = DateTime.Now;
pjmx.CreateMan = loginname;
pjmx.fzdw = fzdw;
switch (pq.kgkind) {
case "一类":
pjmx.one = 1;
pjmx.whl = 1;
break;
case "二类":
pjmx.two = 2;
pjmx.whl = 1;
break;
case "三类":
pjmx.three = 1;
pjmx.whl = 0;
break;
}
#region 生成缺陷
xlsqlwhere = string.Format(" where kgid='{0}' and xcr='' order by qxlb", pq.kgID);
qxlist = MainHelper.PlatformSqlMap.GetList<PJ_qxfl>(xlsqlwhere);
if (qxlist.Count > 0)
{
sbpj(qxlist, pjmx);
}
#endregion
Client.ClientHelper.PlatformSqlMap.Create<PJ_18gysbpjmx>(pjmx);
}
//变压器
IList<PS_tqbyq> listbyq = Client.ClientHelper.PlatformSqlMap.GetList<PS_tqbyq>("WHERE (tqID IN(SELECT tqID FROM PS_tq WHERE (SUBSTRING(tqcode, 1, 6) = '" + pl.LineCode + "')))");
foreach (PS_tqbyq pq in listbyq)
{
bh++;
pjmx = new PJ_18gysbpjmx();
pjmx.ID += bh;
pjmx.xh = bh;
pjmx.PJ_ID = obj.PJ_ID;
pjmx.sbdy = pq.byqName + "变压器";
pjmx.CreateDate = DateTime.Now;
pjmx.CreateMan = loginname;
pjmx.fzdw = fzdw;
switch (pq.byqkind) {
case "一类":
pjmx.one = 1;
pjmx.whl = 1;
break;
case "二类":
pjmx.two = 2;
pjmx.whl = 1;
break;
case "三类":
pjmx.three = 1;
pjmx.whl = 0;
break;
}
#region 生成缺陷
xlsqlwhere = string.Format(" where byqid='{0}' and xcr='' order by qxlb", pq.byqID);
qxlist = MainHelper.PlatformSqlMap.GetList<PJ_qxfl>(xlsqlwhere);
if (qxlist.Count > 0)
{
sbpj(qxlist, pjmx);
}
#endregion
Client.ClientHelper.PlatformSqlMap.Create<PJ_18gysbpjmx>(pjmx);
}
}
//if (isWorkflowCall) {
// WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns();
// mrwt.ModleRecordID = obj.PJ_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 = 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);
//}
RefreshData(" where OrgCode='" + parentID + "'");
}
void gridViewOperation_AfterAdd(PJ_18gysbpj obj) {
Export18.BuildPj(obj,true);
RefreshData(" where OrgCode='" + parentID + "'");
}