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