/// <summary>
/// 查重方法
/// </summary>
/// <returns></returns>
private bool btnCheck()
{
bool rbool = true;
try
{
//IC卡类型值
string ValueName = this.txtICCardType_Value.Text.Trim();
string ICType = this.txtICCardType_Name.Text.Trim();
//判断名称是否已存在
Expression <Func <ICCardType, bool> > funviewICCard = n => n.ICCardType_Name == ICType && n.ICCardType_Name != this.dgvICCardType.SelectedRows[0].Cells["ICCardType_Name"].Value.ToString();
if (ICCardTypeDAL.Query(funviewICCard).Count() > 0)
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "该IC卡类型名称已存在", txtICCardType_Name, this);
txtICCardType_Name.Focus();
rbool = false;;
}
//判断名称是否已存在
Expression <Func <ICCardType, bool> > funviewICCard1 = n => n.ICCardType_Value == ValueName && n.ICCardType_Value != this.dgvICCardType.SelectedRows[0].Cells["ICCardType_Value"].Value.ToString();
if (ICCardTypeDAL.Query(funviewICCard1).Count() > 0)
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "该IC卡类型值已存在", txtICCardType_Value, this);
txtICCardType_Value.Focus();
rbool = false;;
}
return(rbool);
}
catch
{
CommonalityEntity.WriteTextLog("IC卡类型信息 btnCheck()");
rbool = false;
}
return(rbool);
}
/// <summary>
/// 用户双击组件时发生
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvICCardType_DoubleClick(object sender, EventArgs e)
{
this.btnUpdate.Enabled = true;
this.btnSave.Enabled = false;
if (this.dgvICCardType.SelectedRows.Count > 0)//选中行
{
if (dgvICCardType.SelectedRows.Count > 1)
{
MessageBox.Show("修改只能选中一行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
//修改的值
int ID = int.Parse(this.dgvICCardType.SelectedRows[0].Cells["ICCardType_ID"].Value.ToString());
Expression <Func <ICCardType, bool> > funviewinto = n => n.ICCardType_ID == ID;
foreach (var n in ICCardTypeDAL.Query(funviewinto))
{
if (n.ICCardType_Name != null)
{
//IC卡类型名称
this.txtICCardType_Name.Text = n.ICCardType_Name;
}
if (n.ICCardType_Value != null)
{
//IC卡类型值
this.txtICCardType_Value.Text = n.ICCardType_Value;
}
if (n.ICCardType_State != null)
{
// IC卡类型状态
this.comboxICCardType_State.Text = n.ICCardType_State;
}
if (n.ICCardType_Description != null)
{
// IC卡类型描述
this.txtICCardType_Description.Text = n.ICCardType_Description;
}
if (n.ICCardType_Remark != null)
{
// IC卡类型备注
this.txtICCardType_Remark.Text = n.ICCardType_Remark;
}
if (n.ICCardType_Permissions != null)
{
ICCardPermissions.Text = n.ICCardType_Permissions;
}
break;
}
}
}
else
{
MessageBox.Show("请选择要修改的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <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>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (this.txtICCardType_Name.Text == "")
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "IC卡类型名称不能为空！", txtICCardType_Name, this);
return;
}
if (this.txtICCardType_Value.Text == "")
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "IC卡类型值不能为空！", txtICCardType_Value, this);
return;
}
//判断IC卡类型名称是否存在txtICCardType_Name
if (LinQBaseDao.Query("select * from ICCardType where ICCardType_Name='" + txtICCardType_Name + "'").Tables[0].Rows.Count >= 1)
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "IC类型名称已存在！", txtICCardType_Name, this);
return;
}
if (LinQBaseDao.Query("select * from ICCardType where ICCardType_Value='" + txtICCardType_Value + "'").Tables[0].Rows.Count >= 1)
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "IC类型值已存在！", txtICCardType_Value, this);
return;
}
if (!btnCheck())
{
return; // 去重复
}
if (this.dgvICCardType.SelectedRows.Count > 0) //选中行
{
if (dgvICCardType.SelectedRows.Count > 1)
{
MessageBox.Show("修改只能选中一行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
Expression <Func <ICCardType, bool> > p = n => n.ICCardType_ID == int.Parse(this.dgvICCardType.SelectedRows[0].Cells["ICCardType_ID"].Value.ToString());
string id = "";
string strfront = "";
string strContent = "";
Action <ICCardType> ap = s =>
{
strfront = s.ICCardType_Name + "," + s.ICCardType_State + "," + s.ICCardType_State + "," + s.ICCardType_Value + "," + s.ICCardType_Description + "," + s.ICCardType_Permissions + "," + s.ICCardType_Remark;
s.ICCardType_Name = this.txtICCardType_Name.Text.Trim();
s.ICCardType_State = this.comboxICCardType_State.Text.Trim();
s.ICCardType_Value = this.txtICCardType_Value.Text.Trim();
s.ICCardType_Description = this.txtICCardType_Description.Text.Trim();
if (!string.IsNullOrEmpty(this.ICCardPermissions.Text.Trim()))
{
s.ICCardType_Permissions = this.ICCardPermissions.Text.Trim();
}
s.ICCardType_Remark = this.txtICCardType_Remark.Text.Trim();
strContent = s.ICCardType_Name + "," + s.ICCardType_State + "," + s.ICCardType_State + "," + s.ICCardType_Value + "," + s.ICCardType_Description + "," + s.ICCardType_Permissions + "," + s.ICCardType_Remark;
id = s.ICCardType_ID.ToString();
};
if (ICCardTypeDAL.Update(p, ap))
{
MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
CommonalityEntity.WriteLogData("修改", "更新编号为：" + id + "的IC卡类型；修改前：" + strfront + ";修改后：" + strContent, CommonalityEntity.USERNAME); //添加操作日志
Empty(); // 调用清空的方法
}
else
{
MessageBox.Show("修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
catch
{
CommonalityEntity.WriteTextLog("IC卡信息管理 btnUpdate_Click()");
}
finally
{
LogInfoLoad("");
this.btnUpdate.Enabled = false;
this.btnSave.Enabled = true;
}
}
/// <summary>
/// “保 存” 按钮的单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
//判断IC卡类型名称是否存在txtICCardType_Name
if (LinQBaseDao.Query("select * from ICCardType where ICCardType_Name='" + txtICCardType_Name + "'").Tables[0].Rows.Count >= 1)
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "IC类型名称已存在！", txtICCardType_Name, this);
return;
}
if (LinQBaseDao.Query("select * from ICCardType where ICCardType_Value='" + txtICCardType_Value + "'").Tables[0].Rows.Count >= 1)
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "IC类型值已存在！", txtICCardType_Value, this);
return;
}
if (this.txtICCardType_Name.Text == "")
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "IC卡类型名称不能为空！", txtICCardType_Name, this);
return;
}
if (this.txtICCardType_Value.Text == "")
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "IC卡类型值不能为空！", txtICCardType_Value, this);
return;
}
if (!btnCheck())
{
return; // 去重复
}
var ICCardTypeadd = new ICCardType
{
ICCardType_Name = this.txtICCardType_Name.Text.Trim(),
ICCardType_State = this.comboxICCardType_State.Text.Trim(),
ICCardType_Value = this.txtICCardType_Value.Text.Trim(),
ICCardType_Description = this.txtICCardType_Description.Text.Trim(),
ICCardType_Remark = this.txtICCardType_Remark.Text.Trim(),
ICCardType_Permissions = this.ICCardPermissions.Text,
ICCardType_PermissionsValue = strview
};
if (ICCardTypeDAL.InsertOneICCardType(ICCardTypeadd))
{
MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
string strContent1 = "新增IC卡类型名称为： " + this.txtICCardType_Name.Text.Trim();
CommonalityEntity.WriteLogData("新增", strContent1, CommonalityEntity.USERNAME); //添加操作日志
Empty(); // 调用清空的方法
}
else
{
MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch
{
CommonalityEntity.WriteTextLog("IC卡信息管理 btnSave_Click()");
}
finally
{
LogInfoLoad("");
}
}
