//*********************************************************************** /// <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(); }