private String GetTagID(String TagCode) { if (String.IsNullOrWhiteSpace(TagCode)) { return(""); } return(KPI_RealTagDal.GetID(TagCode)); }
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 RealCode = dr["RealCode"].ToString().Trim(); //判断是否存在 if (!KPI_RealTagDal.CodeExist(RealCode, "")) { //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();"); nEmpty += 1; continue; } else { //main tag //string RealID = KPI_RealTagDal.GetRealID(RealCode); KPI_RealTagEntity mEntity = new KPI_RealTagEntity(); mEntity.RealID = KPI_RealTagDal.GetID(RealCode); KPI_RealTagDal.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 bool ImportFromExcelToModify(DataSet ds) { 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 RealCode = dr["RealCode"].ToString().Trim(); //判断是否存在 if (!KPI_RealTagDal.CodeExist(RealCode, "")) { //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();"); nNoExist += 1; continue; } //main tag string keyid = KPI_RealTagDal.GetID(RealCode); 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(); KPI_RealTagDal.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, ee.Message, "call();"); return(false); } }