Example #1
0
        public override IModel CreateModel(SqlDataReader dr)
        {
            RepoApplyDetail repoapplydetail = new RepoApplyDetail();

            int indexDetailId = dr.GetOrdinal("DetailId");
            repoapplydetail.DetailId = Convert.ToInt32(dr[indexDetailId]);

            int indexRepoApplyId = dr.GetOrdinal("RepoApplyId");
            if (dr["RepoApplyId"] != DBNull.Value)
            {
                repoapplydetail.RepoApplyId = Convert.ToInt32(dr[indexRepoApplyId]);
            }

            int indexStockDetailId = dr.GetOrdinal("StockDetailId");
            if (dr["StockDetailId"] != DBNull.Value)
            {
                repoapplydetail.StockDetailId = Convert.ToInt32(dr[indexStockDetailId]);
            }

            int indexPledgeApplyId = dr.GetOrdinal("PledgeApplyId");
            if (dr["PledgeApplyId"] != DBNull.Value)
            {
                repoapplydetail.PledgeApplyId = Convert.ToInt32(dr[indexPledgeApplyId]);
            }

            int indexRepoTime = dr.GetOrdinal("RepoTime");
            if (dr["RepoTime"] != DBNull.Value)
            {
                repoapplydetail.RepoTime = Convert.ToDateTime(dr[indexRepoTime]);
            }

            int indexContractNo = dr.GetOrdinal("ContractNo");
            if (dr["ContractNo"] != DBNull.Value)
            {
                repoapplydetail.ContractNo = Convert.ToString(dr[indexContractNo]);
            }

            int indexNetAmount = dr.GetOrdinal("NetAmount");
            if (dr["NetAmount"] != DBNull.Value)
            {
                repoapplydetail.NetAmount = Convert.ToDecimal(dr[indexNetAmount]);
            }

            int indexStockId = dr.GetOrdinal("StockId");
            if (dr["StockId"] != DBNull.Value)
            {
                repoapplydetail.StockId = Convert.ToInt32(dr[indexStockId]);
            }

            int indexRefNo = dr.GetOrdinal("RefNo");
            if (dr["RefNo"] != DBNull.Value)
            {
                repoapplydetail.RefNo = Convert.ToString(dr[indexRefNo]);
            }

            int indexHands = dr.GetOrdinal("Hands");
            if (dr["Hands"] != DBNull.Value)
            {
                repoapplydetail.Hands = Convert.ToInt32(dr[indexHands]);
            }

            int indexPrice = dr.GetOrdinal("Price");
            if (dr["Price"] != DBNull.Value)
            {
                repoapplydetail.Price = Convert.ToDecimal(dr[indexPrice]);
            }

            int indexExpiringDate = dr.GetOrdinal("ExpiringDate");
            if (dr["ExpiringDate"] != DBNull.Value)
            {
                repoapplydetail.ExpiringDate = Convert.ToDateTime(dr[indexExpiringDate]);
            }

            int indexAccountName = dr.GetOrdinal("AccountName");
            if (dr["AccountName"] != DBNull.Value)
            {
                repoapplydetail.AccountName = Convert.ToString(dr[indexAccountName]);
            }

            int indexMemo = dr.GetOrdinal("Memo");
            if (dr["Memo"] != DBNull.Value)
            {
                repoapplydetail.Memo = Convert.ToString(dr[indexMemo]);
            }

            int indexDetailStatus = dr.GetOrdinal("DetailStatus");
            if (dr["DetailStatus"] != DBNull.Value)
            {
                repoapplydetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexDetailStatus]);
            }

            return repoapplydetail;
        }
Example #2
0
        public override IModel CreateModel(DataRow dr)
        {
            RepoApplyDetail repoapplydetail = new RepoApplyDetail();

            repoapplydetail.DetailId = Convert.ToInt32(dr["DetailId"]);

            if (dr["RepoApplyId"] != DBNull.Value)
            {
                repoapplydetail.RepoApplyId = Convert.ToInt32(dr["RepoApplyId"]);
            }

            if (dr["StockDetailId"] != DBNull.Value)
            {
                repoapplydetail.StockDetailId = Convert.ToInt32(dr["StockDetailId"]);
            }

            if (dr["PledgeApplyId"] != DBNull.Value)
            {
                repoapplydetail.PledgeApplyId = Convert.ToInt32(dr["PledgeApplyId"]);
            }

            if (dr["RepoTime"] != DBNull.Value)
            {
                repoapplydetail.RepoTime = Convert.ToDateTime(dr["RepoTime"]);
            }

            if (dr["ContractNo"] != DBNull.Value)
            {
                repoapplydetail.ContractNo = Convert.ToString(dr["ContractNo"]);
            }

            if (dr["NetAmount"] != DBNull.Value)
            {
                repoapplydetail.NetAmount = Convert.ToDecimal(dr["NetAmount"]);
            }

            if (dr["StockId"] != DBNull.Value)
            {
                repoapplydetail.StockId = Convert.ToInt32(dr["StockId"]);
            }

            if (dr["RefNo"] != DBNull.Value)
            {
                repoapplydetail.RefNo = Convert.ToString(dr["RefNo"]);
            }

            if (dr["Hands"] != DBNull.Value)
            {
                repoapplydetail.Hands = Convert.ToInt32(dr["Hands"]);
            }

            if (dr["Price"] != DBNull.Value)
            {
                repoapplydetail.Price = Convert.ToDecimal(dr["Price"]);
            }

            if (dr["ExpiringDate"] != DBNull.Value)
            {
                repoapplydetail.ExpiringDate = Convert.ToDateTime(dr["ExpiringDate"]);
            }

            if (dr["AccountName"] != DBNull.Value)
            {
                repoapplydetail.AccountName = Convert.ToString(dr["AccountName"]);
            }

            if (dr["Memo"] != DBNull.Value)
            {
                repoapplydetail.Memo = Convert.ToString(dr["Memo"]);
            }

            if (dr["DetailStatus"] != DBNull.Value)
            {
                repoapplydetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr["DetailStatus"]);
            }

            return repoapplydetail;
        }