示例#1
0
        private void button1_Click(object sender, EventArgs e)
        {
            switch (deptCode)
            {
            case "AM":
                this.Hide();
                EditMenu em = new EditMenu(this, 0);
                em.Show();
                break;

            case "RM":
                this.Hide();
                PurchaseRequest pr = new PurchaseRequest(this, restNo, StaffNo);
                pr.Show();
                break;

            case "PM":
                this.Hide();
                TypeofAgreementMenu tam = new TypeofAgreementMenu(staffName, this);
                tam.Show();
                break;

            case "CM":
                this.Hide();
                Category cat = new Category(this);
                cat.Show();
                break;

            case "WC":
                this.Hide();
                WHViewDPI dpi = new WHViewDPI(this);
                dpi.Show();
                break;

            case "AD":
                this.Hide();
                TypeofAgreementMenu adtam = new TypeofAgreementMenu(staffName, this);
                adtam.Show();
                break;
            }
        }
        public WHGenerateDN(WHViewDPI vDPI, String iId, String rno, String status)
        {
            InitializeComponent();
            this.vDPI   = vDPI;
            this.iId    = iId;
            this.rno    = rno;
            this.status = status;
            cnn.Open();
            MySqlDataAdapter sda = new MySqlDataAdapter("SELECT Distinct DI.ItemID, ItemName,ItemDescription, DI.quantity as Needs, DI.quantity, S.quantity as Stock FROM DespatchInstruction DI, WarehouseStock_new S, Item I WHERE DI.ItemID=I.ItemID and DI.ItemID=S.ItemID and DesID = '" + iId + "';", cnn);
            DataTable        dt  = new DataTable();

            sda.Fill(dt);
            dGVItem.DataSource = dt;
            int i = 0;

            maxQty = new int[dGVItem.RowCount];
            stock  = new int[dGVItem.RowCount];
            foreach (DataGridViewRow row in dGVItem.Rows)
            {
                int    quantity = Convert.ToInt32(row.Cells["quantity"].Value);
                String itemID   = Convert.ToString(row.Cells["ItemID"].Value);
                stock[i] = Convert.ToInt32(row.Cells["Stock"].Value);
                MySqlCommand getQuantity = new MySqlCommand("Select quantity from DespatchInstruction WHERE ItemID = '" + itemID + "' and DesID = '" + iId + "';", cnn);
                maxQty[i] = Convert.ToInt32(getQuantity.ExecuteScalar());
                if (quantity > stock[i])
                {
                    row.Cells["quantity"].Value = stock[i];
                }
                i++;
            }
            MySqlDataAdapter getDID = new MySqlDataAdapter("select Distinct Max(DeliveryID) from DeliveryNote;", cnn);
            DataTable        dt2    = new DataTable();

            if (status.Equals("FIN"))
            {
                btnGen.Enabled = false;
                lbDID.Text     = "";
                MySqlDataAdapter getDeliveryID = new MySqlDataAdapter("Select DeliveryID from DeliveryNote WHERE DesID = '" + iId + "';", cnn);
                DataTable        dt3           = new DataTable();
                getDeliveryID.Fill(dt3);
                foreach (DataRow dr in dt3.Rows)
                {
                    lbDID.Text += Convert.ToString(dr[0]) + ", ";
                }
            }
            else
            {
                String did;
                getDID.Fill(dt2);
                did = dt2.Rows[0][0].ToString();
                if (did.Equals(""))
                {
                    did = "0";
                }
                did        = Regex.Match(did, @"\d+").Value;
                lbDID.Text = "D" + (Int32.Parse(did) + 1).ToString().PadLeft(7, '0');
            }
            MySqlDataAdapter getRest  = new MySqlDataAdapter("Select RestName, RestAddress From PurchaseRequest pr, Restaurant r where RequestNo = '" + rno + "' and pr.restNo=r.restNo;", cnn);
            DataTable        restInfo = new DataTable();

            getRest.Fill(restInfo);
            numQty.Maximum = 0;
            lbRName.Text   = restInfo.Rows[0][0].ToString();
            lbAddress.AppendText(restInfo.Rows[0][1].ToString());
            lbCreationDate.Text = today.ToString("yyyy-MM-dd");
            lbStatus.Text       = status;
            lbDesId.Text        = iId;
            lbRNo.Text          = rno;
            cnn.Close();
            btnUpdate.Enabled = false;
        }