/// <summary> /// 增加一条数据 /// </summary> public int Add(MobileSoft.Model.Sys.Tb_Sys_TakePicSec model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.Sys.Tb_Sys_TakePicSec model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <MobileSoft.Model.Sys.Tb_Sys_TakePicSec> DataTableToList(DataTable dt) { List <MobileSoft.Model.Sys.Tb_Sys_TakePicSec> modelList = new List <MobileSoft.Model.Sys.Tb_Sys_TakePicSec>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { MobileSoft.Model.Sys.Tb_Sys_TakePicSec model; for (int n = 0; n < rowsCount; n++) { model = new MobileSoft.Model.Sys.Tb_Sys_TakePicSec(); //model.StatID=dt.Rows[n]["StatID"].ToString(); if (dt.Rows[n]["StatType"].ToString() != "") { model.StatType = int.Parse(dt.Rows[n]["StatType"].ToString()); } if (dt.Rows[n]["CommID"].ToString() != "") { model.CommID = int.Parse(dt.Rows[n]["CommID"].ToString()); } model.OrganCode = dt.Rows[n]["OrganCode"].ToString(); if (dt.Rows[n]["StatDate"].ToString() != "") { model.StatDate = DateTime.Parse(dt.Rows[n]["StatDate"].ToString()); } if (dt.Rows[n]["ManageCount"].ToString() != "") { model.ManageCount = int.Parse(dt.Rows[n]["ManageCount"].ToString()); } if (dt.Rows[n]["ManageArea"].ToString() != "") { model.ManageArea = decimal.Parse(dt.Rows[n]["ManageArea"].ToString()); } if (dt.Rows[n]["ManageCount1"].ToString() != "") { model.ManageCount1 = int.Parse(dt.Rows[n]["ManageCount1"].ToString()); } if (dt.Rows[n]["ManageArea1"].ToString() != "") { model.ManageArea1 = decimal.Parse(dt.Rows[n]["ManageArea1"].ToString()); } if (dt.Rows[n]["ManageCount2"].ToString() != "") { model.ManageCount2 = int.Parse(dt.Rows[n]["ManageCount2"].ToString()); } if (dt.Rows[n]["ManageArea2"].ToString() != "") { model.ManageArea2 = decimal.Parse(dt.Rows[n]["ManageArea2"].ToString()); } if (dt.Rows[n]["ManageCount3"].ToString() != "") { model.ManageCount3 = int.Parse(dt.Rows[n]["ManageCount3"].ToString()); } if (dt.Rows[n]["ManageArea3"].ToString() != "") { model.ManageArea3 = decimal.Parse(dt.Rows[n]["ManageArea3"].ToString()); } if (dt.Rows[n]["ManageCountNew"].ToString() != "") { model.ManageCountNew = int.Parse(dt.Rows[n]["ManageCountNew"].ToString()); } if (dt.Rows[n]["ManageAreaNew"].ToString() != "") { model.ManageAreaNew = decimal.Parse(dt.Rows[n]["ManageAreaNew"].ToString()); } if (dt.Rows[n]["AllArea"].ToString() != "") { model.AllArea = decimal.Parse(dt.Rows[n]["AllArea"].ToString()); } if (dt.Rows[n]["ProUseArea1"].ToString() != "") { model.ProUseArea1 = decimal.Parse(dt.Rows[n]["ProUseArea1"].ToString()); } if (dt.Rows[n]["ProUseArea2"].ToString() != "") { model.ProUseArea2 = decimal.Parse(dt.Rows[n]["ProUseArea2"].ToString()); } if (dt.Rows[n]["ProUseArea3"].ToString() != "") { model.ProUseArea3 = decimal.Parse(dt.Rows[n]["ProUseArea3"].ToString()); } if (dt.Rows[n]["ProUseRoomNum1"].ToString() != "") { model.ProUseRoomNum1 = int.Parse(dt.Rows[n]["ProUseRoomNum1"].ToString()); } if (dt.Rows[n]["ProUseRoomNum2"].ToString() != "") { model.ProUseRoomNum2 = int.Parse(dt.Rows[n]["ProUseRoomNum2"].ToString()); } if (dt.Rows[n]["ProUseRoomNum3"].ToString() != "") { model.ProUseRoomNum3 = int.Parse(dt.Rows[n]["ProUseRoomNum3"].ToString()); } if (dt.Rows[n]["ParkAllNum"].ToString() != "") { model.ParkAllNum = int.Parse(dt.Rows[n]["ParkAllNum"].ToString()); } if (dt.Rows[n]["ParkSaleNum"].ToString() != "") { model.ParkSaleNum = int.Parse(dt.Rows[n]["ParkSaleNum"].ToString()); } if (dt.Rows[n]["ParkLeaseNum"].ToString() != "") { model.ParkLeaseNum = int.Parse(dt.Rows[n]["ParkLeaseNum"].ToString()); } if (dt.Rows[n]["ParkEmptyNum"].ToString() != "") { model.ParkEmptyNum = int.Parse(dt.Rows[n]["ParkEmptyNum"].ToString()); } if (dt.Rows[n]["CommKindRoomNum"].ToString() != "") { model.CommKindRoomNum = int.Parse(dt.Rows[n]["CommKindRoomNum"].ToString()); } if (dt.Rows[n]["CommKindArea1"].ToString() != "") { model.CommKindArea1 = decimal.Parse(dt.Rows[n]["CommKindArea1"].ToString()); } if (dt.Rows[n]["CommKindCount1"].ToString() != "") { model.CommKindCount1 = int.Parse(dt.Rows[n]["CommKindCount1"].ToString()); } if (dt.Rows[n]["CommKindRoomNum1"].ToString() != "") { model.CommKindRoomNum1 = int.Parse(dt.Rows[n]["CommKindRoomNum1"].ToString()); } if (dt.Rows[n]["CommKindArea2"].ToString() != "") { model.CommKindArea2 = decimal.Parse(dt.Rows[n]["CommKindArea2"].ToString()); } if (dt.Rows[n]["CommKindCount2"].ToString() != "") { model.CommKindCount2 = int.Parse(dt.Rows[n]["CommKindCount2"].ToString()); } if (dt.Rows[n]["CommKindRoomNum2"].ToString() != "") { model.CommKindRoomNum2 = int.Parse(dt.Rows[n]["CommKindRoomNum2"].ToString()); } if (dt.Rows[n]["ChargeRateTheMonth"].ToString() != "") { model.ChargeRateTheMonth = decimal.Parse(dt.Rows[n]["ChargeRateTheMonth"].ToString()); } if (dt.Rows[n]["ChargeRateTheYear"].ToString() != "") { model.ChargeRateTheYear = decimal.Parse(dt.Rows[n]["ChargeRateTheYear"].ToString()); } if (dt.Rows[n]["ChargeRateLastYear"].ToString() != "") { model.ChargeRateLastYear = decimal.Parse(dt.Rows[n]["ChargeRateLastYear"].ToString()); } if (dt.Rows[n]["ChargeRateTheMonth1"].ToString() != "") { model.ChargeRateTheMonth1 = decimal.Parse(dt.Rows[n]["ChargeRateTheMonth1"].ToString()); } if (dt.Rows[n]["ChargeRateTheYear1"].ToString() != "") { model.ChargeRateTheYear1 = decimal.Parse(dt.Rows[n]["ChargeRateTheYear1"].ToString()); } if (dt.Rows[n]["ChargeRateLastYear1"].ToString() != "") { model.ChargeRateLastYear1 = decimal.Parse(dt.Rows[n]["ChargeRateLastYear1"].ToString()); } if (dt.Rows[n]["ChargeRateTheMonth2"].ToString() != "") { model.ChargeRateTheMonth2 = decimal.Parse(dt.Rows[n]["ChargeRateTheMonth2"].ToString()); } if (dt.Rows[n]["ChargeRateTheYear2"].ToString() != "") { model.ChargeRateTheYear2 = decimal.Parse(dt.Rows[n]["ChargeRateTheYear2"].ToString()); } if (dt.Rows[n]["ChargeRateLastYear2"].ToString() != "") { model.ChargeRateLastYear2 = decimal.Parse(dt.Rows[n]["ChargeRateLastYear2"].ToString()); } if (dt.Rows[n]["IncidCustHasNum"].ToString() != "") { model.IncidCustHasNum = int.Parse(dt.Rows[n]["IncidCustHasNum"].ToString()); } if (dt.Rows[n]["IncidCustNoNum"].ToString() != "") { model.IncidCustNoNum = int.Parse(dt.Rows[n]["IncidCustNoNum"].ToString()); } if (dt.Rows[n]["IncidCustDayRate"].ToString() != "") { model.IncidCustDayRate = int.Parse(dt.Rows[n]["IncidCustDayRate"].ToString()); } if (dt.Rows[n]["IncidCustMonthRate"].ToString() != "") { model.IncidCustMonthRate = int.Parse(dt.Rows[n]["IncidCustMonthRate"].ToString()); } if (dt.Rows[n]["IncidCustYearRate"].ToString() != "") { model.IncidCustYearRate = int.Parse(dt.Rows[n]["IncidCustYearRate"].ToString()); } if (dt.Rows[n]["IncidCustAllNoNum"].ToString() != "") { model.IncidCustAllNoNum = int.Parse(dt.Rows[n]["IncidCustAllNoNum"].ToString()); } if (dt.Rows[n]["IncidCustDayNoNum"].ToString() != "") { model.IncidCustDayNoNum = int.Parse(dt.Rows[n]["IncidCustDayNoNum"].ToString()); } if (dt.Rows[n]["IncidCustWeekNoNum"].ToString() != "") { model.IncidCustWeekNoNum = int.Parse(dt.Rows[n]["IncidCustWeekNoNum"].ToString()); } if (dt.Rows[n]["IncidCustMonthNoNum"].ToString() != "") { model.IncidCustMonthNoNum = int.Parse(dt.Rows[n]["IncidCustMonthNoNum"].ToString()); } if (dt.Rows[n]["IncidCompDayNum"].ToString() != "") { model.IncidCompDayNum = int.Parse(dt.Rows[n]["IncidCompDayNum"].ToString()); } if (dt.Rows[n]["IncidCompMonthNum"].ToString() != "") { model.IncidCompMonthNum = int.Parse(dt.Rows[n]["IncidCompMonthNum"].ToString()); } if (dt.Rows[n]["IncidCompYearNum"].ToString() != "") { model.IncidCompYearNum = int.Parse(dt.Rows[n]["IncidCompYearNum"].ToString()); } if (dt.Rows[n]["CurFeesRate_Deno"].ToString() != "") { model.CurFeesRate_Deno = decimal.Parse(dt.Rows[n]["CurFeesRate_Deno"].ToString()); } if (dt.Rows[n]["CurFeesRate_Mole"].ToString() != "") { model.CurFeesRate_Mole = decimal.Parse(dt.Rows[n]["CurFeesRate_Mole"].ToString()); } if (dt.Rows[n]["CurYearFeesRate_Deno"].ToString() != "") { model.CurYearFeesRate_Deno = decimal.Parse(dt.Rows[n]["CurYearFeesRate_Deno"].ToString()); } if (dt.Rows[n]["CurYearFeesRate_Mole"].ToString() != "") { model.CurYearFeesRate_Mole = decimal.Parse(dt.Rows[n]["CurYearFeesRate_Mole"].ToString()); } if (dt.Rows[n]["BefLastFeesRate_Deno"].ToString() != "") { model.BefLastFeesRate_Deno = decimal.Parse(dt.Rows[n]["BefLastFeesRate_Deno"].ToString()); } if (dt.Rows[n]["BefLastFeesRate_Mole"].ToString() != "") { model.BefLastFeesRate_Mole = decimal.Parse(dt.Rows[n]["BefLastFeesRate_Mole"].ToString()); } if (dt.Rows[n]["IncidFinlishDayNum"].ToString() != "") { model.IncidFinlishDayNum = int.Parse(dt.Rows[n]["IncidFinlishDayNum"].ToString()); } if (dt.Rows[n]["IncidHappenDayNum"].ToString() != "") { model.IncidHappenDayNum = int.Parse(dt.Rows[n]["IncidHappenDayNum"].ToString()); } if (dt.Rows[n]["IncidFinlishMonthNum"].ToString() != "") { model.IncidFinlishMonthNum = int.Parse(dt.Rows[n]["IncidFinlishMonthNum"].ToString()); } if (dt.Rows[n]["IncidHappenMonthNum"].ToString() != "") { model.IncidHappenMonthNum = int.Parse(dt.Rows[n]["IncidHappenMonthNum"].ToString()); } if (dt.Rows[n]["IncidFinlishYearNum"].ToString() != "") { model.IncidFinlishYearNum = int.Parse(dt.Rows[n]["IncidFinlishYearNum"].ToString()); } if (dt.Rows[n]["IncidHappenYearNum"].ToString() != "") { model.IncidHappenYearNum = int.Parse(dt.Rows[n]["IncidHappenYearNum"].ToString()); } modelList.Add(model); } } return(modelList); }