/// <summary> /// 保存数据 /// </summary> public static bool SaveEntity(aspnet_ManagersEntity entity, bool isAdd, DbServers.DbServerName currDbName = DbServers.DbServerName.LatestDB) { try { string execSql = (isAdd) ? "Insert Into aspnet_Managers(RoleId,ClientUserId,state,CreateDate,UserName,Password,Email,AgentName,poi_id)values(@RoleId,@ClientUserId,@state,@CreateDate,@UserName,@Password,@Email,@AgentName,@poi_id)" : "Update aspnet_Managers Set RoleId=@RoleId,ClientUserId=@ClientUserId,state=@state,CreateDate=@CreateDate,UserName=@UserName,Password=@Password,Email=@Email,AgentName=@AgentName,poi_id=@poi_id Where UserId=@UserId"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@UserId", entity.UserId), new SqlParameter("@RoleId", entity.RoleId), new SqlParameter("@ClientUserId", entity.ClientUserId), new SqlParameter("@state", entity.State), (entity.CreateDate == null || entity.CreateDate == DateTime.MinValue)?new SqlParameter("@CreateDate", DBNull.Value):new SqlParameter("@CreateDate", entity.CreateDate), (entity.UserName == null)?new SqlParameter("@UserName", DBNull.Value):new SqlParameter("@UserName", entity.UserName), (entity.Password == null)?new SqlParameter("@Password", DBNull.Value):new SqlParameter("@Password", entity.Password), (entity.Email == null)?new SqlParameter("@Email", DBNull.Value):new SqlParameter("@Email", entity.Email), (entity.AgentName == null)?new SqlParameter("@AgentName", DBNull.Value):new SqlParameter("@AgentName", entity.AgentName), (entity.Poi_id == null)?new SqlParameter("@poi_id", DBNull.Value):new SqlParameter("@poi_id", entity.Poi_id), }; DataAccessFactory.GetDataProvider(DbServers.GetCurrentDB(currDbName)).Execute(execSql, para); return(true); } catch { return(false); } }
/// <summary> /// 保存 /// </summary> public static bool SaveEntity(aspnet_ManagersEntity entity, bool isAdd, DbServers.DbServerName currDbName = DbServers.DbServerName.LatestDB) { return(aspnet_ManagersManager.SaveEntity(entity, isAdd, currDbName)); }