public void TestSaveSupplierMng()
{
AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory);
using (var db = new PurchaseEntities())
{
SupplierMng supplier = db.SupplierMng.Find(0);
// supplier.SupplierName = "供应商名称2";
supplier.SupplierMngAttachmentFile.Clear();
for (int i = 0; i < 2; i++)
{
SupplierMngAttachmentFile attach = new SupplierMngAttachmentFile();
attach.FileName = "fileName1";
attach.SeqNO = i + 1;
attach.SupplierId = supplier.Id;
attach.SupplierMng = supplier;
attach.UploadChk = true;
attach.InDateTime = DateTime.Now;
attach.InUserId = "admin";
supplier.SupplierMngAttachmentFile.Add(attach);
}
db.SaveChanges();
}
}
public ActionResult EmailSend(int projectId, int supplierId, string SettlementId, string QuotationGroupId)
{
ViewBag.ProjectId = projectId;
ViewBag.SupplierId = supplierId;
Projects Projects = db.Projects.Find(projectId);
ViewBag.ProjectName = "";
ViewBag.ProjectShortName = "";
if (Projects != null)
{
ViewBag.ProjectName = Projects.ProjectName;
ViewBag.ProjectShortName = Projects.ProjectShortName;
ViewBag.ProjectCode = Projects.ProjectCode;
ViewBag.ModelType = Projects.ModelType;
}
SupplierMng SupplierMng = db.SupplierMng.Find(supplierId);
ViewBag.SupplierName = "";
ViewBag.SupplierShortName = "";
ViewBag.Email = "";
if (SupplierMng != null)
{
ViewBag.SupplierName = SupplierMng.SupplierName;
ViewBag.SupplierShortName = SupplierMng.SupplierShortName;
ViewBag.Email = SupplierMng.BussinessMainEmail + "," + SupplierMng.BussinessSecondEmail;
}
ViewBag.SettlementId = SettlementId;
ViewBag.QuotationGroupId = QuotationGroupId;
return(View("EmailSend"));
}
public ActionResult DeleteConfirmed(int id)
{
SupplierMng suppliermng = db.SupplierMng.Find(id);
db.SupplierMng.Remove(suppliermng);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id, FormCollection collection)
{
try
{
SupplierMng supplierMng = new SupplierMng();
//if (ModelState.IsValid)
//{
supplierMng = db.SupplierMng.Find(id);
// 不是临时保存的时候，如果变更了银行信息则需要保留一条提醒，如果是临时保存不需要进操作
if (supplierMng.TempChk != "Y")
{
string changePros = "";
bool isChange = false;
string[] propertys = { "SupplierName", "AccountName", "AccountBankFullName", "AccountBankNo", "AccountBankAddress" };
foreach (string pro in propertys)
{
var value = supplierMng.GetType().GetProperty(pro).GetValue(supplierMng);
string valueString = value == null ? "" : value.ToString();
if (collection.Get(pro) != valueString)
{
changePros += pro + ",";
isChange = true;
}
}
if (isChange)
{
changePros = changePros.Substring(0, changePros.Length - 1);
//supplierMng.BankModifyDateTime = DateTime.Now;
//supplierMng.BankModifyColumn = changePros;
service.SupplierModifySave(supplierMng.Id.ToString(), UserInfo.UserId, changePros, false); // 修改的时候对财务人员保存一条提醒记录
}
}
supplierMng.ModifyDateTime = DateTime.Now;
supplierMng.ModifyUserId = UserInfo.UserId;
TryUpdateModel <SupplierMng>(supplierMng);
// 如果供应商代码为9999，有可能是没有选择城市，所有重新给供应商编码赋值。
if (supplierMng.SupplierCode == "9999")
{
supplierMng.SupplierCode = GetSupplierCode(supplierMng.City);
}
SavePng(supplierMng);
db.SaveChanges();
string queryParams = Request.Form["queryParams"];
return(RedirectToAction("Index", new { queryParams = queryParams }));
//}
return(View(supplierMng));
}
catch (Exception e)
{
return(View(e.Message.ToString()));
}
}
// GET: /SupplierMng/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ViewBag.queryParams = Request.QueryString["queryParams"];
ViewBag.UserRoleType = UserInfo.RoleTypeCode;
SupplierMng suppliermng = new SupplierMng()
{
Id = id.Value
};
return(View(suppliermng));
}
public ActionResult Load(SupplierMng condition, string applyStatusCode, int pageNum, int?pageSize)
{
DateFormatString = "yyyy-MM-dd HH:mm:ss";
if (pageSize.HasValue)
{
_countPerPage = pageSize.Value;
}
List <SupplierDto> list = service.SupplierSearch(condition, ((Mst_UserInfo)Session["LoginUser"]).UserId, applyStatusCode);
int total = list.Count();
int pageCount = CalcPages(total, pageSize);
int start = CalcStartIndex(pageNum);
list = list.Skip(start).Take(_countPerPage).ToList();
return(Json(new { List = list, PageCount = pageCount, CurPage = pageNum }));
}
private void SavePng(SupplierMng supplierMng)
{
supplierMng.SupplierMngAttachmentFile.Clear();
string[] attachs = Request.Form["AttachPngs"].Split(',');
for (int i = 0; i < attachs.Length; i++)
{
int seqNo = i + 1;
SupplierMngAttachmentFile attach = new SupplierMngAttachmentFile();
attach.FileName = attachs[i];
attach.SeqNO = seqNo;
attach.SupplierId = supplierMng.Id;
attach.SupplierMng = supplierMng;
attach.UploadChk = !string.IsNullOrWhiteSpace(attach.FileName);
attach.InDateTime = DateTime.Now;
attach.InUserId = UserInfo.InUserId;
supplierMng.SupplierMngAttachmentFile.Add(attach);
}
}
public ActionResult ExportSupplierBankInfo(SupplierMng condition)
{
List <SupplierDto> list = service.SupplierBankInfoSearch(condition, ((Mst_UserInfo)Session["LoginUser"]).UserId);
string absPath = Server.MapPath(basePath);
if (!Directory.Exists(absPath))
{
Directory.CreateDirectory(absPath);
}
string createFileName = "供应商银行信息_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xlsx";
string path = absPath + createFileName;
string templateFile = Server.MapPath(tempPath + "供应商银行信息.xlsx");
System.IO.File.Copy(templateFile, path);
SupplierMngExport export = new SupplierMngExport();
export.ExportBankInfo(path, list);
return(Json(new { ExportPath = path }));
}
public ActionResult Create(SupplierMng supplierMng)
{
try
{
//if (ModelState.IsValid)
//{
List <SupplierDto> list = service.SupplierSearchBySupplierName(supplierMng.SupplierName, supplierMng.ServiceTrade);
if (list.Count == 0)
{
supplierMng.SupplierCode = GetSupplierCode(supplierMng.City);
db.SupplierMng.Add(supplierMng);
supplierMng.InDateTime = DateTime.Now;
supplierMng.InUserId = UserInfo.UserId;
supplierMng.UseChk = true;
supplierMng.ModifyUserId = UserInfo.UserId;
supplierMng.ModifyDateTime = DateTime.Now;
db.SaveChanges();
service.SupplierModifySave(supplierMng.Id.ToString(), UserInfo.UserId, "", true); // 新增的时候对财务人员保存一条提醒记录
SavePng(supplierMng);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//}
//else
//{
//}
return(View(supplierMng));
}
catch (DbEntityValidationException ex)
{
throw ex;
}
}
public ActionResult LoadBank(SupplierMng condition, int pageNum, int?pageSize)
{
DateFormatString = "yyyy-MM-dd HH:mm:ss";
if (pageSize.HasValue)
{
_countPerPage = pageSize.Value;
}
//var query = db.SupplierMng.OrderByDescending(x => x.BankModifyDateTime).Select(s => new
// {
// s.Id,
// s.SupplierCode,
// s.SupplierType,
// s.SupplierName,
// s.SupplierShortName,
// s.RecommendDepartment,
// s.CooperationState,
// s.AccountName,
// s.AccountBankFullName,
// s.AccountBankNo,
// s.VATRate,
// s.ServiceTrade,
// s.Remark,
// s.PurchaseType,
// s.Province,
// s.City,
// s.InDateTime,
// s.InUserId,
// s.BankModifyColumn,
// s.BankModifyDateTime
// }).AsQueryable();
//#region ====查询条件============
//if (condition != null)
//{
// if (!string.IsNullOrWhiteSpace(condition.SupplierCode))
// {
// query = query.Where(x => x.SupplierCode.Contains(condition.SupplierCode));
// }
// if (!string.IsNullOrWhiteSpace(condition.SupplierName))
// {
// query = query.Where(x => x.SupplierName.Contains(condition.SupplierName));
// }
// if (!string.IsNullOrWhiteSpace(condition.SupplierShortName))
// {
// query = query.Where(x => x.SupplierShortName.Contains(condition.SupplierShortName));
// }
// if (!string.IsNullOrWhiteSpace(condition.CooperationState))
// {
// query = query.Where(x => x.CooperationState.Contains(condition.CooperationState));
// }
// if (!string.IsNullOrWhiteSpace(condition.ServiceTrade))
// {
// query = query.Where(x => x.ServiceTrade.Contains(condition.ServiceTrade));
// }
// if (!string.IsNullOrWhiteSpace(condition.PurchaseType))
// {
// query = query.Where(x => x.PurchaseType.Contains(condition.PurchaseType));
// }
// if (!string.IsNullOrWhiteSpace(condition.Province))
// {
// query = query.Where(x => x.Province.Contains(condition.Province));
// }
// if (!string.IsNullOrWhiteSpace(condition.City))
// {
// query = query.Where(x => x.City.Contains(condition.City));
// }
//}
//#endregion
//int total = query.Count();
//int pageCount = CalcPages(total,pageSize);
//int start = CalcStartIndex(pageNum);
//var lst = query.OrderByDescending(x => x.InDateTime).Skip(start).Take(_countPerPage).ToList();
List <SupplierDto> list = service.SupplierBankInfoSearch(condition, ((Mst_UserInfo)Session["LoginUser"]).UserId);
int total = list.Count();
int pageCount = CalcPages(total, pageSize);
int start = CalcStartIndex(pageNum);
list = list.Skip(start).Take(_countPerPage).ToList();
return(Json(new { List = list, PageCount = pageCount, CurPage = pageNum }));
//return Json(new { List = lst, PageCount = pageCount, CurPage = pageNum });
}
