public SearchListViewModel SearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IActorSettingService actorSettingService = new ActorSettingService();
#endregion
#region 流程
//檢查是否驗證通過
if (!_authState.IsAuth)
{
throw new Exception(_authState.AuthDescription);
}
// 參數驗證
VerifyParams(searchInfo);
try
{
//取得查詢結果
searchList = actorSettingService.QuerySearchList(searchInfo);
}
catch (Exception ex)
{
throw ex;
}
#endregion
return(searchList);
}
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
//組立SQL字串並連接資料庫
#region 參數告宣
SearchListViewModel result = new SearchListViewModel();
#endregion
#region 流程
StringBuilder _sqlStr = new StringBuilder();
_sqlStr.Append("SELECT * FROM Product p Where p.Status = 1");
_sqlParams = new Dapper.DynamicParameters();
if (!string.IsNullOrEmpty(searchInfo.Name))
{
_sqlStr.Append(" AND p.Name LIKE @Name ");
_sqlParams.Add("Name", "%" + searchInfo.Name + "%");
}
result.SearchItemList = new List <SearchItemViewModel>();
using (var cn = new SqlConnection(_dbConnPPP)) //連接資料庫
{
cn.Open();
result.SearchItemList = cn.Query <SearchItemViewModel>(_sqlStr.ToString(), _sqlParams).ToList();
}
return(result);
#endregion
}
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
//組立SQL字串並連接資料庫
#region 參數告宣
SearchListViewModel result = new SearchListViewModel();
#endregion
#region 流程
StringBuilder _sqlStr = new StringBuilder();
StringBuilder _sqlCountStr = new StringBuilder();
_sqlCountStr.Append("select count(*) from appraisal");
_sqlStr.Append("select * from appraisal ORDER BY " + (searchInfo.iSortCol_0 + 1).ToString() + " " + searchInfo.sSortDir_0 + " OFFSET @iDisplayStart ROWS FETCH NEXT @iDisplayLength ROWS ONLY");
_sqlParams = new Dapper.DynamicParameters();
_sqlParams.Add("iDisplayStart", searchInfo.iDisplayStart);
_sqlParams.Add("iDisplayLength", searchInfo.iDisplayLength);
result.data = new List <SearchItemViewModel>();
result.draw = (searchInfo.sEcho + 1);
using (var cn = new SqlConnection(_dbConnPPP)) //連接資料庫
{
cn.Open();
result.data = cn.Query <SearchItemViewModel>(_sqlStr.ToString(), _sqlParams).ToList();
result.recordsTotal = cn.Query <int>(_sqlCountStr.ToString()).First();
result.recordsFiltered = result.recordsTotal;
}
return(result);
#endregion
}
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
MaintainDao maintainDao = new MaintainDao();
#endregion
#region 流程
searchList = maintainDao.QuerySearchList(searchInfo); //將參數送入Dao層,組立SQL字串並連接資料庫
return(searchList);
#endregion
}
/// <summary>
/// 查詢列表
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IBrandPMRepository brandPMRp = new BrandPMRepository();
#endregion
#region 流程
searchList = brandPMRp.QuerySearchList(searchInfo);
return(searchList);
#endregion
}
/// <summary>
/// 查詢列表
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IActorRepository actorRp = new ActorRepository();
#endregion
#region 流程
searchList = actorRp.QuerySearchList(searchInfo);
return(searchList);
#endregion
}
/// <summary>
/// 查詢列表
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IProjectPriceSellRepository projectPriceSellRp = new ProjectPriceSellRepository();
#endregion
#region 流程
searchList = projectPriceSellRp.QuerySearchList(searchInfo);
return(searchList);
#endregion
}
/// <summary>
/// 查詢列表
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IBatchImportMaterialRepository batchImportMaterialRp = new BatchImportMaterialRepository();
#endregion
#region 流程
searchList = batchImportMaterialRp.QuerySearchList(searchInfo);
return(searchList);
#endregion
}
/// <summary>
/// 查詢列表
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IParameterCategoryRepository parameterCategoryRp = new ParameterCategoryRepository();
#endregion
#region 流程
searchList = parameterCategoryRp.QuerySearchList(searchInfo);
return(searchList);
#endregion
}
private bool QuerySearchListSql(SearchInfoViewModel searchInfo)
{
// 設定主SQL, _sqlStr 中不可以包含 ORDER BY
_sqlStr = new StringBuilder();
//_sqlStr.Append(" 主要SQL語法 ");
//設定排序SQL
_sqlOrderByStr = searchInfo.GetOrderByFromSort(SearchInfoViewModel.EnumSort.DEFAULT);
//設定參數
_sqlParams = new Dapper.DynamicParameters();
//_sqlParams.Add("參數", searchInfo.參數);
return(true);
}
/// <summary>
/// 查詢列表
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IMaterialVerifyFormRepository materialVerifyFormRp = new MaterialVerifyFormRepository();
#endregion
#region 流程
searchList = materialVerifyFormRp.QuerySearchList(searchInfo);
return(searchList);
#endregion
}
/// <summary>
/// 查詢列表
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IHandSetRepository handSetRp = new HandSetRepository();
#endregion
#region 流程
searchList = handSetRp.QuerySearchList(searchInfo);
return(searchList);
#endregion
}
private void VerifyParams(SearchInfoViewModel searchInfo)
{
#region 參數宣告
List <RequestValidateErrorViewModel> requestValidateErrorList = new List <RequestValidateErrorViewModel>();
#endregion
#region 流程
//處理欄位驗證
if (requestValidateErrorList.Count > 0)
{
throw new RequestValidateException(requestValidateErrorList);
}
#endregion
}
public IActionResult SearchInfo(string word, DateTime date)
{
SearchInfoModel searchInfoResult = _logger.GetSearchInfo(word, date);
SearchInfoViewModel searchInfo = new SearchInfoViewModel();
searchInfo.UserIp = searchInfoResult.UserIp;
searchInfo.RequestWord = searchInfoResult.RequestWord;
searchInfo.RequestDate = searchInfoResult.RequestDate;
foreach (string s in searchInfoResult.Anagrams)
{
searchInfo.Anagrams.Add(s);
}
return(View(searchInfo));
}
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel result = new SearchListViewModel();
#endregion
#region 流程
var sql = QuerySearchListSql(searchInfo);
result.Page = searchInfo.Page;
result.SearchItemList = new List <SearchItemViewModel>();
using (var cn = new SqlConnection(_dbConnPPP))
{
result.SearchItemList = cn.Query <SearchItemViewModel>(GetPagingSql(searchInfo.Page), _sqlParams).ToList();
result.Page.TotalCount = cn.Query <int>(GetTotalCountSql(), _sqlParams).ToList().FirstOrDefault();
}
return(result);
#endregion
}
public ViewModelLocator()
{
myNavigationService = new MyNavigationService();
appViewModel = new AppViewModel(myNavigationService);
logInViewModel = new LogInViewModel(myNavigationService);
menyuViewModel = new MenyuViewModel(myNavigationService);
tripsViewModel = new TripsViewModel(myNavigationService);
registrationViewModel = new RegistrationViewModel(myNavigationService);
weatherViewModel = new WeatherViewModel(myNavigationService);
ticketsPDFViewModel = new TicketsPDFViewModel(myNavigationService);
citiesViewModel = new CitiesViewModel(myNavigationService);
introViewModel = new IntroViewModel(myNavigationService);
mapViewModel = new MapViewModel(myNavigationService);
searchInfoViewModel = new SearchInfoViewModel(myNavigationService);
ticketsViewModel = new TicketsViewModel(myNavigationService);
myNavigationService.Register <LogInViewModel>(logInViewModel);
myNavigationService.Register <MenyuViewModel>(menyuViewModel);
myNavigationService.Register <TripsViewModel>(tripsViewModel);
myNavigationService.Register <RegistrationViewModel>(registrationViewModel);
myNavigationService.Register <WeatherViewModel>(weatherViewModel);
myNavigationService.Register <TicketsPDFViewModel>(ticketsPDFViewModel);
myNavigationService.Register <CitiesViewModel>(citiesViewModel);
myNavigationService.Register <IntroViewModel>(introViewModel);
myNavigationService.Register <MapViewModel>(mapViewModel);
myNavigationService.Register <SearchInfoViewModel>(searchInfoViewModel);
myNavigationService.Register <TicketsViewModel>(ticketsViewModel);
//myNavigationService.Register("LogIn", logInViewModel);
//myNavigationService.Register("Menyu", menyuViewModel);
//myNavigationService.Register("Trips", tripsViewModel);
//myNavigationService.Register("Registration", registrationViewModel);
//myNavigationService.Navigate<LogInViewModel>();
myNavigationService.Navigate <IntroViewModel>();
//myNavigationService.Navigate<TicketsPDFViewModel>();
//myNavigationService.Navigate<TripsViewModel>();
//myNavigationService.Navigate("LogIn");
}
public SearchListViewModel SearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IaaaService aaaService = new aaaService();
IAuthorityService authorityService = new AuthorityService();
#endregion
#region 流程
//檢查是否驗證通過
if (!_authState.IsAuth)
{
throw new Exception(_authState.AuthDescription);
}
// 參數驗證
VerifyParams(searchInfo);
try
{
//取得查詢結果
searchList = aaaService.QuerySearchList(searchInfo);
//檢查資料編輯權限
searchList.SearchItemList.ForEach(item => item.HasEditPermission = authorityService.HasDataPermission(_authState.UserID, item.DepartmentCD));
}
catch (Exception ex)
{
throw ex;
}
#endregion
return(searchList);
}
public ActionResult MaintainJson(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
MaintainService maintainService = new MaintainService();
#endregion
#region 流程
try
{
//送參數進入Service層做商業邏輯
searchList = maintainService.QuerySearchList(searchInfo);
}
catch (Exception ex)
{
searchList.db_Result = "Fail , " + ex.Message;
}
//組Json格式回傳Models資料
return(Json(searchList, JsonRequestBehavior.AllowGet));
#endregion
}
