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(); }
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); } }