private void ddlRemedy_AbnormalReasonID_Data()
{
var isSuccess = false;
var msg = "";
var datas = new List <AT_CodeMap_Bean>();
var viewData = new AT_CodeMap_Model()
{
TabName = "Punch",
FldName = "PunchSeason"
};
ddlRemedy_AbnormalReasonID.Items.Clear();
isSuccess = PunchUpdate.Select_AT_CodeMap(viewData, out datas, out msg);
if (isSuccess && datas != null && datas.Count > 0)
{
viewData.SelectDDLDataList = PunchUpdate.GridDataFormat(datas); //Format Data
}
try
{
ddlRemedy_AbnormalReasonID.DataSource = viewData.SelectDDLDataList;
ddlRemedy_AbnormalReasonID.DataTextField = "CodeCName";
ddlRemedy_AbnormalReasonID.DataValueField = "Code";
ddlRemedy_AbnormalReasonID.DataBind();
}
catch (Exception)
{
Util.MsgBox("非公務-補登原因撈取資料失敗，請通知相關設定人員!!");
}
ddlRemedy_AbnormalReasonID.Items.Insert(0, new ListItem("---請選擇---", ""));
}
public static List <AT_CodeMap_Model> GridDataFormat(List <AT_CodeMap_Bean> dbDataList)
{
var result = new List <AT_CodeMap_Model>();
foreach (var item in dbDataList)
{
var data = new AT_CodeMap_Model();
data.TabName = item.TabName;
data.FldName = item.FldName;
data.Code = item.Code;
data.CodeCName = item.CodeCName;
data.SortFld = item.SortFld;
data.NotShowFlag = item.NotShowFlag;
data.LastChgComp = item.LastChgComp;
data.LastChgID = item.LastChgID;
data.LastChgDate = item.LastChgDate;
result.Add(data);
}
return(result);
}
/// <summary>
/// 取得DB資料
/// 個人班表
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="datas">回傳資料</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool Select_AT_CodeMap(AT_CodeMap_Model model, out List <AT_CodeMap_Bean> datas, out string msg)
{
bool result = false;
msg = "";
datas = new List <AT_CodeMap_Bean>();
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
AT_CodeMap_Bean dataBean = new AT_CodeMap_Bean()
{
TabName = model.TabName,
FldName = model.FldName
};
StringBuilder sb = new StringBuilder();
SqlCommand.Select_AT_CodeMap(dataBean, ref sb, true);
try
{
datas = conn.Query <AT_CodeMap_Bean>(sb.ToString(), dataBean).ToList();
}
catch (Exception)
{
throw;
}
if (datas == null)
{
throw new Exception("查無資料!");
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
