/// <summary> /// 增加一条数据 /// </summary> public void Add(MobileSoft.Model.HSPR.Tb_HSPR_ParkingHand model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.HSPR.Tb_HSPR_ParkingHand model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <MobileSoft.Model.HSPR.Tb_HSPR_ParkingHand> DataTableToList(DataTable dt) { List <MobileSoft.Model.HSPR.Tb_HSPR_ParkingHand> modelList = new List <MobileSoft.Model.HSPR.Tb_HSPR_ParkingHand>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { MobileSoft.Model.HSPR.Tb_HSPR_ParkingHand model; for (int n = 0; n < rowsCount; n++) { model = new MobileSoft.Model.HSPR.Tb_HSPR_ParkingHand(); //model.HandID=dt.Rows[n]["HandID"].ToString(); if (dt.Rows[n]["CommID"].ToString() != "") { model.CommID = int.Parse(dt.Rows[n]["CommID"].ToString()); } //model.ParkID=dt.Rows[n]["ParkID"].ToString(); //model.CustID=dt.Rows[n]["CustID"].ToString(); //model.RoomID=dt.Rows[n]["RoomID"].ToString(); if (dt.Rows[n]["ApplyDate"].ToString() != "") { model.ApplyDate = DateTime.Parse(dt.Rows[n]["ApplyDate"].ToString()); } model.InfoSource = dt.Rows[n]["InfoSource"].ToString(); model.UseProperty = dt.Rows[n]["UseProperty"].ToString(); if (dt.Rows[n]["ParkStartDate"].ToString() != "") { model.ParkStartDate = DateTime.Parse(dt.Rows[n]["ParkStartDate"].ToString()); } if (dt.Rows[n]["ParkEndDate"].ToString() != "") { model.ParkEndDate = DateTime.Parse(dt.Rows[n]["ParkEndDate"].ToString()); } model.PayPeriod = dt.Rows[n]["PayPeriod"].ToString(); if (dt.Rows[n]["NextPayDate"].ToString() != "") { model.NextPayDate = DateTime.Parse(dt.Rows[n]["NextPayDate"].ToString()); } model.RentMode = dt.Rows[n]["RentMode"].ToString(); model.Contact = dt.Rows[n]["Contact"].ToString(); model.handling = dt.Rows[n]["handling"].ToString(); if (dt.Rows[n]["HandDate"].ToString() != "") { model.HandDate = DateTime.Parse(dt.Rows[n]["HandDate"].ToString()); } if (dt.Rows[n]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(dt.Rows[n]["IsDelete"].ToString()); } if (dt.Rows[n]["IsSubmit"].ToString() != "") { model.IsSubmit = int.Parse(dt.Rows[n]["IsSubmit"].ToString()); } model.ParkingCarSign = dt.Rows[n]["ParkingCarSign"].ToString(); model.CarSign = dt.Rows[n]["CarSign"].ToString(); model.CarType = dt.Rows[n]["CarType"].ToString(); model.FacBrands = dt.Rows[n]["FacBrands"].ToString(); model.CarColor = dt.Rows[n]["CarColor"].ToString(); model.CarEmission = dt.Rows[n]["CarEmission"].ToString(); model.Phone = dt.Rows[n]["Phone"].ToString(); if (dt.Rows[n]["IsUse"].ToString() != "") { model.IsUse = int.Parse(dt.Rows[n]["IsUse"].ToString()); } if (dt.Rows[n]["IsInput"].ToString() != "") { model.IsInput = int.Parse(dt.Rows[n]["IsInput"].ToString()); } if (dt.Rows[n]["NextDate"].ToString() != "") { model.NextDate = DateTime.Parse(dt.Rows[n]["NextDate"].ToString()); } if (dt.Rows[n]["HandSynchCode"].ToString() != "") { model.HandSynchCode = new Guid(dt.Rows[n]["HandSynchCode"].ToString()); } if (dt.Rows[n]["SynchFlag"].ToString() != "") { model.SynchFlag = int.Parse(dt.Rows[n]["SynchFlag"].ToString()); } if (dt.Rows[n]["IsListing"].ToString() != "") { model.IsListing = int.Parse(dt.Rows[n]["IsListing"].ToString()); } if (dt.Rows[n]["ListingData"].ToString() != "") { model.ListingData = DateTime.Parse(dt.Rows[n]["ListingData"].ToString()); } modelList.Add(model); } } return(modelList); }