public static Order GetOrderByOrderId(int orderid) { string sql = "select * from cloudorder where id=?id"; MySqlConnection con = new MySqlConnection(Config_MySql.sqlUrl); con.Open(); MySqlCommand comm = new MySqlCommand(sql, con); comm.Parameters.Add(new MySqlParameter("?id", orderid)); MySqlDataReader rdr = comm.ExecuteReader(); Order order = new Order(); while (rdr.Read()) { order.Id = rdr.GetInt32("id"); order.UserId = rdr.GetInt32("userid"); order.CloudCode = rdr.GetString("cloudcode"); order.Addtime = rdr.GetString("addtime"); order.OrderId = rdr.GetString("orderid"); order.GoodId = rdr.GetInt32("goodid"); order.good = GoodService.GetGoodMsg(order.GoodId); } comm.Clone(); con.Close(); return(order); }
/** * 0:进行中 * 1:已经揭晓 */ public static int getStatus(int good_id) { List <Order> orders = new List <Order>(); string sql = "select * from cloudorder where goodid = @good_id"; MySqlConnection con = new MySqlConnection(Config_MySql.sqlUrl); con.Open(); MySqlCommand comm = new MySqlCommand(sql, con); comm.Parameters.Add(new MySqlParameter("@good_id", good_id)); MySqlDataReader sdr = comm.ExecuteReader(); while (sdr.Read()) { Order order = new Order(); order.Id = sdr.GetInt32("id"); order.Addtime = sdr.GetString("addtime"); order.UserId = sdr.GetInt32("userid"); order.OrderSum = 0; order.CloudCode = sdr.GetString("cloudcode"); order.GoodId = sdr.GetInt32("goodid"); order.good = GoodService.GetGoodMsg(order.GoodId); orders.Add(order); } sdr.Close(); con.Close(); if (orders.Count > 0 && orders.Count >= orders[0].good.Joinpeoplenum) { return(1); } else { return(0); } }
public static List <Order> GetOrdersByUserId(int user_id) { List <Order> orders = new List <Order>(); string sql = "select * from cloudorder where userid = @userid"; MySqlConnection con = new MySqlConnection(Config_MySql.sqlUrl); con.Open(); MySqlCommand comm = new MySqlCommand(sql, con); comm.Parameters.Add(new MySqlParameter("@userid", user_id)); MySqlDataReader sdr = comm.ExecuteReader(); while (sdr.Read()) { Order order = new Order(); order.Id = sdr.GetInt32("id"); order.Addtime = sdr.GetString("addtime"); order.UserId = sdr.GetInt32("userid"); order.OrderSum = 0; order.CloudCode = sdr.GetString("cloudcode"); order.GoodId = sdr.GetInt32("goodid"); order.good = GoodService.GetGoodMsg(order.GoodId); orders.Add(order); } sdr.Close(); con.Close(); return(orders); }
public Good getGoodId() { int id = int.Parse(Request.QueryString["id"].ToString()); good = GoodService.GetGoodMsg(id); return(good); }
public static ShopCar getShopCarByShopCarId(int shopcarid) { ShopCar shopcar = new ShopCar(); string sql = "select * from shopcar where id=?shopcarid"; MySqlConnection con = new MySqlConnection(Config_MySql.sqlUrl); con.Open(); MySqlCommand comm = new MySqlCommand(sql, con); comm.Parameters.Add(new MySqlParameter("?shopcarid", shopcarid)); MySqlDataReader rdr = comm.ExecuteReader(); while (rdr.Read()) { shopcar.UserId = rdr.GetInt32("userid"); shopcar.GoodId = rdr.GetInt32("goodid"); shopcar.BuyTime = rdr.GetInt32("buytime"); shopcar.good = GoodService.GetGoodMsg(shopcar.GoodId); } comm.Clone(); con.Close(); return(shopcar); }
protected void addOrder(object sender, EventArgs e) { string buytime = buytime1.Value; int userid = 0; username = (string)Session["username"]; if (UserService.getUserIdByPhone(username) == 0) { userid = UserService.getUserIdByEmail(username); } else { userid = UserService.getUserIdByPhone(username); } int buytime_judge = int.Parse(buytime); if (buytime_judge > shopcar.good.RemainPeople || buytime_judge <= 0) { Response.Write("<script>alert('您的输入有误,请您重新输入购买个数!');location.href='Index.aspx';</script>"); } else { int buytimeInt = Convert.ToInt32(buytime); int goodid = shopcar.GoodId; string addtime = DateTime.Now.ToShortDateString().ToString(); Good value_good = GoodService.GetGoodMsg(goodid); int totalPeople = value_good.Joinpeoplenum; int old_remainpeople = value_good.RemainPeople; //生成订单编号 string orderId_head = "2017"; string orderId = orderId_head + userid + goodid; int[] codeArray = Hashtable_code(totalPeople); for (int i = 0; i < buytimeInt; i++) { int joinpeople = OrderService.GetOrderMsg(goodid); //真正云购码 string realCode = getCloudCode(codeArray, joinpeople).ToString() + userid + goodid; Order order = OrderService.AddOrder(userid, goodid, realCode, addtime, orderId); } int new_joinpeople = OrderService.GetOrderMsg(goodid); int remainpeople = totalPeople - new_joinpeople; GoodService.UpdateGoodPeople(new_joinpeople, remainpeople, goodid); if (remainpeople == 0) { //开奖 //1.依据goodid从cloudorder中随机查询一个luckycode string luckyCode = OrderService.getLuckyCodeByGoodId(goodid); //2.修改该good的信息 GoodService.UpateGoodLuckyMsg(goodid, luckyCode); //3.进入显示该商品信息的界面 Response.Write("<script>location.href='PersonalPage/PurchaseRecord/AnnouncedPurchase.aspx';</script>"); } Response.Write("<script>alert('订单添加成功!');location.href='PersonalPage/PurchaseRecord/JinxingPurchase.aspx';</script>"); } }