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