public int AddBookingtrade(Bookingtrade bookingtrade, DbTransaction trans)
{
string cmdText = "INSERT INTO BookingTrade(bookingshopid,bookingid,bookingname,shopid,shopname,handlerid,handlername,proxyid,proxyname,uid,realname,tradeid,tradename,tradevalue,tradecount,issettle,bookinttime,remarks)VALUES(@bookingshopid,@bookingid,@bookingname,@shopid,@shopname,@handlerid,@handlername,@proxyid,@proxyname,@uid,@realname,@tradeid,@tradename,@tradevalue,@tradecount,@issettle,@bookinttime,@remarks);SELECT @@identity";
DbParameter[] cmdParameters = {
DbHelper.MakeInParam("@bookingshopid", (DbType)SqlDbType.Int, 0, bookingtrade.Bookingshopid)/**/,
DbHelper.MakeInParam("@bookingid", (DbType)SqlDbType.Int, 0, bookingtrade.Bookingid)/**/,
DbHelper.MakeInParam("@bookingname", (DbType)SqlDbType.NChar, 50, bookingtrade.Bookingname)/**/,
DbHelper.MakeInParam("@shopid", (DbType)SqlDbType.Int, 0, bookingtrade.Shopid)/**/,
DbHelper.MakeInParam("@shopname", (DbType)SqlDbType.NChar, 20, bookingtrade.Shopname)/**/,
DbHelper.MakeInParam("@handlerid", (DbType)SqlDbType.Int, 0, bookingtrade.Handlerid)/**/,
DbHelper.MakeInParam("@handlername", (DbType)SqlDbType.NChar, 10, bookingtrade.Handlername)/**/,
DbHelper.MakeInParam("@proxyid", (DbType)SqlDbType.Int, 0, bookingtrade.Proxyid)/**/,
DbHelper.MakeInParam("@proxyname", (DbType)SqlDbType.NChar, 10, bookingtrade.Proxyname)/**/,
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 0, bookingtrade.Uid)/**/,
DbHelper.MakeInParam("@realname", (DbType)SqlDbType.NChar, 10, bookingtrade.Realname)/**/,
DbHelper.MakeInParam("@tradeid", (DbType)SqlDbType.Int, 0, bookingtrade.Tradeid)/**/,
DbHelper.MakeInParam("@tradename", (DbType)SqlDbType.NChar, 20, bookingtrade.Tradename)/**/,
DbHelper.MakeInParam("@tradevalue", (DbType)SqlDbType.Decimal, 0, bookingtrade.Tradevalue)/**/,
DbHelper.MakeInParam("@tradecount", (DbType)SqlDbType.Int, 0, bookingtrade.Tradecount)/**/,
DbHelper.MakeInParam("@issettle", (DbType)SqlDbType.Bit, 0, bookingtrade.Issettle)/**/,
DbHelper.MakeInParam("@bookinttime", (DbType)SqlDbType.DateTime, 0, bookingtrade.Bookinttime)/**/,
DbHelper.MakeInParam("@remarks", (DbType)SqlDbType.NChar, 100, bookingtrade.Remarks)/**/
};
string s = DbHelper.ExecuteScalar(trans, CommandType.Text, cmdText, cmdParameters).ToString();
int i = (string.IsNullOrEmpty(s) ? 0 : int.Parse(s));
return i;
}
public int UpdateBookingtrade(Bookingtrade bookingtrade, DbTransaction trans)
{
string cmdText = "UPDATE BookingTrade SET bookingshopid=@bookingshopid, bookingid=@bookingid, bookingname=@bookingname, shopid=@shopid, shopname=@shopname, handlerid=@handlerid, handlername=@handlername, proxyid=@proxyid, proxyname=@proxyname, uid=@uid, realname=@realname, tradeid=@tradeid, tradename=@tradename, tradevalue=@tradevalue, tradecount=@tradecount, issettle=@issettle, remarks=@remarks WHERE id=@id";
DbParameter[] cmdParameters2 = {
DbHelper.MakeInParam("@id", (DbType)SqlDbType.Int, 0, bookingtrade.Id)/**/,
DbHelper.MakeInParam("@bookingshopid", (DbType)SqlDbType.Int, 0, bookingtrade.Bookingshopid)/**/,
DbHelper.MakeInParam("@bookingid", (DbType)SqlDbType.Int, 0, bookingtrade.Bookingid)/**/,
DbHelper.MakeInParam("@bookingname", (DbType)SqlDbType.NChar, 50, bookingtrade.Bookingname)/**/,
DbHelper.MakeInParam("@shopid", (DbType)SqlDbType.Int, 0, bookingtrade.Shopid)/**/,
DbHelper.MakeInParam("@shopname", (DbType)SqlDbType.NChar, 20, bookingtrade.Shopname)/**/,
DbHelper.MakeInParam("@handlerid", (DbType)SqlDbType.Int, 0, bookingtrade.Handlerid)/**/,
DbHelper.MakeInParam("@handlername", (DbType)SqlDbType.NChar, 10, bookingtrade.Handlername)/**/,
DbHelper.MakeInParam("@proxyid", (DbType)SqlDbType.Int, 0, bookingtrade.Proxyid)/**/,
DbHelper.MakeInParam("@proxyname", (DbType)SqlDbType.NChar, 10, bookingtrade.Proxyname)/**/,
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 0, bookingtrade.Uid)/**/,
DbHelper.MakeInParam("@realname", (DbType)SqlDbType.NChar, 10, bookingtrade.Realname)/**/,
DbHelper.MakeInParam("@tradeid", (DbType)SqlDbType.Int, 0, bookingtrade.Tradeid)/**/,
DbHelper.MakeInParam("@tradename", (DbType)SqlDbType.NChar, 20, bookingtrade.Tradename)/**/,
DbHelper.MakeInParam("@tradevalue", (DbType)SqlDbType.Decimal, 0, bookingtrade.Tradevalue)/**/,
DbHelper.MakeInParam("@tradecount", (DbType)SqlDbType.Int, 0, bookingtrade.Tradecount)/**/,
DbHelper.MakeInParam("@issettle", (DbType)SqlDbType.Bit, 0, bookingtrade.Issettle)/**/,
DbHelper.MakeInParam("@remarks", (DbType)SqlDbType.NChar, 100, bookingtrade.Remarks)/**/
};
return DbHelper.ExecuteNonQuery(trans, CommandType.Text, cmdText, cmdParameters2);
}
public int UpdateBookingtrade(Bookingtrade bookingtrade)
{
using (DbTransaction trans = DbHelper.BeginTransaction())
{
int i = UpdateBookingtrade(bookingtrade, trans);
if (i <= 0)
{
trans.Rollback();
}
else
{
trans.Commit();
}
return i;
}
}
public static int UpdateBookingtrade(Bookingtrade bookingtrade, DbTransaction trans)
{
return DatabaseProvider.GetInstance().UpdateBookingtrade(bookingtrade, trans);
}
/// <summary>
/// 修改方法
/// </summary>
public static int UpdateBookingtrade(Bookingtrade bookingtrade)
{
return DatabaseProvider.GetInstance().UpdateBookingtrade(bookingtrade);
}
public static Bookingtrade GetBookingtrade(IDataReader reader)
{
Bookingtrade model = new Bookingtrade();
model.Id = (reader["Id"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Id"]));
model.Bookingshopid = (reader["Bookingshopid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Bookingshopid"]));
model.Bookingid = (reader["Bookingid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Bookingid"]));
model.Bookingname = reader["Bookingname"].ToString();
model.Shopid = (reader["Shopid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Shopid"]));
model.Shopname = reader["Shopname"].ToString();
model.Handlerid = (reader["Handlerid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Handlerid"]));
model.Handlername = reader["Handlername"].ToString();
model.Proxyid = (reader["Proxyid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Proxyid"]));
model.Proxyname = reader["Proxyname"].ToString();
model.Uid = (reader["Uid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Uid"]));
model.Realname = reader["Realname"].ToString();
model.Tradeid = (reader["Tradeid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Tradeid"]));
model.Tradename = reader["Tradename"].ToString();
model.Tradevalue = (reader["Tradevalue"] is DBNull ? Convert.ToDouble("0") : Convert.ToDouble(reader["Tradevalue"]));
model.Tradecount = (reader["Tradecount"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Tradecount"]));
model.Issettle = (reader["Issettle"] is DBNull ? Convert.ToBoolean("false") : Convert.ToBoolean(reader["Issettle"]));
model.Bookinttime = (reader["Bookinttime"] is DBNull ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(reader["Bookinttime"]));
model.Remarks = reader["Remarks"].ToString();
return model;
}
public void handler(IResponder responder)
{
int withUid = SJSRequest.GetInt("WithUid", 0);
Bookingtrade bookingtrade = new Bookingtrade();
bookingtrade.Tradeid = SJSRequest.GetInt("Tradeid", 0);
bookingtrade.Bookingshopid = SJSRequest.GetInt("Id", 0);
bookingtrade.Tradecount = SJSRequest.GetInt("Tradecount", 0);
//bookingtrade.Remarks = SJSRequest.GetString("Remarks");
if (bookingtrade.Tradecount <= 0)
{
responder.WriteErroredMsg("预订数量只能是正数!");
return;
}
if (bookingtrade.Tradeid <= 0)
{
responder.WriteErroredMsg("菜单项请求参数错误!");
return;
}
if (bookingtrade.Bookingshopid <= 0)
{
responder.WriteErroredMsg("预订店铺记录请求参数错误!");
return;
}
Bookingshop bookingshop = BookingshopManager.GetBookingshop(bookingtrade.Bookingshopid);
if (bookingshop == null)
{
responder.WriteErroredMsg("此店铺接受预订记录不存在,无法预订!");
return;
}
Booking booking = BookingManager.GetBooking(bookingshop.Bookingid);
if (booking == null)
{
responder.WriteErroredMsg("此预订不存在,无法预订!");
return;
}
if (booking.Isbooking == false && User.IsAdministrator(PageUtils.Utype) == false)
{
responder.WriteErroredMsg("此预订已结束,无法预订!");
return;
}
Trade trade = TradeManager.GetTrade(bookingtrade.Tradeid);
if (trade == null)
{
responder.WriteErroredMsg("不存在此菜单项,无法预订!");
return;
}
IList<Bookingtrade> confirmList = BookingtradeManager.GetBookingtrade(bookingshop.Id, trade.Id, true);
Bookingtrade confirm = null;
int uid = PageUtils.AccountID;
string rname = PageUtils.RealName;
for (int i = 0; i < confirmList.Count; i++)
{
if (withUid > 0 && withUid == confirmList[i].Uid)
{
confirm = confirmList[i];
break;
}
if (withUid <= 0 && uid == confirmList[i].Uid)
{
confirm = confirmList[i];
break;
}
}
int rlt = 0;
bool isAdd = false;
using (DbTransaction trans = DbHelper.BeginTransaction())
{
bool writeError = false;
try
{
User user = null;
Deduction deduction = new Deduction();
int addedCount = 0;
if (confirm != null && (withUid <= 0 || withUid == confirm.Uid))
{
addedCount = bookingtrade.Tradecount;
user = UserManager.GetUser(confirm.Uid, trans);
if (user == null)
{
writeError = true;
trans.Rollback();
responder.WriteErroredMsg("不存在此用户,无法预订!");
return;
}
if (user.Enabled == false)
{
writeError = true;
trans.Rollback();
responder.WriteErroredMsg(user.Realname + " 处于禁用状态,无法预订!");
return;
}
uid = user.Uid;
rname = user.Realname;
deduction.Deductionbalance = user.Balance - confirm.Tradevalue * addedCount;
deduction.Deductioncount = addedCount;
deduction.Deductionname = string.Format("预订{0}", confirm.Tradename);
deduction.Deductiontime = DateTime.Now;
deduction.Deductionvalue = -confirm.Tradevalue * addedCount;
deduction.Uid = confirm.Uid;
deduction.Realname = confirm.Realname;
deduction.Shopid = confirm.Shopid;
deduction.Shopname = confirm.Shopname;
deduction.Remarks = confirm.Remarks;
confirm.Tradecount += addedCount;
bookingtrade = confirm;
isAdd = false;
}
else
{
if (withUid > 0 && uid != withUid)
user = UserManager.GetUser(withUid, trans);
else
user = UserManager.GetUser(uid, trans);
if (user == null)
{
writeError = true;
trans.Rollback();
responder.WriteErroredMsg("不存在此用户,无法预订!");
return;
}
if (user.Enabled == false)
{
writeError = true;
trans.Rollback();
responder.WriteErroredMsg(user.Realname + " 处于禁用状态,无法预订!");
return;
}
if (withUid > 0)
{
bookingtrade.Proxyid = uid;
bookingtrade.Proxyname = rname;
bookingtrade.Remarks += string.Format("由 {0} 代订", rname.Trim());
}
uid = user.Uid;
rname = user.Realname;
bookingtrade.Bookingid = booking.Id;
bookingtrade.Bookingname = booking.Bookingname;
bookingtrade.Handlerid = bookingshop.Uid;
bookingtrade.Handlername = bookingshop.Realname;
bookingtrade.Uid = uid;
bookingtrade.Realname = rname;
bookingtrade.Shopid = bookingshop.Shopid;
bookingtrade.Shopname = bookingshop.Shopname;
bookingtrade.Tradename = trade.Tradename;
bookingtrade.Tradevalue = trade.Tradevalue;
bookingtrade.Issettle = booking.Isbooking == false;
bookingtrade.Bookinttime = DateTime.Now;
if (booking.Bookingtime.Date.Equals(DateTime.Now.Date) == false)
{
bookingtrade.Bookinttime = new DateTime(booking.Bookingtime.Date.Ticks);
bookingtrade.Bookinttime = bookingtrade.Bookinttime.AddHours(DateTime.Now.Hour).AddMinutes(DateTime.Now.Minute).AddSeconds(DateTime.Now.Second);
}
addedCount = bookingtrade.Tradecount;
deduction.Deductionbalance = user.Balance - trade.Tradevalue * addedCount;
deduction.Deductioncount = addedCount;
deduction.Deductionname = string.Format("预订{0}", bookingtrade.Tradename);
deduction.Deductiontime = DateTime.Now;
deduction.Deductionvalue = -bookingtrade.Tradevalue * addedCount;
deduction.Uid = bookingtrade.Uid;
deduction.Realname = bookingtrade.Realname;
deduction.Shopid = bookingtrade.Shopid;
deduction.Shopname = bookingtrade.Shopname;
deduction.Remarks = bookingtrade.Remarks;
isAdd = true;
}
rlt = UserManager.UpdateUserBalance(uid, trade.Tradevalue * addedCount, trans);
if (rlt <= 0)
{
writeError = true;
trans.Rollback();
responder.WriteErroredMsg("扣除余额失败,数据库更新不成功!");
return;
}
rlt = DeductionManager.AddDeduction(deduction, trans);
if (rlt <= 0)
{
writeError = true;
trans.Rollback();
responder.WriteErroredMsg("扣款记录失败,数据库写入不成功!");
return;
}
if (isAdd)
{
rlt = BookingtradeManager.AddBookingtrade(bookingtrade, trans);
}
else
{
rlt = BookingtradeManager.UpdateBookingtrade(bookingtrade, trans);
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
if (writeError == false)
{
responder.WriteErroredMsg("预订失败,程序异常!");
}
return;
}
}
if (rlt <= 0)
{
if(isAdd)
responder.WriteErroredMsg("预订失败,数据库写入不成功!");
else
responder.WriteErroredMsg("预订失败,数据库更新不成功!");
return;
}
if (isAdd)
responder.WriteSuccessedMsg("提交成功,预订项已添加!");
else
responder.WriteSuccessedMsg("提交成功,预订项已更新!");
}