Beispiel #1
0
        private void btn_SelItemType_Click(object sender, EventArgs e)
        {
            DataSet set       = null;
            string  sErr      = "";
            string  sSql      = "";
            string  sFldsDate = "";
            Button  button    = (Button)sender;

            sSql           = "select cTypeId,cTypeName from TPC_MaterialType where ctypemode=0";
            sFldsDate      = "";
            Cursor.Current = Cursors.WaitCursor;
            set            = PubDBCommFuns.GetDataBySql(base.AppInformation.SvrSocket, sSql, sFldsDate, out sErr);
            Cursor.Current = Cursors.Default;
            if ((sErr.Trim() != "") && (sErr.Trim() != "0"))
            {
                MessageBox.Show(sErr);
            }
            else
            {
                frmSelItemList list  = new frmSelItemList();
                DataTable      table = set.Tables["data"];
                list.TableItem = table;
                list.TitleText = "物料类别选择";
                list.FldDesc   = "cTypeName";
                list.FldKey    = "cTypeId";
                list.ShowDialog();
                if (list.IsSelected)
                {
                    this.txt_ItemType.Text = list.SelectItemList;
                    this.txt_ItemType.Tag  = list.SelectKeyList;
                }
                list.Dispose();
                set.Clear();
            }
        }
Beispiel #2
0
        private void btn_SelItemType_Click(object sender, EventArgs e)
        {
            DataSet dsX      = null;
            string  sErr     = "";
            string  sSql     = "";
            string  sDateFld = "";
            Button  btnX     = (Button)sender;

            sSql           = "select cTypeId,cTypeName from TPC_MaterialType where ctypemode=0";
            sDateFld       = "";
            Cursor.Current = Cursors.WaitCursor;
            dsX            = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, sSql, sDateFld, out sErr);
            Cursor.Current = Cursors.Default;
            if (sErr.Trim() != "" && sErr.Trim() != "0")
            {
                MessageBox.Show(sErr);
                return;
            }
            frmSelItemList frmX = new frmSelItemList();
            //frmX.FldDesc = "cTypeName";
            //frmX.FldKey = "cTypeId";
            DataTable tbX = dsX.Tables["data"];

            frmX.TableItem = tbX;
            frmX.TitleText = "物料类别选择";
            frmX.FldDesc   = "cTypeName";
            frmX.FldKey    = "cTypeId";
            frmX.ShowDialog();
            if (frmX.IsSelected)
            {
                txt_ItemType.Text = frmX.SelectItemList;
                txt_ItemType.Tag  = frmX.SelectKeyList;
            }
            frmX.Dispose();
            dsX.Clear();
        }