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(); //更新完了之后，就得重新绑定，即重新从数据库中读取刚才更新的数据。
}
