Packing_NewPallet.cs 2.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879
  1. using System;
  2. using System.Data;
  3. using System.Windows.Forms;
  4. using UAS_MES_NEW.DataOperate;
  5. using UAS_MES_NEW.Entity;
  6. using UAS_MES_NEW.PublicMethod;
  7. namespace UAS_MES_NEW.Packing
  8. {
  9. public partial class Packing_NewPallet : CustomControl.BaseForm.BaseForm
  10. {
  11. DataHelper dh;
  12. DataTable Dbfind;
  13. //生成的箱类型,2表示大箱号,3表示栈板号
  14. string pa_type = "";
  15. string OutBoxCode1;
  16. public string OutBoxCode
  17. {
  18. get
  19. {
  20. return OutBoxCode1;
  21. }
  22. set
  23. {
  24. OutBoxCode1 = value;
  25. }
  26. }
  27. public Packing_NewPallet(string Caller, string MakeCode)
  28. {
  29. InitializeComponent();
  30. try { UAS_MES_NEW.I18n.LanguageManager.Localize(this); } catch { }
  31. pa_outboxcode.Caller = Caller;
  32. pa_outboxcode.MakeCode = MakeCode;
  33. }
  34. private void Make_NewPallet_Load(object sender, EventArgs e)
  35. {
  36. dh = new DataHelper();
  37. pr_code.FormName = Name;
  38. pr_code.SetValueField = new string[] { "pr_code" };
  39. pr_code.TableName = "product";
  40. pr_code.SelectField = "pr_code # 物料编号,pr_detail # 物料名称,pr_kind # 物料种类,pr_spec # 物料规格";
  41. pr_code.DbChange += Pr_code_DbChange;
  42. }
  43. private void Pr_code_DbChange(object sender, EventArgs e)
  44. {
  45. Dbfind = pr_code.ReturnData;
  46. BaseUtil.SetFormValue(this.Controls, Dbfind);
  47. }
  48. private void pr_code_UserControlTextChanged(object sender, EventArgs e)
  49. {
  50. pa_outboxcode.ProdCode = pr_code.Text;
  51. }
  52. private void Confirm_Click(object sender, EventArgs e)
  53. {
  54. if (pa_outboxcode.Text != "" && pr_code.Text != "")
  55. {
  56. string sql = "insert into package (pa_id,pa_outboxcode,pa_makecode,pa_indate,pa_type,pa_prodcode,pa_level,PA_STATUS,pa_sccode,pa_currentstep)values";
  57. sql += "(package_seq.nextval,'" + pa_outboxcode.Text + "','" + pa_outboxcode.MakeCode + "',sysdate,3,'" + pr_code.Text + "',0,0,'" + User.UserSourceCode + "','" + User.CurrentStepCode + "')";
  58. dh.ExecuteSql(sql, "insert");
  59. }
  60. else MessageBox.Show(UAS_MES_NEW.I18n.LanguageManager.T("请先填写完整信息"));
  61. }
  62. private void pa_outboxcode_UserControlTextChanged(object sender, EventArgs e)
  63. {
  64. OutBoxCode1 = pa_outboxcode.Text;
  65. }
  66. }
  67. }