public IEnumerable <PM_OUTPUTVOUCHER> TraCuuPhieuXuat(TraCuuPhieuXuat traCuuPhieuXuat)
{
Debug.WriteLine("Log" + traCuuPhieuXuat.TuKhoa);
List <PM_OUTPUTVOUCHER> stoList = new List <PM_OUTPUTVOUCHER>();
using (OracleConnection con = new OracleConnection(_connectString))
{
string queryString = "Select * from PM_OUTPUTVOUCHER where OUTPUTVOUCHERID like '%" + traCuuPhieuXuat.TuKhoa +
"%' and STOREID like '%" + traCuuPhieuXuat.Kho + "%'" +
" and OUTPUTDATE BETWEEN TO_DATE ('" + traCuuPhieuXuat.TuNgay.ToString("dd/MM/yyyy") + "', 'DD/MM/YYYY')" +
"AND TO_DATE('" + traCuuPhieuXuat.DenNgay.ToString("dd/MM/yyyy") + "', 'DD/MM/YYYY')" +
"and PAYABLETYPE like '%" + traCuuPhieuXuat.HinhThucXuat + "%'";
Debug.WriteLine("Log" + queryString);
OracleCommand command = new OracleCommand(queryString, con);
con.Open();
OracleDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
PM_OUTPUTVOUCHER store = new PM_OUTPUTVOUCHER()
{
OUTPUTVOUCHERID = reader["OUTPUTVOUCHERID"].ToString(),
ORIGINATESTOREID = Convert.ToInt32(reader["ORIGINATESTOREID"]),
OUTPUTDATE = reader["OUTPUTDATE"].ToString(),
CUSTOMERNAME = reader["CUSTOMERNAME"].ToString()
//TOTALAMOUNTBF = Convert.ToInt32(reader["TOTALAMOUNTBF"]),
//PROCESSSTATUS = Convert.ToInt32(reader["PROCESSSTATUS"])
};
Debug.WriteLine("Log" + stoList.Count());
stoList.Add(store);
}
}
finally
{
reader.Close();
}
}
return(stoList);
}
public void TaoPhieuXuat(PM_OUTPUTVOUCHER po)
{
System.Diagnostics.Debug.WriteLine("Log" + po.OUTPUTVOUCHERID);
try
{
using (OracleConnection con = new OracleConnection(_connectString))
{
string queryString = "Insert into PM_OUTPUTVOUCHER(OUTPUTVOUCHERID,STOREID,CUSTOMERNAME,CUSTOMERADDRESS,CUSTOMERPHONE) values" +
"('" + po.OUTPUTVOUCHERID + "','" + po.STOREID + "','" + po.CUSTOMERNAME + "','" +
po.CUSTOMERADDRESS + "','" + po.CUSTOMERPHONE + "')";
//string queryString = "Insert into PM_INPUTORDER(INPUTVOUCHERID) VALUES ('+"+pi.INPUTVOUCHERID.ToString()+"+')";
OracleCommand command = new OracleCommand(queryString, con);
con.Open();
command.ExecuteNonQuery();
}
}
catch (Exception)
{
throw;
}
}
public IActionResult TaoPhieuXuat(PM_OUTPUTVOUCHER po)
{
service.TaoPhieuXuat(po);
return(RedirectToAction(nameof(Index)));
}
