protected void btnAddConstant_Click(object sender, EventArgs e) { int index = KPI_ConstantDal.ConstantIDCounts(); string sID = PageControl.GetGuid(); ConstantEntity ote = new ConstantEntity(); ote.ConstantID = sID; ote.ConstantCode = "InputCode"; ote.ConstantName = "Input Name"; ote.ConstantDesc = ""; ote.ConstantValue = "Input Value"; ote.ConstantNote = ""; ote.ConstantCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.ConstantModifyTime = ote.ConstantCreateTime; if (KPI_ConstantDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); gvConstant.EditIndex = index; BindConstant(); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } }
protected void btnAddPosition_Click(object sender, EventArgs e) { int index = KPI_PositionDal.PositionIDCounts(); string sID = PageControl.GetGuid(); KPI_PositionEntity ote = new KPI_PositionEntity(); ote.PositionID = sID; ote.PositionName = "InputName"; ote.PositionDesc = ""; ote.PositionWeight = 10; ote.PositionIsHand = "1"; ote.PositionIsShift = "1"; ote.PositionIsValid = "1"; ote.PositionNote = ""; ote.PositionCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.PositionModifyTime = ote.PositionCreateTime; if (KPI_PositionDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } gvPosition.EditIndex = index; BindPosition(); }
protected void btnAddEngunit_Click(object sender, EventArgs e) { int index = EngunitDal.EngunitIDCounts(); string sID = PageControl.GetGuid(); EngunitEntity ote = new EngunitEntity(); ote.EngunitID = sID; ote.EngunitName = "Input Name"; ote.EngunitDesc = ""; ote.EngunitNote = ""; ote.EngunitCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.EngunitModifyTime = ote.EngunitCreateTime; if (EngunitDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } gvEngunit.EditIndex = index; BindGrid(); }
protected void btnAddTeam_Click(object sender, EventArgs e) { int index = KPI_TeamDal.TeamIDCounts(); string sID = PageControl.GetGuid(); KPI_TeamEntity ote = new KPI_TeamEntity(); ote.TeamID = sID; ote.ShiftID = ""; ote.PersonID = ""; ote.PositionID = ""; ote.TeamPersonID = ""; ote.TeamNote = ""; ote.TeamCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.TeamModifyTime = ote.TeamCreateTime; if (KPI_TeamDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); gvTeam.EditIndex = index; BindTeamByTime(); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } }
/// <summary> /// 插入数据 /// </summary> /// <returns></returns> bool Insert() { string unitid = PageControl.GetGuid(); KPI_UnitEntity mEntity = new KPI_UnitEntity(); mEntity.UnitID = unitid; mEntity.PlantID = ddl_PlantID.Value; mEntity.UnitCode = txt_UnitCode.Value.Trim(); mEntity.UnitName = txt_UnitName.Value.Trim(); mEntity.UnitDesc = txt_UnitDesc.Value.Trim(); mEntity.UnitIndex = int.Parse(txt_UnitIndex.Value.Trim()); mEntity.UnitIsValid = int.Parse(ddl_UnitIsValid.Value); mEntity.UnitPrefix = txt_UnitPrefix.Value; mEntity.UnitMW = decimal.Parse(txt_UnitMW.Value); mEntity.UnitMWTag = txt_UnitMWTag.Value; mEntity.UnitCondition = txt_UnitCondition.Value.Replace("'", "''"); mEntity.UnitIsKPI = int.Parse(ddl_UnitIsKPI.Value); mEntity.UnitIsSnapshot = int.Parse(ddl_UnitIsSnapshot.Value); mEntity.UnitIsSort = int.Parse(ddl_UnitIsSort.Value); mEntity.UnitIsSecurity = int.Parse(ddl_UnitIsSecurity.Value); mEntity.UnitIsPower = int.Parse(ddl_UnitIsPower.Value); mEntity.WorkID = ddl_UnitWorkID.Value; mEntity.UnitNote = txt_UnitNote.Value.Trim(); mEntity.UnitCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); mEntity.UnitModifyTime = mEntity.UnitCreateTime; return(KPI_UnitDal.Insert(mEntity)); }
protected void btnAddWeb_Click(object sender, EventArgs e) { int index = KPI_WebDal.WebIDCounts(); KPI_WebEntity gwe = new KPI_WebEntity(); gwe.WebID = PageControl.GetGuid(); gwe.WebCode = "InputCode"; gwe.WebDesc = "Input Description"; gwe.WebType = 0; gwe.WebNote = ""; gwe.WebCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); gwe.WebModifyTime = gwe.WebCreateTime; if (KPI_WebDal.Insert(gwe)) { gvWeb.EditIndex = index; BindWebs(); //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); } else { MessageBox.popupClientMessage(this.Page, "添加失败!", "call();"); } return; }
protected void btnAddCycle_Click(object sender, EventArgs e) { int index = CycleDal.CycleIDCounts(); string sID = PageControl.GetGuid(); CycleEntity ote = new CycleEntity(); ote.CycleID = sID; ote.CycleName = "TX"; ote.CycleDesc = "10分钟"; ote.CycleValue = 10; ote.CycleNote = "分钟计算周期"; ote.CycleCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.CycleModifyTime = ote.CycleCreateTime; if (CycleDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } gvCycle.EditIndex = index; BindGrid(); }
protected void btnAddLinq_Click(object sender, EventArgs e) { int index = KPI_LinqDal.LinqIDCounts(); string sID = PageControl.GetGuid(); LinqEntity ote = new LinqEntity(); ote.LinqID = sID; ote.LinqName = "InputName"; ote.LinqDesc = ""; ote.LinqEngunit = ""; ote.LinqIndex = index + 1; ote.LinqIsValid = 1; ote.LinqNote = ""; ote.LinqCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.LinqModifyTime = ote.LinqCreateTime; if (KPI_LinqDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); gvLinq.EditIndex = index; BindGrid(); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } }
protected void btnAddKpi_Click(object sender, EventArgs e) { int index = KpiDal.KpiIDCounts(); string sID = PageControl.GetGuid(); KpiEntity ote = new KpiEntity(); ote.KpiID = sID; ote.KpiCode = "InputCode"; ote.KpiName = "Input Name"; ote.KpiDesc = ""; ote.KpiIsValid = 1; ote.KpiNote = ""; ote.KpiCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.KpiModifyTime = ote.KpiCreateTime; if (KpiDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } gvKpi.EditIndex = index; BindKpi(); }
protected bool ImportFromExcelToCreate(DataSet ds) { try { System.Data.DataTable dt = ds.Tables[0]; int nAll = dt.Rows.Count; int nCreate = 0; int nExist = 0; foreach (System.Data.DataRow dr in dt.Rows) { if (dr["SelectX"].ToString().ToLower() == "x") { //string PersonCode = dr["PersonCode"].ToString().Trim(); ////判断是否存在 //if (KPI_PersonDal.PersonCodeExists(PersonCode, "")) //{ // //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();"); // nExist += 1; // continue; //} //main tag string keyid = PageControl.GetGuid(); KPI_TeamEntity mEntity = new KPI_TeamEntity(); mEntity.TeamID = keyid; mEntity.PlantID = KPI_PlantDal.GetPlantID(dr["PlantName"].ToString().Trim()); mEntity.ShiftID = KPI_ShiftDal.GetShiftID(dr["ShiftName"].ToString().Trim()); mEntity.PersonID = KPI_PersonDal.GetPersonID(dr["PersonCode"].ToString().Trim()); mEntity.PositionID = KPI_PersonDal.GetPositionID(mEntity.PersonID); //PersonName,无多大意义 mEntity.PositionID = KPI_PositionDal.GetPositionID(dr["PositionName"].ToString().Trim()); mEntity.TeamNote = dr["TeamNote"].ToString().Trim(); KPI_TeamDal.Insert(mEntity); nCreate += 1; } } string strInfor = "标签点总数为:{0}个, 创建成功:{1}个,已存在标签点: {2}个。"; strInfor = string.Format(strInfor, nAll, nCreate, nExist); MessageBox.popupClientMessage(this.Page, strInfor, "call();"); return(true); } catch (Exception ee) { // MessageBox.popupClientMessage(this.Page, ee.Message, "call();"); return(false); } }
/// <summary> /// 插入数据 /// </summary> /// <returns></returns> bool Insert() { string LinqID = ViewState["linqid"].ToString(); string keyid = PageControl.GetGuid(); LinqTagEntity mEntity = new LinqTagEntity(); mEntity.TagID = keyid; mEntity.LinqID = LinqID; mEntity.UnitID = ddl_UnitID.SelectedValue; mEntity.UnitName = ddl_UnitID.SelectedItem.Text; mEntity.ECID = ddl_ECID.SelectedValue; mEntity.ECName = ddl_ECID.SelectedItem.Text; return(LinqTagDal.Insert(mEntity)); }
protected void btnAddSecurity_Click(object sender, EventArgs e) { string said = ViewState["said"].ToString(); if (said == "") { //btnAddSecurity.Enabled = false; MessageBox.popupClientMessage(this.Page, "请先点击应用按钮生成新的安全指标!", "call();"); return; } int index = KPI_SecurityDal.SecurityIDCounts(said); KPI_SecurityEntity ote = new KPI_SecurityEntity(); ote.SecurityID = PageControl.GetGuid(); ote.SAID = said; ote.SecurityCalcExp = "Input Calc Exp"; ote.SecurityGainExp = "1"; ote.SecurityOptimal = 0; ote.SecurityAlarm = 0; ote.SecurityIsValid = 1; //ote.SecurityNote = ""; //ote.SecurityCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); //ote.SecurityModifyTime = ote.SecurityCreateTime; //if (KPI_SecurityDal.Insert(ote)) //{ // //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); // gvSecurity.EditIndex = index; // BindSecurity(); //} //else //{ // MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); //} }
public void KPI_Web_Add(HttpContext context) { string sID = PageControl.GetGuid(); string sCode = context.Request["WebCode"]; string sDesc = context.Request["WebDesc"]; string sType = context.Request["WebType"]; string sNote = context.Request["WebNote"]; if (sCode == "") { context.Response.Write("{\"status\":\"代码不能为空!\"}"); return; } //名称是否重复 if (KPI_WebDal.WebCodeExists(sCode, sID)) { context.Response.Write("{\"status\":\"已存在相同的代码!\"}"); return; } //更新 KPI_WebEntity ote = new KPI_WebEntity(); ote.WebID = sID; ote.WebCode = sCode; ote.WebDesc = sDesc; ote.WebType = int.Parse(sType); ote.WebNote = sNote; ote.WebCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.WebModifyTime = ote.WebCreateTime; if (KPI_WebDal.Insert(ote)) { context.Response.Write("{\"status\":\"ok\"}"); return; } else { context.Response.Write("{\"status\":\"添加失败!\"}"); return; } }
protected void btnAddReal_Click(object sender, EventArgs e) { if (ddlUnitID.SelectedValue == "ALL") { MessageBox.popupClientMessage(this.Page, "请选择具体机组!", "call();"); return; } string UnitID = ddlUnitID.SelectedValue.Trim(); int index = KPI_RealTagDal.IDCounts(UnitID); string sID = PageControl.GetGuid(); KPI_RealTagEntity ote = new KPI_RealTagEntity(); ote.RealID = sID; ote.UnitID = UnitID; ote.RealCode = "InputCode"; ote.RealDesc = "Input DEsc"; ote.RealEngunit = "Input Engunit"; ote.RealSnapshot = "0"; ote.RealSort = "1"; ote.RealDisplay = "0"; ote.RealXYZ = "0"; ote.RealNote = ""; ote.RealCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.RealModifyTime = ote.RealCreateTime; if (KPI_RealTagDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } gvReal.EditIndex = index; BindReal(); }
/// <summary> /// 插入数据 /// </summary> /// <returns></returns> bool Insert() { string plantid = PageControl.GetGuid(); KPI_PlantEntity mEntity = new KPI_PlantEntity(); mEntity.PlantID = plantid; mEntity.PlantCode = txt_PlantCode.Value.Trim(); mEntity.PlantName = txt_PlantName.Value.Trim(); mEntity.PlantDesc = txt_PlantDesc.Value.Trim(); mEntity.PlantIndex = int.Parse(txt_PlantIndex.Value.Trim()); mEntity.PlantIsValid = int.Parse(ddl_PlantIsValid.Value); mEntity.PlantAddress = txt_PlantAddress.Value.Trim(); mEntity.PlantNote = txt_PlantNote.Value.Trim(); mEntity.PlantCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); mEntity.PlantModifyTime = mEntity.PlantCreateTime; return(KPI_PlantDal.Insert(mEntity)); }
protected void btnAddPeriod_Click(object sender, EventArgs e) { //集团信息,新增页面 //string strjs = "<script language=javascript>window.open('KPI_SubRunPeriod.aspx','newwindow','width=500,height=400')</script>"; //ClientScript.RegisterStartupScript(this.GetType(), "", strjs); int index = KPI_PeriodDal.PeriodIDCounts(); string sID = PageControl.GetGuid(); KPI_PeriodEntity ote = new KPI_PeriodEntity(); ote.PeriodID = sID; ote.PeriodCode = KPI_PeriodDal.GetNextCode(); ote.PeriodName = "InputName"; ote.PeriodDesc = ""; ote.PeriodStartHour = 8; ote.PeriodEndHour = 17; ote.PeriodHours = 9; ote.PeriodIsIDL = "0"; ote.PeriodIsValid = "1"; ote.PeriodNote = ""; ote.PeriodCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.PeriodModifyTime = ote.PeriodCreateTime; if (KPI_PeriodDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); gvPeriod.EditIndex = index; BindPeriod(); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } }
protected void btnAddCurve_Click(object sender, EventArgs e) { int index = CurveTagDal.CurveIDCounts(); string sID = PageControl.GetGuid(); CurveTagEntity ote = new CurveTagEntity(); ote.CurveID = sID; ote.CurveCode = "InputCode"; ote.CurveName = "InputName"; ote.CurveDesc = ""; ote.CurveGroup = "InputGroup"; ote.CurveMonth = "1,2,3,4,5,6,7,8,9,10,11,12,"; ote.CurveIsValid = 0; ote.CurveIndex = 100; ote.CurveType = 0; ote.CurveGetType = 0; ote.CurveXRealTag = ""; ote.CurveYRealTag = ""; ote.CurveZRealTag = ""; ote.CurveXYZ = ""; ote.CurveNote = ""; ote.CurveCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.CurveModifyTime = ote.CurveCreateTime; if (CurveTagDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); gvCurve.EditIndex = index; BindValues(); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } }
/// <summary> /// 数据提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnApply_Click(object sender, EventArgs e) { string msg = ""; if (CheckVal(out msg)) { MessageBox.popupClientMessage(this.Page, msg, "call();"); return; } if (ViewState["said"].ToString() == "") { string said = PageControl.GetGuid(); if (Insert(said)) { ViewState["said"] = said; MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); //btnAddSecurity.Enabled = true; } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } } else { if (Update()) { MessageBox.popupClientMessage(this.Page, "编辑成功!", "call();"); //btnAddSecurity.Enabled = true; } else { MessageBox.popupClientMessage(this.Page, "编辑错误!", "call();"); } } }
protected void btnAddShift_Click(object sender, EventArgs e) { ////添加新电厂信息 //string strjs = "<script language=javascript>window.open('KPI_SubRunShift.aspx','newwindow','width=500,height=400')</script>"; //ClientScript.RegisterStartupScript(this.GetType(), "", strjs); int index = KPI_ShiftDal.ShiftIDCounts(); string sID = PageControl.GetGuid(); KPI_ShiftEntity ote = new KPI_ShiftEntity(); ote.ShiftID = sID; ote.ShiftCode = KPI_ShiftDal.GetNextCode(); ote.ShiftName = "InputName"; ote.ShiftDesc = ""; ote.ShiftIsValid = "1"; ote.ShiftNote = ""; ote.ShiftCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.ShiftModifyTime = ote.ShiftCreateTime; if (KPI_ShiftDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); gvShift.EditIndex = index; BindShift(); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } }
protected void btnAddWork_Click(object sender, EventArgs e) { //检查名称是否重复 string sName = txt_WorkName.Value.Trim(); if (KPI_WorkDal.WorkNameExists(sName, "")) { MessageBox.popupClientMessage(this.Page, "名称已存在,请修改倒班名称!", "call();"); return; } int nShifts = int.Parse(ddl_BaseShifts.SelectedValue); int nDays = int.Parse(ddl_BaseDays.SelectedValue); string sWorkSequence = ""; //WorkSequence for (int j = 0; j < nDays; j++) { for (int i = 0; i < nShifts; i++) { string id = string.Format("ddl_period{0}{1}", i, j); DropDownList ddl = (DropDownList)this.FindControl(id); sWorkSequence += ddl.SelectedValue + "-"; } } string sWorkShift = ""; //WorkShift for (int i = 0; i < nShifts; i++) { string id = string.Format("ddl_shift0{0}", i); DropDownList ddl = (DropDownList)this.FindControl(id); sWorkShift += ddl.SelectedValue + "-"; } string keyid = PageControl.GetGuid(); ////////////////////////////////////////////////////////////////////////////// KPI_WorkEntity kwe = new KPI_WorkEntity(); kwe.WorkID = keyid; kwe.WorkName = txt_WorkName.Value; kwe.WorkDesc = txt_WorkDesc.Value; kwe.WorkStartTime = txt_date.Value; kwe.WorkEndTime = DateTime.Now.AddYears(10).ToLocalTime().ToString("yyyy-MM-dd"); kwe.WorkBaseShifts = nShifts; kwe.WorkBaseDays = nDays; kwe.WorkSequence = sWorkSequence; kwe.WorkShift = sWorkShift; kwe.WorkIsValid = int.Parse(ddl_WorkIsValid.SelectedValue); kwe.WorkNote = txt_WorkNote.Value; kwe.WorkCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); kwe.WorkModifyTime = kwe.WorkCreateTime; /////////////////////////////////////////////////////////////////////////////// if (KPI_WorkDal.Insert(kwe)) { MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); BindWork(); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } if (KPI_WorkDal.Update(kwe)) { MessageBox.popupClientMessage(this.Page, "修改成功!", "call();"); BindWork(); } else { MessageBox.popupClientMessage(this.Page, "修改错误!", "call();"); } }
protected bool ImportFromExcelToCreateAndModify(DataSet ds) { try { System.Data.DataTable dt = ds.Tables[0]; int nAll = dt.Rows.Count; int nCreate = 0; int nModify = 0; bool bExist = false; foreach (System.Data.DataRow dr in dt.Rows) { if (dr["SelectX"].ToString().ToLower() == "x") { string PersonCode = dr["PersonCode"].ToString().Trim(); //判断是否存在 bExist = KPI_PersonDal.PersonCodeExists(PersonCode, ""); string keyid = PageControl.GetGuid(); if (bExist) { keyid = KPI_PersonDal.GetPersonID(PersonCode); //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();"); //nExist += 1; //continue; } //main tag KPI_PersonEntity mEntity = new KPI_PersonEntity(); mEntity.PersonID = keyid; mEntity.PositionID = KPI_PositionDal.GetPositionID(dr["PositionName"].ToString().Trim()); mEntity.PersonCode = PersonCode; mEntity.PersonName = dr["PersonName"].ToString().Trim(); mEntity.PersonDesc = dr["PersonDesc"].ToString().Trim(); mEntity.PersonIsValid = dr["PersonIsValid"].ToString().Trim(); mEntity.PersonNote = dr["PersonNote"].ToString().Trim(); if (bExist) { KPI_PersonDal.Update(mEntity); nModify += 1; } else { KPI_PersonDal.Insert(mEntity); nCreate += 1; } } } string strInfor = "标签点总数为:{0}个, 创建成功:{1}个, 修改成功: {2}个。"; strInfor = string.Format(strInfor, nAll, nCreate, nModify); MessageBox.popupClientMessage(this.Page, strInfor, "call();"); return(true); } catch (Exception ee) { // MessageBox.popupClientMessage(this.Page, ee.Message, "call();"); return(false); } }
protected bool ImportFromExcelToCreateAndModify(DataSet ds) { string strKPIError = ""; try { System.Data.DataTable dt = ds.Tables[0]; int nAll = dt.Rows.Count; int nCreate = 0; int nModify = 0; int nNotValid = 0; bool bExist = false; foreach (System.Data.DataRow dr in dt.Rows) { if (dr["SelectX"].ToString().ToLower() == "x") { string ECCode = dr["ECCode"].ToString().Trim(); strKPIError = ECCode; //判断是否存在 bExist = ECTagDal.CodeExist(ECCode, ""); string keyid = PageControl.GetGuid(); if (bExist) { keyid = ECTagDal.GetECIDByCode(ECCode); //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();"); //nExist += 1; //continue; } else { //其他表存在也不能创建 if (ALLDal.CodeExist(ECCode, "")) { nNotValid += 1; continue; } } ECTagEntity mEntity = new ECTagEntity(); mEntity.ECID = keyid; string UnitName = dr["UnitName"].ToString().Trim(); mEntity.UnitID = KPI_UnitDal.GetUnitID(UnitName); string SeqName = dr["SeqName"].ToString().Trim(); mEntity.SeqID = KPI_SeqDal.GetSeqID(SeqName); string KpiName = dr["KpiName"].ToString().Trim(); mEntity.KpiID = KpiDal.GetKpiID(KpiName); string EngunitName = dr["EngunitName"].ToString().Trim(); mEntity.EngunitID = EngunitDal.GetEngunitID(EngunitName); string CycleName = dr["CycleName"].ToString().Trim(); mEntity.CycleID = CycleDal.GetCycleID(CycleName); mEntity.ECCode = dr["ECCode"].ToString().Trim(); mEntity.ECName = dr["ECName"].ToString().Trim(); mEntity.ECDesc = dr["ECDesc"].ToString().Trim(); mEntity.ECIndex = int.Parse(dr["ECIndex"].ToString().Trim()); mEntity.ECWeb = dr["ECWeb"].ToString().Trim(); mEntity.ECIsValid = int.Parse(dr["ECIsValid"].ToString().Trim()); mEntity.ECIsCalc = int.Parse(dr["ECIsCalc"].ToString().Trim()); mEntity.ECIsAsses = int.Parse(dr["ECIsAsses"].ToString().Trim()); mEntity.ECIsZero = int.Parse(dr["ECIsZero"].ToString().Trim()); mEntity.ECIsDisplay = int.Parse(dr["ECIsDisplay"].ToString().Trim()); mEntity.ECIsTotal = int.Parse(dr["ECIsTotal"].ToString().Trim()); mEntity.ECDesign = dr["ECDesign"].ToString().Trim(); mEntity.ECOptimal = dr["ECOptimal"].ToString().Trim(); if (dr["ECMaxValue"].ToString().Trim() != "") { mEntity.ECMaxValue = decimal.Parse(dr["ECMaxValue"].ToString().Trim()); } if (dr["ECMinValue"].ToString().Trim() != "") { mEntity.ECMinValue = decimal.Parse(dr["ECMinValue"].ToString().Trim()); } mEntity.ECWeight = decimal.Parse(dr["ECWeight"].ToString().Trim()); mEntity.ECCalcClass = int.Parse(dr["ECCalcClass"].ToString().Trim()); mEntity.ECFilterExp = dr["ECFilterExp"].ToString().Trim(); mEntity.ECCalcExp = dr["ECCalcExp"].ToString().Trim(); mEntity.ECCalcDesc = dr["ECCalcDesc"].ToString().Trim(); mEntity.ECIsSnapshot = int.Parse(dr["ECIsSnapshot"].ToString().Trim()); mEntity.ECXLineType = int.Parse(dr["ECXLineType"].ToString().Trim()); mEntity.ECXLineGetType = int.Parse(dr["ECXLineGetType"].ToString().Trim()); mEntity.ECXLineXRealTag = dr["ECXLineXRealTag"].ToString().Trim(); mEntity.ECXLineYRealTag = dr["ECXLineYRealTag"].ToString().Trim(); mEntity.ECXLineZRealTag = dr["ECXLineZRealTag"].ToString().Trim(); mEntity.ECXLineXYZ = dr["ECXLineXYZ"].ToString().Trim(); mEntity.ECScoreExp = dr["ECScoreExp"].ToString().Trim(); mEntity.ECCurveGroup = dr["ECCurveGroup"].ToString().Trim(); mEntity.ECIsSort = int.Parse(dr["ECIsSort"].ToString().Trim()); mEntity.ECType = int.Parse(dr["ECType"].ToString().Trim()); mEntity.ECSort = int.Parse(dr["ECSort"].ToString().Trim()); mEntity.ECScore = dr["ECScore"].ToString().Trim(); mEntity.ECExExp = dr["ECExExp"].ToString().Trim(); mEntity.ECExScore = dr["ECExScore"].ToString().Trim(); mEntity.ECNote = dr["ECNote"].ToString().Trim(); mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); mEntity.ECModifyTime = mEntity.ECCreateTime; if (bExist) { ECTagDal.Update(mEntity); nModify += 1; } else { ECTagDal.Insert(mEntity); nCreate += 1; } } } string strInfor = "标签点总数为:{0}个, 创建成功:{1}个, 修改成功: {2}个,其他表存在Code: {3}个。"; strInfor = string.Format(strInfor, nAll, nCreate, nModify, nNotValid); MessageBox.popupClientMessage(this.Page, strInfor, "call();"); return(true); } catch (Exception ee) { // MessageBox.popupClientMessage(this.Page, strKPIError + ": " + ee.Message, "call();"); return(false); } }
protected bool ImportFromExcelToCreateAndModify(DataSet ds) { try { System.Data.DataTable dt = ds.Tables[0]; int nAll = dt.Rows.Count; int nCreate = 0; int nModify = 0; int nNotValid = 0; bool bExist = false; foreach (System.Data.DataRow dr in dt.Rows) { if (dr["SelectX"].ToString().ToLower() == "x") { string RealCode = dr["RealCode"].ToString().Trim(); //判断是否存在 bExist = KPI_RealTagDal.CodeExist(RealCode, ""); string keyid = PageControl.GetGuid(); if (bExist) { keyid = KPI_RealTagDal.GetID(RealCode); //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();"); //nExist += 1; //continue; } else { //其他表存在也不能创建 if (ALLDal.CodeExist(RealCode, "")) { nNotValid += 1; continue; } } //main tag KPI_RealTagEntity mEntity = new KPI_RealTagEntity(); mEntity.RealID = keyid; mEntity.UnitID = KPI_UnitDal.GetUnitID(dr["UnitName"].ToString().Trim()); mEntity.RealCode = RealCode; mEntity.RealDesc = dr["RealDesc"].ToString().Trim(); mEntity.RealEngunit = dr["RealEngunit"].ToString().Trim(); string sv = dr["RealMaxValue"].ToString().Trim(); if (sv != "") { mEntity.RealMaxValue = decimal.Parse(sv); } sv = dr["RealMinValue"].ToString().Trim(); if (sv != "") { mEntity.RealMinValue = decimal.Parse(sv); } mEntity.RealSnapshot = dr["RealSnapshot"].ToString().Trim(); mEntity.RealSort = dr["RealSort"].ToString().Trim(); mEntity.RealDisplay = dr["RealDisplay"].ToString().Trim(); mEntity.RealXYZ = dr["RealXYZ"].ToString().Trim(); mEntity.RealNote = dr["RealNote"].ToString().Trim(); if (bExist) { KPI_RealTagDal.Update(mEntity); nModify += 1; } else { KPI_RealTagDal.Insert(mEntity); nCreate += 1; } } } string strInfor = "标签点总数为:{0}个, 创建成功:{1}个, 修改成功: {2}个,其他表存在Code: {3}个。"; strInfor = string.Format(strInfor, nAll, nCreate, nModify, nNotValid); MessageBox.popupClientMessage(this.Page, strInfor, "call();"); return(true); } catch (Exception ee) { // MessageBox.popupClientMessage(this.Page, ee.Message, "call();"); return(false); } }