public DataSet PrintReportCustomOutgoing(string facility, string tgl1, string tgl2, string bctype) { try { DSREPORT ds = new DSREPORT(); string strQuery = "rpt_custom_outgoing"; SqlParameter[] pParam = new SqlParameter[4]; pParam[0] = new SqlParameter("@facility", SqlDbType.VarChar); pParam[0].Value = facility; pParam[1] = new SqlParameter("@DateFilter1", SqlDbType.VarChar); pParam[1].Value = tgl1; pParam[2] = new SqlParameter("@DateFilter2", SqlDbType.VarChar); pParam[2].Value = tgl2; pParam[3] = new SqlParameter("@BCType", SqlDbType.VarChar); pParam[3].Value = bctype; ds = GetDataSetByCommand1(strQuery, "dtCustomOutgoing", pParam); return(ds); } catch (Exception ex) { throw ex; } }
public static DSREPORT GetDataSet(string pQuery, string dt, int pTimeOut = 300) { SqlDataAdapter da = null; DSREPORT dsa = new DSREPORT(); try { if (gh_Trans != null && gh_Trans.Command != null) { gh_Trans.Command.CommandType = CommandType.Text; gh_Trans.Command.CommandText = pQuery; gh_Trans.Command.CommandTimeout = pTimeOut; da = new SqlDataAdapter(gh_Trans.Command); da.Fill(dsa); } else { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = Connection(); conn.Open(); da = new SqlDataAdapter(pQuery, conn); da.Fill(dsa, dt); } } da = null; return(dsa); } catch (Exception ex) { throw ex; } }
public static DSREPORT GetDataSetByCommand1(string pQuery, string dt, SqlParameter[] pParam = null, int pTimeOut = 0) { SqlDataAdapter da = null; DSREPORT dsa = new DSREPORT(); try { if (gh_Trans != null && gh_Trans.Command != null) { gh_Trans.Command.CommandType = CommandType.StoredProcedure; gh_Trans.Command.CommandText = pQuery; gh_Trans.Command.CommandTimeout = pTimeOut; gh_Trans.Command.Parameters.Clear(); if (pParam != null) { for (int i = 0; i <= pParam.Length - 1; i++) { gh_Trans.Command.Parameters.Add(pParam[i]); } } da = new SqlDataAdapter(gh_Trans.Command); da.Fill(dsa); } else { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = Connection(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = pQuery; cmd.CommandTimeout = pTimeOut; cmd.Connection = conn; if (pParam != null) { for (int i = 0; i <= pParam.Length - 1; i++) { cmd.Parameters.Add(pParam[i]); } } conn.Open(); da = new SqlDataAdapter(cmd); da.Fill(dsa, dt); } } da = null; return(dsa); } catch (Exception ex) { throw ex; } }
public DataSet PrintReportWIP(string facility, int period, int yearperiod) { try { DSREPORT ds = new DSREPORT(); string strQuery = "rpt_custom_mutasi_wip"; SqlParameter[] pParam = new SqlParameter[3]; pParam[0] = new SqlParameter("@facility", SqlDbType.VarChar); pParam[0].Value = facility; pParam[1] = new SqlParameter("@period", SqlDbType.Int); pParam[1].Value = period; pParam[2] = new SqlParameter("@yearperiod", SqlDbType.Int); pParam[2].Value = yearperiod; ds = GetDataSetByCommand1(strQuery, "dtCustomWIP", pParam); return(ds); } catch (Exception ex) { throw ex; } }