/// <summary>
/// 创建新用户
/// </summary>
/// <param name="User"></param>
/// <returns>是否成功</returns>
public bool CreateUser(BzureUser User)
{
string sql = string.Format("INSERT INTO {0}(UserID,UserName,Password,State,EMail,OpenID,RoleValue,NickName) VALUES (@UserID, @UserName, @Password, @State, @EMail, @OpenID,@RoleValue,@NickName)", this.TableName);
int ret = new SqlEntityMap <string>(this.ContractProvider, sql)
.AddString("UserID", User.UserID)
.AddString("UserName", User.UserName)
.AddString("Password", User.Password)
.AddInt("State", User.State)
.AddString("EMail", User.EMail)
.AddString("OpenID", User.OpenID)
.AddInt("RoleValue", User.RoleValue)
.AddString("NickName", User.NickName)
.AsNonQuery();
if (ret > 0)
{
this.MarkPersistenceState(User, true);
}
return(ret > 0);
}
protected override Entity[] ProcessEntityQueryRequestPaged <Entity>(Bzure.Common.Data.EntityPageQueryRequest <Entity> QueryRequest)
{
Dictionary <string, MemberDataMap> MapSet = new Dictionary <string, MemberDataMap>();
lock (DataMapContainer)
{
Dictionary <string, MemberDataMap> MapSetTemp;
if (DataMapContainer.TryGetValue(typeof(Entity), out MapSetTemp))
{
foreach (KeyValuePair <string, MemberDataMap> kvp in MapSetTemp)
{
MapSet[kvp.Key] = kvp.Value.Copy();
}
}
else
{
throw new Exception(string.Format("类型：{0}没有在构建静态构造中初始化实体{1}的数据更新映射", this.GetType().Name, typeof(Entity).Name));
}
}
Delegate queryMap = null;
if (!QueryMapContainer.TryGetValue(typeof(Entity), out queryMap))
{
throw new Exception(string.Format("类型：{0}没有在构建静态构造中初始化实体{1}的数据查询映射", this.GetType().Name, typeof(Entity).Name));
}
ResultMapDelegate <Entity> qMap = queryMap as ResultMapDelegate <Entity>;
//查寻的条件
List <IDataMemberMap> ConditionDataMemberMapList = new List <IDataMemberMap>();
foreach (IEntityMemberMap map in QueryRequest.ConditionMap)
{
if (map is EntityMemberMap)
{
EntityMemberMap EntityMemberMap = map as EntityMemberMap;
MemberDataMap MemberDataMap;
if (MapSet.TryGetValue(EntityMemberMap.MemberName, out MemberDataMap))
{
ConditionDataMemberMapList.Add(new DataMemberMap()
{
DataFieldName = MemberDataMap.DataFieldName,
DataValue = EntityMemberMap.MemberValue,
Operator = EntityMemberMap.Operator
});
}
}
else if (map is LogicLinkMap)
{
ConditionDataMemberMapList.Add(map as LogicLinkMap);
}
}
//排序字段
DataMemberMap OrderFiledmap = default(DataMemberMap);
if (QueryRequest.OrderByMember != default(EntityMemberMap))
{
MemberDataMap mdm;
if (MapSet.TryGetValue(QueryRequest.OrderByMember.MemberName, out mdm))
{
OrderFiledmap = new DataMemberMap()
{
DataFieldName = mdm.DataFieldName,
DataValue = QueryRequest.OrderByMember.MemberValue,
Operator = QueryRequest.OrderByMember.Operator
};
}
}
string OrderField = "";
if (OrderFiledmap != default(DataMemberMap))
{
OrderField = string.Format("{0} {1}", OrderFiledmap.DataFieldName, QueryRequest.OrderTypeString());
}
string conditionSql = BuildPageQueryWhere(ConditionDataMemberMapList);
SqlEntityMap <Entity> ep = new SqlEntityMap <Entity>(this.ContractProvider, "[dbo].[P_BM_GenericPage]");
ep.SetCommandType(System.Data.CommandType.StoredProcedure);
List <Entity> list =
ep.AddString("TableName", this.TableName)
.AddString("Fields", "*")
.AddInt("pageSize", QueryRequest.PageSize)
.AddInt("pageIndex", QueryRequest.PageIndex)
.AddString("OrderField", OrderField)
.AddString("sqlWhere", conditionSql)
.AddInt("TotalPage", QueryRequest.TotalPage).SetDirection(ParameterDirection.Output)
.AddLong("Return", QueryRequest.TotalRecord).SetDirection(ParameterDirection.ReturnValue)
.AsList(qMap);
QueryRequest.TotalPage = (int)ep.GetParamValue("TotalPage");
//Object o = ep.GetParamValue("Return");
QueryRequest.TotalRecord = long.Parse(ep.GetParamValue("Return").ToString());
return(list.ToArray());
}
/// <summary>
/// 创建新用户
/// </summary>
/// <param name="User"></param>
/// <returns>是否成功</returns>
public bool CreateUser(BzureUser User)
{
string sql = string.Format("INSERT INTO {0}(UserID,UserName,Password,State,EMail,OpenID,RoleValue,NickName) VALUES (@UserID, @UserName, @Password, @State, @EMail, @OpenID,@RoleValue,@NickName)", this.TableName);
int ret = new SqlEntityMap<string>(this.ContractProvider, sql)
.AddString("UserID", User.UserID)
.AddString("UserName", User.UserName)
.AddString("Password", User.Password)
.AddInt("State", User.State)
.AddString("EMail", User.EMail)
.AddString("OpenID", User.OpenID)
.AddInt("RoleValue", User.RoleValue)
.AddString("NickName", User.NickName)
.AsNonQuery();
if (ret > 0)
this.MarkPersistenceState(User, true);
return ret > 0;
}
