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");
}