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