///<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(); }