static private SqlCommand estContParaValue(SqlCommand cmd, DataGridViewRow dgvr) { cmd.Parameters["@iCod"].Value = Convert.ToString(dgvr.Cells["ItemCode"].Value); cmd.Parameters["@item"].Value = Convert.ToString(dgvr.Cells["Item"].Value); cmd.Parameters["@iDtl"].Value = Convert.ToString(dgvr.Cells["ItemDetail"].Value); cmd.Parameters["@qty"].Value = Convert.ToDecimal(dgvr.Cells["Quantity"].Value); cmd.Parameters["@unit"].Value = Convert.ToString(dgvr.Cells["Unit"].Value); // Wakamatsu 20170324 //cmd.Parameters["@cost"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells["Cost"].Value)); Calculation calc = new Calculation(); if (calc.ExtractCalcWord(Convert.ToString(dgvr.Cells["Item"].Value)) == Sign.Discount) { // Wakamatsu 20170327 //cmd.Parameters["@cost"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells["Amount"].Value)); cmd.Parameters["@cost"].Value = SignConvert(Convert.ToString(dgvr.Cells["Amount"].Value)); } // Wakamatsu 20170327 else { cmd.Parameters["@cost"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells["Cost"].Value)); } // Wakamatsu 20170324 cmd.Parameters["@note"].Value = Convert.ToString(dgvr.Cells["Note"].Value); return(cmd); }
static private SqlCommand planningContParaValue(SqlCommand cmd, DataGridViewRow dgvr) { cmd.Parameters["@iCod"].Value = Convert.ToString(dgvr.Cells[1].Value); cmd.Parameters["@item"].Value = Convert.ToString(dgvr.Cells[2].Value); cmd.Parameters["@iDtl"].Value = Convert.ToString(dgvr.Cells[3].Value); cmd.Parameters["@qty"].Value = Convert.ToDecimal(dgvr.Cells[4].Value); cmd.Parameters["@unit"].Value = Convert.ToString(dgvr.Cells[5].Value); // Wakamatsu 20170329 //cmd.Parameters["@cost0"].Value = DHandling.ToRegDecimal( Convert.ToString( dgvr.Cells[6].Value ) ); //cmd.Parameters["@cost1"].Value = DHandling.ToRegDecimal( Convert.ToString( dgvr.Cells[8].Value ) ); //cmd.Parameters["@cost2"].Value = DHandling.ToRegDecimal( Convert.ToString( dgvr.Cells[10].Value ) ); Calculation calc = new Calculation(); if (calc.ExtractCalcWord(Convert.ToString(dgvr.Cells["Item"].Value)) == Sign.Discount) { cmd.Parameters["@cost0"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells[7].Value)); cmd.Parameters["@cost1"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells[9].Value)); cmd.Parameters["@cost2"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells[11].Value)); } else { cmd.Parameters["@cost0"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells[6].Value)); cmd.Parameters["@cost1"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells[8].Value)); cmd.Parameters["@cost2"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells[10].Value)); } // Wakamatsu 20170329 return(cmd); }
static private SqlCommand outsourceContParaValue(SqlCommand cmd, DataGridViewRow dgvr) { cmd.Parameters["@iCod"].Value = Convert.ToString(dgvr.Cells["ItemCode"].Value); cmd.Parameters["@item"].Value = Convert.ToString(dgvr.Cells["Item"].Value); cmd.Parameters["@iDtl"].Value = Convert.ToString(dgvr.Cells["ItemDetail"].Value); cmd.Parameters["@qty"].Value = Convert.ToDecimal(dgvr.Cells["Quantity"].Value); cmd.Parameters["@unit"].Value = Convert.ToString(dgvr.Cells["Unit"].Value); cmd.Parameters["@cost"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells["Cost"].Value)); cmd.Parameters["@note"].Value = DHandling.ToRegDecimal(Convert.ToString(dgvr.Cells["Note"].Value)); return(cmd); }