/// <summary>
/// 从DataView加载，删除相同的对象。主要针对于人员兼职情况，有主职保留主职，没有仅保留一个兼职
/// </summary>
/// <param name="view"></param>
/// <param name="removeDuplicateData"></param>
public void LoadFromDataView(DataView view, bool removeDuplicateData)
{
view.NullCheck("view");
this.Clear();
if (removeDuplicateData)
{
LoadDataViewRemoveDuplicateData(view);
}
else
{
ORMapping.DataViewToCollection(this, view);
}
}
internal EmailAttachmentCollection LoadAttachments(string messageID)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem("MESSAGE_ID", messageID);
builder.AppendTenantCode();
string sql = string.Format("SELECT * FROM MSG.EMAIL_ATTACHMENTS WHERE {0} ORDER BY SORT_ID",
builder.ToSqlString(TSqlBuilder.Instance));
EmailAttachmentCollection result = new EmailAttachmentCollection();
ORMapping.DataViewToCollection(result,
DbHelper.RunSqlReturnDS(sql, GetConnectionName()).Tables[0].DefaultView);
return(result);
}
public AUOperationLogCollection Load(IConnectiveSqlClause sqlClause)
{
AUOperationLogCollection result = null;
AUCommon.DoDbAction(() =>
{
VersionedObjectAdapterHelper.Instance.FillData(GetMappingInfo().TableName, sqlClause, this.GetConnectionName(),
(view) =>
{
result = new AUOperationLogCollection();
ORMapping.DataViewToCollection(result, view);
});
});
return(result);
}
public InvalidAssigneeCollection Load(IConnectiveSqlClause builder)
{
InvalidAssigneeCollection result = new InvalidAssigneeCollection();
string sql = SelectSQL;
if (builder.IsEmpty == false)
{
sql = string.Format("{0} WHERE {1}",
SelectSQL,
builder.AppendTenantCodeSqlClause(typeof(InvalidAssignee)).ToSqlString(TSqlBuilder.Instance));
}
DataTable dt = DbHelper.RunSqlReturnDS(sql, this.GetConnectionName()).Tables[0];
ORMapping.DataViewToCollection(result, dt.DefaultView);
return(result);
}
public WfProgramInApplicationCollection LoadProgramsByApplication(string appCodeName)
{
appCodeName.CheckStringIsNullOrEmpty("appCodeName");
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem("APPLICATION_CODE_NAME", appCodeName);
string sql = string.Format("SELECT * FROM WF.PROGRAM_AND_ALIAS_VIEW WHERE {0} ORDER BY SORT",
builder.ToSqlString(TSqlBuilder.Instance));
DataTable table = DbHelper.RunSqlReturnDS(sql, GetConnectionName()).Tables[0];
WfProgramInApplicationCollection result = new WfProgramInApplicationCollection();
ORMapping.DataViewToCollection(result, table.DefaultView);
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public OpenIDBindingCollection GetBindingsByUserID(string userID)
{
ExceptionHelper.CheckStringIsNullOrEmpty(userID, "userID");
ORMappingItemCollection mappings = ORMapping.GetMappingInfo(typeof(OpenIDBinding));
string sql = string.Format("SELECT * FROM {0} WHERE USER_ID = {1}",
mappings.TableName,
TSqlBuilder.Instance.CheckUnicodeQuotationMark(userID));
OpenIDBindingCollection result = new OpenIDBindingCollection();
using (DbContext context = DbContext.GetContext(DataAdapter.DBConnectionName))
{
Database db = DatabaseFactory.Create(DataAdapter.DBConnectionName);
DataView view = db.ExecuteDataSet(CommandType.Text, sql).Tables[0].DefaultView;
ORMapping.DataViewToCollection(result, view);
}
return(result);
}
/// <summary>
/// 根据ID查询所有提示表
/// </summary>
/// <param name="codeArray">CodeName的数组 </param>
/// <param name="cultureName"> 区域</param>
/// <returns>提示信息集合</returns>
public TipCollection GetTips(string[] codeArray, string cultureName)
{
(codeArray != null).FalseThrow("提示信息列表不能为null");
InSqlClauseBuilder builder = new InSqlClauseBuilder("CODE_NAME");
builder.AppendItem(codeArray);
var result = new TipCollection();
if (builder.Count > 0)
{
string sql = string.Format("SELECT * FROM KB.TIP WHERE ENABLE ='1' AND CULTURE='{1}' AND {0} ",
builder.AppendTenantCodeSqlClause(typeof(Tip)).ToSqlString(TSqlBuilder.Instance), cultureName);
DataTable table = null;
DbHelper.RunSql(db => table = db.ExecuteDataSet(CommandType.Text, sql).Tables[0], ConnectionDefine.KBConnectionName);
ORMapping.DataViewToCollection(result, table.DefaultView);
}
return(result);
}
internal void LoadFromDataView(DataView dv)
{
this.Clear();
ORMapping.DataViewToCollection(this, dv);
}
