protected void btnAddSeq_Click(object sender, EventArgs e)
{
int index = KPI_SeqDal.SeqIDCounts();
string sID = PageControl.GetGuid();
KPI_SeqEntity ote = new KPI_SeqEntity();
ote.SeqID = sID;
ote.SeqCode = "InputCode";
ote.SeqName = "Input Name";
ote.SeqDesc = "";
ote.SeqIsValid = 1;
ote.SeqNote = "";
ote.SeqCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.SeqModifyTime = ote.SeqCreateTime;
if (KPI_SeqDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
gvSeq.EditIndex = index;
BindSeq();
}
protected void gvSeq_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
HtmlInputHidden key = (HtmlInputHidden)gvSeq.Rows[e.RowIndex].Cells[0].FindControl("seqid");
string sID = key.Value;
string sCode = ((TextBox)(gvSeq.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
string sName = ((TextBox)(gvSeq.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
string sDesc = ((TextBox)(gvSeq.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
string sNote = ((TextBox)(gvSeq.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim();
string msg = "";
if (sName == "" || sCode =="")
{
msg += "代码或名称不能为空！\r\n";
}
if(!Regex.IsMatch(sCode, "^[A-Za-z0-9]+$"))
{
msg += "代码只能为字母和数字组成！\r\n";
}
if (msg != "")
{
MessageBox.popupClientMessage(this.Page, msg);
return;
}
//代码是否重复
if (KPI_SeqDal.SeqCodeExists(sCode, sID))
{
MessageBox.popupClientMessage(this.Page, "已存在相同的代码!");
return;
}
//更新
KPI_SeqEntity ote = new KPI_SeqEntity();
ote.SeqID = sID;
ote.SeqCode = sCode;
ote.SeqName = sName;
ote.SeqDesc = sDesc;
ote.SeqNote = sNote;
ote.SeqModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
if (KPI_SeqDal.Update(ote))
{
MessageBox.popupClientMessage(this.Page, "编辑成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "编辑错误！", "call();");
}
gvSeq.EditIndex = -1;
BindSeq();
}
