Ejemplo n.º 1
0
        private void selectFormularMacth()
        {
            DialogReturnDamagnedReceive dr = new DialogReturnDamagnedReceive(chkFromCompany.Checked ? "1" : "0", Class.Function.GetTextId(textBox3.Text));//เรียกใช้ Dailog รับคืนสินค้าซ่อม(เสีย)
            dr.StartPosition = FormStartPosition.CenterScreen;
            dr.ShowDialog();

            if (dr.DialogResult == DialogResult.OK && dr.index != 0)
            {
                GetItem(dr);

                //txtFomulaName.Text = dr.dgvShowRepairHead.Rows[dr.index].Cells["FmName"].Value.ToString();
            }
        }
Ejemplo n.º 2
0
        void GetItem(DialogReturnDamagnedReceive o)
        {
            int index = 0;
            List<string> detailId = new List<string>();

            foreach (DataGridViewRow dr in o.dgvShowRepairSelect.Rows)
            {
                string ProductionRepairDetailId = dr.Cells["sProductionRepairDetailId"].Value.ToString();//รหัสรายการซ่อม
                string ProductionRepairHeadId = dr.Cells["sProductionRepairHeadId"].Value.ToString();//เลขที่ใบส่งซ่อม
                double Quantity = Convert.ToDouble(dr.Cells["sQuantity"].Value.ToString());//จำนวน
                double QuantityReceive = Convert.ToDouble(dr.Cells["sQuantityReceive"].Value.ToString());//จำนวนที่รับแล้ว
                double QuantityCanReceive = Convert.ToDouble(dr.Cells["sQuantityCanReceive"].Value.ToString());//จำนวนที่รับได้
                double QuantityReceiveNew = Convert.ToDouble(dr.Cells["sQuantityReceiveNew"].Value.ToString());//จำนวนรับใหม่
                double Cost = 0;

                index = dgvItem.Rows.Add();
                detailId.Add(ProductionRepairDetailId);

                dgvItem.Rows[index].Cells["ProductionRepairDetailId"].Value = ProductionRepairDetailId;//รหัสรายการซ่อม
                dgvItem.Rows[index].Cells["ProductionRepairHeadId"].Value = ProductionRepairHeadId;//เลขที่ใบส่งซ่อม
                dgvItem.Rows[index].Cells["FmName"].Value = "";//ชื่อสูตรผลิต

                dgvItem.Rows[index].Cells["Quantity"].Value = Quantity;//จำนวน
                dgvItem.Rows[index].Cells["QuantityReceive"].Value = QuantityReceive;//จำนวนที่รับแล้ว
                dgvItem.Rows[index].Cells["QuantityCanReceive"].Value = QuantityCanReceive;//จำนวนที่รับได้
                dgvItem.Rows[index].Cells["QuantityReceiveNew"].Value = QuantityReceiveNew;//จำนวนรับใหม่
                dgvItem.Rows[index].Cells["Cost"].Value = Cost;//ต้นทุน
                dgvItem.Rows[index].Cells["Note"].Value = "";//หมายเหตุ
            }

            string where_in = "";
            foreach (string i in detailId)
            {
                where_in += i + ",";
            }
            where_in = where_in.Substring(0, where_in.Length - 1);

            StringBuilder sql = new StringBuilder();
            sql.Append("");
            sql.Append("SELECT prd.ProductionRepairDetailId,pcf.NewProductionId,pf.FmName,pdh.Amount,pdh.TotalCost ");
            sql.Append("FROM ProductionRepairDetail AS prd INNER JOIN " +
                       "ProductionCheckFail AS pcf ON pcf.ProductionCheckFailId = prd.ProductionCheckFailId INNER JOIN " +
                       "ProductionDraw_Head AS pdh ON pdh.NewProductionId = pcf.NewProductionId INNER JOIN " +
                       "ProductionFormular AS pf ON pf.FmId = pdh.FmId ");
            sql.Append("WHERE prd.ProductionRepairDetailId IN (" + where_in + ") ");

            DataTable dt = Class.DBConnString.clsDB.QueryDataTable(sql.ToString());

            double cost = 0;
            double quantityreceive = 0;
            double amount = 0;
            double totalcost = 0;

            for (int i = 0; i < dt.Rows.Count; ++i)
            {
                for (int j = 0; j < dgvItem.Rows.Count; ++j)
                {
                    if (dgvItem.Rows[j].Cells["ProductionRepairDetailId"].Value.ToString() == dt.Rows[i]["ProductionRepairDetailId"].ToString())
                    {
                        dgvItem.Rows[j].Cells["FmName"].Value = dt.Rows[i]["FmName"].ToString();//เก็บค่าชือสูตรผลิต
                        dgvItem.Rows[j].Cells["ProductionRepairDetailId"].Value = dt.Rows[i]["ProductionRepairDetailId"].ToString();//เก็บค่ารหัสอวนซ่อม
                        dgvItem.Rows[j].Cells["NewProductionId"].Value = dt.Rows[i]["NewProductionId"].ToString();//เก็บค่ารหัสเบิกผลิต

                        quantityreceive = Convert.ToDouble(dgvItem.Rows[j].Cells["QuantityReceiveNew"].Value.ToString());//จำนวนที่รับใหม่
                        amount = Convert.ToDouble(dt.Rows[i]["Amount"].ToString());//จำนวน
                        totalcost = Convert.ToDouble(dt.Rows[i]["TotalCost"].ToString());//ต้นทุนรวม
                        cost = (totalcost / amount) * quantityreceive;

                        TotalCost += cost;

                        dgvItem.Rows[j].Cells["Cost"].Value = cost;//ต้นทุน
                    }
                }
            }
        }