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; }