/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Insert(CompanyProductCategoryInfo model) {
string strSQL = "INSERT INTO CompanyProductCategories(Name,IsSystem,CompanyId,ProductCount,IsDeleted) VALUES(@Name,@IsSystem,@CompanyId,0,0);SELECT @@IDENTITY;";
SqlParameter[] parms = {
new SqlParameter("Name",SqlDbType.NVarChar),
new SqlParameter("IsSystem",SqlDbType.Int),
new SqlParameter("CompanyId",SqlDbType.Int),
};
parms[0].Value = model.Name;
parms[1].Value = model.IsSystem;
parms[2].Value = model.CompanyId;
return Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text,strSQL,parms));
}
/// <summary>
/// 添加或编辑
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static CompanyProductCategoryInfo Update(CompanyProductCategoryInfo model)
{
if (model.Id == 0)
{
//插入
int id = CompanyProductCategoryManage.Insert(model);
model.Id = id;
}
else {
CompanyProductCategoryManage.Update(model);
}
return model;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Update(CompanyProductCategoryInfo model) {
string strSQL = "UPDATE CompanyProductCategories SET Name = @Name WHERE CompanyId = @CompanyId AND Id = @Id";
SqlParameter[] parms = {
new SqlParameter("Name",SqlDbType.NVarChar),
new SqlParameter("IsSystem",SqlDbType.Int),
new SqlParameter("CompanyId",SqlDbType.Int),
new SqlParameter("Id",SqlDbType.Int),
};
parms[0].Value = model.Name;
parms[1].Value = model.IsSystem;
parms[2].Value = model.CompanyId;
parms[3].Value = model.Id;
return SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parms);
}
public ActionResult ProductCategoryList(CompanyProductCategoryInfo oldModel) {
var companyInfo = MemberService.GetCompanyInfoByUserId(PlantEngContext.Current.UserId);
//保存
bool errors = false;
if (string.IsNullOrEmpty(oldModel.Name))
{
errors = true;
ModelState.AddModelError("NAMEEMPTY", "名称不能为空");
}
if (!errors && ModelState.IsValid)
{
//OK
oldModel.CompanyId = companyInfo.CompanyId;
CompanyProductCategoryService.Update(oldModel);
ViewBag.Msg = "保存成功！";
}
//产品分类
ViewBag.CategoryList = CompanyProductCategoryService.GetCategoryList(companyInfo.CompanyId);
return View(oldModel);
}