public IActionResult TraCuuPhieuXuat()
{
TraCuuPhieuXuat mymodel = new TraCuuPhieuXuat();
mymodel.pS = service.GetAllStore();
mymodel.TuNgay = DateTime.Today;
mymodel.DenNgay = mymodel.TuNgay.AddDays(1);
return(View(mymodel));
}
public IActionResult TraCuuPhieuXuat(TraCuuPhieuXuat traCuuPhieuXuat)
{
TraCuuPhieuXuat mymodel = new TraCuuPhieuXuat();
mymodel.pS = service.GetAllStore();
mymodel.po = service.TraCuuPhieuXuat(traCuuPhieuXuat);
foreach (var item in mymodel.po)
{
Debug.WriteLine(item.OUTPUTVOUCHERID);
}
return(View(mymodel));
}
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);
}
