public static BillHead SelectHeadOnId(string procName, int action, int id)
{
BillHead head = new BillHead();
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())
{
head.Id = (int)reader.GetSqlInt32(0);
head.BillNumber = reader.GetString(1);
head.BillDate = (DateTime)reader.GetSqlDateTime(2);
head.StoreID = (int)reader.GetSqlInt32(3);
head.BillCategoryID = (int)reader.GetSqlInt32(4);
head.BillPurposeID = (int)reader.GetSqlInt32(5);
if (!reader.GetSqlMoney(6).IsNull)
{
head.TotalSum = System.Convert.ToDecimal(reader.GetSqlMoney(6).ToString());
}
if (!reader.GetSqlMoney(7).IsNull)
{
head.TotalPdv = System.Convert.ToDecimal(reader.GetSqlMoney(7).ToString());
}
head.Description = reader.GetString(8);
}
}
catch (Exception ex)
{
conn.Close();
MessageBox.Show(ex.ToString());
}
finally
{
reader.Close();
conn.Close();
}
return(head);
}
private static void BuildBillHeadParameter(BillHead head, string statement)
{
if (statement == "update")
{
cmd.Parameters.Add(new SqlParameter("@id", head.Id));
}
cmd.Parameters.Add(new SqlParameter("@billNumber", head.BillNumber));
cmd.Parameters.Add(new SqlParameter("@billDate", head.BillDate));
cmd.Parameters.Add(new SqlParameter("@billCategoryID", head.BillCategoryID));
cmd.Parameters.Add(new SqlParameter("@billPurposeID", head.BillPurposeID));
cmd.Parameters.Add(new SqlParameter("@storeID", head.StoreID));
cmd.Parameters.Add(new SqlParameter("@totalSum", head.TotalSum));
cmd.Parameters.Add(new SqlParameter("@totalPdv", head.TotalPdv));
cmd.Parameters.Add(new SqlParameter("@description", head.Description));
cmd.Parameters.Add(new SqlParameter("@statusid", head.StatusID));
}
