chuanyin-group-project.git

			@@ -39,6 +39,28 @@
			/// 分页默认排序字段
			/// </summary>
			const string ORDERBY = " case when Sort is null then 1 else 0 end asc,Sort asc ";


			/// <summary>
			/// 查询目标
			/// </summary>
			const string SELECTTARGET1 = " t.* ";
			/// <summary>
			/// 查询来源
			/// </summary>
			const string FROMSOUCEBEFORE1 = " ( select od.*, " +
			" oss.Name as DriverName, os.Name as ZerenrenName " +
			" from [OA_DeliverPlanPaiche] od " +
			" left join [OA_Staff] os on od.Zerenren = os.Keyid " +
			" left join [OA_Staff] oss on od.[DriverId] = oss.Keyid " +

			" where 0=0 ";
			const string FROMSOUCEEND1 = ") as t ";
			/// <summary>
			/// 分页默认排序字段
			/// </summary>
			const string ORDERBY1 = " DeliveredTime desc ";

			#endregion
			public OA_DeliverPlanPaicheDAL()
			{
			@@ -167,6 +189,25 @@
			LastUpdateTime = new SqlParameter("@LastUpdateTime", DBNull.Value);
			}

			SqlParameter WanjieTime = null;
			if (trueModel.WanjieTime.HasValue)
			{
			WanjieTime = new SqlParameter("@WanjieTime", trueModel.WanjieTime.Value);
			}
			else
			{
			WanjieTime = new SqlParameter("@WanjieTime", DBNull.Value);
			}
			SqlParameter ZerenTime = null;
			if (trueModel.ZerenTime.HasValue)
			{
			ZerenTime = new SqlParameter("@ZerenTime", trueModel.ZerenTime.Value);
			}
			else
			{
			ZerenTime = new SqlParameter("@ZerenTime", DBNull.Value);
			}

			IList<SqlParameter> sqlParms = new List<SqlParameter>()
			{

			@@ -202,8 +243,18 @@
			new SqlParameter("@TransferType",trueModel.TransferType.HasValue?trueModel.TransferType.Value:0),
			new SqlParameter("@TransferName",string.IsNullOrEmpty(trueModel.TransferName)?"":trueModel.TransferName),

			new SqlParameter("@Wanjiestatus",trueModel.Wanjiestatus.HasValue?trueModel.Wanjiestatus.Value:0),
			WanjieTime,
			new SqlParameter("@Wanjieren",string.IsNullOrEmpty(trueModel.Wanjieren)?"":trueModel.Wanjieren),
			new SqlParameter("@Zerenren",trueModel.Zerenren.HasValue?trueModel.Zerenren.Value:0),
			new SqlParameter("@Fakuan",trueModel.Fakuan.HasValue?trueModel.Fakuan.Value:0),
			ZerenTime,
			new SqlParameter("@Zerenoperater",string.IsNullOrEmpty(trueModel.Zerenoperater)?"":trueModel.Zerenoperater),



			};
			string sql = "Update OA_DeliverPlanPaiche Set [FirmId]=@FirmId,[BuyerId]=@BuyerId,[DeliveredTime]=@DeliveredTime,[Zhuyishixiang]=@Zhuyishixiang,Gongzuokaoping=@Gongzuokaoping, [CarId]=@CarId, [DriverId]=@DriverId,[Transferstatus]=@Transferstatus, [TransfersTime]=@TransfersTime, [Creater]=@Creater,[CreateTime]=@CreateTime,[Updater]=@Updater,[LastUpdateTime]=@LastUpdateTime,Sort=@Sort,DeliverTime=@DeliverTime,wentifankui=@wentifankui,Yichangchuli=@Yichangchuli,Xingzhengzhuize=@Xingzhengzhuize,SellerOrderId=@SellerOrderId,Dianhua=@Dianhua,Dizhi=@Dizhi,Remark=@Remark,BusinessManagerId=@BusinessManagerId,Biddingcompany=@Biddingcompany,shifouDelivery=@shifouDelivery,Lianxiren=@Lianxiren,CompanyName=@CompanyName,Deliveredstatus=@Deliveredstatus,TransferType=@TransferType,TransferName=@TransferName where [Keyid] =@Keyid ";
			string sql = "Update OA_DeliverPlanPaiche Set [FirmId]=@FirmId,[BuyerId]=@BuyerId,[DeliveredTime]=@DeliveredTime,[Zhuyishixiang]=@Zhuyishixiang,Gongzuokaoping=@Gongzuokaoping, [CarId]=@CarId, [DriverId]=@DriverId,[Transferstatus]=@Transferstatus, [TransfersTime]=@TransfersTime, [Creater]=@Creater,[CreateTime]=@CreateTime,[Updater]=@Updater,[LastUpdateTime]=@LastUpdateTime,Sort=@Sort,DeliverTime=@DeliverTime,wentifankui=@wentifankui,Yichangchuli=@Yichangchuli,Xingzhengzhuize=@Xingzhengzhuize,SellerOrderId=@SellerOrderId,Dianhua=@Dianhua,Dizhi=@Dizhi,Remark=@Remark,BusinessManagerId=@BusinessManagerId,Biddingcompany=@Biddingcompany,shifouDelivery=@shifouDelivery,Lianxiren=@Lianxiren,CompanyName=@CompanyName,Deliveredstatus=@Deliveredstatus,TransferType=@TransferType,TransferName=@TransferName,Wanjiestatus=@Wanjiestatus,WanjieTime=@WanjieTime,Wanjieren=@Wanjieren,Zerenren=@Zerenren,Fakuan=@Fakuan,ZerenTime=@ZerenTime,Zerenoperater=@Zerenoperater where [Keyid] =@Keyid ";

			try
			{
			@@ -304,6 +355,34 @@
			return _dataBase.SelectModelPage<Model.OA_DeliverPlan>(pagination, SELECTTARGET, fromSouce, orderbys[0], resultOrderBy);
			}



			/// <summary>
			/// 分页查询
			/// </summary>
			/// <param name="query"></param>
			/// <param name="pagination"></param>
			/// <returns></returns>
			public IEnumerable<Model.OA_DeliverPlan> SelectModelPageWenti(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
			{
			if (null == pagination \|\| null == query \|\| null == query.Criteria \|\| 1 > query.Criteria.Count)
			return null;
			//query.Criteria 首个元素必须是排序字段，其值为结果排序字段

			int maxParamIndex = query.Criteria.Count - 1;//最大索引

			string[] orderbys = new string[] { ORDERBY1 };
			string resultOrderBy = "";//结果集排序方式

			if ("@orderBy".Equals(query.Criteria[maxParamIndex].PropertyName))
			{
			orderbys = string.Format("{0}", query.Criteria[maxParamIndex].Value).Split(',');
			resultOrderBy = query.Criteria[maxParamIndex].Value.ToString();//= 1 == orderbys.Length ? resultOrderBy : orderbys[1];
			}
			string fromSouce = string.Format("{0}{1}{2}", FROMSOUCEBEFORE1, query.Criteria[0].Value, FROMSOUCEEND1);//拼装条件
			return _dataBase.SelectModelPage<Model.OA_DeliverPlan>(pagination, SELECTTARGET1, fromSouce, orderbys[0], resultOrderBy);
			}

			/// <summary>
			/// 删除
			/// </summary>