public void ProcessRequest(HttpContext context) { DataModel dm = new DataModel(); InstOrder lt = new InstOrder(); lt.InstOrderID = Convert.ToInt32(context.Request.Params["InstOrderID"]); lt.InstOrderLab = Convert.ToInt32(context.Request.Params["InstOrderLab"]); lt.InstOrderIns = Convert.ToInt32(context.Request.Params["InstOrderIns"]); lt.InstOrderAmount = Convert.ToInt32(context.Request.Params["InstOrderAmount"]); dm.SaveInstOrder(lt); dm.ReturnJsonMsg(context.Response, 1, "保存成功!", lt.InstOrderID); }
public List<InstOrder> GetLabOrderInst(int id) { List<InstOrder> ods = new List<InstOrder>(); InitCommand(); cmd.CommandText = "select * from ( InstOrder_tb left join Instrument_tb on InstOrder_tb.InstOrderIns= Instrument_tb.InstrumentID ) where InstOrder_tb.InstOrderLab = @id"; cmd.Parameters.AddWithValue("@id", id); dr = cmd.ExecuteReader(); if (dr.Read()) { InstOrder lt = new InstOrder(); lt.InstOrderID = Convert.ToInt32(dr["InstOrderID"]); lt.InstOrderLab = Convert.ToInt32(dr["InstOrderLab"]); lt.InstOrderIns = Convert.ToInt32(dr["InstOrderIns"]); lt.InstOrderAmount = Convert.ToInt32(dr["InstOrderAmount"]); lt.InstName = dr["InstrumentName"].ToString(); ods.Add(lt); } dr.Close(); conn.Close(); return ods; }
public int SaveInstOrder(InstOrder ino) { InitCommand(); if (ino.InstOrderID == 0) { //Insert new user cmd.CommandText = "INSERT INTO InstOrder_tb (InstOrderLab,InstOrderIns,InstOrderAmount) VALUES (@InstOrderLab,@InstOrderIns,@InstOrderAmount)"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@InstOrderLab", ino.InstOrderLab); cmd.Parameters.AddWithValue("@InstOrderIns", ino.InstOrderIns); cmd.Parameters.AddWithValue("@InstOrderAmount", ino.InstOrderAmount); cmd.ExecuteNonQuery(); cmd.CommandText = "SELECT @@Identity "; ino.InstOrderID = (int)cmd.ExecuteScalar(); } else { cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandText = "UPDATE User_tb SET " + " InstOrderLab=@InstOrderLab,InstOrderIns=@InstOrderIns,InstOrderAmount=@InstOrderAmount where InstOrderID=@InstOrderID"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@InstOrderLab", ino.InstOrderLab); cmd.Parameters.AddWithValue("@InstOrderIns", ino.InstOrderIns); cmd.Parameters.AddWithValue("@InstOrderAmount", ino.InstOrderAmount); cmd.Parameters.AddWithValue("@InstOrderID", ino.InstOrderID); cmd.ExecuteNonQuery(); } conn.Close(); return ino.InstOrderID; }
public List<InstOrder> GetInstOrders(int term,int week,int weekday,int cls,int instID ) { List<InstOrder> orders = new List<InstOrder>(); InitCommand(); cmd.CommandText = "select * from (InstOrder_tb left join Order_tb on InstOrder_tb.InstOrderLab=Order_tb.OrderID) where InstOrder_tb.InstOrderIns=@instID and InstOrderLab in " + " (select OrderID form Order_tb where OrderTerm = @term and OrderWeek = @week and OrderWeekday=@weekday and OrderCls=@cls )"; dr = cmd.ExecuteReader(); while (dr.Read()) { InstOrder lt = new InstOrder(); lt.InstOrderID = Convert.ToInt32(dr["InstOrderID"]); lt.InstOrderLab = Convert.ToInt32(dr["InstOrderLab"]); lt.InstOrderIns = Convert.ToInt32(dr["InstOrderIns"]); lt.InstOrderAmount = Convert.ToInt32(dr["InstOrderAmount"]); orders.Add(lt); } dr.Close(); conn.Close(); return orders; }