protected void btnSave_Click(object sender, EventArgs e) { foreach (DataListItem item in dlEmployee.Items) { DropDownList ddlcheckin, ddlcheckout; CheckBox chkIsLeave; TextBox txtAnnual, txtSick, txtOther; chkIsLeave = (CheckBox)item.FindControl("chkIsLeave"); txtAnnual = (TextBox)item.FindControl("txtAnnualLeave"); txtSick = (TextBox)item.FindControl("txtSickLeave"); txtOther = (TextBox)item.FindControl("txtOtherLeave"); ddlcheckin = (DropDownList)item.FindControl("ddlCheckIn"); ddlcheckout = (DropDownList)item.FindControl("ddlCheckOut"); HiddenField empNum = (HiddenField)item.FindControl("employeeNum"); tblReservationTime entity = new tblReservationTime(); entity.workdate = (DateTime)DateSelector1.DateValue; entity.checkinTime = ddlcheckin.SelectedItem.Text; entity.checkoutTime = ddlcheckout.SelectedItem.Text; entity.employeeNum = empNum.Value; entity.isLeave = chkIsLeave.Checked; entity.AnnualLeave = txtAnnual.Text.Trim(); entity.SickLeave = txtSick.Text.Trim(); entity.OtherLeave = txtOther.Text.Trim(); rh.saveReservationTime(entity); } this.ShowSavaOK(""); }
protected void btnSave_Click(object sender, EventArgs e) { foreach (RepeaterItem Item in rptEmp.Items) { DropDownList ddlcheckin, ddlcheckout; CheckBox chkIsLeave, chkSel; TextBox txtAnnual, txtSick, txtOther; chkIsLeave = (CheckBox)Item.FindControl("chkIsLeave"); chkSel = (CheckBox)Item.FindControl("chkSel"); txtAnnual = (TextBox)Item.FindControl("txtAnnualLeave"); txtSick = (TextBox)Item.FindControl("txtSickLeave"); txtOther = (TextBox)Item.FindControl("txtOtherLeave"); ddlcheckin = (DropDownList)Item.FindControl("ddlCheckIn"); ddlcheckout = (DropDownList)Item.FindControl("ddlCheckOut"); HiddenField empNum = (HiddenField)Item.FindControl("employeeNum"); //---add work store field //-- 如果選擇了,就是該分店的當天上班的員工. 員工每天上班的分店是不固定的 if (chkSel.Checked) { tblReservationTime entity = new tblReservationTime(); entity.workdate = (DateTime)DateSelector1.DateValue; entity.checkinTime = ddlcheckin.SelectedItem.Text; entity.checkoutTime = ddlcheckout.SelectedItem.Text; entity.employeeNum = empNum.Value; entity.isLeave = chkIsLeave.Checked; entity.AnnualLeave = txtAnnual.Text.Trim(); entity.SickLeave = txtSick.Text.Trim(); entity.OtherLeave = txtOther.Text.Trim(); entity.workStore = ddlStoreNum.SelectedValue; rh.saveReservationTime(entity); } } this.ShowSavaOK(""); }
public tblReservationTime saveReservationTime(tblReservationTime entity) { if (dataCtx.Connection != null) { dataCtx.Connection.Open(); } DbTransaction tran = dataCtx.Connection.BeginTransaction(); dataCtx.Transaction = tran; try { var qry = from t in ReservationTimes where t.employeeNum == entity.employeeNum && t.workdate == entity.workdate select t; var obj = qry.SingleOrDefault(); if (obj != null) { //pk identity can't update //this.CopyEntity(obj, entity); obj.checkinTime = entity.checkinTime; obj.checkoutTime = entity.checkoutTime; obj.isLeave = entity.isLeave; obj.AnnualLeave = entity.AnnualLeave; obj.SickLeave = entity.SickLeave; obj.OtherLeave = entity.OtherLeave; obj.workOffice = entity.workOffice; } else { this.ReservationTimes.InsertOnSubmit(entity); } this.dataCtx.SubmitChanges(); tran.Commit(); return(obj); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { dataCtx.Connection.Close(); } }
protected void btnSave_Click(object sender, EventArgs e) { foreach (RepeaterItem Item in rptEmp.Items) { DropDownList ddlcheckin, ddlcheckout; CheckBox chkIsLeave,chkSel; TextBox txtAnnual, txtSick, txtOther; chkIsLeave = (CheckBox)Item.FindControl("chkIsLeave"); chkSel = (CheckBox)Item.FindControl("chkSel"); txtAnnual = (TextBox)Item.FindControl("txtAnnualLeave"); txtSick = (TextBox)Item.FindControl("txtSickLeave"); txtOther = (TextBox)Item.FindControl("txtOtherLeave"); ddlcheckin = (DropDownList)Item.FindControl("ddlCheckIn"); ddlcheckout = (DropDownList)Item.FindControl("ddlCheckOut"); HiddenField empNum = (HiddenField)Item.FindControl("employeeNum"); //---add work store field //-- 如果選擇了,就是該分店的當天上班的員工. 員工每天上班的分店是不固定的 if (chkSel.Checked) { tblReservationTime entity = new tblReservationTime(); entity.workdate = (DateTime)DateSelector1.DateValue; entity.checkinTime = ddlcheckin.SelectedItem.Text; entity.checkoutTime = ddlcheckout.SelectedItem.Text; entity.employeeNum = empNum.Value; entity.isLeave = chkIsLeave.Checked; entity.AnnualLeave = txtAnnual.Text.Trim(); entity.SickLeave = txtSick.Text.Trim(); entity.OtherLeave = txtOther.Text.Trim(); entity.workStore = ddlStoreNum.SelectedValue; rh.saveReservationTime(entity); } } this.ShowSavaOK(""); }
public tblReservationTime saveReservationTime(tblReservationTime entity) { if (dataCtx.Connection != null) dataCtx.Connection.Open(); DbTransaction tran = dataCtx.Connection.BeginTransaction(); dataCtx.Transaction = tran; try { var qry = from t in ReservationTimes where t.employeeNum == entity.employeeNum && t.workdate == entity.workdate select t; var obj = qry.SingleOrDefault(); if (obj != null) { //pk identity can't update //this.CopyEntity(obj, entity); obj.checkinTime = entity.checkinTime; obj.checkoutTime = entity.checkoutTime; obj.isLeave = entity.isLeave; obj.AnnualLeave = entity.AnnualLeave; obj.SickLeave = entity.SickLeave; obj.OtherLeave = entity.OtherLeave; obj.workOffice = entity.workOffice; } else this.ReservationTimes.InsertOnSubmit(entity); this.dataCtx.SubmitChanges(); tran.Commit(); return obj; } catch (Exception ex) { tran.Rollback(); throw ex; } finally { dataCtx.Connection.Close(); } }