public static string SetDataOrderQueryBusiness(string mobile, out string name) { String sql = String.Format("select row_number() over(order by CreateTime desc) as [No], OrderID,StoreID,Price,Fee,OrderType,PayStatus,CONVERT(varchar(100), PayTime, 23)as PayTime,CreateTime,Descript,Mobile,BuyType,StoreName,Coins from Data_Order where Mobile='{0}' and PayStatus='1' order by CreateTime desc", mobile); System.Data.DataSet ds = XCGameManabll.ExecuteQuerySentence(sql, null); DataTable dt = ds.Tables[0]; dt.Columns.Add("CreateTimes"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DateTime time1 = Convert.ToDateTime(dt.Rows[i]["CreateTime"]); string CreateTimes = time1.ToString("yyyy-MM-dd H:mm"); dt.Rows[i]["CreateTimes"] = CreateTimes; } var list = Utils.GetModelList <DataOrderModel>(ds.Tables[0]).ToList(); int time = CacheExpires.CommonPageQueryDataCacheTime; DataOrderCaChe.Add(mobile, list, time); name = "1"; return(name); } name = ""; return(name); }
public object getMemberCard(Dictionary <string, object> dicParas) { try { string mobile = string.Empty; MobileTokenModel mobileTokenModel = (MobileTokenModel)(dicParas[Constant.MobileTokenModel]); string sql = "exec SelectMenber @Mobile,@Return output"; SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@Mobile", mobileTokenModel.Mobile); parameters[1] = new SqlParameter("@Return", 0); parameters[1].Direction = System.Data.ParameterDirection.Output; System.Data.DataSet ds = XCGameManabll.ExecuteQuerySentence(sql, parameters); DataTable dt = ds.Tables[0]; if (dt.Rows.Count == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "")); } var list = Utils.GetModelList <TmpmemberModel>(ds.Tables[0]).ToList(); return(ResponseModelFactory <List <TmpmemberModel> > .CreateModel(isSignKeyReturn, list)); } catch (Exception e) { throw e; } }
public static void StoreDogInit() { string errMsg = string.Empty; IStoreService storeService = BLLContainer.Resolve <IStoreService>(); string sql = " exec Selectstoredog"; System.Data.DataSet ds = XCGameManabll.ExecuteQuerySentence(sql, null); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { var list = Utils.GetModelList <StoreDogCacheModel>(ds.Tables[0]).ToList(); StoreDogCache.Add(list); } }
public static void StoreInit() { string errMsg = string.Empty; IStoreService storeService = BLLContainer.Resolve <IStoreService>(); string sql = " select ID as StoreID,store_password as StorePassword,store_dbname as StoreDBName,companyname as StoreName,StoreType,StoreDBDeployType from t_store where state = 1"; System.Data.DataSet ds = XCGameManabll.ExecuteQuerySentence(sql, null); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { var list = Utils.GetModelList <StoreCacheModel>(ds.Tables[0]).ToList(); StoreCache.Add(list); } }
/// <summary> /// 获取订单号 /// </summary> /// <param name="StoreId"></param> /// <returns></returns> public static string GetOrderNo(string storeId, decimal price, decimal fee, int orderType, string productName, string mobile, string buyType, int coins) { string sql = "exec InsertMPOrder @StoreId,@Price,@Fee,@OrderType,@ProductName,@Mobile,@BuyType,@Coins "; SqlParameter[] parameters = new SqlParameter[8]; parameters[0] = new SqlParameter("@StoreId", storeId); parameters[1] = new SqlParameter("@Price", price); parameters[2] = new SqlParameter("@Fee", fee); parameters[3] = new SqlParameter("@OrderType", orderType); parameters[4] = new SqlParameter("@ProductName", productName); parameters[5] = new SqlParameter("@Mobile", mobile); parameters[6] = new SqlParameter("@BuyType", buyType); parameters[7] = new SqlParameter("@Coins", coins); System.Data.DataSet ds = XCGameManabll.ExecuteQuerySentence(sql, parameters); return(ds.Tables[0].Rows[0][0].ToString()); }
public static bool UpdateOrderForPaySuccess(string orderId, string tradeNo) { string sql = "exec UpdateOrderForPaySuccess @OrderId,@TradeNo"; SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@OrderId", orderId); parameters[1] = new SqlParameter("@TradeNo", tradeNo); System.Data.DataSet ds = XCGameManabll.ExecuteQuerySentence(sql, parameters); int result = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()); if (result == 1) { return(true); } else { return(false); } }
public object getPromotion(Dictionary <string, object> dicParas) { try { string sql = "select ID,StoreName,StoreID,CONVERT(varchar(100), [Time], 23) as [Time],CONVERT(varchar(100), [ReleaseTime], 23) as [ReleaseTime],PicturePath,Title,PagePath,Publisher,PublishType ,PromotionType from t_promotion where State='1'"; System.Data.DataSet ds = XCGameManabll.ExecuteQuerySentence(sql, null); DataTable dt = ds.Tables[0]; if (dt.Rows.Count == 0) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据")); } var list = Utils.GetModelList <PromotionModel>(ds.Tables[0]).ToList(); return(ResponseModelFactory <List <PromotionModel> > .CreateModel(isSignKeyReturn, list)); } catch (Exception e) { throw e; } }
public object getDataOrder(Dictionary <string, object> dicParas) { try { string mobile = string.Empty; string PageSize = CommonConfig.DataOrderPageSize; //显示数量 string PageIndex = dicParas.ContainsKey("pageIndex") ? dicParas["pageIndex"].ToString() : string.Empty; //页码 string MobileToken = dicParas.ContainsKey("mobileToken") ? dicParas["mobileToken"].ToString() : string.Empty; //手机token string StoreName = dicParas.ContainsKey("storename") ? dicParas["storename"].ToString() : string.Empty; //门店名称 string StartCoins = dicParas.ContainsKey("startcoins") ? dicParas["startcoins"].ToString() : string.Empty; //开始币数 string EndCoins = dicParas.ContainsKey("endcoins") ? dicParas["endcoins"].ToString() : string.Empty; //结束币数 string Buytype = dicParas.ContainsKey("buytype") ? dicParas["buytype"].ToString() : string.Empty; //购买类型 string Startcreatetime = dicParas.ContainsKey("startcreatetime") ? dicParas["startcreatetime"].ToString() : string.Empty; //创建时间 string Endcreatetime = dicParas.ContainsKey("endcreatetime") ? dicParas["endcreatetime"].ToString() : string.Empty; //创建时间 string StartPrice = dicParas.ContainsKey("startprice") ? dicParas["startprice"].ToString() : string.Empty; //开始金额 string EndPrice = dicParas.ContainsKey("endprice") ? dicParas["endprice"].ToString() : string.Empty; //结束金额 if (!MobileTokenBusiness.ExistToken(MobileToken, out mobile)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "手机token无效")); } string name = ""; string CreateTime = "1"; if (Startcreatetime != "" && Endcreatetime == "") { Endcreatetime = Startcreatetime + " 23:59"; } else if (Endcreatetime != "" && Startcreatetime == "") { Startcreatetime = Endcreatetime + " 00:00"; Endcreatetime += " 23:59"; } else if (Startcreatetime != "" && Endcreatetime != "") { Endcreatetime += " 23:59"; } else { CreateTime = ""; } string sql = "select row_number() over(order by CreateTime desc) as [No], OrderID,StoreID,Price,Fee,OrderType,PayStatus,CONVERT(varchar(100), PayTime, 23)as PayTime,CreateTime,Descript,Mobile,BuyType,StoreName,Coins from Data_Order where Mobile='" + mobile + "' and PayStatus='1' "; if (StartCoins != "") { sql += " and Coins>=" + StartCoins + ""; } if (EndCoins != "") { sql += " and Coins<=" + EndCoins + ""; } if (StartPrice != "") { sql += " and Price>=" + StartPrice + ""; } if (EndPrice != "") { sql += " and Price<=" + EndPrice + ""; } if (CreateTime != "") { sql += " and CreateTime >='" + Convert.ToDateTime(Startcreatetime) + "' and CreateTime<='" + Convert.ToDateTime(Endcreatetime) + "'"; } if (Buytype != "") { sql += " and BuyType='" + Buytype + "'"; } if (StoreName != "") { sql += " and StoreName like '%" + StoreName + "%'"; } sql += " order by CreateTime desc"; System.Data.DataSet ds = XCGameManabll.ExecuteQuerySentence(sql, null); DataTable dt = ds.Tables[0]; dt.Columns.Add("CreateTimes"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DateTime time1 = Convert.ToDateTime(dt.Rows[i]["CreateTime"]); string CreateTimes = time1.ToString("yyyy-MM-dd H:mm"); dt.Rows[i]["CreateTimes"] = CreateTimes; } var list = Utils.GetModelList <DataOrderModel>(ds.Tables[0]).ToList(); int PageCout = 0; List <DataOrderModel> list1 = null; if (Utils.GetPageList <DataOrderModel>(list, Convert.ToInt32(PageIndex), Convert.ToInt32(PageSize), out PageCout, ref list1)) { sql = "select SUM(Coins) as Totalcoins,SUM(Price)as Totalmoney from Data_Order where Mobile='" + mobile + "' and PayStatus='1'"; DataSet ds2 = XCGameManabll.ExecuteQuerySentence(sql, null); DataTable dt2 = ds2.Tables[0]; string Totalcoins = dt2.Rows[0]["Totalcoins"].ToString(); if (Totalcoins == "") { Totalcoins = "0"; } string Totalmoney = dt2.Rows[0]["Totalmoney"].ToString(); if (Totalmoney == "") { Totalmoney = "0"; } sql = "select SUM(Coins) as Buycoins from Data_Order where Mobile='" + mobile + "'and BuyType='购币' and PayStatus='1'"; DataSet ds1 = XCGameManabll.ExecuteQuerySentence(sql, null); DataTable dt1 = ds1.Tables[0]; string Buycoins = dt1.Rows[0]["Buycoins"].ToString(); if (Buycoins == "") { Buycoins = "0"; } sql = "select Distinct (BuyType )as BuyTypelist from Data_Order where Mobile='" + mobile + "' and PayStatus='1'"; DataSet ds3 = XCGameManabll.ExecuteQuerySentence(sql, null); DataTable dt3 = ds3.Tables[0]; var BuyTypelist = Utils.GetModelList <DataOrderModelBuyType>(ds3.Tables[0]).ToList(); sql = "select Distinct ( StoreName )as StoreNamelist from Data_Order where Mobile='" + mobile + "' and PayStatus='1'"; DataSet ds4 = XCGameManabll.ExecuteQuerySentence(sql, null); DataTable dt4 = ds4.Tables[0]; var StoreNamelist = Utils.GetModelList <DataOrderModelStoreName>(ds4.Tables[0]).ToList(); DataOrderPageModel dataOrder = new DataOrderPageModel(); dataOrder.Lists = list1; dataOrder.Page = PageCout.ToString(); dataOrder.Count = list.Count.ToString(); dataOrder.Totalcoins = Totalcoins; dataOrder.Buycoins = Buycoins; dataOrder.Totalmoney = Totalmoney; dataOrder.BuyTypelist = BuyTypelist; dataOrder.StoreNamelist = StoreNamelist; return(ResponseModelFactory <DataOrderPageModel> .CreateModel(isSignKeyReturn, dataOrder)); } } return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "未查询数据")); } catch (Exception e) { throw e; } }