protected void btnAddEngunit_Click(object sender, EventArgs e)
{
int index = EngunitDal.EngunitIDCounts();
string sID = PageControl.GetGuid();
EngunitEntity ote = new EngunitEntity();
ote.EngunitID = sID;
ote.EngunitName = "Input Name";
ote.EngunitDesc = "";
ote.EngunitNote = "";
ote.EngunitCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.EngunitModifyTime = ote.EngunitCreateTime;
if (EngunitDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
gvEngunit.EditIndex = index;
BindGrid();
}
void BindGrid()
{
txt_EngunitName.Text = txt_EngunitName.Text.Trim();
DataTable dt = EngunitDal.GetSearchList(txt_EngunitName.Text);
gvEngunit.DataSource = dt;
gvEngunit.DataBind();
}
protected void gvEngunit_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string keyid = ((HtmlInputHidden)(gvEngunit.Rows[e.RowIndex].Cells[0].FindControl("engunitid"))).Value;
string eName = ((TextBox)(gvEngunit.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
string eDesc = ((TextBox)(gvEngunit.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
string eNote = ((TextBox)(gvEngunit.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
string msg = "";
if (eName == "")
{
msg += "名称不能为空！\r\n";
}
if (msg != "")
{
MessageBox.popupClientMessage(this.Page, msg);
return;
}
if (EngunitDal.EngunitExist(eName, keyid))
{
MessageBox.popupClientMessage(this.Page, "该单位已存在！", "call();");
return;
}
EngunitEntity mEntity = new EngunitEntity();
mEntity.EngunitID = keyid;
mEntity.EngunitName = eName;
mEntity.EngunitDesc = eDesc;
mEntity.EngunitNote = eNote;
//mEntity.EngunitCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
mEntity.EngunitModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
if (!EngunitDal.Update(mEntity))
{
MessageBox.popupClientMessage(this.Page, "编辑错误！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "编辑成功！", "call();");
gvEngunit.EditIndex = -1;
BindGrid();
}
}
protected void gvEngunit_RowCommand(object sender, GridViewCommandEventArgs e)
{
string engunitid = e.CommandArgument.ToString();
if (e.CommandName == "dataDelete")
{
if (EngunitDal.DeleteEngunit(engunitid))
{
MessageBox.popupClientMessage(this.Page, "删除成功！", "call();");
BindGrid();
}
else
{
MessageBox.popupClientMessage(this.Page, "删除错误！", "call();");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
btnApply.Attributes.Add("onclick", "setDivPos('Lay1');Lay1.style.visibility='';progress_update();");
//机组信息
DataTable dt = KPI_UnitDal.GetUnits("");
foreach (DataRow dr in dt.Rows)
{
ddl_UnitID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//设备信息
dt = KPI_SeqDal.GetSeqs();
foreach (DataRow dr in dt.Rows)
{
ddl_SeqID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//指标信息
dt = KpiDal.GetKpis();
foreach (DataRow dr in dt.Rows)
{
ddl_KpiID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//单位信息
dt = EngunitDal.GetEngunits();
foreach (DataRow dr in dt.Rows)
{
ddl_EngunitID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//周期信息
dt = CycleDal.GetCycles();
foreach (DataRow dr in dt.Rows)
{
ddl_CycleID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//网页集信息
//信息在KPI_Constant表中
dt = KPI_ConstantDal.GetECWebs();
foreach (DataRow dr in dt.Rows)
{
ddl_ECWeb.Items.Add(new ListItem(dr["Name"].ToString(), dr["Value"].ToString()));
}
//判断是否新建或编辑
if (Request.QueryString["ecid"] != null)
{
ViewState["ecid"] = Request.QueryString["ecid"].ToString();
BindValues();
}
else
{
//添加
ViewState["ecid"] = "";
//
ddl_ECIsValid.Value = "1";
ddl_ECIsCalc.Value = "1";
ddl_ECIsDisplay.Value = "1";
ddl_ECIsTotal.Value = "1";
SetECCodeAndName();
txt_ECIndex.Value = "100";
txt_ECWeight.Value = "1";
txt_ECDenom.Value = "1";
txt_ECCalcClass.Value = "1";
}
btnApply.Visible = true;
}
}
protected bool ImportFromExcelToModify(DataSet ds)
{
string strError = "";
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 ECCode = dr["ECCode"].ToString().Trim();
strError = ECCode;
//判断是否存在
if (!ECTagDal.CodeExist(ECCode, ""))
{
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
nNoExist += 1;
continue;
}
//main tag
string keyid = ECTagDal.GetECIDByCode(ECCode);
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = keyid;
string UnitName = dr["UnitName"].ToString().Trim();
mEntity.UnitID = KPI_UnitDal.GetUnitID(UnitName);
string SeqName = dr["SeqName"].ToString().Trim();
mEntity.SeqID = KPI_SeqDal.GetSeqID(SeqName);
string KpiName = dr["KpiName"].ToString().Trim();
mEntity.KpiID = KpiDal.GetKpiID(KpiName);
string EngunitName = dr["EngunitName"].ToString().Trim();
mEntity.EngunitID = EngunitDal.GetEngunitID(EngunitName);
string CycleName = dr["CycleName"].ToString().Trim();
mEntity.CycleID = CycleDal.GetCycleID(CycleName);
mEntity.ECCode = dr["ECCode"].ToString().Trim();
mEntity.ECName = dr["ECName"].ToString().Trim();
mEntity.ECDesc = dr["ECDesc"].ToString().Trim();
mEntity.ECIndex = int.Parse(dr["ECIndex"].ToString().Trim());
mEntity.ECWeb = dr["ECWeb"].ToString().Trim();
mEntity.ECIsValid = int.Parse(dr["ECIsValid"].ToString().Trim());
mEntity.ECIsCalc = int.Parse(dr["ECIsCalc"].ToString().Trim());
mEntity.ECIsAsses = int.Parse(dr["ECIsAsses"].ToString().Trim());
mEntity.ECIsZero = int.Parse(dr["ECIsZero"].ToString().Trim());
mEntity.ECIsDisplay = int.Parse(dr["ECIsDisplay"].ToString().Trim());
mEntity.ECIsTotal = int.Parse(dr["ECIsTotal"].ToString().Trim());
mEntity.ECDesign = dr["ECDesign"].ToString().Trim();
mEntity.ECOptimal = dr["ECOptimal"].ToString().Trim();
if (dr["ECMaxValue"].ToString().Trim() != "")
{
mEntity.ECMaxValue = decimal.Parse(dr["ECMaxValue"].ToString().Trim());
}
if (dr["ECMinValue"].ToString().Trim() != "")
{
mEntity.ECMinValue = decimal.Parse(dr["ECMinValue"].ToString().Trim());
}
mEntity.ECWeight = decimal.Parse(dr["ECWeight"].ToString().Trim());
mEntity.ECCalcClass = int.Parse(dr["ECCalcClass"].ToString().Trim());
mEntity.ECFilterExp = dr["ECFilterExp"].ToString().Trim();
mEntity.ECCalcExp = dr["ECCalcExp"].ToString().Trim();
mEntity.ECCalcDesc = dr["ECCalcDesc"].ToString().Trim();
mEntity.ECIsSnapshot = int.Parse(dr["ECIsSnapshot"].ToString().Trim());
mEntity.ECXLineType = int.Parse(dr["ECXLineType"].ToString().Trim());
mEntity.ECXLineGetType = int.Parse(dr["ECXLineGetType"].ToString().Trim());
mEntity.ECXLineXRealTag = dr["ECXLineXRealTag"].ToString().Trim();
mEntity.ECXLineYRealTag = dr["ECXLineYRealTag"].ToString().Trim();
mEntity.ECXLineZRealTag = dr["ECXLineZRealTag"].ToString().Trim();
mEntity.ECXLineXYZ = dr["ECXLineXYZ"].ToString().Trim();
mEntity.ECScoreExp = dr["ECScoreExp"].ToString().Trim();
mEntity.ECCurveGroup = dr["ECCurveGroup"].ToString().Trim();
mEntity.ECIsSort = int.Parse(dr["ECIsSort"].ToString().Trim());
mEntity.ECType = int.Parse(dr["ECType"].ToString().Trim());
mEntity.ECSort = int.Parse(dr["ECSort"].ToString().Trim());
mEntity.ECScore = dr["ECScore"].ToString().Trim();
mEntity.ECExExp = dr["ECExExp"].ToString().Trim();
mEntity.ECExScore = dr["ECExScore"].ToString().Trim();
mEntity.ECNote = dr["ECNote"].ToString().Trim();
mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
mEntity.ECModifyTime = mEntity.ECCreateTime;
ECTagDal.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, strError + ": " + ee.Message, "call();");
return(false);
}
}
