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;
}
