protected void btnApply_Click(object sender, EventArgs e)
{
if (gvTable.Rows.Count <= 0)
{
return;
}
for (int i = 0; i < gvTable.Rows.Count; i++)
{
Race_TagEntity csE = new Race_TagEntity();
csE.TagID = gvTable.Rows[i]["TagID"].ToString();
csE.TagIndex = i + 1;
Race_TagDal.Update(csE);
}
MessageBox.popupClientMessage(this.Page, "排序成功！", "call();");
}
protected bool ImportFromExcelToModify(DataSet ds)
{
//需要导入到机组ID
string UnitID = ddlExcelUnitID.Value;
//string PlantID = ddlExcelPlantID.Value;
//if (UnitID == "NON")
//{
// UnitID = "";
//}
//////////////////////////////////////////////////////
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 TagName = dr["TagName"].ToString().Trim();
//判断是否存在
if (!Race_TagDal.TagNameExist(TagName))
{
nNoExist += 1;
continue;
}
//main tag
string keyid = Race_TagDal.GetTagID(TagName, UnitID);
Race_TagEntity mEntity = new Race_TagEntity();
mEntity.TagID = keyid;
mEntity.UnitID = UnitID;
mEntity.TagName = TagName;
mEntity.TagDesc = dr["TagDesc"].ToString().Trim();
mEntity.TagType = dr["TagType"].ToString().Trim();
mEntity.TagEngunit = dr["TagEngunit"].ToString().Trim();
string sv = dr["TagIsValid"].ToString().Trim();
if (sv != "")
{
mEntity.TagIsValid = int.Parse(sv);
}
sv = dr["TagIndex"].ToString().Trim();
if (sv != "")
{
mEntity.TagIndex = int.Parse(sv);
}
mEntity.TagFilterExp = dr["TagFilterExp"].ToString().Trim();//.Replace("'", "''");
mEntity.TagCalcExp = dr["TagCalcExp"].ToString().Trim();//.Replace("'", "''");
sv = dr["TagCalcExpType"].ToString().Trim();
if (sv != "")
{
mEntity.TagCalcExpType = int.Parse(sv);
}
sv = dr["TagCalcType"].ToString().Trim();
if (sv != "")
{
mEntity.TagCalcType = int.Parse(sv);
}
sv = dr["TagFactor"].ToString().Trim();
if (sv != "")
{
mEntity.TagFactor = decimal.Parse(sv);
}
sv = dr["TagOffset"].ToString().Trim();
if (sv != "")
{
mEntity.TagOffset = decimal.Parse(sv);
}
Race_TagDal.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;
}
}