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