/// <summary> /// 插入数据 /// </summary> /// <returns></returns> bool Insert(string ecid) { ECTagEntity mEntity = new ECTagEntity(); mEntity.ECID = ecid; //mEntity.UnitID = ddl_UnitID.SelectedValue; //mEntity.SeqID = ddl_SeqID.Value.Trim(); //mEntity.KpiID = ddl_KpiID.SelectedValue; //mEntity.EngunitID = ddl_EngunitID.Value.Trim(); //mEntity.CycleID = ddl_CycleID.Value.Trim(); //mEntity.ECIsValid = int.Parse(ddl_ECIsValid.Value); //mEntity.ECIsCalc = int.Parse(ddl_ECIsCalc.Value); //mEntity.ECIsDisplay = int.Parse(ddl_ECIsDisplay.Value); //mEntity.ECIsTotal = int.Parse(ddl_ECIsTotal.Value); //mEntity.ECCode = txt_ECCode.Value.Trim(); //mEntity.ECName = txt_ECName.Value.Trim(); //mEntity.ECDesc = txt_ECDesc.Value.Trim(); //mEntity.ECIndex = int.Parse(txt_ECIndex.Value.Trim()); //mEntity.ECWeb = ddl_ECWeb.Value; //// //mEntity.ECDesign = txt_ECDesign.Value; //mEntity.ECOptimal = txt_ECOptimal.Value; //mEntity.ECMaxValue = int.Parse(txt_ECMaxValue.Value.Trim()); //mEntity.ECMinValue = int.Parse(txt_ECMinValue.Value.Trim()); //mEntity.ECWeight = int.Parse(txt_ECWeight.Value.Trim()); //mEntity.ECNote = txt_ECNote.Value.Trim(); //mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); //mEntity.ECModifyTime = mEntity.ECCreateTime; return(ECTagDal.Insert(mEntity)); }
/// <summary> /// 绑定数据 /// </summary> void BindValues() { string ECID = ViewState["ecid"].ToString(); if (ECID == "") { btnAddScore.Enabled = false; return; } mEntity = ECTagDal.GetEntity(ECID); if (mEntity == null) { return; } lbl_ECCode.Text = "指标代码:" + mEntity.ECCode; lbl_ECName.Text = "指标名称:" + mEntity.ECName; cbx_ECIsSnapshot.Checked = mEntity.ECIsSnapshot == 1 ? true : false; BindScore(true); }
/// <summary> /// 绑定数据 /// </summary> void BindValues() { string ECID = ViewState["ecid"].ToString(); if (ECID == "") { return; } ECTagEntity mEntity = ECTagDal.GetEntity(ECID); ddl_UnitID.SelectedValue = mEntity.UnitID; ddl_SeqID.Value = mEntity.SeqID; ddl_KpiID.SelectedValue = mEntity.KpiID; ddl_EngunitID.Value = mEntity.EngunitID; ddl_CycleID.Value = mEntity.CycleID; ddl_ECIsValid.Value = mEntity.ECIsValid.ToString(); ddl_ECIsCalc.Value = mEntity.ECIsCalc.ToString(); ddl_ECIsAsses.Value = mEntity.ECIsAsses.ToString(); ddl_ECIsZero.Value = mEntity.ECIsZero.ToString(); ddl_ECIsDisplay.Value = mEntity.ECIsDisplay.ToString(); ddl_ECIsTotal.Value = mEntity.ECIsTotal.ToString(); ddl_ECWeb.Value = mEntity.ECWeb; txt_ECCode.Value = mEntity.ECCode; txt_ECName.Value = mEntity.ECName; txt_ECDesc.Value = mEntity.ECDesc; txt_ECIndex.Value = mEntity.ECIndex.ToString(); txt_ECDesign.Value = mEntity.ECDesign; if (mEntity.ECMaxValue == decimal.MinValue) { txt_ECMaxValue.Value = ""; } else { txt_ECMaxValue.Value = mEntity.ECMaxValue.ToString(); } if (mEntity.ECMinValue == decimal.MinValue) { txt_ECMinValue.Value = ""; } else { txt_ECMinValue.Value = mEntity.ECMinValue.ToString(); } //txt_ECMinValue.Value = mEntity.ECMinValue.ToString(); txt_ECWeight.Value = mEntity.ECWeight.ToString(); txt_ECDenom.Value = mEntity.ECDenom.ToString(); txt_ECCalcClass.Value = mEntity.ECCalcClass.ToString(); txt_ECNote.Value = mEntity.ECNote; }
/// <summary> /// 更新数据 /// </summary> /// <returns></returns> bool Update() { string ecid = ViewState["ecid"].ToString(); ECTagEntity mEntity = new ECTagEntity(); mEntity.ECID = ecid; mEntity.UnitID = ddl_UnitID.SelectedValue; mEntity.SeqID = ddl_SeqID.Value.Trim(); mEntity.KpiID = ddl_KpiID.SelectedValue; mEntity.EngunitID = ddl_EngunitID.Value.Trim(); mEntity.CycleID = ddl_CycleID.Value.Trim(); mEntity.ECIsValid = int.Parse(ddl_ECIsValid.Value); mEntity.ECIsCalc = int.Parse(ddl_ECIsCalc.Value); mEntity.ECIsAsses = int.Parse(ddl_ECIsAsses.Value); mEntity.ECIsZero = int.Parse(ddl_ECIsZero.Value); mEntity.ECIsDisplay = int.Parse(ddl_ECIsDisplay.Value); mEntity.ECIsTotal = int.Parse(ddl_ECIsTotal.Value); mEntity.ECCode = txt_ECCode.Value.Trim(); mEntity.ECName = txt_ECName.Value.Trim(); mEntity.ECDesc = txt_ECDesc.Value.Trim(); //if (txt_ECIndex.Value != "") //{} mEntity.ECIndex = int.Parse(txt_ECIndex.Value); mEntity.ECWeb = ddl_ECWeb.Value; // mEntity.ECDesign = txt_ECDesign.Value; mEntity.ECOptimal = txt_ECOptimal.Value; if (txt_ECMaxValue.Value != "") { mEntity.ECMaxValue = decimal.Parse(txt_ECMaxValue.Value); } if (txt_ECMinValue.Value != "") { mEntity.ECMinValue = decimal.Parse(txt_ECMinValue.Value); } mEntity.ECWeight = decimal.Parse(txt_ECWeight.Value.Trim()); mEntity.ECDenom = decimal.Parse(txt_ECDenom.Value.Trim()); mEntity.ECCalcClass = int.Parse(txt_ECCalcClass.Value.Trim()); mEntity.ECNote = txt_ECNote.Value.Trim(); //mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); mEntity.ECModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); return(ECTagDal.Update(mEntity)); }
/// <summary> /// 绑定数据 /// </summary> void BindValues() { string ECID = ViewState["ecid"].ToString(); ECTagEntity mEntity = ECTagDal.GetEntity(ECID); lbl_ECCode.Text = "指标代码:" + mEntity.ECCode; lbl_ECName.Text = "指标名称:" + mEntity.ECName; // tbx_ECCalcExp.Text = mEntity.ECCalcExp; tbx_ECCalcDesc.Text = mEntity.ECCalcDesc; }
/// <summary> /// 更新数据 /// </summary> /// <returns></returns> bool Update() { string ecid = ViewState["ecid"].ToString(); ECTagEntity mEntity = new ECTagEntity(); mEntity.ECID = ecid; mEntity.ECCalcExp = tbx_ECCalcExp.Text;//.Replace("'", "''"); mEntity.ECCalcDesc = tbx_ECCalcDesc.Text; mEntity.ECModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); return(ECTagDal.Update(mEntity)); }
protected bool ImportFromExcelToDelete(DataSet ds) { try { System.Data.DataTable dt = ds.Tables[0]; int nAll = dt.Rows.Count; int nDelete = 0; int nEmpty = 0; foreach (System.Data.DataRow dr in dt.Rows) { if (dr["SelectX"].ToString().ToLower() == "x") { string ECCode = dr["ECCode"].ToString().Trim(); //判断是否存在 if (!ECTagDal.CodeExist(ECCode, "")) { //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();"); nEmpty += 1; continue; } else { //main tag ECTagEntity mEntity = new ECTagEntity(); mEntity.ECID = ECTagDal.GetECIDByCode(ECCode); ECTagDal.Delete(mEntity); nDelete += 1; } } } string strInfor = "标签点总数为:{0}个, 删除成功:{1}个,空标签点: {2}个。"; strInfor = string.Format(strInfor, nAll, nDelete, nEmpty); MessageBox.popupClientMessage(this.Page, strInfor, "call();"); return(true); } catch (Exception ee) { // MessageBox.popupClientMessage(this.Page, ee.Message, "call();"); return(false); } }
protected void btnApply_Click(object sender, EventArgs e) { if (gvTable.Rows.Count <= 0) { return; } for (int i = 0; i < gvTable.Rows.Count; i++) { ECTagEntity csE = new ECTagEntity(); csE.ECID = gvTable.Rows[i]["ECID"].ToString(); csE.ECIndex = i + 1; ECTagDal.Update(csE); } MessageBox.popupClientMessage(this.Page, "排序成功!", "call();"); }
/// <summary> /// 更新数据 /// </summary> /// <returns></returns> bool Update() { string ecid = ViewState["ecid"].ToString(); ECTagEntity mEntity = new ECTagEntity(); mEntity.ECID = ecid; mEntity.ECIsSort = cbx_ECIsSort.Checked ? 1 : 0; mEntity.ECType = int.Parse(ddl_ECType.SelectedValue); mEntity.ECSort = int.Parse(ddl_ECSort.Value); mEntity.ECScore = txt_ECScore.Value; mEntity.ECExExp = txt_ECExExp.Value; mEntity.ECExScore = txt_ECExScore.Value; mEntity.ECModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); return(ECTagDal.Update(mEntity)); }
protected void cbx_ECIsSort_CheckedChanged(object sender, EventArgs e) { string ecid = ViewState["ecid"].ToString(); if (ecid == "") { btnApply.Enabled = false; return; } else { btnApply.Enabled = true; } ECTagEntity ect = new ECTagEntity(); ect.ECID = ecid; ect.ECIsSort = cbx_ECIsSort.Checked ? 1 : 0; ECTagDal.Update(ect); }
/// <summary> /// 绑定数据 /// </summary> void BindValues() { string ECID = ViewState["ecid"].ToString(); if (ECID == "") { btnApply.Enabled = false; return; } ECTagEntity mEntity = ECTagDal.GetEntity(ECID); lbl_ECCode.Text = "指标代码:" + mEntity.ECCode; lbl_ECName.Text = "指标名称:" + mEntity.ECName; //if(mEntity.ECType ddl_ECType.SelectedValue = mEntity.ECType.ToString(); ddl_ECSort.Value = mEntity.ECSort.ToString(); txt_ECExExp.Value = mEntity.ECExExp; txt_ECExScore.Value = mEntity.ECExScore; }
/// <summary> /// 插入数据 /// </summary> /// <returns></returns> bool Insert(string ecid) { // //插入时更新所有的字段 // ECTagEntity mEntity = new ECTagEntity(); mEntity.ECID = ecid; mEntity.UnitID = ddl_UnitID.SelectedValue; mEntity.SeqID = ddl_SeqID.Value.Trim(); mEntity.KpiID = ddl_KpiID.SelectedValue; mEntity.EngunitID = ddl_EngunitID.Value.Trim(); mEntity.CycleID = ddl_CycleID.Value.Trim(); mEntity.ECCode = txt_ECCode.Value.Trim(); mEntity.ECName = txt_ECName.Value.Trim(); mEntity.ECDesc = txt_ECDesc.Value.Trim(); mEntity.ECIndex = int.Parse(txt_ECIndex.Value); mEntity.ECWeb = ddl_ECWeb.Value; mEntity.ECIsValid = int.Parse(ddl_ECIsValid.Value); mEntity.ECIsCalc = int.Parse(ddl_ECIsCalc.Value); mEntity.ECIsAsses = int.Parse(ddl_ECIsAsses.Value); mEntity.ECIsZero = int.Parse(ddl_ECIsZero.Value); mEntity.ECIsDisplay = int.Parse(ddl_ECIsDisplay.Value); mEntity.ECIsTotal = int.Parse(ddl_ECIsTotal.Value); mEntity.ECDesign = txt_ECDesign.Value; mEntity.ECOptimal = txt_ECOptimal.Value; if (txt_ECMaxValue.Value != "") { mEntity.ECMaxValue = decimal.Parse(txt_ECMaxValue.Value); } if (txt_ECMinValue.Value != "") { mEntity.ECMinValue = decimal.Parse(txt_ECMinValue.Value); } mEntity.ECWeight = decimal.Parse(txt_ECWeight.Value.Trim()); mEntity.ECDenom = decimal.Parse(txt_ECDenom.Value.Trim()); mEntity.ECCalcClass = int.Parse(txt_ECCalcClass.Value.Trim()); mEntity.ECFilterExp = ""; mEntity.ECCalcExp = ""; mEntity.ECCalcDesc = ""; mEntity.ECIsSnapshot = 0; mEntity.ECXLineType = 0; mEntity.ECXLineGetType = 0; mEntity.ECXLineXRealTag = ""; mEntity.ECXLineYRealTag = ""; mEntity.ECXLineZRealTag = ""; mEntity.ECXLineXYZ = ""; mEntity.ECScoreExp = ""; mEntity.ECCurveGroup = ""; mEntity.ECIsSort = 0; mEntity.ECType = 0; mEntity.ECSort = 0; mEntity.ECScore = ""; mEntity.ECExExp = ""; mEntity.ECExScore = ""; mEntity.ECNote = txt_ECNote.Value.Trim(); mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); mEntity.ECModifyTime = mEntity.ECCreateTime; return(ECTagDal.Insert(mEntity)); }
protected bool ImportFromExcelToModify(DataSet ds) { string strError = ""; try { System.Data.DataTable dt = ds.Tables[0]; int nAll = dt.Rows.Count; int nModify = 0; int nNoExist = 0; foreach (System.Data.DataRow dr in dt.Rows) { if (dr["SelectX"].ToString().ToLower() == "x") { string ECCode = dr["ECCode"].ToString().Trim(); strError = ECCode; //判断是否存在 if (!ECTagDal.CodeExist(ECCode, "")) { //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();"); nNoExist += 1; continue; } //main tag string keyid = ECTagDal.GetECIDByCode(ECCode); 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; ECTagDal.Update(mEntity); nModify += 1; } } string strInfor = "标签点总数为:{0}个, 修改成功:{1}个,不存在标签点: {2}个。"; strInfor = string.Format(strInfor, nAll, nModify, nNoExist); MessageBox.popupClientMessage(this.Page, strInfor, "call();"); return(true); } catch (Exception ee) { // MessageBox.popupClientMessage(this.Page, strError + ": " + ee.Message, "call();"); return(false); } }