protected void btnAddConstant_Click(object sender, EventArgs e)
{
int index = KPI_ConstantDal.ConstantIDCounts();
string sID = PageControl.GetGuid();
ConstantEntity ote = new ConstantEntity();
ote.ConstantID = sID;
ote.ConstantCode = "InputCode";
ote.ConstantName = "Input Name";
ote.ConstantDesc = "";
ote.ConstantValue = "Input Value";
ote.ConstantNote = "";
ote.ConstantCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.ConstantModifyTime = ote.ConstantCreateTime;
if (KPI_ConstantDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
gvConstant.EditIndex = index;
BindConstant();
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
}
private void DeleteInputTagCategory(HttpContext context)
{
KPI_ConstantDal DataAccess = new KPI_ConstantDal();
HttpRequest Request = context.Request;
HttpResponse Response = context.Response;
Msg msg;
try {
ConstantEntity Constant = new ConstantEntity {
ConstantID = Request.Params["ConstantID"],
ConstantCode = "M",
ConstantName = Request.Params["ConstantName"],
ConstantValue = Request.Params["ConstantValue"]
};
DataAccess.DeleteConstant(Constant);
msg = new Msg {
Status = "ok",
Message = "数据删除成功！"
};
}
catch (Exception ex) {
msg = new Msg {
Status = "error",
Message = "数据删除失败！错误信息：" + ex.Message,
StackTrace = ex.StackTrace
};
}
Response.Write(JsonConvert.SerializeObject(msg));
}
/// <summary>
/// //设备信息
/// </summary>
void BindConstant()
{
//设备信息
DataTable dtConstant = KPI_ConstantDal.GetConstantList();
gvConstant.DataSource = dtConstant;
gvConstant.DataBind();
}
private void ClientInitial()
{
drpTagCategorys.DataSource = KPI_ConstantDal.GetManagementTags();
drpTagCategorys.DataValueField = "ConstantValue";
drpTagCategorys.DataTextField = "ConstantName";
drpTagCategorys.DataBind();
txtCheckDate.Text = DateTime.Now.Date.ToString("yyyy-MM-dd");
txtTagScore.Text = "0";
}
private void ClientInitial()
{
drpInputType.DataSource = KPI_ConstantDal.GetManagementTags();
drpInputType.DataValueField = "ConstantValue";
drpInputType.DataTextField = "ConstantName";
drpInputType.DataBind();
drpTagCategorys.DataSource = drpInputType.DataSource;
drpTagCategorys.DataValueField = "ConstantValue";
drpTagCategorys.DataTextField = "ConstantName";
drpTagCategorys.DataBind();
}
protected void gvConstant_RowCommand(object sender, GridViewCommandEventArgs e)
{
string keyid = e.CommandArgument.ToString();
if (e.CommandName == "dataDelete")
{
if (KPI_ConstantDal.DeleteConstant(keyid))
{
MessageBox.popupClientMessage(this.Page, "删除成功！", "call();");
BindConstant();
}
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 void gvConstant_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
HtmlInputHidden key = (HtmlInputHidden)gvConstant.Rows[e.RowIndex].Cells[0].FindControl("constantid");
string sID = key.Value;
string sCode = ((TextBox)(gvConstant.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
string sName = ((TextBox)(gvConstant.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
string sDesc = ((TextBox)(gvConstant.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
string sValue = ((TextBox)(gvConstant.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim();
string sNote = ((TextBox)(gvConstant.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim();
string msg = "";
if (sCode == "")
{
msg += "类型不能为空！\r\n";
}
if (sName == "")
{
msg += "名称不能为空！\r\n";
}
if (!Regex.IsMatch(sCode, "^[A-Za-z]+$"))
{
msg += "类型只能为字母！\r\n";
}
if (msg != "")
{
MessageBox.popupClientMessage(this.Page, msg);
return;
}
//代码是否重复
if (KPI_ConstantDal.ConstantNameExists(sName, sCode))
{
MessageBox.popupClientMessage(this.Page, "相同的类型下已存在该名称!");
return;
}
//更新
ConstantEntity ote = new ConstantEntity();
ote.ConstantID = sID;
ote.ConstantCode = sCode;
ote.ConstantName = sName;
ote.ConstantDesc = sDesc;
ote.ConstantValue = sValue;
ote.ConstantNote = sNote;
ote.ConstantModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
if (KPI_ConstantDal.Update(ote))
{
MessageBox.popupClientMessage(this.Page, "编辑成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "编辑错误！", "call();");
}
gvConstant.EditIndex = -1;
BindConstant();
}
public override void DataBind()
{
TagCategorys.DataSource = KPI_ConstantDal.GetManagementTags();
base.DataBind();
}