Beispiel #1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            DataTable dtType = clsSELECT.TypeProduct("", this.cbbTypeProduct.Text.Trim()).Tables[0];
            string Type_ID = dtType.Rows[0]["Type_ID"].ToString();

            if (txtProductName.Text == "")
            {
                MessageBox.Show("กรุณาระบุชื่อสินค้าก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else if (txtID.Text == "")
            {
            MessageBox .Show ("กรุณาระบุรหัสสินค้าก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
                else if (txtGoodmin .Text == "")
            {
                MessageBox.Show("กรุณาระบุจุดสั่งซื้อของสินค้า!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                try
                {
                    var product = new clsPRODUCT();
                    product.Product_ID = this.txtID.Text.Trim();
                    product.Type_ID = Type_ID;
                    product.Product_Name = this.txtProductName.Text.Trim();
                    product.Good_Min = this.txtGoodmin.Text.Trim();

                    if (FUNCTION == "INSERT")
                    {
                        if (clsINSERT.PRODUCT(product) == true)
                        {
                            MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("ข้อมูลไม่ถูกต้อง", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                    }

                    else
                    {
                        if (clsUPDATE.PRODUCT(product) == true)
                        {
                            MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("ข้อมูลไม่ถูกต้อง", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                }
                catch (Exception ex) { MessageBox.Show(ex.Message); }

            } this.Close();
        }
Beispiel #2
0
        public static Boolean PRODUCT(clsPRODUCT M)
        {
            try
             {
                 StringBuilder sb = new StringBuilder();

                 sb.Remove(0, sb.ToString().Length);
                 sb.Append(" DELETE ");
                 sb.Append(" FROM PRODUCT ");
                 sb.Append(" WHERE Product_ID = '" + M.Product_ID + "'");

                 clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString());
                 return true;
             }
             catch (Exception ex) { return false; throw ex; }
        }
Beispiel #3
0
        public static Boolean PRODUCT(clsPRODUCT M)
        {
            try
            {
                StringBuilder sb = new StringBuilder();

                sb.Remove(0, sb.ToString().Length);
                sb.Append(" UPDATE PRODUCT ");
                sb.Append(" SET Product_Name =  '" + M.Product_Name + "' ");
                sb.Append(" ,Pricebuy =  '" + M.Pricebuy + "' ");
                sb.Append(" ,Pricesale =  '" + M.Pricesale + "'");
                sb.Append(" ,Total =  '" + M.Total + "'");
                sb.Append(" ,Type_ID =  '" + M.Type_ID + "' ");
                sb.Append(" ,Dealer_ID =  '" + M.Dealer_ID + "' ");
                sb.Append(" WHERE Product_ID =  '" + M.Product_ID + "' ");

                clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString());
                return true;
            }
            catch (Exception ex) { return false; throw ex; }
        }
Beispiel #4
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (txtSale .Text == "")
            {
                MessageBox.Show("กรุณาระบุราคาขายสินค้าก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            int a = Convert.ToInt32(txtSale.Text);
            int b = Convert.ToInt32(Math.Floor(Convert.ToDouble(txtPrice.Text)));
            if (a < b)
            {
                MessageBox.Show("ราคาทุนมากกกว่าราคาขาย!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }

            else
            {
                try
                {
                    var Price = new clsPRODUCT();
                    Price.Product_ID = this.txtID.Text.Trim();
                    Price.Product_Name = this.txtProductName.Text.Trim();
                    Price.Pricesale = this.txtSale.Text.Trim();

                    if (action == "")
                    {
                        if (clsUPDATE.PRICESALE(Price) == true)
                        {
                            MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("ข้อมูลไม่ถูกต้อง", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                    }
                }
                catch (Exception ex) { MessageBox.Show(ex.Message); }
            }
        }
Beispiel #5
0
        private void button2_Click(object sender, EventArgs e)
        {
            var Product = new clsPRODUCT();
            Product.Product_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_ID"].Value.ToString().Trim();
            Product.Product_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_Name"].Value.ToString().Trim();
            Product.Type_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Type_ID"].Value.ToString().Trim();
            Product.Good_Min = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Good_min"].Value.ToString().Trim();

            //dgvView.Columns ("Pricebuy").DefaultCellStyle.Format = "#,##0.00";
            if (MessageBox.Show("ต้องการลบข้อมูลใช่หรือไม่", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {

                if (clsDELETE.PRODUCT (Product) == true)
                {
                    MessageBox.Show("ลบข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("เกิดข้อผิดพลาดในการลบข้อมูล", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
                }
                btnSearch_Click(sender, e);
            }
        }
Beispiel #6
0
        private void button2_Click(object sender, EventArgs e)
        {
            var Product = new clsPRODUCT();
            Product.Product_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_ID"].Value.ToString().Trim();
            Product.Product_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_Name"].Value.ToString().Trim();
            Product.Pricebuy = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Pricebuy"].Value.ToString().Trim();
            Product.Pricesale = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Pricesale"].Value.ToString().Trim();
            Product.Total = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Total"].Value.ToString().Trim();
            Product.Dealer_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Dealer_ID"].Value.ToString().Trim();
            Product.Type_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Type_ID"].Value.ToString().Trim();
            if (MessageBox.Show("ต้องการลบข้อมูลใช่หรือไม่", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {

                if (clsDELETE.PRODUCT (Product) == true)
                {
                    MessageBox.Show("DE OK", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("DE NOT OK", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
                }
                btnSearch_Click(sender, e);
            }
        }
Beispiel #7
0
        private void btnConfirm_Click(object sender, EventArgs e)
        {
            try
            {

                var Order = new clsORDER();
                Order.Order_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Order_ID"].Value.ToString().Trim();
                Order.Product_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_ID"].Value.ToString().Trim();
                Order.Product_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_Name"].Value.ToString().Trim();
                Order.Price = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Price"].Value.ToString().Trim();
                Order.Total = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Total"].Value.ToString().Trim();

                var Stock = new clsPRODUCT();
                Stock.Product_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_ID"].Value.ToString().Trim();
                Stock.Product_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_Name"].Value.ToString().Trim();
                Stock.Total = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Total"].Value.ToString().Trim();

                if (MessageBox.Show("ต้องการบันทึกข้อมูลใช่หรือไม่", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {

                if (action == "")
                {  //รับสินค้า
                    StringBuilder sb = new StringBuilder();
                    sb.Append("INSERT INTO DELIVERY(DELIVERY_ID ,Dealer_ID ,DELIVERY_Date ,Mem_ID)");
                    sb.Append("VALUES (");
                    sb.Append(" '" + lbID.Text.Trim() + "' ");
                    sb.Append(" ,'" + txtDeler .Text.Trim() + "' ");
                    sb.Append(" ,'" + dtpDateReceive.Value.ToString("MM/dd/yyyy", cConfigAtt.formatEn) + "'");
                    sb.Append(" ,'" + lblMID.Text.Trim() + "' ) ");
                    clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString());

                    StringBuilder sbDetail = new StringBuilder();

                    foreach (DataGridViewRow row in dgvView.Rows)
                    {  //รายละเอียดการรับ
                        sbDetail.Append(" INSERT INTO DETAIL_DELIVERY(DELIVERY_ID ,Product_ID,Price ,Total )");
                        sbDetail.Append(" VALUES( ");
                        sbDetail.Append(" '" + lbID.Text.Trim() + "' ");
                        sbDetail.Append(", '" + row.Cells["Product_ID"].Value.ToString() + "' ");
                        sbDetail.Append(", '" + row.Cells["Price"].Value.ToString() + "' ");
                        sbDetail.Append(", '" + row.Cells["TotalDerivery"].Value.ToString() + "' ");
                        sbDetail.Append(" ); ");

                        if (action1 == "") // เพิ่มสินค้าเข้าสต๊อก
                        {
                            StringBuilder sbUPSTOCK = new StringBuilder();
                            sbUPSTOCK.Append("update dbo.PRODUCT set Total =  ");
                            sbUPSTOCK.Append("Total + " + row.Cells["TotalDerivery"].Value.ToString());
                            sbUPSTOCK.Append(" where  Product_ID = '" + row.Cells["Product_ID"].Value.ToString() + "'" );
                            clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sbUPSTOCK.ToString());
                        }

                    }
                    clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sbDetail.ToString());

                }

                if (clsUPDATE.DERIVERYOK(Order) == true) // อัพเดดสถานะ
                {

                        MessageBox.Show("บันทึกข้อมูลเรียบร้อยแล้ว", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);

                 }

                else
                {
                    MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
                }
            }
            }
            catch (Exception) { MessageBox.Show("เกิดข้อผิดพลาดในการรับสินค้า!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); }
        }
Beispiel #8
0
        public static Boolean PRODUCT(clsPRODUCT M)
        {
            try
            {
                StringBuilder sb = new StringBuilder();

                sb.Remove(0, sb.ToString().Length);
                sb.Append(" INSERT INTO PRODUCT ");
                sb.Append(" (Dealer_ID ");
                sb.Append(" ,Type_ID ");
                sb.Append(" ,Product_Name ");
                sb.Append(" ,Pricebuy ");
                sb.Append(" ,Pricesale ");
                sb.Append(" ,Total )");
                sb.Append(" VALUES ");
                sb.Append(" ('" + M.Dealer_ID  + "' ");
                sb.Append(" ,'" + M.Type_ID + "' ");
                sb.Append(" ,'" + M.Product_Name + "' ");
                sb.Append(" ,'" + M.Pricebuy + "' ");
                sb.Append(" ,'" + M.Pricesale + "' ");
                sb.Append(" ,'" + M.Total+ "') ");

                clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString());
                return true;
            }
            catch (Exception ex) { return false; throw ex; }
        }
Beispiel #9
0
        public static Boolean STOCK(clsPRODUCT S)
        {
            try
            {
                StringBuilder sb = new StringBuilder();

                sb.Remove(0, sb.ToString().Length);
                sb.Append(" UPDATE PRODUCT ");
                sb.Append(" SET Total =  '" + S.Total  + "' ");
                sb.Append(" WHERE  Product_ID =  '" + S.Product_ID + "'  ");
                clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString());
                return true;

            }
            catch (Exception ex) { return false; throw ex; }
        }
Beispiel #10
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            DataTable dtType = clsSELECT.TypeProduct("", this.cbbTypeProduct.Text.Trim()).Tables[0];
            string Type_ID = dtType.Rows[0]["Type_ID"].ToString();

            DataTable dtDealer = clsSELECT.Dealer("", this.cbbDealer.Text.Trim()).Tables[0];
            string Dealer_ID = dtDealer.Rows[0]["Dealer_ID"].ToString();

             if (txtProductName .Text == "")
            {
                MessageBox.Show("กรุณาระบุชื่อตัวแทนจำหน่ายก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else if (txtCost .Text == "")
            {
                MessageBox.Show("กรุณาระบุราคาทุนก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else if (txtSele .Text == "")
            {
                MessageBox.Show("กรุณาระบุราคาขายก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else if (txtTotal.Text == "")
            {
                MessageBox.Show("กรุณาระบุจำนวนสินค้าในสต๊อกก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                try
                {
                    var product = new clsPRODUCT();
                    product.Product_ID = this.txtID.Text.Trim();
                    product.Dealer_ID = Dealer_ID;
                    product.Type_ID = Type_ID;
                    product.Product_Name = this.txtProductName.Text.Trim();
                    product.Pricebuy = this.txtCost.Text.Trim();
                    product.Pricesale = this.txtSele.Text.Trim();
                    product.Total = this.txtTotal.Text.Trim();

                    if (FUNCTION == "INSERT")
                    {
                        if (clsINSERT.PRODUCT(product) == true)
                        {
                            MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("ข้อมูลไม่ถูกต้อง", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                    }
                    else
                    {
                        if (clsUPDATE.PRODUCT(product) == true)
                        {
                            MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("ข้อมูลไม่ถูกต้อง", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                }
                catch (Exception ex) { MessageBox.Show(ex.Message); }
            }
        }