Пример #1
0
        private void PurchaseOrder_Load(object sender, EventArgs e)
        {
            dtpDate.Value  = DateTime.Now;
            panel2.Visible = false;
            SqlConnection con    = dbMainClass.openConnection();
            string        stlect = "select  Orderid from VendorOrderDetails";
            DataTable     dt     = dbMainClass.getDetailByQuery(stlect);
            string        id     = "";

            foreach (DataRow dr in dt.Rows)
            {
                id = dr[0].ToString();
            }
            //txtSrNo.Text = id;
            if (id == "")
            {
                //int txt = Convert.ToInt32(id);
                //int txt1 = txt + 1;
                id           = "1";
                txtSrNo.Text = id;
            }
            else
            {
                int txt  = Convert.ToInt32(id);
                int txt1 = txt + 1;
                txtSrNo.Text = txt1.ToString();
            }

            Purchase.PurchaseDetails purChaseDetailObj = new Purchase.PurchaseDetails();
            vendorDetails = purChaseDetailObj.GetVendorDetaisInDataTable();
            ItemDetails   = purChaseDetailObj.GetItemPriceAndNameDetaisInDataTable();
            setAutoCompleteMode(txtProductName, "ItemName", ItemDetails);
            setAddToCraftTable();
            //setAutoCompleteMode(txtVendorName, "Name", vendorDetails);
        }