public void ProcessRequest(HttpContext context)
{
//{ UserName: userName, OldPassWord: oldPassWord, NewPassword: newPassword }
context.Response.ContentType = "text/plain";
DBContainer db = new DBContainer();
if (context.Request.Form["UserName"] == null
&& context.Request.Form["OldPassWord"] == null
&& context.Request.Form["NewPassword"] == null)
{
context.Response.Write("操作失败,参数错误");
return;
}
string userName = context.Request.Form["UserName"];
string newPassword = context.Request.Form["NewPassword"];
string odPassWord = context.Request.Form["OldPassWord"];
dtUser user = (from u in db.dtUser where u.CuserName == userName && u.CPass == odPassWord select u).FirstOrDefault();
if (user == null)
{
context.Response.Write("操作失败,原始密码错误");
return;
}
else
{
//user = new dtUser() { CuserName = userName, CPass = passWord, BIsLock = false };
user.CPass = newPassword;
db.SaveChanges();
context.Response.Write("修改成功");
}
}
protected void Page_Load(object sender, EventArgs e)
{
DBContainer db=new DBContainer();
dtType type = (from t in db.dtType where t.Id == TypeId select t).FirstOrDefault();
if (type == null)
{
this.Page.Response.StatusCode = 404;
this.Page.Response.End();
return;
}
int startNum = (PageNum - 1) * ListSize;
List<dtInfo> list = (from info in db.dtInfo where info.dtType.Id == TypeId && info.BIsMode == false orderby info.Id descending select info).Skip(startNum).Take(ListSize).ToList();
foreach (var item in list)
{
if (item.CTitle.Length > TitleLength)
{
item.CTitle = item.CTitle.Substring(0, TitleLength - 1)+"…";
}
}
groupName.InnerText = type.CTypeName;
dtInfoRepeater.DataSource = list;
dtInfoRepeater.DataBind();
int i = (from info in db.dtInfo where info.dtType.Id == TypeId && info.BIsMode == false select info).Count();
PageCount.InnerText = Math.Ceiling((double)i / ListSize) + "";
nowPage.InnerText = PageNum + "";
InputTypeId.Value = TypeId + "";
}
public void ProcessRequest(HttpContext context)
{
DBContainer db=new DBContainer();
context.Response.ContentType = "text/plain";
if (context.Request.Form["Id"]==null)
{
context.Response.Write("操作失败,参数错误");
return;
}
int id = int.Parse(context.Request.Form["Id"]);
bool bIsLock=context.Request.Form["BIsLock"]=="true";
dtUser user = (from u in db.dtUser where u.Id == id select u).FirstOrDefault();
if (user==null)
{
context.Response.Write("操作失败,用户不存在");
return;
}
if (user.CuserName=="admin")
{
context.Response.Write("操作失败,权限不足");
return;
}
user.BIsLock = bIsLock;
db.SaveChanges();
context.Response.Write("操作成功");
return;
}
public void ProcessRequest(HttpContext context)
{
DBContainer db = new DBContainer();
context.Response.ContentType = "text/plain";
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
int start = (page - 1) * rows;
var Infos = (from i in db.dtInfo
where i.BIsMode==true
select new
{
DTPubDate = i.DTPubDate,
CTitle = i.CTitle,
Id = i.Id,
BIsMode = i.BIsMode,
UserName = i.dtUser.CuserName,
operation = i.Id,
CtypeName = i.dtType.CTypeName
}).OrderByDescending(i => i.Id).Skip(start).Take(rows).ToList();
string result = JsonConvert.SerializeObject(Infos);
int count = (from i in db.dtInfo where i.BIsMode==true select i).Count();
//总记录数total
//构造json
result = "{\"total\":" + count + ",\"rows\":" + result + "}";
context.Response.Write(result);
}
protected void Page_Load(object sender, EventArgs e)
{
DBContainer db = new DBContainer();
if (Request.Cookies["userId"] != null && Request.Cookies["userName"] != null)
{
int userId = int.Parse(Request.Cookies["UserId"].Value);
string userName = Request.Cookies["UserName"].Value;
dtUser user = (from u in db.dtUser where u.Id == userId && u.CuserName == userName && u.BIsLock == false select u).FirstOrDefault();
if (user != null && user.Id > 0)
{
List<dtType> typeList = db.dtType.ToList();
typeNameRepeater.DataSource = typeList;
typeNameRepeater.DataBind();
int id = int.Parse(Request["id"]);
dtInfo info = (from i in db.dtInfo where i.Id == id select i).FirstOrDefault();
news_title.Value = info.CTitle;
newsAuthor.Value = info.dtUser.CuserName;
hiddenNewsType.Value = info.dtType.Id + "";
BIsMode1.Checked = !info.BIsMode;
BIsMode2.Checked = info.BIsMode;
newsId.Value = id + "";
newsAuthorId.Value = info.dtUser.Id + "";
hiddenMyEditor.Value = info.CContent;
}
else
{
HttpContext.Current.Response.Redirect("/admin/Login/Index.aspx");
}
}
else
{
HttpContext.Current.Response.Redirect("/admin/Login/Index.aspx");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
DBContainer db=new DBContainer();
if (context.Request.Form["Login"]==null&&context.Request.Form["password"]==null)
{
return;
}
string userName = context.Request.Form["Login"];
string pass = context.Request.Form["Password"];
dtUser user=(from u in db.dtUser where u.CuserName==userName && u.CPass==pass&&u.BIsLock==false select u).FirstOrDefault();
if (user!=null&&user.Id>0)
{
string r=JsonConvert.SerializeObject(new dtUser(){Id=user.Id,CuserName=user.CuserName });
context.Response.Write(r);
return;
//HttpCookie cookies = new bHttpCookie("userInfo");
//cookies["validate"] = r;
//context.Response.AppendCookie(cookies);
}
else
{
context.Response.Write(JsonConvert.SerializeObject(new { code=-1}));
}
}
protected void Page_Load(object sender, EventArgs e)
{
DBContainer db = new DBContainer();
if (Request.Cookies["userId"] != null && Request.Cookies["userName"] != null)
{
int userId = int.Parse(Request.Cookies["UserId"].Value);
string userName = Request.Cookies["UserName"].Value;
dtUser user = (from u in db.dtUser where u.Id == userId && u.CuserName == userName && u.BIsLock == false select u).FirstOrDefault();
if (user != null && user.Id > 0)
{
newsUserName.Value = user.CuserName;
newsUserId.Value = user.Id+"";
List<dtType> typeList = db.dtType.ToList();
typeNameRepeater.DataSource = typeList;
typeNameRepeater.DataBind();
}
else
{
HttpContext.Current.Response.Redirect("/admin/Login/Index.aspx");
}
}
else
{
HttpContext.Current.Response.Redirect("/admin/Login/Index.aspx");
}
//添加user
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
DBContainer db = new DBContainer();
if (context.Request.Form["UserName"]==null&&context.Request.Form["PassWord"]==null)
{
context.Response.Write("添加失败,参数错误");
return;
}
string userName = context.Request.Form["UserName"];
string passWord = context.Request.Form["PassWord"];
dtUser user=(from u in db.dtUser where u.CuserName==userName select u).FirstOrDefault();
if (user!=null)
{
context.Response.Write("添加失败,用户名已存在");
return;
}
else
{
user = new dtUser() { CuserName = userName, CPass = passWord, BIsLock = false };
db.dtUser.Add(user);
db.SaveChanges();
context.Response.Write("添加成功");
}
}
public void ProcessRequest(HttpContext context)
{
int id = int.Parse(context.Request.Form["Id"]);
DBContainer db = new DBContainer();
dtInfo info = (from i in db.dtInfo where i.Id==id select i).FirstOrDefault();
db.Entry<dtInfo>(info).State = EntityState.Deleted;
db.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
DBContainer db = new DBContainer();
dtType type = db.dtType.Where(t => t.Id == TypeId).FirstOrDefault();
typeName = type.CTypeName;
List<dtInfo> infoList = type.dtInfo.Where(i => i.BIsMode == false).OrderByDescending(i => i.Id).Take(count).ToList();
listRepeater.DataSource = infoList;
listRepeater.DataBind();
}
public void ProcessRequest(HttpContext context)
{
int id = int.Parse(context.Request.Form["Id"]);
int val = int.Parse(context.Request.Form["Val"]);
DBContainer db = new DBContainer();
dtInfo info = (from i in db.dtInfo where i.Id == id select i).FirstOrDefault();
info.BIsMode = (val==1);
db.Entry<dtInfo>(info).State = System.Data.EntityState.Modified;
db.SaveChanges();//执行数据库操作
}
protected void Page_Load(object sender, EventArgs e)
{
DBContainer db = new DBContainer();
var ZZGZtype = (from type in db.dtType where type.Id == TypeId select type).FirstOrDefault();
if (ZZGZtype==null)
{
return;
}
List<dtInfo> list = ZZGZtype.dtInfo.Where(i=>i.BIsMode==false).ToList();
dtInfoList.DataSource = list;
dtInfoList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DBContainer db = new DBContainer();
dtType type = db.dtType.Where(t => t.Id == TypeId).FirstOrDefault();
typeName = type.CTypeName;
List<dtInfo> infoList = type.dtInfo.Where(i => i.BIsPic == true).Where(i => i.BIsMode == false).OrderByDescending(i => i.Id).Take(Count).ToList();
List<dtInfo> picListLeft = infoList.Take(Count / 2).ToList();
List<dtInfo> picListRight = infoList.Skip(Count / 2).ToList();
picListLeftRepeater.DataSource = picListLeft;
picListRightRepeater.DataSource = picListRight;
picListLeftRepeater.DataBind();
picListRightRepeater.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DBContainer db = new DBContainer();
if (HttpContext.Current.Request.Cookies["UserId"] == null && HttpContext.Current.Request.Cookies["UserName"] != null)
{
string userName = HttpContext.Current.Request.Cookies["UserId"].ToString();
string pass = HttpContext.Current.Request.Cookies["UserName"].ToString();
dtUser user = (from u in db.dtUser where u.CuserName == userName && u.CPass == pass && u.BIsLock == false select u).FirstOrDefault();
if (user != null && user.Id > 0)
{
HttpContext.Current.Response.Redirect("/admin/Index.aspx");
}
}
}
public void ProcessRequest(HttpContext context)
{
DBContainer db = new DBContainer();
context.Response.ContentType = "text/plain";
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
int start = (page - 1) * rows;
var links = (from l in db.dtLink
select l).OrderByDescending(i => i.Id).OrderByDescending(i=>i.NSort).Skip(start).Take(rows).ToList();
string result = JsonConvert.SerializeObject(links);
int count = (from i in db.dtLink select i).Count();
//总记录数total
//构造json
result = "{\"total\":" + count + ",\"rows\":" + result + "}";
context.Response.Write(result);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
DBContainer db = new DBContainer();
if (context.Request.Form["Website"] == null && context.Request.Form["Url"] == null)
{
context.Response.Write("添加失败,参数错误");
return;
}
string website = context.Request.Form["Website"];
string url = context.Request.Form["Url"];
//dtLink link = (from u in db.dtLink where u. == website select u).FirstOrDefault();
dtLink link = new dtLink() { CTitle = website, CLinkUrl = url, BIsPic = false, CPicUrl = "/files/not_find_pic.png", DTPubDate = DateTime.Now };
db.dtLink.Add(link);
db.SaveChanges();
context.Response.Write("添加成功");
}
protected void Page_Load(object sender, EventArgs e)
{
DBContainer db = new DBContainer();
var list = (
from info in db.dtInfo
where info.dtType.Id == TypeId && info.BIsMode == false
select info).Take(ListCount).ToList();
foreach (var item in list)
{
if (item.CTitle.Length > TitleLength)
{
item.CTitle = item.CTitle.Substring(0, TitleLength - 1)+"…";
}
}
dtInfoRepeater.DataSource = list;
dtInfoRepeater.DataBind();
}
public void ProcessRequest(HttpContext context)
{
DBContainer db = new DBContainer();
context.Response.ContentType = "text/plain";
string cTitle = context.Request.Form["CTitle"];
string cContent = context.Request.Form["CContent"];
bool bIsMode = context.Request.Form["BIsMode"] == "true";
bool bIsPic = context.Request.Form["BIsPic"] == "true";
string cPicUrl = context.Request.Form["CPicUrl"];
int dtTypeId = int.Parse(context.Request.Form["DtTypeId"]);
int id = int.Parse(context.Request.Form["Id"]);
int dtUserId =int.Parse(context.Request.Form["dtUserId"]);
dtType type = (from t in db.dtType where t.Id == dtTypeId select t).FirstOrDefault();
dtUser user = (from u in db.dtUser where u.Id == dtUserId select u).FirstOrDefault();
DateTime dtPubDate = DateTime.Now;
dtInfo info=(from i in db.dtInfo where i.Id==id select i).FirstOrDefault();
info.CTitle = cTitle; info.CContent = cContent; info.BIsMode = bIsMode; info.BIsPic = bIsPic; info.CPicUrl = cPicUrl; info.DTPubDate = dtPubDate; info.dtType = type; info.dtUser = user ;
//db.dtInfo.Add(info);
db.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
DBContainer db = new DBContainer();
if (Request.Cookies["userId"] != null && Request.Cookies["userName"] != null)
{
int userId = int.Parse(Request.Cookies["UserId"].Value);
string userName = Request.Cookies["UserName"].Value;
dtUser user = (from u in db.dtUser where u.Id == userId && u.CuserName == userName && u.BIsLock == false select u).FirstOrDefault();
if (user != null && user.Id > 0)
{
}
else
{
HttpContext.Current.Response.Redirect("/admin/Login/Index.aspx");
}
}
else
{
HttpContext.Current.Response.Redirect("/admin/Login/Index.aspx");
}
}
public void ProcessRequest(HttpContext context)
{
DBContainer db=new DBContainer();
context.Response.ContentType = "text/plain";
string cTitle = context.Request.Form["CTitle"];
string cContent = context.Request.Form["CContent"];
bool bIsMode = context.Request.Form["BIsMode"]=="true";
bool bIsPic = context.Request.Form["BIsPic"] == "true";
string cPicUrl = context.Request.Form["CPicUrl"];
int dtTypeId =int.Parse(context.Request.Form["DtTypeId"]);
int dtUserId = int.Parse(context.Request.Form["DtUserId"]);
//int dtUserId =int.Parse(context.Request.Form["dtUserId"]);
dtType type = (from t in db.dtType where t.Id == dtTypeId select t).FirstOrDefault();
dtUser user = (from u in db.dtUser where u.Id == dtUserId select u).FirstOrDefault();
DateTime dtPubDate = DateTime.Now;
dtInfo info = new dtInfo() { CTitle = cTitle, CContent = cContent, BIsMode = bIsMode, BIsPic = bIsPic, CPicUrl = cPicUrl, DTPubDate = dtPubDate, dtType = type, dtUser = user };
db.dtInfo.Add(info);
db.SaveChanges();
//context.Response.Write(CContent);
}
public void ProcessRequest(HttpContext context)
{
DBContainer db = new DBContainer();
context.Response.ContentType = "text/plain";
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
string result = "";
int start = (page - 1) * rows;
var users = (from u in db.dtUser
select new
{
Id = u.Id,
CuserName=u.CuserName,
BIsLock=u.BIsLock
}).OrderByDescending(i => i.Id).Skip(start).Take(rows).ToList();
result = JsonConvert.SerializeObject(users);
int count = db.dtUser.Count();
//总记录数total
//构造json
result = "{\"total\":" + count + ",\"rows\":" + result + "}";
context.Response.Write(result);
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="db">数据库</param>
/// <returns>集合</returns>
public IQueryable <SysException> GetList(DBContainer db)
{
IQueryable <SysException> list = db.SysException.AsQueryable();
return(list);
}
public SysUserRepository(DBContainer db) : base(db)
{
}
public Spl_TestClassRepository(DBContainer db) : base(db)
{
}
public MIS_Article_AlbumsRepository(DBContainer db) : base(db)
{
}
public SysPositionRepository(DBContainer db) : base(db)
{
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="db">数据库</param>
/// <returns>集合</returns>
public IQueryable <SysLog> GetList(DBContainer db)
{
IQueryable <SysLog> list = db.SysLog.AsQueryable();
return(list);
}
public BaseRepository(DBContainer context)
{
this.db = context;
}
public void Execute(IJobExecutionContext context)
{
using (DBContainer dbContext = new DBContainer())
{
DbSet <Spm_ExpressInfo> dbSet0 = dbContext.Set <Spm_ExpressInfo>();
DbSet <Spm_TracesInfo> dbSet1 = dbContext.Set <Spm_TracesInfo>();
KdApiSearchHelper search = new KdApiSearchHelper();
DateTime searchTime0 = DateTime.Now.AddDays(-3);
DateTime searchTime1 = DateTime.Now.AddDays(-14);
DateTime searchTime = DateTime.Now.AddDays(-1);
DateTime searchTime2 = DateTime.Now.AddDays(-14);
//DateTime searchTime = DateTime.Now.AddDays(-15);
//DateTime searchTime2 = DateTime.Now.AddDays(-16);
//spmContainer
//var eiContainer = dbSet0.Where(e => e.ShipperCode != "HHTT:天天快递" && !e.ShipperCode.Contains("LK:") && (e.ActualShipDateTime < searchTime && e.ActualShipDateTime > searchTime2 && (e.State == "0" || e.State == "900")));
var eiContainer = dbSet0.Where(e => e.ShipperCode != "HHTT:天天快递" && !e.ShipperCode.Contains("LK:") && ((e.ActualShipDateTime <searchTime && e.ActualShipDateTime> searchTime2 && (e.State == "0" || e.State == "900")) || (e.ActualShipDateTime <searchTime0 && e.ActualShipDateTime> searchTime1 && (e.State == "2"))));
//var eiContainer = dbSet0.Where(e => e.ShipperCode != "HHTT:天天快递" && !e.ShipperCode.Contains("LK:") && ((e.ActualShipDateTime < searchTime && e.ActualShipDateTime > searchTime2 && (e.State == "0" || e.State == "900")) || (e.ActualShipDateTime < searchTime0 && e.ActualShipDateTime > searchTime1 && (e.State == "2"))));
//var eiContainer = dbSet0.Where(e => e.TrackingNumber == "884997150832865860" || e.TrackingNumber == "884997154424198193" || e.TrackingNumber == "884997139039592133" || e.TrackingNumber == "884997158451108294");
int count = eiContainer.Count();
List <Spm_TracesInfo> addList = new List <Spm_TracesInfo>();
List <Spm_ExpressInfo> modifyList = new List <Spm_ExpressInfo>();
List <Spm_TracesInfo> traceList = dbSet1.ToList();
ParallelOptions parallelOptions = new ParallelOptions();
parallelOptions.MaxDegreeOfParallelism = 6;
Parallel.ForEach(eiContainer, parallelOptions, item =>
{
//foreach (var item in eiContainer) {
try
{
Apps.Models.Common.KdSearchModel result = JsonConvert.DeserializeObject <Apps.Models.Common.KdSearchModel>(search.getOrderTracesByJson(item.TrackingNumber, item.ShipperCode.Split(':')[0]));
if (result.Success)
{
//Spm_ExpressInfo exInfo = dbContext.Set<Spm_ExpressInfo>().Where(e=>e.TrackingNumber == item.TrackingNumber).FirstOrDefault();
modifyList.Add(new Spm_ExpressInfo()
{
Id = item.Id, State = result.State
});
//if (exInfo != null)
//{
//exInfo.State = result.State;
// exInfo.EBusinessID = result.EBusinessID;
// exInfo.OrderCode = result.OrderCode;
// exInfo.Reason = result.Reason;
// exInfo.Success = result.Success;
//dbContext.Entry<Spm_ExpressInfo>(exInfo).State = EntityState.Modified;
if (result.Traces.Count() > 0)
{
List <Spm_TracesInfo> ti = traceList.Where(t => t.ExInfoId == item.Id).OrderByDescending(a => a.AcceptTime).ToList();
//List<Spm_TracesInfoModel> ti = serviceSession.Spm_TracesInfo.GetList(t => t.ExInfoId == exInfo.Id).OrderByDescending(a => a.AcceptTime).ToList();
foreach (var tc in result.Traces)
{
if (ti.Count() > 0)
{
if ((tc.AcceptTime > ti.First().AcceptTime))
{
Spm_TracesInfo m = new Spm_TracesInfo()
{
Id = ResultHelper.NewId,
ExInfoId = item.Id,
AcceptTime = tc.AcceptTime,
AcceptStation = tc.AcceptStation,
};
addList.Add(m);
//dbContext.Entry<Spm_TracesInfo>(m).State = EntityState.Added;
}
}
else
{
Spm_TracesInfo m = new Spm_TracesInfo()
{
Id = ResultHelper.NewId,
ExInfoId = item.Id,
AcceptTime = tc.AcceptTime,
AcceptStation = tc.AcceptStation,
};
addList.Add(m);
//dbContext.Entry<Spm_TracesInfo>(m).State = EntityState.Added;
}
}
}
}
//}
}
catch
{
}
});
if (modifyList.Count() > 0)
{
foreach (var item in modifyList)
{
dbSet0.Where(e => e.Id == item.Id).First().State = item.State;
}
}
if (addList.Count() > 0)
{
dbSet1.AddRange(addList);
}
dbContext.SaveChanges();
//dbContext.SaveChanges();
}
}
public Spl_WarehouseAllocationRepository(DBContainer db) : base(db)
{
}
public bool ImportExcelData(string oper, string filePath, ref ValidationErrors errors)
{
bool rtn = true;
var targetFile = new FileInfo(filePath);
if (!targetFile.Exists)
{
errors.Add("导入的数据文件不存在");
return(false);
}
var excelFile = new ExcelQueryFactory(filePath);
using (XLWorkbook wb = new XLWorkbook(filePath))
{
//第一个Sheet
using (IXLWorksheet wws = wb.Worksheets.First())
{
//对应列头
excelFile.AddMapping <WMS_POModel>(x => x.PO, "采购订单");
excelFile.AddMapping <WMS_POModel>(x => x.PODate, "采购日期");
excelFile.AddMapping <WMS_POModel>(x => x.SupplierShortName, "供应商简称");
excelFile.AddMapping <WMS_POModel>(x => x.PartCode, "物料编码");
excelFile.AddMapping <WMS_POModel>(x => x.QTY, "数量");
excelFile.AddMapping <WMS_POModel>(x => x.PlanDate, "计划到货日期");
excelFile.AddMapping <WMS_POModel>(x => x.POType, "采购订单类型");
//excelFile.AddMapping<WMS_POModel>(x => x.Status, "状态");
excelFile.AddMapping <WMS_POModel>(x => x.Remark, "说明");
//excelFile.AddMapping<WMS_POModel>(x => x.Attr1, "");
//excelFile.AddMapping<WMS_POModel>(x => x.Attr2, "");
//excelFile.AddMapping<WMS_POModel>(x => x.Attr3, "");
//excelFile.AddMapping<WMS_POModel>(x => x.Attr4, "");
//excelFile.AddMapping<WMS_POModel>(x => x.Attr5, "");
//excelFile.AddMapping<WMS_POModel>(x => x.CreatePerson, "创建人");
//excelFile.AddMapping<WMS_POModel>(x => x.CreateTime, "创建时间");
//excelFile.AddMapping<WMS_POModel>(x => x.ModifyPerson, "修改人");
//excelFile.AddMapping<WMS_POModel>(x => x.ModifyTime, "修改时间");
//SheetName，第一个Sheet
var excelContent = excelFile.Worksheet <WMS_POModel>(0);
//开启事务
using (DBContainer db = new DBContainer())
{
var tran = db.Database.BeginTransaction(); //开启事务
int rowIndex = 0;
//检查数据正确性
foreach (var row in excelContent)
{
rowIndex += 1;
string errorMessage = String.Empty;
var model = new WMS_POModel();
model.Id = row.Id;
model.PO = row.PO;
model.PODate = row.PODate;
model.SupplierShortName = row.SupplierShortName;
model.PartCode = row.PartCode;
model.QTY = row.QTY;
model.PlanDate = row.PlanDate;
model.POType = row.POType;
model.Status = "有效";
model.Remark = row.Remark;
//model.Attr1 = row.Attr1;
//model.Attr2 = row.Attr2;
//model.Attr3 = row.Attr3;
//model.Attr4 = row.Attr4;
//model.Attr5 = row.Attr5;
//model.CreatePerson = row.CreatePerson;
//model.CreateTime = row.CreateTime;
//model.ModifyPerson = row.ModifyPerson;
//model.ModifyTime = row.ModifyTime;
if (!String.IsNullOrEmpty(errorMessage))
{
rtn = false;
errors.Add(string.Format("第 {0} 列发现错误：{1}{2}", rowIndex, errorMessage, "<br/>"));
wws.Cell(rowIndex + 1, excelFile.GetColumnNames("Sheet1").Count()).Value = errorMessage;
continue;
}
//执行额外的数据校验
try
{
AdditionalCheckExcelData(db, ref model);
}
catch (Exception ex)
{
rtn = false;
errorMessage = ex.Message;
errors.Add(string.Format("第 {0} 列发现错误：{1}{2}", rowIndex, errorMessage, "<br/>"));
wws.Cell(rowIndex + 1, excelFile.GetColumnNames("Sheet1").Count()).Value = errorMessage;
continue;
}
//写入数据库
WMS_PO entity = new WMS_PO();
entity.Id = model.Id;
entity.PO = model.PO;
entity.PODate = model.PODate;
entity.SupplierId = model.SupplierId;
entity.PartId = model.PartId;
entity.QTY = model.QTY;
entity.PlanDate = model.PlanDate;
entity.POType = model.POType;
entity.Status = "有效";
entity.Remark = model.Remark;
entity.Attr1 = model.Attr1;
entity.Attr2 = model.Attr2;
entity.Attr3 = model.Attr3;
entity.Attr4 = model.Attr4;
entity.Attr5 = model.Attr5;
entity.CreatePerson = oper;
entity.CreateTime = DateTime.Now;
entity.ModifyPerson = oper;
entity.ModifyTime = DateTime.Now;
db.WMS_PO.Add(entity);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
rtn = false;
//将当前报错的entity状态改为分离，类似EF的回滚（忽略之前的Add操作）
db.Entry(entity).State = System.Data.Entity.EntityState.Detached;
errorMessage = ex.InnerException.InnerException.Message;
errors.Add(string.Format("第 {0} 列发现错误：{1}{2}", rowIndex, errorMessage, "<br/>"));
wws.Cell(rowIndex + 1, excelFile.GetColumnNames("Sheet1").Count()).Value = errorMessage;
}
}
if (rtn)
{
tran.Commit(); //必须调用Commit()，不然数据不会保存
}
else
{
tran.Rollback(); //出错就回滚
}
}
}
wb.Save();
}
return(rtn);
}
private void AdditionalCheckExcelData(DBContainer db, ref WMS_POModel model)
{
//获取物料ID
if (!String.IsNullOrEmpty(model.PartCode))
{
var partCode = model.PartCode;
Expression <Func <WMS_Part, bool> > exp = x => x.PartCode == partCode;
//var part = m_PartRep.GetSingleWhere(exp);
var part = db.WMS_Part.FirstOrDefault(exp);
if (part == null)
{
throw new Exception("物料编码不存在！");
}
else
{
model.PartId = part.Id;
}
}
else
{
throw new Exception("物料编码不能为空！");
}
//获取代理商ID
if (!String.IsNullOrEmpty(model.SupplierShortName))
{
var supplierShortName = model.SupplierShortName;
Expression <Func <WMS_Supplier, bool> > exp = x => x.SupplierShortName == supplierShortName;
//var supplier = m_SupplierRep.GetSingleWhere(exp);
var supplier = db.WMS_Supplier.FirstOrDefault(exp);
if (supplier == null)
{
throw new Exception("供应商简称不存在！");
}
else
{
model.SupplierId = supplier.Id;
}
}
else
{
throw new Exception("供应商简称不能为空！");
}
//校验订单号与物料
if (!String.IsNullOrEmpty(model.PO))
{
var partId = model.PartId;
var po = model.PO;
Expression <Func <WMS_PO, bool> > exp = x => x.PartId == partId && x.PO == po;
//var part = m_PORep.GetSingleWhere(exp);
var part = db.WMS_PO.FirstOrDefault(exp);
if (part != null)
{
throw new Exception("订单号与物料编码重复！");
}
}
else
{
throw new Exception("订单号不能为空！");
}
//校验订单号与供应商
if (!String.IsNullOrEmpty(model.PO))
{
var supplierId = model.SupplierId;
var po = model.PO;
Expression <Func <WMS_PO, bool> > exp = x => x.PO == po && x.SupplierId != supplierId;
//var result = m_PORep.GetSingleWhere(exp);
var result = db.WMS_PO.FirstOrDefault(exp);
if (result != null)
{
throw new Exception("同订单存在不同供应商！");
}
}
}
public Spl_WarehouseCategoryRepository(DBContainer db) : base(db)
{
}
public void Execute(IJobExecutionContext context)
{
string url = ConfigurationManager.AppSettings["URL"].ToString();
string appkey = ConfigurationManager.AppSettings["APPKEY"].ToString(); //"1023883919"; 23883919
string secret = ConfigurationManager.AppSettings["SECRET"].ToString(); //"sandboxff0b11ecc626508c171a5b2a2";
string customeId = ConfigurationManager.AppSettings["CUSTOMEID"].ToString();
string v = ConfigurationManager.AppSettings["v"].ToString();
string[] customerArr = customeId.Split(',');
try
{
_logger.Info("EntryorderConfirmJob 开始执行... " + DateTime.Now + "");
foreach (var cId in customerArr)
{
using (SCVDBContainer dbContext0 = new SCVDBContainer())
using (DBContainer dbContext1 = new DBContainer())
{
DbSet <RECEIPT_HEADER> header = dbContext0.Set <RECEIPT_HEADER>();
DbSet <RECEIPT_DETAIL> detail = dbContext0.Set <RECEIPT_DETAIL>();
//DbSet<QiMen_PushTimeStatus> dbSet0 = dbContext1.Set<QiMen_PushTimeStatus>();
DbSet <QiMen_PushLog> dbSet1 = dbContext1.Set <QiMen_PushLog>();
IQimenClient client = new DefaultQimenClient(url, appkey, secret);
EntryorderConfirmRequest req = new EntryorderConfirmRequest();
//DateTime lastTime;
//QiMen_PushTimeStatus qmt = dbSet0.Where(q => q.CustomerId == cId && q.OrderType == RECEIPT && q.Interface == INTERFACE).FirstOrDefault();
//if (qmt == null)
//{
// qmt = new QiMen_PushTimeStatus() { CustomerId = cId, ActualArriveTime = DateTime.Now, OrderType = RECEIPT, Interface = INTERFACE };
// dbSet0.Add(qmt);
// lastTime = DateTime.Now.AddMinutes(-1);
//}
//else
//{
// lastTime = ((DateTime)qmt.ActualArriveTime).AddMinutes(-1);
//}
//var confirmlList = header.Where(h => h.COMPANY == cId && h.TRAILING_STS == 900 && !(h.RECEIPT_TYPE.Equals("THRK", StringComparison.OrdinalIgnoreCase)) && h.CLOSE_DATE >= lastTime).Include(r => r.RECEIPT_DETAIL).OrderByDescending(h => h.CLOSE_DATE).ToList();
var confirmlList = header.Where(h => h.COMPANY == cId &&
h.CREATE_USER == "EntryorderCreate" &&
(h.USER_DEF8 == null || h.USER_DEF8 == QimenPushStatus.Failure.ToString() ||
h.USER_DEF8 == "1" || h.USER_DEF8 == "2" || h.USER_DEF8 == "3" || h.USER_DEF8 == "4" || h.USER_DEF8 == "5") &&
(h.TRAILING_STS == 800 || h.TRAILING_STS == 850 || h.TRAILING_STS == 900) &&
!h.RECEIPT_TYPE.Equals("THRK", StringComparison.OrdinalIgnoreCase)
).Include(s => s.RECEIPT_DETAIL).ToList();
if (cId == "XGQQG")
{
confirmlList.Clear();
}
//if (cId == "CQHGE")
//{
// confirmlList = confirmlList.Where(l => l.CREATE_USER == "EntryorderCreate").ToList();
//}
if (cId == "CH")
{
req.CustomerId = "CH1";
}
else
{
req.CustomerId = cId;
}
req.Version = v;
req.Timestamp = DateTime.Now;
//bool pushFlag = true;
foreach (var itemHeader in confirmlList)
{
EntryorderConfirmRequest.EntryOrderDomain entryOrder = new EntryorderConfirmRequest.EntryOrderDomain();
entryOrder.EntryOrderCode = itemHeader.RECEIPT_ID;
entryOrder.OwnerCode = itemHeader.COMPANY;
entryOrder.WarehouseCode = itemHeader.WAREHOUSE;
entryOrder.OutBizCode = itemHeader.INTERNAL_RECEIPT_NUM.ToString();
//if (itemHeader.RECEIPT_ID == "RK1708240001")
//{
// entryOrder.OutBizCode = "xxx1231";
//}
entryOrder.Status = "FULFILLED";//item.TRAILING_STS.ToString();
entryOrder.ConfirmType = 0L;
entryOrder.EntryOrderType = itemHeader.RECEIPT_TYPE;
entryOrder.TotalOrderLines = (long)itemHeader.TOTAL_LINES;//======
entryOrder.EntryOrderId = itemHeader.INTERNAL_RECEIPT_NUM.ToString();
req.EntryOrder = entryOrder;
List <EntryorderConfirmRequest.OrderLineDomain> orderLineList = new List <EntryorderConfirmRequest.OrderLineDomain>();
foreach (var itemDetail in itemHeader.RECEIPT_DETAIL)
{
EntryorderConfirmRequest.OrderLineDomain orderLine = new EntryorderConfirmRequest.OrderLineDomain();
orderLine.ItemId = itemDetail.INTERNAL_RECEIPT_LINE_NUM.ToString();
orderLine.ItemName = itemDetail.ITEM_DESC;
orderLine.OwnerCode = itemDetail.COMPANY;
orderLine.ItemCode = itemDetail.ITEM;
orderLine.PlanQty = (long)itemDetail.TOTAL_QTY;
orderLine.ActualQty = (long)(itemDetail.TOTAL_QTY - itemDetail.OPEN_QTY);
//if (itemDetail.TOTAL_QTY != itemDetail.OPEN_QTY)
//{
// entryOrder.Status = "PARTFULFILLED";
//}
orderLine.OutBizCode = itemDetail.INTERNAL_RECEIPT_LINE_NUM.ToString();
//if (itemHeader.RECEIPT_ID == "RK1708240001")
//{
// orderLine.OutBizCode = itemDetail.INTERNAL_RECEIPT_LINE_NUM.ToString() + "x";
// orderLine.ActualQty = 0;
//}
orderLineList.Add(orderLine);
}
req.OrderLines = orderLineList;
var rsp = client.Execute(req);
QiMen_PushLog log = new QiMen_PushLog();
log.InternalOrderID = itemHeader.INTERNAL_RECEIPT_NUM;
log.OrderType = INTERFACE;
log.CustomerId = cId;
log.Flag = rsp.Flag;
log.Message = rsp.Message;
log.CreateTime = DateTime.Now;
dbSet1.Add(log);
if (rsp.Flag == "success")
{
itemHeader.USER_DEF8 = QimenPushStatus.Success.ToString();
_logger.Info("入库单:" + itemHeader.RECEIPT_ID + "确认成功----" + DateTime.Now);
}
else
{
//if (rsp.Message.Length > 50)
//{
// pushFlag = false;
//}
if (string.IsNullOrEmpty(itemHeader.USER_DEF8))
{
itemHeader.USER_DEF8 = "1";
}
else
{
int parseResult;
if (int.TryParse(itemHeader.USER_DEF8, out parseResult))
{
itemHeader.USER_DEF8 = (parseResult + 1).ToString();
}
}
_logger.Info("入库单:" + itemHeader.RECEIPT_ID + "确认失败:-" + rsp.Message + DateTime.Now);
}
}
//if (confirmlList.Count > 0 && pushFlag)
//{
// qmt.ActualArriveTime = (DateTime)confirmlList.First().CLOSE_DATE;
//}
dbContext0.SaveChanges();
dbContext1.SaveChanges();
}
}
_logger.Info("EntryorderConfirmJob 执行完成... " + DateTime.Now + "");
}
catch (Exception ex)
{
_logger.Error("EntryorderConfirmJob 异常..." + DateTime.Now + " " + ex.Message);
}
}
public WMS_InvInfoRepository(DBContainer db) : base(db)
{
}
public SysValidTokenRepository(DBContainer db) : base(db)
{
}
public Spl_ContactCompanyRepository(DBContainer db) : base(db)
{
}
public IQueryable <SysModule> GetModuleBySystem(DBContainer db, string parentId)
{
IQueryable <SysModule> list = db.SysModule.Where(o => o.ParentId == parentId).AsQueryable();
return(list);
}
public Flow_FormRepository(DBContainer db) : base(db)
{
}
public IQueryable <SysSample> GetList(DBContainer db, string queryStr)
{
IQueryable <SysSample> list = db.SysSample.Where(s => s.Name.Contains(queryStr)).AsQueryable();
return(list);
}
public SysRightOperateRepository(DBContainer db) : base(db)
{
}
public SysModuleOperateRepository(DBContainer db) : base(db)
{
}
public IQueryable <SysModuleOperate> GetList(DBContainer db)
{
IQueryable <SysModuleOperate> list = db.SysModuleOperate.AsQueryable();
return(list);
}
public WMS_ReportRepository(DBContainer db) : base(db)
{
}
public IQueryable <P_Sys_GetRoleByUserId_Result> GetRoleByUserId(DBContainer db, string userId)
{
return(db.P_Sys_GetRoleByUserId(userId).AsQueryable());
}
public WC_GroupRepository(DBContainer db) : base(db)
{
}
public void ProcessRequest(HttpContext context)
{
DBContainer db = new DBContainer();
context.Response.ContentType = "text/plain";
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
int dtTypeId=9999;
if (context.Request["DtTypeId"]!=null)
{
dtTypeId = int.Parse(context.Request["DtTypeId"]);
}
string searchTitle="";
if (context.Request["SearchTitle"]!=null)
{
searchTitle = context.Request["SearchTitle"];
}
string result = "";
int start = (page-1) * rows;
if (dtTypeId == 9999 && searchTitle.Length>0)
{
var Infos = (from i in db.dtInfo
where i.CTitle.Contains(searchTitle)
select new
{
DTPubDate = i.DTPubDate,
CTitle = i.CTitle,
Id = i.Id,
BIsMode = i.BIsMode,
UserName = i.dtUser.CuserName,
operation = i.Id,
CtypeName = i.dtType.CTypeName
}).OrderByDescending(i => i.Id).Skip(start).Take(rows).ToList();
result = JsonConvert.SerializeObject(Infos);
int count = (from i in db.dtInfo where i.CTitle.Contains(searchTitle) select i).Count();
//总记录数total
//构造json
result = "{\"total\":" + count + ",\"rows\":" + result + "}";
context.Response.Write(result);
}
if (dtTypeId != 9999 && searchTitle.Length == 0)
{
var Infos = (from i in db.dtInfo
where i.dtType.Id == dtTypeId
select new
{
DTPubDate = i.DTPubDate,
CTitle = i.CTitle,
Id = i.Id,
BIsMode = i.BIsMode,
UserName = i.dtUser.CuserName,
operation = i.Id,
CtypeName = i.dtType.CTypeName
}).OrderByDescending(i => i.Id).Skip(start).Take(rows).ToList();
result = JsonConvert.SerializeObject(Infos);
int count = (from i in db.dtInfo where i.dtType.Id == dtTypeId select i).Count();
//总记录数total
//构造json
result = "{\"total\":" + count + ",\"rows\":" + result + "}";
context.Response.Write(result);
}
if (dtTypeId != 9999 && searchTitle.Length > 0)
{
var Infos = (from i in db.dtInfo
where i.dtType.Id == dtTypeId && i.CTitle.Contains(searchTitle)
select new
{
DTPubDate = i.DTPubDate,
CTitle = i.CTitle,
Id = i.Id,
BIsMode = i.BIsMode,
UserName = i.dtUser.CuserName,
operation = i.Id,
CtypeName = i.dtType.CTypeName
}).OrderByDescending(i => i.Id).Skip(start).Take(rows).ToList();
result = JsonConvert.SerializeObject(Infos);
int count = (from i in db.dtInfo where i.dtType.Id == dtTypeId && i.CTitle.Contains(searchTitle) select i).Count();
//总记录数total
//构造json
result = "{\"total\":" + count + ",\"rows\":" + result + "}";
context.Response.Write(result);
}
if (dtTypeId == 9999 && searchTitle.Length == 0)
{
var Infos = (from i in db.dtInfo
select new
{
DTPubDate = i.DTPubDate,
CTitle = i.CTitle,
Id = i.Id,
BIsMode = i.BIsMode,
UserName = i.dtUser.CuserName,
operation = i.Id,
CtypeName = i.dtType.CTypeName
}).OrderByDescending(i => i.Id).Skip(start).Take(rows).ToList();
result = JsonConvert.SerializeObject(Infos);
int count = (from i in db.dtInfo select i).Count();
//总记录数total
//构造json
result = "{\"total\":" + count + ",\"rows\":" + result + "}";
context.Response.Write(result);
}
}
public Spl_WarehouseWarrantRepository(DBContainer db) : base(db)
{
}
public SysLogRepository(DBContainer db) : base(db)
{
}
public Flow_StepRuleRepository(DBContainer db) : base(db)
{
}
public ApplicantController()
{
db = new DBContainer();
applicants = db.Applicants;
}
public void Post(TrackingInfoModel model)
{
if (model.meta != null && model.meta.code == 200)
{
if (model.data == null)
{
return;
}
if (model.data.origin_info != null && model.data.status != null && model.data.origin_info.trackinfo != null)
{
using (DBContainer dbContext = new DBContainer())
{
DbSet <Spm_ExpressInfo> dbSet0 = dbContext.Set <Spm_ExpressInfo>();
DbSet <Spm_TracesInfo> dbSet1 = dbContext.Set <Spm_TracesInfo>();
Spm_ExpressInfo exInfo = dbSet0.Where(o => o.TrackingNumber == model.data.tracking_number).FirstOrDefault();
if (exInfo != null)
{
switch (model.data.status)
{
case "notfound": exInfo.State = "0"; break;
case "transit":
case "pickup":
case "undelivered":
case "expired": exInfo.State = "2"; break;
case "delivered": exInfo.State = "3"; break;
case "exception": exInfo.State = "4"; break;
default:
break;
}
IQueryable <Spm_TracesInfo> ti = dbSet1.Where(t => t.ExInfoId == exInfo.Id).OrderByDescending(a => a.AcceptTime);
foreach (var item in model.data.origin_info.trackinfo)
{
if (ti.Count() > 0)
{
if ((item.Date > ti.First().AcceptTime))
{
Spm_TracesInfo m = new Spm_TracesInfo()
{
Id = ResultHelper.NewId,
ExInfoId = exInfo.Id,
AcceptTime = item.Date,
AcceptStation = item.StatusDescription + ";" + item.Details,
};
dbSet1.Add(m);
}
}
else
{
Spm_TracesInfo m = new Spm_TracesInfo()
{
Id = ResultHelper.NewId,
ExInfoId = exInfo.Id,
AcceptTime = item.Date,
AcceptStation = item.StatusDescription + ";" + item.Details,
};
dbSet1.Add(m);
}
}
}
dbContext.SaveChanges();
}
}
}
}
