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