public static int CreateCategory(Category category)
{
const string sql = "insert into Category(Name,Description,CreateTime,CreateUser,EnumDataEntityStatus,MergedId) values(@Name,@Description,@CreateTime,@CreateUser,@EnumDataEntityStatus,@MergedId);Select LAST_INSERT_ID();";
MySqlCommand command = new MySqlCommand(sql, ProductMySqlConnection);
command.Parameters.AddWithValue("@Name", category.Name);
command.Parameters.AddWithValue("@Description", category.Description);
command.Parameters.AddWithValue("@CreateTime", category.CreateTime);
command.Parameters.AddWithValue("@CreateUser", category.CreateUser);
command.Parameters.AddWithValue("@EnumDataEntityStatus", category.EnumDataEntityStatus);
command.Parameters.AddWithValue("@MergedId", category.MergedId);
ProductMySqlConnection.Open();
Int32 categoryId = Convert.ToInt32(command.ExecuteScalar());
return categoryId;
}
public static List<Category> SearchCategoryByName(string name)
{
List<Category> categories = new List<Category>();
const string sql = "SELECT * FROM Category WHERE Name=@Name";
MySqlCommand command = new MySqlCommand(sql, ProductMySqlConnection);
command.Parameters.AddWithValue("@Name",name);
ProductMySqlConnection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
Category category = new Category();
category.CategoryId = reader.GetInt32("CategoryId");
category.CreateTime = reader.GetDateTime("CreateTime");
category.CreateUser = reader.GetInt32("CreateUser");
category.Description = reader.GetString("Description");
category.EnumDataEntityStatus = (EnumDataEntityStatus)reader.GetInt32("EnumDataEntityStatus");
category.MergedId = reader.GetInt32("MergedId");
category.Name = reader.GetString("Name");
categories.Add(category);
}
return categories;
}
public static Category GetCategoryById(int categoryId)
{
const string sql = "SELECT top 1 * FROM Category WHERE CategoryId=@CategoryId";
MySqlCommand command = new MySqlCommand(sql, ProductMySqlConnection);
command.Parameters.AddWithValue("@CategoryId", categoryId);
ProductMySqlConnection.Open();
var reader = command.ExecuteReader();
if (reader.Read())
{
Category category = new Category();
category.CategoryId = reader.GetInt32("CategoryId");
category.CreateTime = reader.GetDateTime("CreateTime");
category.CreateUser = reader.GetInt32("CreateUser");
category.Description = reader.GetString("Description");
category.EnumDataEntityStatus = (EnumDataEntityStatus) reader.GetInt32("EnumDataEntityStatus");
category.MergedId = reader.GetInt32("MergedId");
category.Name = reader.GetString("Name");
return category;
}
return null;
}
public ActionResult Add(StuffCommentCreateViewModel viewModel)
{
int userId;
int.TryParse(TicketTool.GetUserData(), out userId);
// 如无Category，创建新的
if (viewModel.CategoryId == 0)
{
// 搜索
var categories = StuffManager.SearchCategoryByName(viewModel.CategoryName.Trim());
if (categories.Any(m => m.EnumDataEntityStatus == EnumDataEntityStatus.Normal))
{
viewModel.CategoryId = categories.First(m => m.EnumDataEntityStatus == EnumDataEntityStatus.Normal).CategoryId;
}
else
{
Category category = new Category();
//category.CategoryId
category.CreateTime = DateTime.Now;
category.CreateUser = userId;
category.Description = "";
category.EnumDataEntityStatus = EnumDataEntityStatus.Normal;
category.MergedId = 0;
category.Name = viewModel.CategoryName;
int categoryId = StuffManager.CreateCategory(category);
viewModel.CategoryId = categoryId;
}
}
// 如无Brand,创建新的
if (viewModel.BrandId == 0)
{
var brands = StuffManager.SearchBrandByName(viewModel.CategoryName.Trim());
if (brands != null && brands.Any(m => m.EnumDataEntityStatus == EnumDataEntityStatus.Normal))
{
viewModel.BrandId = brands.First(m => m.EnumDataEntityStatus == EnumDataEntityStatus.Normal).BrandId;
}
else
{
Brand brand = new Brand();
brand.CreateTime = DateTime.Now;
brand.CreateUser = userId;
brand.Description = "";
brand.EnumDataEntityStatus = EnumDataEntityStatus.Normal;
brand.MergedId = 0;
brand.Name = viewModel.BrandName;
int brandId = StuffManager.CreateBrand(brand);
viewModel.BrandId = brandId;
}
}
// 如无产品，创建新的
if (viewModel.StuffId == 0)
{
var stuffs = StuffManager.SearchStuffByName(viewModel.StuffName);
if (stuffs != null && stuffs.Any(m => m.EnumDataEntityStatus == EnumDataEntityStatus.Normal))
{
viewModel.StuffId = stuffs.First(m => m.EnumDataEntityStatus == EnumDataEntityStatus.Normal).StuffId;
}
else
{
Stuff stuff = new Stuff();
stuff.BrandId = viewModel.BrandId;
stuff.CategoryId = viewModel.CategoryId;
stuff.CraeteTime = DateTime.Now;
stuff.CreateUser = userId;
stuff.EnumDataEntityStatus = EnumDataEntityStatus.Normal;
stuff.MergedId = 0;
stuff.Name = viewModel.StuffName.Trim();
int stuffId =StuffManager.CreateStuff(stuff);
viewModel.StuffId = stuffId;
}
}
// 创建评论
StuffComment stuffComment = new StuffComment();
stuffComment.BuyPrice = viewModel.BuyPrice;
stuffComment.CommentDetail = viewModel.CommentDetail;
stuffComment.CostPerformance = viewModel.CostPerformance;
stuffComment.CrateTime = DateTime.Now;
stuffComment.CreateUser = userId;
stuffComment.EnumAuditStatus = EnumAuditStatus.Approved;
stuffComment.Functions = viewModel.Functions;
stuffComment.IsActive = true;
// TODO:图片数据需要再处理
stuffComment.Pictures = new List<string>();
stuffComment.PublishTime = DateTime.Now;
stuffComment.Published = true;
stuffComment.Service = viewModel.Service;
//stuffComment.StuffCommentId
stuffComment.StuffId = viewModel.StuffId;
stuffComment.Workmanship = viewModel.Workmanship;
int stuffCommentId = StuffManager.CreateStuffComment(stuffComment);
return View();
}
