/// <summary>
/// 添加供应商信息
/// </summary>
/// <param name="pro">供应商实体类</param>
/// <param name="exx">错误对象</param>
/// <returns></returns>
public bool InsertProductsources(model.productsource pro, out Exception exx)
{
try
{
OpenCon();
var temp = (from c in pbx.productsource where c.SourceCode == pro.SourceCode select c).ToList();
if (temp.Count > 0)
{
exx = new Exception("该供应商编号已经存在");
return(false);
}
pbx.productsource.InsertOnSubmit(pro);
pbx.SubmitChanges();
exx = null;
return(true);
}
catch (Exception ex)
{
exx = ex;
return(false);
}
finally
{
CloseCon();
}
}
/// <summary>
/// 修改供应商信息
/// </summary>
/// <param name="pro"></param>
/// <param name="exx"></param>
/// <returns></returns>
public bool UpdateProductsource(model.productsource pro, out Exception exx)
{
try
{
OpenCon();
var temp = from c in pbx.productsource where c.Id == pro.Id select c;
foreach (var v in temp)
{
v.SourceCode = pro.SourceCode;
v.sourceName = pro.sourceName;
v.sourcePhone = pro.sourcePhone;
v.SourceManage = pro.SourceManage;
v.SourceLevel = pro.SourceLevel;
v.UserId = pro.UserId;
v.Def2 = pro.Def2;
}
pbx.SubmitChanges();
exx = null;
return(true);
}
catch (Exception ex)
{
exx = ex;
return(false);
}
finally
{
CloseCon();
}
}
/// <summary>
/// 查询指定供应商信息
/// </summary>
/// <param name="Id"></param>
/// <param name="exx"></param>
/// <returns></returns>
public model.productsource GetProductsource(string Id, out Exception exx)
{
try
{
OpenCon();
var temp = (from c in pbx.productsource where c.SourceCode == Id select c).ToList();
model.productsource pro = new model.productsource();
if (temp.Count > 0)
{
exx = null;
return(temp[0]);
}
else
{
pro = null;
}
exx = null;
return(pro);
}
catch (Exception ex)
{
exx = ex;
return(null);
}
finally
{
CloseCon();
}
}
/// <summary>
/// 修改供应商信息
/// </summary>
/// <param name="pro"></param>
/// <param name="exx"></param>
/// <returns></returns>
public bool UpdateProductsource(model.productsource pro, int?UserId)
{
Exception ex;
bool bol = dal.UpdateProductsource(pro, out ex);
if (ex != null)
{
model.errorlog err = new model.errorlog();
err.operation = 1;
err.errorTime = DateTime.Now;
err.errorSrc = "pbxdata.bll.SystemConfigManagerbll->UpdateProductsource()--->pbxdata.dal.SystemConfigManagerdll->UpdateProductsource()";
err.ErrorMsg = ex.Source;
err.errorMsgDetails = ex.Message;
err.UserId = UserId;
error.InsertErrorlog(err);
}
else
{
model.errorlog err = new model.errorlog();
err.operation = 2;
err.errorTime = DateTime.Now;
err.errorSrc = "pbxdata.bll.SystemConfigManagerbll->UpdateProductsource()--->pbxdata.dal.SystemConfigManagerdll->InsertProductsourceConfig()";
err.ErrorMsg = "修改";
err.errorMsgDetails = "修改一条供应商信息";
err.UserId = UserId;
error.InsertErrorlog(err);
}
return(bol);
}
//添加供应商页面
public ActionResult InsertProductsoures()
{
ViewData["IsUpdate"] = "false";
pbxdata.model.productsource pro = new model.productsource();
pro.UserId = userInfo.User.UserId;
pro.UserName1 = userInfo.User.userName;
return(View(pro));
}
public ActionResult InsertProductsoures1(FormCollection fr)
{
bool isUpdate = bool.Parse(fr["IsUpdate"]);
pbxdata.bll.SystemConfigManagerbll systembll = new bll.SystemConfigManagerbll();
if (isUpdate)
{
pbxdata.model.productsource prop = systembll.GetProductsourece(fr["SourceCode"]);
prop.SourceCode = fr["SourceCode"] == "" ? prop.SourceCode : fr["SourceCode"];
prop.sourceName = fr["sourceName"] == "" ? prop.sourceName : fr["sourceName"];
prop.sourcePhone = fr["sourcePhone"] == "" ? prop.sourcePhone : fr["sourcePhone"];
prop.SourceManage = fr["SourceManage"] == "" ? prop.SourceManage : fr["SourceManage"];
prop.SourceLevel = fr["SourceLevel"] == "" ? prop.SourceLevel : fr["SourceLevel"];
prop.Def2 = fr["Def2"] == "" ? prop.Def2 : fr["Def2"];
prop.Def3 = fr["Def3"] == "" ? prop.Def3 : fr["Def3"];
prop.UserId = userInfo.User.Id;
bool bol = systembll.UpdateProductsource(prop, userInfo.User.Id);
if (bol)
{
return(Content("true"));
}
else
{
return(Content("false"));
}
}
else
{
model.productsource pro = new model.productsource();
pro.SourceCode = fr["SourceCode"];
pro.sourceName = fr["sourceName"];
pro.sourcePhone = fr["sourcePhone"];
pro.SourceManage = fr["SourceManage"];
pro.SourceLevel = fr["SourceLevel"];
pro.Def2 = fr["Def2"];
pro.Def3 = fr["Def3"];
pro.UserId = userInfo.User.Id;
//pbxdata.bll.SystemConfigManagerbll systembll = new bll.SystemConfigManagerbll();
bool bol;
bool success = systembll.InsertProductsources(pro, out bol);
if (!success)
{
if (bol)
{
return(Content("NoE"));
}
else
{
return(Content("保存失败！"));
}
}
return(Content("true"));
}
}
/// <summary>
/// 查找供应商
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public model.productsource GetProductsourece(string Id)
{
Exception ex;
model.productsource pro = dal.GetProductsource(Id, out ex);
if (pro == null && ex != null)
{
model.errorlog err = new model.errorlog();
err.operation = 1;
err.errorTime = DateTime.Now;
err.errorSrc = "pbxdata.bll.SystemConfigManagerbll->DeleteProductsources()--->pbxdata.dal.SystemConfigManagerdll->DeleteProductsources()";
err.ErrorMsg = ex.Source;
err.errorMsgDetails = ex.Message;
err.UserId = pro.UserId;
error.InsertErrorlog(err);
return(null);
}
return(pro);
}
/// <summary>
/// 添加供应商信息
/// </summary>
/// <param name="pro">供应商实体类</param>
/// <param name="IsExistCode">该供应商是否存在</param>
/// <returns></returns>
public bool InsertProductsources(model.productsource pro, out bool IsExistCode)
{
Exception ex;
bool bol = dal.InsertProductsources(pro, out ex);
if (!bol)
{
if (ex.Message.Equals("该供应商编号已经存在"))
{
IsExistCode = true;
return(false);
}
else
{
model.errorlog err = new model.errorlog();
err.operation = 1;
err.errorTime = DateTime.Now;
err.errorSrc = "pbxdata.bll.SystemConfigManagerbll->DeleteProductsources()--->pbxdata.dal.SystemConfigManagerdll->DeleteProductsources()";
err.ErrorMsg = ex.Source;
err.errorMsgDetails = ex.Message;
err.UserId = pro.UserId;
error.InsertErrorlog(err);
IsExistCode = false;
}
}
else
{
model.errorlog err = new model.errorlog();
err.operation = 2;
err.errorTime = DateTime.Now;
err.errorSrc = "pbxdata.bll.SystemConfigManagerbll->DeleteProductsources()--->pbxdata.dal.SystemConfigManagerdll->DeleteProductsources()";
err.ErrorMsg = " 添加";
err.errorMsgDetails = "添加一条供应商信息";
err.UserId = pro.UserId;
error.InsertErrorlog(err);
IsExistCode = false;
}
IsExistCode = false;
return(bol);
}
/// <summary>
/// 获取所有供应商信息
/// </summary>
/// <param name="exx">异常信息</param>
/// <returns></returns>
public List <model.productsource> GetProductsource(out Exception exx)
{
try
{
pbx = new model.pbxdatasourceDataContext(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
/// <summary>
OpenCon();
var temp = from c in pbx.productsource orderby c.SourceCode ascending select c;
List <model.productsource> list = new List <model.productsource>();
foreach (var t in temp)
{
var user = (from c in pbx.users where c.Id == t.UserId select c.userName).ToList();
model.productsource pro = new model.productsource();
pro.Id = t.Id;
pro.SourceCode = t.SourceCode;
pro.sourceName = t.sourceName;
pro.sourcePhone = t.sourcePhone;
pro.SourceManage = t.SourceManage;
pro.SourceLevel = t.SourceLevel;
pro.UserId = t.UserId;
pro.UserName1 = user.Count > 0 ? user[0].ToString() : "";
pro.Def2 = t.Def2;
pro.Def3 = t.Def3;
list.Add(pro);
}
exx = null;
return(list);
}
catch (Exception ex)
{
exx = ex;
return(null);
}
finally
{
CloseCon();
}
}
