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