WebAPI2 practicing.

這是一個Winform 呼叫 webapi進行基本查詢、維護的範例。

• 畫面圖示

• 程式架構
  • WebApiHelper - 介於winform與webapi間的溝通橋樑，winform呼叫helper的服務後，再由helper執行真正對應的WebApi內容並加以整合business rule後回傳給winform需要的資料型態與內容。
  • WebApiTest - WebApi，此範例主要僅用來處理CRUD
  • WindowsFormApp1 - Winform畫面

• 以Query查詢程式為例
• Winform的btnQuery_Click

 private void btnQuery_Click(object sender, EventArgs e)
{
var equalSearch = new LocalCuisine { DISTRICT = string.IsNullOrEmpty(cboDistrict.Text) == false? cboDistrict.Text : null };
var fuzzySearch = new LocalCuisine
{
NAME = string.IsNullOrEmpty(txtName.Text) == false? txtName.Text : null,
ADDRESS = string.IsNullOrEmpty(txtAddress.Text) == false? txtAddress.Text : null
};
List<LocalCuisine> datas = actionHelper.Query(equalSearch, fuzzySearch);dgvResult.Rows.Clear();
foreach (var data in datas)
{
dgvResult.Rows.Add(data.ID, data.ITEM, data.NAME, data.DISTRICT, data.PHONE, data.ADDRESS);
}
}

• Helper的Query()

public List<LocalCuisine> Query(LocalCuisine equalSearch, LocalCuisine fuzzySearch)
{
//WebApi query的寫法是equal判斷, 故除了District這種正規化欄位可equal search外, 其餘Name與Address這兩個模糊搜尋的欄位另外以lambda過濾
ExecuteResult getAllData = CommonUtil.CallService(equalSearch, "action", "query");
List<LocalCuisine> jObjs = new List<LocalCuisine>();
foreach (var d in getAllData.Data)
{
JObject jObj = d as JObject;jObjs.Add(jObj.ToObject<LocalCuisine>());
}
if (string.IsNullOrEmpty(fuzzySearch.NAME) == false)
{
jObjs = jObjs.FindAll(x => x.NAME.IndexOf(fuzzySearch.NAME) > -1);
}
if (string.IsNullOrEmpty(fuzzySearch.ADDRESS) == false)
{
jObjs = jObjs.FindAll(x => x.ADDRESS.IndexOf(fuzzySearch.ADDRESS) > -1);
}
return jObjs;
}

• WebApi

 [HttpPost]
[Route("query")]
public ExecuteResult QueryData([FromBody] JObject postData)
{
ExecuteResult executeResult = new ExecuteResult();
try
{
LocalCuisine criteria = postData.ToObject<LocalCuisine>();
//引用AppLibrary.dll中的Repository pattern, 抓取sqlite db
Repository<LocalCuisine> rep = new Repository<LocalCuisine>(CommonUtil.getConfig("DBName"));
executeResult.Data = rep.Select(criteria);
executeResult.IsSuccess = true;
}
catch (Exception e)
{
executeResult.Msg = e.Message;
executeResult.IsSuccess = false;
}
return executeResult;
}

• Winform操作功能簡介

Import

• 可選擇 WebApiHelper\Models\Taichung_LocalCuisine_formatter.json file後進行import, 程式會將json內容寫入sqlite資料庫(產生路徑：WebApiTest\testdb.sqlite)
• 程式先Delete all data後再進行batch insert

Query

• 依查詢條件回傳符合結果
• 用於撈出 "District" dropdownlist內容及 "Query" button的查詢結果

Update

• 除Item欄位外，其餘Cell click兩下可修改該欄位值, 按下 "Update" button後進行batch update

Export

• 可選擇匯出json or excel file
• 依gridview內容進行匯出