06-07-17, 02:18 AM
سلام عليكم
شباب ما هو الخطأ فى هذا الكود
شباب ما هو الخطأ فى هذا الكود
PHP كود :
double total_ = 0;
for (int i = 0; i <= DGV.Rows.Count - 1; i++)
{
string str;
DataTable dt = new DataTable();
dt.Clear();
str = "SELECT SUM(dbo.BILL_2.QTY * dbo.BILL_2.VAL_UNIT) AS Expr3, SUM(dbo.BILL_2.total_currency_1) AS Expr2 FROM dbo.BILL_1 INNER JOIN dbo.BILL_2 ON dbo.BILL_1.ID = dbo.BILL_2.ID_INT WHERE (dbo.BILL_1.TYP = 11) AND (dbo.BILL_2.ID_ITEM = " + Convert.ToInt32(DGV.Rows[i].Cells[13].Value.ToString()) + ")";
SqlDataAdapter adp = new SqlDataAdapter(str, con);
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
double qty= Convert.ToDouble(DGV.Rows[i].Cells[0].Value.ToString());
double price = Convert.ToDouble(dt.Rows[0][1].ToString()) / Convert.ToDouble(dt.Rows[0][0].ToString());
double totalprice = Convert.ToDouble(qty) * Convert.ToDouble(price);
double disc = Convert.ToDouble(DGV.Rows[i].Cells[7].Value.ToString());
double add = Convert.ToDouble(DGV.Rows[i].Cells[8].Value.ToString());
double totaly = Convert.ToDouble(totalprice) + Convert.ToDouble(add) - Convert.ToDouble(disc);
DGV.Rows[i].Cells[11].Value = Convert.ToDouble(price);
DGV.Rows[i].Cells[12].Value = Convert.ToDouble(DGV.Rows[i].Cells[9].Value) - Convert.ToDouble(totaly);
if ( Convert.ToInt32( DGV.Rows[i].Cells[14].Value )== 14)
{
DGV.Rows[i].Cells[12].Value = Convert.ToDouble(DGV.Rows[i].Cells[12].Value) * -1;
}
total_ = Convert.ToDouble(total_) + Convert.ToDouble(DGV.Rows[i].Cells[12].Value);
}
}
TXT_TOTAL.Text = Convert.ToString (total_);