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

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

            int indexAllotId = dr.GetOrdinal("AllotId");
            if (dr["AllotId"] != DBNull.Value)
            {
                finbusinvallotdetail.AllotId = Convert.ToInt32(dr[indexAllotId]);
            }

            int indexBusinessInvoiceId = dr.GetOrdinal("BusinessInvoiceId");
            if (dr["BusinessInvoiceId"] != DBNull.Value)
            {
                finbusinvallotdetail.BusinessInvoiceId = Convert.ToInt32(dr[indexBusinessInvoiceId]);
            }

            int indexFinanceInvoiceId = dr.GetOrdinal("FinanceInvoiceId");
            if (dr["FinanceInvoiceId"] != DBNull.Value)
            {
                finbusinvallotdetail.FinanceInvoiceId = Convert.ToInt32(dr[indexFinanceInvoiceId]);
            }

            int indexAllotBala = dr.GetOrdinal("AllotBala");
            if (dr["AllotBala"] != DBNull.Value)
            {
                finbusinvallotdetail.AllotBala = Convert.ToDecimal(dr[indexAllotBala]);
            }

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

            return finbusinvallotdetail;
        }
Example #2
0
        public ResultModel Load(UserModel user, int allotId, Common.StatusEnum status)
        {
            ResultModel result = new ResultModel();

            try
            {
                string sql = string.Format("select * from dbo.Inv_FinBusInvAllotDetail where AllotId = {0} and DetailStatus = {1}", allotId, (int)status);

                DataTable dt = SqlHelper.ExecuteDataTable(ConnectString, sql, null, CommandType.Text);

                List<FinBusInvAllotDetail> finBusInvAllotDetails = new List<FinBusInvAllotDetail>();

                foreach (DataRow dr in dt.Rows)
                {
                    FinBusInvAllotDetail finbusinvallotdetail = new FinBusInvAllotDetail();
                    finbusinvallotdetail.DetailId = Convert.ToInt32(dr["DetailId"]);

                    if (dr["AllotId"] != DBNull.Value)
                    {
                        finbusinvallotdetail.AllotId = Convert.ToInt32(dr["AllotId"]);
                    }
                    if (dr["BusinessInvoiceId"] != DBNull.Value)
                    {
                        finbusinvallotdetail.BusinessInvoiceId = Convert.ToInt32(dr["BusinessInvoiceId"]);
                    }
                    if (dr["FinanceInvoiceId"] != DBNull.Value)
                    {
                        finbusinvallotdetail.FinanceInvoiceId = Convert.ToInt32(dr["FinanceInvoiceId"]);
                    }
                    if (dr["AllotBala"] != DBNull.Value)
                    {
                        finbusinvallotdetail.AllotBala = Convert.ToDecimal(dr["AllotBala"]);
                    }
                    if (dr["DetailStatus"] != DBNull.Value)
                    {
                        finbusinvallotdetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr["DetailStatus"]);
                    }
                    finBusInvAllotDetails.Add(finbusinvallotdetail);
                }
                result.AffectCount = dt.Rows.Count;
                result.Message = "获取列表成功";
                result.ResultStatus = 0;
                result.ReturnValue = finBusInvAllotDetails;
            }
            catch (Exception e)
            {
                result.ResultStatus = -1;
                result.Message = e.Message;
            }

            return result;
        }