public static DataTable ListGroup() { SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB")); DataSet ds = sp.Execute("spListFAGroup"); return(ds.Tables[0]); }
public static DataTable GetGroup(string acode) { SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB")); sp.Add("@A_CODE", typeof(System.String), acode); DataSet ds = sp.Execute("spGetFAGroup"); return(ds.Tables[0]); }
public static DataTable GetJournal(String JId) { SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB")); sp.Add("@J_ID", typeof(System.String), JId); DataSet ds = sp.Execute("spGetJMaster"); return(ds.Tables[0]); }