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