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