public void AddRecord(System.Collections.Generic.List<int> InsList, DAO dao, string DBNo, string sysLinkName, string CacheKey = null) { if (InsList == null || InsList.Count == 0) return; string sql = ""; StringBuilder sbd = new StringBuilder(); foreach (var id in InsList) { sbd.Append(id); sbd.Append(","); } sql = string.Format("select * from Sys_Role where ID in({0})", sbd.ToString(0, sbd.Length - 1)); BooleanValue<DataTable> bv = dao.GetDataTable(sql); if (bv.Success && bv.Value.Rows.Count > 0) { if (Default_sql != null) { object busisData = null; YueMES.Base.Dal.DTO.TryGetCache(Default_sql, DBNo, out busisData); Sys_Roles busis = (Sys_Roles)busisData; if (busis.Columns.Count != bv.Value.Columns.Count) return; lock (_lock) { foreach (DataRow row in bv.Value.Rows) { busis.LoadDataRow(row, true); } busis.AcceptChanges(); } } } }
public static Sys_Role GetItem(int id) { Sys_Role result = (Sys_Role)Default.FindRow("ID", id); if (result != null) return result; string sql = string.Format("select * from Sys_Role where ID={0}", id); DataRow dr = DAO.Default.GetDataRow(sql).Value as DataRow; if (dr == null) return null; result = Default.LoadDataRow(dr, true) as Sys_Role; return result; }