FrmDepotDialogNew.cs 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102
  1. using System;
  2. using System.Drawing;
  3. using System.Collections;
  4. using System.ComponentModel;
  5. using System.Windows.Forms;
  6. using Core.Mes.ClientFrameWork;
  7. using Core.Mes.IBaseInterface;
  8. using System.Data;
  9. using System.Runtime.InteropServices;
  10. using Core.XgMes.Client.JGKC.TurnoffSendManager;
  11. namespace Core.XgMes.Client.JGKC.MaterialManager
  12. {
  13. public partial class FrmDepotDialogNew : Mes.ClientFrameWork.FrmBase
  14. {
  15. public FrmDepotDialogNew()
  16. {
  17. InitializeComponent();
  18. }
  19. public void Init()
  20. {
  21. string err = "";
  22. string sql = "SELECT DEPOTID,DEPOTNAME,DEPOT_LB "
  23. + "FROM KCJ_DEPOTMAGAGER1 WHERE 1=1 "
  24. ;
  25. DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet", new object[] { sql }, out err);
  26. if (err == "")
  27. {
  28. ultraGrid1.DataSource = ds;
  29. }
  30. }
  31. public string strckdm = "";
  32. public string stckmc = "";
  33. public string strcklb = "";
  34. private void btrqr_Click(object sender, EventArgs e)
  35. {
  36. Infragistics.Win.UltraWinGrid.UltraGridRow row = ultraGrid1.ActiveRow;
  37. if (row.Selected) return;
  38. strckdm = row.Cells["DEPOTID"].Value.ToString();
  39. stckmc = row.Cells["DEPOTNAME"].Value.ToString();
  40. strcklb = row.Cells["DEPOT_LB"].Value.ToString();
  41. this.Close();
  42. }
  43. private void FrmDepotDialog_Load(object sender, EventArgs e)
  44. {
  45. Init();
  46. }
  47. private void button1_Click(object sender, EventArgs e)
  48. {
  49. string strWhere = "";
  50. string sql = "";
  51. string err = "";
  52. if (Chk_WZDM.Checked && txt_wzdm.Text.Trim().Length > 0)
  53. {
  54. strWhere += " AND DEPOTID LIKE '%" + txt_wzdm.Text.Trim().ToString() + "%' ";
  55. }
  56. if (chk_wz.Checked && txt_wz.Text.Trim().Length > 0)
  57. {
  58. strWhere += " AND DEPOTNAME LIKE '%" + txt_wz.Text.Trim().ToString() + "%' ";
  59. }
  60. if (Chk_CKLB.Checked && Cmb_LB.Text.Trim().Length > 0)
  61. {
  62. strWhere += " AND DEPOT_LB LIKE '%" + txt_wz.Text.Trim().ToString() + "%' ";
  63. }
  64. sql = "SELECT DEPOTID,DEPOTNAME,DEPOT_LB "
  65. + "FROM KCJ_DEPOTMAGAGER1 WHERE 1=1 " + strWhere
  66. ;
  67. DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet", new object[] { sql }, out err);
  68. if (err == "")
  69. {
  70. ultraGrid1.DataSource = ds;
  71. }
  72. }
  73. private void Chk_WZDM_CheckedChanged(object sender, EventArgs e)
  74. {
  75. txt_wzdm.Enabled = Chk_WZDM.Checked;
  76. }
  77. private void chk_wz_CheckedChanged(object sender, EventArgs e)
  78. {
  79. txt_wz.Enabled = chk_wz.Checked;
  80. }
  81. private void Chk_CKLB_CheckedChanged(object sender, EventArgs e)
  82. {
  83. Cmb_LB.Enabled = Chk_CKLB.Checked;
  84. }
  85. }
  86. }