public bool AddExpress(base_exp_comp proclassfy, out int isexit, out int id)
{
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
try
{
//1.先判断是否存在
var singleOrDefault = db.Queryable <base_exp_comp>().SingleOrDefault(c => c.express_name == proclassfy.express_name);
if (singleOrDefault != null && singleOrDefault.del_flag == false)//代表已存在数据库且被删除
{
isexit = 1;
id = singleOrDefault.express_id;
return(false);
}
if (singleOrDefault != null && singleOrDefault.del_flag == true)//代表已存在数据库未被删除
{
isexit = 2;
id = singleOrDefault.express_id;
return(false);
}
//2.不存在再添加
db.DisableInsertColumns = new string[] { "edit_time" };//edit_time列将不会插入值
var myid = db.Insert <base_exp_comp>(proclassfy);
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 AddExpress(string expressname)
{
DBModel.Common.ComResult res = new DBModel.Common.ComResult();
try
{
if (!Regex.IsMatch(expressname, @"(?i)^[0-9a-z\u4e00-\u9fa5]+$") && !string.IsNullOrEmpty(expressname))
{
res.Msg = "分类名称不能有非法字符";
res.State = 0;
return(Json(res));
}
if (string.IsNullOrEmpty(expressname))
{
res.Msg = "分类名称不能为空";
res.State = 0;
return(Json(res));
}
base_exp_comp pro = new base_exp_comp();
pro.country_id = 0;;
pro.create_time = DateTime.Now;
pro.create_user_id = LoginUser.Current.user_id;
pro.del_flag = true;
pro.del_time = DateTime.Now;
pro.del_user_id = 0;
pro.edit_time = DateTime.Now;
pro.edit_user_id = 0;
pro.express_descrip = "";
pro.express_name = expressname;
pro.express_status = true;
pro.remark = "";
int isexit = 0;
int id = 0;
bool isok = _service.AddExpress(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 = "/Express/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));
}
}