public int InsertOutput_storageRow(EntityOutput_storage outputStorage) { string SqlStr = ""; SqlStr = "INSERT INTO TC_OUTPUT_STORAGE " + "(OUTPUT_CODE ,input_code ,customer_code ,output_count ,output_check_persion" + ",output_oper ,output_quality_persion ,output_issued ,output_packing_in ,output_packing_mid" + ",output_packing_out ,output_remark ,output_instorage_date ,output_checktime ,output_type" + ",output_backreason ,operate_type)"; SqlStr += " VALUES ('" + outputStorage.Output_code.Trim() + "','" + outputStorage.Input_code.Trim() + "','" + outputStorage.Customer_code.Trim() + "'," + "" + outputStorage.Output_count + ",'" + outputStorage.Output_check_persion.Trim() + "','" + outputStorage.Output_oper.Trim() + "','" + outputStorage.Output_quality_persion.Trim() + "'" + ",'" + outputStorage.Output_issued.Trim() + "','" + outputStorage.Output_packing_in.Trim() + "','" + outputStorage.Output_packing_mid.Trim() + "','" + outputStorage.Output_packing_out.Trim() + "'" + ",'" + outputStorage.Output_remark.Trim() + "','" + outputStorage.Output_instorage_date + "','" + outputStorage.Output_checktime + "'," + outputStorage.Output_type.Trim() + "" + ",'" + outputStorage.Output_backreason.Trim() + "','" + outputStorage.Operate_type.Trim() + "')"; SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = SqlStr; try { ExcuteSql(sqlCommand); } catch { return(Constants.SystemConfig.SERVER_ERROR); } return(Constants.SystemConfig.SERVER_SUCCESS); }
public int UpdateOutput_storage(EntityOutput_storage entity, SearchParameter sp) { //设置更新出库表SQL语句 string SqlStr = ""; SqlStr = "update tc_output_storage"; SqlStr += " set operate_type= '" + entity.Operate_type.Trim() + "'"; ArrayList arrayList = sp.Keys(); switch (sp.GetHashTable[arrayList[0]].GetType().Name) { case "String": SqlStr += " where " + arrayList[0].ToString().Replace(":", "") + " like '" + sp.GetValue(arrayList[0].ToString()) + "%'"; break; case "Int32": SqlStr += " where " + arrayList[0].ToString().Replace(":", "") + "= " + sp.GetValue(arrayList[0].ToString()) + ""; break; default: SqlStr += " where " + arrayList[0].ToString().Replace(":", "") + " like '" + sp.GetValue(arrayList[0].ToString()) + "%'"; break; } SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = SqlStr; //执行SQL语句 ExcuteSql(sqlCommand); //返回操作成功结果 return(Constants.SystemConfig.SERVER_SUCCESS); }
//*********************************************************************** /// <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/7/26 完成 /// 更新信息: /// </history> //*********************************************************************** private void btnDelete_Click(object sender, EventArgs e) { result = -1; countNum = 0; if (dgv.SelectedRows.Count > 1) { MessageBox.Show("只能选择一条要删除的记录!", Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (dgv.SelectedRows.Count < 1) { MessageBox.Show("请选择一条要删除的记录!", Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBox.Show("您确定要删除该数据吗?", Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { try { SearchParameter sp = new SearchParameter(); sp.SetValue(":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.DeleteRow("tc_apparatus_quality", sp); dataAccess.Commit(); } catch (Exception ex) { dataAccess.Rollback(); MessageBox.Show(ex.Message); throw ex; } finally { dataAccess.Close(); } if (result == 0) { if (!updateMark()) { try { dataAccess = new DataAccess(); dataAccess.Open(); GetData getData = new GetData(dataAccess.Connection); //处理操作标示 EntityOutput_storage outputStorageEntity = new EntityOutput_storage(); outputStorageEntity.Operate_type = "0"; SearchParameter sp = new SearchParameter(); sp.SetValue(":output_code", txtApparatus_quality_output_code.Text); result = getData.UpdateOutput_storage(outputStorageEntity, sp); } catch (Exception ex) { MessageBox.Show("请查看数据库是否正常!", Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { if (dataAccess.Connection != null) { dataAccess.Close(); } } } MessageBox.Show("数据已经被成功删除!", Text, MessageBoxButtons.OK, MessageBoxIcon.Information); BandingDgv(); } else { MessageBox.Show("数据删除时发生错误,请检查数据库!", Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
//*********************************************************************** /// <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(); }