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