public object GetDetails(int page, int rows, SRM srms) { IQueryable <SRM> sRMQuery = SRMRepository.GetQueryable(); var sRMDetail = sRMQuery.Where(s => s.SRMName.Contains(srms.SRMName) //&& s.OPCServiceName.Contains(srms.OPCServiceName) //&& s.GetRequest.Contains(srms.GetRequest) //&& s.GetAllow.Contains(srms.GetAllow) //&& s.GetComplete.Contains(srms.GetComplete) //&& s.PutRequest.Contains(srms.PutRequest) //&& s.PutAllow.Contains(srms.PutAllow) //&& s.PutComplete.Contains(srms.PutComplete) && s.State.Contains(srms.State)).OrderBy(ul => ul.SRMName); int total = sRMDetail.Count(); var sRMDetails = sRMDetail.Skip((page - 1) * rows).Take(rows); var sRM_Detail = sRMDetails.ToArray().Select(s => new { s.ID, s.SRMName, s.OPCServiceName, s.GetRequest, s.GetAllow, s.GetComplete, s.PutRequest, s.PutAllow, s.PutComplete, s.Description, State = s.State == "01" ? "可用" : "不可用" }); return(new { total, rows = sRM_Detail.ToArray() }); }
public object GetSRM(int page, int rows, string queryString, string value) { string id = "", srmName = ""; if (queryString == "id") { id = value; } else { srmName = value; } IQueryable <SRM> srmQuery = SRMRepository.GetQueryable(); //int Id = Convert.ToInt32(id); var srm = srmQuery.Where(s => s.SRMName.Contains(srmName) && s.State == "01") .OrderBy(s => s.ID).AsEnumerable(). Select(s => new { s.SRMName, s.OPCServiceName, s.GetRequest, s.GetAllow, s.GetComplete, s.PutRequest, s.PutAllow, s.PutComplete, s.Description, State = s.State == "01" ? "可用" : "不可用" }); int total = srm.Count(); srm = srm.Skip((page - 1) * rows).Take(rows); return(new { total, rows = srm.ToArray() }); }
public bool Delete(int srmId) { var srm = SRMRepository.GetQueryable().FirstOrDefault(s => s.ID == srmId); if (srm != null) { SRMRepository.Delete(srm); SRMRepository.SaveChanges(); } else { return(false); } return(true); }
public bool Save(SRM srm) { var sr = SRMRepository.GetQueryable().FirstOrDefault(s => s.ID == srm.ID); sr.SRMName = srm.SRMName; sr.Description = srm.Description; sr.OPCServiceName = srm.OPCServiceName; sr.GetRequest = srm.GetRequest; sr.GetAllow = srm.GetAllow; sr.GetComplete = srm.GetComplete; sr.PutRequest = srm.PutRequest; sr.PutAllow = srm.PutAllow; sr.PutComplete = srm.PutComplete; sr.State = srm.State; SRMRepository.SaveChanges(); return(true); }
public System.Data.DataTable GetSRM(int page, int rows, SRM srms) { IQueryable <SRM> sRMQuery = SRMRepository.GetQueryable(); var sRMDetail = sRMQuery.Where(s => s.SRMName.Contains(srms.SRMName) && s.OPCServiceName.Contains(srms.OPCServiceName) && s.GetRequest.Contains(srms.GetRequest) && s.GetAllow.Contains(srms.GetAllow) && s.GetComplete.Contains(srms.GetComplete) && s.PutRequest.Contains(srms.PutRequest) && s.PutAllow.Contains(srms.PutAllow) && s.PutComplete.Contains(srms.PutComplete) && s.State.Contains(srms.State)).OrderBy(ul => ul.SRMName); var sRM_Detail = sRMDetail.ToArray().Select(s => new { s.ID, s.SRMName, s.OPCServiceName, s.GetRequest, s.GetAllow, s.GetComplete, s.PutRequest, s.PutAllow, s.PutComplete, s.Description, State = s.State == "01" ? "可用" : "不可用" }); System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add("堆垛机编码", typeof(string)); dt.Columns.Add("堆垛机名称", typeof(string)); dt.Columns.Add("OPC服务名", typeof(string)); dt.Columns.Add("取货请求数据项名", typeof(string)); dt.Columns.Add("充许取货数据项名", typeof(string)); dt.Columns.Add("取货完成数据项名", typeof(string)); dt.Columns.Add("放货请求数据项名", typeof(string)); dt.Columns.Add("充许放货数据项名", typeof(string)); dt.Columns.Add("放货完成数据项名", typeof(string)); dt.Columns.Add("描述", typeof(string)); dt.Columns.Add("状态", typeof(string)); foreach (var s in sRM_Detail) { dt.Rows.Add ( s.ID, s.SRMName, s.OPCServiceName, s.GetRequest, s.GetAllow, s.GetComplete, s.PutRequest, s.PutAllow, s.PutComplete, s.Description, s.State ); } return(dt); }