/// <summary>
/// ����һ������
/// </summary>
public int Add(Mycms.Model.sys_channel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_sys_channel(");
strSql.Append("model_id,name,title,sort_id)");
strSql.Append(" values (");
strSql.Append("@model_id,@name,@title,@sort_id)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@model_id", SqlDbType.Int,4),
new SqlParameter("@name", SqlDbType.NVarChar,100),
new SqlParameter("@title", SqlDbType.NVarChar,100),
new SqlParameter("@sort_id", SqlDbType.Int,4)};
parameters[0].Value = model.model_id;
parameters[1].Value = model.name;
parameters[2].Value = model.title;
parameters[3].Value = model.sort_id;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(Mycms.Model.users model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Mycms.Model.users model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(Mycms.Model.manager_role model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Mycms.Model.manager_role model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Mycms.Model.sys_channel model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(Mycms.Model.sys_channel model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Mycms.Model.sys_channel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_sys_channel set ");
strSql.Append("model_id=@model_id,");
strSql.Append("name=@name,");
strSql.Append("title=@title,");
strSql.Append("sort_id=@sort_id");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@model_id", SqlDbType.Int,4),
new SqlParameter("@name", SqlDbType.NVarChar,100),
new SqlParameter("@title", SqlDbType.NVarChar,100),
new SqlParameter("@sort_id", SqlDbType.Int,4),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.model_id;
parameters[1].Value = model.name;
parameters[2].Value = model.title;
parameters[3].Value = model.sort_id;
parameters[4].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
