public static int DeleteProdTest(string sn)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@sn", sn);
return(DbAccess.ExecuteNonQuery(CommandType.StoredProcedure, "SYS_ProdTest_Delete", para));
}
//select all information
public static DataSet SelectAll()
{
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Module_SelectAll", null));
}
//选择生产部门
public static DataSet SelectProductDept()
{
return(DbAccess.DataAdapterByCmd(CommandType.Text, "select deptid,deptname from dept where state='Y'", null));
}
//select cmenu module
public static DataSet SelectMenuModule(string IsWeb)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@IsWeb", IsWeb);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Module_SelectMenuModule", para));
}