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));
}
