/// <summary> /// 添加行走异常配置信息 /// </summary> /// <returns>返回执行结果行数</returns> public int InsertWalkConfigInfo(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[0].Value = model.EmpId; para[1].Value = model.FirstStationHead.StationAddress; para[2].Value = model.FirstStationHead.StationHeadAddress; para[3].Value = model.FirstStationHead.StationHeadAntennaA; para[4].Value = model.FirstStationHead.StationHeadAntennaB; para[5].Value = model.MiddleStationHead.StationAddress; para[6].Value = model.MiddleStationHead.StationHeadAddress; para[7].Value = model.MiddleStationHead.StationHeadAntennaA; para[8].Value = model.MiddleStationHead.StationHeadAntennaB; para[9].Value = model.LastStationHead.StationAddress; para[10].Value = model.LastStationHead.StationHeadAddress; para[11].Value = model.LastStationHead.StationHeadAntennaA; para[12].Value = model.LastStationHead.StationHeadAntennaB; para[13].Value = model.TimeValue; return(help.RunProcedureByInt("InsertWalkConfigInfo", para, out outStr)); }
/// <summary> /// 更新行走异常配置信息 /// </summary> /// <returns>返回执行影响的行数</returns> public int UpdateWalkConfigInfo(WalkConfigModel model) { return(dal.UpdateWalkConfigInfo(model)); }
/// <summary> /// 添加行走异常配置信息 /// </summary> /// <returns>返回执行结果行数</returns> public int InsertWalkConfigInfo(WalkConfigModel model) { return(dal.InsertWalkConfigInfo(model)); }
/// <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)); }