///<summary>
///根据-类型名称--得到类型信息
///</summary>
///<param name=""></param>
///<returns></returns>
public DataSet FindTypeByName(TypeManage typemanamege, string tbName)
{
SqlParameter[] prams =
{
data.MakeInParam("@name", SqlDbType.VarChar, 50, typemanamege.CategoryName + "%"),
};
return(data.RunProcReturn("select * from tb_type where name like @name", prams, tbName));
}
///<summary>
///删除--类型信息
///</summary>
///<param name=""></param>
///<returns></returns>
public int DeleteType(TypeManage typemanage)
{
SqlParameter[] prams =
{
data.MakeInParam("@id", SqlDbType.VarChar, 50, typemanage.ID),
};
return(data.RunProc("delete from tb_type where id=@id", prams));
}
///<summary>
///添加--类型信息
///</summary>
///<param name=""></param>
///<returns></returns>
public int AddType(TypeManage typemanage)
{
SqlParameter[] prams =
{
data.MakeInParam("@id", SqlDbType.VarChar, 50, typemanage.ID),
data.MakeInParam("@categoryname", SqlDbType.VarChar, 50, typemanage.CategoryName),
data.MakeInParam("@parentid", SqlDbType.VarChar, 50, typemanage.ParentId),
data.MakeInParam("@catelevel", SqlDbType.Int, 4, typemanage.CateLevel),
data.MakeInParam("@catepath", SqlDbType.VarChar, 50, typemanage.CatePath),
};
return(data.RunProc("INSERT INTO tb_type (id,categoryname,parentid,catelevel,catepath)VALUES(@id,@categoryname,@parentid,@catelevel,@catepath)", prams));
}
///<summary>
///修改--类型信息
///</summary>
///<param name=""></param>
///<returns></returns>
public int UpdateType(TypeManage typemanage)
{
SqlParameter[] prams =
{
data.MakeInParam("@id", SqlDbType.VarChar, 50, typemanage.ID),
data.MakeInParam("@categoryname", SqlDbType.VarChar, 50, typemanage.CategoryName),
data.MakeInParam("@parentid", SqlDbType.VarChar, 50, typemanage.ParentId),
data.MakeInParam("@catelevel", SqlDbType.Int, 4, typemanage.CateLevel),
data.MakeInParam("@catepath", SqlDbType.VarChar, 50, typemanage.CatePath),
};
return(data.RunProc("update tb_type set categoryname=@categoryname ,parentid=@parentid,catelevel=@catelevel,catepath=@catepath where id=@id", prams));
}
private void quảnLíLoạiToolStripMenuItem_Click(object sender, EventArgs e)
{
TypeManage typeManage = new TypeManage();
typeManage.ShowDialog();
}
private void QL_Loai_Click(object sender, EventArgs e)
{
TypeManage typeManage = new TypeManage();
typeManage.ShowDialog();
}
