public bool AddProclassfy(base_productclass proclassfyname, out int isexit, out int id)
{
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
try
{
//1.先判断是否存在
var singleOrDefault = db.Queryable <base_productclass>().SingleOrDefault(c => c.class_name == proclassfyname.class_name);
if (singleOrDefault != null && singleOrDefault.del_flag == false)//代表已存在数据库且被删除
{
isexit = 1;
id = singleOrDefault.prod_class_id;
return(false);
}
if (singleOrDefault != null && singleOrDefault.del_flag == true)//代表已存在数据库未被删除
{
isexit = 2;
id = singleOrDefault.prod_class_id;
return(false);
}
//2.不存在再添加
db.DisableInsertColumns = new string[] { "edit_time" };//edit_time列将不会插入值
var myid = db.Insert <base_productclass>(proclassfyname);
if (myid.ObjToInt() > 0)
{
isexit = 0;
id = myid.ObjToInt();
return(true);
}
else
{
isexit = 0;
id = myid.ObjToInt();
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
public ActionResult AddProductClass(string proclassfyname)
{
ComResult res = new ComResult();
try
{
if (!Regex.IsMatch(proclassfyname, @"(?i)^[0-9a-z\u4e00-\u9fa5]+$") && !string.IsNullOrEmpty(proclassfyname))
{
res.Msg = "分类名称不能有非法字符";
res.State = 0;
return(Json(res));
}
if (string.IsNullOrEmpty(proclassfyname))
{
res.Msg = "分类名称不能为空";
res.State = 0;
return(Json(res));
}
base_productclass pro = new base_productclass();
pro.class_name = proclassfyname;
pro.class_icon = "";
pro.class_sort = 1;
pro.create_user_id = 1;
pro.edit_user_id = 1;
pro.del_flag = true;
pro.remark = "";
pro.create_time = DateTime.Now;
pro.edit_time = DateTime.Now;
int isexit = 0;
int id = 0;
bool isok = _service.AddProclassfy(pro, out isexit, out id);
if (1 == isexit)
{
res.Msg = "此分类已存在且被删除是否恢复?";
res.URL = id.ToString();
res.State = 2;
return(Json(res));
}
if (2 == isexit)
{
res.Msg = "已存在此分类";
res.State = 0;
return(Json(res));
}
if (isok)
{
res.Msg = "添加成功";
res.State = 1;
res.URL = "/Product/Index";
return(Json(res));
}
else
{
res.Msg = "添加失败";
res.State = 0;
return(Json(res));
}
}
catch (Exception ex)
{
res.Msg = ex.ToString();
res.State = 0;
return(Json(res));
}
}
