/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.CMArticleType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CMArticleType(");
strSql.Append("ATName,DisplayCss,ColorValue)");
strSql.Append(" values (");
strSql.Append("@ATName,@DisplayCss,@ColorValue)");
strSql.Append(";select @@IDENTITY");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ATName", DbType.String, model.ATName);
db.AddInParameter(dbCommand, "DisplayCss", DbType.AnsiString, model.DisplayCss);
db.AddInParameter(dbCommand, "ColorValue", DbType.String, model.ColorValue);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.CMArticleType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CMArticleType set ");
strSql.Append("ATName=@ATName,");
strSql.Append("DisplayCss=@DisplayCss,");
strSql.Append("ColorValue=@ColorValue");
strSql.Append(" where ATId=@ATId ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ATId", DbType.Int32, model.ATId);
db.AddInParameter(dbCommand, "ATName", DbType.String, model.ATName);
db.AddInParameter(dbCommand, "DisplayCss", DbType.AnsiString, model.DisplayCss);
db.AddInParameter(dbCommand, "ColorValue", DbType.String, model.ColorValue);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public Model.CMArticleType GetModel(string strWhere, List <SqlParameter> parameters)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from CMArticleType ");
Database db = DatabaseFactory.CreateDatabase();
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
if (parameters.Count > 0)
{
foreach (SqlParameter sqlParameter in parameters)
{
dbCommand.Parameters.Add(sqlParameter);
}
}
Model.CMArticleType model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand)) {
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public Model.CMArticleType ReaderBind(IDataReader dataReader)
{
Model.CMArticleType model = new Model.CMArticleType();
object ojb;
ojb = dataReader["ATId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ATId = Convert.ToInt32(ojb);
}
model.ATName = dataReader["ATName"].ToString();
model.DisplayCss = dataReader["DisplayCss"].ToString();
model.ColorValue = dataReader["ColorValue"].ToString();
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.CMArticleType GetModel(int ATId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ATId,ATName,DisplayCss,ColorValue from CMArticleType ");
strSql.Append(" where ATId=@ATId ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ATId", DbType.Int32, ATId);
Model.CMArticleType model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.CMArticleType DataRowToModel(DataRow row)
{
Model.CMArticleType model = new Model.CMArticleType();
if (row != null)
{
if (row["ATId"] != null && row["ATId"].ToString() != "")
{
model.ATId = Convert.ToInt32(row["ATId"].ToString());
}
if (row["ATName"] != null)
{
model.ATName = row["ATName"].ToString();
}
if (row["DisplayCss"] != null)
{
model.DisplayCss = row["DisplayCss"].ToString();
}
if (row["ColorValue"] != null)
{
model.ColorValue = row["ColorValue"].ToString();
}
}
return(model);
}
