public bool Delete(UndergoInfo model)
{
Database db = DBHelper.CreateDataBase();
StringBuilder sb = new StringBuilder();
sb.Append("delete from Undergo");
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 ActionResult Create(UndergoInfo model)
{
model.CreateDate = DateTime.Now;
model.CreateIP = this.GetIP;
int id = mUndergoMgr.Create(model);
if (id > 0)
{
return(Json(true));
}
return(Json(false));
}
public bool Update(UndergoInfo model)
{
Database db = DBHelper.CreateDataBase();
StringBuilder sb = new StringBuilder();
sb.Append("update Undergo set ");
sb.Append("StarUserId=@StarUserId,Photos=@Photos,Content=@Content,CreateDate=@CreateDate,CreateIP=@CreateIP,UndergoType=@UndergoType");
sb.Append(" where Id=@Id");
DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString());
db.AddInParameter(dbCommand, "@Id", DbType.Int32, model.Id);
db.AddInParameter(dbCommand, "@StarUserId", DbType.Int32, model.StarUserId);
db.AddInParameter(dbCommand, "@Photos", DbType.String, model.Photos);
db.AddInParameter(dbCommand, "@Content", DbType.String, model.Content);
db.AddInParameter(dbCommand, "@CreateDate", DbType.DateTime, model.CreateDate);
db.AddInParameter(dbCommand, "@CreateIP", DbType.String, model.CreateIP);
db.AddInParameter(dbCommand, "@UndergoType", DbType.Int32, model.UndergoType);
return(db.ExecuteNonQuery(dbCommand) < 1 ? false : true);
}
private UndergoInfo FillList(IDataReader dataReader)
{
UndergoInfo model = new UndergoInfo();
object ojb;
ojb = dataReader["Id"];
if (ojb != null && ojb != DBNull.Value)
{
model.Id = ( int)(ojb);
}
ojb = dataReader["StarUserId"];
if (ojb != null && ojb != DBNull.Value)
{
model.StarUserId = ( int)(ojb);
}
ojb = dataReader["Photos"];
if (ojb != null && ojb != DBNull.Value)
{
model.Photos = ( string)(ojb);
}
ojb = dataReader["Content"];
if (ojb != null && ojb != DBNull.Value)
{
model.Content = ( 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["UndergoType"];
if (ojb != null && ojb != DBNull.Value)
{
model.UndergoType = ( int)(ojb);
}
return(model);
}
public UndergoInfo Get(int Id)
{
Database db = DBHelper.CreateDataBase();
StringBuilder sb = new StringBuilder();
sb.Append("select * from Undergo where Id=@Id");
DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString());
db.AddInParameter(dbCommand, "@Id", DbType.Int32, Id);
UndergoInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = FillList(dataReader);
}
}
return(model);
}
public int Create(UndergoInfo model)
{
Database db = DBHelper.CreateDataBase();
StringBuilder sb = new StringBuilder();
sb.Append("insert into Undergo(");
sb.Append("StarUserId,Photos,Content,CreateDate,CreateIP,UndergoType");
sb.Append(") values(");
sb.Append("@StarUserId,@Photos,@Content,@CreateDate,@CreateIP,@UndergoType);SELECT @@IDENTITY;");
DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString());
db.AddInParameter(dbCommand, "@StarUserId", DbType.Int32, model.StarUserId);
db.AddInParameter(dbCommand, "@Photos", DbType.String, model.Photos);
db.AddInParameter(dbCommand, "@Content", DbType.String, model.Content);
db.AddInParameter(dbCommand, "@CreateDate", DbType.DateTime, model.CreateDate);
db.AddInParameter(dbCommand, "@CreateIP", DbType.String, model.CreateIP);
db.AddInParameter(dbCommand, "@UndergoType", DbType.Int32, model.UndergoType);
int id = Convert.ToInt32(db.ExecuteScalar(dbCommand));
return(id);
}
public bool Delete(UndergoInfo model)
{
return(dal.Delete(model));
}
public bool Update(UndergoInfo model)
{
return(dal.Update(model));
}
public int Create(UndergoInfo model)
{
int id = dal.Create(model);
return(id);
}
