public ActionResult ListGroupBySearch(int ProjectID) { object objResult = null; try { using (LedDb db = new LedDb()) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"select o.Id ID, o.GroupName Name from GroupInfo o where (o.IsDel!=1 or o.IsDel is null) and o.OrgId='{0}'", ProjectID); List <ModelForIDAndName> list = db.Database.SqlQuery <ModelForIDAndName>(strSql.ToString()).ToList(); objResult = list; } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult List(string Method, string Key) { object objResult = null; try { using (LedDb db = new LedDb()) { List <ModelForProject> list = new List <ModelForProject>(); if (Method == "FirstLoad") { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select p.*, o.Name OrgName, g.GroupName GroupName from ProjectInfo p left join GroupInfo g on g.Id=p.GroupId left join OrgInfo o on o.Id=p.OrgId where p.IsDel!=1"); list = db.Database.SqlQuery <ModelForProject>(strSql.ToString()).ToList(); } else if (Method == "SearchLoad") { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"select p.*, o.Name OrgName, g.GroupName GroupName from ProjectInfo p left join GroupInfo g on g.Id=p.GroupId left join OrgInfo o on o.Id=p.OrgId where p.IsDel!=1 and p.ProjectName like '%{0}%'", Key); list = db.Database.SqlQuery <ModelForProject>(strSql.ToString()).ToList(); } int page = string.IsNullOrWhiteSpace(Request["page"]) ? 1 : Int32.Parse(Request["page"]); int rows = string.IsNullOrWhiteSpace(Request["rows"]) ? 1 : Int32.Parse(Request["rows"]); string order = string.IsNullOrWhiteSpace(Request["order"]) ? "DESC" : Request["order"].ToUpper(); string sort = string.IsNullOrWhiteSpace(Request["sort"]) ? "Id" : Request["sort"]; IQueryable <ProjectInfo> query = CommonTools.DataSorting <ProjectInfo>(list.AsQueryable(), sort, order).Skip((page - 1) * rows).Take(rows); objResult = new { total = list.Count, rows = query }; } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; //throw; } return(Json(objResult)); }
public ActionResult ListOrg() { object objResult = null; try { using (LedDb db = new LedDb()) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select o.Id ID, o.Name Name from OrgInfo o where o.IsDel!=1"); List <ModelForIDAndName> list = db.Database.SqlQuery <ModelForIDAndName>(strSql.ToString()).ToList(); objResult = list; } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult List(string Method, string Key) { object objResult = null; try { using (LedDb db = new LedDb()) { List <ModelForOrgUser> list = new List <ModelForOrgUser>(); if (Method == "FirstLoad") { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select g.*, g.Name MgrOrgName from OrgUser g where g.IsDel!=1 or g.IsDel is null"); list = db.Database.SqlQuery <ModelForOrgUser>(strSql.ToString()).ToList(); } else if (Method == "SearchLoad") { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"select g.*, g.Name MgrOrgName from OrgUser g where (g.IsDel!=1 or g.IsDel is null) and g.name like '%{0}%'", Key); list = db.Database.SqlQuery <ModelForOrgUser>(strSql.ToString()).ToList(); } int page = string.IsNullOrWhiteSpace(Request["page"]) ? 1 : Int32.Parse(Request["page"]); int rows = string.IsNullOrWhiteSpace(Request["rows"]) ? 1 : Int32.Parse(Request["rows"]); string order = string.IsNullOrWhiteSpace(Request["order"]) ? "DESC" : Request["order"].ToUpper(); string sort = string.IsNullOrWhiteSpace(Request["sort"]) ? "Id" : Request["sort"]; IQueryable <ModelForOrgUser> query = CommonTools.DataSorting <ModelForOrgUser>(list.AsQueryable(), sort, order).Skip((page - 1) * rows).Take(rows); objResult = new { total = list.Count, rows = query }; } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; //throw; } return(Json(objResult)); }
/// <summary> /// Save配置 /// </summary> /// <param name="id"></param> /// <param name="IsDouble"></param> /// <param name="ScreenCount"></param> /// <param name="CardModel"></param> /// <param name="CardPointCount"></param> public void SaveDev(int id, int IsDouble, int ScreenCount, string CardModel, int CardPointCount) { using (LedDb db = new LedDb()) { GasCardWithCommInfo aDev = db.GasCardWithCommInfo.Where(p => p.Id == id && p.IsDel != 1).FirstOrDefault(); if (aDev != null) { aDev.CardIsDouble = IsDouble; aDev.CardScreenCount = ScreenCount; aDev.CardModel = CardModel; aDev.CardPointCount = CardPointCount; db.SaveChanges(); } } }
public ActionResult GetGasCardInfo(int id) { object objResult = null; if (!string.IsNullOrWhiteSpace(id.ToString())) { using (LedDb db = new LedDb()) { GasCardWithCommInfo aGasCardInfo = db.GasCardWithCommInfo.Where(p => p.Id == id && p.IsDel != 1).FirstOrDefault(); if (aGasCardInfo != null) { objResult = new ResultHelper() { Desc = " Station Information Get Success", Msg = " Station Information Get Success", Obj = aGasCardInfo, Ret = 1, Status = true }; } else { objResult = new ResultHelper() { Status = false, Ret = -1, Obj = null, Msg = "No such record exists", Desc = "No such record exists" }; } } } else { objResult = new ResultHelper() { Status = false, Ret = -1, Obj = null, Msg = "id is null,Please try again later", Desc = "id is null,Please try again later" }; } return(Json(objResult)); }
public bool SendCMD(int id, string value) { bool bSend = false; if (!string.IsNullOrWhiteSpace(id.ToString())) { using (LedDb db = new LedDb()) { string strError = string.Empty; GlareSysEfDbAndModels.CmdLogs aLog = new GlareSysEfDbAndModels.CmdLogs() { CardInfoId = id, CmdInfo = value, CmdType = GlareLedSysDefPub.CmdDefSetOilValue, CommDevId = id, CreateTime = DateTime.Now, IsDetele = 0, Result = 0, ResultInfo = "", UpdateTime = DateTime.Now }; bSend = CmdLogsBll.AddCommDevInfo(ref aLog, out strError); bSend = InsertCmdToMemcached(aLog.Id); if (bSend) { for (int i = 1; i < 10; i++) { Thread.Sleep(1000); if (RemoveCmdHandledInMemcached(aLog.Id)) { bSend = true; break; } } } } } else { bSend = false; } return(bSend); }
public ActionResult List(string Method, string Key) { object objResult = null; try { using (LedDb db = new LedDb()) { List <SuperUser> list = new List <SuperUser>(); if (Method == "FirstLoad") { list = db.SuperUser.Where(p => p.IsDel != 1 || p.IsDel == null).ToList(); } else if (Method == "SearchLoad") { list = db.SuperUser.Where(p => p.Name.Contains(Key) && p.IsDel != 1).ToList(); } int page = string.IsNullOrWhiteSpace(Request["page"]) ? 1 : Int32.Parse(Request["page"]); int rows = string.IsNullOrWhiteSpace(Request["rows"]) ? 1 : Int32.Parse(Request["rows"]); string order = string.IsNullOrWhiteSpace(Request["order"]) ? "DESC" : Request["order"].ToUpper(); string sort = string.IsNullOrWhiteSpace(Request["sort"]) ? "Id" : Request["sort"]; IQueryable <SuperUser> query = CommonTools.DataSorting <SuperUser>(list.AsQueryable(), sort, order).Skip((page - 1) * rows).Take(rows); objResult = new { total = list.Count, rows = query }; } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; //throw; } return(Json(objResult)); }
public ActionResult Modify(GroupUser subject) { ResultHelper objResult = null; try { using (LedDb db = new LedDb()) { if (ModelState.IsValid) { GroupUser aSubject = db.GroupUser.Where(p => p.Id == subject.Id).FirstOrDefault(); //aSubject.CardName = subject.CardName; //aSubject.CardModel = subject.CardModel; //aSubject.ScreenCount = subject.ScreenCount; //aSubject.ScreenNams = subject.ScreenNams; aSubject = subject; aSubject.UpdateDt = DateTime.Now; if (db.SaveChanges() > 0) { objResult = new ResultHelper() { Status = true, Ret = 0, Obj = subject, Msg = "Edit Success!", Desc = "Edit Success!" }; } else { objResult = new ResultHelper() { Desc = "Edit Faile,please try again.", Msg = "Edit Faile,please try again.", Obj = null, Ret = -1, Status = false }; } } else { objResult = new ResultHelper() { Desc = " Faile,please try again", Msg = " Faile,please try again", Obj = null, Ret = -1, Status = false }; } } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult SendCMD(int id, string value) { object objResult = null; if (!string.IsNullOrWhiteSpace(id.ToString())) { using (LedDb db = new LedDb()) { string strError = string.Empty; GlareSysEfDbAndModels.CmdLogs aLog = new GlareSysEfDbAndModels.CmdLogs() { CardInfoId = id, CmdInfo = value, CmdType = GlareLedSysDefPub.CmdDefSetOilValue, CommDevId = id, CreateTime = DateTime.Now, IsDetele = 0, Result = 0, ResultInfo = "", UpdateTime = DateTime.Now }; bool bSend = CmdLogsBll.AddCommDevInfo(ref aLog, out strError); bSend = InsertCmdToMemcached(aLog.Id); bool bRecived = false; if (bSend) { for (int i = 1; i < 10; i++) { Thread.Sleep(1000); if (RemoveCmdHandledInMemcached(aLog.Id)) { bRecived = true; break; } } } if (bRecived) { objResult = new ResultHelper() { Desc = "Command issued Success", Msg = "Command issued Success", Obj = aLog, Ret = 1, Status = true }; } else { objResult = new ResultHelper() { Status = false, Ret = -1, Obj = null, Msg = strError, Desc = strError }; } } } else { objResult = new ResultHelper() { Status = false, Ret = -1, Obj = null, Msg = "id is null,Please try again later", Desc = "id is null,Please try again later" }; } return(Json(objResult)); }
public ActionResult Delete(string ProjectIds) { ResultHelper objResult = null; try { using (LedDb db = new LedDb()) { if (ModelState.IsValid) { string[] Id = ProjectIds.Split(','); string strMsg = string.Empty; for (int i = 0; i < Id.Length; i++) { ProjectBll.DeleteAProject(int.Parse(Id[i]), out strMsg); } objResult = new ResultHelper() { Status = true, Ret = 0, Obj = ProjectIds, Msg = strMsg, Desc = strMsg }; //StringBuilder strSql = new StringBuilder(); //strSql.AppendFormat(@"UPDATE ProjectInfo SET IsDel = 1 WHERE Id IN ({0})", ProjectIds); //if (db.Database.ExecuteSqlCommand(strSql.ToString()) > 0) //{ // objResult = new ResultHelper() // { // Status = true, // Ret = 0, // Obj = ProjectIds, // Msg = "Delete Success!", // Desc = "Delete Success!" // }; //} //else //{ // objResult = new ResultHelper() // { // Desc = "Delete Faile,please try again.", // Msg = "Delete Faile,please try again.", // Obj = null, // Ret = -1, // Status = false // }; //} } else { objResult = new ResultHelper() { Desc = " Faile,please try again", Msg = " Faile,please try again", Obj = null, Ret = -1, Status = false }; } } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult Modify(GlareSysEfDbAndModels.ProjectInfo subject) { ResultHelper objResult = null; try { using (LedDb db = new LedDb()) { if (ModelState.IsValid) { ProjectInfo aSubject = db.ProjectInfo.Where(p => p.Id == subject.Id).FirstOrDefault(); aSubject.ProjectName = subject.ProjectName; aSubject.ManagerName = subject.ManagerName; aSubject.Address = subject.Address; aSubject.ManagerTel = subject.ManagerTel; aSubject.OrgId = subject.OrgId; aSubject.GroupId = subject.GroupId; aSubject.UpdateDt = DateTime.Now; string strMsg = string.Empty; bool b = ProjectBll.UpdateProejct(ref subject, out strMsg); if (b) { objResult = new ResultHelper() { Status = true, Ret = 0, Obj = subject, Msg = strMsg, Desc = strMsg }; } else { objResult = new ResultHelper() { Desc = strMsg, Msg = strMsg, Obj = null, Ret = -1, Status = false }; } //if (db.SaveChanges() > 0) //{ // objResult = new ResultHelper() // { // Status = true, // Ret = 0, // Obj = subject, // Msg = "Edit Success!", // Desc = "Edit Success!" // }; //} //else //{ // objResult = new ResultHelper() // { // Desc = "Edit Faile,please try again.", // Msg = "Edit Faile,please try again.", // Obj = null, // Ret = -1, // Status = false // }; //} } else { objResult = new ResultHelper() { Desc = " Faile,please try again", Msg = " Faile,please try again", Obj = null, Ret = -1, Status = false }; } } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult Add(GlareSysEfDbAndModels.ProjectInfo subject) { ResultHelper objResult = null; try { using (LedDb db = new LedDb()) { if (ModelState.IsValid) { subject.UpdateDt = DateTime.Now; subject.CreateDt = DateTime.Now; subject.IsDel = 0; subject.UpdateDt = DateTime.Now; subject.CreateDt = DateTime.Now; subject.IsDel = 0; string strMsg = string.Empty; bool b = ProjectBll.AddAProject(ref subject, out strMsg); if (b) { objResult = new ResultHelper() { Status = true, Ret = 0, Obj = subject, Msg = strMsg, Desc = strMsg }; } else { objResult = new ResultHelper() { Desc = strMsg, Msg = strMsg, Obj = null, Ret = -1, Status = false }; } //db.ProjectInfo.Add(subject); //if (db.SaveChanges() > 0) //{ // objResult = new ResultHelper() // { // Status = true, // Ret = 0, // Obj = subject, // Msg = "Add Success!", // Desc = "Add Success!" // }; //} //else //{ // objResult = new ResultHelper() // { // Desc = "Add Faile,please try again.", // Msg = "Add Faile,please try again.", // Obj = null, // Ret = -1, // Status = false // }; //} } else { objResult = new ResultHelper() { Desc = " Faile,please try again", Msg = " Faile,please try again", Obj = null, Ret = -1, Status = false }; } } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult Setcfg(int id, int IsDouble, int ScreenCount, string CardModel, int CardPointCount) { object objResult = null; if (!string.IsNullOrWhiteSpace(id.ToString())) { using (LedDb db = new LedDb()) { string strError = string.Empty; //1 //双面显示(单面为0x00) isdouble //3 //一面三个牌 screencount //5 //每个牌5个8(包含小8) 价格数字的数量(CardModel,例如:GL-88888,那就填写5,GL-88888-8(上标小字),填写6 //0 //是否显示9/10(如果是GL-888-8-910,则为1,否则为0) //8 //亮度等级,永远写8 string CmdInfo = ""; if (IsDouble == 1)//双面显示 { CmdInfo = "1"; } else { CmdInfo = "0x00"; } CmdInfo = CmdInfo + "-" + ScreenCount.ToString();//screencount string strEightModel = CardModel.Replace("GL", "").Replace("-", ""); int iEightCount = strEightModel.Length; CmdInfo = CmdInfo + "-" + iEightCount.ToString(); //每个牌5个8(包含小8) if (CardModel.Contains("910")) //是否显示9/10 { CmdInfo = CmdInfo + "-1"; } else { CmdInfo = CmdInfo + "-0"; } CmdInfo = CmdInfo + "-8";//亮度 GlareSysEfDbAndModels.CmdLogs cmd = new GlareSysEfDbAndModels.CmdLogs() { CardInfoId = id, CmdInfo = CmdInfo, CmdType = GlareLedSysDefPub.CmdDefSetOilCfg, CommDevId = id, CreateTime = DateTime.Now, Id = 0, IsDetele = 0, Result = 0, ResultInfo = "", UpdateTime = DateTime.Now }; CmdLogsBll.AddCommDevInfo(ref cmd, out strError); bool bSend = InsertCmdToMemcached(cmd.Id); bool bRecived = false; if (bSend) { for (int i = 1; i < 10; i++) { Thread.Sleep(1000); if (RemoveCmdHandledInMemcached(cmd.Id)) { bRecived = true; break; } } } if (bRecived) { bool bSetPoint = SetPoint(id, IsDouble, ScreenCount, CardModel, CardPointCount); if (bSetPoint) { objResult = new ResultHelper() { Desc = "Command issued Success", Msg = "Command issued Success", Obj = cmd, Ret = 1, Status = true }; } else { objResult = new ResultHelper() { Desc = "Setcfg Success,Command issued Faile,please try again", Msg = "Setcfg Success,Command issued Faile,please try again", Obj = cmd, Ret = -1, Status = false }; } } else { objResult = new ResultHelper() { Status = false, Ret = -1, Obj = null, Msg = strError, Desc = strError }; } } } else { objResult = new ResultHelper() { Status = false, Ret = -1, Obj = null, Msg = "id is null,Please try again later", Desc = "id is null,Please try again later" }; } return(Json(objResult)); }
public ActionResult Save(GasCardWithCommInfo subject) { ResultHelper objResult = null; try { using (LedDb db = new LedDb()) { if (ModelState.IsValid) { GasCardWithCommInfo aSubject = db.GasCardWithCommInfo.Where(p => p.Id == subject.Id).FirstOrDefault(); aSubject.Name = subject.Name; aSubject.CommServerSn = subject.CommServerSn; aSubject.CardModel = subject.CardModel; aSubject.CardPointCount = subject.CardPointCount; aSubject.CardIsDouble = subject.CardIsDouble; aSubject.CardScreenCount = subject.CardScreenCount; aSubject.CardContext = subject.CardContext; aSubject.UpdateDt = DateTime.Now; if (db.SaveChanges() > 0) { objResult = new ResultHelper() { Status = true, Ret = 0, Obj = subject, Msg = "Edit Success!", Desc = "Edit Success!" }; } else { objResult = new ResultHelper() { Desc = "Edit Faile,please try again.", Msg = "Edit Faile,please try again.", Obj = null, Ret = -1, Status = false }; } } else { objResult = new ResultHelper() { Desc = " Faile,please try again", Msg = " Faile,please try again", Obj = null, Ret = -1, Status = false }; } } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult Delete(string SubjectIDs) { ResultHelper objResult = null; try { using (LedDb db = new LedDb()) { if (ModelState.IsValid) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"UPDATE GroupUser SET IsDel = 1 WHERE Id IN ({0})", SubjectIDs); if (db.Database.ExecuteSqlCommand(strSql.ToString()) > 0) { objResult = new ResultHelper() { Status = true, Ret = 0, Obj = SubjectIDs, Msg = "Delete Success!", Desc = "Delete Success!" }; } else { objResult = new ResultHelper() { Desc = "Delete Faile,please try again.", Msg = "Delete Faile,please try again.", Obj = null, Ret = -1, Status = false }; } } else { objResult = new ResultHelper() { Desc = " Faile,please try again", Msg = " Faile,please try again", Obj = null, Ret = -1, Status = false }; } } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult SaveBatchOilPrice(string Price1, string Price2, string Price3, string Price4, string Price5, string Price6, string Price7, string Price8, string Price9, string Price10, string Price11, string Price12, string BatchIds) { ResultHelper objResult = null; try { string Context = Price1 + "-" + Price2 + "-" + Price3 + "-" + Price4 + "-" + Price5 + "-" + Price6 + "-" + Price7 + "-" + Price8 + "-" + Price9 + "-" + Price10 + "-" + Price11 + "-" + Price12; using (LedDb db = new LedDb()) { if (ModelState.IsValid) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"UPDATE GasCardWithCommInfo SET CardContext = {0} WHERE Id IN ({1})", Context, BatchIds); if (db.Database.ExecuteSqlCommand(strSql.ToString()) > 0) { objResult = new ResultHelper() { Status = true, Ret = 0, Obj = BatchIds, Msg = "Batch Upadate Success!", Desc = "Batch Upadate Success!" }; string[] id = BatchIds.Split(','); for (int i = 0; i < id.Length; i++) { int iID = DataFormat.ConvertDBNullToInt32(id[i]); SendCMD(iID, Context); } } else { objResult = new ResultHelper() { Desc = "Batch Upadate Faile,please try again.", Msg = "Batch Upadate Faile,please try again.", Obj = null, Ret = -1, Status = false }; } } else { objResult = new ResultHelper() { Desc = " Faile,please try again", Msg = " Faile,please try again", Obj = null, Ret = -1, Status = false }; } } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult Add(GroupUser subject) { ResultHelper objResult = null; try { using (LedDb db = new LedDb()) { if (ModelState.IsValid) { subject.UpdateDt = DateTime.Now; subject.CreateDt = DateTime.Now; subject.IsDel = 0; db.GroupUser.Add(subject); if (db.SaveChanges() > 0) { objResult = new ResultHelper() { Status = true, Ret = 0, Obj = subject, Msg = "Add Success!", Desc = "Add Success!" }; } else { objResult = new ResultHelper() { Desc = "Add Faile,please try again.", Msg = "Add Faile,please try again.", Obj = null, Ret = -1, Status = false }; } } else { objResult = new ResultHelper() { Desc = " Faile,please try again", Msg = " Faile,please try again", Obj = null, Ret = -1, Status = false }; } } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; } return(Json(objResult)); }
public ActionResult List(string Method, string Key, string NodeId) { object objResult = null; try { List <ModelForGasCardWithCommInfo> list = new List <ModelForGasCardWithCommInfo>(); if (string.IsNullOrWhiteSpace(NodeId)) { list = DataLoader.GetAllGasCardWithCommInfoList(); int page = string.IsNullOrWhiteSpace(Request["page"]) ? 1 : Int32.Parse(Request["page"]); int rows = string.IsNullOrWhiteSpace(Request["rows"]) ? 1 : Int32.Parse(Request["rows"]); string order = string.IsNullOrWhiteSpace(Request["order"]) ? "DESC" : Request["order"].ToUpper(); string sort = string.IsNullOrWhiteSpace(Request["sort"]) ? "Id" : Request["sort"]; IQueryable <GasCardWithCommInfo> query = CommonTools.DataSorting <GasCardWithCommInfo>(list.AsQueryable(), sort, order).Skip((page - 1) * rows).Take(rows); objResult = new { total = list.Count, rows = query }; } else { string[] strNodeIdSplit = NodeId.Split('_'); string strType = strNodeIdSplit[0]; string strId = strNodeIdSplit[1]; int iId = DataFormat.ConvertDBNullToInt32(strId); using (LedDb db = new LedDb()) { if (Method == "FirstLoad") { if (string.IsNullOrWhiteSpace(NodeId)) { list = DataLoader.GetAllGasCardWithCommInfoList(); } else { if (strType == "org") { list = DataLoader.GetGasCardWithCommInfoByOrgId(strId); } else if (strType == "group") { list = DataLoader.GetGasCardWithCommInfoByGorupID(strId); } else if (strType == "project") { list = DataLoader.GetGasCardWithCommInfoByProjectID(strId); } } } else if (Method == "SearchLoad") { //list = db.GasCardWithCommInfo.Where(p => p.Name.Contains(Key) && p.IsDel != 1).ToList(); } int page = string.IsNullOrWhiteSpace(Request["page"]) ? 1 : Int32.Parse(Request["page"]); int rows = string.IsNullOrWhiteSpace(Request["rows"]) ? 1 : Int32.Parse(Request["rows"]); string order = string.IsNullOrWhiteSpace(Request["order"]) ? "DESC" : Request["order"].ToUpper(); string sort = string.IsNullOrWhiteSpace(Request["sort"]) ? "Id" : Request["sort"]; IQueryable <GasCardWithCommInfo> query = CommonTools.DataSorting <GasCardWithCommInfo>(list.AsQueryable(), sort, order).Skip((page - 1) * rows).Take(rows); objResult = new { total = list.Count, rows = query }; } } } catch (Exception ex) { objResult = new ResultHelper() { Desc = ex.Message, Msg = ex.Message, Obj = null, Ret = -1, Status = false }; //throw; } return(Json(objResult)); }