public bool Update(StarUserInfo model)
{
Database db = DBHelper.CreateDataBase();
StringBuilder sb = new StringBuilder();
sb.Append("update StarUser set ");
sb.Append("Gender=@Gender,RealName=@RealName,Birthday=@Birthday,City=@City,Province=@Province,Area=@Area,Avatar=@Avatar,Height=@Height,Weight=@Weight,Hobby=@Hobby,Greeting=@Greeting,CreateDate=@CreateDate,CreateIP=@CreateIP,NickName=@NickName,ParentId=@ParentId,IsRecommend=@IsRecommend,FansNumber=@FansNumber,LikeNumber=@LikeNumber");
sb.Append(" where Id=@Id");
DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString());
db.AddInParameter(dbCommand, "@Id", DbType.Int32, model.Id);
db.AddInParameter(dbCommand, "@Gender", DbType.Int32, model.Gender);
db.AddInParameter(dbCommand, "@RealName", DbType.String, model.RealName);
db.AddInParameter(dbCommand, "@Birthday", DbType.DateTime, model.Birthday);
db.AddInParameter(dbCommand, "@City", DbType.Int32, model.City);
db.AddInParameter(dbCommand, "@Province", DbType.Int32, model.Province);
db.AddInParameter(dbCommand, "@Area", DbType.Int32, model.Area);
db.AddInParameter(dbCommand, "@Avatar", DbType.String, model.Avatar);
db.AddInParameter(dbCommand, "@Height", DbType.Int32, model.Height);
db.AddInParameter(dbCommand, "@Weight", DbType.Int32, model.Weight);
db.AddInParameter(dbCommand, "@Hobby", DbType.String, model.Hobby);
db.AddInParameter(dbCommand, "@Greeting", DbType.String, model.Greeting);
db.AddInParameter(dbCommand, "@CreateDate", DbType.DateTime, model.CreateDate);
db.AddInParameter(dbCommand, "@CreateIP", DbType.String, model.CreateIP);
db.AddInParameter(dbCommand, "@NickName", DbType.String, model.NickName);
db.AddInParameter(dbCommand, "@ParentId", DbType.Int32, model.ParentId);
db.AddInParameter(dbCommand, "@IsRecommend", DbType.Boolean, model.IsRecommend);
db.AddInParameter(dbCommand, "@FansNumber", DbType.Int32, model.FansNumber);
db.AddInParameter(dbCommand, "@LikeNumber", DbType.Int32, model.LikeNumber);
return(db.ExecuteNonQuery(dbCommand) < 1 ? false : true);
}
public int Create(StarUserInfo model)
{
Database db = DBHelper.CreateDataBase();
StringBuilder sb = new StringBuilder();
sb.Append("insert into StarUser(");
sb.Append("Gender,RealName,Birthday,City,Province,Area,Avatar,Height,Weight,Hobby,Greeting,CreateDate,CreateIP,NickName,ParentId,IsRecommend,FansNumber,LikeNumber");
sb.Append(") values(");
sb.Append("@Gender,@RealName,@Birthday,@City,@Province,@Area,@Avatar,@Height,@Weight,@Hobby,@Greeting,@CreateDate,@CreateIP,@NickName,@ParentId,@IsRecommend,@FansNumber,@LikeNumber);SELECT @@IDENTITY;");
DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString());
db.AddInParameter(dbCommand, "@Gender", DbType.Int32, model.Gender);
db.AddInParameter(dbCommand, "@RealName", DbType.String, model.RealName);
db.AddInParameter(dbCommand, "@Birthday", DbType.DateTime, model.Birthday);
db.AddInParameter(dbCommand, "@City", DbType.Int32, model.City);
db.AddInParameter(dbCommand, "@Province", DbType.Int32, model.Province);
db.AddInParameter(dbCommand, "@Area", DbType.Int32, model.Area);
db.AddInParameter(dbCommand, "@Avatar", DbType.String, model.Avatar);
db.AddInParameter(dbCommand, "@Height", DbType.Int32, model.Height);
db.AddInParameter(dbCommand, "@Weight", DbType.Int32, model.Weight);
db.AddInParameter(dbCommand, "@Hobby", DbType.String, model.Hobby);
db.AddInParameter(dbCommand, "@Greeting", DbType.String, model.Greeting);
db.AddInParameter(dbCommand, "@CreateDate", DbType.DateTime, model.CreateDate);
db.AddInParameter(dbCommand, "@CreateIP", DbType.String, model.CreateIP);
db.AddInParameter(dbCommand, "@NickName", DbType.String, model.NickName);
db.AddInParameter(dbCommand, "@ParentId", DbType.Int32, model.ParentId);
db.AddInParameter(dbCommand, "@IsRecommend", DbType.Boolean, model.IsRecommend);
db.AddInParameter(dbCommand, "@FansNumber", DbType.Int32, model.FansNumber);
db.AddInParameter(dbCommand, "@LikeNumber", DbType.Int32, model.LikeNumber);
int id = Convert.ToInt32(db.ExecuteScalar(dbCommand));
return(id);
}
public ActionResult CreateStarUser(StarUserInfo model)
{
bool issuc = false;
model.Hobby = Request["Hobby"];
model.CreateDate = DateTime.Now;
model.CreateIP = this.GetIP;
model.Avatar = "";
int id = starUserMgr.Create(model);
if (id > 0)
{
issuc = true;
}
MsgInfo msgInfo = new MsgInfo();
if (issuc)
{
msgInfo.IsError = false;
msgInfo.Msg = id.ToString();
msgInfo.MsgNo = (int)ErrorEnum.成功;
}
else
{
msgInfo.IsError = true;
msgInfo.Msg = "操作失败！";
msgInfo.MsgNo = (int)ErrorEnum.失败;
}
return(Content(JsonConvert.SerializeObject(msgInfo)));
}
/// <summary>
/// 修改Books表信息时 添加修改索引(实质上是先删除原有索引 再新增修改后索引)请求至队列
/// </summary>
/// <param name="books"></param>
public void Mod(StarUserInfo user)
{
IndexQueue bvm = new IndexQueue();
bvm.Id = user.Id;
bvm.KeyWords = user.RealName;
bvm.IT = IndexType.Modify;
starUserQueue.Enqueue(bvm);
}
public bool Delete(StarUserInfo model)
{
Database db = DBHelper.CreateDataBase();
StringBuilder sb = new StringBuilder();
sb.Append("delete from StarUser");
sb.Append(" where Id=@Id");
DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString());
db.AddInParameter(dbCommand, "@Id", DbType.Int32, model.Id);
return(db.ExecuteNonQuery(dbCommand) < 1 ? false : true);
}
public StarUserInfo Get(int Id)
{
Database db = DBHelper.CreateDataBase();
StringBuilder sb = new StringBuilder();
sb.Append("select * from StarUser where Id=@Id");
DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString());
db.AddInParameter(dbCommand, "@Id", DbType.Int32, Id);
StarUserInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = FillList(dataReader);
}
}
return(model);
}
public ActionResult StarCreate(StarUserInfo model)
{
if (model.Id > 0)
{
StarUserInfo _model = mStarUserMgr.Get(model.Id);
if (_model == null)
{
return(Json(-1));
}
_model.Avatar = model.Avatar;
_model.RealName = model.RealName;
_model.Height = model.Height;
_model.Hobby = model.Hobby;
_model.Greeting = model.Greeting;
_model.Gender = model.Gender;
_model.Weight = model.Weight;
_model.Birthday = model.Birthday;
_model.Province = model.Province;
_model.City = model.City;
_model.Area = model.Area;
bool res = mStarUserMgr.Update(_model);
if (res)
{
return(Json(1));
}
}
else
{
model.CreateDate = DateTime.Now;
model.CreateIP = this.GetIP;
model.ParentId = this.AccountId;
int id = mStarUserMgr.Create(model);
if (id > 0)
{
return(Json(1));
}
}
return(Json(0));
}
private StarUserInfo FillList(IDataReader dataReader)
{
StarUserInfo model = new StarUserInfo();
object ojb;
ojb = dataReader["Id"];
if (ojb != null && ojb != DBNull.Value)
{
model.Id = ( int)(ojb);
}
ojb = dataReader["Gender"];
if (ojb != null && ojb != DBNull.Value)
{
model.Gender = ( int)(ojb);
}
ojb = dataReader["RealName"];
if (ojb != null && ojb != DBNull.Value)
{
model.RealName = ( string)(ojb);
}
ojb = dataReader["Birthday"];
if (ojb != null && ojb != DBNull.Value)
{
model.Birthday = ( DateTime)(ojb);
}
ojb = dataReader["City"];
if (ojb != null && ojb != DBNull.Value)
{
model.City = ( int)(ojb);
}
ojb = dataReader["Province"];
if (ojb != null && ojb != DBNull.Value)
{
model.Province = ( int)(ojb);
}
ojb = dataReader["Area"];
if (ojb != null && ojb != DBNull.Value)
{
model.Area = ( int)(ojb);
}
ojb = dataReader["Avatar"];
if (ojb != null && ojb != DBNull.Value)
{
model.Avatar = ( string)(ojb);
}
ojb = dataReader["Height"];
if (ojb != null && ojb != DBNull.Value)
{
model.Height = ( int)(ojb);
}
ojb = dataReader["Weight"];
if (ojb != null && ojb != DBNull.Value)
{
model.Weight = ( int)(ojb);
}
ojb = dataReader["Hobby"];
if (ojb != null && ojb != DBNull.Value)
{
model.Hobby = ( string)(ojb);
}
ojb = dataReader["Greeting"];
if (ojb != null && ojb != DBNull.Value)
{
model.Greeting = ( string)(ojb);
}
ojb = dataReader["CreateDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateDate = ( DateTime)(ojb);
}
ojb = dataReader["CreateIP"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateIP = ( string)(ojb);
}
ojb = dataReader["NickName"];
if (ojb != null && ojb != DBNull.Value)
{
model.NickName = ( string)(ojb);
}
ojb = dataReader["ParentId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ParentId = ( int)(ojb);
}
ojb = dataReader["IsRecommend"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsRecommend = ( bool)(ojb);
}
ojb = dataReader["FansNumber"];
if (ojb != null && ojb != DBNull.Value)
{
model.FansNumber = ( int)(ojb);
}
ojb = dataReader["LikeNumber"];
if (ojb != null && ojb != DBNull.Value)
{
model.LikeNumber = ( int)(ojb);
}
return(model);
}
public bool Delete(StarUserInfo model)
{
return(dal.Delete(model));
}
public bool Update(StarUserInfo model)
{
return(dal.Update(model));
}
public int Create(StarUserInfo model)
{
int id = dal.Create(model);
return(id);
}
