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)); }