protected MRS.Model.AccountBook Parse(SqlDataReader Reader)
{
MRS.Model.AccountBook accountBook = new MRS.Model.AccountBook();
accountBook.BXDId = Convert.ToInt32(Reader[DSL.AccountBook.BXDID_FIELD]);
accountBook.BXDate = Convert.ToDateTime(Reader[DSL.AccountBook.BXDATE_FIELD]);
accountBook.YBH = Reader[DSL.AccountBook.YBH_FIELD].ToString().Trim();
accountBook.PsnType = Reader[DSL.AccountBook.PSN_TYPE_FIELD].ToString().Trim();
accountBook.AttNumber = Convert.ToInt32(Reader[DSL.AccountBook.ATT_NUMBER_FIELD]);
accountBook.Accountant = Reader[DSL.AccountBook.ACCOUNTANT_FIELD].ToString().Trim();
accountBook.YYF = Convert.ToDecimal(Reader[DSL.AccountBook.YYF_FIELD]);
accountBook.BXJE = Convert.ToDecimal(Reader[DSL.AccountBook.BXJE_FIELD]);
accountBook.ZLF = Convert.ToDecimal(Reader[DSL.AccountBook.ZLF_FIELD]);
accountBook.TCJJ = Convert.ToDecimal(Reader[DSL.AccountBook.TCJJ_FIELD]);
accountBook.GRZFei = Convert.ToDecimal(Reader[DSL.AccountBook.GRZFEI_FIELD]);
accountBook.GRZFu = Convert.ToDecimal(Reader[DSL.AccountBook.GRZFU_FIELD]);
accountBook.Name = Reader[DSL.AccountBook.NAME_FIELD].ToString().Trim();
accountBook.JobNumber = Reader[DSL.AccountBook.JOB_NUMBER_FIELD].ToString().Trim();
accountBook.IdentityCard = Reader[DSL.AccountBook.IDENTITY_CARD_FIELD].ToString().Trim();
accountBook.Birthday = Convert.ToDateTime(Reader[DSL.AccountBook.BIRTHDAY_FIELD]);
accountBook.Organization = Reader[DSL.AccountBook.ORGANIZATION_FIELD].ToString().Trim();
accountBook.Sex = Reader[DSL.AccountBook.SEX_FIELD].ToString().Trim();
accountBook.ChargeUpSign = Reader[DSL.AccountBook.CHARGE_UP_SIGN_FIELD].ToString().Trim();
accountBook.ChargeUpDate = Convert.ToDateTime(Reader[DSL.AccountBook.CHARGE_UP_DATE_FIELD]);
accountBook.Cashier = Reader[DSL.AccountBook.CASHIER_FIELD].ToString().Trim();
return(accountBook);
}
public IList <MRS.Model.AccountBook> Select_AccountBook_PaymentList(DateTime BeginDate, DateTime EndDate)
{
IList <MRS.Model.AccountBook> accountBooks = new List <MRS.Model.AccountBook>();
SqlParameter begin_date_parm = new SqlParameter(DSL.AccountBook.CHARGE_UP_BEGIN_DATE_PARM, SqlDbType.DateTime);
SqlParameter end_date_parm = new SqlParameter(DSL.AccountBook.CHARGE_UP_END_DATE_PARM, SqlDbType.DateTime);
begin_date_parm.Value = BeginDate;
end_date_parm.Value = EndDate;
SqlParameter[] parms = new SqlParameter[2];
parms.SetValue(begin_date_parm, 0);
parms.SetValue(end_date_parm, 1);
using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.SELECT_ACCOUNT_BOOK_PAYMENT_LIST, parms))
{
while (reader.Read())
{
MRS.Model.AccountBook abook = Parse(reader);
accountBooks.Add(abook);
}
}
return(accountBooks);
}
