/// <summary>
/// 双击组件时发生
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvBusinessType_DoubleClick(object sender, EventArgs e)
{
this.btnUpdate.Enabled = true;
this.btnSave.Enabled = false;
if (this.dgvBusinessType.SelectedRows.Count > 0)//选中行
{
if (dgvBusinessType.SelectedRows.Count > 1)
{
MessageBox.Show("修改只能选中一行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
//修改的值
int ID = int.Parse(this.dgvBusinessType.SelectedRows[0].Cells["BusinessType_ID"].Value.ToString());
Expression <Func <BusinessType, bool> > funviewinto = n => n.BusinessType_ID == ID;
foreach (var n in BusinessTypeDAL.QueryView(funviewinto))
{
if (n.BusinessType_Name != null)
{
// 业务类别名称
this.txtBusinessType_Name.Text = n.BusinessType_Name;
}
if (n.BusinessType_CarType_ID != null && n.BusinessType_CarType_ID > 0)
{
cmbCarType.Text = LinQBaseDao.GetSingle("select CarType_Name from CarType where CarType_ID=" + n.BusinessType_CarType_ID).ToString();
}
if (n.BusinessType_State != null)
{
// 业务类别状态
this.cbxBusinessType_State.Text = n.BusinessType_State;
}
if (n.BusinessType_Loaded != null)
{
//装货类型
this.cbxBusinessType_Loaded.Text = n.BusinessType_Loaded;
}
if (n.BusinessType_Use != null)
{
//业务类别用途
this.txtBusinessType_Use.Text = n.BusinessType_Use;
}
if (n.BusinessType_Content != null)
{
// 业务类别描述
this.txtBusinessType_Content.Text = n.BusinessType_Content;
}
if (n.BusinessType_Remark != null)
{
// 业务类别备注
this.txtBusinessType_Remark.Text = n.BusinessType_Remark;
}
break;
}
}
}
else
{
MessageBox.Show("请选择要修改的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <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="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>
/// <returns></returns>
private bool btnCheckupdate()
{
bool rbool = true;
try
{
string BusinessType_Name = this.txtBusinessType_Name.Text.ToString();
//判断名称是否已存在
Expression <Func <BusinessType, bool> > funviewFVNInfo = n => n.BusinessType_Name == BusinessType_Name && n.BusinessType_Name != this.dgvBusinessType.SelectedRows[0].Cells["BusinessType_Name"].Value.ToString();
if (BusinessTypeDAL.QueryView(funviewFVNInfo).Count() > 0)
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "该业务类型名称已存在", txtBusinessType_Name, this);
this.txtBusinessType_Name.Focus();
rbool = false;;
}
return(rbool);
}
catch
{
CommonalityEntity.WriteTextLog("地感管理 btnCheck()");
rbool = false;
}
return(rbool);
}
/// <summary>
/// “修改” 按钮的单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (this.txtBusinessType_Name.Text == "")
{
PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "业务类别名称不能为空！", txtBusinessType_Name, this);
return;
}
if (this.dgvBusinessType.SelectedRows.Count > 0)//选中行
{
if (dgvBusinessType.SelectedRows.Count > 1)
{
MessageBox.Show("修改只能选中一行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (!btnCheckupdate())
{
return; // 去重复
}
Expression <Func <BusinessType, bool> > pc = n => n.BusinessType_ID == int.Parse(this.dgvBusinessType.SelectedRows[0].Cells["BusinessType_ID"].Value.ToString());
Action <BusinessType> ap = s =>
{
s.BusinessType_UserId = CommonalityEntity.USERID;
s.BusinessType_Name = this.txtBusinessType_Name.Text.Trim();
s.BusinessType_Content = this.txtBusinessType_Content.Text.Trim();
s.BusinessType_CreatTime = Convert.ToDateTime(CommonalityEntity.GetServersTime().ToString());
s.BusinessType_Remark = this.txtBusinessType_Remark.Text.Trim();
s.BusinessType_Use = this.txtBusinessType_Use.Text.Trim();
s.BusinessType_State = this.cbxBusinessType_State.Text;
s.BusinessType_Loaded = this.cbxBusinessType_Loaded.Text;
s.BusinessType_CarType_ID = Convert.ToInt32(cmbCarType.SelectedValue.ToString());
};
if (BusinessTypeDAL.Update(pc, ap))
{
string strContent = "业务类别名称为：" + this.txtBusinessType_Name.Text.Trim();;
CommonalityEntity.WriteLogData("修改", "修改 " + strContent + " 的信息", common.USERNAME);//添加日志
MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
catch
{
CommonalityEntity.WriteTextLog("业务类别管理 btnAdd_Click()");
}
finally
{
LogInfoLoad("");
this.btnUpdate.Enabled = false;
this.btnSave.Enabled = true;
Empty(); // 调用清空的方法
}
}
