public ActionResult AddLinkMan(string LinkMan, string LinkPhone, string LinkEmail, string Remark)
{
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<LinkMan, bool>> exp = u => u.LinkManName == LinkMan;
LinkMan obj = db.LinkMan.Where(exp).FirstOrDefault();
if (obj != null)
{
throw new Exception("客户名称已存在！");
}
{
TugDataModel.LinkMan newLinkMan = new LinkMan();//
newLinkMan.LinkManName = LinkMan;
newLinkMan.LinkPhone = LinkPhone;
newLinkMan.LinkEmail = LinkEmail;
newLinkMan.Remark = Remark;
newLinkMan.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
newLinkMan.UserDefinedCol1 = "";
newLinkMan.UserDefinedCol2 = "";
newLinkMan.UserDefinedCol3 = "";
newLinkMan.UserDefinedCol4 = "";
newLinkMan.UserDefinedCol9 = "";
newLinkMan.UserDefinedCol10 = "";
newLinkMan = db.LinkMan.Add(newLinkMan);
db.SaveChanges();
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult AddEdit_LinkMan()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.LinkMan linkMan = new LinkMan();
linkMan.LinkManName = Request.Form["LinkManName"];
linkMan.LinkPhone = Request.Form["LinkPhone"];
linkMan.LinkEmail = Request.Form["LinkEmail"];
linkMan.Remark = Request.Form["Remark"];
linkMan.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
linkMan.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
linkMan.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
linkMan.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
linkMan.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
linkMan.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
linkMan.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
linkMan.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
linkMan.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
linkMan.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
linkMan.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
linkMan = db.LinkMan.Add(linkMan);
db.SaveChanges();
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
return Json(ret);
}
}
#endregion Add
#region Edit
if (Request.Form["oper"].Equals("edit"))
{
try
{
int idx = Util.toint(Request.Form["IDX"]);
string name = Request.Form["LinkMan"];
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<LinkMan, bool>> exp = u => u.LinkManName == name && u.IDX != idx;
LinkMan obj = db.LinkMan.Where(exp).FirstOrDefault();
if (obj != null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = "客户名称已存在！" });//Resources.Common.ERROR_MESSAGE
}
LinkMan linkMan = db.LinkMan.Where(u => u.IDX == idx).FirstOrDefault();
if (linkMan == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
linkMan.LinkManName = Request.Form["LinkManName"];
linkMan.LinkPhone = Request.Form["LinkPhone"];
linkMan.LinkEmail = Request.Form["LinkEmail"];
linkMan.Remark = Request.Form["Remark"];
linkMan.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
linkMan.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
linkMan.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
linkMan.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
linkMan.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
linkMan.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
linkMan.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
linkMan.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
linkMan.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
linkMan.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
db.Entry(linkMan).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var linkmanList = db.OrderInfor.Where(u => u.CustomerID == idx).ToList();
if (linkmanList != null)
{
foreach (var item in linkmanList)
{
item.CustomerName = linkMan.LinkManName;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
