コード例 #1
0
        private void selectFormularMacth()
        {
            if (!IsPeaple)
            {
                String q = "";
                Double t = 0;
                foreach (DataGridViewRow r in dataGridView1.Rows)
                {
                    if (r.Cells["Id"].Value.ToString() == dataGridView1.CurrentRow.Cells["Id"].Value.ToString())
                    {
                        t += Convert.ToDouble((r.Cells["Quantity"].Value.ToString() == "") ? "0" : r.Cells["Quantity"].Value.ToString());
                    }
                }
                ProductionNew.dialogReqReceive dr = new dialogReqReceive(empid, st, t.ToString(), dataGridView1.CurrentRow.Cells["Id"].Value.ToString(),1);
                dr.ShowDialog();
                if (dr.DialogResult == DialogResult.OK)
                {
                    dataGridView1.CurrentRow.Cells[2].Value = dr.dataGridView1.CurrentRow.Cells[7].Value;
                    dataGridView1.CurrentRow.Cells[4].Value = dr.dataGridView1.CurrentRow.Cells[1].Value;
                }
            }
            else if (st == "1")
            {
                String q = "";
                Double t = 0;
                foreach (DataGridViewRow i in dataGridView1.Rows)
                {
                    if (i.Cells["Id"].Value.ToString() == dataGridView1.CurrentRow.Cells["Id"].Value.ToString())
                    {
                        t += Convert.ToDouble((i.Cells["Quantity"].Value.ToString() == "") ? "0" : i.Cells["Quantity"].Value.ToString());
                    }
                }
                ProductionNew.DialogPeapleRepair r = new DialogPeapleRepair(empid, t.ToString());

                r.ShowDialog();
                if (r.DialogResult == System.Windows.Forms.DialogResult.OK)
                {
                    dataGridView1.CurrentRow.Cells["QuantityReceive"].Value = r.dataGridView1.CurrentRow.Cells["QuantityBalance"].Value;
                    dataGridView1.CurrentRow.Cells["Id"].Value = r.dataGridView1.CurrentRow.Cells["RepairDetailId"].Value;
                }
            }
        }
コード例 #2
0
 private void selectFormularMacth()
 {
     ProductionNew.dialogReqReceive dr = new dialogReqReceive(Class.Function.GetTextId(textBox3.Text), "0", "0", textBox9.Text,1);
     dr.ShowDialog();
     if (dr.DialogResult == DialogResult.OK)
     {
         Qty = Convert.ToDouble(dr.dataGridView1.CurrentRow.Cells[6].Value.ToString());
         FmId = dr.dataGridView1.CurrentRow.Cells[8].Value.ToString();
         textBox10.Text = dr.dataGridView1.CurrentRow.Cells[3].Value.ToString();
         textBox9.Text = dr.dataGridView1.CurrentRow.Cells[1].Value.ToString();
         LotId = dr.dataGridView1.CurrentRow.Cells[0].Value.ToString();
     }
 }
コード例 #3
0
        private void selectFormularMacth()
        {
            int cutType = getCutType();

            ProductionNew.dialogReqReceive dr = new dialogReqReceive(Class.Function.GetTextId(textBox3.Text), "0", textBox12.Text, textBox9.Text,cutType );
            dr.ShowDialog();
            if (dr.DialogResult == DialogResult.OK)
            {
                Qty = (dr.dataGridView1.CurrentRow.Cells[7].Value.ToDouble());//จำนวน
                FmId = dr.dataGridView1.CurrentRow.Cells[9].Value.IsNullAsEmpty();//รหัสสูตรผลิต
                textBox10.Text = dr.dataGridView1.CurrentRow.Cells[4].Value.IsNullAsEmpty();//ชื่อสูตรผลิต
                textBox9.Text = dr.dataGridView1.CurrentRow.Cells[1].Value.IsNullAsEmpty();//รหัสเบิก
                LotId = dr.dataGridView1.CurrentRow.Cells[0].Value.IsNullAsEmpty();//รหัสงาน
                textBox12.Text = "0";
                //String sql = "select m.mid,m.mname,(Cast(d.mquantity * " + Qty + " as decimal(10,2))) as mquantity," +
                //    "(select u.unitsalename from unitsale u where u.unitsaleid = m.munit) as munit " +
                //    "from productionmaterial m inner join productionformulardetail d" +
                //    " on d.mid = m.mid where d.FmId = '" + FmId + "'";//ดึงข้อมูลวัตถุดิบ
                //dataGridView1.DataSource = Class.DBConnString.clsDB.QueryDataTable(sql);
                //dataGridView1.Columns[0].HeaderText = "รหัสวัตถุดิบ";
                //dataGridView1.Columns[1].HeaderText = "ชื่อวัตถุดิบ";
                //dataGridView1.Columns[1].Width = 200;
                //dataGridView1.Columns[2].HeaderText = "จำนวน";
                //dataGridView1.Columns[3].HeaderText = "หน่วย";
                FmIdTemp = FmId;
                OutstandingIdTemp = LotId;
            }
        }