//***********************************************************************
/// <summary>
/// 确认按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：代国明 2010/07/22 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
if (txt_goods_name.Text.Trim() == "双击选择产品..." || txt_goods_name.Text.Trim() == string.Empty)
{
MessageBox.Show("产品名称不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_goods_name.Focus();
return;
}
if (txt_supplier_name.Text.Trim() == string.Empty)
{
MessageBox.Show("供货商不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_supplier_name.Focus();
return;
}
if (nud_output_count.Value == 0)
{
MessageBox.Show("退货数量不能为0！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
nud_output_count.Select();
return;
}
//判断时间有效性
if (DateTime.Now.Date < dtp_output_checktime.Value.Date)
{
MessageBox.Show("请选择一个正确的验收日期！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dtp_output_checktime.Select();
return;
}
//判断时间有效性
if (dtp_output_instorage_date.Value.Date > dtp_output_checktime.Value.Date)
{
MessageBox.Show("请选择一个正确的出库日期！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dtp_output_instorage_date.Select();
return;
}
if (txt_output_check_persion.Text.Trim() == "双击选择验收人..." || txt_output_check_persion.Text.Trim() == string.Empty)
{
MessageBox.Show("验收人不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_output_check_persion.Focus();
return;
}
if (txt_output_quality_persion.Text.Trim() == "双击选择质管员..." || txt_output_quality_persion.Text.Trim() == string.Empty)
{
MessageBox.Show("质管员不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_output_quality_persion.Focus();
return;
}
if (txt_output_oper.Text.Trim() == "双击选择业务员..." || txt_output_oper.Text.Trim() == string.Empty)
{
MessageBox.Show("业务员不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_output_oper.Focus();
return;
}
if (txt_output_issued.Text.Trim() == "双击选择经办人..." || txt_output_issued.Text.Trim() == string.Empty)
{
MessageBox.Show("经办人不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_output_issued.Focus();
return;
}
//if (cmb_output_packing_in.Text.Equals("请选择一种包装情况"))
//{
// MessageBox.Show("请选择一种包装情况", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// cmb_output_packing_in.Focus();
// return;
//}
//if (cmb_output_packing_mid.Text.Equals("请选择一种包装情况"))
//{
// MessageBox.Show("请选择一种包装情况", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// cmb_output_packing_mid.Focus();
// return;
//}
//if (cmb_output_packing_out.Text.Equals("请选择一种包装情况"))
//{
// MessageBox.Show("请选择一种包装情况", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// cmb_output_packing_out.Focus();
// return;
//}
//添加后库存数目剪掉添加数目数据信息
UpdateStorageDetailsByAdd();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
//取得实体类
outputStorageEntity = new EntityOutput_storage();
//赋值实体类
outputStorageEntity.Output_checktime = Convert.ToDateTime(dtp_output_checktime.Value.ToString("yyyy-MM-dd"));
outputStorageEntity.Output_instorage_date = Convert.ToDateTime(dtp_output_instorage_date.Value.ToString("yyyy-MM-dd"));
outputStorageEntity.Output_count = Convert.ToInt32(nud_output_count.Value);
outputStorageEntity.Input_code = inputCode;
outputStorageEntity.Output_packing_in = cmb_output_packing_in.Text.ToString();
outputStorageEntity.Output_packing_mid = cmb_output_packing_mid.Text.ToString();
outputStorageEntity.Output_packing_out = cmb_output_packing_out.Text.ToString();
outputStorageEntity.Output_oper = txt_output_oper.Text.ToString();
outputStorageEntity.Output_quality_persion = txt_output_quality_persion.Text.ToString();
outputStorageEntity.Output_issued = txt_output_issued.Text.ToString();
outputStorageEntity.Output_check_persion = txt_output_check_persion.Text.ToString();
outputStorageEntity.Output_backreason = txt_output_reback_reason.Text.ToString();
outputStorageEntity.Output_remark = txt_output_remark.Text.ToString();
outputStorageEntity.Output_type = "1";
outputStorageEntity.Operate_type = "0";
//赋值实体类
inputStorageEntity = new EntityInput_storage();
inputStorageEntity.OPERATE_TYPE = '1';
inputStorageEntity.INPUT_CODE = inputCode;
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey mpk = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
outputStorageEntity.Output_code = mpk.MakeCode("出库");
//取得操作类
GetData getData = new GetData(dataAccess.Connection);
//取得结果符
result = getData.InsertOutput_storageRow(outputStorageEntity);
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("数据已经保存失败！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
getData.UpdateOperate_typeByInput_codeRow(inputStorageEntity);
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
//关闭数据库连接
dataAccess.Close();
//设置按钮状态
dataType = DataType.None;
setButtonState();
//重新加载画面
BindingDgvOutputStorage();
}
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/07/13 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
if (txtSupplier_name.Text.Trim() == string.Empty)
{
MessageBox.Show("供货商名称不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtSupplier_name.Focus();
return;
}
if (txtSupplier_licence.Text.Trim() == string.Empty)
{
MessageBox.Show("许可证编号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtSupplier_licence.Focus();
return;
}
if (cb_Supplier_type.SelectedIndex == 0)
{
MessageBox.Show("供货商分类不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
cb_Supplier_type.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;
}
}
}
EntitySupplier entitySupplier = new EntitySupplier();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entitySupplier.Supplier_code = txtSupplier_code.Text;
entitySupplier.Supplier_name = txtSupplier_name.Text;
entitySupplier.Supplier_yxm = txtSupplier_yxm.Text;
entitySupplier.Supplier_address = txtSupplier_address.Text;
entitySupplier.Supplier_artificial_person = txtSupplier_artificial_person.Text;
entitySupplier.Supplier_business_scpoe = txtSupplier_business_scpoe.Text;
entitySupplier.Supplier_licence = txtSupplier_licence.Text;
entitySupplier.Supplier_trustpersion = txtSupplier_trustpersion.Text;
entitySupplier.Supplier_tariff_num = txtSupplier_tariff_num.Text;
entitySupplier.Supplier_principal = txtSupplier_principal.Text;
entitySupplier.Supplier_bank = txtSupplier_bank.Text;
entitySupplier.Supplier_bank_num = txtSupplier_bank_num.Text;
entitySupplier.Supplier_tel = txtSupplier_tel.Text;
entitySupplier.Supplier_fax = txtSupplier_fax.Text;
entitySupplier.Supplier_business_licence = txtSupplier_business_licence.Text;
entitySupplier.Supplier_postal_code = txtSupplier_postal_code.Text;
entitySupplier.Supplier_make_quality_num = txtSupplier_make_quality_num.Text;
entitySupplier.Supplier_business_num = txtSupplier_business_num.Text;
entitySupplier.Supplier_type = cb_Supplier_type.Text;
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
entitySupplier.Supplier_code = primaryKey.MakeCode("供货商");
GetData getData = new GetData(dataAccess.Connection);
if (getData.InsertIsOnly("tc_supplier", "supplier_name", txtSupplier_name.Text.Trim()))
{
MessageBox.Show("您输入的供货商名称已经存在，请更改供货商名称后再保存！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtSupplier_name.Focus();
return;
}
result = getData.InsertSupplier(entitySupplier);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entitySupplier.Supplier_code = txtSupplier_code.Text;
entitySupplier.Supplier_name = txtSupplier_name.Text;
entitySupplier.Supplier_yxm = txtSupplier_yxm.Text;
entitySupplier.Supplier_address = txtSupplier_address.Text;
entitySupplier.Supplier_artificial_person = txtSupplier_artificial_person.Text;
entitySupplier.Supplier_business_scpoe = txtSupplier_business_scpoe.Text;
entitySupplier.Supplier_licence = txtSupplier_licence.Text;
entitySupplier.Supplier_trustpersion = txtSupplier_trustpersion.Text;
entitySupplier.Supplier_tariff_num = txtSupplier_tariff_num.Text;
entitySupplier.Supplier_principal = txtSupplier_principal.Text;
entitySupplier.Supplier_bank = txtSupplier_bank.Text;
entitySupplier.Supplier_bank_num = txtSupplier_bank_num.Text;
entitySupplier.Supplier_tel = txtSupplier_tel.Text;
entitySupplier.Supplier_fax = txtSupplier_fax.Text;
entitySupplier.Supplier_business_licence = txtSupplier_business_licence.Text;
entitySupplier.Supplier_postal_code = txtSupplier_postal_code.Text;
entitySupplier.Supplier_make_quality_num = txtSupplier_make_quality_num.Text;
entitySupplier.Supplier_business_num = txtSupplier_business_num.Text;
entitySupplier.Supplier_type = cb_Supplier_type.Text;
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
if (getData.UpdateIsOnly("tc_supplier", "supplier_code", entitySupplier.Supplier_code, "supplier_name", txtSupplier_name.Text.Trim()))
{
MessageBox.Show("您输入的供货商名称已经存在，请更改供货商名称后再保存！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtSupplier_name.Focus();
return;
}
//取得结果符
result = getData.UpdateSupplier(entitySupplier);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
MessageBox.Show("数据保存时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
finally
{
//关闭数据库连接
if (dataAccess != null)
{
dataAccess.Close();
}
}
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("数据保存时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
BandingDgv();
//设置按钮状态
dataType = DataType.None;
setButtonState();
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/7/26 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
//判断非法字符
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
//判断入库编号不为空
if (txtApparatus_quality_output_code.Text.Trim() == string.Empty || txtApparatus_quality_output_code.Text == "双击选择出库编号...")
{
MessageBox.Show("出库编号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_quality_output_code.Focus();
return;
}
if (txtApparatus_quality_count.Text.Trim() == string.Empty)
{
MessageBox.Show("出问题产品数量不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_quality_count.Focus();
return;
}
if (Convert.ToInt32(txtApparatus_quality_count.Text.Trim()) == 0)
{
MessageBox.Show("出问题产品数量不能为0！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_quality_count.Focus();
return;
}
if (Convert.ToInt32(labelSellcount.Text) < Convert.ToInt32(txtApparatus_quality_count.Text.Trim()))
{
MessageBox.Show("输入的数量不能大于出售数量！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
labelSellcount.Focus();
return;
}
if (txtApparatus_speaker.Text.Trim() == string.Empty)
{
MessageBox.Show("报告人不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_speaker.Focus();
return;
}
if (txtApparatus_qualityt_issued.Text.Trim() == string.Empty || txtApparatus_qualityt_issued.Text == "双击选择经办人...")
{
MessageBox.Show("经办人不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_qualityt_issued.Focus();
return;
}
//判断时间有效性
if (DateTime.Now.Date < dateApparatus_report_date.Value.Date)
{
MessageBox.Show("报告日期不能大于今天！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dateApparatus_report_date.Focus();
return;
}
//判断时间有效性
if (dateApparatus_accident_management_date.Value.Date < dateApparatus_report_date.Value.Date)
{
MessageBox.Show("处理日期不能小于报告日期！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dateApparatus_accident_management_date.Focus();
return;
}
//判断时间有效性
if (dateApparatus_report_date.Value.Date < outputInstorageDate)
{
MessageBox.Show("报告日期不能小于销售日期！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
EntityApparatus_quality entity = new EntityApparatus_quality();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entity.Apparatus_output_code = txtApparatus_quality_output_code.Text;
entity.Apparatus_accident_conditions = txtApparatus_accident_conditions.Text;
entity.Apparatus_accident_management = txtApparatus_accident_management.Text;
entity.Apparatus_accident_management_date = dateApparatus_accident_management_date.Value.Date;
entity.Apparatus_customer_feedback = txtApparatus_customer_feedback.Text;
entity.Apparatus_opinion_leader = txtApparatus_opinion_leader.Text;
entity.Apparatus_quality_count = Convert.ToInt32(txtApparatus_quality_count.Text.Trim());
entity.Apparatus_qualityt_issued = txtApparatus_qualityt_issued.Text;
entity.Apparatus_report_date = dateApparatus_report_date.Value.Date;
entity.Apparatus_speaker = txtApparatus_speaker.Text;
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
entity.Apparatus_quality_code = primaryKey.MakeCode("器械质量跟踪");
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertApparatus_quality(entity);
//处理操作标示
EntityOutput_storage outputStorageEntity = new EntityOutput_storage();
outputStorageEntity.Operate_type = "1";
SearchParameter sp = new SearchParameter();
sp.SetValue(":output_code", txtApparatus_quality_output_code.Text);
result = getData.UpdateOutput_storage(outputStorageEntity, sp);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entity.Apparatus_output_code = txtApparatus_quality_output_code.Text;
entity.Apparatus_accident_conditions = txtApparatus_accident_conditions.Text;
entity.Apparatus_accident_management = txtApparatus_accident_management.Text;
entity.Apparatus_accident_management_date = dateApparatus_accident_management_date.Value.Date;
entity.Apparatus_customer_feedback = txtApparatus_customer_feedback.Text;
entity.Apparatus_opinion_leader = txtApparatus_opinion_leader.Text;
entity.Apparatus_quality_count = Convert.ToInt32(txtApparatus_quality_count.Text.Trim());
entity.Apparatus_qualityt_issued = txtApparatus_qualityt_issued.Text;
entity.Apparatus_report_date = dateApparatus_report_date.Value.Date;
entity.Apparatus_speaker = txtApparatus_speaker.Text;
entity.Apparatus_quality_code = dgv.SelectedRows[0].Cells["Apparatus_quality_code"].Value.ToString();
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateApparatus_quality(entity);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据保存时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
//关闭数据库连接
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();
//重新加载画面
BandingDgv();
}
//***********************************************************************
/// <summary>
/// 确认按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：代国明 2010/07/25 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
//条件不为空
if (txt_input_code.Text.Trim() == string.Empty || txt_input_code.Text.Trim() == "双击选择入库编号...")
{
MessageBox.Show("入库编号不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_input_code.Focus();
return;
}
if (txt_goods_name.Text.Trim() == string.Empty)
{
MessageBox.Show("产品编号不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_goods_name.Focus();
return;
}
//判断时间有效性
if (DateTime.Now.Date < dtp_lose_datetime.Value.Date)
{
MessageBox.Show("报损日期不能大于今天！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dtp_lose_datetime.Focus();
return;
}
if (instorageDate > dtp_lose_datetime.Value.Date)
{
MessageBox.Show("报损日期不能小于入库日期！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dtp_lose_datetime.Focus();
return;
}
if (txt_lose_applier.Text.Trim() == "双击选择报损申请人..." || txt_lose_applier.Text.Trim() == string.Empty)
{
MessageBox.Show("报损申请人不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_lose_applier.Focus();
return;
}
if (txt_lose_checker.Text.Trim() == "双击选择报损核准人..." || txt_lose_checker.Text.Trim() == string.Empty)
{
MessageBox.Show("报损核准人不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_lose_checker.Focus();
return;
}
//添加,修改后库存数目剪掉添加数目数据信息
UpdateStorageDetailsByAdd();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
//取得实体类
loseEntity = new EntityLose();
//赋值实体类
loseEntity.Input_code = txt_input_code.Text.ToString();
loseEntity.Lose_applier = txt_lose_applier.Text.ToString();
loseEntity.Lose_checker = txt_lose_checker.Text.ToString();
loseEntity.Lose_count = int.Parse(nud_lose_count.Value.ToString());
loseEntity.Lose_reason = txt_lose_reason.Text.ToString();
loseEntity.Lose_remark = txt_lose_remark.Text.ToString();
loseEntity.Lose_result = txt_lose_result.Text.ToString();
loseEntity.Lose_datetime = Convert.ToDateTime(dtp_lose_datetime.Value.ToString("yyyy-MM-dd"));
//赋值实体类
inputStorageEntity = new EntityInput_storage();
inputStorageEntity.OPERATE_TYPE = '1';
inputStorageEntity.INPUT_CODE = txt_input_code.Text.ToString();
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
//取得操作类
GetData getData = new GetData(dataAccess.Connection);
//生成主键
MakePrimaryKey mpk = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
loseEntity.Lose_code = mpk.MakeCode("报损表");
//取得结果符
result = getData.InsertLoseRow(loseEntity);
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("数据已经保存失败！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
getData.UpdateOperate_typeByInput_codeRow(inputStorageEntity);
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
//重新加载画面
BandingDgvLose();
}
//***********************************************************************
/// <summary>
/// 更新按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：吴小科 2010/07/14 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
//结果符
result1 = -1;
//取得实体类
input_storageEntity = new EntityInput_storage();
//判断该字段是否为空
if (textBox_goods_name.Text.Equals("双击选择一个产品..."))
{
MessageBox.Show("产品名称不能为空", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox_goods_name.Focus();
return;
}
//赋值实体类
input_storageEntity.INPUT_GOODS_CODE = goods_code;
//判断该字段是否为空
if (textBox_input_standard_count.Value == 0)
{
MessageBox.Show("数量不能为0，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox_input_standard_count.Focus();
return;
}
if (textBox_input_standard_count.Text == "")
{
MessageBox.Show("数量不能为空，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox_input_standard_count.Focus();
return;
}
input_storageEntity.INPUT_STANDARD_COUNT = (int)textBox_input_standard_count.Value;
input_storageEntity.INPUT_ARRIVAL_COUNT = (int)textBox_input_standard_count.Value;
//判断时间有效性
if (dataTime_input_maketime.Value.Date > dateTime_input_instorage_date.Value.Date)
{
MessageBox.Show("生产日期不可大于入库日期", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dataTime_input_maketime.Focus();
return;
}
//判断时间有效性
if (DateTime.Now.Date < dateTime_input_instorage_date.Value.Date)
{
MessageBox.Show("入库时间不可大于今天", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dateTime_input_instorage_date.Focus();
return;
}
input_storageEntity.INPUT_MAKETIME = dataTime_input_maketime.Value.Date;
input_storageEntity.INPUT_INSTORAGE_DATE = dateTime_input_instorage_date.Value.Date;
//判断该字段是否为空
if (textBox_counter_name.Text.Equals("双击选择一个货位..."))
{
MessageBox.Show("货位不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox_counter_name.Focus();
return;
}
if (textBox_input_oper.Text.Equals("双击选择一个业务员..."))
{
MessageBox.Show("业务员不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox_input_oper.Focus();
return;
}
if (textBox_input_quality_persion.Text.Equals("双击此处一个质管员..."))
{
MessageBox.Show("质管员不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox_input_quality_persion.Focus();
return;
}
if (textBox_supplier_name.Text.Equals("双击选择一个供货商..."))
{
MessageBox.Show("供货商不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox_supplier_name.Focus();
return;
}
if (comboBox_packing_out.Text.Equals("请选择一种包装情况"))
{
MessageBox.Show("请重新选择包装情况(外)", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
comboBox_packing_out.Focus();
return;
}
if (comboBox_packing_mid.Text.Equals("请选择一种包装情况"))
{
MessageBox.Show("请重新选择包装情况(中)", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
comboBox_packing_mid.Focus();
return;
}
if (comboBox_packing_in.Text.Equals("请选择一种包装情况"))
{
MessageBox.Show("请重新选择一种包装情况(内)", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
comboBox_packing_in.Focus();
return;
}
if (textBox_input_batch_num.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("批号/设备号不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox_input_batch_num.Focus();
return;
}
input_storageEntity.INPUT_PACKING_OUT = comboBox_packing_out.Text;
input_storageEntity.INPUT_PACKING_MID = comboBox_packing_mid.Text;
input_storageEntity.INPUT_PACKING_IN = comboBox_packing_in.Text;
input_storageEntity.INPUT_REMARK = textBox_input_remark.Text;
input_storageEntity.INPUT_BATCH_NUM = textBox_input_batch_num.Text;
input_storageEntity.SUPPLIER_NAME = textBox_supplier_name.Text;
input_storageEntity.COUNTER_NAME = textBox_counter_name.Text;
input_storageEntity.INPUT_OPER = textBox_input_oper.Text;
input_storageEntity.INPUT_QUALITY_PERSION = textBox_input_quality_persion.Text;
//实体类赋值
input_storageEntity.INPUT_QUALITY_REG = textBox_input_quality_reg.Text;
input_storageEntity.INPUT_REMARK = textBox_input_remark.Text;
//增加操作
if (dataType == DataType.Insert)
{
SearchParameter sp = new SearchParameter();
//更新条件参数赋值
sp.SetValue(":goods_code", goods_code);
//取得实体类
temp_storageEntity = new EntityTemp_storage();
//赋值实体类
temp_storageEntity.Count = (int)textBox_input_standard_count.Value;
try
{
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
//取得操作类
GetData getData1 = new GetData(dataAccess.Connection);
MakePrimaryKey key = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
input_storageEntity.INPUT_CODE = key.MakeCode("入库");
//取得结果符
result2 = getData1.InsertInput_storageRow(input_storageEntity);
result1 = getData1.UpdateTemp_storage(temp_storageEntity, sp);
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
//提示错误
MessageBox.Show("操作数据时发生错误，请检查数据库是否正常开启！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
//关闭数据库连接
dataAccess.Close();
//设置按钮状态
dataType = DataType.None;
SetButtonState();
//重新加载画面
BandingDgvCounter();
}
}
//更新操作
else if (dataType == DataType.Update)
{
input_storageEntity.INPUT_CODE = textBox_input_code2.Text;
//设置更新条件参数
SearchParameter sp = new SearchParameter();
SearchParameter sp1 = new SearchParameter();
//更新条件参数赋值
sp.SetValue(":goods_code", goods_code);
sp1.SetValue(":input_code", input_storageEntity.INPUT_CODE);
temp_storageEntity = new EntityTemp_storage();
//赋值实体类
temp_storageEntity.Count = (int)textBox_input_standard_count.Value - oldCount;
try
{
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
//打开事务
dataAccess.BeginTransaction();
GetData getData1 = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result2 = getData1.UpdateInput_storageRow(input_storageEntity, sp1);
result1 = getData1.UpdateTemp_storage(temp_storageEntity, sp);
//提交事务
dataAccess.Commit();
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("操作数据时发生错误，请检查数据库是否正常开启！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
//设置按钮状态
dataType = DataType.None;
SetButtonState();
//重新加载画面
BandingDgvCounter();
}
dataGridView_input_storage.Focus();
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/7/21 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
//判断入库编号不为空
if (txtMaintain_input_code.Text.Trim() == string.Empty || txtMaintain_input_code.Text == "双击选择入库编号...")
{
MessageBox.Show("入库编号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMaintain_input_code.Focus();
return;
}
//判断时间有效性
if (DateTime.Now.Date < dateMaintain_create_date.Value.Date)
{
MessageBox.Show("建档日期不可大于今天日期！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dateMaintain_create_date.Focus();
return;
}
if (inStorageDate > dateMaintain_create_date.Value.Date)
{
MessageBox.Show("建档日期不可小于入库日期！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dateMaintain_create_date.Focus();
return;
}
//判断非法字符
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
EntityMaintain entity = new EntityMaintain();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entity.Maintain_input_code = txtMaintain_input_code.Text;
entity.Maintain_application = txtMaintain_application.Text;
entity.Maintain_purpose = txtMaintain_purpose.Text;
entity.Maintain_quality = txtMaintain_quality.Text;
entity.Maintain_test_items = txtMaintain_test_items.Text;
entity.Maintain_characters = txtMaintain_characters.Text;
entity.Maintain_create_date = dateMaintain_create_date.Value.Date;
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
entity.Maintain_code = primaryKey.MakeCode("养护记录");
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertMaintainTable(entity);
//处理操作标示
EntityInput_storage inputStorageEntity = new EntityInput_storage();
inputStorageEntity.OPERATE_TYPE = '1';
inputStorageEntity.INPUT_CODE = txtMaintain_input_code.Text;
result = getData.UpdateOperate_typeByInput_codeRow(inputStorageEntity);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entity.Maintain_code = dgv.SelectedRows[0].Cells["Maintain_code"].Value.ToString();
entity.Maintain_input_code = txtMaintain_input_code.Text;
entity.Maintain_application = txtMaintain_application.Text;
entity.Maintain_purpose = txtMaintain_purpose.Text;
entity.Maintain_quality = txtMaintain_quality.Text;
entity.Maintain_test_items = txtMaintain_test_items.Text;
entity.Maintain_characters = txtMaintain_characters.Text;
entity.Maintain_create_date = dateMaintain_create_date.Value.Date;
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateMaintainTable(entity);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("操作数据时发生错误，请检查数据库是否正常开启！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
//关闭数据库连接
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();
//重新加载画面
BandingDgv();
}
private void btnCommit_Click(object sender, EventArgs e)
{
//判断非法字符
foreach (Control control in this.panel1.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
if (txtCompanyName.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("企业名称不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCompanyName.Focus();
return;
}
if (Util.CheckCompanyName(txtCompanyName.Text.Trim()))
{
MessageBox.Show("企业名称不能包含特殊字符！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCompanyName.Focus();
return;
}
if (txtBusinessLicence.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("营业执照不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtBusinessLicence.Focus();
return;
}
if (txtLicence.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("许可证编号不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtLicence.Focus();
return;
}
if (Util.CheckCompanyName(txtLicence.Text.Trim()))
{
MessageBox.Show("许可证编号不能包含特殊字符！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtLicence.Focus();
return;
}
companyEntity = new EntityCompany();
companyEntity.Company_name = txtCompanyName.Text;
companyEntity.Company_registered_address = txtRegisteredAddress.Text;
companyEntity.Company_rel_address = txtRelAddress.Text;
companyEntity.Company_business_licence = txtBusinessLicence.Text;
companyEntity.Company_licence = txtLicence.Text;
companyEntity.Company_artificial_person = txtArtificialPerson.Text;
companyEntity.Company_principal = txtPrincipal.Text;
companyEntity.Company_business_type = comboxBusinessType.Text;
companyEntity.Company_storage_address = txtStorageAddress.Text;
companyEntity.Company_postal_code = txtPostalCode.Text;
companyEntity.Company_fax = txtFax.Text;
companyEntity.Company_tel = txtTel.Text;
companyEntity.Company_bank = txtBank.Text;
companyEntity.Company_bank_num = txtBankNum.Text;
companyEntity.Company_tariff_num = txtTariffNum.Text;
companyEntity.Company_business_scope = txt_company_business_scope.Text;
companyEntity.Company_mobile = txtMobile.Text;
companyEntity.Company_quality_persion = txt_company_quality_persion.Text;
companyEntity.Company_style = cmb_company_style.Text;
try
{
dataAccess = new DataAccess();
dataAccess.Open();
if (dataType == DataType.Insert)
{
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
companyEntity.Company_code = primaryKey.MakeCode("公司");
companyCode = companyEntity.Company_code;
GetData getData = new GetData(dataAccess.Connection);
//取得结果符
result = getData.InsertCompanyRow(companyEntity);
dataType = DataType.Update;
}
else if (dataType == DataType.Update)
{
//打开事务
dataAccess.BeginTransaction();
companyEntity.Company_code = companyCode;
//取得操作类
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateCompanyTable(companyEntity);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
MessageBox.Show(ex.Message);
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
if (result == 0)
{
MessageBox.Show("数据已保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (result == -1)
{
MessageBox.Show("数据提交失败,请检查数据库是否打开，添加信息是否正确！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/07/13 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
if (txtMaker_name.Text.Trim() == string.Empty)
{
MessageBox.Show("生产厂家名称不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMaker_name.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;
}
}
}
EntityMaker entityMaker = new EntityMaker();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entityMaker.Maker_code = txtMaker_code.Text;
entityMaker.Maker_name = txtMaker_name.Text;
entityMaker.Maker_yxm = txtMaker_yxm.Text;
entityMaker.Maker_address = txtMaker_address.Text;
entityMaker.Maker_quality_reg = txtMaker_quality_reg.Text;
entityMaker.Maker_hygiene = txtMaker_hygiene.Text;
entityMaker.Maker_licence = txtMaker_licence.Text;
entityMaker.Maker_tel = txtMaker_tel.Text;
entityMaker.Maker_principal = txtMaker_principal.Text;
entityMaker.Maker_postal_code = txtMaker_postal_code.Text;
entityMaker.Maker_business_scope = txtMaker_business_scope.Text;
entityMaker.Maker_business_goods = txtMaker_business_goods.Text;
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
entityMaker.Maker_code = primaryKey.MakeCode("生产厂家");
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertMaker(entityMaker);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entityMaker.Maker_code = txtMaker_code.Text;
entityMaker.Maker_name = txtMaker_name.Text;
entityMaker.Maker_yxm = txtMaker_yxm.Text;
entityMaker.Maker_address = txtMaker_address.Text;
entityMaker.Maker_quality_reg = txtMaker_quality_reg.Text;
entityMaker.Maker_hygiene = txtMaker_hygiene.Text;
entityMaker.Maker_licence = txtMaker_licence.Text;
entityMaker.Maker_tel = txtMaker_tel.Text;
entityMaker.Maker_principal = txtMaker_principal.Text;
entityMaker.Maker_postal_code = txtMaker_postal_code.Text;
entityMaker.Maker_business_scope = txtMaker_business_scope.Text;
entityMaker.Maker_business_goods = txtMaker_business_goods.Text;
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateMaker(entityMaker);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
}
finally
{
//关闭数据库连接
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();
//重新加载画面
BandingDgv();
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/07/13 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
if (txtCustomer_name.Text.Trim() == string.Empty)
{
MessageBox.Show("客户名称不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_name.Focus();
return;
}
if (cb_customer_type.SelectedIndex == 0)
{
MessageBox.Show("客户性质不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
cb_customer_type.Focus();
return;
}
//判断非法字符
foreach (Control control in groupBox1.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
EntityCustomer entityCustomer = new EntityCustomer();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entityCustomer.Customer_name = txtCustomer_name.Text;
entityCustomer.Customer_yxm = txtCustomer_yxm.Text;
entityCustomer.Customer_artificial_person = txtCustomer_artificial_person.Text;
entityCustomer.Customer_bank = txtCustomer_bank.Text;
entityCustomer.Customer_bank_num = txtCustomer_bank_num.Text;
entityCustomer.Customer_address = txtCustomer_address.Text;
entityCustomer.Customer_principal = txtCustomer_principal.Text;
entityCustomer.Customer_tariff_num = txtCustomer_tariff_num.Text;
entityCustomer.Customer_licence = txtCustomer_licence.Text;
entityCustomer.Customer_business_licence = txtCustomer_business_licence.Text;
entityCustomer.Customer_tel = txtCustomer_tel.Text;
entityCustomer.Customer_fax = txtCustomer_fax.Text;
entityCustomer.Customer_postal_code = txtCustomer_postal_code.Text;
entityCustomer.Customer_medical_institutions = txtCustomer_medical_institutions.Text;
entityCustomer.Customer_quality = txtCustomer_quality.Text;
entityCustomer.Customer_type = cb_customer_type.Text;
entityCustomer.Customer_flag = "0";
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
entityCustomer.Customer_code = primaryKey.MakeCode("客户");
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertCustomer(entityCustomer);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgvCustomer.SelectedRows[0].Index;
entityCustomer.Customer_code = txtCustomer_code.Text;
entityCustomer.Customer_name = txtCustomer_name.Text;
entityCustomer.Customer_yxm = txtCustomer_yxm.Text;
entityCustomer.Customer_artificial_person = txtCustomer_artificial_person.Text;
entityCustomer.Customer_bank = txtCustomer_bank.Text;
entityCustomer.Customer_bank_num = txtCustomer_bank_num.Text;
entityCustomer.Customer_address = txtCustomer_address.Text;
entityCustomer.Customer_principal = txtCustomer_principal.Text;
entityCustomer.Customer_tariff_num = txtCustomer_tariff_num.Text;
entityCustomer.Customer_licence = txtCustomer_licence.Text;
entityCustomer.Customer_business_licence = txtCustomer_business_licence.Text;
entityCustomer.Customer_tel = txtCustomer_tel.Text;
entityCustomer.Customer_fax = txtCustomer_fax.Text;
entityCustomer.Customer_postal_code = txtCustomer_postal_code.Text;
entityCustomer.Customer_medical_institutions = txtCustomer_medical_institutions.Text;
entityCustomer.Customer_quality = txtCustomer_quality.Text;
entityCustomer.Customer_type = cb_customer_type.Text;
entityCustomer.Customer_flag = "0";
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateCustomer(entityCustomer);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BandingDgv();
}
else
{
MessageBox.Show("数据保存时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
}
private void btnCommit_Click(object sender, EventArgs e)
{
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (control.Name != "txtStaffIntroduction")
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
}
if (txt_staff_contract_num.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("合同编号不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_staff_contract_num.Focus();
return;
}
if (txtStaffName.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("员工姓名不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtStaffName.Focus();
return;
}
//if (Util.GetByteLength(txtStaffName.Text.Trim()) > 10)
//{
// MessageBox.Show("员工姓名过长！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// txtStaffName.Focus();
// return;
//}
if (txtStaffCard.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("身份证号不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtStaffCard.Focus();
return;
}
if (!Util.CheckIdCard(txtStaffCard.Text.Trim()))
{
MessageBox.Show("身份证格式不正确！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtStaffCard.Focus();
return;
}
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
staffEntity = new EntityStaff();
staffEntity.Staff_name = txtStaffName.Text.Trim();
staffEntity.Staff_yxm = Util.IndexCode(txtStaffName.Text.Trim()).ToUpper();
staffEntity.Staff_sex = comBoxSex.Text;
staffEntity.Staff_birthday = DateTime.Parse(dateTimeBrithday.Value.ToString("yyyy-MM-dd"));
staffEntity.Staff_card = txtStaffCard.Text.Trim();
staffEntity.Staff_edu = comBoxStaffEdu.Text;
staffEntity.Staff_tel = txtTel.Text.Trim();
staffEntity.Staff_introduction = txtStaffIntroduction.Text;
staffEntity.Staff_dep = txt_staff_dep.Text;
staffEntity.Staff_contract_num = txt_staff_contract_num.Text;
staffEntity.Staff_specialities = txt_staff_specialities.Text;
staffEntity.Staff_job_title = txt_staff_job_title.Text;
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
staffEntity.Staff_code = primaryKey.MakeCode("员工");
//取得操作类
GetData getData = new GetData(dataAccess.Connection);
if (getData.InsertIsOnly("tc_staff", "staff_contract_num", Util.ChangeForSqlString(txt_staff_contract_num.Text.Trim())))
{
MessageBox.Show("您输入的合同编号已经存在！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_staff_contract_num.Focus();
return;
}
if (getData.InsertIsOnly("tc_staff", "staff_card", Util.ChangeForSqlString(txtStaffCard.Text.Trim())))
{
MessageBox.Show("您输入的身份证号已经存在！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtStaffCard.Focus();
return;
}
//取得结果符
result = getData.InsertStaffRow(staffEntity);
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("操作添加时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (dataType == DataType.Update)
{
if (dgvStaff.SelectedRows != null && dgvStaff.SelectedRows.Count != 0)
{
countNum = dgvStaff.SelectedRows[0].Index;
}
//赋值实体类
staffEntity = new EntityStaff();
staffEntity.Staff_code = txtStaffCode.Text.Trim();
staffEntity.Staff_name = txtStaffName.Text.Trim();
staffEntity.Staff_yxm = Util.IndexCode(txtStaffName.Text.Trim()).ToUpper();
staffEntity.Staff_sex = comBoxSex.Text;
staffEntity.Staff_birthday = DateTime.Parse(dateTimeBrithday.Value.ToString("yyyy-MM-dd"));
staffEntity.Staff_card = txtStaffCard.Text.Trim();
staffEntity.Staff_edu = comBoxStaffEdu.Text;
staffEntity.Staff_tel = txtTel.Text.Trim();
staffEntity.Staff_introduction = txtStaffIntroduction.Text;
staffEntity.Staff_job_title = txt_staff_job_title.Text;
staffEntity.Staff_dep = txt_staff_dep.Text;
staffEntity.Staff_contract_num = txt_staff_contract_num.Text;
staffEntity.Staff_specialities = txt_staff_specialities.Text;
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
//打开事务
dataAccess.BeginTransaction();
//取得操作类
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
if (getData.UpdateIsOnly("tc_staff", "Staff_code", staffEntity.Staff_code, "staff_contract_num", Util.ChangeForSqlString(txt_staff_contract_num.Text.Trim())))
{
MessageBox.Show("您输入的合同编号已经存在！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_staff_contract_num.Focus();
return;
}
if (getData.UpdateIsOnly("tc_staff", "Staff_code", staffEntity.Staff_code, "staff_card", Util.ChangeForSqlString(txtStaffCard.Text.Trim())))
{
MessageBox.Show("您输入的身份证号已经存在！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtStaffCard.Focus();
return;
}
//取得结果符
result = getData.UpdateStaffTable(staffEntity);
//提交事务
dataAccess.Commit();
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("操作修改时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
MessageBox.Show("操作数据时发生错误，请检查数据库是否正常开启！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
dataAccess.Close();
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
BandingDgvStaff();
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/11/8 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
//判断客户编号不能为空
if (txtCustomer_usecode.Text.Trim() == string.Empty)
{
MessageBox.Show("客户编号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_usecode.Focus();
return;
}
//判断客户名称不能为空
if (txtCustomer_name.Text.Trim() == string.Empty)
{
MessageBox.Show("客户姓名不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_name.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;
}
}
}
EntityCustomer entityCustomer = new EntityCustomer();
EntityArchives entityArchives = new EntityArchives();
int result1 = -1;
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
//向客户实体类添加数据
entityCustomer.Customer_name = txtCustomer_name.Text;
entityCustomer.Customer_yxm = txtCustomer_yxm.Text;
entityCustomer.Customer_tel = txtCustomer_tel.Text;
entityCustomer.Customer_address = txtCustomer_address.Text;
//向档案实体类添加数据
entityArchives.Customer_age = txtCustomer_age.Text;
entityArchives.Customer_usecode = txtCustomer_usecode.Text;
entityArchives.Customer_sex = cbCustomer_sex.Text;
//添加标识, "1",固定为个人客户
entityCustomer.Customer_flag = "1";
dataAccess = new DataAccess();
dataAccess.Open();
GetData getData = new GetData(dataAccess.Connection);
if (getData.InsertIsOnly("tc_archives", "customer_usecode", txtCustomer_usecode.Text.Trim()))
{
MessageBox.Show("您输入的客户编号已经存在！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_usecode.Focus();
return;
}
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
string code = primaryKey.MakeCode("客户");
entityCustomer.Customer_code = code;
entityArchives.Customer_code = code;
result = getData.InsertCustomer(entityCustomer);
result1 = getData.InsertArchives(entityArchives);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entityCustomer.Customer_code = dgv.SelectedRows[0].Cells["CUSTOMER_code"].Value.ToString();
entityCustomer.Customer_name = txtCustomer_name.Text;
entityCustomer.Customer_yxm = txtCustomer_yxm.Text;
entityCustomer.Customer_tel = txtCustomer_tel.Text;
entityCustomer.Customer_address = txtCustomer_address.Text;
//添加标识, "1",固定为个人客户
entityCustomer.Customer_flag = "1";
//向档案实体类添加数据
entityArchives.Customer_age = txtCustomer_age.Text;
entityArchives.Customer_usecode = txtCustomer_usecode.Text;
entityArchives.Customer_sex = cbCustomer_sex.Text;
entityArchives.Customer_code = entityCustomer.Customer_code;
entityArchives.Archives_id = Convert.ToInt32(dgv.SelectedRows[0].Cells["Archives_id"].Value.ToString());
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//判断客户编号重复
if (getData.UpdateIsOnly("tc_archives", "Archives_id", entityArchives.Archives_id.ToString(), "customer_usecode", txtCustomer_usecode.Text.Trim()))
{
MessageBox.Show("您输入的客户编号已经存在！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_usecode.Focus();
return;
}
//取得结果符
result = getData.UpdateCustomer(entityCustomer);
result1 = getData.UpdateArchives(entityArchives);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
if (result == 0 && result1 == 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/15 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnSave_Click(object sender, EventArgs e)
{
foreach (Control control in groupBox1.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
if (this.txt_unit_name.Text.Trim() == string.Empty)
{
MessageBox.Show("计量单位不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.txt_unit_name.Focus();
return;
}
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
//取得实体类
unitEntity = new EntityUnit();
//赋值实体类
unitEntity.Unit_name = this.txt_unit_name.Text.ToString().Trim();
unitEntity.Unit_yxm = this.txt_unit_yxm.Text.ToString().Trim();
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey mpk = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
unitEntity.Unit_code = mpk.MakeCode("计量单位");
//取得操作类
GetData getData = new GetData(dataAccess.Connection);
if (getData.InsertIsOnly("tc_unit", "unit_name", txt_unit_name.Text.ToString()))
{
MessageBox.Show("您输入的计量单位已经存在！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_unit_name.Focus();
return;
}
//取得结果符
result = getData.InsertUnitRow(unitEntity);
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("操作添加时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//如果是更新
else if (dataType == DataType.Update)
{
countNum = dgvUnit.SelectedRows[0].Index;
//取得树体类
unitEntity = new EntityUnit();
//赋值实体类
unitEntity.Unit_code = dgvUnit.SelectedRows[0].Cells["unit_code"].Value.ToString();
unitEntity.Unit_name = txt_unit_name.Text.ToString().Trim();
unitEntity.Unit_yxm = txt_unit_yxm.Text.ToString().Trim();
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
//打开事务
dataAccess.BeginTransaction();
//取得操作类
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
if (getData.UpdateIsOnly("tc_unit", "unit_code", unitEntity.Unit_code, "unit_name", txt_unit_name.Text.ToString()))
{
MessageBox.Show("您输入的计量单位已经存在！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_unit_name.Focus();
return;
}
//取得结果符
result = getData.UpdateUnitTable(unitEntity);
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("操作添加时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
//关闭数据库连接
dataAccess.Close();
//设置按钮状态
dataType = DataType.None;
setButtonState();
//重新加载画面
BandingDgvUnit();
}
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/7/15 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
//判断有效期不能为空
//判断产品名称不能为空
if (txtGoods_name.Text.Trim() == string.Empty)
{
MessageBox.Show("产品名称不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtGoods_name.Focus();
return;
}
if (txtGoods_appliance_code.Text.Trim() == string.Empty || txtGoods_appliance_code.Text == "双击选择器械分类...")
{
MessageBox.Show("器械分类不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtGoods_appliance_code.Focus();
return;
}
//判断注册证号不能为空
if (txtGoods_reg_num.Text.Trim() == string.Empty)
{
MessageBox.Show("注册证号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtGoods_reg_num.Focus();
return;
}
//判断生产厂家不能为空
if (txtGoods_maker.Text.Trim() == string.Empty || txtGoods_maker.Text == "双击选择生产厂家...")
{
MessageBox.Show("生产厂家不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtGoods_maker.Focus();
return;
}
//判断规格型号不能为空
if (txtGoods_type.Text.Trim() == string.Empty)
{
MessageBox.Show("规格型号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtGoods_type.Focus();
return;
}
if (txtGoods_validity.Text.Trim() == string.Empty)
{
MessageBox.Show("有效期不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtGoods_validity.Focus();
return;
}
if (int.Parse(txtGoods_validity.Text.Trim()) == 0)
{
MessageBox.Show("有效期不能为0！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtGoods_validity.Focus();
return;
}
//判断储藏方法不能为空
if (txtGoods_storemethod.Text.Trim() == string.Empty)
{
MessageBox.Show("储藏方法不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtGoods_storemethod.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;
}
}
}
EntityGoods entityGoods = new EntityGoods();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entityGoods.Goods_name = txtGoods_name.Text;
entityGoods.Goods_yxm = txtGoods_yxm.Text;
entityGoods.Goods_reg_num = txtGoods_reg_num.Text;
entityGoods.Goods_reg_mark = txtGoods_reg_mark.Text;
entityGoods.Goods_type = txtGoods_type.Text;
entityGoods.Goods_maker = txtMaker_code.Text;
entityGoods.Goods_validity = Convert.ToInt32(txtGoods_validity.Text.Trim());
entityGoods.Goods_unit = cb_goods_unit.SelectedValue.ToString();
entityGoods.Goods_storemethod = txtGoods_storemethod.Text;
entityGoods.Goods_appliance_code = txtGoods_appliance_code.Text;
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
entityGoods.Goods_code = primaryKey.MakeCode("产品");
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertGoods(entityGoods);
if (result == 0)
{
EntityTemp_storage entityTemp = new EntityTemp_storage();
entityTemp.Goods_code = entityGoods.Goods_code;
getData.InsertTemp_storageTable(entityTemp);
}
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entityGoods.Goods_code = txtGoods_code.Text;
entityGoods.Goods_name = txtGoods_name.Text;
entityGoods.Goods_yxm = txtGoods_yxm.Text;
entityGoods.Goods_reg_num = txtGoods_reg_num.Text;
entityGoods.Goods_reg_mark = txtGoods_reg_mark.Text;
entityGoods.Goods_type = txtGoods_type.Text;
entityGoods.Goods_maker = txtMaker_code.Text;
entityGoods.Goods_validity = Convert.ToInt32(txtGoods_validity.Text.Trim());
entityGoods.Goods_unit = cb_goods_unit.SelectedValue.ToString();
entityGoods.Goods_storemethod = txtGoods_storemethod.Text;
entityGoods.Goods_appliance_code = txtGoods_appliance_code.Text;
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateGoods(entityGoods);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
//关闭数据库连接
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();
}
