private dynamic GetSqlQueryString(string beingTime = "", string endTime = "", QuestTypeEnum typeEnum = QuestTypeEnum.DefaultQuest, string ordernum = "")
{
string BTime = Convert.ToDateTime(beingTime).ToString(@"yyyy-MM-dd");
string ETime = Convert.ToDateTime(endTime).Date.AddHours(23).AddMinutes(59).AddSeconds(59).ToString(@"yyyy-MM-dd HH:mm:ss");
if (typeEnum == QuestTypeEnum.DefaultQuest)
{
return(QuerySqlstr = string.Format(@"select * from T_BDX_ORDER where DDRQ >= '{0}' and DDRQ <= '{1}' ORDER BY DDRQ DESC", BTime, ETime));
}
// if (typeEnum == QuestTypeEnum.GroupByQuest) return string.Format(@"select t.DDNO, t.DDRQ,t.KH,t.DW, SUM(to_number(t.SL)) as SL from T_BDX_ORDER t where DDRQ >= '{0}' and DDRQ <= '{1}' Group by t.DDNO ,t.DDRQ,t.KH,t.DW", BTime,ETime);
if (typeEnum == QuestTypeEnum.OrderNumQuest)
{
return(QuerySqlstr = string.Format(@"select * from T_BDX_ORDER where DDRQ >= '{0}' and DDRQ <= '{1}' and DDNO LIKE '%{2}%' ORDER BY DDRQ DESC ", BTime, ETime, ordernum));
}
//return string.Format(@"select t.DDNO, t.DDRQ,t.KH,t.DW, SUM(t.SL) as SL from T_BDX_ORDER t where t.DDNO = '{0}' Group by t.DDNO ,t.DDRQ,t.KH,t.DW", ordernum);
return("");
}
public ShowMyQuestCommand(int playerId, QuestTypeEnum type)
{
PlayerId = playerId;
Type = type;
}
