public void Update(IDbConnection cn, Footmark footmark)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
//StringBuilder sb = new StringBuilder();
//sb.Append("UPDATE YZAppNotesFootmark SET ");
//sb.Append("Account=@Account,");
//sb.Append("FileID=@FileID,");
//sb.Append("Duration=@Duration,");
//sb.Append("Comments=@Comments,");
//sb.Append("CreateAt=@CreateAt ");
//sb.Append("WHERE ItemID=@ItemID");
//cmd.CommandText = sb.ToString();
//cmd.Parameters.Add("@Account", SqlDbType.NVarChar).Value = this.Convert(footmark.Account, false);
//cmd.Parameters.Add("@FileID", SqlDbType.NVarChar).Value = this.Convert(footmark.FileID, false);
//cmd.Parameters.Add("@Duration", SqlDbType.Int).Value = footmark.Duration;
//cmd.Parameters.Add("@Comments", SqlDbType.NVarChar).Value = this.Convert(footmark.Comments, true);
//cmd.Parameters.Add("@CreateAt", SqlDbType.DateTime).Value = this.Convert(footmark.CreateAt, false);
//cmd.Parameters.Add("@ItemID", SqlDbType.Int).Value = footmark.ItemID;
cmd.ExecuteNonQuery();
}
}
public void Update(IDbConnection cn, Footmark footmark)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
//StringBuilder sb = new StringBuilder();
//sb.Append("UPDATE YZAppNotesFootmark SET ");
//sb.Append("Account=:Account,");
//sb.Append("FileID=:FileID,");
//sb.Append("Duration=:Duration,");
//sb.Append("Comments=:Comments,");
//sb.Append("CreateAt=:CreateAt ");
//sb.Append("WHERE ItemID=:ItemID");
//cmd.CommandText = sb.ToString();
//cmd.Parameters.Add(":Account", OracleDbType.NVarchar2).Value = this.Convert(footmark.Account, false);
//cmd.Parameters.Add(":FileID", OracleDbType.NVarchar2).Value = this.Convert(footmark.FileID, false);
//cmd.Parameters.Add(":Duration", OracleDbType.Int32).Value = footmark.Duration;
//cmd.Parameters.Add(":Comments", OracleDbType.NVarchar2).Value = this.Convert(footmark.Comments, true);
//cmd.Parameters.Add(":CreateAt", OracleDbType.Date).Value = this.Convert(footmark.CreateAt, false);
//cmd.Parameters.Add(":ItemID", OracleDbType.Int32).Value = footmark.ItemID;
cmd.ExecuteNonQuery();
}
}
public void Insert(IDbConnection cn, Footmark footmark)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
StringBuilder sb = new StringBuilder();
sb.Append("SET NOCOUNT ON;");
sb.Append("INSERT INTO YZAppNotesFootmark(");
sb.Append("Account,");
sb.Append("Time,");
sb.Append("Rawlat,");
sb.Append("Rawlon,");
sb.Append("Lat,");
sb.Append("Lon,");
sb.Append("LocId,");
sb.Append("LocName,");
sb.Append("LocAddress,");
sb.Append("Contact,");
sb.Append("Comments,");
sb.Append("Attachments,");
sb.Append("Date) ");
sb.Append("VALUES(");
sb.Append("@Account,");
sb.Append("@Time,");
sb.Append("@Rawlat,");
sb.Append("@Rawlon,");
sb.Append("@Lat,");
sb.Append("@Lon,");
sb.Append("@LocId,");
sb.Append("@LocName,");
sb.Append("@LocAddress,");
sb.Append("@Contact,");
sb.Append("@Comments,");
sb.Append("@Attachments,");
sb.Append("@Date);");
sb.Append("SELECT SCOPE_IDENTITY()");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add("@Account", SqlDbType.NVarChar).Value = this.Convert(footmark.Account, false);
cmd.Parameters.Add("@Time", SqlDbType.DateTime).Value = this.Convert(footmark.Time, false);
cmd.Parameters.Add("@Rawlat", SqlDbType.Float).Value = footmark.Position.RawLat;
cmd.Parameters.Add("@Rawlon", SqlDbType.Float).Value = footmark.Position.RawLon;
cmd.Parameters.Add("@Lat", SqlDbType.Float).Value = footmark.Position.Lat;
cmd.Parameters.Add("@Lon", SqlDbType.Float).Value = footmark.Position.Lon;
cmd.Parameters.Add("@LocId", SqlDbType.NVarChar).Value = this.Convert(footmark.Position.Id, false);
cmd.Parameters.Add("@LocName", SqlDbType.NVarChar).Value = this.Convert(footmark.Position.Name, false);
cmd.Parameters.Add("@LocAddress", SqlDbType.NVarChar).Value = this.Convert(footmark.Position.Address, false);
cmd.Parameters.Add("@Contact", SqlDbType.NVarChar).Value = this.Convert(footmark.Contact, true);
cmd.Parameters.Add("@Comments", SqlDbType.NVarChar).Value = this.Convert(footmark.Comments, true);
cmd.Parameters.Add("@Attachments", SqlDbType.NVarChar).Value = this.Convert(footmark.Attachments, true);
cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = new DateTime(footmark.Time.Year, footmark.Time.Month, footmark.Time.Day);
footmark.ItemID = System.Convert.ToInt32(cmd.ExecuteScalar());
}
}
public virtual object Save(HttpContext context)
{
YZRequest request = new YZRequest(context);
JObject jPost = request.GetPostData <JObject>();
Footmark footmark = jPost.ToObject <Footmark>(request.Serializer);
DateTime now = DateTime.Now;
footmark.Account = YZAuthHelper.LoginUserAccount;
footmark.Time = new DateTime(now.Year, now.Month, now.Day, now.Hour, now.Minute, 0);
using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider)
{
using (IDbConnection cn = provider.OpenConnection())
{
FootmarkManager.Insert(provider, cn, footmark);
return(footmark.ItemID);
}
}
}
public void Insert(IDbConnection cn, Footmark footmark)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
cmd.CommandText = "SELECT BPMSEQ_YZAPPNOTESFOOTMARK.NEXTVAL FROM DUAL";
footmark.ItemID = System.Convert.ToInt32(cmd.ExecuteScalar());
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO YZAppNotesFootmark(");
sb.Append("ItemID,");
sb.Append("Account,");
sb.Append("Time,");
sb.Append("Rawlat,");
sb.Append("Rawlon,");
sb.Append("Lat,");
sb.Append("Lon,");
sb.Append("LocId,");
sb.Append("LocName,");
sb.Append("LocAddress,");
sb.Append("Contact,");
sb.Append("Comments,");
sb.Append("Attachments,");
sb.Append("\"DATE\") ");
sb.Append("VALUES(");
sb.Append(":ItemID,");
sb.Append(":Account,");
sb.Append(":Time,");
sb.Append(":Rawlat,");
sb.Append(":Rawlon,");
sb.Append(":Lat,");
sb.Append(":Lon,");
sb.Append(":LocId,");
sb.Append(":LocName,");
sb.Append(":LocAddress,");
sb.Append(":Contact,");
sb.Append(":Comments,");
sb.Append(":Attachments,");
sb.Append(":PM_Date)");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add(":ItemID", OracleDbType.Int32).Value = footmark.ItemID;
cmd.Parameters.Add(":Account", OracleDbType.NVarchar2).Value = this.Convert(footmark.Account, false);
cmd.Parameters.Add(":Time", OracleDbType.Date).Value = this.Convert(footmark.Time, false);
cmd.Parameters.Add(":Rawlat", OracleDbType.Decimal).Value = footmark.Position.RawLat;
cmd.Parameters.Add(":Rawlon", OracleDbType.Decimal).Value = footmark.Position.RawLon;
cmd.Parameters.Add(":Lat", OracleDbType.Decimal).Value = footmark.Position.Lat;
cmd.Parameters.Add(":Lon", OracleDbType.Decimal).Value = footmark.Position.Lon;
cmd.Parameters.Add(":LocId", OracleDbType.NVarchar2).Value = this.Convert(footmark.Position.Id, false);
cmd.Parameters.Add(":LocName", OracleDbType.NVarchar2).Value = this.Convert(footmark.Position.Name, false);
cmd.Parameters.Add(":LocAddress", OracleDbType.NVarchar2).Value = this.Convert(footmark.Position.Address, false);
cmd.Parameters.Add(":Contact", OracleDbType.NVarchar2).Value = this.Convert(footmark.Contact, true);
cmd.Parameters.Add(":Comments", OracleDbType.NVarchar2).Value = this.Convert(footmark.Comments, true);
cmd.Parameters.Add(":Attachments", OracleDbType.NVarchar2).Value = this.Convert(footmark.Attachments, true);
cmd.Parameters.Add(":PM_Date", OracleDbType.Date).Value = new DateTime(footmark.Time.Year, footmark.Time.Month, footmark.Time.Day);
cmd.ExecuteNonQuery();
}
}
int limit = 100;//拿几条数据
public async void GetDayDataFromDB()
{
DBProxyComponent dBProxyComponent = Game.Scene.GetComponent <DBProxyComponent>();
try
{
var acountscount = await dBProxyComponent.QueryCount <ProductInfoData>("{ }");
while (skip < acountscount)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{ }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts = await dBProxyComponent.QueryLss <ProductInfoData>(LSS);
foreach (var dataDate in acounts)
{
ProductInfoData Infodata = dataDate as ProductInfoData;
if (ProductInfolist.TryAdd(Infodata._ProductInfoID, Infodata))
{
}
;
long ShopInfoID = Infodata._ShopInfoID;
lock (ShopProductlist)
{
List <ProductInfoData> datalist = new List <ProductInfoData>();
if (ShopProductlist.ContainsKey(ShopInfoID))
{
//有这个商铺直接往这个商铺的list里添加
ShopProductlist[ShopInfoID].Add(Infodata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (ShopProductlist.TryAdd(ShopInfoID, datalist) == true)
{
}
;
ShopProductlist[ShopInfoID].Add(Infodata);
}
}
}
skip += limit;
}
skip = 0;
var acounts1count = await dBProxyComponent.QueryCount <ProductInfoOrder>("{ }");
while (skip < acounts1count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{_CreationTime:-1 }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts1 = await dBProxyComponent.QueryLss <ProductInfoOrder>(LSS);
foreach (ProductInfoOrder item in acounts1)
{
ProductInfoOrder Orderdata = item as ProductInfoOrder;
long UserID = Orderdata._UserID;
lock (UserProductOrderlist)
{
List <ProductInfoOrder> datalist = new List <ProductInfoOrder>();
if (UserProductOrderlist.ContainsKey(UserID))
{
//有这个商铺直接往这个商铺的list里添加
UserProductOrderlist[UserID].Add(Orderdata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (UserProductOrderlist.TryAdd(UserID, datalist) == true)
{
}
;
UserProductOrderlist[UserID].Add(Orderdata);
}
}
}
skip += limit;
}
skip = 0;
var acounts2count = await dBProxyComponent.QueryCount <SimpleOrder>("{ }");
while (skip < acounts2count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{_id:-1 }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts1 = await dBProxyComponent.QueryLss <SimpleOrder>(LSS);
foreach (SimpleOrder item in acounts1)
{
SimpleOrder Orderdata = item as SimpleOrder;
if (Orderdata._State == 0)
{
long UserID = Orderdata._UserID;
lock (UserSimpleOrderlist)
{
List <SimpleOrder> datalist = new List <SimpleOrder>();
if (UserSimpleOrderlist.ContainsKey(UserID))
{
//有这个商铺直接往这个商铺的list里添加
UserSimpleOrderlist[UserID].Add(Orderdata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (UserSimpleOrderlist.TryAdd(UserID, datalist) == true)
{
}
;
UserSimpleOrderlist[UserID].Add(Orderdata);
}
}
}
}
skip += limit;
}
skip = 0;
var acount1s = await dBProxyComponent.Query <ServiceInfoData>("{ }");
foreach (ServiceInfoData item in acount1s)
{
if (!ServiceInfos.Contains(item._ServiceInfoID))
{
ServiceInfos.Add(item._ServiceInfoID);
}
}
var acounts3count = await dBProxyComponent.QueryCount <ShopActivityInfo>("{ }");
while (skip < acounts3count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{ }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts1 = await dBProxyComponent.QueryLss <ShopActivityInfo>(LSS);
foreach (ShopActivityInfo item in acounts1)
{
ShopActivityInfo Infodata = item as ShopActivityInfo;
long ShopInfoID = Infodata._ShopInfoID;
lock (UserSimpleOrderlist)
{
List <ShopActivityInfo> datalist = new List <ShopActivityInfo>();
if (ShopActivitylist.ContainsKey(ShopInfoID))
{
//有这个商铺直接往这个商铺的list里添加
ShopActivitylist[ShopInfoID].Add(Infodata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (ShopActivitylist.TryAdd(ShopInfoID, datalist) == true)
{
}
;
ShopActivitylist[ShopInfoID].Add(Infodata);
}
}
}
skip += limit;
}
skip = 0;
var acounts4count = await dBProxyComponent.QueryCount <ShopInfoData>("{ }");
while (skip < acounts4count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{ }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts = await dBProxyComponent.QueryLss <ShopInfoData>(LSS);
foreach (var dataDate in acounts)
{
ShopInfoData Infodata = dataDate as ShopInfoData;
if (ShopInfolist.TryAdd(Infodata._ShopInfoID, Infodata))
{
}
;
}
skip += limit;
}
skip = 0;
var acounts5count = await dBProxyComponent.QueryCount <CollectProduct>("{ }");
while (skip < acounts5count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{ }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts1 = await dBProxyComponent.QueryLss <CollectProduct>(LSS);
foreach (CollectProduct item in acounts1)
{
CollectProduct Orderdata = item as CollectProduct;
if (Orderdata._State == 0)
{
long UserID = Orderdata._UserID;
lock (UserCollectProductlist)
{
List <CollectProduct> datalist = new List <CollectProduct>();
if (UserCollectProductlist.ContainsKey(UserID))
{
//有这个商铺直接往这个商铺的list里添加
UserCollectProductlist[UserID].Add(Orderdata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (UserCollectProductlist.TryAdd(UserID, datalist) == true)
{
}
;
UserCollectProductlist[UserID].Add(Orderdata);
}
}
}
}
skip += limit;
}
skip = 0;
var acounts6count = await dBProxyComponent.QueryCount <CollectShopInfo>("{ }");
while (skip < acounts6count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{ }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts1 = await dBProxyComponent.QueryLss <CollectShopInfo>(LSS);
foreach (CollectShopInfo item in acounts1)
{
CollectShopInfo Orderdata = item as CollectShopInfo;
if (Orderdata._State == 0)
{
long UserID = Orderdata._UserID;
lock (UserCollecShoptlist)
{
List <CollectShopInfo> datalist = new List <CollectShopInfo>();
if (UserCollecShoptlist.ContainsKey(UserID))
{
//有这个商铺直接往这个商铺的list里添加
UserCollecShoptlist[UserID].Add(Orderdata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (UserCollecShoptlist.TryAdd(UserID, datalist) == true)
{
}
;
UserCollecShoptlist[UserID].Add(Orderdata);
}
}
}
}
skip += limit;
}
skip = 0;
var acounts7count = await dBProxyComponent.QueryCount <Discount>("{ }");
while (skip < acounts7count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{ }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts1 = await dBProxyComponent.QueryLss <Discount>(LSS);
foreach (Discount item in acounts1)
{
Discount Orderdata = item as Discount;
if (Orderdata._State == 0)
{
long UserID = Orderdata._UserID;
lock (UserDiscountlist)
{
List <Discount> datalist = new List <Discount>();
if (UserDiscountlist.ContainsKey(UserID))
{
//有这个商铺直接往这个商铺的list里添加
UserDiscountlist[UserID].Add(Orderdata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (UserDiscountlist.TryAdd(UserID, datalist) == true)
{
}
;
UserDiscountlist[UserID].Add(Orderdata);
}
}
}
}
skip += limit;
}
skip = 0;
var acounts8count = await dBProxyComponent.QueryCount <Footmark>("{ }");
while (skip < acounts8count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{ }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts1 = await dBProxyComponent.QueryLss <Footmark>(LSS);
foreach (Footmark item in acounts1)
{
Footmark Orderdata = item as Footmark;
if (Orderdata._State == 0)
{
long UserID = Orderdata._UserID;
lock (UserFootmarklist)
{
List <Footmark> datalist = new List <Footmark>();
if (UserFootmarklist.ContainsKey(UserID))
{
//有这个商铺直接往这个商铺的list里添加
UserFootmarklist[UserID].Add(Orderdata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (UserFootmarklist.TryAdd(UserID, datalist) == true)
{
}
;
UserFootmarklist[UserID].Add(Orderdata);
}
}
}
}
skip += limit;
}
skip = 0;
var acounts9count = await dBProxyComponent.QueryCount <ThumbProduct>("{ }");
while (skip < acounts9count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{ }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts1 = await dBProxyComponent.QueryLss <ThumbProduct>(LSS);
foreach (ThumbProduct item in acounts1)
{
ThumbProduct Orderdata = item as ThumbProduct;
if (Orderdata._State == 0)
{
long ThumbProductID = Orderdata._ThumbProductID;
lock (ThumbUserlist)
{
List <ThumbProduct> datalist = new List <ThumbProduct>();
if (ThumbUserlist.ContainsKey(ThumbProductID))
{
//有这个商铺直接往这个商铺的list里添加
ThumbUserlist[ThumbProductID].Add(Orderdata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (ThumbUserlist.TryAdd(ThumbProductID, datalist) == true)
{
}
;
ThumbUserlist[ThumbProductID].Add(Orderdata);
}
}
}
}
skip += limit;
}
skip = 0;
var acounts10count = await dBProxyComponent.QueryCount <EvaluateProduct>("{ }");
while (skip < acounts10count)
{
string Json = "{ }"; //查找类型里面可以添加斜杠来做匹配查找，例如：{userNowArea:/^湖南省/}
string sort = "{ }"; //排序方式，必须要有参数和排序方式，例如：{userID:1}
string LSS = Json + "|" + skip + "|" + limit + "|" + sort;
var acounts1 = await dBProxyComponent.QueryLss <EvaluateProduct>(LSS);
foreach (EvaluateProduct item in acounts1)
{
EvaluateProduct Orderdata = item as EvaluateProduct;
if (Orderdata._State == 0)
{
long EvaluateProductID = Orderdata._EvaluateProductID;
lock (ProductEvaluatelist)
{
List <EvaluateProduct> datalist = new List <EvaluateProduct>();
if (ProductEvaluatelist.ContainsKey(EvaluateProductID))
{
//有这个商铺直接往这个商铺的list里添加
ProductEvaluatelist[EvaluateProductID].Add(Orderdata);
}
else
{
//没有这个商铺，添加这个商铺，在往商铺里面的list里添加
if (ProductEvaluatelist.TryAdd(EvaluateProductID, datalist) == true)
{
}
;
ProductEvaluatelist[EvaluateProductID].Add(Orderdata);
}
}
}
}
skip += limit;
}
skip = 0;
}
catch (Exception e)
{
Log.Debug("ProductCenterComponent:GetDayDataFromDB:" + e);
}
}
