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