public JsonResult tbactivitydef()
{
ErpDB db = new ErpDB();
var query = db.CActivity.Where(z => z.IsActive == true)
.Select(p => new { p.ID, p.ActivityName });
return(Json(new { aaData = query }, JsonRequestBehavior.AllowGet));
}
public JsonResult tbdeptdef()
{
ErpDB db = new ErpDB();
var query = db.Hr_dept
.Select(p => new { p.DeptID, p.DeptName });
return(Json(new { aaData = query }, JsonRequestBehavior.AllowGet));
}
public JsonResult tbcpydef()
{
ErpDB db = new ErpDB();
var query = db.Company.Where(z => z.IsActive == true)
.Select(p => new { p.ID, p.CompanyName, p.ProList.Count });
return(Json(new { aaData = query }, JsonRequestBehavior.AllowGet));
}
public JsonResult tbempdef()
{
ErpDB db = new ErpDB();
var query = db.HR_EmpReform
.Select(p => new { p.Emp_Id, p.Emp_Name });
return(Json(new { aaData = query }, JsonRequestBehavior.AllowGet));
}
public JsonResult jcatfunk(int id)
{
ErpDB db = new ErpDB();
var query = db.JobCategory.Where(x => x.Kdr_fk == id)
.Select(p => new { p.JBC_PK, p.JBC_Name });
SelectList data = new SelectList(query, "JBC_PK", "JBC_Name", 0);
return(Json(data));
}
public void SyncReadyMBill(string[] readyMBill = null)
{
// 获取配置文件
var config = HttpHelp.RequsetAbp <SettingValue[]>(RequsetMethod.POST, "/api/services/app/Configuration/GetAppConfig", new string[] { "defaultForCustomerMStorageId", "defaultForSelfMStorageId", "reelMoveMethodId" }, null, false).Result;
string sql = string.Format(@"SELECT
ltrim(rtrim(reqno)) Id,
'True' IsActive,
ltrim(rtrim(parentitem)) ProductId,
ltrim(rtrim(line)) LineId,
ltrim(rtrim(sono)) WorkBillId,
soqty WorkQty,
ltrim(rtrim(partno)) PartNoId,
reqqty PartNoQty,
CASE WHEN SUBSTRING(ltrim(rtrim(partno)),1,1)='2' THEN 36*30 ELSE 18*30 END as ShelfLife,
'{0}' ReelMoveMethodId,
'{1}' ForCustomerMStorageId,
'{2}' ForSelfMStorageId
FROM
materialrequest_erp" , config.FirstOrDefault(c => c.Name == "reelMoveMethodId").Value, config.FirstOrDefault(c => c.Name == "defaultForCustomerMStorageId").Value, config.FirstOrDefault(c => c.Name == "defaultForSelfMStorageId").Value);
if (readyMBill == null || readyMBill.Length == 0)
{
sql += " where DateDiff(dd,mtime,getdate())<=2";
}
else
{
sql += " where ltrim(rtrim(reqno)) in ('" + string.Join("','", readyMBill) + "')";
}
var res = ErpDB.Query <RBBatchReadyMBillDto>(sql, System.Data.CommandType.Text);
// 先同步物料信息,分批次
SyncMaterial(res.GroupBy(r => r.PartNoId).Select(r => r.Key).Union(res.GroupBy(r => r.ProductId).Select(r => r.Key)).ToArray());
// 分批次同步备料信息
int pageIndex = 1, pageSize = 200, tol = res.Count();
while ((pageIndex - 1) * pageSize < tol)
{
var async = res.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var ress = HttpHelp.RequsetAbp <bool>(RequsetMethod.POST, "/api/services/app/ReadyMBill/RBBatchInsOrUpdate", async, null, false);
pageIndex += 1;
}
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
bool authorize = false;
using (ErpDB db = new ErpDB())
{
CoreManager UM = new CoreManager();
foreach (var roles in userAssignedRoles)
{
authorize = UM.IsUserInRole(httpContext.User.Identity.Name.Split('|')[0], roles);
if (authorize)
{
return(authorize);
}
}
}
return(authorize);
}
public void SyncMaterial(string[] pn = null)
{
string sql = @"SELECT
ltrim(rtrim(itemno)) Id,
ltrim(rtrim(itemname)) Name,
ltrim(rtrim(description)) Info,
NULL Remark,
30 ShelfLife,
itemclass MPNHierarchy,
itemlevel MPNLevel,
packagemax MPQ1,
itemtype MPNType,
0 MSDLevel,
0 IncomingMethod,
'True' IsActive
FROM
material_erp";
if (pn == null || pn.Length < 0)
{
sql += " where DateDiff(dd,mtime,getdate())<=7";
}
else
{
sql += " where ltrim(rtrim(itemno)) in ('" + string.Join("','", pn) + "')";
}
var res = ErpDB.Query <MPNDto>(sql);
int pageIndex = 1, pageSize = 200, tol = res.Count();
while ((pageIndex - 1) * pageSize < tol)
{
var async = res.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var ress = HttpHelp.RequsetAbp <bool>(RequsetMethod.POST, "/api/services/app/MPN/BatchInsOrUpdate", async, null, false);
pageIndex += 1;
}
}
