public ActionResult Nhi_Med(Nhi_Med_Filter filter, Rest.Core.Paging Page) { var PermissionCheck = CheckPermission("健保專區管理"); if (PermissionCheck != null) { return(PermissionCheck); } if (!string.IsNullOrEmpty(filter.CodeOld) && filter.CodeOld.StartsWith("請輸入")) { filter.CodeOld = null; } ViewData["Filter"] = filter; Rest.Core.Paging page = new Rest.Core.Paging() { }; if (Page.CurrentPage > 0) { page.CurrentPage = Page.CurrentPage; } List <Nhi_Med_Info> data = MedMan.GetByParameter(filter, page, null, "PublishDate desc"); ViewData["Model"] = data; ViewData["Page"] = page; return(View()); }
public List <Nhi_Med_Info> GetByParam(Nhi_Med_Filter Filter, Paging Page, string[] fieldNames, string _orderby) { if (fieldNames == null) { fieldNames = new string[] { "*" }; } if (Page == null) { Page = new Paging(); } using (var db = new DBExecutor().GetDatabase()) { var SQLStr = ConstructSQL(Filter, fieldNames, _orderby); var result = db.Page <Nhi_Med_Info>(Page.CurrentPage, Page.ItemsPerPage, SQLStr); Page.Convert <Nhi_Med_Info>(result); return(result.Items); } }
public List <Nhi_Med_Info> GetByParam(Nhi_Med_Filter Filter, string[] fieldNames, string _orderby, Paging Page) { return(GetByParam(Filter, Page, fieldNames, _orderby)); }
public List <Nhi_Med_Info> GetByParam(Nhi_Med_Filter Filter, string _orderby, Paging Page) { return(GetByParam(Filter, Page, null, _orderby)); }
public List <Nhi_Med_Info> GetByParam(Nhi_Med_Filter Filter, Paging Page) { return(GetByParam(Filter, Page, null, "")); }
public List <Nhi_Med_Info> GetByParam(Nhi_Med_Filter Filter) { return(GetByParam(Filter, null, null, "")); }
private Rest.Core.PetaPoco.Sql ConstructSQL(Nhi_Med_Filter filter, string[] fieldNames, string _orderby) { var SQLStr = Rest.Core.PetaPoco.Sql.Builder .Append("SELECT " + FieldNameArrayToFieldNameString(fieldNames) + " FROM db_Nhi_Med") .Append("WHERE 1=1 "); if (filter != null) { if (filter.MedicationID.HasValue) { SQLStr.Append(" AND MedicationID=@0", filter.MedicationID.Value); } if (filter.SortNum.HasValue) { SQLStr.Append(" AND SortNum=@0", filter.SortNum.Value); } if (filter.PublishDate.HasValue) { SQLStr.Append(" AND PublishDate=@0", filter.PublishDate.Value); } if (!string.IsNullOrEmpty(filter.CodeOld)) { SQLStr.Append(" AND (CodeOld like @0 or PNameOld like @0)", "%" + filter.CodeOld + "%"); } if (!string.IsNullOrEmpty(filter.PCodeOld)) { SQLStr.Append(" AND PCodeOld=@0", filter.PCodeOld); } if (!string.IsNullOrEmpty(filter.PNameEngOld)) { SQLStr.Append(" AND PNameEngOld=@0", filter.PNameEngOld); } if (!string.IsNullOrEmpty(filter.PNameOld)) { SQLStr.Append(" AND PNameOld=@0", filter.PNameOld); } if (!string.IsNullOrEmpty(filter.PNameAndNumOld)) { SQLStr.Append(" AND PNameAndNumOld=@0", filter.PNameAndNumOld); } if (!string.IsNullOrEmpty(filter.ScientificNameOld)) { SQLStr.Append(" AND ScientificNameOld=@0", filter.ScientificNameOld); } if (!string.IsNullOrEmpty(filter.CompanyNameOld)) { SQLStr.Append(" AND CompanyNameOld=@0", filter.CompanyNameOld); } if (!string.IsNullOrEmpty(filter.ImageOld)) { SQLStr.Append(" AND ImageOld=@0", filter.ImageOld); } if (!string.IsNullOrEmpty(filter.SuitOld)) { SQLStr.Append(" AND SuitOld=@0", filter.SuitOld); } if (!string.IsNullOrEmpty(filter.UsageOld)) { SQLStr.Append(" AND UsageOld=@0", filter.UsageOld); } if (!string.IsNullOrEmpty(filter.SideEffectOld)) { SQLStr.Append(" AND SideEffectOld=@0", filter.SideEffectOld); } if (!string.IsNullOrEmpty(filter.NotificationOld)) { SQLStr.Append(" AND NotificationOld=@0", filter.NotificationOld); } if (!string.IsNullOrEmpty(filter.ModifiedContent)) { SQLStr.Append(" AND ModifiedContent=@0", filter.ModifiedContent); } if (filter.HitOld.HasValue) { SQLStr.Append(" AND HitOld=@0", filter.HitOld.Value); } if (!string.IsNullOrEmpty(filter.Code)) { SQLStr.Append(" AND Code=@0", filter.Code); } if (!string.IsNullOrEmpty(filter.PCode)) { SQLStr.Append(" AND PCode=@0", filter.PCode); } if (!string.IsNullOrEmpty(filter.PNameEng)) { SQLStr.Append(" AND PNameEng=@0", filter.PNameEng); } if (!string.IsNullOrEmpty(filter.ScientificName)) { SQLStr.Append(" AND ScientificName=@0", filter.ScientificName); } if (!string.IsNullOrEmpty(filter.PName)) { SQLStr.Append(" AND PName=@0", filter.PName); } if (!string.IsNullOrEmpty(filter.PNameAndNum)) { SQLStr.Append(" AND PNameAndNum=@0", filter.PNameAndNum); } if (!string.IsNullOrEmpty(filter.CompanyName)) { SQLStr.Append(" AND CompanyName=@0", filter.CompanyName); } if (!string.IsNullOrEmpty(filter.Image)) { SQLStr.Append(" AND Image=@0", filter.Image); } if (!string.IsNullOrEmpty(filter.Suit)) { SQLStr.Append(" AND Suit=@0", filter.Suit); } if (!string.IsNullOrEmpty(filter.Usage)) { SQLStr.Append(" AND Usage=@0", filter.Usage); } if (!string.IsNullOrEmpty(filter.SideEffect)) { SQLStr.Append(" AND SideEffect=@0", filter.SideEffect); } if (!string.IsNullOrEmpty(filter.Notification)) { SQLStr.Append(" AND Notification=@0", filter.Notification); } if (filter.LastUpdate.HasValue) { SQLStr.Append(" AND LastUpdate=@0", filter.LastUpdate.Value); } if (!string.IsNullOrEmpty(filter.LastUpdator)) { SQLStr.Append(" AND LastUpdator=@0", filter.LastUpdator); } if (_orderby != "") { SQLStr.OrderBy(_orderby); } } return(SQLStr); }
private Rest.Core.PetaPoco.Sql ConstructSQL(Nhi_Med_Filter filter) { return(ConstructSQL(filter, new string[] { "*" }, "")); }
public List <Nhi_Med_Info> GetByParameter(Nhi_Med_Filter Filter, string[] fieldNames, string _orderby, Rest.Core.Paging Page) { return(new Nhi_Med_Repo().GetByParam(Filter, fieldNames, _orderby, Page)); }
public List <Nhi_Med_Info> GetByParameter(Nhi_Med_Filter Filter, string _orderby) { return(new Nhi_Med_Repo().GetByParam(Filter, _orderby)); }
public List <Nhi_Med_Info> GetByParameter(Nhi_Med_Filter Filter, Rest.Core.Paging Page) { return(new Nhi_Med_Repo().GetByParam(Filter, Page)); }
public List <Nhi_Med_Info> GetByParameter(Nhi_Med_Filter Filter) { return(new Nhi_Med_Repo().GetByParam(Filter)); }