/// <summary> /// /// </summary> public void Save() { if (IsNew()) { DistributeDBI.Insert(this.NeedWaterClass.NeedWaterID, Begin, End, this.DistributeAmount, this.Remark); } else { DistributeDBI.Update(this.DistributeWaterID, Begin, End, this.DistributeAmount, this.Remark); } }
/// <summary> /// /// </summary> /// <param name="begin"></param> /// <param name="end"></param> /// <returns></returns> public DataTable GetDistributeWaterDataTable(DateTime begin, DateTime end) { DataTable r = null; foreach (WaterUserClass w in this) { DataTable t = DistributeDBI.GetDistributeDataTable(w.WaterUserID, begin, end); if (r == null) { r = t; } else { r.Merge(t); } } return(r); }
/// <summary> /// /// </summary> /// <param name="distributeID"></param> /// <returns></returns> static public DistributeClass CreateByID(int distributeID) { DataTable tbl = DistributeDBI.GetDistributeDataTableByID(distributeID); if (tbl.Rows.Count > 0) { DataRow row = tbl.Rows[0]; DistributeClass d = new DistributeClass(); d.Begin = Convert.ToDateTime(row[DBNames.tblDistributeWater.DistributeBeginDT]); d.End = Convert.ToDateTime(row[DBNames.tblDistributeWater.DistributeEndDT]); d.DistributeAmount = Convert.ToInt32(row[DBNames.tblDistributeWater.DistributeAmount]); d.DistributeWaterID = Convert.ToInt32(row[DBNames.tblDistributeWater.DistributeWaterID]); d.Remark = row[DBNames.tblDistributeWater.Remark].ToString(); int needID = Convert.ToInt32(row[DBNames.tblDistributeWater.NeedWaterID]); d.NeedWaterClass = NeedWaterClass.CreateByID(needID); return(d); } else { return(null); } }
/// <summary> /// 获取用水户的配水信息 /// </summary> /// <param name="begin"></param> /// <param name="end"></param> /// <remarks> /// 由该用户的上级单位向其分配的水量信息 /// </remarks> /// <returns></returns> public DataTable GetDistributeWaterDataTable(DateTime begin, DateTime end) { return(DistributeDBI.GetDistributeDataTable(this.WaterUserID, begin, end)); }