protected void btnAdd_Click(object sender, EventArgs e)
{
string controllerName = txtControllerName.Text.Trim();
if (controllerName.Length == 0)
{
LitMsg.Text = "<script type='text/javascript'>alert('链接名称必须填写');</script>";
return;
}
string linkURI = txtLinkURI.Text.Trim();
if (linkURI.Length == 0)
{
LitMsg.Text = "<script type='text/javascript'>alert('链接指向必须填写');</script>";
return;
}
int orderNum = 0;
if (!Function.CheckNumber(txtOrderNum.Text.Trim()))
{
LitMsg.Text = "<script type='text/javascript'>alert('排序必须为非负整数');</script>";
return;
}
orderNum = int.Parse(txtOrderNum.Text.Trim());
M_Controller model = new M_Controller();
model.ControllerId = 0;
model.ControllerName = controllerName;
model.LinkURI = linkURI;
model.OrderNum = orderNum;
model.UserId = UserId;
Bll.Add(model);
txtControllerName.Text = "";
txtLinkURI.Text = "";
txtOrderNum.Text = "";
gvController.EditIndex = -1;
Bind();
}
public void Update(M_Controller model)
{
if (model.ControllerId > 0)
{
this.dal.Update(model);
}
}
public void Update(M_Controller model)
{
this.Add(model);
}
public void Add(M_Controller model)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ControllerId", model.ControllerId), new SqlParameter("@ControllerName", model.ControllerName), new SqlParameter("@LinkURI", model.LinkURI), new SqlParameter("@OrderNum", model.OrderNum), new SqlParameter("@UserId", model.UserId) };
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_Controller_Set", commandParameters);
}
protected void gvController_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int controllerId = (int)gvController.DataKeys[e.RowIndex].Value;
TextBox ctxtControllerName = gvController.Rows[e.RowIndex].Cells[0].Controls[0] as TextBox;
string controllerName = ctxtControllerName.Text.Trim();
if (controllerName.Length == 0||controllerName.Length>50)
{
LitMsg.Text = "<script type='text/javascript'>alert('链接名称必须填写');</script>";
return;
}
TextBox ctxtLinkURI = gvController.Rows[e.RowIndex].Cells[1].Controls[0] as TextBox;
string linkURI = ctxtLinkURI.Text.Trim();
if (linkURI.Length == 0 || controllerName.Length > 255)
{
LitMsg.Text = "<script type='text/javascript'>alert('链接指向必须填写');</script>";
return;
}
TextBox ctxtOrderNum = gvController.Rows[e.RowIndex].Cells[2].Controls[0] as TextBox;
int orderNum = 0;
if (!Function.CheckNumber(ctxtOrderNum.Text.Trim()))
{
LitMsg.Text = "<script type='text/javascript'>alert('排序必须为非负整数');</script>";
return;
}
orderNum = int.Parse(ctxtOrderNum.Text.Trim());
M_Controller model = new M_Controller();
model.ControllerId = controllerId;
model.ControllerName = controllerName;
model.LinkURI = linkURI;
model.OrderNum = orderNum;
model.UserId = UserId;
Bll.Update(model);
gvController.EditIndex = -1;
Bind();
}
public void Add(M_Controller model)
{
this.dal.Add(model);
}
