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