/// <summary>
/// 保存班次对象
/// </summary>
/// <param name="objShiftTimes">班次对象</param>
/// <returns>执行结果</returns>
public int AddShift(ShiftTimes objShiftTimes)
{
string sql = "insert into ShiftTimes values('{0}','{1}','{2}','{3}',{4},{5},{6},{7},{8},{9},{10})";
sql = string.Format(sql, objShiftTimes.ShiftName, objShiftTimes.TimesName1, objShiftTimes.TimesName2, objShiftTimes.TimesName3,
objShiftTimes.Monday, objShiftTimes.Tuesday, objShiftTimes.Wednesday, objShiftTimes.Thursday, objShiftTimes.Friday,
objShiftTimes.Saturday, objShiftTimes.Sunday);
return(SQLHelper.Update(sql));
}
/// <summary>
/// 修改班次对象
/// </summary>
/// <param name="objShift">班次对象</param>
/// <param name="AgoShiftName">原始名称</param>
/// <returns></returns>
public int UpdateShift(ShiftTimes objShift, string AgoShiftName)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("update ShiftTimes set ShiftName ='{0}',TimesName1 ='{1}',TimesName2 ='{2}',TimesName3 ='{3}',");
sqlBuilder.Append("Monday={4},Tuesday={5},Wednesday={6},Thursday={7},Friday={8},Saturday={9},Sunday={10}");
sqlBuilder.Append(" where ShiftName='{11}'");
string sql = string.Format(sqlBuilder.ToString(), objShift.ShiftName, objShift.TimesName1, objShift.TimesName2,
objShift.TimesName3, objShift.Monday, objShift.Tuesday, objShift.Wednesday, objShift.Thursday, objShift.Friday,
objShift.Saturday, objShift.Sunday, AgoShiftName);
return(SQLHelper.Update(sql));
}
//修改班次
private void btnUpdate_Click(object sender, EventArgs e)
{
//验证
if (objShiftTimesService.IsShiftNameExisted(txtShiftName.Text.Trim()))
{
MessageBox.Show("班次名称重复！");
txtShiftName.Focus();
txtShiftName.SelectAll();
return;
}
else
{
int index = dgvShift.CurrentRow.Index;
//获取原始班次名
string AgoShiftName = dgvShift.Rows[index].Cells[0].Value.ToString();
ShiftTimes objShiftTimes = new ShiftTimes()
{
ShiftName = txtShiftName.Text.Trim(),
TimesName1 = cboTimes1.Text.Trim(),
TimesName2 = cboTimes2.Text.Trim(),
TimesName3 = cboTimes3.Text.Trim(),
Monday = Convert.ToInt32(chkMonday.Checked),
Tuesday = Convert.ToInt32(chkTuesday.Checked),
Wednesday = Convert.ToInt32(chkWednesday.Checked),
Thursday = Convert.ToInt32(chkThursday.Checked),
Friday = Convert.ToInt32(chkFriday.Checked),
Saturday = Convert.ToInt32(chkSaturday.Checked),
Sunday = Convert.ToInt32(chkSunday.Checked),
};
//插入数据
objShiftTimesService.UpdateShift(objShiftTimes, AgoShiftName);
//更新DGV
//获取数据
DataTable dtShift = objShiftTimesService.GetShiftTimesDataSet().Tables[0];
//移除ID列
dtShift.Columns.Remove("ShiftId");
//设置数据源
dgvShift.DataSource = dtShift;
}
}
//添加班次
private void btnShiftAdd_Click(object sender, EventArgs e)
{
//验证输入
if (txtShiftName.Text.Trim() == "")
{
MessageBox.Show("班次名称不能为空！");
txtShiftName.Focus();
txtShiftName.SelectAll();
return;
}
if (cboTimes1.Text.Trim() == "")
{
MessageBox.Show("时段名称1不能为空！");
cboTimes1.Focus();
cboTimes1.SelectAll();
return;
}
if (cboTimes2.Text.Trim() == "")
{
MessageBox.Show("时段2名称不能为空！");
cboTimes2.Focus();
cboTimes2.SelectAll();
return;
}
if (objShiftTimesService.IsShiftNameExisted(txtShiftName.Text.Trim()))
{
MessageBox.Show("班次名称重复！");
txtShiftName.Focus();
txtShiftName.SelectAll();
return;
}
//封装对象
ShiftTimes objShiftTimes = new ShiftTimes()
{
ShiftName = txtShiftName.Text.Trim(),
TimesName1 = cboTimes1.Text.Trim(),
TimesName2 = cboTimes2.Text.Trim(),
TimesName3 = cboTimes3.Text.Trim(),
Monday = Convert.ToInt32(chkMonday.Checked),
Tuesday = Convert.ToInt32(chkTuesday.Checked),
Wednesday = Convert.ToInt32(chkWednesday.Checked),
Thursday = Convert.ToInt32(chkThursday.Checked),
Friday = Convert.ToInt32(chkFriday.Checked),
Saturday = Convert.ToInt32(chkSaturday.Checked),
Sunday = Convert.ToInt32(chkSunday.Checked)
};
//插入数据
objShiftTimesService.AddShift(objShiftTimes);
//刷新DGV显示数据
//获取数据
DataTable dtShift = objShiftTimesService.GetShiftTimesDataSet().Tables[0];
//移除ID列
dtShift.Columns.Remove("ShiftId");
//设置数据源
dgvShift.DataSource = dtShift;
}
