public DataTable SELECT_MANHOM_DINHMUC(string pMA_DVIQLY, string pMA_KHANG)
{
DataTable dt = new DataTable();
OracleConnection objConn = new OracleConnection(ConnectString.ConnectionString(pMA_DVIQLY));
OracleCommand objCmd = new OracleCommand();
try
{
objConn.Open();
objCmd.Connection = objConn;
objCmd.CommandText = "PKG_TRUYTHUNONTAI.SELECT_MANHOM_DINHMUC";
objCmd.Parameters.Add("pMA_DVIQLY", OracleType.VarChar).Value = pMA_DVIQLY;
objCmd.Parameters.Add("pMA_KHANG", OracleType.VarChar).Value = pMA_KHANG;
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("rs", OracleType.Cursor).Direction = ParameterDirection.Output;
OracleDataReader objReader = objCmd.ExecuteReader();
dt.Load(objReader);
objConn.Close();
objCmd.Dispose();
objCmd = null;
}
catch (Exception ex)
{
System.Console.WriteLine("Exception: {0}", ex.ToString());
}
finally
{
objConn.Close();
objConn.Dispose();
objCmd = null;
}
return(dt);
}
public void Update_TRUYTHU_NONTAI(int pID, int pIDMBA, string pMA_DVIQLY, string pMA_KHANG, int pTHANG, int pNAM, decimal pTHOIGIANSD, string pMA_NHOM)
{
DataTable dt = new DataTable();
OracleConnection objConn = new OracleConnection(ConnectString.ConnectionString(pMA_DVIQLY));
OracleCommand objCmd = new OracleCommand();
try
{
objConn.Open();
objCmd.Connection = objConn;
objCmd.CommandText = "PKG_TRUYTHUNONTAI.UPDATE_TRUYTHU_NONTAI";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("pID", OracleType.Number).Value = pID;
objCmd.Parameters.Add("pIDMBA", OracleType.Number).Value = pIDMBA;
objCmd.Parameters.Add("pMA_DVIQLY", OracleType.VarChar).Value = pMA_DVIQLY;
objCmd.Parameters.Add("pMA_KHANG", OracleType.VarChar).Value = pMA_KHANG;
objCmd.Parameters.Add("pTHANG", OracleType.Number).Value = pTHANG;
objCmd.Parameters.Add("pNAM", OracleType.Number).Value = pNAM;
objCmd.Parameters.Add("pTHOIGIANSD", OracleType.Number).Value = pTHOIGIANSD;
objCmd.Parameters.Add("pMA_NHOM", OracleType.VarChar).Value = pMA_NHOM;
OracleDataReader objReader = objCmd.ExecuteReader();
}
catch (Exception ex)
{
System.Console.WriteLine("Exception: {0}", ex.ToString());
}
finally
{
objConn.Close();
objConn.Dispose();
objCmd = null;
}
}
public void DELETE_TRUYTHU_NONTAI(int ID, string pMA_DVIQLY)
{
DataTable dt = new DataTable();
OracleConnection objConn = new OracleConnection(ConnectString.ConnectionString(pMA_DVIQLY));
OracleCommand objCmd = new OracleCommand();
try
{
objConn.Open();
objCmd.Connection = objConn;
objCmd.CommandText = "PKG_TRUYTHUNONTAI.DELETE_TRUYTHU_NONTAI";
objCmd.Parameters.Add("pID", OracleType.VarChar).Value = ID;
objCmd.CommandType = CommandType.StoredProcedure;
OracleDataReader objReader = objCmd.ExecuteReader();
}
catch (Exception ex)
{
System.Console.WriteLine("Exception: {0}", ex.ToString());
}
finally
{
objConn.Close();
objConn.Dispose();
objCmd = null;
}
}
public void Update_TRUYTHU_MBA(int pIDMBA, string pMA_KHANG, string pMA_DVIQLY, int pCSTIEUTHU, DateTime pNGAYTAO, decimal CS_TONTHAT)
{
DataTable dt = new DataTable();
OracleConnection objConn = new OracleConnection(ConnectString.ConnectionString(pMA_DVIQLY));
OracleCommand objCmd = new OracleCommand();
try
{
objConn.Open();
objCmd.Connection = objConn;
objCmd.CommandText = "PKG_TRUYTHUNONTAI.UPDATE_TRUYTHU_MBA";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("pIDMBA", OracleType.Number).Value = pIDMBA;
objCmd.Parameters.Add("pMA_KHANG", OracleType.VarChar).Value = pMA_KHANG;
objCmd.Parameters.Add("pMA_DVIQLY", OracleType.VarChar).Value = pMA_DVIQLY;
objCmd.Parameters.Add("pCSTIEUTHU", OracleType.Number).Value = pCSTIEUTHU;
objCmd.Parameters.Add("pNGAYTAO", OracleType.DateTime).Value = pNGAYTAO;
objCmd.Parameters.Add("pCS_TONTHAT", OracleType.Number).Value = CS_TONTHAT;
OracleDataReader objReader = objCmd.ExecuteReader();
}
catch (Exception ex)
{
System.Console.WriteLine("Exception: {0}", ex.ToString());
}
finally
{
objConn.Close();
objConn.Dispose();
objCmd = null;
}
}
public DataTable Get_BCTT_LDD(string pMA_DVIQLY, int pTHANG, int pNAM, string pLanBC, int LuyKe)
{
DataTable dt = new DataTable();
OracleConnection objConn = new OracleConnection(ConnectString.ConnectionString(pMA_DVIQLY));
OracleCommand objCmd = new OracleCommand();
try
{
objConn.Open();
objCmd.Connection = objConn;
objCmd.CommandText = " GNDN.PKG_NPCTTHAT.Get_BCTT_LDD";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("pMA_DVIQLY", OracleType.VarChar).Value = pMA_DVIQLY;
objCmd.Parameters.Add("pThang", OracleType.Number).Value = pTHANG;
objCmd.Parameters.Add("pNam", OracleType.Number).Value = pNAM;
objCmd.Parameters.Add("pLanBC", OracleType.VarChar).Value = pLanBC;
objCmd.Parameters.Add("pLuyke", OracleType.Number).Value = LuyKe;
objCmd.Parameters.Add("rs", OracleType.Cursor).Direction = ParameterDirection.Output;
OracleDataReader objReader = objCmd.ExecuteReader();
dt.Load(objReader);
objConn.Close();
objCmd.Dispose();
objCmd = null;
}
catch (Exception ex)
{
System.Console.WriteLine("Exception: {0}", ex.ToString());
}
finally
{
objConn.Close();
objConn.Dispose();
objCmd = null;
}
return(dt);
}