/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(cycms.Model.Speciality model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo_Speciality(");
strSql.Append("dbo_Name,dbo_HtmlDir,dbo_ContentHtml,dbo_IfShow,dbo_LinkUrl)");
strSql.Append(" values (");
strSql.Append("@dbo_Name,@dbo_HtmlDir,@dbo_ContentHtml,@dbo_IfShow,@dbo_LinkUrl)");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_Name", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_HtmlDir", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_ContentHtml", OleDbType.VarChar, 0),
new OleDbParameter("@dbo_IfShow", OleDbType.Boolean, 1),
new OleDbParameter("@dbo_LinkUrl", OleDbType.VarChar, 200)
};
parameters[0].Value = model.dbo_Name;
parameters[1].Value = model.dbo_HtmlDir;
parameters[2].Value = model.dbo_ContentHtml;
parameters[3].Value = model.dbo_IfShow;
parameters[4].Value = model.dbo_LinkUrl;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public cycms.Model.Speciality DataRowToModel(DataRow row)
{
cycms.Model.Speciality model = new cycms.Model.Speciality();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["dbo_Name"] != null)
{
model.dbo_Name = row["dbo_Name"].ToString();
}
if (row["dbo_HtmlDir"] != null)
{
model.dbo_HtmlDir = row["dbo_HtmlDir"].ToString();
}
if (row["dbo_ContentHtml"] != null)
{
model.dbo_ContentHtml = row["dbo_ContentHtml"].ToString();
}
if (row["dbo_IfShow"] != null && row["dbo_IfShow"].ToString() != "")
{
if ((row["dbo_IfShow"].ToString() == "1") || (row["dbo_IfShow"].ToString().ToLower() == "true"))
{
model.dbo_IfShow = true;
}
else
{
model.dbo_IfShow = false;
}
}
if (row["dbo_LinkUrl"] != null)
{
model.dbo_LinkUrl = row["dbo_LinkUrl"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(cycms.Model.Speciality model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo_Speciality set ");
strSql.Append("dbo_Name=@dbo_Name,");
strSql.Append("dbo_HtmlDir=@dbo_HtmlDir,");
strSql.Append("dbo_ContentHtml=@dbo_ContentHtml,");
strSql.Append("dbo_IfShow=@dbo_IfShow,");
strSql.Append("dbo_LinkUrl=@dbo_LinkUrl");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_Name", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_HtmlDir", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_ContentHtml", OleDbType.VarChar, 0),
new OleDbParameter("@dbo_IfShow", OleDbType.Boolean, 1),
new OleDbParameter("@dbo_LinkUrl", OleDbType.VarChar, 200),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.dbo_Name;
parameters[1].Value = model.dbo_HtmlDir;
parameters[2].Value = model.dbo_ContentHtml;
parameters[3].Value = model.dbo_IfShow;
parameters[4].Value = model.dbo_LinkUrl;
parameters[5].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public cycms.Model.Speciality GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,dbo_Name,dbo_HtmlDir,dbo_ContentHtml,dbo_IfShow,dbo_LinkUrl from dbo_Speciality ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
cycms.Model.Speciality model = new cycms.Model.Speciality();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
