public static void UpdateGroup(string acode, string adesc, string type, decimal curbal) { SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB")); sp.Add("@A_CODE", typeof(System.String), acode); sp.Add("@A_DESC", typeof(System.String), adesc); sp.Add("@A_TYPE", typeof(System.String), type); sp.Add("@A_CURRB", typeof(System.Decimal), curbal); sp.ExecuteNonQuery("spUpdateFAGroup"); }
public static void DeleteSubGroup(string scode) { SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB")); sp.Add("@S_CODE", typeof(System.String), scode); sp.ExecuteNonQuery("spDeleteFASubGroup"); }
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]); }
public static void UpdateSubGroup(string scode, string sdesc, string stype, decimal opbal, string drcr, string flag) { SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB")); sp.Add("@S_CODE", typeof(System.String), scode); sp.Add("@S_DESC", typeof(System.String), sdesc); sp.Add("@S_TYPE", typeof(System.String), stype); sp.Add("@S_OPBAL", typeof(System.String), opbal); sp.Add("@S_DRCR", typeof(System.String), drcr); sp.Add("@S_FLAG", typeof(System.String), flag); sp.ExecuteNonQuery("spUpdateFASubGroup"); }