/// <summary> /// 获取实体列表 /// </summary> /// <param name="showFields">显示字段</param> /// <param name="reader">IDataReader</param> /// <returns>返回Admin实体列表</returns> public static List<AdminModel> GetList(List<AdminFields> showFields, IDataReader reader) { List< AdminModel> list = new List< AdminModel>(); while ( reader.Read() ) { AdminModel admin= new AdminModel(); if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.AId)) && reader["AId"] !=DBNull.Value) { admin.AId = Convert.ToInt32(reader["AId"]); } if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.AName)) && reader["AName"] !=DBNull.Value) { admin.AName = reader["AName"].ToString(); } if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.APassword)) && reader["APassword"] !=DBNull.Value) { admin.APassword = reader["APassword"].ToString(); } if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.AEmail)) && reader["AEmail"] !=DBNull.Value) { admin.AEmail = reader["AEmail"].ToString(); } if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.ATelephone)) && reader["ATelephone"] !=DBNull.Value) { admin.ATelephone = reader["ATelephone"].ToString(); } if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.ARowValid)) && reader["ARowValid"] !=DBNull.Value) { admin.ARowValid = Convert.ToByte(reader["ARowValid"]); } if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.ACreateTime)) && reader["ACreateTime"] !=DBNull.Value) { admin.ACreateTime = Convert.ToDateTime(reader["ACreateTime"]); } if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.AScenicId)) && reader["AScenicId"] !=DBNull.Value) { admin.AScenicId = reader["AScenicId"].ToString(); } if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.AUserId)) && reader["AUserId"] !=DBNull.Value) { admin.AUserId = reader["AUserId"].ToString(); } if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, AdminFields.AUserLimit)) && reader["AUserLimit"] !=DBNull.Value) { admin.AUserLimit = Convert.ToByte(reader["AUserLimit"]); } list.Add(admin); } reader.Close(); return list; }
/// <summary> /// Admin 添加操作返回主键的编号 /// </summary> /// <param name="admin">Admin实体类</param> /// <param name="transaction">事务</param> /// <returns>执行成功返回true,否则为false</returns> public int AddByIdentity(AdminModel admin,DbTransaction transaction) { string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Admin表增加操作/File:AdminAccess.cs/Fun:AddByIdentity*/"; StringBuilder sql = new StringBuilder(); sql.Append(sqlDescription); sql.Append("insert ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Admin] (AName,APassword,AEmail,ATelephone,ARowValid,ACreateTime,AScenicId,AUserId,AUserLimit) values(@AName,@APassword,@AEmail,@ATelephone,@ARowValid,@ACreateTime,@AScenicId,@AUserId,@AUserLimit)"); SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection(); Collection.Add(new SqlParameterWrapper("@AName", admin.AName,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@APassword", admin.APassword,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@AEmail", admin.AEmail,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@ATelephone", admin.ATelephone,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@ARowValid", admin.ARowValid,SqlDbType.TinyInt)); Collection.Add(new SqlParameterWrapper("@ACreateTime", admin.ACreateTime,SqlDbType.DateTime)); Collection.Add(new SqlParameterWrapper("@AScenicId", admin.AScenicId,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@AUserId", admin.AUserId,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@AUserLimit", admin.AUserLimit,SqlDbType.TinyInt)); return SqlHelper.ExecuteIdentity(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction); }
/// <summary> /// Admin修改操作 /// </summary> /// <param name="aId">景区用户Id</param> /// <param name="updateModel">要修改Admin实体类</param> /// <param name="transaction">事务</param> /// <returns>执行成功返回true,否则为false</returns> public bool Update(int aId,AdminModel updateModel,DbTransaction transaction) { string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Admin表更新操作/File:AdminAccess.cs/Fun:Update*/"; StringBuilder sql = new StringBuilder(); sql.Append(sqlDescription); sql.Append("update ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Admin] set APassword=@APassword,AEmail=@AEmail,ATelephone=@ATelephone,ARowValid=@ARowValid,ACreateTime=@ACreateTime,AScenicId=@AScenicId,AUserLimit=@AUserLimit where AId=@AId"); SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection(); Collection.Add(new SqlParameterWrapper("@APassword", updateModel.APassword,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@AEmail", updateModel.AEmail,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@ATelephone", updateModel.ATelephone,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@ARowValid", updateModel.ARowValid,SqlDbType.TinyInt)); Collection.Add(new SqlParameterWrapper("@ACreateTime", updateModel.ACreateTime,SqlDbType.DateTime)); Collection.Add(new SqlParameterWrapper("@AScenicId", updateModel.AScenicId,SqlDbType.NVarChar)); Collection.Add(new SqlParameterWrapper("@AUserLimit", updateModel.AUserLimit,SqlDbType.TinyInt)); Collection.Add(new SqlParameterWrapper("@AId", aId,SqlDbType.Int)); return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction) > 0; }
/// <summary> /// Admin 添加操作返回主键的编号 /// </summary> /// <param name="admin">Admin实体类</param> /// <returns>执行成功返回true,否则为false</returns> public int AddByIdentity(AdminModel admin) { return dataAccess.AddByIdentity(admin); }
/// <summary> /// Admin修改操作 /// </summary> /// <param name="aId">景区用户Id</param> /// <param name="updateModel">要修改Admin实体类</param> /// <returns>执行成功返回true,否则为false</returns> public bool Update(int aId,AdminModel updateModel) { return dataAccess.Update(aId,updateModel); }
/// <summary> ///Admin 添加操作 /// </summary> /// <param name="admin">Admin实体类</param> /// <returns>执行成功返回true,否则为false</returns> public bool Add(AdminModel admin) { return dataAccess.Add(admin); }