/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Pro_Scheduling> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Id,ProNo,ShipMainProNo,PlanFromDate,PlanToDate,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" from Pro_Scheduling "); string otherWhere = ""; if (query.GetCondition("PlanFromDate") != null) { } if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters, otherWhere)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_Scheduling>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList <SceneryOrderRefundDomain> GetAllDomain(QueryCondition query, Hashtable hsWhere) { query.AddEqual("RowState", "1").AddOrderBy("Id", false); var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); StringBuilder otherWhere = new StringBuilder(); if (hsWhere.ContainsKey("ApprovalStatus")) { otherWhere.AppendFormat(" and ApprovalStatus in (0,1)"); } strSql.Append("select Id,SceneryTCId,SceneryName,BatchNumber,SerialId,PlayDate,Total,ApprovalStatus,PayType,CreateTime,Creater,UpdateTime,Updater,RowState from SceneryOrderRefund "); if (query.GetPager() != null) { string sumSql = "sum(Total) as SumTotal"; strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters, otherWhere.ToString(), sumSql)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(otherWhere); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <SceneryOrderRefundDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
public string GetPagerSql(string sqlBody, QueryCondition query, IDbParameters parameters, string otherWhere = "", string otherSum = "") { PagerDomain domain = query.GetPager(); string strWhere = query.GetSQL_Where(parameters).ToString(); string orderby = query.GetSQL_Order().ToString(); #region 查询总条数 var strSql = new StringBuilder(); strSql.Append("select count(1) "); if (!string.IsNullOrEmpty(otherSum)) { strSql.Append("," + otherSum); } strSql.Append(sqlBody.Substring(sqlBody.ToUpper().IndexOf(" FROM "))); if (!string.IsNullOrEmpty(strWhere.Trim())) { strSql.Append(strWhere); } if (!string.IsNullOrEmpty(otherWhere.Trim())) { strSql.Append(otherWhere); } var allCount = DataSet_ReadAdoTemplate.DataSetCreateWithParams(CommandType.Text, strSql.ToString(), parameters); domain.TotalCount = Convert.ToInt32(allCount.Tables[0].Rows[0][0]); domain.SumDT = allCount.Tables[0]; #endregion #region 拼接好的分页SQL strSql = new StringBuilder(); strSql.Append("SELECT * FROM ( "); strSql.Append(" SELECT ROW_NUMBER() OVER ("); if (!string.IsNullOrEmpty(orderby.Trim())) { strSql.Append(orderby); } strSql.AppendFormat(")AS Row, {0} ", sqlBody.Substring(sqlBody.ToUpper().IndexOf("SELECT ") + 7)); if (!string.IsNullOrEmpty(strWhere.Trim())) { strSql.Append(strWhere); } if (!string.IsNullOrEmpty(otherWhere.Trim())) { strSql.Append(otherWhere); } strSql.Append(" ) TT"); strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", ((domain.CurrentPage - 1) * domain.PageSize + 1), domain.CurrentPage * domain.PageSize); #endregion return(strSql.ToString()); }
/// <summary> /// 查询并返回总记录数和总页数 /// </summary> /// <param name="condition">查询条件</param> /// <param name="recordCount">总记录数</param> /// <param name="pageCount">总页数</param> /// <returns></returns> public virtual IList <T> Query(QueryCondition condition, out int recordCount, out int pageCount) { recordCount = 0; pageCount = 0; DataSet ds = QueryBase(condition); if (ds != null && ds.Tables[0] != null) { recordCount = int.Parse(ds.Tables[0].Rows[0][0].ToString()); int pageSize = condition.GetPager().PageSize; pageCount = (recordCount + pageSize - 1) / pageSize; } return(DataSetToList(condition, ds)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList <Pro_Scheduling> GetList(QueryCondition query, Hashtable hs) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Id,ProNo,ShipMainProNo,PlanFromDate,PlanToDate,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" from Pro_Scheduling "); string otherWhere = ""; if (hs.ContainsKey("PlanFromDate")) { otherWhere += string.Format(" and '{0}'>=PlanFromDate and '{0}'<=PlanToDate", hs["PlanFromDate"]); } if (hs.ContainsKey("LineNo")) { otherWhere += string.Format(" and Exists(select id from Pro_SchedulingLine where ProLineNo like '%{0}%' and Pro_SchedulingLine.MainId=Pro_Scheduling.Id)", hs["LineNo"]); } if (hs.ContainsKey("GoodNo") || hs.ContainsKey("GoodName") || hs.ContainsKey("ShipTo")) { otherWhere += " and Id in (select MainId from Pro_SchedulingLine left join Pro_SchedulingGoods on Pro_SchedulingGoods.SLineId=Pro_SchedulingLine.Id where 1=1 "; if (hs.ContainsKey("GoodNo")) { otherWhere += string.Format(" and GoodNo like '%{0}%'", hs["GoodNo"]); } if (hs.ContainsKey("GoodName")) { otherWhere += string.Format(" and GoodName like '%{0}%'", hs["GoodName"]); } if (hs.ContainsKey("ShipTo")) { otherWhere += string.Format(" and ShipTo like '%{0}%'", hs["ShipTo"]); } otherWhere += " )"; } if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters, otherWhere)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_Scheduling>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList<Base_Stock> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,MainId,Location,WH,GoodNo,GoodName,Qty,Batch,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM Base_Stock "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return ReadAdoTemplate.QueryWithRowMapperDelegate<Base_Stock>(CommandType.Text, strSql.ToString(), MapRow, parameters); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Pro_SchedulingLine> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,MainId,ProLineNo,MorningShift,MiddleShift,EveningShift "); strSql.Append(" FROM Pro_SchedulingLine "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_SchedulingLine>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Pro_PSDetail> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,MainId,GoodNo,GoodName,ShipTo,ShipToName,PackNum,Qty,ChanNeng,ProOrderIndex,SType,StartTime,EndTime "); strSql.Append(" FROM Pro_PSDetail "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_PSDetail>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Base_ProductionLines> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,ProLineId,People,Number "); strSql.Append(" FROM Base_ProductionLines "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Base_ProductionLines>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <MenuDomain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,DisplayName,MenuIndex "); strSql.Append(" FROM SetUp_Menu "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <MenuDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Pro_SchedulingGoods> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,SLineId,GoodNo,GoodName,ShipTo,ShipToName,StockNum,PackNum,MorningNum,MiddleNum,EveningNum,ParentGoodNo,ParentGoodName "); strSql.Append(" FROM Pro_SchedulingGoods "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_SchedulingGoods>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Base_ProductionLine> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,ProLineNo,GoodNo,GoodName,PCS,StandPers,MinProNum,BoxNum,LineMins,ProShift,ProCapacityDesc,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM Base_ProductionLine "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Base_ProductionLine>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Pro_PS> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,SchedulingProNo,ProNo,LineId,ProLineNo,ProDate,FinalMorningNum,FinalMiddleNum,FinalEveningNum,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM Pro_PS "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_PS>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Pro_ShipPlanMain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,ProNo,PlanFromDate,PlanFromTo,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM Pro_ShipPlanMain "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_ShipPlanMain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 微信 /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <WeChatDetailDomain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,AppId,SceneryName,BatchNumber,SerialId,Result_code,Err_code,Err_code_des,Openid,Trade_type,Bank_type,Total_fee,Settlement_total_fee,Transaction_id,Out_trade_no,Time_end,SceneryRate,WeChatPlayDate,Out_refund_no,Refund_id,CreateTime,Creater,UpdateTime,Updater,RowState from WeChatDetail "); if (query.GetPager() != null) { string sumSql = "sum(Total_fee) as SumTotal_fee"; strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters, "", sumSql)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <WeChatDetailDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Pro_ShipPlan> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,MainId,ScheduleNo,Term,EditionNo,CityNo,ShipDetailNo,ShipTo,ShipToName,GoodNo,GoodName"); strSql.Append(" FROM Pro_ShipPlan "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_ShipPlan>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Pro_SchedulingGoodsNum> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,SGoodId,SType,SDate,SNum "); strSql.Append(" FROM Pro_SchedulingGoodsNum "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_SchedulingGoodsNum>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Role_FunctionDomain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,FormId,FunctionId,RoleId,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM SetUp_Role_Function "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Role_FunctionDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <WxPayConfigDomain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,WeAppName,APPID,MCHID,PAYKEY,APPSECRET,SSLCERT_PATH,SSLCERT_PASSWORD,Remark,CreateTime,Creater,UpdateTime,Updater,RowState from WxPayConfig "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <WxPayConfigDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <Base_Ship> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,ShipTo,ShipToName,CityNo,City,ShipToHour,ShipToMins,LeadTime,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM Base_Ship "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Base_Ship>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <AlipayDomain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select PID,Remark,Id,AppName,APP_ID,ALIPAY_PUBLIC_KEY,APP_PRIVATE_KEY,APP_PUBLIC_KEY,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM Alipay "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <AlipayDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <AlipayQRCodeDomain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append(" Select Phone,AppId,Id,Out_trade_no,SceneryName,BatchNumber,RequestJson,QrCode,Remark,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM AlipayQRCode "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <AlipayQRCodeDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList <Pro_ShipPlanMain> GetList(QueryCondition query, Hashtable hs) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,ProNo,PlanFromDate,PlanFromTo,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM Pro_ShipPlanMain "); string otherWhere = ""; if (hs.ContainsKey("PlanDate")) { otherWhere += string.Format(" and '{0}'>=PlanFromDate and '{0}'<=PlanFromTo", hs["PlanFromDate"]); } if (hs.ContainsKey("GoodNo") || hs.ContainsKey("GoodName") || hs.ContainsKey("ShipTo")) { otherWhere += " and Exists (select id from Pro_ShipPlan where Pro_ShipPlan.MainId=Pro_ShipPlanMain.Id "; if (hs.ContainsKey("GoodNo")) { otherWhere += string.Format(" and GoodNo like '%{0}%'", hs["GoodNo"]); } if (hs.ContainsKey("GoodName")) { otherWhere += string.Format(" and GoodName like '%{0}%'", hs["GoodName"]); } if (hs.ContainsKey("ShipTo")) { otherWhere += string.Format(" and ShipTo like '%{0}%'", hs["ShipTo"]); } otherWhere += " )"; } if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters, otherWhere)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_ShipPlanMain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <AlipayDetailDomain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select AlipayPlayDate,SceneryRate,BatchNumber,SerialId,AppId,Id,SceneryName,Buyer_logon_id,Out_trade_no,Send_pay_date,Total_amount,Trade_no,Trade_status,Code,Msg,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM AlipayDetail "); if (query.GetPager() != null) { string sumSql = "sum(Total_amount) as SumTotal_amount"; strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters, "", sumSql)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <AlipayDetailDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <SceneryDomain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Rate,AccountId,AccountPwd,AppName,WeAppName,Scenery.Id,SceneryName,SceneryTCId,AlipayId,Scenery.CreateTime,Scenery.Creater,Scenery.UpdateTime,Scenery.Updater,Scenery.RowState,WeChatRate,WeChatId "); strSql.Append(" FROM Scenery left join Alipay on Alipay.id=Scenery.AlipayId"); strSql.Append(" LEFT JOIN WxPayConfig ON WxPayConfig.Id=Scenery.WeChatId"); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <SceneryDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 获取信息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public override IList <UserDomain> GetAllDomain(QueryCondition query) { var parameters = WriteAdoTemplate.CreateDbParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,loginId,loginPwd,loginState,Name,UserState,Phone,Email,Sex,Position,Leader,Company,Avatar,CreateTime,Creater,UpdateTime,Updater,RowState "); strSql.Append(" FROM SetUp_User "); if (query.GetPager() != null) { strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters)); } else { // strSql.Append(" where 1=1 AND LoginId='admin'"); strSql.Append(query.GetSQL_Where(parameters)); strSql.Append(query.GetSQL_Order()); } return(ReadAdoTemplate.QueryWithRowMapperDelegate <UserDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters)); }
/// <summary> /// 查询结果的DataSet转为List /// </summary> /// <param name="condition">查询条件</param> /// <param name="ds">数据集</param> /// <returns></returns> public virtual IList <T> DataSetToList(QueryCondition condition, DataSet ds) { try { IList <T> list = new List <T>(); if (ds != null && ds.Tables.Count > 0) { IList <string> fields = condition.SelectFields; DataTable dt = condition.GetPager() != null ? ds.Tables[1] : ds.Tables[0]; foreach (DataRow dr in dt.Rows) { list.Add(Model.SetModelValueByDataRow(dr, fields)); } } return(list); } catch (Exception e) { throw new Exception("将数据表转换成对象时出错!", e); } }