/// <summary>
/// 更新一条数据
/// </summary>
public int UpdateBasicInfo(Sys.Model.Member model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Username", SqlDbType.NVarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Birthday", SqlDbType.DateTime),
new SqlParameter("@QQ", SqlDbType.VarChar, 20),
new SqlParameter("@MSN", SqlDbType.VarChar, 50),
new SqlParameter("@Question", SqlDbType.NVarChar, 100),
new SqlParameter("@Answer", SqlDbType.NVarChar, 100),
new SqlParameter("@RealName", SqlDbType.NVarChar, 20),
new SqlParameter("@EmailState", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.Username;
parameters[2].Value = model.Email;
parameters[3].Value = model.Birthday;
parameters[4].Value = model.QQ;
parameters[5].Value = model.MSN;
parameters[6].Value = model.Question;
parameters[7].Value = model.Answer;
parameters[8].Value = model.RealName;
parameters[9].Value = model.EmailState;
return(DbHelperSQL.RunProcedure("Member_UpdateBasicInfo", parameters, out rowsAffected));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddReturnUserID(Sys.Model.Member model, string Password)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Username", SqlDbType.NVarChar, 20),
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@CreateIP", SqlDbType.NVarChar, 50),
new SqlParameter("@Password", SqlDbType.NVarChar, 50),
new SqlParameter("@State", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.Username;
parameters[2].Value = model.GroupID;
parameters[3].Value = model.CreateIP;
parameters[4].Value = Password;
parameters[5].Value = model.State;
DbHelperSQL.RunProcedure("Member_ADDReturnUserID", parameters, out rowsAffected);
if (rowsAffected == 1)
{
return(rowsAffected);
}
else
{
return((int)parameters[0].Value);;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Sys.Model.Member model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Username", SqlDbType.NVarChar, 20),
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@State", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.Username;
parameters[2].Value = model.GroupID;
parameters[3].Value = model.State;
return(DbHelperSQL.RunProcedure("Member_Update", parameters, out rowsAffected));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Sys.Model.Member model, string Password)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@Username", SqlDbType.NVarChar, 20),
new SqlParameter("@CreateIP", SqlDbType.NVarChar, 50),
new SqlParameter("@Password", SqlDbType.NVarChar, 50),
new SqlParameter("@Email", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Username;
parameters[1].Value = model.CreateIP;
parameters[2].Value = Password;
parameters[3].Value = model.Email;
return(DbHelperSQL.RunProcedure("Member_ADD", parameters, out rowsAffected));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Sys.Model.Member GetModel(int UserID)
{
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
Sys.Model.Member model = new Sys.Model.Member();
DataSet ds = DbHelperSQL.RunProcedure("Member_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
model.Username = ds.Tables[0].Rows[0]["Username"].ToString();
if (ds.Tables[0].Rows[0]["GroupID"].ToString() != "")
{
model.GroupID = int.Parse(ds.Tables[0].Rows[0]["GroupID"].ToString());
}
model.GroupName = ds.Tables[0].Rows[0]["GroupName"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
if (ds.Tables[0].Rows[0]["EmailState"].ToString() != "")
{
model.EmailState = int.Parse(ds.Tables[0].Rows[0]["EmailState"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
}
model.CreateIP = ds.Tables[0].Rows[0]["CreateIP"].ToString();
model.Question = ds.Tables[0].Rows[0]["Question"].ToString();
model.Answer = ds.Tables[0].Rows[0]["Answer"].ToString();
if (ds.Tables[0].Rows[0]["LoginTimes"].ToString() != "")
{
model.LoginTimes = int.Parse(ds.Tables[0].Rows[0]["LoginTimes"].ToString());
}
if (ds.Tables[0].Rows[0]["LastLoginTime"].ToString() != "")
{
model.LastLoginTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastLoginTime"].ToString());
}
model.LastLoginIP = ds.Tables[0].Rows[0]["LastLoginIP"].ToString();
if (ds.Tables[0].Rows[0]["ThisLoginTime"].ToString() != "")
{
model.ThisLoginTime = DateTime.Parse(ds.Tables[0].Rows[0]["ThisLoginTime"].ToString());
}
model.ThisLoginIP = ds.Tables[0].Rows[0]["ThisLoginIP"].ToString();
if (ds.Tables[0].Rows[0]["ActiveTime"].ToString() != "")
{
model.ActiveTime = DateTime.Parse(ds.Tables[0].Rows[0]["ActiveTime"].ToString());
}
if (ds.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString());
}
if (ds.Tables[0].Rows[0]["IsVIP"].ToString() != "")
{
model.IsVIP = int.Parse(ds.Tables[0].Rows[0]["IsVIP"].ToString());
}
if (ds.Tables[0].Rows[0]["VIPStartTime"].ToString() != "")
{
model.VIPStartTime = DateTime.Parse(ds.Tables[0].Rows[0]["VIPStartTime"].ToString());
}
if (ds.Tables[0].Rows[0]["VIPEndTime"].ToString() != "")
{
model.VIPEndTime = DateTime.Parse(ds.Tables[0].Rows[0]["VIPEndTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Birthday"].ToString() != "")
{
model.Birthday = DateTime.Parse(ds.Tables[0].Rows[0]["Birthday"].ToString());
}
model.RealName = ds.Tables[0].Rows[0]["RealName"].ToString();
model.Sign = ds.Tables[0].Rows[0]["Sign"].ToString();
model.QQ = ds.Tables[0].Rows[0]["QQ"].ToString();
model.MSN = ds.Tables[0].Rows[0]["MSN"].ToString();
model.Guid = ds.Tables[0].Rows[0]["Guid"].ToString();
model.Integral = int.Parse(ds.Tables[0].Rows[0]["Integral"].ToString());
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据(包含所有字段)
/// </summary>
public int Update_AllInfo(Sys.Model.Member model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Username", SqlDbType.NVarChar, 20),
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@GroupName", SqlDbType.NVarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@EmailState", SqlDbType.Int, 4),
new SqlParameter("@RealName", SqlDbType.NVarChar, 20),
new SqlParameter("@Birthday", SqlDbType.DateTime),
new SqlParameter("@Sign", SqlDbType.NVarChar, 255),
new SqlParameter("@QQ", SqlDbType.VarChar, 20),
new SqlParameter("@MSN", SqlDbType.VarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateIP", SqlDbType.VarChar, 50),
new SqlParameter("@Question", SqlDbType.NVarChar, 50),
new SqlParameter("@Answer", SqlDbType.NVarChar, 50),
new SqlParameter("@LoginTimes", SqlDbType.Int, 4),
new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
new SqlParameter("@LastLoginIP", SqlDbType.VarChar, 50),
new SqlParameter("@ThisLoginTime", SqlDbType.DateTime),
new SqlParameter("@ThisLoginIP", SqlDbType.VarChar, 50),
new SqlParameter("@ActiveTime", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@IsVIP", SqlDbType.Int, 4),
new SqlParameter("@VIPStartTime", SqlDbType.DateTime),
new SqlParameter("@VIPEndTime", SqlDbType.DateTime),
new SqlParameter("@Guid", SqlDbType.VarChar, 36),
new SqlParameter("@Integral", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.Username;
parameters[2].Value = model.GroupID;
parameters[3].Value = model.GroupName;
parameters[4].Value = model.Email;
parameters[5].Value = model.EmailState;
parameters[6].Value = model.RealName;
parameters[7].Value = model.Birthday;
parameters[8].Value = model.Sign;
parameters[9].Value = model.QQ;
parameters[10].Value = model.MSN;
parameters[11].Value = model.CreateTime;
parameters[12].Value = model.CreateIP;
parameters[13].Value = model.Question;
parameters[14].Value = model.Answer;
parameters[15].Value = model.LoginTimes;
parameters[16].Value = model.LastLoginTime;
parameters[17].Value = model.LastLoginIP;
parameters[18].Value = model.ThisLoginTime;
parameters[19].Value = model.ThisLoginIP;
parameters[20].Value = model.ActiveTime;
parameters[21].Value = model.State;
parameters[22].Value = model.IsVIP;
parameters[23].Value = model.VIPStartTime;
parameters[24].Value = model.VIPEndTime;
parameters[25].Value = model.Guid;
parameters[26].Value = model.Integral;
return(DbHelperSQL.RunProcedure("Member_Update_AllInfo", parameters, out rowsAffected));
}
