public void handler(IResponder responder) { Bookingshop bookingshop = new Bookingshop(); bookingshop.Bookingid = SJSRequest.GetInt("Bookingid", 0); bookingshop.Bookingname = SJSRequest.GetString("Bookingname"); bookingshop.Shopid = SJSRequest.GetInt("Shopid", 0); bookingshop.Shopname = SJSRequest.GetString("Shopname"); bookingshop.Uid = PageUtils.AccountID; bookingshop.Realname = PageUtils.RealName.Trim(); bookingshop.Isover = false; //bookingshop.Begintime = DateTime.Now;// DateTime.UtcNow; if (bookingshop.Bookingid <= 0) { responder.WriteErroredMsg("预订参数错误!"); return; } if (bookingshop.Shopid <= 0) { responder.WriteErroredMsg("店铺参数错误!"); return; } Booking booking = BookingManager.GetBooking(bookingshop.Bookingid); if (booking == null) { responder.WriteErroredMsg("此预订不存在,无法加入!"); return; } if (booking.Isbooking == false) { responder.WriteErroredMsg("此预订已结束,无法加入!"); return; } Bookingshop confirm = BookingshopManager.GetBookingshop(bookingshop.Bookingid, bookingshop.Shopid, bookingshop.Uid); if (confirm != null) { responder.WriteErroredMsg("此店铺已存在于" + bookingshop.Bookingname + "的店铺列表,无法再次加入预订!"); return; } bookingshop.Begintime = booking.Bookingtime; int rlt = BookingshopManager.AddBookingshop(bookingshop); if (rlt <= 0) { responder.WriteErroredMsg("店铺预订加入失败,数据库写入不成功!"); return; } responder.WriteSuccessedMsg("加入预订成功!"); }
public int AddBookingshop(Bookingshop bookingshop) { string cmdText = "INSERT INTO BookingShop(bookingid,bookingname,uid,realname,shopid,shopname,begintime,isover)VALUES(@bookingid,@bookingname,@uid,@realname,@shopid,@shopname,@begintime,@isover);SELECT @@identity"; DbParameter[] cmdParameters = { DbHelper.MakeInParam("@bookingid", (DbType)SqlDbType.Int, 0, bookingshop.Bookingid)/**/, DbHelper.MakeInParam("@bookingname", (DbType)SqlDbType.NChar, 20, bookingshop.Bookingname)/**/, DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 0, bookingshop.Uid)/**/, DbHelper.MakeInParam("@realname", (DbType)SqlDbType.NChar, 10, bookingshop.Realname)/**/, DbHelper.MakeInParam("@shopid", (DbType)SqlDbType.Int, 0, bookingshop.Shopid)/**/, DbHelper.MakeInParam("@shopname", (DbType)SqlDbType.NChar, 20, bookingshop.Shopname)/**/, DbHelper.MakeInParam("@begintime", (DbType)SqlDbType.DateTime, 0, bookingshop.Begintime)/**/, DbHelper.MakeInParam("@isover", (DbType)SqlDbType.Bit, 0, bookingshop.Isover)/**/ }; string s = DbHelper.ExecuteScalar(CommandType.Text, cmdText, cmdParameters).ToString(); int i = (string.IsNullOrEmpty(s) ? 0 : int.Parse(s)); return i; }
/// <summary> /// 修改方法 /// </summary> public static int UpdateBookingshop(Bookingshop bookingshop) { return DatabaseProvider.GetInstance().UpdateBookingshop(bookingshop); }
public static Bookingshop GetBookingshop(IDataReader reader) { Bookingshop model = new Bookingshop(); model.Id = (reader["Id"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Id"])); model.Bookingid = (reader["Bookingid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Bookingid"])); model.Bookingname = reader["Bookingname"].ToString(); model.Uid = (reader["Uid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Uid"])); model.Realname = reader["Realname"].ToString(); model.Shopid = (reader["Shopid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Shopid"])); model.Shopname = reader["Shopname"].ToString(); model.Begintime = (reader["Begintime"] is DBNull ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(reader["Begintime"])); model.Isover = (reader["Isover"] is DBNull ? Convert.ToBoolean("false") : Convert.ToBoolean(reader["Isover"])); return model; }