/// <summary> /// 查重方法 /// </summary> /// <returns></returns> private bool btnCheck() { bool rbool = true; try { //定义字段用以保存门岗名称和门岗值 string PositionName = this.txtPosition_Name.Text.Trim(); string PositionValue = this.txtPosition_Value.Text.Trim(); //判断名称是否已存在 Expression <Func <Position, bool> > funviewPosition = n => n.Position_Name == PositionName && n.Position_Name != this.dgvPositionList.SelectedRows[0].Cells["Position_Name"].Value.ToString(); if (PositionDAL.Query(funviewPosition).Count() > 0) { PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "该门岗名称已存在", txtPosition_Name, this); txtPosition_Name.Focus(); rbool = false;; } Expression <Func <Position, bool> > funviewPosition1 = n => n.Position_Value == PositionValue && n.Position_Value != this.dgvPositionList.SelectedRows[0].Cells["Position_Value"].Value.ToString(); if (PositionDAL.Query(funviewPosition1).Count() > 0) { PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "该门岗值已存在", txtPosition_Value, this); txtPosition_Value.Focus(); rbool = false;; } return(rbool); } catch { CommonalityEntity.WriteTextLog("门岗管理 btnCheck()"); rbool = false; } return(rbool); }
/// <summary> /// 在ListControl上更改SelectedValueChanged属性的值时引发的事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cbxMenGangName_SelectedValueChanged(object sender, EventArgs e) { if (this.cbxPositionID.Items.Count > 0) // 门岗编号 { this.cbxPositionID.Items.Clear(); } if (this.cbxPositionValue.Items.Count > 0) // 门岗值 { this.cbxPositionValue.Items.Clear(); } if (this.cbxMenGangName.Text == "") { return; } string PositionName = this.cbxMenGangName.Text; var name = PositionDAL.GetViewPosition(String.Format("select * from Position where Position_Name='{0}'", PositionName)); if (name != null) { foreach (var item in name) { if (item.Position_ID != null) { if (item.Position_Value != null) { cbxPositionID.Items.Add(item.Position_ID); cbxPositionID.SelectedIndex = 0; cbxPositionValue.Items.Add(item.Position_Value); cbxPositionValue.SelectedIndex = 0; } } } } }
private void cPositionButtonEdit_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { foreach (DataRow row in model.dtDetails.Rows) { row["cWhCode"] = model.cWhCode; } if (gridView1.GetFocusedRowCellValue("cWhCode") == null) { throw new Exception("请先选择仓库!"); } var whCode = gridView1.GetFocusedRowCellValue("cWhCode").ToString(); IRefDAL2 dal = new PositionDAL(Information.UserInfo.ConnU8, whCode); RefForm2 frm = new RefForm2(dal); if (frm.ShowDialog() == DialogResult.OK) { var row = gridView1.GetDataRow(gridView1.FocusedRowHandle); row["cPosCode"] = frm.rows[0]["cPosCode"]; row["cPosName"] = frm.rows[0]["cPosName"]; gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "cPosCode", row["cPosCode"]); } }
/// <summary> /// 绑定门岗 /// </summary> public void SelectPositionLoad() { string sql = "Select * from Position"; chkSPositionLED_Position_Id.DataSource = PositionDAL.GetPositionID(sql); chkSPositionLED_Position_Id.ValueMember = "Position_Id"; chkSPositionLED_Position_Id.DisplayMember = "Position_Name"; }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { this.gridView1.CellValueChanged -= gridView1_CellValueChanged; try { if (e.Column.Name == "iQualifyQty") { var hgQty = Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "iQualifyQty")); var qmQty = Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "qmQty")); if (hgQty > qmQty) { throw new Exception("合格数量不能大于报检数量!"); } else { gridView1.SetRowCellValue(e.RowHandle, "iUnQualifyQty", qmQty - hgQty); } } else if (e.Column.Name == "iUnQualifyQty") { var bhgQty = Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "iUnQualifyQty")); var qmQty = Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "qmQty")); if (bhgQty > qmQty) { throw new Exception("不合格数量不能大于报检数量!"); } else { gridView1.SetRowCellValue(e.RowHandle, "iQualifyQty", qmQty - bhgQty); } } else if (e.Column.FieldName == "cPosCode") { if (gridView1.GetFocusedRowCellValue("cWhCode") == DBNull.Value) { gridView1.SetRowCellValue(e.RowHandle, "cPosCode", null); throw new Exception("仓库编码不能为空!"); } var cPosCode = e.Value.ToString(); var cWhCode = gridView1.GetFocusedRowCellValue("cWhCode").ToString(); if (!string.IsNullOrEmpty(cPosCode)) { var cPosName = new PositionDAL(Information.UserInfo.ConnU8, cWhCode).GetName(cPosCode); gridView1.SetRowCellValue(e.RowHandle, "cPosName", cPosName); } } } finally { this.gridView1.CellValueChanged += gridView1_CellValueChanged; } }
/// <summary> /// 绑定门岗 /// </summary> public void PositionLoad() { string sql = "Select Position_Id,Position_Name from Position where Position_State='启动'"; chkPositionLED_Position_Id.DataSource = PositionDAL.GetPositionID(sql); chkPositionLED_Position_Id.ValueMember = "Position_Id"; chkPositionLED_Position_Id.DisplayMember = "Position_Name"; chkSPositionLED_Position_Id.DataSource = PositionDAL.GetPositionID(sql); chkSPositionLED_Position_Id.ValueMember = "Position_Id"; chkSPositionLED_Position_Id.DisplayMember = "Position_Name"; }
/// <summary> /// 删除选中行数据的方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tbtnDelPosition() { try { int j = 0; if (dgvPositionList.SelectedRows.Count > 0)//选中删除 { if (MessageBox.Show("确定要删除吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { //选中数量 int count = dgvPositionList.SelectedRows.Count; string id = ""; //遍历 for (int i = 0; i < count; i++) { int position_id = int.Parse(this.dgvPositionList.SelectedRows[i].Cells["Position_ID"].Value.ToString()); Expression <Func <Position, bool> > funuserinfo = n => n.Position_ID == position_id; string strContent = LinQBaseDao.GetSingle("select Position_Name from Position where Position_ID=" + position_id).ToString(); if (PositionDAL.DeleteToMany(funuserinfo)) { j++; CommonalityEntity.WriteLogData("删除", "删除门岗名称为:" + strContent + " 的信息", common.USERNAME);//添加日志 } } if (j == 0) { MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //重新查询门岗值的最大值 countID = PositionDAL.MaxID("select MAX(Position_Value) from Position"); txtPosition_Value.Text = "0" + (countID + 1); } } } else//没有选中 { MessageBox.Show("请选择要删除的行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch { common.WriteTextLog("门岗管理 tbtnDelPosition()+"); } finally { LogInfoLoad(""); } }
/// <summary> /// 门岗加载事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void PositionFrom_Load(object sender, EventArgs e) { userContext(); btnUpdate.Enabled = false; btnSelect_Click(btnSelect, null); // 调用查询条件执行查询 BindPosition(); BindSearchPosition(); mf = new MainForm(); LoadData(); this.cbxPosition_State.Text = "启动"; this.txtPositionUserID.Text = common.NAME; countID = PositionDAL.MaxID("select MAX(Position_Value) from Position"); txtPosition_Value.Text = "0" + (countID + 1); }
private void RefPosition(object obj, EventArgs e) { if (txtr_warehouse.Tag == null) { MsgBox.ShowInfoMsg("请先选择仓库!"); return; } IRefDAL2 dal = new PositionDAL(Information.UserInfo.ConnU8, txtr_warehouse.Tag.ToString()); RefForm2 frm = new RefForm2(dal); if (frm.ShowDialog() == DialogResult.OK) { (obj as TextBox).Text = frm.rows[0]["cPosName"].ToString(); (obj as TextBox).Tag = frm.rows[0]["cPosCode"].ToString(); } }
/// <summary> /// To EDIT POSITION /// </summary> /// <param name="PositionBOObj"></param> /// <returns></returns> public string EDITPOSITION(PositionBO PositionBOObj) { PositionDAL PositionDAL = new PositionDAL(); //Data pass -to Database Layer try { return(PositionDAL.EDITPOSITION(PositionBOObj)); } catch { throw; } finally { PositionDAL = null; } }
private void RefPosition(object sender, EventArgs e) { #region 货位档案 if (string.IsNullOrEmpty(model.cWhCode)) { MsgBox.ShowInfoMsg("请先选择仓库!"); return; } IRefDAL2 dal = new PositionDAL(Information.UserInfo.ConnU8, model.cWhCode); RefForm2 frm = new RefForm2(dal); if (frm.ShowDialog() == DialogResult.OK) { int handle = gridView1.FocusedRowHandle; gridView1.SetFocusedRowCellValue("cPosCode", frm.rows[0]["cPosCode"]); gridView1.SetFocusedRowCellValue("cPosName", frm.rows[0]["cPosName"]); } #endregion }
/// <summary> /// 绑定门岗名称 /// </summary> private void BindPositionName() { try { string sql = String.Format("select * from Position"); this.cbxMenGangName.DataSource = PositionDAL.GetViewPosition(sql); if (PositionDAL.GetViewPosition(sql).Count() > 0) { this.cbxMenGangName.DisplayMember = "Position_Name"; this.cbxMenGangName.ValueMember = "Position_ID"; cbxMenGangName.SelectedIndex = 0; } } catch { MessageBox.Show("系统设置“门岗”绑定有误,请查看门岗信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }
/// <summary> /// 加载事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DrivewayFrom_Load(object sender, EventArgs e) { try { userContext(); cbodizhima.SelectedIndex = 0; cbmcloseAdd.SelectedIndex = 1; btnUpdate.Enabled = false; btnSelect_Click(btnSelect, null); mf = new MainForm(); tscbxPageSize.SelectedIndex = 1; // LoadData(); BindDriveway(); BindSearchDriveway(); BindPositionName(); BindSearchWarrantState(); // 绑定搜索的通道报修状态 BindPositionType(); BindDrivewayWarrantState(); BindRemarkDriveway(); Bindmengang(); if (iDrivewayPositionID > 0) { // 若门岗管理界面中有选择“门岗”再跳转的,则显示门岗如下 Expression <Func <Position, bool> > funviewinto = n => n.Position_ID == iDrivewayPositionID; foreach (var n in PositionDAL.Query(funviewinto)) { if (n.Position_Name != null) { //门岗名称 this.cbxDriveway_PositionName.Text = n.Position_Name; } } } } catch { MessageBox.Show("加载通道信息有误,请查看与通道相关的信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }
/// <summary> /// 搜索 --绑定门岗 /// </summary> private void BindMenGang1() { try { string sql = "select * from Position where Position_State='启动'"; this.comboxMenGang.DataSource = PositionDAL.GetViewPosition(sql); if (PositionDAL.GetViewPosition(sql).Count() > 0) { this.comboxMenGang.DisplayMember = "Position_Name"; this.comboxMenGang.ValueMember = "Position_ID"; comboxMenGang.SelectedIndex = -1; } else { MessageBox.Show("门岗暂无数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch { MessageBox.Show("摄像头管理“门岗”绑定有误,请查看门岗信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }
private void BindPositionName() { try { string sql = "select * from Position where Position_State='启动'"; this.cbxDriveway_PositionName.DataSource = PositionDAL.GetViewPosition(sql); if (PositionDAL.GetViewPosition(sql).Count() > 0) { this.cbxDriveway_PositionName.DisplayMember = "Position_Name"; this.cbxDriveway_PositionName.ValueMember = "Position_ID"; cbxDriveway_PositionName.SelectedIndex = 0; } else { return; } //在绑定门岗完成后,绑定一个此门岗的最大通道值+1 int drid = int.Parse(cbxDriveway_PositionName.SelectedValue.ToString()); Expression <Func <Driveway, bool> > funuserinfo = p => p.Driveway_Position_ID == drid; DataTable dt = LinQBaseDao.Query("select MAX(Driveway_Value) from Driveway where Driveway_Position_ID=" + drid).Tables[0]; if (dt.Rows.Count > 0) { int num = Convert.ToInt32(dt.Rows[0][0].ToString()); txtDriveway_Value.Text = "0" + (num + 1).ToString(); } boo = true; } catch { CommonalityEntity.WriteTextLog("DrivewayFrom .BindPositionName()"); } }
/// <summary> /// To Obsolete Position /// </summary> /// <param name="PositionID"></param> /// <param name="PositionIsDeleted"></param> /// <returns></returns> public string ObsoletePosition(int PositionID, string PositionIsDeleted) { PositionDAL PositionDALObj = new PositionDAL(); return(PositionDALObj.ObsoletePosition(PositionID, PositionIsDeleted)); }
/// <summary> /// “保存” 按钮的单击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { if (this.txtPosition_Name.Text == "") { PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "门岗名称不能为空!", txtPosition_Name, this); return; } int num = dgvPositionList.Rows.Count; int mgz = Convert.ToInt32(dgvPositionList.Rows[num - 1].Cells["Position_Value"].Value); txtPosition_Value.Text = "0" + (mgz + 1); int count = Convert.ToInt32(LinQBaseDao.GetSingle("select count(0) from Position").ToString()); if (count >= SystemClass.postionCount) { MessageBox.Show(this, "已超出可添加门岗上限!"); return; } if (!btnCheck()) { return; // 去重复 } var Positionadd = new Position { Position_Name = this.txtPosition_Name.Text.Trim(), Position_Value = this.txtPosition_Value.Text.Trim(), Position_State = this.cbxPosition_State.Text, Position_UserId = int.Parse(common.USERID), // 用户编号 Position_Add = this.txtPosition_ADD.Text.Trim(), Position_Phone = this.txtPosition_Phone.Text.Trim(), Position_CreatTime = Convert.ToDateTime(CommonalityEntity.GetServersTime().ToString()), Position_CameraValue = this.txtPosition_CameraValue.Text.Trim(), Position_Remark = this.txtPosition_Remark.Text.Trim() }; if (PositionDAL.InsertOneQCRecord(Positionadd)) { MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); string strContent1 = "门岗名称为:" + this.txtPosition_Name.Text.Trim();; CommonalityEntity.WriteLogData("新增", "新增 " + strContent1 + " 的信息", common.USERNAME);//添加日志); //重新查询门岗值的最大值 countID = PositionDAL.MaxID("select MAX(Position_Value) from Position"); txtPosition_Value.Text = "0" + (countID + 1); } else { MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch { common.WriteTextLog("门岗管理 btnSave_Click()"); } finally { LogInfoLoad(""); Empty(); } }
/// <summary> /// “修改” 按钮的单击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdate_Click(object sender, EventArgs e) { try { if (this.dgvPositionList.SelectedRows.Count > 0)//选中行 { if (dgvPositionList.SelectedRows.Count > 1) { MessageBox.Show("修改只能选中一行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (this.txtPosition_Name.Text == "") { PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "门岗名称不能为空!", txtPosition_Name, this); return; } if (!btnCheck()) { return; // 去重复 } Expression <Func <Position, bool> > p = n => n.Position_ID == int.Parse(this.dgvPositionList.SelectedRows[0].Cells["Position_ID"].Value.ToString()); string id = ""; string strfront = ""; string strContent = ""; Action <Position> ap = s => { strfront = s.Position_Name + "," + s.Position_Value + "," + s.Position_State + "," + s.Position_UserId + "," + s.Position_Add + "," + s.Position_Phone + "," + s.Position_CameraValue + "," + s.Position_Remark; s.Position_Name = this.txtPosition_Name.Text.Trim(); s.Position_Value = this.txtPosition_Value.Text.Trim(); s.Position_State = this.cbxPosition_State.Text; s.Position_UserId = int.Parse(common.USERID); // 用户编号 s.Position_Add = this.txtPosition_ADD.Text.Trim(); s.Position_Phone = this.txtPosition_Phone.Text.Trim(); s.Position_CameraValue = this.txtPosition_CameraValue.Text.Trim(); s.Position_Remark = this.txtPosition_Remark.Text.Trim(); strContent = s.Position_Name + "," + s.Position_Value + "," + s.Position_State + "," + s.Position_UserId + "," + s.Position_Add + "," + s.Position_Phone + "," + s.Position_CameraValue + "," + s.Position_Remark; }; if (PositionDAL.Update(p, ap)) { MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CommonalityEntity.WriteLogData("修改", "更新编号为:" + id + "的门岗信息;修改前:" + strfront + ";修改后:" + strContent, common.USERNAME);//添加日志 Empty(); } else { MessageBox.Show("修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } } catch { common.WriteTextLog("门岗管理 btnUpdate_Click()"); } finally { LogInfoLoad(""); this.btnUpdate.Enabled = false; this.btnSave.Enabled = true; } }
/// <summary> /// 用户双击组件时发生 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvPositionList_DoubleClick(object sender, EventArgs e) { this.btnUpdate.Enabled = true; this.btnSave.Enabled = false; if (this.dgvPositionList.SelectedRows.Count > 0)//选中行 { if (dgvPositionList.SelectedRows.Count > 1) { MessageBox.Show("修改只能选中一行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { //修改的值 int ID = int.Parse(this.dgvPositionList.SelectedRows[0].Cells["Position_ID"].Value.ToString()); Expression <Func <Position, bool> > funviewinto = n => n.Position_ID == ID; foreach (var n in PositionDAL.Query(funviewinto)) { if (n.Position_Name != null) { //门岗名称 this.txtPosition_Name.Text = n.Position_Name; } if (n.Position_Value != null) { // 门岗值 this.txtPosition_Value.Text = n.Position_Value; } //if (n.UserInfo.UserName != null) //{ // // 门岗创建人 // this.txtPositionUserID.Text = n.UserInfo.UserName; //} if (n.Position_State != null) { // 门岗状态 this.cbxPosition_State.Text = n.Position_State; } if (n.Position_Add != null) { // 门岗地址 this.txtPosition_ADD.Text = n.Position_Add; } if (n.Position_Phone != null) { // 门岗电话 this.txtPosition_Phone.Text = n.Position_Phone; } if (n.Position_CameraValue != null) { // 登记拍照摄像头 this.txtPosition_CameraValue.Text = n.Position_CameraValue; } if (n.Position_Remark != null) { // 门岗备注 this.txtPosition_Remark.Text = n.Position_Remark; } break; } } } else { MessageBox.Show("请选择要修改的行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
//Search the Singal Data by passing ID /// <summary> /// To Get Position By Id /// </summary> /// <param name="PositionID"></param> /// <returns></returns> public PositionBO GetPositionById(int PositionID) { PositionDAL PositionDALObj = new PositionDAL(); return(PositionDALObj.GetPositionById(PositionID)); }
/// <summary> /// To Delete Position /// </summary> /// <param name="PositionID"></param> /// <returns></returns> public string DeletePosition(int PositionID) { PositionDAL PositionDALObj = new PositionDAL(); return(PositionDALObj.DeletePosition(PositionID)); }
public override void SetCurrentDal() { CurrentDAL = new PositionDAL(); }
/// <summary> /// To Get All Positions /// </summary> /// <returns></returns> public PositionList GetAllPositions() { PositionDAL PositionDALObj = new PositionDAL(); return(PositionDALObj.GetAllPositions()); }
static PositionBUL() { db = new PositionDAL(); }
public PositionBLL() { this.positionDAL = new PositionDAL(); }