/// <summary>
/// 插入数据
/// </summary>
/// <returns></returns>
bool Insert(string ecid)
{
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ecid;
//mEntity.UnitID = ddl_UnitID.SelectedValue;
//mEntity.SeqID = ddl_SeqID.Value.Trim();
//mEntity.KpiID = ddl_KpiID.SelectedValue;
//mEntity.EngunitID = ddl_EngunitID.Value.Trim();
//mEntity.CycleID = ddl_CycleID.Value.Trim();
//mEntity.ECIsValid = int.Parse(ddl_ECIsValid.Value);
//mEntity.ECIsCalc = int.Parse(ddl_ECIsCalc.Value);
//mEntity.ECIsDisplay = int.Parse(ddl_ECIsDisplay.Value);
//mEntity.ECIsTotal = int.Parse(ddl_ECIsTotal.Value);
//mEntity.ECCode = txt_ECCode.Value.Trim();
//mEntity.ECName = txt_ECName.Value.Trim();
//mEntity.ECDesc = txt_ECDesc.Value.Trim();
//mEntity.ECIndex = int.Parse(txt_ECIndex.Value.Trim());
//mEntity.ECWeb = ddl_ECWeb.Value;
////
//mEntity.ECDesign = txt_ECDesign.Value;
//mEntity.ECOptimal = txt_ECOptimal.Value;
//mEntity.ECMaxValue = int.Parse(txt_ECMaxValue.Value.Trim());
//mEntity.ECMinValue = int.Parse(txt_ECMinValue.Value.Trim());
//mEntity.ECWeight = int.Parse(txt_ECWeight.Value.Trim());
//mEntity.ECNote = txt_ECNote.Value.Trim();
//mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
//mEntity.ECModifyTime = mEntity.ECCreateTime;
return(ECTagDal.Insert(mEntity));
}
/// <summary>
/// 绑定数据
/// </summary>
void BindValues()
{
string ECID = ViewState["ecid"].ToString();
if (ECID == "")
{
btnAddScore.Enabled = false;
return;
}
mEntity = ECTagDal.GetEntity(ECID);
if (mEntity == null)
{
return;
}
lbl_ECCode.Text = "指标代码：" + mEntity.ECCode;
lbl_ECName.Text = "指标名称：" + mEntity.ECName;
cbx_ECIsSnapshot.Checked = mEntity.ECIsSnapshot == 1 ? true : false;
BindScore(true);
}
/// <summary>
/// 绑定数据
/// </summary>
void BindValues()
{
string ECID = ViewState["ecid"].ToString();
if (ECID == "")
{
return;
}
ECTagEntity mEntity = ECTagDal.GetEntity(ECID);
ddl_UnitID.SelectedValue = mEntity.UnitID;
ddl_SeqID.Value = mEntity.SeqID;
ddl_KpiID.SelectedValue = mEntity.KpiID;
ddl_EngunitID.Value = mEntity.EngunitID;
ddl_CycleID.Value = mEntity.CycleID;
ddl_ECIsValid.Value = mEntity.ECIsValid.ToString();
ddl_ECIsCalc.Value = mEntity.ECIsCalc.ToString();
ddl_ECIsAsses.Value = mEntity.ECIsAsses.ToString();
ddl_ECIsZero.Value = mEntity.ECIsZero.ToString();
ddl_ECIsDisplay.Value = mEntity.ECIsDisplay.ToString();
ddl_ECIsTotal.Value = mEntity.ECIsTotal.ToString();
ddl_ECWeb.Value = mEntity.ECWeb;
txt_ECCode.Value = mEntity.ECCode;
txt_ECName.Value = mEntity.ECName;
txt_ECDesc.Value = mEntity.ECDesc;
txt_ECIndex.Value = mEntity.ECIndex.ToString();
txt_ECDesign.Value = mEntity.ECDesign;
if (mEntity.ECMaxValue == decimal.MinValue)
{
txt_ECMaxValue.Value = "";
}
else
{
txt_ECMaxValue.Value = mEntity.ECMaxValue.ToString();
}
if (mEntity.ECMinValue == decimal.MinValue)
{
txt_ECMinValue.Value = "";
}
else
{
txt_ECMinValue.Value = mEntity.ECMinValue.ToString();
}
//txt_ECMinValue.Value = mEntity.ECMinValue.ToString();
txt_ECWeight.Value = mEntity.ECWeight.ToString();
txt_ECDenom.Value = mEntity.ECDenom.ToString();
txt_ECCalcClass.Value = mEntity.ECCalcClass.ToString();
txt_ECNote.Value = mEntity.ECNote;
}
/// <summary>
/// 更新数据
/// </summary>
/// <returns></returns>
bool Update()
{
string ecid = ViewState["ecid"].ToString();
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ecid;
mEntity.UnitID = ddl_UnitID.SelectedValue;
mEntity.SeqID = ddl_SeqID.Value.Trim();
mEntity.KpiID = ddl_KpiID.SelectedValue;
mEntity.EngunitID = ddl_EngunitID.Value.Trim();
mEntity.CycleID = ddl_CycleID.Value.Trim();
mEntity.ECIsValid = int.Parse(ddl_ECIsValid.Value);
mEntity.ECIsCalc = int.Parse(ddl_ECIsCalc.Value);
mEntity.ECIsAsses = int.Parse(ddl_ECIsAsses.Value);
mEntity.ECIsZero = int.Parse(ddl_ECIsZero.Value);
mEntity.ECIsDisplay = int.Parse(ddl_ECIsDisplay.Value);
mEntity.ECIsTotal = int.Parse(ddl_ECIsTotal.Value);
mEntity.ECCode = txt_ECCode.Value.Trim();
mEntity.ECName = txt_ECName.Value.Trim();
mEntity.ECDesc = txt_ECDesc.Value.Trim();
//if (txt_ECIndex.Value != "")
//{}
mEntity.ECIndex = int.Parse(txt_ECIndex.Value);
mEntity.ECWeb = ddl_ECWeb.Value;
//
mEntity.ECDesign = txt_ECDesign.Value;
mEntity.ECOptimal = txt_ECOptimal.Value;
if (txt_ECMaxValue.Value != "")
{
mEntity.ECMaxValue = decimal.Parse(txt_ECMaxValue.Value);
}
if (txt_ECMinValue.Value != "")
{
mEntity.ECMinValue = decimal.Parse(txt_ECMinValue.Value);
}
mEntity.ECWeight = decimal.Parse(txt_ECWeight.Value.Trim());
mEntity.ECDenom = decimal.Parse(txt_ECDenom.Value.Trim());
mEntity.ECCalcClass = int.Parse(txt_ECCalcClass.Value.Trim());
mEntity.ECNote = txt_ECNote.Value.Trim();
//mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
mEntity.ECModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
return(ECTagDal.Update(mEntity));
}
/// <summary>
/// 绑定数据
/// </summary>
void BindValues()
{
string ECID = ViewState["ecid"].ToString();
ECTagEntity mEntity = ECTagDal.GetEntity(ECID);
lbl_ECCode.Text = "指标代码：" + mEntity.ECCode;
lbl_ECName.Text = "指标名称：" + mEntity.ECName;
//
tbx_ECCalcExp.Text = mEntity.ECCalcExp;
tbx_ECCalcDesc.Text = mEntity.ECCalcDesc;
}
/// <summary>
/// 更新数据
/// </summary>
/// <returns></returns>
bool Update()
{
string ecid = ViewState["ecid"].ToString();
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ecid;
mEntity.ECCalcExp = tbx_ECCalcExp.Text;//.Replace("'", "''");
mEntity.ECCalcDesc = tbx_ECCalcDesc.Text;
mEntity.ECModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
return(ECTagDal.Update(mEntity));
}
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 ECCode = dr["ECCode"].ToString().Trim();
//判断是否存在
if (!ECTagDal.CodeExist(ECCode, ""))
{
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
nEmpty += 1;
continue;
}
else
{
//main tag
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ECTagDal.GetECIDByCode(ECCode);
ECTagDal.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 void btnApply_Click(object sender, EventArgs e)
{
if (gvTable.Rows.Count <= 0)
{
return;
}
for (int i = 0; i < gvTable.Rows.Count; i++)
{
ECTagEntity csE = new ECTagEntity();
csE.ECID = gvTable.Rows[i]["ECID"].ToString();
csE.ECIndex = i + 1;
ECTagDal.Update(csE);
}
MessageBox.popupClientMessage(this.Page, "排序成功！", "call();");
}
/// <summary>
/// 更新数据
/// </summary>
/// <returns></returns>
bool Update()
{
string ecid = ViewState["ecid"].ToString();
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ecid;
mEntity.ECIsSort = cbx_ECIsSort.Checked ? 1 : 0;
mEntity.ECType = int.Parse(ddl_ECType.SelectedValue);
mEntity.ECSort = int.Parse(ddl_ECSort.Value);
mEntity.ECScore = txt_ECScore.Value;
mEntity.ECExExp = txt_ECExExp.Value;
mEntity.ECExScore = txt_ECExScore.Value;
mEntity.ECModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
return(ECTagDal.Update(mEntity));
}
protected void cbx_ECIsSort_CheckedChanged(object sender, EventArgs e)
{
string ecid = ViewState["ecid"].ToString();
if (ecid == "")
{
btnApply.Enabled = false;
return;
}
else
{
btnApply.Enabled = true;
}
ECTagEntity ect = new ECTagEntity();
ect.ECID = ecid;
ect.ECIsSort = cbx_ECIsSort.Checked ? 1 : 0;
ECTagDal.Update(ect);
}
/// <summary>
/// 绑定数据
/// </summary>
void BindValues()
{
string ECID = ViewState["ecid"].ToString();
if (ECID == "")
{
btnApply.Enabled = false;
return;
}
ECTagEntity mEntity = ECTagDal.GetEntity(ECID);
lbl_ECCode.Text = "指标代码：" + mEntity.ECCode;
lbl_ECName.Text = "指标名称：" + mEntity.ECName;
//if(mEntity.ECType
ddl_ECType.SelectedValue = mEntity.ECType.ToString();
ddl_ECSort.Value = mEntity.ECSort.ToString();
txt_ECExExp.Value = mEntity.ECExExp;
txt_ECExScore.Value = mEntity.ECExScore;
}
/// <summary>
/// 插入数据
/// </summary>
/// <returns></returns>
bool Insert(string ecid)
{
//
//插入时更新所有的字段
//
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ecid;
mEntity.UnitID = ddl_UnitID.SelectedValue;
mEntity.SeqID = ddl_SeqID.Value.Trim();
mEntity.KpiID = ddl_KpiID.SelectedValue;
mEntity.EngunitID = ddl_EngunitID.Value.Trim();
mEntity.CycleID = ddl_CycleID.Value.Trim();
mEntity.ECCode = txt_ECCode.Value.Trim();
mEntity.ECName = txt_ECName.Value.Trim();
mEntity.ECDesc = txt_ECDesc.Value.Trim();
mEntity.ECIndex = int.Parse(txt_ECIndex.Value);
mEntity.ECWeb = ddl_ECWeb.Value;
mEntity.ECIsValid = int.Parse(ddl_ECIsValid.Value);
mEntity.ECIsCalc = int.Parse(ddl_ECIsCalc.Value);
mEntity.ECIsAsses = int.Parse(ddl_ECIsAsses.Value);
mEntity.ECIsZero = int.Parse(ddl_ECIsZero.Value);
mEntity.ECIsDisplay = int.Parse(ddl_ECIsDisplay.Value);
mEntity.ECIsTotal = int.Parse(ddl_ECIsTotal.Value);
mEntity.ECDesign = txt_ECDesign.Value;
mEntity.ECOptimal = txt_ECOptimal.Value;
if (txt_ECMaxValue.Value != "")
{
mEntity.ECMaxValue = decimal.Parse(txt_ECMaxValue.Value);
}
if (txt_ECMinValue.Value != "")
{
mEntity.ECMinValue = decimal.Parse(txt_ECMinValue.Value);
}
mEntity.ECWeight = decimal.Parse(txt_ECWeight.Value.Trim());
mEntity.ECDenom = decimal.Parse(txt_ECDenom.Value.Trim());
mEntity.ECCalcClass = int.Parse(txt_ECCalcClass.Value.Trim());
mEntity.ECFilterExp = "";
mEntity.ECCalcExp = "";
mEntity.ECCalcDesc = "";
mEntity.ECIsSnapshot = 0;
mEntity.ECXLineType = 0;
mEntity.ECXLineGetType = 0;
mEntity.ECXLineXRealTag = "";
mEntity.ECXLineYRealTag = "";
mEntity.ECXLineZRealTag = "";
mEntity.ECXLineXYZ = "";
mEntity.ECScoreExp = "";
mEntity.ECCurveGroup = "";
mEntity.ECIsSort = 0;
mEntity.ECType = 0;
mEntity.ECSort = 0;
mEntity.ECScore = "";
mEntity.ECExExp = "";
mEntity.ECExScore = "";
mEntity.ECNote = txt_ECNote.Value.Trim();
mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
mEntity.ECModifyTime = mEntity.ECCreateTime;
return(ECTagDal.Insert(mEntity));
}
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);
}
}
