/// <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();
}
