/// <summary>
/// 删除
/// </summary>
/// <param name="p"></param>
public void DelMemos(int p)
{
string sql = "delete Memos where ID=@id";
SqlParameter[] para =
{
new SqlParameter("@id", p)
};
DbHelper.ExecuteCommandBySql(sql, para);
}
/// <summary>
/// 设置为已读
/// </summary>
/// <param name="id"></param>
public void UpdateMemosIsRead(int id)
{
string sql = "update Memos set IsRead=1 where id=@id";
SqlParameter[] para =
{
new SqlParameter("@id", id)
};
DbHelper.ExecuteCommandBySql(sql, para);
}
public bool DelNsyNews(int p)
{
string sql = "delete NsyNews where ID=@id";
SqlParameter[] para =
{
new SqlParameter("@id", p)
};
if (DbHelper.ExecuteCommandBySql(sql, para) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 添加一个分类
/// </summary>
/// <param name="tpName"></param>
/// <returns></returns>
public bool AddCaseType(string tpName)
{
string sql = "insert into BoCaseType (TypeName) values(@TypeName)";
SqlParameter[] para =
{
new SqlParameter("@TypeName", tpName)
};
if (DbHelper.ExecuteCommandBySql(sql, para) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 删除案例
/// </summary>
/// <returns></returns>
public bool DelBoutiqueCase(int d)
{
string sql = "delete BoutiqueCase where ID=@id";
SqlParameter[] para =
{
new SqlParameter("@id", d)
};
if (DbHelper.ExecuteCommandBySql(sql, para) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="us"></param>
/// <returns></returns>
public bool EditPwd(UserInfo us)
{
string sql = "update UserInfo set LogPwd=@pwd where ID=@id";
SqlParameter[] para =
{
new SqlParameter("@pwd", us.LogPwd),
new SqlParameter("@id", us.ID),
};
if (DbHelper.ExecuteCommandBySql(sql, para) > 0)
{
return(true);
}
return(false);
}