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