public static bool addShift(KQ_Shift sh) { using(DataClassesEduDataContext dc= new DataClassesEduDataContext()) { dc.KQ_Shift.InsertOnSubmit(sh); dc.SubmitChanges(); return true; } }
List<KQ_Shift> listShift = new List<KQ_Shift>(); //数据库读出的班次记录 #endregion Fields #region Methods protected void btAdd_Click(object sender, EventArgs e) { KQ_Shift sh = new KQ_Shift(); sh.Name = tbName.Text; sh.isClockOn = cbShangban.Checked; sh.ClockOnTime = tbShangbanTime.Text; sh.isClockOff = cbXiaban.Checked; sh.ClockOffTime = tbXiabanTime.Text; sh.isDefault = cbDefault.Checked; sh.Remark = tbRemark.Text; BLL.Application.KQ.SchedulingManagement.addShift(sh); databind(); }
public static void updateShift(KQ_Shift sh) { using (DataClassesEduDataContext dc = new DataClassesEduDataContext()) { KQ_Shift kq = dc.KQ_Shift.Where(k => k.Id == sh.Id).Single(); kq.Name = sh.Name; kq.isClockOn = sh.isClockOn; kq.ClockOnTime = sh.ClockOnTime; kq.isClockOff = sh.isClockOff; kq.ClockOffTime = sh.ClockOffTime; kq.isDefault = sh.isDefault; kq.Remark = sh.Remark; dc.SubmitChanges(); } }
protected void gvShift_RowUpdating(object sender, GridViewUpdateEventArgs e) { KQ_Shift sh = new KQ_Shift(); sh.Id = Convert.ToInt32( gvShift.DataKeys[e.RowIndex].Value.ToString()); sh.Name = ((TextBox)gvShift.Rows[e.RowIndex].Cells[1].FindControl("tbName")).Text; sh.isClockOn = ((CheckBox)gvShift.Rows[e.RowIndex].Cells[2].FindControl("cbShangban")).Checked; sh.ClockOnTime = ((TextBox)gvShift.Rows[e.RowIndex].Cells[3].FindControl("tbClockOnTime")).Text; sh.isClockOff = ((CheckBox)gvShift.Rows[e.RowIndex].Cells[4].FindControl("cbXiaban")).Checked; sh.ClockOffTime = ((TextBox)gvShift.Rows[e.RowIndex].Cells[5].FindControl("tbClockOffTime")).Text; sh.isDefault = ((CheckBox)gvShift.Rows[e.RowIndex].Cells[6].FindControl("cbDefault")).Checked; sh.Remark = ((TextBox)gvShift.Rows[e.RowIndex].Cells[7].FindControl("tbRemark")).Text; BLL.Application.KQ.SchedulingManagement.updateShift(sh); gvShift.EditIndex = -1; //将GridView控件恢复为编辑前的状态。即更新完了就得回到非编辑状态 databind(); //更新完了之后,就得重新绑定,即重新从数据库中读取刚才更新的数据。 }