public void SetEntity(NonQueryBuilder sqlBuilder, OrganizeEntity entity) { sqlBuilder.SetValue(FieldID, entity.ID); sqlBuilder.SetValue(FieldParentID, entity.ParentID); sqlBuilder.SetValue(FieldOrganizeCategoryID, entity.OrganizeCategoryID); sqlBuilder.SetValue(FieldCode, entity.Code); sqlBuilder.SetValue(FieldFullName, entity.FullName); sqlBuilder.SetValue(FieldShortName, entity.ShortName); sqlBuilder.SetValue(FieldOuterPhone, entity.OuterPhone); sqlBuilder.SetValue(FieldInnerPhone, entity.InnerPhone); sqlBuilder.SetValue(FieldFax, entity.Fax); sqlBuilder.SetValue(FieldEmail, entity.Email); sqlBuilder.SetValue(FieldPostalcode, entity.Postalcode); sqlBuilder.SetValue(FieldAddress, entity.Address); sqlBuilder.SetValue(FieldWeb, entity.Web); sqlBuilder.SetValue(FieldLayer, entity.Layer); sqlBuilder.SetValue(FieldSortCode, entity.SortCode); sqlBuilder.SetValue(FieldDescription, entity.Description); sqlBuilder.SetValue(FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(FieldIsEnable, entity.IsEnable); sqlBuilder.SetValue(FieldCreateOn, entity.CreateOn); sqlBuilder.SetValue(FieldCreateUserId, entity.CreateUserId); sqlBuilder.SetValue(FieldCreateBy, entity.CreateBy); sqlBuilder.SetValue(FieldModifiedOn, entity.ModifiedOn); sqlBuilder.SetValue(FieldModifiedUserId, entity.ModifiedUserId); sqlBuilder.SetValue(FieldModifiedBy, entity.ModifiedBy); }
public void SetEntity(NonQueryBuilder sqlBuilder, OrderHandlerEntity entity) { sqlBuilder.SetValue(FieldOrderID, entity.OrderID); sqlBuilder.SetValue(FieldHandlerID, entity.HandlerID); sqlBuilder.SetValue(FieldWorkload, entity.Workload); sqlBuilder.SetValue(FieldIsLeader, entity.IsLeader); }
public void SetEntity(NonQueryBuilder sqlBuilder, ResourceEntity entity) { sqlBuilder.SetValue(FieldParentID, entity.ParentID); sqlBuilder.SetValue(FieldCode, entity.Code); sqlBuilder.SetValue(FieldFullName, entity.FullName); sqlBuilder.SetValue(FieldSysCategory, entity.SysCategory); sqlBuilder.SetValue(FieldResourceCategory, entity.ResourceCategory); sqlBuilder.SetValue(FieldType, entity.Type); sqlBuilder.SetValue(FieldGroups, entity.Groups); sqlBuilder.SetValue(FieldTarget, entity.Target); sqlBuilder.SetValue(FieldNavigateUrl, entity.NavigateUrl); sqlBuilder.SetValue(FieldImagUrl, entity.ImagUrl); sqlBuilder.SetValue(FieldIsVisible, entity.IsVisible); sqlBuilder.SetValue(FieldIsEnable, entity.IsEnable); sqlBuilder.SetValue(FieldIsPublic, entity.IsPublic); sqlBuilder.SetValue(FieldDescription, entity.Description); sqlBuilder.SetValue(FieldSortCode, entity.SortCode); sqlBuilder.SetValue(FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(FieldCreateOn, entity.CreateOn); sqlBuilder.SetValue(FieldCreateUserId, entity.CreateUserId); sqlBuilder.SetValue(FieldCreateBy, entity.CreateBy); sqlBuilder.SetValue(FieldModifiedOn, entity.ModifiedOn); sqlBuilder.SetValue(FieldModifiedUserId, entity.ModifiedUserId); sqlBuilder.SetValue(FieldModifiedBy, entity.ModifiedBy); }
/// <summary> /// 更新实体数据,返回受影响的行数 /// </summary> /// <param name="dbHelper"></param> /// <param name="this.CurrentTableName">数据表名</param> /// <param name="targetFields">更新的目标字段 数组</param> /// <param name="targetValues">更新的目标值 数组</param> /// <param name="whereClause">WHERE 从句</param> /// <returns></returns> public int Update(List <KeyValuePair <string, object> > targetKVPs, WhereStatement whereStatement) { whereStatement.DbHelper = this.DbHelper; NonQueryBuilder sqlBuilder = new NonQueryBuilder(this.DbHelper, DbOperation.Update); sqlBuilder.SetFromTable(this.CurrentTableName); foreach (KeyValuePair <string, object> kv in targetKVPs) { sqlBuilder.SetValue(kv.Key, kv.Value); } if (whereStatement.ClauseLevels > 0) { sqlBuilder.AddWhere(whereStatement); } else { throw new Exception("whereClause contains 0 element"); } DbParameter[] parameters = null; string sql = sqlBuilder.BuildSQL(out parameters); int rows = this.DbHelper.ExecuteNonQuery(sql, parameters); return(rows); }
public void SetEntity(NonQueryBuilder sqlBuilder, OrderFlowEntity entity) { sqlBuilder.SetValue(FieldOrderID, entity.OrderID); sqlBuilder.SetValue(FieldOperatorID, entity.OperatorID); sqlBuilder.SetValue(FieldNextOperatorID, entity.NextOperatorID); sqlBuilder.SetValue(FieldOperation, entity.Operation); sqlBuilder.SetValue(FieldOperateTime, entity.OperateTime); sqlBuilder.SetValue(FieldRemark, entity.Remark); }
public void SetEntity(NonQueryBuilder sqlBuilder, OrderHandleDetailEntity entity) { sqlBuilder.SetValue(FieldOrderID, entity.OrderID); sqlBuilder.SetValue(FieldHandlerID, entity.HandlerID); sqlBuilder.SetValue(FieldHandleType, entity.HandleType); sqlBuilder.SetValue(FieldHandleDetail, entity.HandleDetail); sqlBuilder.SetValue(FieldProgress, entity.Progress); sqlBuilder.SetValue(FieldHandleTime, entity.HandleTime); sqlBuilder.SetValue(FieldRemark, entity.Remark); }
public void SetEntity(NonQueryBuilder sqlBuilder, UserEntity entity) { sqlBuilder.SetValue(this.FieldF1, entity.F1); sqlBuilder.SetValue(this.FieldF2, entity.F2); sqlBuilder.SetValue(this.FieldF3, entity.F3); sqlBuilder.SetValue(this.FieldDateTimeType, entity.DateTimeType); sqlBuilder.SetValue(this.FieldNumberType, entity.NumberType); sqlBuilder.SetValue(this.FieldDoubleType, entity.DoubleType); sqlBuilder.SetValue(this.FieldFloatType, entity.FloatType); sqlBuilder.SetValue(this.FieldDecimalType, entity.DecimalType); sqlBuilder.SetValue(this.FieldNullType, entity.NullType); }
public void SetEntity(NonQueryBuilder sqlBuilder, RolePermissionEntity entity) { sqlBuilder.SetValue(FieldRoleID, entity.RoleID); sqlBuilder.SetValue(FieldPermissionID, entity.PermissionID); sqlBuilder.SetValue(FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(FieldCreateOn, entity.CreateOn); sqlBuilder.SetValue(FieldCreateUserId, entity.CreateUserId); sqlBuilder.SetValue(FieldCreateBy, entity.CreateBy); sqlBuilder.SetValue(FieldModifiedOn, entity.ModifiedOn); sqlBuilder.SetValue(FieldModifiedUserId, entity.ModifiedUserId); sqlBuilder.SetValue(FieldModifiedBy, entity.ModifiedBy); }
/// <summary> /// 添加实体 /// </summary> /// <param name="entity">实体类型</param> /// <param name="returnId">返回新增的ID</param> /// <returns></returns> public string Insert(T entity, bool returnId = true) { DbParameter[] parameters = null; NonQueryBuilder sqlBuilder = new NonQueryBuilder(this.DbHelper, DbOperation.Insert); sqlBuilder.SetFromTable(this.CurrentTableName); this._iEntity.SetEntity(sqlBuilder, entity); string sql = sqlBuilder.BuildSQL(out parameters); return(DoInsert(parameters, sql, returnId)); }
public void SetEntity(NonQueryBuilder sqlBuilder, PermissionEntity entity) { sqlBuilder.SetValue(FieldPermissionItemID, entity.PermissionItemID); sqlBuilder.SetValue(FieldResourceID, entity.ResourceID); sqlBuilder.SetValue(FieldPermissionConstraint, entity.PermissionConstraint); sqlBuilder.SetValue(FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(FieldCreateOn, entity.CreateOn); sqlBuilder.SetValue(FieldCreateUserId, entity.CreateUserId); sqlBuilder.SetValue(FieldCreateBy, entity.CreateBy); sqlBuilder.SetValue(FieldModifiedOn, entity.ModifiedOn); sqlBuilder.SetValue(FieldModifiedUserId, entity.ModifiedUserId); sqlBuilder.SetValue(FieldModifiedBy, entity.ModifiedBy); }
public void SetEntity(NonQueryBuilder sqlBuilder, RoleEntity entity) { sqlBuilder.SetValue(FieldParentID, entity.ParentID); sqlBuilder.SetValue(FieldOrganizeID, entity.OrganizeID); sqlBuilder.SetValue(FieldFullName, entity.FullName); sqlBuilder.SetValue(FieldDescription, entity.Description); sqlBuilder.SetValue(FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(FieldCreateOn, entity.CreateOn); sqlBuilder.SetValue(FieldCreateUserId, entity.CreateUserId); sqlBuilder.SetValue(FieldCreateBy, entity.CreateBy); sqlBuilder.SetValue(FieldModifiedOn, entity.ModifiedOn); sqlBuilder.SetValue(FieldModifiedUserId, entity.ModifiedUserId); sqlBuilder.SetValue(FieldModifiedBy, entity.ModifiedBy); }
public int Delete(WhereStatement whereStatement) { whereStatement.DbHelper = this.DbHelper; NonQueryBuilder sqlBuilder = new NonQueryBuilder(this.DbHelper, DbOperation.Delete); sqlBuilder.SetFromTable(this.CurrentTableName); sqlBuilder.AddWhere(whereStatement); DbParameter[] parameters = null; string sql = sqlBuilder.BuildSQL(out parameters); int rows = this.DbHelper.ExecuteNonQuery(sql, parameters); return(rows); }
/// <summary> /// 插入指定键值对的数据 /// </summary> /// <param name="targetKVPs">需要插入的数据</param> /// <param name="returnId">返回新增的ID</param> /// <returns></returns> public string Insert(List <KeyValuePair <string, object> > targetKVPs, bool returnId = false) { DbParameter[] parameters = null; NonQueryBuilder sqlBuilder = new NonQueryBuilder(this.DbHelper, DbOperation.Insert); sqlBuilder.SetFromTable(this.CurrentTableName); foreach (KeyValuePair <string, object> kvp in targetKVPs) { sqlBuilder.SetValue(kvp.Key, kvp.Value); } string sql = sqlBuilder.BuildSQL(out parameters); return(DoInsert(parameters, sql, returnId)); }
public void SetEntity(NonQueryBuilder sqlBuilder, UserEntity entity) { sqlBuilder.SetValue(FieldUserName, entity.UserName); sqlBuilder.SetValue(FieldPassword, entity.Password); sqlBuilder.SetValue(FieldOpenID, entity.OpenID); sqlBuilder.SetValue(FieldIsLogin, entity.IsLogin); sqlBuilder.SetValue(FieldIsEnable, entity.IsEnable); sqlBuilder.SetValue(FieldDescription, entity.Description); sqlBuilder.SetValue(FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(FieldCreateOn, entity.CreateOn); sqlBuilder.SetValue(FieldCreateUserId, entity.CreateUserId); sqlBuilder.SetValue(FieldCreateBy, entity.CreateBy); sqlBuilder.SetValue(FieldModifiedOn, entity.ModifiedOn); sqlBuilder.SetValue(FieldModifiedUserId, entity.ModifiedUserId); sqlBuilder.SetValue(FieldModifiedBy, entity.ModifiedBy); }
public void SetEntity(NonQueryBuilder sqlBuilder, StaffEntity entity) { sqlBuilder.SetValue(FieldUserID, entity.UserID); sqlBuilder.SetValue(FieldOrganizeID, entity.OrganizeID); sqlBuilder.SetValue(FieldName, entity.Name); sqlBuilder.SetValue(FieldTel, entity.Tel); sqlBuilder.SetValue(FieldAddr, entity.Addr); sqlBuilder.SetValue(FieldIsEnable, entity.IsEnable); sqlBuilder.SetValue(FieldIsOnJob, entity.IsOnJob); sqlBuilder.SetValue(FieldSex, entity.Sex); sqlBuilder.SetValue(FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(FieldCreateOn, entity.CreateOn); sqlBuilder.SetValue(FieldCreateUserId, entity.CreateUserId); sqlBuilder.SetValue(FieldCreateBy, entity.CreateBy); sqlBuilder.SetValue(FieldModifiedOn, entity.ModifiedOn); sqlBuilder.SetValue(FieldModifiedUserId, entity.ModifiedUserId); sqlBuilder.SetValue(FieldModifiedBy, entity.ModifiedBy); }
/// <summary> /// 更新实体数据,返回受影响的行数 /// </summary> /// <param name="dbHelper"></param> /// <param name="this.CurrentTableName">数据表名</param> /// <param name="targetFields">更新的目标字段 数组</param> /// <param name="targetValues">更新的目标值 数组</param> /// <param name="whereClause">WHERE 从句</param> /// <returns></returns> public int Update(List <KeyValuePair <string, object> > targetKVPs, WhereClause whereClause) { NonQueryBuilder sqlBuilder = new NonQueryBuilder(this.DbHelper, DbOperation.Update); sqlBuilder.SetFromTable(this.CurrentTableName); sqlBuilder.AddWhere(whereClause); foreach (KeyValuePair <string, object> kv in targetKVPs) { sqlBuilder.SetValue(kv.Key, kv.Value); } DbParameter[] parameters = null; string sql = sqlBuilder.BuildSQL(out parameters); int rows = this.DbHelper.ExecuteNonQuery(sql, parameters); return(rows); }
public void SetEntity(NonQueryBuilder sqlBuilder, OrderEntity entity) { sqlBuilder.SetValue(FieldID, entity.ID); sqlBuilder.SetValue(FieldOrderNo, entity.OrderNo); sqlBuilder.SetValue(FieldStarterID, entity.StarterID); sqlBuilder.SetValue(FieldHandlerID, entity.HandlerID); sqlBuilder.SetValue(FieldAppointerID, entity.AppointerID); sqlBuilder.SetValue(FieldOperatorID, entity.OperatorID); sqlBuilder.SetValue(FieldNextOperatorID, entity.NextOperatorID); sqlBuilder.SetValue(FieldAssignDpt, entity.AssignDpt); sqlBuilder.SetValue(FieldRemark, entity.Remark); sqlBuilder.SetValue(FieldPriority, entity.Priority); sqlBuilder.SetValue(FieldStatus, entity.Status); sqlBuilder.SetValue(FieldFinishTime, entity.FinishTime); sqlBuilder.SetValue(FieldBookingTime, entity.BookingTime); sqlBuilder.SetValue(FieldAttn, entity.Attn); sqlBuilder.SetValue(FieldAttnTel, entity.AttnTel); sqlBuilder.SetValue(FieldContent, entity.Content); sqlBuilder.SetValue(FieldStartTime, entity.StartTime); sqlBuilder.SetValue(FieldOperateTime, entity.OperateTime); }
public void SetEntity(NonQueryBuilder sqlBuilder, PermissionItemEntity entity) { sqlBuilder.SetValue(FieldParentId, entity.ParentId); sqlBuilder.SetValue(FieldCode, entity.Code); sqlBuilder.SetValue(FieldFullName, entity.FullName); sqlBuilder.SetValue(FieldSysCategory, entity.SysCategory); sqlBuilder.SetValue(FieldActionName, entity.ActionName); sqlBuilder.SetValue(FieldActionParameter, entity.ActionParameter); sqlBuilder.SetValue(FieldAllowEdit, entity.AllowEdit); sqlBuilder.SetValue(FieldAllowDelete, entity.AllowDelete); sqlBuilder.SetValue(FieldIsVisible, entity.IsVisible); sqlBuilder.SetValue(FieldIsEnable, entity.IsEnable); sqlBuilder.SetValue(FieldIsPublic, entity.IsPublic); sqlBuilder.SetValue(FieldDescription, entity.Description); sqlBuilder.SetValue(FieldSortCode, entity.SortCode); sqlBuilder.SetValue(FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(FieldCreateOn, entity.CreateOn); sqlBuilder.SetValue(FieldCreateUserId, entity.CreateUserId); sqlBuilder.SetValue(FieldCreateBy, entity.CreateBy); sqlBuilder.SetValue(FieldModifiedOn, entity.ModifiedOn); sqlBuilder.SetValue(FieldModifiedUserId, entity.ModifiedUserId); sqlBuilder.SetValue(FieldModifiedBy, entity.ModifiedBy); }
public void SetEntity(NonQueryBuilder sqlBuilder, TabSNEntity entity) { sqlBuilder.SetValue(FieldSn, entity.Sn); sqlBuilder.SetValue(FieldSnDt, entity.SnDt); }
public void SetEntity(NonQueryBuilder sqlBuilder, RoleUserEntity entity) { sqlBuilder.SetValue(FieldRoleID, entity.RoleID); sqlBuilder.SetValue(FieldUserID, entity.UserID); }