/// <summary> /// 获取列表 /// </summary> /// <param name="categoryId">类别主键</param> /// <returns>数据表</returns> public virtual DataTable GetDataTableByCategory(string categoryId) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldCategoryId, categoryId)); return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parameters)); }
public virtual int Delete(object id) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(this.PrimaryKey, id)); return(DbLogic.Delete(DbHelper, this.CurrentTableName, parameters)); }
public virtual string[] GetIds(KeyValuePair <string, object> parameter) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter); return(DbLogic.GetProperties(DbHelper, this.CurrentTableName, parameters, 0, BaseBusinessLogic.FieldId)); }
public virtual string[] GetProperties(KeyValuePair <string, object> parameter, int topLimit, string targetField) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter); return(DbLogic.GetProperties(DbHelper, this.CurrentTableName, parameters, topLimit, targetField)); }
public virtual bool Exists(KeyValuePair <string, object> parameter, object id) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter); return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, new KeyValuePair <string, object>(this.PrimaryKey, id))); }
// // 读取属性 // public virtual string GetProperty(object id, string targetField) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldId, id)); return(DbLogic.GetProperty(DbHelper, this.CurrentTableName, parameters, targetField)); }
/// <summary> /// 获得序列 /// </summary> /// <param name="fullName">序列名</param> /// <param name="defaultSequence">默认序列</param> /// <returns>序列实体</returns> protected BaseSequenceEntity GetSequenceByLock(string fullName, int defaultSequence) { BaseSequenceEntity sequenceEntity = new BaseSequenceEntity(); // 这里主要是为了判断是否存在 sequenceEntity = this.GetEntityByName(fullName); if (sequenceEntity == null) { // 这里添加记录时加锁机制。 // 是否已经被锁住 this.ReturnStatusCode = StatusCode.CanNotLock.ToString(); for (int i = 0; i < BaseSystemInfo.LockNoWaitCount; i++) { // 被锁定的记录数 int lockCount = DbLogic.LockNoWait(DbHelper, BaseSequenceEntity.TableName, new KeyValuePair <string, object>(BaseSequenceEntity.FieldFullName, BaseSequenceEntity.TableName)); if (lockCount > 0) { sequenceEntity.FullName = fullName; sequenceEntity.Reduction = defaultSequence - 1; sequenceEntity.Sequence = defaultSequence; sequenceEntity.Step = DefaultStep; this.AddEntity(sequenceEntity); this.ReturnStatusCode = StatusCode.LockOK.ToString(); break; } else { System.Threading.Thread.Sleep(BaseRandom.GetRandom(1, BaseSystemInfo.LockNoWaitTickMilliSeconds)); } } if (this.ReturnStatusCode == StatusCode.LockOK.ToString()) { // JiRiGaLa 这个是否能省略 sequenceEntity = this.GetEntityByName(fullName); } } else { // 若记录已经存在,加锁,然后读取记录。 // 是否已经被锁住 this.ReturnStatusCode = StatusCode.CanNotLock.ToString(); for (int i = 0; i < BaseSystemInfo.LockNoWaitCount; i++) { // 被锁定的记录数 int lockCount = DbLogic.LockNoWait(DbHelper, BaseSequenceEntity.TableName, new KeyValuePair <string, object>(BaseSequenceEntity.FieldFullName, fullName)); if (lockCount > 0) { sequenceEntity = this.GetEntityByName(fullName); this.ReturnStatusCode = StatusCode.LockOK.ToString(); break; } else { System.Threading.Thread.Sleep(BaseRandom.GetRandom(1, BaseSystemInfo.LockNoWaitTickMilliSeconds)); } } } return(sequenceEntity); }
/// <summary> /// 分页读取数据 /// </summary> /// <param name="recordCount">页面个数</param> /// <param name="pageIndex">当前页</param> /// <param name="pageSize">每页显示</param> /// <param name="tableName">从什么表</param> /// <param name="whereConditional">条件</param> /// <param name="selectField">选择哪些字段</param> /// <returns>数据表</returns> public virtual DataTable GetDataTableByPage(out int recordCount, int pageIndex = 1, int pageSize = 20, string sortExpression = null, string sortDire = null, string tableName = null, string whereConditional = null, string selectField = null) { if (tableName.ToUpper().IndexOf("SELECT") >= 0) { // 统计总条数 string commandText = string.Empty; if (string.IsNullOrEmpty(tableName)) { tableName = this.CurrentTableName; } commandText = tableName; if (tableName.ToUpper().IndexOf("SELECT") >= 0) { commandText = "(" + tableName + ") AS T "; } commandText = string.Format("SELECT COUNT(1) AS recordCount FROM {0}", commandText); object returnObject = DbHelper.ExecuteScalar(commandText); if (returnObject != null) { recordCount = int.Parse(returnObject.ToString()); } else { recordCount = 0; } return(DbLogic.GetDataTableByPage(DbHelper, recordCount, pageIndex, pageSize, tableName, sortExpression, sortDire)); } // 这个是调用存储过程的方法 return(DbLogic.GetDataTableByPage(DbHelper, out recordCount, pageIndex, pageSize, sortExpression, sortDire, tableName, whereConditional, selectField)); }
// // 设置属性 // public virtual int SetProperty(KeyValuePair <string, object> parameter) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter); return(DbLogic.SetProperty(DbHelper, this.CurrentTableName, null, parameters)); }
public virtual DataTable GetDataTable(KeyValuePair <string, object> parameter, int topLimit = 0, string order = null) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter); return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parameters, topLimit, order)); }
/// <summary> /// 按父亲节点获取数据 /// </summary> /// <param name="parentId">父节点主键</param> /// <returns>数据表</returns> public virtual DataTable GetDataTableByParent(string parentId) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldParentId, parentId)); return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parameters, 0, BaseBusinessLogic.FieldSortCode)); }
public virtual DataTable GetDataTable(KeyValuePair <string, object> parameter1, KeyValuePair <string, object> parameter2, string order) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter1); parameters.Add(parameter2); return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parameters, 0, order)); }
/// <summary> /// 获取主键 /// </summary> /// <param name="code">编号</param> /// <returns>主键</returns> public virtual string GetIdByCode(string code) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldCode, code)); parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldDeletionStateCode, 0)); return(DbLogic.GetProperty(DbHelper, this.CurrentTableName, parameters, BaseBusinessLogic.FieldId)); }
public virtual string GetProperty(KeyValuePair <string, object> parameter1, KeyValuePair <string, object> parameter2, string targetField) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter1); parameters.Add(parameter2); return(DbLogic.GetProperty(DbHelper, this.CurrentTableName, parameters, targetField)); }
public virtual bool Exists(KeyValuePair <string, object> parameter1, KeyValuePair <string, object> parameter2, KeyValuePair <string, object> parameter) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter1); parameters.Add(parameter2); return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, parameter)); }
/// <summary> /// 获取列表 /// </summary> /// <param name="categoryId">类别主键</param> /// <returns>数据表</returns> public virtual List <T> GetListByCategory <T>(string categoryId) where T : new() { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldCategoryId, categoryId)); IDataReader dr = DbLogic.GetDataReader(DbHelper, this.CurrentTableName, parameters); return(GetList <T>(dr)); }
public virtual List <T> GetList <T>(KeyValuePair <string, object> parameter, int topLimit, string order) where T : new() { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter); IDataReader dr = DbLogic.GetDataReader(DbHelper, this.CurrentTableName, parameters, topLimit, order); return(GetList <T>(dr)); }
public virtual int DeleteEntity(params KeyValuePair <string, object>[] parameters) { List <KeyValuePair <string, object> > parametersList = new List <KeyValuePair <string, object> >(); for (int i = 0; i < parameters.Length; i++) { parametersList.Add(parameters[i]); } return(DbLogic.Delete(DbHelper, this.CurrentTableName, parametersList)); }
public virtual string GetId(params KeyValuePair <string, object>[] parameters) { List <KeyValuePair <string, object> > parameterList = new List <KeyValuePair <string, object> >(); foreach (var parameter in parameters) { parameterList.Add(parameter); } return(DbLogic.GetProperty(DbHelper, this.CurrentTableName, parameterList, BaseBusinessLogic.FieldId)); }
public virtual List <T> GetList <T>(params KeyValuePair <string, object>[] parameters) where T : new() { List <KeyValuePair <string, object> > parametersList = new List <KeyValuePair <string, object> >(); for (int i = 0; i < parameters.Length; i++) { parametersList.Add(parameters[i]); } IDataReader dr = DbLogic.GetDataReader(DbHelper, this.CurrentTableName, parametersList); return(GetList <T>(dr)); }
public virtual int Delete(string name, object[] values) { int returnValue = 0; for (int i = 0; i < values.Length; i++) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(name, values[i])); returnValue += DbLogic.Delete(DbHelper, this.CurrentTableName, parameters); } return(returnValue); }
public virtual List <T> GetList <T>(List <KeyValuePair <string, object> > parameters, string order) where T : new() { IDataReader dr = DbLogic.GetDataReader(DbHelper, this.CurrentTableName, parameters, 0, order); return(GetList <T>(dr)); }
public virtual List <T> GetList <T>(string name, Object[] values, string order = null) where T : new() { IDataReader dr = DbLogic.GetDataReader(DbHelper, this.CurrentTableName, name, values, order); return(GetList <T>(dr)); }
public virtual List <T> GetList <T>(string[] ids) where T : new() { IDataReader dr = DbLogic.GetDataReader(DbHelper, this.CurrentTableName, BaseBusinessLogic.FieldId, ids); return(GetList <T>(dr)); }
public virtual List <T> GetList <T>(int topLimit = 0, string order = null) where T : new() { IDataReader dr = DbLogic.GetDataReader(DbHelper, this.CurrentTableName, null, topLimit, order); return(GetList <T>(dr)); }
/// <summary> /// 获取父节点列表 /// </summary> /// <param name="fieldCode">编码字段</param> /// <param name="code">编码</param> /// <returns>主键数组</returns> public string[] GetParentsIdByCode(string fieldCode, string code) { return(DbLogic.GetParentsIDByCode(DbHelper, this.CurrentTableName, fieldCode, code, string.Empty)); }
/// <summary> /// 获取父子节点列表 /// </summary> /// <param name="fieldCode">编码字段</param> /// <param name="code">编码</param> /// <param name="order">排序</param> /// <returns>数据表</returns> public DataTable GetParentChildrensByCode(string fieldCode, string code, string order) { return(DbLogic.GetParentChildrensByCode(DbHelper, this.CurrentTableName, fieldCode, code, order)); }
/// <summary> /// 获取子节点列表 /// </summary> /// <param name="fieldId">主键字段</param> /// <param name="id">值</param> /// <param name="fieldParentId">父亲节点字段</param> /// <param name="order">排序</param> /// <returns>数据表</returns> public DataTable GetChildrens(string fieldId, string id, string fieldParentId, string order) { return(DbLogic.GetChildrens(DbHelper, this.CurrentTableName, fieldId, id, fieldParentId, order)); }
/// <summary> /// 获取子节点列表 /// </summary> /// <param name="fieldId">主键字段</param> /// <param name="id">值</param> /// <param name="fieldParentId">父亲节点字段</param> /// <param name="order">排序</param> /// <returns>主键数组</returns> public string[] GetChildrensId(string fieldId, string id, string fieldParentId) { return(DbLogic.GetChildrensId(DbHelper, this.CurrentTableName, fieldId, id, fieldParentId, string.Empty)); }
public virtual DataTable GetDataTable(string name, Object[] values, string order = null) { return(DbLogic.GetDataTable(BaseSystemInfo.UserCenterDbType, DbHelper, this.CurrentTableName, name, values, order)); }