public static void Select_AT_CodeMap(AT_CodeMap_Bean Bean, ref StringBuilder sb, bool isReset = false) { if (isReset) { sb.Clear(); } sb.AppendLine(" select TabName , FldName , Code , CodeCName , SortFld , NotShowFlag , LastChgComp , LastChgID , LastChgDate "); sb.AppendLine(" from AT_CodeMap "); sb.AppendLine(" where 1=1 "); if (!string.IsNullOrEmpty(Bean.TabName)) { sb.AppendLine(" and TabName=").AppendFormat("@TabName", Bean.TabName); } if (!string.IsNullOrEmpty(Bean.FldName)) { sb.AppendLine(" and FldName=").AppendFormat("@FldName", Bean.FldName); } }
/// <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); }