public static MerchantExtend GetMerchantExtend(int sellerId) { string cmd = @"select * from merchantextend where sellerId=?sellerId"; List <MySqlParameter> parameters = new List <MySqlParameter>(); parameters.Add(new MySqlParameter("?sellerId", sellerId)); MerchantExtend item = new MerchantExtend(); try { using (var conn = Utility.ObtainConn(Utility._gameDbConn)) { MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmd, parameters.ToArray()); while (reader.Read()) { item.SellerId = reader.GetInt32(0); item.ChargeIntegral = (int)reader["ChargeIntegral"]; item.CommentIntegral = (int)reader["CommentIntegral"]; item.ConsumeIntegral = (int)reader["ConsumeIntegral"]; item.RegisteIntegaral = (int)reader["RegisteIntegaral"]; item.ShareIntegral = (int)reader["ShareIntegral"]; } } } catch (System.Exception ex) { throw; } return(item); }
public static void CreateMerchantExtend(MerchantExtend extend) { string connectionString = GlobalConfig.DbConn; string commandText = @"INSERT INTO merchantextend ( SellerId, Title, PushType, Content, TypeId, CreateTime ) VALUES ( ?SellerId, ?Title, ?PushType, ?Content, ?TypeId, ?CreateTime )" ; List <MySqlParameter> parameters = new List <MySqlParameter>(); parameters.Add(new MySqlParameter("?SellerId", extend.SellerId)); parameters.Add(new MySqlParameter("?ChargeIntegral", extend.ChargeIntegral)); parameters.Add(new MySqlParameter("?CommentIntegral", extend.CommentIntegral)); parameters.Add(new MySqlParameter("?ConsumeIntegral", extend.ConsumeIntegral)); parameters.Add(new MySqlParameter("?RegisteIntegaral", extend.RegisteIntegaral)); parameters.Add(new MySqlParameter("?ShareIntegral", extend.ShareIntegral)); MySqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, commandText, parameters.ToArray()); }
private void UpdateRules() { var sellerId = GetInt("sellerid"); var seller = MerchantHelper.GetMerchant(sellerId); //var userlevels = SystemHelper.GetUserLevels(sellerId); var userlevels = Newtonsoft.Json.JsonConvert.DeserializeObject <List <UserLevel> >(GetString("levels")); var merchantExtend = SystemHelper.GetMerchantExtend(sellerId); if (merchantExtend == null) { merchantExtend = new MerchantExtend(); merchantExtend.SellerId = sellerId; merchantExtend.CommentIntegral = GetInt("cmi"); merchantExtend.ConsumeIntegral = GetInt("costi"); merchantExtend.ChargeIntegral = GetInt("ci"); merchantExtend.ShareIntegral = GetInt("si"); merchantExtend.RegisteIntegaral = GetInt("ri"); SystemHelper.CreateMerchantExtend(merchantExtend); } else { merchantExtend.CommentIntegral = GetInt("cmi"); merchantExtend.ConsumeIntegral = GetInt("costi"); merchantExtend.ChargeIntegral = GetInt("ci"); merchantExtend.ShareIntegral = GetInt("si"); merchantExtend.RegisteIntegaral = GetInt("ri"); SystemHelper.UpdateMerchantExtend(merchantExtend); } seller.Freight = GetInt("fe"); seller.NeedToFreeFreight = GetInt("nffe"); MerchantHelper.SaveMerchant(seller); SystemHelper.UpdateUserLevels(userlevels); }
public static void UpdateMerchantExtend(MerchantExtend extend) { string commandText = @"UPDATE merchantextend SET ChargeIntegral = ?ChargeIntegral, CommentIntegral = ?CommentIntegral, RegisteIntegaral = ?RegisteIntegaral, ConsumeIntegral = ?ConsumeIntegral, ShareIntegral = ?ShareIntegral WHERE SellerId = ?SellerId"; List <MySqlParameter> parameters = new List <MySqlParameter>(); parameters.Add(new MySqlParameter("?SellerId", extend.SellerId)); parameters.Add(new MySqlParameter("?ChargeIntegral", extend.ChargeIntegral)); parameters.Add(new MySqlParameter("?CommentIntegral", extend.CommentIntegral)); parameters.Add(new MySqlParameter("?ConsumeIntegral", extend.ConsumeIntegral)); parameters.Add(new MySqlParameter("?RegisteIntegaral", extend.RegisteIntegaral)); parameters.Add(new MySqlParameter("?ShareIntegral", extend.ShareIntegral)); MySqlHelper.ExecuteNonQuery(GlobalConfig.DbConn, CommandType.Text, commandText, parameters.ToArray()); }