123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165 |
- using SinoChemCommonUtilities;
- using System;
- using System.Collections.Generic;
- using System.Data.SqlClient;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace SinochemInternetPlusApp
- {
- public static class DbModelConstructors
- {
- public static Xiaofei2Model ConstructXiaofei2Model(SqlDataReader reader)
- {
-
-
- if (reader.Read())
- {
- Xiaofei2Model xiaofei2Model = new Xiaofei2Model();
- xiaofei2Model.plate_number = DbFieldReader.SafelyReadDbField<string>(reader["plate_number"]);
- xiaofei2Model.jihao = DbFieldReader.SafelyReadDbField<int>(reader["jihao"]);
- xiaofei2Model.youpin = DbFieldReader.SafelyReadDbField <string>(reader["youpin"]);
- xiaofei2Model.qty = DbFieldReader.SafelyReadDbField<double>(reader["qty"]);
- xiaofei2Model.danjia = DbFieldReader.SafelyReadDbField<double>(reader["danjia"]);
- xiaofei2Model.amount = DbFieldReader.SafelyReadDbField<double>(reader["amount"]);
- xiaofei2Model.xf_date = DbFieldReader.SafelyReadDbField<DateTime>(reader["xf_date"]);
- xiaofei2Model.xf_time = DbFieldReader.SafelyReadDbField <string>(reader["xf_time"]);
- xiaofei2Model.liushuino = DbFieldReader.SafelyReadDbField <string>(reader["liushuino"]);
- xiaofei2Model.fzqty = DbFieldReader.SafelyReadDbField <string>(reader["fzqty"]);
- xiaofei2Model.fzamount = DbFieldReader.SafelyReadDbField<double>(reader["fzamount"]);
- return xiaofei2Model;
- }
- else
- {
- return null;
- }
- }
- public static JyInfoModel ConstructJyInfoModel(SqlDataReader reader)
- {
- if (reader.Read())
- {
- JyInfoModel jyInfoModel = new JyInfoModel();
- jyInfoModel.jihao = DbFieldReader.SafelyReadDbField<int>(reader["jihao"]);
- jyInfoModel.status = DbFieldReader.SafelyReadDbField<string>(reader["status"]);
- jyInfoModel.youpin = DbFieldReader.SafelyReadDbField<string>(reader["youpin"]);
- jyInfoModel.qty = DbFieldReader.SafelyReadDbField<double>(reader["qty"]);
- jyInfoModel.amount = DbFieldReader.SafelyReadDbField<double>(reader["amount"]);
- jyInfoModel.fzqty = DbFieldReader.SafelyReadDbField <string>(reader["fzqty"]);
- jyInfoModel.fzamount = DbFieldReader.SafelyReadDbField<double>(reader["fzamount"]);
- return jyInfoModel;
- }
- else
- {
- return null;
- }
- }
- public static List<EpsTransactionModel> ConstructEpsTrxModelList(SqlDataReader reader)
- {
- List<EpsTransactionModel> epsTrxModelList = new List<EpsTransactionModel>();
- while (reader.Read())
- {
- EpsTransactionModel epxTrxModel = FillEpsTrxModelWithReaderReady(reader);
- epsTrxModelList.Add(epxTrxModel);
- }
- return epsTrxModelList;
- }
- public static List<EpsTransaction> ConstructEpsTrxList(SqlDataReader reader)
- {
- List<EpsTransaction> epsTrxList = new List<EpsTransaction>();
- while (reader.Read())
- {
- EpsTransactionModel epxTrxModel = FillEpsTrxModelWithReaderReady(reader);
- epsTrxList.Add(EpsTransaction.RestroeEpsTrxFrom(epxTrxModel));
- }
- return epsTrxList;
- }
-
- private static EpsTransactionModel FillEpsTrxModelWithReaderReady(SqlDataReader reader)
- {
- #region for debugging purpose
-
- #endregion
- EpsTransactionModel epxTrxModel = new EpsTransactionModel
- {
- id = DbFieldReader.SafelyReadDbField<int>(reader["id"]),
- jihao = DbFieldReader.SafelyReadDbField<int>(reader["jihao"]),
- youpin = DbFieldReader.SafelyReadDbField<string>(reader["youpin"]),
- qty = DbFieldReader.SafelyReadDbField<double>(reader["qty"]),
- danjia = DbFieldReader.SafelyReadDbField<double>(reader["danjia"]),
- amount = DbFieldReader.SafelyReadDbField<double>(reader["amount"]),
- xf_date = DbFieldReader.SafelyReadDbField<DateTime>(reader["xf_date"]),
- xf_time = DbFieldReader.SafelyReadDbField<string>(reader["xf_time"]),
- liushuino = DbFieldReader.SafelyReadDbField<string>(reader["liushuino"]),
- fzqty = DbFieldReader.SafelyReadDbField<string>(reader["fzqty"]),
- fzamount = DbFieldReader.SafelyReadDbField<double>(reader["fzamount"]),
- trx_status = (EpsTrxStatus)DbFieldReader.SafelyReadDbField<int>(reader["trx_status"]),
- payMethod = DbFieldReader.SafelyReadDbField<string>(reader["payMethod"]),
- mop = (EpsTransactionMode)DbFieldReader.SafelyReadDbField<int>(reader["mop"]),
- car_number = DbFieldReader.SafelyReadDbField<string>(reader["car_number"]),
- card_no = DbFieldReader.SafelyReadDbField<string>(reader["card_no"]),
- cardType = (CardType)DbFieldReader.SafelyReadDbField<int>(reader["cardType"]),
- ttc = DbFieldReader.SafelyReadDbField<string>(reader["ttc"]),
- token = DbFieldReader.SafelyReadDbField<string>(reader["token"]),
- tid = DbFieldReader.SafelyReadDbField<string>(reader["tid"]),
- mac = DbFieldReader.SafelyReadDbField<string>(reader["mac"]),
- balance_before_trx = DbFieldReader.SafelyReadDbField<double>(reader["balance_before_trx"]),
- real_pay_amount = DbFieldReader.SafelyReadDbField<double>(reader["real_pay_amount"]),
- auth_time = DbFieldReader.SafelyReadDbField<string>(reader["auth_time"]),
- bill_id = DbFieldReader.SafelyReadDbField<string>(reader["bill_id"]),
- created_time = DbFieldReader.SafelyReadDbField<DateTime>(reader["created_time"]),
- shift_id = DbFieldReader.SafelyReadDbField<string>(reader["shift_id"]),
- business_date = DbFieldReader.SafelyReadDbField<string>(reader["business_date"]),
- notify_pos = (NotifyPosFlag)DbFieldReader.SafelyReadDbField<int>(reader["notify_pos"]),
- cardNo_masked = DbFieldReader.SafelyReadDbField<string>(reader["cardNo_masked"]),
- nozzleSelected = DbFieldReader.SafelyReadDbField<int>(reader["nozzleSelected"]),
- openId = DbFieldReader.SafelyReadDbField<string>(reader["openId"]),
- };
- return epxTrxModel;
- }
- }
- }
|