/// <summary>
/// 取得員工資料
/// </summary>
public JsonResult GetContactTitleList()
{
try
{
Service.CodeService codeService = new Service.CodeService();
JsonResult result = this.Json(codeService.GetTitle(), JsonRequestBehavior.AllowGet);
return(result);
}
catch (Exception)
{
return(this.Json(false));
}
}
/// <summary>
/// 取得職稱資料
/// </summary>
/// <returns></returns>
public List <SelectListItem> GetVal()
{
DataTable dt = new DataTable();
string sql = @"select CodeVal,CodeId from dbo.CodeTable where CodeType='TITLE'";
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
sqlAdapter.Fill(dt);
conn.Close();
}
Service.CodeService codeservice = new Service.CodeService();
return(codeservice.MapCustomerData(dt));
}
