/// <summary>
/// 绑定供应商代码
/// </summary>
/// <returns></returns>
public ActionResult getEmpCode()
{
string Code = "";
var listEmp = (from tbEmp in MyModels.B_SupplierList
orderby tbEmp.SupplierNumber
select tbEmp).ToList();
if (listEmp.Count > 0)
{
int intCount = listEmp.Count;
B_SupplierList modelEmp = listEmp[intCount - 1];
int intEmp = Convert.ToInt32(modelEmp.SupplierNumber.Substring(1, 6));
intEmp++;
Code = intEmp.ToString();
for (int i = 0; i < 6; i++)
{
Code = Code.Length < 6 ? "0" + Code : Code;
}
Code = "" + Code;
}
else
{
Code = "000000";
}
return(Json(Code, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 删除供货商
/// </summary>
/// <param name="goodsId"></param>
/// <returns></returns>
public ActionResult DeleteHeTong(int goodsId)
{
//定义返回
string strMsg = "fail";
try
{
B_SupplierList dbGoodsDetail = (from tbGoodsDetail in MyModels.B_SupplierList
where tbGoodsDetail.SupplierID == goodsId
select tbGoodsDetail).Single();
MyModels.B_SupplierList.Remove(dbGoodsDetail);
if (MyModels.SaveChanges() > 0)
{
strMsg = "success";
}
}
catch (Exception)
{
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 审核
/// </summary>
/// <param name="SupplierListgf"></param>
/// <returns></returns>
public ActionResult ShenheJingXiao(B_SupplierList SupplierListgf)
{
string strMag = "fail";
B_SupplierList SupplierList = new B_SupplierList();
try
{
SupplierList.SupplierID = Convert.ToInt32(SupplierListgf.SupplierID);
SupplierList.SupplierNumber = SupplierListgf.SupplierNumber;
SupplierList.SupplierName = SupplierListgf.SupplierName;
SupplierList.SupplierCHName = SupplierListgf.SupplierCHName;
SupplierList.SupplierEnglishName = SupplierListgf.SupplierEnglishName;
SupplierList.SupplierAbbreviation = SupplierListgf.SupplierAbbreviation;
SupplierList.SupplierPTCode = SupplierListgf.SupplierPTCode;
SupplierList.SupplierDependency = SupplierListgf.SupplierDependency;
SupplierList.SupplierRegisteredAddress = SupplierListgf.SupplierRegisteredAddress;
SupplierList.SupplierRegisteredEnglish = SupplierListgf.SupplierRegisteredEnglish;
SupplierList.PaymentID = Convert.ToInt32(SupplierListgf.PaymentID);
SupplierList.CompanyID = Convert.ToInt32(SupplierListgf.CompanyID);
SupplierList.SupplierRankID = Convert.ToInt32(SupplierListgf.SupplierRankID);
SupplierList.UnitCharacterID = Convert.ToInt32(SupplierListgf.UnitCharacterID);
SupplierList.AgreementTypeID = Convert.ToInt32(SupplierListgf.AgreementTypeID);
SupplierList.AgreementStateID = Convert.ToInt32(SupplierListgf.AgreementStateID);
SupplierList.SupplierInformationName = SupplierListgf.SupplierInformationName;
SupplierList.SupplierTelephone = SupplierListgf.SupplierTelephone;
SupplierList.SupplierContacts = SupplierListgf.SupplierContacts;
SupplierList.SupplierPost = SupplierListgf.SupplierPost;
SupplierList.SupplierEmail = SupplierListgf.SupplierEmail;
SupplierList.SupplierZipCode = SupplierListgf.SupplierZipCode;
SupplierList.SupplierPortraiture = SupplierListgf.SupplierPortraiture;
SupplierList.SupplierAddress = SupplierListgf.SupplierAddress;
SupplierList.SupplierURL = SupplierListgf.SupplierURL;
SupplierList.EnterpriseBank = SupplierListgf.EnterpriseBank;
SupplierList.EnterpriseNumber = SupplierListgf.EnterpriseNumber;
SupplierList.EnterpriseNatureID = Convert.ToInt32(SupplierListgf.EnterpriseNatureID);
SupplierList.NationalTaxNumber = SupplierListgf.NationalTaxNumber;
SupplierList.EnterpriseTypeID = Convert.ToInt32(SupplierListgf.EnterpriseTypeID);
SupplierList.LocalTaxNumber = SupplierListgf.LocalTaxNumber;
SupplierList.EnterprisePassword = SupplierListgf.EnterprisePassword;
SupplierList.Registrant = SupplierListgf.Registrant;
SupplierList.Registranttime = Convert.ToDateTime(SupplierListgf.Registranttime);
SupplierList.Executor = SupplierListgf.Executor;
SupplierList.Executortime = Convert.ToDateTime(SupplierListgf.Executortime);
SupplierList.Auditor = SupplierListgf.Auditor;
SupplierList.Auditortime = Convert.ToDateTime(SupplierListgf.Auditortime);
if (SupplierList.SupplierNumber != "" && SupplierList.SupplierID > 0)
{
MyModels.Entry(SupplierList).State = System.Data.Entity.EntityState.Modified;
MyModels.SaveChanges();//changes的三种状态：新增、修改、删除
strMag = "success";
}
}
catch (Exception)
{
return(Json(strMag, JsonRequestBehavior.AllowGet));
}
return(Json(strMag, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增供应商
/// </summary>
/// <param name="SupplierList"></param>
/// <param name="SupplierInformationList"></param>
/// <param name="EnterpriseNatureList"></param>
/// <returns></returns>
public ActionResult SelectGoods(B_SupplierList SupplierListgf)
{
B_SupplierList SupplierList = new B_SupplierList();
string strMag = "fali";
ReturnJsonVo returnJson = new ReturnJsonVo();
try
{
SupplierList.SupplierNumber = SupplierListgf.SupplierNumber;
SupplierList.SupplierName = SupplierListgf.SupplierName;
SupplierList.SupplierCHName = SupplierListgf.SupplierCHName;
SupplierList.SupplierEnglishName = SupplierListgf.SupplierEnglishName;
SupplierList.SupplierAbbreviation = SupplierListgf.SupplierAbbreviation;
SupplierList.SupplierPTCode = SupplierListgf.SupplierPTCode;
SupplierList.SupplierDependency = SupplierListgf.SupplierDependency;
SupplierList.SupplierRegisteredAddress = SupplierListgf.SupplierRegisteredAddress;
SupplierList.SupplierRegisteredEnglish = SupplierListgf.SupplierRegisteredEnglish;
SupplierList.PaymentID = Convert.ToInt32(SupplierListgf.PaymentID);
SupplierList.CompanyID = Convert.ToInt32(SupplierListgf.CompanyID);
SupplierList.SupplierRankID = Convert.ToInt32(SupplierListgf.SupplierRankID);
SupplierList.UnitCharacterID = Convert.ToInt32(SupplierListgf.UnitCharacterID);
SupplierList.AgreementTypeID = Convert.ToInt32(SupplierListgf.AgreementTypeID);
SupplierList.AgreementStateID = Convert.ToInt32(SupplierListgf.AgreementStateID);
SupplierList.SupplierInformationName = SupplierListgf.SupplierInformationName;
SupplierList.SupplierTelephone = SupplierListgf.SupplierTelephone;
SupplierList.SupplierContacts = SupplierListgf.SupplierContacts;
SupplierList.SupplierPost = SupplierListgf.SupplierPost;
SupplierList.SupplierEmail = SupplierListgf.SupplierEmail;
SupplierList.SupplierZipCode = SupplierListgf.SupplierZipCode;
SupplierList.SupplierPortraiture = SupplierListgf.SupplierPortraiture;
SupplierList.SupplierAddress = SupplierListgf.SupplierAddress;
SupplierList.SupplierURL = SupplierListgf.SupplierURL;
SupplierList.EnterpriseBank = SupplierListgf.EnterpriseBank;
SupplierList.EnterpriseNumber = SupplierListgf.EnterpriseNumber;
SupplierList.EnterpriseNatureID = Convert.ToInt32(SupplierListgf.EnterpriseNatureID);
SupplierList.NationalTaxNumber = SupplierListgf.NationalTaxNumber;
SupplierList.EnterpriseTypeID = Convert.ToInt32(SupplierListgf.EnterpriseTypeID);
SupplierList.LocalTaxNumber = SupplierListgf.LocalTaxNumber;
SupplierList.EnterprisePassword = SupplierListgf.EnterprisePassword;
SupplierList.Registrant = SupplierListgf.Registrant;
SupplierList.Registranttime = Convert.ToDateTime(SupplierListgf.Registranttime);
if (SupplierList.SupplierNumber != "")
{
MyModels.B_SupplierList.Add(SupplierList);
MyModels.SaveChanges();
strMag = "success";
}
}
catch (Exception)
{
return(Json(strMag, JsonRequestBehavior.AllowGet));
}
return(Json(strMag, JsonRequestBehavior.AllowGet));
}
