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