public System.Data.DataTable GetContactUsQuestionList(Model.Query.ContactUsQuestionQuery query, out int totalCount)
{
try
{
DataTable _list = _contQuest.GetContactUsQuestionList(query, out totalCount);
if (_list.Rows.Count > 0)
{
_list.Columns.Add("question_status_name");
_list.Columns.Add("question_type_name");
_list.Columns.Add("question_problem_name");
_parameterDao = new Dao.ParametersrcDao(connStr);
List<Parametersrc> parameterList = _parameterDao.QueryParametersrcByTypes("Question_Status", "Question_Type", "problem_category");
foreach (DataRow dr in _list.Rows)
{
//求參數
var alist = parameterList.Find(m => m.ParameterType == "Question_Status" && m.ParameterCode == dr["question_status"].ToString());
var blist = parameterList.Find(m => m.ParameterType == "Question_Type" && m.ParameterCode == dr["question_type"].ToString());
var clist = parameterList.Find(m => m.ParameterType == "problem_category" && m.ParameterCode == dr["question_problem"].ToString());
if (alist != null)
{
dr["question_status_name"] = alist.parameterName;
}
if (blist != null)
{
dr["question_type_name"] = blist.parameterName;
}
if (clist != null)
{
dr["question_problem_name"] = clist.parameterName;
}
//加密機敏資料
if (query.isSecret)
{
if (!string.IsNullOrEmpty(dr["question_username"].ToString()))
{
dr["question_username"] = dr["question_username"].ToString().Substring(0, 1) + "**";
}
dr["question_email"] = dr["question_email"].ToString().Split('@')[0] + "@***";
if (dr["question_phone"].ToString().Length > 3)
{
dr["question_phone"] = dr["question_phone"].ToString().Substring(0, 3) + "***";
}
else
{
dr["question_phone"] = dr["question_phone"].ToString() + "***";
}
}
}
}
return _list;
}
catch (Exception ex)
{
throw new Exception("ContactUsQuestionMgr-->GetContactUsQuestionList-->" + ex.Message, ex);
}
}
public System.Data.DataTable GetContactUsQuestionExcelList(Model.Query.ContactUsQuestionQuery query)
{
try
{
DataTable _list = _contQuest.GetContactUsQuestionExcelList(query);
if (_list.Rows.Count > 0)
{
_list.Columns.Add("question_status_name");
_list.Columns.Add("question_type_name");
_list.Columns.Add("question_problem_name");
_parameterDao = new Dao.ParametersrcDao(connStr);
List<Parametersrc> parameterList = _parameterDao.QueryParametersrcByTypes("Question_Status", "Question_Type", "problem_category");
foreach (DataRow dr in _list.Rows)
{
//求參數
var alist = parameterList.Find(m => m.ParameterType == "Question_Status" && m.ParameterCode == dr["question_status"].ToString());
var blist = parameterList.Find(m => m.ParameterType == "Question_Type" && m.ParameterCode == dr["question_type"].ToString());
var clist = parameterList.Find(m => m.ParameterType == "problem_category" && m.ParameterCode == dr["question_problem"].ToString());
if (alist != null)
{
dr["question_status_name"] = alist.parameterName;
}
if (blist != null)
{
dr["question_type_name"] = blist.parameterName;
}
if (clist != null)
{
dr["question_problem_name"] = clist.parameterName;
}
}
}
return _list;
}
catch (Exception ex)
{
throw new Exception("ContactUsQuestionMgr-->GetContactUsQuestionExcelList-->" + ex.Message, ex);
}
}
