public static BillBody SelectBodyOnId(string procName, int action, int id)
{
BillBody body = new BillBody();
PrepareComponent();
cmd.CommandText = procName;
cmd.Parameters.Add(new SqlParameter("@action", action));
cmd.Parameters.Add(new SqlParameter("@id", id));
try
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
body.Articl = reader.GetString(0);
body.UomID = (int)reader.GetSqlInt32(1);
if (!reader.GetSqlMoney(3).IsNull)
{
body.Quantity = System.Convert.ToDecimal(reader.GetSqlMoney(3).ToString());
}
if (reader.GetString(4).Length > 0)
{
body.Sum = MainHelper.SqlStringIntoDecimal(reader.GetString(4));
}
if (reader.GetString(5).Length > 0)
{
body.Pdv = MainHelper.SqlStringIntoDecimal(reader.GetString(5));
}
body.Description = reader.GetString(6);
body.Id = (int)reader.GetSqlInt32(7);
body.HeadId = (int)reader.GetSqlInt32(8);
}
}
catch (Exception ex)
{
conn.Close();
MessageBox.Show(ex.ToString());
}
finally
{
reader.Close();
conn.Close();
}
return(body);
}
private static void BuildBillBodyParameter(BillBody body, string statement)
{
if (statement == "update")
{
cmd.Parameters.Add(new SqlParameter("@id", body.Id));
}
cmd.Parameters.Add(new SqlParameter("@Headid", body.HeadId));
cmd.Parameters.Add(new SqlParameter("@articl", body.Articl));
cmd.Parameters.Add(new SqlParameter("@quantity", body.Quantity));
cmd.Parameters.Add(new SqlParameter("@uomID", body.UomID));
cmd.Parameters.Add(new SqlParameter("@sum", body.Sum));
cmd.Parameters.Add(new SqlParameter("@pdv", body.Pdv));
cmd.Parameters.Add(new SqlParameter("@description", body.Description));
}
