public IEnumerable <PM_INPUTORDER> GetAllPM_INPUTORDER() { List <PM_INPUTORDER> stoList = new List <PM_INPUTORDER>(); using (OracleConnection con = new OracleConnection(_connectString)) { string queryString = "Select * from PM_INPUTORDER"; OracleCommand command = new OracleCommand(queryString, con); con.Open(); OracleDataReader reader = command.ExecuteReader(); try { while (reader.Read()) { PM_INPUTORDER store = new PM_INPUTORDER(); stoList.Add(store); } } finally { reader.Close(); } } return(stoList); }
public IActionResult ThemSanPham(PM_INPUTORDER pi, SP_TaoPhieuNhap spt) { Debug.WriteLine("Log" + list.Count); TaoPhieuNhap mymodel = new TaoPhieuNhap(); mymodel.pS = service.GetAllStore(); mymodel.ispt = service.GetAllThemSanPham(list, spt); mymodel.tpnt = new TaoPhieuNhap_Temp(); mymodel.pi = pi; service.TaoPhieuNhap_Temp(mymodel.tpnt, mymodel); return(View("TaoPhieuNhap", mymodel)); }
public void TaoPhieuNhap_NoSubmit(PM_INPUTORDER pi) { System.Diagnostics.Debug.WriteLine("Log" + pi.AUTOSTORECHANGETOSTOREID); try { using (OracleConnection con = new OracleConnection(_connectString)) { string queryString = "Insert into PM_INPUTORDER(INPUTVOUCHERID,AUTOSTORECHANGETOSTOREID,CUSTOMERNAME,CUSTOMERADDRESS,CUSTOMERPHONE,TAXID,CHECKREALINPUTNOTE) values" + "('" + pi.INPUTVOUCHERID + "','" + pi.AUTOSTORECHANGETOSTOREID + "','" + pi.CUSTOMERNAME + "','" + pi.CUSTOMERADDRESS + "','" + pi.CUSTOMERPHONE + "','" + pi.TAXID + "','" + pi.CHECKREALINPUTNOTE + "') "; //string queryString = "Insert into PM_INPUTORDER(INPUTVOUCHERID) VALUES ('+"+pi.INPUTVOUCHERID.ToString()+"+')"; OracleCommand command = new OracleCommand(queryString, con); con.Open(); } } catch (Exception) { throw; } }
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); }
public IActionResult TaoPhieuNhap(PM_INPUTORDER pi) { service.TaoPhieuNhap(pi); return(RedirectToAction(nameof(Index))); }