//判断标示
private bool updateMark()
{
Boolean mark = false;
dataAccess = new DataAccess();
try
{
SearchParameter sp = new SearchParameter();
sp.SetValue(":Maintain_input_code", txtMaintain_input_code.Text);
dataAccess.Open();
GetData getData = new GetData(dataAccess.Connection);
DataTable dt = getData.GetSingleTableByCondition("TC_MAINTAIN", sp);
if (dt.Rows.Count > 0)
{
mark = true;
return(mark);
}
sp.Clear();
sp.SetValue("input_code", txtMaintain_input_code.Text);
dataAccess.Open();
getData = new GetData(dataAccess.Connection);
dt = getData.GetSingleTableByCondition("TC_lose", sp);
if (dt.Rows.Count > 0)
{
mark = true;
return(mark);
}
dataAccess.Open();
getData = new GetData(dataAccess.Connection);
dt = getData.GetSingleTableByCondition("TC_OUTPUT_STORAGE", sp);
if (dt.Rows.Count > 0)
{
mark = true;
return(mark);
}
}
catch (Exception ex)
{
MessageBox.Show("请查看数据库是否正常！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
if (dataAccess.Connection != null)
{
dataAccess.Close();
}
}
return(mark);
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/7/15 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
//判断有效日期不能为空
if (txtStaff_name.Text.Trim() == string.Empty || txtStaff_name.Text == "双击选择员工...")
{
MessageBox.Show("用户姓名不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtStaff_name.Focus();
return;
}
//判断产品名称不能为空
if (txtAuthority_user_code.Text.Trim() == string.Empty)
{
MessageBox.Show("登录账号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtAuthority_user_code.Focus();
return;
}
//判断非法字符
foreach (Control control in groupBox1.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
EntityAuthority entity = new EntityAuthority();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entity.Authority_level = "2";
entity.Authority_user_code = txtAuthority_user_code.Text;
entity.Staff_code = staffCode;
//加密狗
entity.Authority_password = Util.GetHashCode("000000");
dataAccess = new DataAccess();
dataAccess.Open();
SearchParameter sp = new SearchParameter();
sp.SetValue(":Authority_user_code", txtAuthority_user_code.Text);
GetData getData = new GetData(dataAccess.Connection);
DataTable dt = getData.GetSingleTableByConditionUnLike("tc_Authority", sp);
dataAccess.Open();
sp.Clear();
sp.SetValue(":staff_code", staffCode);
getData = new GetData(dataAccess.Connection);
DataTable dt2 = getData.GetSingleTableByConditionUnLike("tc_Authority", sp);
if (dt != null && dt.Rows.Count != 0 && dt2 != null && dt2.Rows.Count != 0)
{
MessageBox.Show("该用户已经存在自己的登录账号！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtStaff_name.Focus();
return;
}
if (dt != null && dt.Rows.Count != 0)
{
MessageBox.Show("登录账号已存在！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtAuthority_user_code.Focus();
return;
}
else if (dt2 != null && dt2.Rows.Count != 0)
{
MessageBox.Show("该用户已经存在自己的登录账号！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtStaff_name.Focus();
return;
}
else
{
dataAccess.Open();
result = getData.InsertAuthorityTable(entity);
}
}
}
catch (COMException comex)
{
MessageBox.Show("加密狗未找到，请插入加密狗！", "长白ERP系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
//关闭数据库连接
if (dataAccess.Connection != null)
{
dataAccess.Close();
}
}
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BandingDgv();
}
else
{
MessageBox.Show("数据保存时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
}
/// <summary>
/// 删除按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/07/13 完成
/// 更新信息：
/// </history>
private void btnDelete_Click(object sender, EventArgs e)
{
result = -1;
countNum = 0;
if (dgv.SelectedRows.Count > 1)
{
MessageBox.Show("只能选择一条要删除的记录！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (dgv.SelectedRows.Count < 1)
{
MessageBox.Show("请选择一条要删除的记录！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
SearchParameter sp = new SearchParameter();
sp.SetValue(":supplier_name", dgv.SelectedRows[0].Cells["supplier_name"].Value.ToString());
dataAccess = new DataAccess();
try
{
dataAccess.Open();
GetData gd = new GetData(dataAccess.Connection);
DataTable dt = gd.GetSingleTableByCondition("TC_INPUT_STORAGE", sp);
if (dt != null && dt.Rows.Count > 0)
{
MessageBox.Show("此供货商信息已经被使用，无法删除！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
catch
{
MessageBox.Show("数据删除时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
dataAccess.Close();
}
if (MessageBox.Show("您确定要删除该数据吗？", Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
try
{
sp.Clear();
sp.SetValue(":Supplier_code", dgv.SelectedRows[0].Cells["Supplier_code"].Value.ToString());
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
result = getData.DeleteRow("tc_Supplier", sp);
dataAccess.Commit();
}
catch (Exception ex)
{
dataAccess.Rollback();
}
finally
{
dataAccess.Close();
if (result == 0)
{
MessageBox.Show("数据已经被成功删除！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BandingDgv();
}
else
{
MessageBox.Show("数据删除时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}