public IActionResult TraCuuPhieuNhap(TraCuuPhieuNhap traCuuPhieuNhap) { TraCuuPhieuNhap mymodel = new TraCuuPhieuNhap(); mymodel.pS = service.GetAllStore(); mymodel.pi = service.TraCuuPhieuNhap(traCuuPhieuNhap); return(View(mymodel)); }
public IActionResult TraCuuPhieuNhap() { TraCuuPhieuNhap mymodel = new TraCuuPhieuNhap(); mymodel.pS = service.GetAllStore(); mymodel.TuNgay = DateTime.Today; mymodel.DenNgay = mymodel.TuNgay.AddDays(1); return(View(mymodel)); }
public IEnumerable <PM_INPUTORDER> TraCuuPhieuNhap(TraCuuPhieuNhap traCuuPhieuNhap) { Debug.WriteLine("Log" + traCuuPhieuNhap.TuKhoa); List <PM_INPUTORDER> stoList = new List <PM_INPUTORDER>(); using (OracleConnection con = new OracleConnection(_connectString)) { string queryString = "Select * from PM_INPUTORDER where INPUTVOUCHERID like '%" + traCuuPhieuNhap.TuKhoa + "%' and AUTOSTORECHANGETOSTOREID like '%" + traCuuPhieuNhap.Kho + "%'" + " and INPUTDATE BETWEEN TO_DATE ('" + traCuuPhieuNhap.TuNgay.ToString("dd/MM/yyyy") + "', 'DD/MM/YYYY')" + "AND TO_DATE('" + traCuuPhieuNhap.DenNgay.ToString("dd/MM/yyyy") + "', 'DD/MM/YYYY')" + "and PAYABLETYPE like '%" + traCuuPhieuNhap.HinhThucNhap + "%' and PROCESSSTATUS like '%" + traCuuPhieuNhap.TrangThaiNhap + "%'"; Debug.WriteLine("Log" + queryString); OracleCommand command = new OracleCommand(queryString, con); con.Open(); OracleDataReader reader = command.ExecuteReader(); try { while (reader.Read()) { PM_INPUTORDER store = new PM_INPUTORDER() { INPUTVOUCHERID = reader["INPUTVOUCHERID"].ToString(), AUTOSTORECHANGETOSTOREID = Convert.ToInt32(reader["AUTOSTORECHANGETOSTOREID"]), INPUTDATE = reader["INPUTDATE"].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); }