public DataSet DisplaySet() { DataSet DS = new DataSet(); DS = DataTransform.ReteriveDataMultiple("EXEC ", " DISPLAY-SET "); ClearTable(); return(DS); }
public DataSet DisplaySet() { DataSet DS = new DataSet(); DS = DataTransform.ReteriveDataMultiple("SELECT ID,SIGNATORY_NAME,UPLOAD_IMAGE_PATH,CURRENT_STATUS,A_userID,A_DateTime,E_UserID,E_DateTime FROM SPDS_SignatorySetup", " DISPLAY-SET "); ClearTable(); return(DS); }
public DataSet Get_RPS_SP_CorrespondingBankFilesId() { DatabaseConnection_Util DataTransform = new DatabaseConnection_Util(); DataSet DS = new DataSet(); DS = DataTransform.ReteriveDataMultiple("select max(ID) from RPS_CorrespondingBankFile", "GET_ALL_USER"); return(DS); }
public TABLE_RPS_DraftCancellation() { RPS_DraftCancellation_DATASET = DataTransform.ReteriveDataMultiple ("select DraftID ID ,DraftID,CancelNo,to_char(CancelDate,'MM/dd/yyyy') CancelDate,to_char(AcknowledgeDate,'MM/dd/yyyy') AcknowledgeDate,AcknowledgeRefNo,CancelStatusID,TracerID ,'' ReIssue,'' Refund ,'' SundryDuplicate ,A_UserID ,to_char(A_DateTime,'MM/dd/yyyy HH:MI:SS') A_DateTime ,E_UserID ,to_char(E_DateTime,'MM/dd/yyyy HH:MI:SS') E_DateTime,company_code from RPS_DraftCancellation WHERE 2=1 ", "NEW_USER_INFO"); //top 0 ID, //OracleParameter[] PR = new OracleParameter[2]; //PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "RPS_DraftCancellation"); //PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); //RPS_DraftCancellation_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR); }
public string Get_SP_CMN_CURRENCY_CHECK(string CurrencyCode) { DataSet DS = new DataSet(); DS = DataTransform.ReteriveDataMultiple("EXEC SP_CMN_CURRENCY_CHECK '" + CurrencyCode + "'", "GET_ALL_USER"); return(DS.Tables[0].Rows[0][0].ToString()); }
//public Stack BatchHeaderDivision(string STR) {} /**************************3RD PARTY PRINTING SYSTEM**********************************************/ public DataSet Get_RPS_DRAFT_V11(string ID) { DataSet DS = new DataSet(); DS = DataTransform.ReteriveDataMultiple("EXEC SP_PRINT_V11 " + ID, "GET_ALL_USER"); return(DS); }