/// <summary>
/// 操作 “增加” 或 “修改”时的操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddOrEdit_Click(object sender, EventArgs e)
{
if (CheckValue())
{
try
{
WalkConfigModel model = new WalkConfigModel();
model.EmpId = Convert.ToInt32(cbEmp.SelectedValue);
model.TimeValue = Convert.ToInt32(txtHour.Text) * 3600 + Convert.ToInt32(txtMin.Text) * 60 + Convert.ToInt32(txtSec.Text);
StationHeadModel fmodel = new StationHeadModel();
fmodel.StationAddress = Convert.ToInt32(cbFS.SelectedValue);
fmodel.StationHeadAddress = Convert.ToInt32(cbFSH.SelectedValue);
fmodel.StationHeadAntennaA = rbFA.Checked;
fmodel.StationHeadAntennaB = rbFB.Checked; ;
StationHeadModel mmodel = new StationHeadModel();
mmodel.StationAddress = Convert.ToInt32(cbMS.SelectedValue);
mmodel.StationHeadAddress = Convert.ToInt32(cbMSH.SelectedValue);
mmodel.StationHeadAntennaA = rbMA.Checked;
mmodel.StationHeadAntennaB = rbMB.Checked;
StationHeadModel lmodel = new StationHeadModel();
lmodel.StationAddress = Convert.ToInt32(cbLS.SelectedValue);
lmodel.StationHeadAddress = Convert.ToInt32(cbLSH.SelectedValue);
lmodel.StationHeadAntennaA = rbLA.Checked;
lmodel.StationHeadAntennaB = rbLB.Checked;
model.FirstStationHead = fmodel;
model.MiddleStationHead = mmodel;
model.LastStationHead = lmodel;
if (btnAddOrEdit.CaptionTitle == "增加")
{
int result = bll.InsertWalkConfigInfo(model);
if (result == 1)
{
MessageBox.Show("增加信息成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("增加操作失败,记录可能已存在，不能增加重复记录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else if (btnAddOrEdit.CaptionTitle == "修改")
{
model.WalkConfigId = walkId;
int result = bll.UpdateWalkConfigInfo(model);
if (result == 1)
{
MessageBox.Show("修改信息成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("修改操作失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
catch (Exception ex)
{
MessageBox.Show("操作失败,失败消息:" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private int InitializeUpdate(WalkConfigModel model)
{
return bll.UpdateWalkConfigInfo(model);
}
/// <summary>
/// 添加行走异常配置信息
/// </summary>
/// <returns>返回执行结果行数</returns>
public int InsertWalkConfigInfo(WalkConfigModel model)
{
return dal.InsertWalkConfigInfo(model);
}
/// <summary>
/// 更新行走异常配置信息
/// </summary>
/// <returns>返回执行影响的行数</returns>
public int UpdateWalkConfigInfo(WalkConfigModel model)
{
return dal.UpdateWalkConfigInfo(model);
}
/// <summary>
/// 更新行走异常配置信息
/// </summary>
/// <returns>返回执行影响的行数</returns>
public int UpdateWalkConfigInfo(WalkConfigModel model)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@WalkConfigId", SqlDbType.Int, 1000) ,
new SqlParameter("@EmpID", SqlDbType.Int, 1000) ,
new SqlParameter("@FirstStationAddress", SqlDbType.Int) ,
new SqlParameter("@FirstStationHeadAddress", SqlDbType.Int) ,
new SqlParameter("@FirstStationHeadAntennaA", SqlDbType.Bit) ,
new SqlParameter("@FirstStationHeadAntennaB", SqlDbType.Bit) ,
new SqlParameter("@MiddleStationAddress", SqlDbType.Int, 1000) ,
new SqlParameter("@MiddleStationHeadAddress", SqlDbType.Int, 1000) ,
new SqlParameter("@MiddleStationHeadAntennaA", SqlDbType.Bit) ,
new SqlParameter("@MiddleStationHeadAntennaB", SqlDbType.Bit) ,
new SqlParameter("@LastStationAddress", SqlDbType.Int) ,
new SqlParameter("@LastStationHeadAddress", SqlDbType.Int) ,
new SqlParameter("@LastStationHeadAntennaA", SqlDbType.Bit) ,
new SqlParameter("@LastStationHeadAntennaB", SqlDbType.Bit) ,
new SqlParameter("@TimeValue", SqlDbType.Int)
};
para[0].Value = model.WalkConfigId;
para[1].Value = model.EmpId;
para[2].Value = model.FirstStationHead.StationAddress;
para[3].Value = model.FirstStationHead.StationHeadAddress;
para[4].Value = model.FirstStationHead.StationHeadAntennaA;
para[5].Value = model.FirstStationHead.StationHeadAntennaB;
para[6].Value = model.MiddleStationHead.StationAddress;
para[7].Value = model.MiddleStationHead.StationHeadAddress;
para[8].Value = model.MiddleStationHead.StationHeadAntennaA;
para[9].Value = model.MiddleStationHead.StationHeadAntennaB;
para[10].Value = model.LastStationHead.StationAddress;
para[11].Value = model.LastStationHead.StationHeadAddress;
para[12].Value = model.LastStationHead.StationHeadAntennaA;
para[13].Value = model.LastStationHead.StationHeadAntennaB;
para[14].Value = model.TimeValue;
return help.RunProcedureByInt("UpdateWalkConfigInfo", para, out outStr);
}
