/// <summary> /// 添加数据 /// </summary> /// <param name="model"></param> public void Insert(ConfigPriceMe model) { using (MDbBase db = new MDbBase()) { db.GetCollection <ConfigPriceMe>().Insert(model, false); } }
/// <summary> /// 修改数据 /// </summary> /// <param name="name">价格名称</param> /// <param name="Price_Plus">加点</param> public void Update(ConfigPriceMe model) { using (MDbBase db = new MDbBase()) { db.GetCollection <ConfigPriceMe>().Update(model, x => x.name == name); } }
public List <ConfigPriceMe> GetAllConfigPriceMe(string authKey) { if (islogin(authKey)) { BLL.Data_Centre.ConfigPriceMe bll = new BLL.Data_Centre.ConfigPriceMe(); return(bll.GetList()); } return(null); }
public bool SetConfigPriceMe(string authKey, DataTable dt) { if (islogin(authKey)) { BLL.Data_Centre.ConfigPriceMe bll = new BLL.Data_Centre.ConfigPriceMe(); foreach (DataRow item in dt.Rows) { decimal Price_Plus = Convert.ToDecimal(item["Price_Plus"]); string CateGory = Convert.ToString(item["CateGory"]); bll.UpdateToSql(CateGory, Price_Plus); } return(true); } return(false); }
public ConfigPriceMe() { BLL.DbBase db = new DbBase(); System.Data.DataTable dt = db.ExecuteDataSet("SELECT DISTINCT category FROM dbo.Price").Tables[0]; var model = new ConfigPriceMe(0); foreach (System.Data.DataRow item in dt.Rows) { if (!Exist(item["category"].ToString())) { model.id = MongoDB.Oid.NewOid().ToString(); model.name = item["category"].ToString(); model.Price_Plus = 1; Insert(model); System.Threading.Thread.Sleep(1000); } } }
/// <summary> /// 修改价格 /// </summary> /// <param name="id"></param> /// <param name="category"></param> public void Update(string id, string category) { string sql = string.Format("UPDATE Price SET price=b.price FROM Price a INNER JOIN Price_TEMP b ON a.ID=b.id AND a.category=b.category WHERE b.ID='{0}' AND b.category='{1}'", id, category); ExecuteNonQuery(sql); //价格含义 object o = ExecuteScalar(string.Format("SELECT TOP 1 sum FROM dbo.Link_Mid WHERE id=(SELECT id FROM dbo.Link WHERE t_id='{0}') AND PriceType<>1", id)); int sum = 0; if (!Library.Lang.DataValidator.isNULL(o)) { sum = (int)o; } //加点计算 decimal d = (decimal)ExecuteScalar(string.Format("SELECT Price_Plus FROM dbo.Price WHERE ID='{0}' AND category='{1}'", id, category)); if (d > 0) { if (sum != 0) { ExecuteNonQuery(string.Format("UPDATE Price SET Price_N=Price/{2}*Price_Plus WHERE ID='{0}' AND category='{1}'", id, category, sum)); } else { ExecuteNonQuery(string.Format("UPDATE Price SET Price_N=Price*Price_Plus WHERE ID='{0}' AND category='{1}'", id, category)); } } else { decimal Price_Plus = new ConfigPriceMe().GetPrice_Plus(category); if (sum != 0) { ExecuteNonQuery(string.Format("UPDATE Price SET Price_N=Price/{2}*{3} WHERE ID='{0}' AND category='{1}'", id, category, sum, Price_Plus)); } else { ExecuteNonQuery(string.Format("UPDATE Price SET Price_N=Price*{2} WHERE ID='{0}' AND category='{1}'", id, category, Price_Plus)); } } InitPriceCache(id); }