private void ModifyUser_Click()
{
try
{
Expression <Func <RoleInfo, bool> > p = n => n.Role_Id == Convert.ToInt32(lblId.Text);
Action <RoleInfo> ap = n =>
{
n.Role_Name = txtRoleName.Text.Trim();
n.Role_State = comboxState.Text.Trim();
n.Role_Remark = txtRemark.Text.Trim();
};
if (!RoleInfoAdd.UpdateOneRoleInfo(p, ap))//用户是否修改失败
{
MessageBox.Show(" 修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
string Log_Content = String.Format("用户名称：{0} ", lblId.Text.Trim());
CommonalityEntity.WriteLogData("修改", "修改" + Log_Content + "的信息", CommonalityEntity.USERNAME);
}
}
catch
{
CommonalityEntity.WriteTextLog("用户管理 bntUpUser_Click()");
}
finally
{
page = new PageControl();
LoadData();
userContext();
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (NullHandleMethod())
{
if (intCarTypeID > 0)
{
OthCarAttribute("", cbxCarAttribute.Text.Trim());
ssy = 0;
Expression <Func <CarType, bool> > funCartype = n => n.CarType_ID == intCarTypeID;
Action <CarType> action = n =>
{
n.CarType_UserId = CommonalityEntity.GetInt(CommonalityEntity.USERID);
n.CarType_Name = txt_CarTypeNmae.Text.Trim();
n.CarType_Content = txt_CarTypeContent.Text.Trim();
n.CarType_State = cob_CarTypeState.Text.Trim();
n.CarType_Property = cbxCarAttribute.Text.Trim();
n.CarType_Remark = txt_CarTypeRemarks.Text.Trim();
n.CarType_Validity = cob_CarTypeEffective.Text.Trim();
n.CarType_ValidityTemporary = cob_CarTypeTemporary.Text.Trim();
n.CarType_OtherProperty = butname.Trim();
if (!string.IsNullOrEmpty(txt_CarTemporaryValue.Text.Trim()))
{
n.CarType_ValidityValue = CommonalityEntity.GetInt(txt_CarTemporaryValue.Text.Trim());
}
if (!string.IsNullOrEmpty(txtInOutTime.Text.Trim()))
{
n.CarType_InOutTime = CommonalityEntity.GetInt(txtInOutTime.Text.Trim());
}
n.CarType_Value = txt_CarTypeValue.Text.Trim();
n.CarType_DriSName = cmbDriSta.Text;
n.CarType_BusType = txtBusType.Text.Trim();
};
if ((CarTypeDAL.Update(funCartype, action)))
{
//查出通行策略ID、通道ID
updateDri(cmbDriSta.Text);
btn_Empty_Click(btn_Empty, null); //调用清空按钮事件
CommonalityEntity.WriteLogData("修改", "车辆类型：" + txt_CarTypeNmae.Text.Trim(), CommonalityEntity.USERNAME); //添加操作日志
btn_Empty.Text = "清 空";
MessageBox.Show(this, "修改成功");
}
}
}
}
catch
{
CommonalityEntity.WriteTextLog("CarTypeForm.btnUpdate_Click()");
MessageBox.Show(this, "修改失败");
}
finally
{
btn_Save.Enabled = true;
btnUpdate.Enabled = false;
BingMethod();
}
}
/// <summary>
/// 修改事件
/// </summary>
private void btnUpdate_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtRoleName.Text))
{
MessageBox.Show(this, "角色名称不能为空！");
return;
}
if (comboxState.SelectedIndex < 0)
{
MessageBox.Show(this, "请选择状态！");
return;
}
string name = txtRoleName.Text; //姓名
string remark = txtRemark.Text; //备注
string state = comboxState.SelectedItem.ToString(); //状态
string id = lblId.Text; //id
int j = 0;
Action <RoleInfo> action = n =>
{
n.Role_Name = name;
n.Role_Remark = remark;
n.Role_State = state;
n.Role_Permission = "";
};
try
{
Expression <Func <RoleInfo, bool> > funroleinfo = n => n.Role_Id.ToString() == id;
if (!RoleInfoAdd.UpdateOneRoleInfo(funroleinfo, action))//角色是否修改失败
{
j++;
}
if (j == 0)
{
MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
string Log_Content = String.Format("角色名称：{0}", name);
CommonalityEntity.WriteLogData("修改", "修改" + Log_Content + "的信息", CommonalityEntity.USERNAME);
}
else
{
MessageBox.Show(" 修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch
{
CommonalityEntity.WriteTextLog("角色管理 btnUpdate_Click");
}
finally
{
page = new PageControl();
LoadData();
userContext();
lblId.Text = "";
txtRemark.Text = "";
txtRoleName.Text = "";
comboxState.Text = "";
}
}
/// <summary>
/// 删除选中行数据的方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tbtnDelDictionary()
{
try
{
string str = "";
string strdel = "";
if (this.dgvDictioanry.SelectedRows.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
int count = dgvDictioanry.SelectedRows.Count;
//string id = "";
//遍历
for (int i = 0; i < count; i++)
{
int dictionary_id = int.Parse(this.dgvDictioanry.SelectedRows[i].Cells["Dictionary_ID"].Value.ToString());
Expression <Func <Dictionary, bool> > funuserinfo = n => n.Dictionary_ID == dictionary_id;
DataTable dt = LinQBaseDao.Query("select Dictionary_Name,Dictionary_IsSystem from Dictionary where Dictionary_ID=" + dictionary_id).Tables[0];
string strname = dt.Rows[0]["Dictionary_Name"].ToString();
if (Convert.ToBoolean(dt.Rows[0]["Dictionary_IsSystem"].ToString()))
{
str += strname + ",";
continue;
}
if (DictionaryDAL.DeleteToMany(funuserinfo))
{
strdel += strname + ",";
CommonalityEntity.WriteLogData("删除", "删除字典名称为：" + strname + " 的信息", CommonalityEntity.USERNAME);//添加日志
}
}
if (!string.IsNullOrEmpty(str))
{
str = "字典名称:" + str + "为系统数据，不能删除\r\n";
}
if (!string.IsNullOrEmpty(strdel))
{
strdel = "字典名称：" + strdel + "删除成功";
}
ShowToolTip(ToolTipIcon.Info, "提示", str + strdel, txtDictionary_Remark, this);
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("字典管理 tbtnDelDictionary() 异常！+");
}
finally
{
LogInfoLoad("");
}
}
private void btnEditPwd_Click(object sender, EventArgs e)
{
if (txtPwd1.Text.Trim().ToLower() != txtpwd2.Text.Trim().ToLower())
{
mf.ShowToolTip(ToolTipIcon.Info, "提示", "新密码不一致!", txtPwd1, this);
txtPwd1.Focus();
return;
}
if (string.IsNullOrEmpty(txtpwd2.Text.Trim()))
{
mf.ShowToolTip(ToolTipIcon.Info, "提示", "新密码不能为空", txtpwd2, this);
txtOlePwd.Focus();
return;
}
if (string.IsNullOrEmpty(txtOlePwd.Text.Trim()))
{
mf.ShowToolTip(ToolTipIcon.Info, "提示", "旧密码不能为空", txtOlePwd, this);
txtOlePwd.Focus();
return;
}
if (LinQBaseDao.Query("select * from UserInfo where userid=" + CommonalityEntity.USERID + "").Tables[0].Rows.Count <= 0)
{
mf.ShowToolTip(ToolTipIcon.Info, "提示", "登录信息有误，请重新登录！", txtOlePwd, this);
GC.Collect();
Application.ExitThread();
Application.Exit();
Process.GetCurrentProcess().Kill();
System.Environment.Exit(System.Environment.ExitCode);
Application.ExitThread();
return;
}
if ((LinQBaseDao.Query("select * from UserInfo where userid=" + CommonalityEntity.USERID + " and UserLoginId='" + CommonalityEntity.USERNAME + "' and UserLoginPwd='" + CommonalityEntity.EncryptDES(txtOlePwd.Text.Trim()) + "'").Tables[0].Rows.Count <= 0))
{
mf.ShowToolTip(ToolTipIcon.Info, "提示", "旧密码有误！", txtOlePwd, this);
txtOlePwd.Focus();
return;
}
Action <UserInfo> action = n =>
{
n.UserLoginPwd = CommonalityEntity.EncryptDES(txtpwd2.Text.Trim());
};
Expression <Func <UserInfo, bool> > funuser = n => n.UserId == CommonalityEntity.USERID;
if (UserInfoDAL.Update(funuser, action) == true)//角色是否修改失败
{
MessageBox.Show("密码修改成功！");
txtOlePwd.Text = "";
txtPwd1.Text = "";
txtpwd2.Text = "";
CommonalityEntity.WriteLogData("修改", "用户" + CommonalityEntity.USERNAME + "修改密码", CommonalityEntity.USERNAME);//添加日志
}
}
/// <summary>
/// 删除选中行数据的方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tbtnDelICCardType()
{
try
{
int j = 0;
if (this.dgvICCardType.SelectedRows.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
int count = dgvICCardType.SelectedRows.Count;
string id = "";
//遍历
for (int i = 0; i < count; i++)
{
int iccardtype_id = int.Parse(this.dgvICCardType.SelectedRows[i].Cells["ICCardType_ID"].Value.ToString());
Expression <Func <ICCardType, bool> > funuserinfo = n => n.ICCardType_ID == iccardtype_id;
string strContent = LinQBaseDao.Query("select ICCardType_Name from ICCardType where ICCardType_ID=" + iccardtype_id).Tables[0].Rows[0][0].ToString();
DataTable dt = LinQBaseDao.Query("select * from ICCard where ICCard_ICCardType_ID =" + iccardtype_id).Tables[0];
if (dt.Rows.Count > 0)
{
MessageBox.Show(strContent + "存在关联信息不能删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
break;
}
if (ICCardTypeDAL.DeleteToMany(funuserinfo))
{
j++;
CommonalityEntity.WriteLogData("删除", "删除IC卡类型名称为：" + strContent + "的信息", CommonalityEntity.USERNAME);//添加操作日志
}
}
if (j == count)
{
MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("IC卡类型信息管理 tbtnDelICCardType() 异常！+");
}
finally
{
LogInfoLoad("");
}
}
/// <summary>
/// 修改
/// </summary>
private void btn_Update_Click(object sender, EventArgs e)
{
try
{
if (TV_MenuInfo.SelectedNode.Tag.ToString() != null)
{
int menuID = Convert.ToInt32(TV_MenuInfo.SelectedNode.Tag.ToString());
if (menuID <= 0)
{
MessageBox.Show("请先修改的节点！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//1.修改数据不会修改Menu_MenuType_ID
//修改MenuInfo信息
Action <MenuInfo> action = n =>
{
n.Menu_ControlType = cob_Menu_ControlType.SelectedValue.ToString(); //控件类型
if (cob_Menu_ControlType.SelectedText.ToString() == "一级菜单")
{
n.Menu_OtherID = 0;
}
n.Menu_ControlText = txt_Menu_ControlText.Text.Trim();
n.Menu_ControlName = txt_Menu_ControlName.Text.ToString();
n.Menu_FromName = txt_Menu_FromName.Text.ToString();
n.Menu_FromText = txt_Menu_FromText.Text;
n.Menu_Enabled = radioButtons.Checked == true ? true : false; //控件是否启用
n.Menu_Visible = radioButton2.Checked == true ? true : false; //控件是否是否可见
};
Expression <Func <MenuInfo, bool> > menuinfo = n => n.Menu_ID.ToString() == menuID.ToString();
if (MenuInfoDAL.Update(menuinfo, action) == true)//角色是否修改失败
{
MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
clean(this);
}
else
{
MessageBox.Show(" 修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
string Log_Contents = String.Format("角色名称：{0}", Name);
CommonalityEntity.WriteLogData("修改", Log_Contents, CommonalityEntity.USERNAME);//添加日志}
}
}
catch
{
CommonalityEntity.WriteTextLog("菜单管理MenuInfoManager btnUpdate_Click");
}
finally
{
PageControl page = new PageControl();
TV_MenuInfo.Nodes.Clear();
InitMenu();
}
}
/// <summary>
/// 单击保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtWeighInfo_Name.Text.Trim()))
{
MessageBox.Show("请输入地磅房名称");
return;
}
if (string.IsNullOrEmpty(cobWeighInfo_State.Text.Trim()))
{
MessageBox.Show("请选择启动状态");
return;
}
if (txtRemark.Text.Trim().Length > 200)
{
MessageBox.Show("超过最大字符，限制200字内");
return;
}
//查重
DataSet ds = LinQBaseDao.Query("select COUNT(1) from WeighInfo where WeighInfo_Name='" + txtWeighInfo_Name.Text.Trim() + "'");
if (Convert.ToInt32(ds.Tables[0].Rows[0][0]) > 0)
{
MessageBox.Show("该磅房名称已存在");
return;
}
//进行新增操作
WeighInfo info = new WeighInfo();
info.WeighInfo_Name = txtWeighInfo_Name.Text.Trim();
info.WeighInfo_Phone = txtWeighInfo_Phone.Text.Trim();
info.WeighInfo_State = cobWeighInfo_State.Text.Trim();
info.WeighInfo_CreateTime = CommonalityEntity.GetServersTime();
info.WeighInfo_Remark = txtRemark.Text.Trim();
if (WeighInfoDAL.InsertOneCamera(info))
{
MessageBox.Show("保存成功");
CommonalityEntity.WriteLogData("新增", "新增过磅基础信息：" + txtWeighInfo_Name.Text.Trim(), CommonalityEntity.USERNAME);//添加操作日志
Empty();
}
else
{
MessageBox.Show("保存失败");
}
}
catch
{
Console.WriteLine("");
}
finally
{
LogInfoLoad("");
}
}
/// <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 tbtnDelPosition()
{
try
{
int j = 0;
if (dgvDrivewayList.SelectedRows.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
int count = dgvDrivewayList.SelectedRows.Count;
string id = "";
//遍历
for (int i = 0; i < count; i++)
{
//-----------------------------------------------------------------------------------------
int drid = int.Parse(this.dgvDrivewayList.SelectedRows[i].Cells["Driveway_ID"].Value.ToString());
Expression <Func <Driveway, bool> > funuserinfo = n => n.Driveway_ID == drid;
string strContent = LinQBaseDao.Query("Select (Position_Name+Driveway_Name) as DrivewayPosition from View_DrivewayPosition where Driveway_ID=" + drid).Tables[0].Rows[0][0].ToString();
if (DrivewayDAL.DeleteToMany(funuserinfo))
{
j++;
CommonalityEntity.WriteLogData("删除", "删除通道名称为：" + strContent + " 的信息", common.USERNAME);//添加日志
}
}
if (j == count)
{
MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//重新绑定通道值
tongdaoZ();
}
else
{
MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("通道管理 tbtnDelPosition()+");
}
finally
{
LogInfoLoad("");
}
}
/// <summary>
///删除用户信息
/// </summary>
private void tbtnDelUser_delete()
{
try
{
int j = 0;
UserIDSearch = lvwUserList.SelectedRows.Count;
if (UserIDSearch > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
//遍历
for (int i = 0; i < UserIDSearch; i++)
{
Expression <Func <RoleInfo, bool> > funuserinfo = n => n.Role_Id == Convert.ToInt32(lvwUserList.SelectedRows[i].Cells["Role_Id"].Value);;
if (!RoleInfoAdd.DeleteToMany(funuserinfo))
{
j++;
}
else
{
CommonalityEntity.WriteLogData("删除", "删除角色名称为：" + lvwUserList.SelectedRows[i].Cells["Role_Name"].Value + "的信息", CommonalityEntity.USERNAME);
}
}
if (j == 0)
{
MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch
{
CommonalityEntity.WriteTextLog("用户管理 tbtnDelUser_delete()+");
}
finally
{
page = new PageControl();
//page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString();
LoadData();//更新
}
}
/// <summary>
/// 删除按钮双击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_delete_Click(object sender, EventArgs e)
{
try
{
string strmessagebox = "";
string strlog = "";
if (btn_delete.Enabled)
{
btn_delete.Enabled = false;
}
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (JudgeCarTypeUseMethod())//判断要删除的管控信息是否正在使用
{
Expression <Func <ControlInfo, bool> > fun = n => list.Contains(common.GetInt(n.ControlInfo_ID));
if (ControlInfoDAL.DeleteToMany(fun))
{
strmessagebox = "成功删除管控信息";
list.Clear();
strlog = String.Format("删除管控信息：{0}", strControlInfo_Name);
CommonalityEntity.WriteLogData("删除", strlog, CommonalityEntity.USERNAME);
}
else
{
strmessagebox = "删除管控信息失败";
}
}
else
{
strmessagebox = "该管控信息正在使用不能删除";
}
}
if (strmessagebox != "")
{
MessageBox.Show(strmessagebox, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch
{
CommonalityEntity.WriteTextLog("ControlInfoForm.btn_delete_Click()");
}
finally
{
btn_delete.Enabled = true;
InitMenu();//更新
}
}
/// <summary>
/// 保存事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (NullHandleMethod())
{
OthCarAttribute("", cbxCarAttribute.Text.Trim());
ssy = 0;
CarType ct = new CarType();
ct.CarType_UserId = CommonalityEntity.GetInt(CommonalityEntity.USERID);
ct.CarType_Name = txt_CarTypeNmae.Text.Trim();
ct.CarType_Content = txt_CarTypeContent.Text.Trim();
ct.CarType_State = cob_CarTypeState.Text.Trim();
ct.CarType_Property = cbxCarAttribute.Text.Trim();
ct.CarType_Remark = txt_CarTypeRemarks.Text.Trim();
ct.CarType_Validity = cob_CarTypeEffective.Text.Trim();
ct.CarType_ValidityTemporary = cob_CarTypeTemporary.Text.Trim();
ct.CarType_OtherProperty = butname.Trim();
if (!string.IsNullOrEmpty(txtInOutTime.Text.Trim()))
{
ct.CarType_InOutTime = CommonalityEntity.GetInt(txtInOutTime.Text.Trim());
}
if (!string.IsNullOrEmpty(txt_CarTemporaryValue.Text.Trim()))
{
ct.CarType_ValidityValue = CommonalityEntity.GetInt(txt_CarTemporaryValue.Text.Trim());
}
ct.CarType_Value = txt_CarTypeValue.Text.Trim();
ct.CarType_CreatTime = CommonalityEntity.GetServersTime();
ct.CarType_UserId = CommonalityEntity.USERID;
ct.CarType_DriSName = cmbDriSta.Text;
ct.CarType_BusType = txtBusType.Text.Trim();
if ((CarTypeDAL.InsertOneQCRecord(ct)))
{
btn_Empty_Click(btn_Empty, null); //调用清空按钮事件
CommonalityEntity.WriteLogData("新增", "新增车辆类型：" + txt_CarTypeNmae.Text.Trim(), CommonalityEntity.USERNAME); //添加操作日志
MessageBox.Show(this, "添加成功");
}
}
}
catch
{
CommonalityEntity.WriteTextLog("CarTypeForm.JudgeCarTypeUseMethod()");
MessageBox.Show(this, "添加失败");
}
finally
{
BingMethod();
}
}
int LowerID; // 定义一个下级编号的变量
/// <summary>
/// “保存” 按钮的单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (this.txtCarAttribute_Name.Text == "")
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "车辆属性名称不能为空！", txtCarAttribute_Name, this);
return;
}
if (this.comboxCarAttribute_HeightID.Text != "")
{
LowerID = int.Parse(this.comboxCarAttribute_HeightID.SelectedValue.ToString());
}
else
{
LowerID = 0;
}
if (!btnCheck())
{
return; // 去重复
}
var CarAttributeadd = new CarAttribute
{
CarAttribute_Name = this.txtCarAttribute_Name.Text.Trim(),
CarAttribute_State = this.cbxCarAttribute_State.Text,
CarAttribute_HeightID = LowerID
};
if (CarAttributeDAL.InsertOneCarAttribute(CarAttributeadd))
{
MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
string strContent1 = "车辆属性名称为：" + this.txtCarAttribute_Name.Text.Trim();;
CommonalityEntity.WriteLogData("添加", strContent1, CommonalityEntity.USERNAME);//添加操作日志
}
catch
{
CommonalityEntity.WriteTextLog("车辆属性管理 btnSave_Click()");
}
finally
{
LogInfoLoad("");
BindHeightIDAttribute();
Empty(); // 调用清空的方法
}
}
/// <summary>
///删除选中数据信息的方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tslDelCarAttribute()
{
try
{
int j = 0;
if (dgvCarAttribute.SelectedRows.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
int count = dgvCarAttribute.SelectedRows.Count;
string id = "";
//遍历
for (int i = 0; i < count; i++)
{
Expression <Func <CarAttribute, bool> > funuserinfo = n => n.CarAttribute_ID == int.Parse(this.dgvCarAttribute.SelectedRows[i].Cells["CarAttribute_ID"].Value.ToString());
if (!CarAttributeDAL.DeleteToMany(funuserinfo))
{
j++;
}
}
if (j == 0)
{
MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindHeightIDAttribute(); // 刷新绑定上级编号
}
else
{
MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
string strContent = "车辆属性编号为：" + this.dgvCarAttribute.SelectedRows[0].Cells["CarAttribute_ID"].Value.ToString();
CommonalityEntity.WriteLogData("删除", strContent, CommonalityEntity.USERNAME);//添加操作日志
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("车辆属性管理 tslDelCarAttribute()+");
}
finally
{
LogInfoLoad("");
}
}
/// <summary>
///删除选中数据信息的方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tslDelCamera()
{
try
{
int j = 0;
if (dgvCamera.SelectedRows.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
int count = dgvCamera.SelectedRows.Count;
string id = "";
//遍历
for (int i = 0; i < count; i++)
{
int cameraid = int.Parse(this.dgvCamera.SelectedRows[i].Cells["Camera_ID"].Value.ToString());
Expression <Func <Camera, bool> > funuserinfo = n => n.Camera_ID == cameraid;
string strContent = LinQBaseDao.Query("select Camera_Name from Camera where Camera_ID=" + cameraid).Tables[0].Rows[0][0].ToString();
if (CameraDAL.DeleteToMany(funuserinfo))
{
j++;
CommonalityEntity.WriteLogData("删除", "删除摄像头名称为：" + strContent + "的信息", CommonalityEntity.USERNAME);//添加操作日志
}
}
if (j == count)
{
MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("摄像头管理 tslDelCamera()+");
}
finally
{
LogInfoLoad("");
}
}
/// <summary>
/// 删除事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsbtnDel_Click()
{
try
{
int j = 0;
if (gdvUnLoadCarMange.SelectedRows.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
int count = gdvUnLoadCarMange.SelectedRows.Count;
string id = "";
//遍历
for (int i = 0; i < count; i++)
{
int busid = int.Parse(this.gdvUnLoadCarMange.SelectedRows[i].Cells["BusinessRecord_ID"].Value.ToString());
Expression <Func <BusinessRecord, bool> > funuserinfo = n => n.BusinessRecord_ID == busid;
string strContent = LinQBaseDao.GetSingle("select smallTicket_Serialnumber from View_BusinessRecord_CarInfo where BusinessRecord_ID=" + busid).ToString();
if (BusinessRecordDAL.DeleteToMany(funuserinfo))
{
j++;
CommonalityEntity.WriteLogData("删除", "删除车牌号为：" + strContent + "，流水号为：" + strContent + "的过磅信息", CommonalityEntity.USERNAME);//添加操作日志
}
}
if (j == count)
{
MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("卸货点管理 tsbtnDel_Click()+" + "".ToString());
}
finally
{
LogInfoLoad("");
}
}
private void btnAdd_Click()
{
try
{
if (cmbUserState.SelectedItem == null)
{
MessageBox.Show("请选择状态！");
return;
}
int j = 0;
int rint = 0;
if (!btnCheck())
{
return;
}
var useradd = new UserInfo
{
UserLoginId = txtUserLoginID.Text.Trim(), //登陆ID
UserLoginPwd = CommonalityEntity.EncryptDES(txtPassword.Text.Trim()), //登陆密码 加密
UserName = txtName.Text.Trim(), //姓名
UserPhone = txtPhone.Text.Trim(), //电话
UserAddress = txtAddress.Text.Trim(), //地址
UserCreateTime = DateTime.Now, //创建时间
UserCreateName = CommonalityEntity.USERNAME, //创建人
UserRemark = txtRemark.Text.Trim(), //备注信息
UserSate = cmbUserState.SelectedItem.ToString(),
UserRoleID = Convert.ToInt32(cmbRoleUser.SelectedValue),
};
if (UserInfoDAL.InsertOneQCRecord(useradd, out rint))
{
MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
string Log_Content = String.Format("用户名称：{0} ", txtUserLoginID.Text.Trim());
CommonalityEntity.WriteLogData("新增", "新增" + Log_Content + "的权限", CommonalityEntity.USERNAME);//添加日志
}
catch
{
CommonalityEntity.WriteTextLog("用户管理 btnAdd_Click()" + "".ToString());
MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
page = new PageControl();
//page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString();
LoadData();
}
}
/// <summary>
/// 删除选中数据信息的方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tslDelBusinessType()
{
try
{
int j = 0;
if (this.dgvBusinessType.SelectedRows.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
int count = dgvBusinessType.SelectedRows.Count;
string id = "";
//遍历
for (int i = 0; i < count; i++)
{
Expression <Func <BusinessType, bool> > funuserinfo = n => n.BusinessType_ID == int.Parse(this.dgvBusinessType.SelectedRows[i].Cells["BusinessType_ID"].Value.ToString());
if (BusinessTypeDAL.DeleteToMany(funuserinfo))
{
j++;
string strContent = "业务类别编号为：" + this.dgvBusinessType.SelectedRows[0].Cells["BusinessType_ID"].Value.ToString();
CommonalityEntity.WriteLogData("删除", "删除 " + strContent + " 的信息", common.USERNAME);//添加日志
}
}
}
if (j != 0)
{
MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception err)
{
CommonalityEntity.WriteTextLog("业务类别管理 tslDelBusinessType()+");
}
finally
{
LogInfoLoad("");
}
}
/// <summary>
/// 保存过磅信息
/// </summary>
/// <param name="carinoutid">车辆通行总记录ID</param>
/// <param name="content">送货车辆EBELN(PO号)、成品车辆WTD_ID（委托单）、三废车辆VBELN(交货单号)</param>
/// <param name="type">业务类型(进门地磅、出门地磅、装货第一次过磅、卸货第一次过磅、装货第二次过磅、卸货第二次过磅)</param>
/// <param name="wie">过磅重量</param>
private void save(string carinoutid, string content, string type, string wie)
{
BusinessRecord busin = new BusinessRecord();
busin.BusinessRecord_CarInOutRecord_ID = Convert.ToInt32(carinoutid);
busin.BusinessRecord_Content = content;
busin.BusinessRecord_State = "启动";
busin.BusinessRecord_Type = type;
busin.BusinessRecord_Weight = Convert.ToDouble(wie);
busin.BusinessRecord_WeightTime = CommonalityEntity.GetServersTime();
busin.BusinessRecord_WeightPerson = CommonalityEntity.USERNAME;
if (LinQBaseDao.InsertOne <BusinessRecord>(new DCCarManagementDataContext(), busin))
{
CommonalityEntity.WriteLogData("新增", "记录IC卡(小票)号为：" + txtSerialnumber.Text.Trim() + "的" + type + "信息", CommonalityEntity.USERNAME);//添加操作日志
}
}
/// <summary>
/// 注销排队车辆
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCancellation_Click(object sender, EventArgs e)
{
if (this.lvwUserList.SelectedRows.Count <= 0)
{
MessageBox.Show("请选择要注销排队的车辆信息");
return;
}
DialogResult dr = MessageBox.Show("是否注销" + this.lvwUserList.SelectedRows[0].Cells["QueueCarNumber"].Value.ToString(), "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
//得到排队信息表编号，修改排队状态
LinQBaseDao.Query("update SortNumberInfo set SortNumberInfo_TongXing='已注销' where SortNumberInfo_ID=" + this.lvwUserList.SelectedRows[0].Cells["sortNumberInfo_ID"].Value.ToString());
CommonalityEntity.WriteLogData("修改", "注销了排队车辆:" + this.lvwUserList.SelectedRows[0].Cells["QueueCarNumber"].Value.ToString(), CommonalityEntity.USERNAME);//添加操作日志
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (this.lvwUserList.SelectedRows.Count <= 0)
{
MessageBox.Show("请选择要删除的项！");
return;
}
if (this.lvwUserList.SelectedRows[0].Cells["PositionSMS_ID"].Value.ToString() == "")
{
MessageBox.Show("请选择要删除的项！");
return;
}
if (this.lvwUserList.SelectedRows[0].Cells["PositionSMS_State"].Value.ToString() == "启动")
{
MessageBox.Show("启用状态的打印设置不能删除！");
return;
}
DialogResult dlgResult = MessageBox.Show("确定删除选中的数据?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlgResult == DialogResult.Cancel)
{
return;
}
//删除条件
int smsid = int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionSMS_ID"].Value.ToString());
Expression <Func <PositionSMS, bool> > fun = n => n.PositionSMS_ID == smsid;
if (PositionSMSDAL.DeletePositionSMS(fun))
{
MessageBox.Show("删除成功");
CommonalityEntity.WriteLogData("删除", "删除短信编号为： " + smsid + "的信息", CommonalityEntity.USERNAME);//添加操作日志
}
else
{
MessageBox.Show("删除失败！");
}
}
catch
{
CommonalityEntity.WriteTextLog("SMSSetForm btnDelete_Click()" + "");
}
finally
{
GetGriddataviewLoad("");//加载
Cler();
}
}
/// <summary>
/// “保存” 按钮的单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (this.txtBusinessType_Name.Text == "")
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "业务类别名称不能为空！", txtBusinessType_Name, this);
return;
}
if (!btnCheck())
{
return; // 去重复
}
var BusinessTypeadd = new BusinessType
{
BusinessType_UserId = int.Parse(common.USERID),
BusinessType_Name = this.txtBusinessType_Name.Text.Trim(),
BusinessType_Content = this.txtBusinessType_Content.Text.Trim(),
BusinessType_CreatTime = Convert.ToDateTime(CommonalityEntity.GetServersTime().ToString()),
BusinessType_Remark = this.txtBusinessType_Remark.Text.Trim(),
BusinessType_Use = this.txtBusinessType_Use.Text.Trim(),
BusinessType_State = this.cbxBusinessType_State.Text,
BusinessType_Loaded = this.cbxBusinessType_Loaded.Text,
BusinessType_CarType_ID = Convert.ToInt32(cmbCarType.SelectedValue.ToString())
};
if (BusinessTypeDAL.InsertOneBusinessType(BusinessTypeadd))
{
string strContent1 = "业务类别名称为：" + this.txtBusinessType_Name.Text.Trim();;
CommonalityEntity.WriteLogData("新增", "新增 " + strContent1 + " 的信息", common.USERNAME);//添加日志
MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("业务类别管理 btnAdd_Click()");
}
finally
{
LogInfoLoad("");
Empty(); // 调用清空的方法
}
}
/// <summary>
/// 删除事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsbtnDel_Click()
{
try
{
int j = 0;
if (lvwUserList.SelectedRows.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
int count = lvwUserList.SelectedRows.Count;
//遍历
for (int i = 0; i < count; i++)
{
int CarInOutInfoRecord_ID = int.Parse(this.lvwUserList.SelectedRows[i].Cells["CarInOutInfoRecord_ID"].Value.ToString());
Expression <Func <CarInOutInfoRecord, bool> > cirFN = n => n.CarInOutInfoRecord_ID == CarInOutInfoRecord_ID;
if (CarInOutInfoRecordDAL.DeleteToMany(cirFN))
{
j++;
CommonalityEntity.WriteLogData("删除", "删除通行详细记录编号为：" + CarInOutInfoRecord_ID + " 的通行详细记录", CommonalityEntity.USERNAME);//添加操作日志
}
}
if (j == count)
{
MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("车辆进出厂统计 tsbtnDel_Click()+");
}
finally
{
BingMethod();
}
}
/// <summary>
/// 车辆授权
/// </summary>
/// <param name="strID"></param>
/// <param name="carName"></param>
private void saveAuthorization(string strID, string carName)
{
Expression <Func <BusinessRecord, bool> > p = n => n.BusinessRecord_CarInOutRecord_ID == int.Parse(strID) && n.BusinessRecord_Type == CommonalityEntity.outWeight;
Action <BusinessRecord> ap = s =>
{
s.BusinessRecord_UnloadEmpowerPerson = CommonalityEntity.USERNAME;
s.BusinessRecord_UnloadEmpowerTime = CommonalityEntity.GetServersTime();
s.BusinessRecord_PrintinvoiceTime = CommonalityEntity.GetServersTime();
s.BusinessRecord_UnloadEmpower = 1;
s.BusinessRecord_Remark = txtRemark.Text.ToString().Trim();
};
BusinessRecordDAL.Update(p, ap);
LinQBaseDao.Query("update CarInOutRecord set CarInOutRecord_OutCheck='是',CarInOutRecord_OutCheckUser='******',CarInOutRecord_OutCheckTime='" + CommonalityEntity.GetServersTime() + "' where CarInOutRecord_ID =" + strID);
CommonalityEntity.WriteLogData("地磅房授权", "地磅房:车辆" + carName + "出门授权", CommonalityEntity.USERNAME);//添加操作日志
MessageBox.Show("授权成功");
}
/// <summary>
/// “保 存” 按钮的单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (this.txtCustomerInfo_Name.Text == "")
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "公司名称不能为空！", txtCustomerInfo_Name, this);
return;
}
if (!btnCheck())
{
return; // 去重复
}
var CustomerInfoadd = new CustomerInfo
{
CustomerInfo_Name = this.txtCustomerInfo_Name.Text.Trim(),
CustomerInfo_State = this.comboxCustomerInfo_State.Text.Trim(),
CustomerInfo_Type = this.txtCustomerInfo_Type.Text.Trim(),
CustomerInfo_Email = this.txtCustomerInfo_Email.Text.Trim(),
CustomerInfo_Contact = this.txtCustomerInfo_Contact.Text.Trim(),
CustomerInfo_ADD = this.txtCustomerInfo_ADD.Text.Trim(),
CustomerInfo_Remark = this.txtCustomerInfo_Remark.Text.Trim()
};
if (CustomerInfoDAL.InsertOneQCRecord(CustomerInfoadd))
{
MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
string strContent1 = "公司名称为：" + this.txtCustomerInfo_Name.Text.Trim();
CommonalityEntity.WriteLogData("新增", "新增 " + strContent1 + " 的信息", CommonalityEntity.USERNAME);//添加日志
}
else
{
MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("公司信息管理 btnSave_Click()");
}
finally
{
LogInfoLoad("");
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSet_Click(object sender, EventArgs e)
{
try
{
string Sql = "select max(Dictionary_Value),MAX(Dictionary_Sort) from Dictionary where Dictionary_OtherID=(select Dictionary_ID from Dictionary where Dictionary_Value='09')";
DataSet ds = LinQBaseDao.Query(Sql);
string Dictionary_Value = ds.Tables[0].Rows[0][0].ToString();
string Dictionary_Sort = ds.Tables[0].Rows[0][1].ToString();
Dictionary dic = new Dictionary();
dic.Dictionary_Value = (Convert.ToInt32("0" + Dictionary_Value) + 1).ToString();
dic.Dictionary_Sort = Convert.ToInt32(Dictionary_Sort) + 1;
dic.Dictionary_Name = txtBackContext.Text;
dic.Dictionary_OtherID = 15;
dic.Dictionary_State = true;
dic.Dictionary_Remark = null;
dic.Dictionary_ISLower = false;
dic.Dictionary_IsSystem = false;
dic.Dictionary_Spare_int1 = Convert.ToInt32(txtDictionary_Spare_int1.Text.Trim());
dic.Dictionary_Spare_int2 = Convert.ToInt32(txtDictionary_Spare_int2.Text.Trim());
dic.Dictionary_Spare_vchar1 = null;
dic.Dictionary_Spare_vchar2 = null;
if (DictionaryDAL.InsertOneDictionary(dic))
{
MessageBox.Show("新增成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
treeViewPositionlist(tv_BackList.Nodes, "0");
Dictionary_Cler();
button4.Enabled = false;
button1.Enabled = false;
}
else
{
MessageBox.Show("新增失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch
{
}
finally
{
string strContent1 = "新增黑名单状态为： " + this.txtBackContext.Text.Trim();
CommonalityEntity.WriteLogData("添加", strContent1, CommonalityEntity.USERNAME);//添加操作日志
}
}
/// <summary>
/// 门岗 --> “保 存” 事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
StrIsNullOrEmpty(); // 调用判断系统初始化设置的各个文本框值是否为空的方法
Save(); // 调用保存系统初始化设置的方法
common.WriteLogData("修改", "初始化设置", common.USERNAME); //操作日志
try
{
if (MessageBox.Show("是否退出系统重新读取配置信息？", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.OK)
{
System.Diagnostics.Process.Start(System.Reflection.Assembly.GetExecutingAssembly().Location);
Application.Restart();
}
CommonalityEntity.WriteLogData("修改", "初始化设置", common.NAME); //操作日志
}
catch
{
Process.GetCurrentProcess().Kill();
}
}
/// <summary>
/// 记录车辆通行详细
/// </summary>
/// <param name="CarInOutRecord_ID">车辆通行编号</param>
/// <param name="DrivewayStrategy_ID">通行策略编号</param>
/// <param name="Remark">车辆通行详细备注</param>
/// <param name="Abnormal">是否通行异常</param>
/// <param name="DrivewayID">当前通道编号</param>
/// <param name="DrivewayStrategy_Sort">通行策略顺序号</param>
private void SaveCarInOutInfoRecord(int carinoutrecord_id, int drivewaystrategy_id, string state, string remark, string abnor, int drivewayid, int drivewaystrategy_sort)
{
CarInOutInfoRecord carinout = new CarInOutInfoRecord();
carinout.CarInOutInfoRecord_CarInOutRecord_ID = carinoutrecord_id;
carinout.CarInOutInfoRecord_DrivewayStrategy_ID = drivewaystrategy_id;
carinout.CarInOutInfoRecord_State = state;
carinout.CarInOutInfoRecord_Remark = remark;
carinout.CarInOutInfoRecord_Abnormal = abnor;
carinout.CarInOutInfoRecord_DrivewayID = drivewayid;
//carinout.CarInOutInfoRecord_DrivewayStrategy_Sort = drivewaystrategy_sort;
carinout.CarInOutInfoRecord_Time = CommonalityEntity.GetServersTime();
if (LinQBaseDao.InsertOne <CarInOutInfoRecord>(new DCCarManagementDataContext(), carinout))
{
string carinfoid = LinQBaseDao.Query("select CarInOutRecord_CarInfo_ID from CarInOutRecord where CarInOutRecord_ID =" + carinoutrecord_id + "").Tables[0].Rows[0][0].ToString();
string carinfoname = LinQBaseDao.Query("select CarInfo_Name from CarInfo where CarInfo_ID =" + carinfoid + "").Tables[0].Rows[0][0].ToString();
CommonalityEntity.WriteLogData("新增", "记录车牌号为：" + carinfoname + "的车辆通行信息", CommonalityEntity.USERNAME);//添加操作日志
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (this.lvwUserList.SelectedRows.Count <= 0)
{
MessageBox.Show("请选择要删除的项！");
return;
}
if (this.lvwUserList.SelectedRows[0].Cells["PositionVoice_ID"].Value.ToString() == "")
{
MessageBox.Show("请选择要删除的项！");
return;
}
if (this.lvwUserList.SelectedRows[0].Cells["PositionVoice_State"].Value.ToString() == "启动")
{
MessageBox.Show("启用状态的打印设置不能删除！");
return;
}
DialogResult dlgResult = MessageBox.Show("确定删除选中的数据?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlgResult == DialogResult.Cancel)
{
return;
}
//删除条件
int ii = int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionVoice_ID"].Value.ToString());
Expression <Func <PositionVoice, bool> > fun = n => n.PositionVoice_ID == ii;
PositionVoiceDAL.DeletePositionVoice(fun);
CommonalityEntity.WriteLogData("删除", "删除编号为" + ii + "的语音呼叫信息", CommonalityEntity.USERNAME);//添加操作日志
MessageBox.Show("删除成功！");
}
catch
{
CommonalityEntity.WriteTextLog("VoiceSetForm btnDelete_Click()" + "");
}
finally
{
btnSelect_Click(sender, e);
//GetGriddataviewLoad("");//加载
}
}
