/// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(MobileSoft.Model.HSPR.Tb_HSPR_WaiversFee model)
 {
     dal.Add(model);
 }
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(MobileSoft.Model.HSPR.Tb_HSPR_WaiversFee model)
 {
     dal.Update(model);
 }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <MobileSoft.Model.HSPR.Tb_HSPR_WaiversFee> DataTableToList(DataTable dt)
        {
            List <MobileSoft.Model.HSPR.Tb_HSPR_WaiversFee> modelList = new List <MobileSoft.Model.HSPR.Tb_HSPR_WaiversFee>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                MobileSoft.Model.HSPR.Tb_HSPR_WaiversFee model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new MobileSoft.Model.HSPR.Tb_HSPR_WaiversFee();
                    //model.WaivID=dt.Rows[n]["WaivID"].ToString();
                    if (dt.Rows[n]["CommID"].ToString() != "")
                    {
                        model.CommID = int.Parse(dt.Rows[n]["CommID"].ToString());
                    }
                    //model.CustID=dt.Rows[n]["CustID"].ToString();
                    //model.RoomID=dt.Rows[n]["RoomID"].ToString();
                    //model.CostID=dt.Rows[n]["CostID"].ToString();
                    if (dt.Rows[n]["WaivAmount"].ToString() != "")
                    {
                        model.WaivAmount = decimal.Parse(dt.Rows[n]["WaivAmount"].ToString());
                    }
                    if (dt.Rows[n]["WaivedAmount"].ToString() != "")
                    {
                        model.WaivedAmount = decimal.Parse(dt.Rows[n]["WaivedAmount"].ToString());
                    }
                    if (dt.Rows[n]["WaivStateDuring"].ToString() != "")
                    {
                        model.WaivStateDuring = DateTime.Parse(dt.Rows[n]["WaivStateDuring"].ToString());
                    }
                    if (dt.Rows[n]["WaivEndDuring"].ToString() != "")
                    {
                        model.WaivEndDuring = DateTime.Parse(dt.Rows[n]["WaivEndDuring"].ToString());
                    }
                    if (dt.Rows[n]["WaivDate"].ToString() != "")
                    {
                        model.WaivDate = DateTime.Parse(dt.Rows[n]["WaivDate"].ToString());
                    }
                    if (dt.Rows[n]["WaivMonthAmount"].ToString() != "")
                    {
                        model.WaivMonthAmount = decimal.Parse(dt.Rows[n]["WaivMonthAmount"].ToString());
                    }
                    model.UserCode      = dt.Rows[n]["UserCode"].ToString();
                    model.WaivReason    = dt.Rows[n]["WaivReason"].ToString();
                    model.AuditReason   = dt.Rows[n]["AuditReason"].ToString();
                    model.WaivMemo      = dt.Rows[n]["WaivMemo"].ToString();
                    model.AuditUserCode = dt.Rows[n]["AuditUserCode"].ToString();
                    if (dt.Rows[n]["IsWaiv"].ToString() != "")
                    {
                        model.IsWaiv = int.Parse(dt.Rows[n]["IsWaiv"].ToString());
                    }
                    if (dt.Rows[n]["IsAudit"].ToString() != "")
                    {
                        model.IsAudit = int.Parse(dt.Rows[n]["IsAudit"].ToString());
                    }
                    if (dt.Rows[n]["WaivType"].ToString() != "")
                    {
                        model.WaivType = int.Parse(dt.Rows[n]["WaivType"].ToString());
                    }
                    if (dt.Rows[n]["WaivRates"].ToString() != "")
                    {
                        model.WaivRates = decimal.Parse(dt.Rows[n]["WaivRates"].ToString());
                    }
                    //model.WaivCostID=dt.Rows[n]["WaivCostID"].ToString();
                    //model.HandID=dt.Rows[n]["HandID"].ToString();
                    model.MeterSign     = dt.Rows[n]["MeterSign"].ToString();
                    model.AuditUserName = dt.Rows[n]["AuditUserName"].ToString();
                    if (dt.Rows[n]["WaivCreDate"].ToString() != "")
                    {
                        model.WaivCreDate = DateTime.Parse(dt.Rows[n]["WaivCreDate"].ToString());
                    }
                    modelList.Add(model);
                }
            }
            return(modelList);
        }