/// <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>
/// <returns></returns>
public List <SceneryDomain> GetStaticDomain()
{
QueryCondition query = QueryCondition.Instance.AddEqual("Scenery", "RowState", "1");
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
strSql.Append("select Rate,AccountId,AccountPwd,AppName,Scenery.Id,SceneryName,SceneryTCId,AlipayId,APP_ID,ALIPAY_PUBLIC_KEY,APP_PRIVATE_KEY,APP_PUBLIC_KEY");
strSql.Append(",WeChatId,WeChatRate,[APPID],[MCHID],[PAYKEY],[APPSECRET],[SSLCERT_PATH],[SSLCERT_PASSWORD] ");
strSql.Append(" FROM Scenery left join Alipay on Alipay.id=Scenery.AlipayId ");
strSql.Append(" LEFT JOIN WxPayConfig ON WxPayConfig.Id=Scenery.WeChatId");
strSql.Append(query.GetSQL_Where(parameters));
strSql.Append(query.GetSQL_Order());
return(ReadAdoTemplate.QueryWithRowMapperDelegate <SceneryDomain>(CommandType.Text, strSql.ToString(), MapRow_Model, parameters).ToList());
}
/// <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>
/// 获取id
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public int GetId(QueryCondition query)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id ");
strSql.Append(" FROM Base_ProductionLine ");
strSql.Append(query.GetSQL_Where(parameters));
strSql.Append(query.GetSQL_Order());
var result = ReadAdoTemplate.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (result == null || result is DBNull)
{
return(-1);
}
return(Convert.ToInt32(result));
}
/// <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 <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 <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 <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_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 <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 <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 <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 <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 <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 <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 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_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 <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 <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 <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 <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 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));
}
