public static void intsert(string name,string remark)
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
t_Sys sys = new t_Sys();
sys.name = name;
sys.remark = remark;
dc.t_Sys.InsertOnSubmit(sys);
dc.SubmitChanges();
}
}
public static void update(t_Sys sys)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
t_Sys s = dc.t_Sys.Where(i => i.Id == sys.Id).Single();
s.name = sys.name;
s.remark = sys.remark;
dc.SubmitChanges();
}
}
protected void gvSys_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
String id = gvSys.DataKeys[e.RowIndex].Value.ToString();
String name = ((TextBox)gvSys.Rows[e.RowIndex].Cells[1].FindControl("tbName")).Text.ToString().Trim();
String remark = ((TextBox)gvSys.Rows[e.RowIndex].Cells[2].FindControl("tbRemark")).Text.ToString().Trim();
t_Sys sys = new t_Sys();
sys.Id = Convert.ToInt32(id);
sys.name = name;
sys.remark = remark;
BLL.admin.sys.SysManage.update(sys);
gvSys.EditIndex = -1;
databind();
}
