protected void BindData()
{
lgk.Model.tb_Order model = ob.GetModel("OrderCode='" + getStringRequest("oid") + "'");
lgk.Model.tb_user user = userBLL.GetModel(" UserID=" + model.UserID);
string orderID = getStringRequest("oid") == null ? "" : getStringRequest("oid");
string UserCode = user.UserCode == null ? "" : user.UserCode;
string TrueName = user.TrueName == null ? "" : user.TrueName;
string UserAddr = model.UserAddr == null ? "" : model.UserAddr;
string OrderTotal = model.OrderTotal.ToString() == null ? "" : model.OrderTotal.ToString();
string order3 = model.Order3 == null ? "" : model.Order3;
string order4 = model.Order4 == null ? "" : model.Order4;
Label1.Text = orderID; //订单号
Label2.Text = UserCode; //代理编号
Label3.Text = model.Order7; //代理姓名
Label4.Text = UserAddr; //收货地址
// Label5.Text = OrderTotal;//总额
Label6.Text = order3; //快递公司
Label7.Text = order4; //快递单号
// bind_repeater(GetDetail(getStringRequest("oid")), rptOrder, "OrderDate desc", null, AspNetPager1);
//int typeid = 0;
//var pmodel = produceTypeBLL.GetModel("Type02 = 1");
//if (pmodel != null)
// typeid = pmodel.ID;
if (model.TypeID == 0) //如果等于促销类
{
bind_repeater(GetDetail(getStringRequest("oid")), Repeater1, "OrderDate desc", null, AspNetPager1);
}
else
{
bind_repeater(GetDetail(getStringRequest("oid"), 5), Repeater1, "OrderDate desc", null, AspNetPager1);
}
}
protected void ShowInfo(string order)
{
lgk.Model.tb_Order orderInfo = orderBLL.GetModelByCode(order);
if (orderInfo != null)
{
int iSendType = orderInfo.IsSend;
lgk.Model.tb_user user = userBLL.GetModel(" UserID=" + orderInfo.UserID);
ltOrderCode.Text = orderInfo.OrderCode;//订单号
ltAddTime.Text = orderInfo.OrderDate.ToString();
ltStateName.Text = OrderStateName(iSendType);
hdoid.Value = orderInfo.OrderID.ToString();
hdsend.Value = iSendType.ToString();
ltPhone.Text = orderInfo.Order6 == null ? "" : orderInfo.Order6; //手机号码
ltUserName.Text = orderInfo.Order7 == null ? "" : orderInfo.Order7; //收货人姓名
ltAddress.Text = orderInfo.UserAddr == null ? "" : orderInfo.UserAddr; //收货地址
ltTotalAmount.Text = orderInfo.OrderTotal.ToString() == null ? "" : orderInfo.OrderTotal.ToString(); //总额
ltGongsi.Text = orderInfo.Order3 == null ? "" : orderInfo.Order3; //快递公司
ltDanhao.Text = orderInfo.Order4 == null ? "" : orderInfo.Order4; //快递单号
if (orderInfo.Order5 == "")
{
orderInfo.Order5 = "1";
}
var model = agent1BLL.GetModel(agent1BLL.GetAgentsIDByUserCode(userBLL.GetModel(long.Parse(orderInfo.Order5)).UserCode));
Literal1.Text = model.AgentCode;
Literal2.Text = model.PicLink;
}
bind_repeater(orderDetailBLL.GetGoodsListAll(" d.OrderCode=" + order), Repeater1, "OrderDate desc", tr1);
}
/// <summary>
/// 奖金结算
/// </summary>
/// <param name="order"></param>
protected void BounsCalc(lgk.Model.tb_Order order)
{
int totalPV = (int)order.PVTotal;
decimal orderTotal = order.OrderTotal;
//慈善基金(每笔订单，公司捐一元)
int UploadUser = 0;
string RecUserCode = string.Empty;
var orderdetail = orderDetailBLL.GetModelList(string.Format(" OrderCode = '{0}'", order.OrderCode));
foreach (var detail in orderdetail)
{
if (order.TypeID == 0)
{
var goods = goodsBLL.GetModel(detail.ProcudeID);
UploadUser = goods.UploadUser;
RecUserCode = goods.UserCode;
}
else
{
//var goods = goods_cxthBLL.GetModel(detail.ProcudeID);
//UploadUser = goods.UploadUser;
//RecUserCode = goods.UserCode;
}
}
var userModel = userBLL.GetModel(order.UserID);
//累加BV值
userBLL.Update(userModel);
////招商奖（3%的BV返还给推荐商品的会员编号）
//int pv = totalPV;
//if (pv > 0)
//{
// lgk.Model.tb_goods goods = tb_goodsBLL.GetModel(orderDetailModel.ProcudeID);
// if (goods != null && string.IsNullOrEmpty(goods.UserCode) == false)
// {
// lgk.Model.tb_user recommandUser = userBLL.GetModelByUserCode(goods.UserCode);
// if (recommandUser != null)
// {
// decimal add_bv = (decimal)Math.Round(pv * 0.03, 2);
// recommandUser.Bv += add_bv;
// userBLL.Update(recommandUser);
// }
// }
//}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "tb_Order";
* parameters[1].Value = "OrderID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion Method
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_Order GetModel(string strwhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from tb_Order ");
if (strwhere != null)
{
strSql.Append(" where " + strwhere);
}
lgk.Model.tb_Order model = new lgk.Model.tb_Order();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_Order GetModelByCode(string strOrderCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from tb_Order ");
strSql.Append(" where OrderCode=@OrderCode");
SqlParameter[] parameters =
{
new SqlParameter("@OrderCode", SqlDbType.VarChar, 50)
};
parameters[0].Value = strOrderCode;
lgk.Model.tb_Order model = new lgk.Model.tb_Order();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_Order GetModel(long OrderID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OrderID,UserID,OrderCode,UserAddr,OrderSum,OrderTotal,PVTotal,OrderDate,IsSend,PayMethod,OrderType,Order1,Order2,Order3,Order4,Order5,Order6,Order7,TypeID,PareTopChild,BaodanOrder,IsDel,SendDate from tb_Order ");
strSql.Append(" where OrderID=@OrderID");
SqlParameter[] parameters =
{
new SqlParameter("@OrderID", SqlDbType.BigInt)
};
parameters[0].Value = OrderID;
lgk.Model.tb_Order model = new lgk.Model.tb_Order();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public bool GoodsCartPay(long userid, int paytype, long addrid, string strcid, string aa, out string msg)
{
string[] arr = strcid.Split(',');
LogHelper.SaveLog(strcid, "GoodsCartPay");
if (arr.Length <= 0)
{
msg = "传递的ID无数据";
return(false);
}
Random rand = new Random();
string orderCode = DateTime.Now.ToString("yyyyMMddhhmmss") + rand.Next(10000, 99999); //订单编号
string goodsname = string.Format("订单号{0}，", orderCode);
decimal totalMoney = 0;
int orderSum = 0;
int insert = 0;
DateTime dtime = DateTime.Now;
if (!userBLL.Exists(userid))
{
msg = "用户不存在";
return(false);
}
if (paytype != 1)
{
msg = "支付类型错误";
return(false);
}
lgk.Model.tb_Address addrModel = addressBLL.GetModel(addrid);
if (addrModel == null)
{
msg = "请选择收货地址";
return(false);
}
IList <lgk.Model.tb_goodsCar> listCar = new List <lgk.Model.tb_goodsCar>();
#region 验证商品
string errmsg = "";
foreach (var strID in arr)
{
long id = 0;
long.TryParse(strID, out id);
lgk.Model.tb_goodsCar carModel = goodsCarBLL.GetModel(id);
if (carModel != null)
{
lgk.Model.tb_goods goodsModel = goodsBLL.GetModelAndOneName(carModel.GoodsID); //根据发布商品编号找到充值账号密码
if (goodsModel.StateType == 0) //判断是否 审核通过 0未审核
{
errmsg = "商品" + goodsModel.GoodsName + "审核未通过,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods003 == "1") //判断是否 删除 1已经删除
{
errmsg = "商品" + goodsModel.GoodsName + "已被删除,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods001 == 0) //判断是否 0下架
{
errmsg = "商品" + goodsModel.GoodsName + "已经下架,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods002 < carModel.Goods006) //判断库存量
{
errmsg = "商品" + goodsModel.GoodsName + "库存不足,请重新修改数量!";
insert = 0;
break;
}
else if (carModel.BuyUser != userid) //判断库存量
{
errmsg = "用户不匹配，请刷新购物车再提交!";
insert = 0;
break;
}
listCar.Add(carModel);
insert += 1;
}
else
{
msg = "购物出为空";
LogHelper.SaveLog(id.ToString() + "," + errmsg, "GoodsCartPay");
return(false);
}
}
if (insert == 0)
{
msg = errmsg;
return(false);
}
#endregion
//总金额
totalMoney += listCar.Sum(s => s.TotalMoney);
lgk.Model.tb_user userModel = userBLL.GetModel(userid);
//支付方式
string[] aw = aa.Split('-');
//if (!userBLL.Exists(long.Parse(aw[2])))
//{
// msg = "运营中心不存在";
// return false;
//}
string sql = "select OrderID from tb_Order where UserID=" + userModel.UserID;
var mo = userBLL.getData_Chaxun(sql, "").Tables[0];
if (aw[0] == "1")
{
//if (mo.Rows.Count > 0)
//{
// msg = "请选择复投产品";
// return false;
//}
if (aw[1] == "2")
{
if (userModel.StockMoney < totalMoney / 2 || userModel.StockAccount < totalMoney / 2)
{
msg = "报单积分、电子积分余额不足";
return(false);
}
}
else
{
if (userModel.StockAccount < totalMoney)
{
msg = "报单积分余额不足";
return(false);
}
}
}
else if (aw[0] == "2")
{
if (userModel.AllBonusAccount < totalMoney)
{
msg = "种子积分余额不足";
return(false);
}
}
else if (aw[0] == "3")
{
if (userModel.StockMoney < totalMoney / 2 || userModel.StockAccount < totalMoney / 2)
{
msg = "报单积分、电子积分余额不足";
return(false);
}
}
else if (aw[0] == "4")
{
if (userModel.BonusAccount < totalMoney)
{
msg = "消费积分余额不足";
return(false);
}
}
#region 订单处理
//总订单
lgk.Model.tb_Order orderModel = new lgk.Model.tb_Order(); //订单
orderModel.UserID = userid; //用户
orderModel.OrderCode = orderCode; //订单编号
orderModel.OrderSum = orderSum; //订单数--
orderModel.OrderTotal = totalMoney; //购买总金
orderModel.PVTotal = totalMoney * getParamAmount("hongbao1"); //
orderModel.OrderDate = dtime;
orderModel.IsSend = 1;
orderModel.PayMethod = 1; //--
orderModel.Order5 = ""; //运营中心UserID
orderModel.UserAddr = addrModel.Address; //发货地址
orderModel.Order6 = addrModel.PhoneNum; //收货电话
orderModel.Order7 = addrModel.MemberName; //收货姓名
orderModel.OrderType = int.Parse(aw[0]); //1:
int fenrun = 0;
foreach (var carModel in listCar)
{
lgk.Model.tb_goods goodsModel = goodsBLL.GetModelAndOneName(carModel.GoodsID); //根据发布商品编号找到充值账号密码
lgk.Model.tb_goods goodsModel1 = goodsBLL.GetModel(carModel.GoodsID); //插入订单详细表
lgk.Model.tb_OrderDetail orderDetailModel = new lgk.Model.tb_OrderDetail();
orderDetailModel.OrderCode = orderCode;
orderDetailModel.Price = carModel.RealityPrice; //单价--
orderDetailModel.OrderSum = carModel.Goods006; //数量--
orderDetailModel.OrderTotal = carModel.Goods006 * carModel.RealityPrice; //订单金额
orderDetailModel.PV = 0; //
orderDetailModel.PVTotal = 0;
orderDetailModel.ProcudeID = carModel.GoodsID; //产品编号--
orderDetailModel.ProcudeName = carModel.GoodsName; //名称--
orderDetailModel.gColor = carModel.gColor;
orderDetailModel.gSize = carModel.gSize;
orderDetailModel.OrderDate = dtime; //
orderDetailBLL.Add(orderDetailModel); //加入订单详情
fenrun += goodsModel1.IsHave * carModel.Goods006; //计算分润单位
//修改库存
goodsModel.Goods002 = goodsModel.Goods002 - carModel.Goods006; //修改库存
goodsModel.SaleNum += carModel.Goods006;
goodsBLL.Update(goodsModel);
//从购物篮减掉
goodsCarBLL.Delete(carModel.ID);
//商品名称 流水表记录用
goodsname += orderDetailModel.ProcudeName + "|";
orderSum += carModel.Goods006;
}
orderModel.BaodanOrder = fenrun;
//if (aw[3]=="1")//自提
//{
// orderModel.Order3 = "自提";
// orderModel.Order4 = "自提";
//}
#endregion
//if (aw[1]=="2")//种子积分
//{
// orderModel.Order3 = "种子积分购买无发货信息！";
// orderModel.Order4= "种子积分购买无发货信息！";
// orderModel.IsSend = 3;
// long iOrderID = orderBLL.Add(orderModel);//加入订单表
//}
//else
//{
long iOrderID = orderBLL.Add(orderModel);//加入订单表
//}
#region 写入到明细表
if (aw[0] == "1")
{
if (aw[1] == "2")
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney / 2; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
if (aw[0] == "2") //50%电子积分+50%消费积分
{
joModel.JournalType = 2; //币种
joModel.BalanceAmount = userModel.StockMoney - totalMoney / 2; //余额
}
journalBLL.Add(joModel);
///---------------------------
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney / 2; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
if (aw[0] == "2") //50%电子积分+50%消费积分
{
joModel.JournalType = 5; //币种
joModel.BalanceAmount = userModel.StockAccount - totalMoney / 2; //余额
}
journalBLL.Add(joModel);
UpdateAccount("StockMoney", userModel.UserID, totalMoney / 2, 0);
UpdateAccount("StockAccount", userModel.UserID, totalMoney / 2, 0);
}
else
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 5; //币种
joModel.BalanceAmount = userModel.StockAccount - totalMoney; //余额
journalBLL.Add(joModel);
UpdateAccount("StockAccount", userModel.UserID, totalMoney, 0);
}
}
else if (aw[0] == "2")
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 4; //币种
joModel.BalanceAmount = userModel.AllBonusAccount - totalMoney; //余额
UpdateAccount("AllBonusAccount", userModel.UserID, totalMoney, 0);
journalBLL.Add(joModel);
}
else if (aw[0] == "3")
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney / 2; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 2; //币种子电子积分
joModel.BalanceAmount = userModel.StockMoney - totalMoney / 2; //余额
journalBLL.Add(joModel);
///---------------------------报单积分扣钱
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney / 2; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 5; //币种
joModel.BalanceAmount = userModel.StockAccount - totalMoney / 2; //余额
journalBLL.Add(joModel);
UpdateAccount("StockMoney", userModel.UserID, totalMoney / 2, 0);
UpdateAccount("StockAccount", userModel.UserID, totalMoney / 2, 0);
}
else if (aw[0] == "4")
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 3; //币种
joModel.BalanceAmount = userModel.BonusAccount - totalMoney; //余额
UpdateAccount("BonusAccount", userModel.UserID, totalMoney, 0);
journalBLL.Add(joModel);
}
else
{
msg = "支付失败，支付方式不正确！";
return(false);
}
//---激活会员
lgk.Model.tb_user user = userBLL.GetModel(orderModel.UserID);
if (user.IsOpend != 2)
{
string a = Luodian(orderModel.UserID);
string[] ID = a.Split('-');//ID[0]=UserID ID[1]=Location ID[2]=ParentID ID[3]=ParentCode ID[4]=Layer
var l = userBLL.GetModel(int.Parse(ID[2]));
//user.RecommendPath = model_1.RecommendPath + "-" + user.UserID.ToString();
user.ParentID = 0; //父节点ID
user.ParentCode = ""; //父节点編號
user.UserPath = "";
user.Layer = 0; //属于多少层
user.Location = 0;
user.ParentID = int.Parse(ID[2]); //父节点ID
user.ParentCode = ID[3]; //父节点編號
user.UserPath = l.UserPath + "-" + user.UserID;
user.Layer = int.Parse(ID[4]); //属于多少层
user.Location = int.Parse(ID[1]);
user.OpenTime = DateTime.Now;
user.IsOpend = 2;
userBLL.Update(user);
}
//开关报单
MySQL(string.Format(" exec proc_Kaiguan " + orderModel.UserID + "," + orderModel.OrderCode + ""));
//报单开关
//---激活会员
if (aw[0] != "4")
{
MySQL(string.Format(" exec proc_YejiUp " + orderModel.UserID + "," + orderModel.OrderTotal + ""));//加业绩
MySQL(string.Format(" exec proc_Fenxiangjiang " + orderModel.UserID + "," + orderModel.OrderTotal + ""));
MySQL(string.Format(" exec proc_Xiaocengjiang " + orderModel.UserID + ""));
MySQL(string.Format(" exec proc_Xiaoliangjiang " + orderModel.UserID + ""));
MySQL(string.Format(" exec proc_Jiandianjiang " + orderModel.UserID + "," + orderModel.OrderTotal + ",1"));
//发奖
#region 报单中心（20套）改为4万元
if (orderModel.OrderTotal >= getParamInt("Fuwu2"))//报单中心（20套）
{
int t = agentBLL.GetIDByIDUser(orderModel.UserID);
if (t == 0)//插入用户
{
var userModel1 = userBLL.GetModel(orderModel.UserID);
lgk.Model.tb_agent model = new lgk.Model.tb_agent();
model.UserID = userModel1.UserID;
model.AgentCode = userModel1.UserCode;
model.Flag = 1;
model.AgentType = 1;
model.Agent003 = userModel1.TrueName;
model.AppliTime = DateTime.Now;
model.JoinMoney = 0;
model.Agent004 = "";
model.Agent001 = 0;
model.Agent002 = 0;
model.PicLink = "";
agentBLL.Add(model);
var model1 = userBLL.GetModel(userModel1.UserID);
model1.AgentsID = agentBLL.GetIDByIDUser(userModel1.UserID);
model1.IsAgent = 1;
userBLL.Update(model1);
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = userModel1.UserID;
journalInfo.Remark = "一次性购买 " + getParamInt("Fuwu2") + "元的产品，成为服务网点";
journalInfo.RemarkEn = "Cash withdrawal";
journalInfo.InAmount = 0;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(userModel1.UserID, "StockMoney");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = 2;
journalInfo.Journal01 = userModel1.UserID;
journalBLL.Add(journalInfo);
}
}
userid = orderModel.UserID;
totalMoney = orderModel.OrderTotal;
#endregion
if (getParamInt("Fuwu") == 1)
{
//报单中心奖
long BD_UserID = userBLL.GetUserID(userBLL.GetModel(orderModel.UserID).User006);
decimal BD = getParamAmount("Fuwu1") / 100 * totalMoney;
int isLock = userBLL.GetModel(BD_UserID).IsLock;
int Ag = userBLL.GetModel(BD_UserID).IsAgent;
if (isLock == 0 && Ag == 1)
{
decimal shouxufei = BD * getParamAmount("PingTai") / 100;
BD -= shouxufei;
decimal Gongyi = BD * getParamAmount("PingTai1") / 100;
BD -= Gongyi;
decimal jiangjin = getParamAmount("JJ");
decimal zhongzi = getParamAmount("ZZ");
decimal xiaofei = getParamAmount("XF");
decimal JJ = BD * jiangjin / 100;
decimal ZZ = BD * zhongzi / 100;
decimal XF = BD * xiaofei / 100;
UpdateAccount("Emoney", BD_UserID, JJ, 1); //奖金
UpdateAccount("StockMoney", BD_UserID, ZZ, 1); //电子
UpdateAccount("ShopAccount", BD_UserID, shouxufei, 1); //奖金
UpdateAccount("GLmoney", BD_UserID, Gongyi, 1); //电子
if (XF > 0)
{
UpdateAccount("BonusAccount", BD_UserID, XF, 1);//消费
lgk.Model.tb_journal journal1 = new lgk.Model.tb_journal();
journal1.UserID = BD_UserID;
journal1.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除平台手续费" + shouxufei + ",扣除公益基金" + Gongyi + " ,剩余" + xiaofei + "%进入消费积分";
journal1.RemarkEn = "";
journal1.InAmount = XF;
journal1.OutAmount = 0;
journal1.BalanceAmount = userBLL.GetMoney(BD_UserID, "BonusAccount");;
journal1.JournalDate = DateTime.Now;
journal1.JournalType = 3;
journal1.Journal01 = 0;
journalBLL.Add(journal1);
}
lgk.Model.tb_journal journal = new lgk.Model.tb_journal();
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除平台手续费" + shouxufei + ",扣除公益基金" + Gongyi + " ,剩余" + jiangjin + "%进入奖金积分";
journal.RemarkEn = "";
journal.InAmount = JJ;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "Emoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 1;
journal.Journal01 = 0;
journalBLL.Add(journal);
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除平台手续费" + shouxufei + ",扣除公益基金" + Gongyi + " ,剩余" + zhongzi + "%进入电子积分";
journal.RemarkEn = "";
journal.InAmount = ZZ;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "StockMoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 2;
journal.Journal01 = 0;
journalBLL.Add(journal);
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除平台手续费" + shouxufei + "";
journal.RemarkEn = "";
journal.InAmount = shouxufei;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "ShopAccount");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 6;
journal.Journal01 = 0;
journalBLL.Add(journal);
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除公益基金" + Gongyi + "";
journal.RemarkEn = "";
journal.InAmount = Gongyi;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "GLmoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 7;
journal.Journal01 = 0;
journalBLL.Add(journal);
SqlConnection conn = new SqlConnection(sconn);
conn.Open();
string sql_Add = "insert into tb_bonus(UserID,TypeID,Amount,Revenue,sf,AddTime,IsSettled,Source,SourceEn,SttleTime,FromUserID,Bonus005,Bonus006)";
sql_Add += "values (" + BD_UserID + ",5," + (BD + shouxufei + Gongyi) + "," + shouxufei + "," + BD + ",getdate(),1,'" + journal.Remark + "','',getdate()," + userid + "," + jiangjin + "," + zhongzi + ");";
SqlCommand cmd = new SqlCommand(sql_Add, conn);
int reInt = cmd.ExecuteNonQuery();
conn.Close();
}
}
}
else
{
MySQL(string.Format(" exec proc_Jiandianjiang " + orderModel.UserID + "," + orderModel.OrderTotal + ",2"));
}
msg = "支付成功";
return(true);
}
protected void rpOrderList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
long iID = Convert.ToInt64(e.CommandArgument);
lgk.Model.tb_Order orderModel = orderBLL.GetModel(iID);
if (e.CommandName.Equals("cancel"))
{
if (orderModel != null)
{
if (orderModel.IsDel == 0)
{
orderModel.IsDel = 1;
if (orderBLL.Update(orderModel))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('订单取消成功!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('订单取消失败!');", true);
return;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单已取消!');", true);
return;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单记录不存在!');", true);
return;
}
}
else if (e.CommandName.Equals("sure"))
{
if (orderModel != null)
{
if (orderModel.IsSend == 3)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单已收货!');", true);
return;
}
else if (orderModel.IsSend == 1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单未发货!');", true);
return;
}
else
{
orderModel.IsSend = 3;
if (orderBLL.Update(orderModel))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('收货成功!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('收货失败!');", true);
return;
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单记录不存在!');", true);
return;
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_Order DataRowToModel(DataRow row)
{
lgk.Model.tb_Order model = new lgk.Model.tb_Order();
if (row != null)
{
if (row["OrderID"] != null && row["OrderID"].ToString() != "")
{
model.OrderID = long.Parse(row["OrderID"].ToString());
}
if (row["UserID"] != null && row["UserID"].ToString() != "")
{
model.UserID = long.Parse(row["UserID"].ToString());
}
if (row["OrderCode"] != null)
{
model.OrderCode = row["OrderCode"].ToString();
}
if (row["UserAddr"] != null)
{
model.UserAddr = row["UserAddr"].ToString();
}
if (row["OrderSum"] != null && row["OrderSum"].ToString() != "")
{
model.OrderSum = int.Parse(row["OrderSum"].ToString());
}
if (row["OrderTotal"] != null && row["OrderTotal"].ToString() != "")
{
model.OrderTotal = decimal.Parse(row["OrderTotal"].ToString());
}
if (row["PVTotal"] != null && row["PVTotal"].ToString() != "")
{
model.PVTotal = decimal.Parse(row["PVTotal"].ToString());
}
if (row["OrderDate"] != null && row["OrderDate"].ToString() != "")
{
model.OrderDate = DateTime.Parse(row["OrderDate"].ToString());
}
if (row["IsSend"] != null && row["IsSend"].ToString() != "")
{
model.IsSend = int.Parse(row["IsSend"].ToString());
}
if (row["PayMethod"] != null && row["PayMethod"].ToString() != "")
{
model.PayMethod = int.Parse(row["PayMethod"].ToString());
}
if (row["OrderType"] != null && row["OrderType"].ToString() != "")
{
model.OrderType = int.Parse(row["OrderType"].ToString());
}
if (row["Order1"] != null && row["Order1"].ToString() != "")
{
model.Order1 = decimal.Parse(row["Order1"].ToString());
}
if (row["Order2"] != null && row["Order2"].ToString() != "")
{
model.Order2 = decimal.Parse(row["Order2"].ToString());
}
if (row["Order3"] != null)
{
model.Order3 = row["Order3"].ToString();
}
if (row["Order4"] != null)
{
model.Order4 = row["Order4"].ToString();
}
if (row["Order5"] != null)
{
model.Order5 = row["Order5"].ToString();
}
if (row["Order6"] != null)
{
model.Order6 = row["Order6"].ToString();
}
if (row["Order7"] != null)
{
model.Order7 = row["Order7"].ToString();
}
if (row["TypeID"] != null && row["TypeID"].ToString() != "")
{
model.TypeID = int.Parse(row["TypeID"].ToString());
}
if (row["PareTopChild"] != null)
{
model.PareTopChild = row["PareTopChild"].ToString();
}
if (row["BaodanOrder"] != null && row["BaodanOrder"].ToString() != "")
{
model.BaodanOrder = int.Parse(row["BaodanOrder"].ToString());
}
if (row["IsDel"] != null && row["IsDel"].ToString() != "")
{
model.IsDel = int.Parse(row["IsDel"].ToString());
}
if (row["SendDate"] != null && row["SendDate"].ToString() != "")
{
model.SendDate = DateTime.Parse(row["SendDate"].ToString());
}
}
return(model);
}
public bool GoodsCartPay(long userid, int paytype, long addrid, string strcid, int shtype, out string msg)
{
if (paytype != 4)
{
msg = "请选择正确的支付方式";
return(false);
}
if (shtype <= 0)
{
msg = "请选择正确的收货方式";
return(false);
}
if (!userBLL.Exists(userid))
{
msg = "请重新登录再支付";
return(false);
}
JavaScriptSerializer js = new JavaScriptSerializer();
var list = js.Deserialize <List <GetGoods> >(strcid);
LogHelper.SaveLog(strcid, "GoodsCartPay");
if (list.Count <= 0)
{
msg = "请选择购物车中的商品";
return(false);
}
Random rand = new Random();
string orderCode = DateTime.Now.ToString("yyyyMMddhhmmss") + rand.Next(10000, 99999); //订单编号
string goodsname = string.Format("订单号{0}，", orderCode);
decimal totalMoney = 0;
int orderSum = 0;
int insert = 0;
DateTime dtime = DateTime.Now;
if (!userBLL.Exists(userid))
{
msg = "用户不存在";
}
//if (addrid!=1)
//{
// lgk.Model.tb_Address addrModel = addressBLL.GetModel(addrid);
// if(addrModel == null)
// {
// msg = "请选择收货地址";
// return false;
// }
//}
IList <lgk.Model.tb_goodsCar> listCar = new List <lgk.Model.tb_goodsCar>();
#region 验证商品
string errmsg = "";
foreach (GetGoods g in list)
{
lgk.Model.tb_goodsCar carModel = goodsCarBLL.GetModel(g.ID);
if (carModel != null)
{
lgk.Model.tb_goods goodsModel = goodsBLL.GetModelAndOneName(carModel.GoodsID);//根据发布商品编号找到充值账号密码
if (goodsModel == null)
{
errmsg = "商品" + goodsModel.GoodsName + "不存在!";
insert = 0;
break;
}
if (g.num <= 0)
{
errmsg = "商品" + goodsModel.GoodsName + "的购买数量必须大于0!";
insert = 0;
break;
}
if (goodsModel.StateType == 0) //判断是否 审核通过 0未审核
{
errmsg = "商品" + goodsModel.GoodsName + "审核未通过,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods003 == "1") //判断是否 删除 1已经删除
{
errmsg = "商品" + goodsModel.GoodsName + "已被删除,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods001 == 0) //判断是否 0下架
{
errmsg = "商品" + goodsModel.GoodsName + "已经下架,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods002 < g.num) //判断库存量
{
errmsg = "商品" + goodsModel.GoodsName + "库存不足,请重新修改数量!";
insert = 0;
break;
}
else if (carModel.BuyUser != userid) //
{
errmsg = "用户不匹配，请刷新购物车再提交!";
insert = 0;
break;
}
carModel.Goods006 = g.num;//以最中传输的数量为准
listCar.Add(carModel);
insert += 1;
}
else
{
msg = "购物出为空";
LogHelper.SaveLog(g.ID.ToString() + "," + errmsg, "GoodsCartPay");
return(false);
}
}
if (insert == 0)
{
msg = errmsg;
return(false);
}
#endregion
//总金额
totalMoney += listCar.Sum(s => s.TotalMoney);
orderSum += listCar.Sum(s => s.Goods006);
lgk.Model.tb_user userModel = userBLL.GetModel(userid);
//var dt = orderBLL.GetList(" UserID=" + userid ).Tables[0];
//if (pay == 1 && dt.Rows.Count>0)
//{
//} sss
//else if (pay == 2 && dt.Rows.Count == 0)
//{
//}
if (paytype == 4 && userModel.GLmoney < totalMoney)
{
msg = "购物分余额不足";
return(false);
}
#region 订单处理
//总订单
lgk.Model.tb_Order orderModel = new lgk.Model.tb_Order(); //订单
orderModel.UserID = userid; //用户
orderModel.OrderCode = orderCode; //订单编号
orderModel.OrderSum = orderSum; //订单数--
orderModel.OrderTotal = totalMoney; //购买总金
orderModel.PVTotal = 0; //
orderModel.OrderDate = dtime;
orderModel.IsSend = 1;
orderModel.PayMethod = 3; //--2、复投 1注册激活,3购物分
orderModel.Order5 = ""; //备用电话
orderModel.UserAddr = userModel.Address; //addrModel.Address;//发货地址
orderModel.Order6 = userModel.PhoneNum; //addrModel.PhoneNum;//收货电话
orderModel.Order7 = userModel.NiceName; //addrModel.MemberName;//收货姓名
orderModel.OrderType = paytype; //购物分
orderModel.ReceiveType = shtype;
long iOrderID = orderBLL.Add(orderModel); //加入订单表
foreach (var carModel in listCar)
{
lgk.Model.tb_goods goodsModel = goodsBLL.GetModelAndOneName(carModel.GoodsID);//根据发布商品编号找到充值账号密码
//插入订单详细表
lgk.Model.tb_OrderDetail orderDetailModel = new lgk.Model.tb_OrderDetail();
orderDetailModel.OrderCode = orderCode;
orderDetailModel.Price = carModel.RealityPrice; //单价--
orderDetailModel.OrderSum = carModel.Goods006; //数量--
orderDetailModel.OrderTotal = carModel.Goods006 * carModel.RealityPrice; //订单金额
orderDetailModel.PV = 0; //
orderDetailModel.PVTotal = 0;
orderDetailModel.ProcudeID = carModel.GoodsID; //产品编号--
orderDetailModel.ProcudeName = carModel.GoodsName; //名称--
orderDetailModel.gColor = carModel.gColor;
orderDetailModel.gSize = carModel.gSize;
orderDetailModel.OrderDate = dtime; //
orderDetailBLL.Add(orderDetailModel); //加入订单详情
//修改库存
goodsModel.Goods002 = goodsModel.Goods002 - carModel.Goods006;//修改库存
goodsModel.SaleNum += carModel.Goods006;
goodsBLL.Update(goodsModel);
//从购物篮减掉
goodsCarBLL.Delete(carModel.ID);
//商品名称 流水表记录用
goodsname += orderDetailModel.ProcudeName + "|";
orderSum += carModel.Goods006;
}
#endregion
#region 写入到明细表
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
if (paytype == 4) //购物分
{
joModel.JournalType = 5; //币种
joModel.BalanceAmount = userModel.GLmoney - totalMoney; //余额
journalBLL.Add(joModel);
UpdateAccount("GLmoney", userModel.UserID, totalMoney, 0);
}
//用户账户更新
#endregion
//购物积分购买不给分红点
//执行存储过程
//string procmsg = string.Empty;
//procmsg = proc_BuyOrder(userid, orderModel.OrderSum, orderCode, 4, totalMoney);
//LogHelper.SaveLog("procmsg:" + procmsg, "proc_BuyOrder");
msg = "支付成功";
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_Order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Order set ");
strSql.Append("UserID=@UserID,");
strSql.Append("OrderCode=@OrderCode,");
strSql.Append("UserAddr=@UserAddr,");
strSql.Append("OrderSum=@OrderSum,");
strSql.Append("OrderTotal=@OrderTotal,");
strSql.Append("PVTotal=@PVTotal,");
strSql.Append("OrderDate=@OrderDate,");
strSql.Append("IsSend=@IsSend,");
strSql.Append("PayMethod=@PayMethod,");
strSql.Append("OrderType=@OrderType,");
strSql.Append("Order1=@Order1,");
strSql.Append("Order2=@Order2,");
strSql.Append("Order3=@Order3,");
strSql.Append("Order4=@Order4,");
strSql.Append("Order5=@Order5,");
strSql.Append("Order6=@Order6,");
strSql.Append("Order7=@Order7,");
strSql.Append("TypeID=@TypeID,");
strSql.Append("PareTopChild=@PareTopChild,");
strSql.Append("BaodanOrder=@BaodanOrder,");
strSql.Append("IsDel=@IsDel,");
strSql.Append("SendDate=@SendDate");
strSql.Append(" where OrderID=@OrderID");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@OrderCode", SqlDbType.VarChar, 50),
new SqlParameter("@UserAddr", SqlDbType.VarChar, 100),
new SqlParameter("@OrderSum", SqlDbType.Int, 4),
new SqlParameter("@OrderTotal", SqlDbType.Decimal, 9),
new SqlParameter("@PVTotal", SqlDbType.Decimal, 9),
new SqlParameter("@OrderDate", SqlDbType.DateTime),
new SqlParameter("@IsSend", SqlDbType.Int, 4),
new SqlParameter("@PayMethod", SqlDbType.Int, 4),
new SqlParameter("@OrderType", SqlDbType.Int, 4),
new SqlParameter("@Order1", SqlDbType.Decimal, 9),
new SqlParameter("@Order2", SqlDbType.Decimal, 9),
new SqlParameter("@Order3", SqlDbType.VarChar, 100),
new SqlParameter("@Order4", SqlDbType.VarChar, 100),
new SqlParameter("@Order5", SqlDbType.VarChar, 100),
new SqlParameter("@Order6", SqlDbType.VarChar, 100),
new SqlParameter("@Order7", SqlDbType.VarChar, 100),
new SqlParameter("@TypeID", SqlDbType.Int, 4),
new SqlParameter("@PareTopChild", SqlDbType.VarChar, 100),
new SqlParameter("@BaodanOrder", SqlDbType.Int, 4),
new SqlParameter("@IsDel", SqlDbType.Int, 4),
new SqlParameter("@SendDate", SqlDbType.DateTime),
new SqlParameter("@OrderID", SqlDbType.BigInt, 8)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.OrderCode;
parameters[2].Value = model.UserAddr;
parameters[3].Value = model.OrderSum;
parameters[4].Value = model.OrderTotal;
parameters[5].Value = model.PVTotal;
parameters[6].Value = model.OrderDate;
parameters[7].Value = model.IsSend;
parameters[8].Value = model.PayMethod;
parameters[9].Value = model.OrderType;
parameters[10].Value = model.Order1;
parameters[11].Value = model.Order2;
parameters[12].Value = model.Order3;
parameters[13].Value = model.Order4;
parameters[14].Value = model.Order5;
parameters[15].Value = model.Order6;
parameters[16].Value = model.Order7;
parameters[17].Value = model.TypeID;
parameters[18].Value = model.PareTopChild;
parameters[19].Value = model.BaodanOrder;
parameters[20].Value = model.IsDel;
parameters[21].Value = model.SendDate;
parameters[22].Value = model.OrderID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "tb_Order";
* parameters[1].Value = "OrderID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion Method
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_Order GetModel(string strwhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from tb_Order ");
if (strwhere != null)
{
strSql.Append(" where " + strwhere);
}
lgk.Model.tb_Order model = new lgk.Model.tb_Order();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["OrderID"] != null && ds.Tables[0].Rows[0]["OrderID"].ToString() != "")
{
model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderCode"] != null && ds.Tables[0].Rows[0]["OrderCode"].ToString() != "")
{
model.OrderCode = ds.Tables[0].Rows[0]["OrderCode"].ToString();
}
if (ds.Tables[0].Rows[0]["UserAddr"] != null && ds.Tables[0].Rows[0]["UserAddr"].ToString() != "")
{
model.UserAddr = ds.Tables[0].Rows[0]["UserAddr"].ToString();
}
if (ds.Tables[0].Rows[0]["OrderSum"] != null && ds.Tables[0].Rows[0]["OrderSum"].ToString() != "")
{
model.OrderSum = int.Parse(ds.Tables[0].Rows[0]["OrderSum"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderTotal"] != null && ds.Tables[0].Rows[0]["OrderTotal"].ToString() != "")
{
model.OrderTotal = decimal.Parse(ds.Tables[0].Rows[0]["OrderTotal"].ToString());
}
if (ds.Tables[0].Rows[0]["PVTotal"] != null && ds.Tables[0].Rows[0]["PVTotal"].ToString() != "")
{
model.PVTotal = decimal.Parse(ds.Tables[0].Rows[0]["PVTotal"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderDate"] != null && ds.Tables[0].Rows[0]["OrderDate"].ToString() != "")
{
model.OrderDate = DateTime.Parse(ds.Tables[0].Rows[0]["OrderDate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsSend"] != null && ds.Tables[0].Rows[0]["IsSend"].ToString() != "")
{
model.IsSend = int.Parse(ds.Tables[0].Rows[0]["IsSend"].ToString());
}
if (ds.Tables[0].Rows[0]["PayMethod"] != null && ds.Tables[0].Rows[0]["PayMethod"].ToString() != "")
{
model.PayMethod = int.Parse(ds.Tables[0].Rows[0]["PayMethod"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderType"] != null && ds.Tables[0].Rows[0]["OrderType"].ToString() != "")
{
model.OrderType = int.Parse(ds.Tables[0].Rows[0]["OrderType"].ToString());
}
if (ds.Tables[0].Rows[0]["Order1"] != null && ds.Tables[0].Rows[0]["Order1"].ToString() != "")
{
model.Order1 = decimal.Parse(ds.Tables[0].Rows[0]["Order1"].ToString());
}
if (ds.Tables[0].Rows[0]["Order2"] != null && ds.Tables[0].Rows[0]["Order2"].ToString() != "")
{
model.Order2 = decimal.Parse(ds.Tables[0].Rows[0]["Order2"].ToString());
}
if (ds.Tables[0].Rows[0]["Order3"] != null && ds.Tables[0].Rows[0]["Order3"].ToString() != "")
{
model.Order3 = ds.Tables[0].Rows[0]["Order3"].ToString();
}
if (ds.Tables[0].Rows[0]["Order4"] != null && ds.Tables[0].Rows[0]["Order4"].ToString() != "")
{
model.Order4 = ds.Tables[0].Rows[0]["Order4"].ToString();
}
if (ds.Tables[0].Rows[0]["Order5"] != null && ds.Tables[0].Rows[0]["Order5"].ToString() != "")
{
model.Order5 = ds.Tables[0].Rows[0]["Order5"].ToString();
}
if (ds.Tables[0].Rows[0]["Order6"] != null && ds.Tables[0].Rows[0]["Order6"].ToString() != "")
{
model.Order6 = ds.Tables[0].Rows[0]["Order6"].ToString();
}
if (ds.Tables[0].Rows[0]["Order7"] != null && ds.Tables[0].Rows[0]["Order7"].ToString() != "")
{
model.Order7 = ds.Tables[0].Rows[0]["Order7"].ToString();
}
if (ds.Tables[0].Rows[0]["TypeID"] != null && ds.Tables[0].Rows[0]["TypeID"].ToString() != "")
{
model.TypeID = int.Parse(ds.Tables[0].Rows[0]["TypeID"].ToString());
}
if (ds.Tables[0].Rows[0]["PareTopChild"] != null && ds.Tables[0].Rows[0]["PareTopChild"].ToString() != "")
{
model.PareTopChild = ds.Tables[0].Rows[0]["TypeID"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_Order GetModel(long OrderID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from tb_Order ");
strSql.Append(" where OrderID=@OrderID");
SqlParameter[] parameters =
{
new SqlParameter("@OrderID", SqlDbType.BigInt, 8)
};
parameters[0].Value = OrderID;
lgk.Model.tb_Order model = new lgk.Model.tb_Order();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["OrderID"] != null && ds.Tables[0].Rows[0]["OrderID"].ToString() != "")
{
model.OrderID = long.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderCode"] != null && ds.Tables[0].Rows[0]["OrderCode"].ToString() != "")
{
model.OrderCode = ds.Tables[0].Rows[0]["OrderCode"].ToString();
}
if (ds.Tables[0].Rows[0]["UserAddr"] != null && ds.Tables[0].Rows[0]["UserAddr"].ToString() != "")
{
model.UserAddr = ds.Tables[0].Rows[0]["UserAddr"].ToString();
}
if (ds.Tables[0].Rows[0]["OrderSum"] != null && ds.Tables[0].Rows[0]["OrderSum"].ToString() != "")
{
model.OrderSum = int.Parse(ds.Tables[0].Rows[0]["OrderSum"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderTotal"] != null && ds.Tables[0].Rows[0]["OrderTotal"].ToString() != "")
{
model.OrderTotal = decimal.Parse(ds.Tables[0].Rows[0]["OrderTotal"].ToString());
}
if (ds.Tables[0].Rows[0]["PVTotal"] != null && ds.Tables[0].Rows[0]["PVTotal"].ToString() != "")
{
model.PVTotal = decimal.Parse(ds.Tables[0].Rows[0]["PVTotal"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderDate"] != null && ds.Tables[0].Rows[0]["OrderDate"].ToString() != "")
{
model.OrderDate = DateTime.Parse(ds.Tables[0].Rows[0]["OrderDate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsSend"] != null && ds.Tables[0].Rows[0]["IsSend"].ToString() != "")
{
model.IsSend = int.Parse(ds.Tables[0].Rows[0]["IsSend"].ToString());
}
if (ds.Tables[0].Rows[0]["PayMethod"] != null && ds.Tables[0].Rows[0]["PayMethod"].ToString() != "")
{
model.PayMethod = int.Parse(ds.Tables[0].Rows[0]["PayMethod"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderType"] != null && ds.Tables[0].Rows[0]["OrderType"].ToString() != "")
{
model.OrderType = int.Parse(ds.Tables[0].Rows[0]["OrderType"].ToString());
}
if (ds.Tables[0].Rows[0]["Order1"] != null && ds.Tables[0].Rows[0]["Order1"].ToString() != "")
{
model.Order1 = decimal.Parse(ds.Tables[0].Rows[0]["Order1"].ToString());
}
if (ds.Tables[0].Rows[0]["Order2"] != null && ds.Tables[0].Rows[0]["Order2"].ToString() != "")
{
model.Order2 = decimal.Parse(ds.Tables[0].Rows[0]["Order2"].ToString());
}
if (ds.Tables[0].Rows[0]["Order3"] != null && ds.Tables[0].Rows[0]["Order3"].ToString() != "")
{
model.Order3 = ds.Tables[0].Rows[0]["Order3"].ToString();
}
if (ds.Tables[0].Rows[0]["Order4"] != null && ds.Tables[0].Rows[0]["Order4"].ToString() != "")
{
model.Order4 = ds.Tables[0].Rows[0]["Order4"].ToString();
}
if (ds.Tables[0].Rows[0]["Order5"] != null && ds.Tables[0].Rows[0]["Order5"].ToString() != "")
{
model.Order5 = ds.Tables[0].Rows[0]["Order5"].ToString();
}
if (ds.Tables[0].Rows[0]["Order6"] != null && ds.Tables[0].Rows[0]["Order6"].ToString() != "")
{
model.Order6 = ds.Tables[0].Rows[0]["Order6"].ToString();
}
if (ds.Tables[0].Rows[0]["Order7"] != null && ds.Tables[0].Rows[0]["Order7"].ToString() != "")
{
model.Order7 = ds.Tables[0].Rows[0]["Order7"].ToString();
}
return(model);
}
else
{
return(null);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (getParamInt("Futou") != 1)
{
MessageBox.ShowBox(this.Page, "后台未开启设置", Library.Enums.ModalTypes.error);//后台未开启设置
return;
}
var jine = getParamAmount("Futou1");
int Shuliang;
if (!int.TryParse(TextBox1.Text, out Shuliang))
{
MessageBox.ShowBox(this.Page, "输入正确的数量", Library.Enums.ModalTypes.error); //输入正确的数量
return;
}
string strPayPwd = txtSecondPassword.Text.Trim();
if (string.IsNullOrEmpty(strPayPwd))
{
MessageBox.ShowBox(this.Page, GetLanguage("SecondaryISNUll"), Library.Enums.ModalTypes.warning);//二级密码不能为空
return;
}
lgk.Model.tb_user userModel = userBLL.GetModel(getLoginID());
if (!ValidPassword(userModel.SecondPassword, PageValidate.GetMd5(strPayPwd)))
{
MessageBox.ShowBox(this.Page, "支付密码错误", Library.Enums.ModalTypes.warning);//
return;
}
Random rand = new Random();
string orderCode = DateTime.Now.ToString("yyyyMMddhhmmss") + rand.Next(10000, 99999); //订单编号
string goodsname = string.Format("订单号{0}，", orderCode);
if (userModel.StockMoney - Shuliang * jine < 0 && DropDownList1.SelectedValue == "3")
{
MessageBox.ShowBox(this.Page, "金额不足", Library.Enums.ModalTypes.error); //输入正确的数量
return;
}
else if (userModel.Emoney - Shuliang * jine < 0 && DropDownList1.SelectedValue == "2")
{
MessageBox.ShowBox(this.Page, "金额不足", Library.Enums.ModalTypes.error); //输入正确的数量
return;
}
else if (userModel.Emoney - Shuliang * jine / 2 < 0 && userModel.StockAccount - Shuliang * jine / 2 < 0 && DropDownList1.SelectedValue == "1")
{
MessageBox.ShowBox(this.Page, "金额不足", Library.Enums.ModalTypes.error); //输入正确的数量
return;
}
//总订单
lgk.Model.tb_Order orderModel = new lgk.Model.tb_Order(); //订单
orderModel.UserID = getLoginID(); //用户
orderModel.OrderCode = orderCode; //订单编号
orderModel.OrderSum = Shuliang; //订单数--
orderModel.OrderTotal = Shuliang * jine; //购买总金
orderModel.PVTotal = 0; //
orderModel.OrderDate = DateTime.Now;
orderModel.IsSend = 3;
orderModel.PayMethod = 2; //--复投 1注册激活,3、购物分购物
orderModel.Order5 = ""; //备用电话
orderModel.UserAddr = userModel.Address; //addrModel.Address;//发货地址
orderModel.Order6 = userModel.PhoneNum; //addrModel.PhoneNum;//收货电话
orderModel.Order7 = userModel.NiceName; //addrModel.MemberName;//收货姓名
orderModel.OrderType = int.Parse(DropDownList1.SelectedValue); //1:
long iOrderID = orderBLL.Add(orderModel); //加入订单表
//lgk.Model.tb_OrderDetail orderDetailModel = new lgk.Model.tb_OrderDetail();
//orderDetailModel.OrderCode = orderCode;
//orderDetailModel.Price = jine;//单价--
//orderDetailModel.OrderSum = Shuliang;//数量--
//orderDetailModel.OrderTotal = jine*Shuliang;//订单金额
//orderDetailModel.PV = 0;//
//orderDetailModel.PVTotal = 0;
//orderDetailModel.ProcudeID = 0; //产品编号--
//orderDetailModel.ProcudeName = "复投产品";//名称--
//orderDetailModel.gColor = "";
//orderDetailModel.gSize = "";
//orderDetailModel.OrderDate = DateTime.Now;//
//orderDetailBLL.Add(orderDetailModel);//加入订单详情
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = Shuliang * jine; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
if (DropDownList1.SelectedValue == "3") //混合是 1 注册 2 福利 3
{
joModel.JournalType = 3; //币种
joModel.BalanceAmount = userModel.StockMoney - Shuliang * jine; //余额
journalBLL.Add(joModel);
UpdateAccount("StockMoney", userModel.UserID, Shuliang * jine, 0);
//执行存储过程
string procmsg = string.Empty;
procmsg = proc_BuyOrder(getLoginID(), orderModel.OrderSum, orderCode, 3, Shuliang * jine);
LogHelper.SaveLog("procmsg:" + procmsg, "proc_BuyOrder");
MessageBox.ShowBox(this.Page, "购买成功！", Library.Enums.ModalTypes.success); //输入正确的数量
return;
}
else if (DropDownList1.SelectedValue == "1") //混合 1 + 4
{
joModel.JournalType = 1; //币种
joModel.BalanceAmount = userModel.Emoney - Shuliang * jine / 2; //余额
journalBLL.Add(joModel);
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = Shuliang * jine; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 4; //币种
joModel.BalanceAmount = userModel.StockAccount - Shuliang * jine / 2; //余额
journalBLL.Add(joModel);
UpdateAccount("Emoney", userModel.UserID, Shuliang * jine / 2, 0);
UpdateAccount("StockAccount", userModel.UserID, Shuliang * jine / 2, 0);
string procmsg = string.Empty;
procmsg = proc_BuyOrder(getLoginID(), orderModel.OrderSum, orderCode, 1, Shuliang * jine);
LogHelper.SaveLog("procmsg:" + procmsg, "proc_BuyOrder");
MessageBox.ShowBox(this.Page, "购买成功！", Library.Enums.ModalTypes.success); //输入正确的数量
return;
}
else if (DropDownList1.SelectedValue == "2") //1
{
joModel.JournalType = 1; //币种
joModel.BalanceAmount = userModel.Emoney - Shuliang * jine; //余额
journalBLL.Add(joModel);
UpdateAccount("Emoney", userModel.UserID, Shuliang * jine, 0);
string procmsg = string.Empty;
procmsg = proc_BuyOrder(getLoginID(), orderModel.OrderSum, orderCode, 2, Shuliang * jine);
LogHelper.SaveLog("procmsg:" + procmsg, "proc_BuyOrder");
MessageBox.ShowBox(this.Page, "购买成功！", Library.Enums.ModalTypes.success); //输入正确的数量
return;
}
MessageBox.ShowBox(this.Page, "复投失败！", Library.Enums.ModalTypes.error); //输入正确的数量
return;
//Response.Redirect("/user/Mall/GoodsList.aspx?FT=1");
}
protected void rptOrder_ItemCommand(object source, RepeaterCommandEventArgs e)
{
//long uid = ob.GetModel(ID).UserID;
//tb_OrderDetail od=obd.GetModelByOrderID(ID);
lgk.Model.tb_Order order = ob.GetModelByCode(e.CommandArgument.ToString());
//tb_level level2 = lb.GetModel(2);
//tb_level level3 = lb.GetModel(3);
//int pid = od.ProcudeID; //商品编号
//int pv = pb.GetModel(pid).procudePV*od.OrderSum;
//decimal emoney=od.OrderTotal;
if (order == null)
{
MessageBox.ShowAndRedirect(this, "已经删除过的记录!", "OrderProduct.aspx");
return;
}
if (order.IsDel == 2)
{
MessageBox.ShowAndRedirect(this, "已经删除过的记录!", "OrderProduct.aspx");
return;
}
TextBox txtGongsi = (TextBox)e.Item.FindControl("txtGongsi"); //快递公司
TextBox txtDanhao = (TextBox)e.Item.FindControl("txtDanhao"); //快递单号
LinkButton link = (LinkButton)e.Item.FindControl("LinkButton2"); //编辑按钮
LinkButton linkSave = ((LinkButton)e.Item.FindControl("LinkButton3")); //保存按钮
if (e.CommandName.Equals("enter")) //确认发货
{
if (order.IsSend == 0)
{
MessageBox.ShowAndRedirect(this, "未付款的记录!", "OrderProduct.aspx");
return;
}
if (order.IsSend > 1)
{
MessageBox.ShowAndRedirect(this, "已发货的记录!", "OrderProduct.aspx");
return;
}
#region 1判断当前用户输入的快递名称及单号 2保存快递信息
if (string.IsNullOrEmpty(txtGongsi.Text))
{
MessageBox.Show(this, "发货失败，原因：快递公司不能为空");
return;
}
if (string.IsNullOrEmpty(txtDanhao.Text))
{
MessageBox.Show(this, "发货失败，原因：快递单号不能为空");
return;
}
order.Order3 = txtGongsi.Text;
order.Order4 = txtDanhao.Text;
if (!ob.Update(order))
{
MessageBox.Show(this, "发货失败，原因：保存快递信息失败");
return;
}
#endregion
bool b = true;
if (b)
{
if (string.IsNullOrEmpty(order.Order3) || string.IsNullOrEmpty(order.Order4))
{
MessageBox.ShowAndRedirect(this, "请先填写快递公司和快递单号!", "OrderProduct.aspx");
return;
}
//if (order.OrderType == 3)
//{
// ob.Update(order);
// MessageBox.ShowAndRedirect(this, "发货已成功！\r\n 由于还需要支付宝平台返回验证消息 \r\n 请稍后刷新查看发货状态", "OrderProduct.aspx");
//}
//else
//{
order.IsSend = 2; //已发货
order.SendDate = DateTime.Now; //发货时间 结算奖金以发货时间为准
if (ob.Update(order))
{
MessageBox.ShowAndRedirect(this, "发货已成功!", "OrderProduct.aspx");
}
//}
}
}
if (e.CommandName.Equals("cancel")) //取消订单
{
lgk.Model.tb_user user = ub.GetModel(order.UserID);
try
{
int jType = 0;
if (order.OrderType == 1)//奖金币
{
jType = 1;
user.BonusAccount += order.OrderTotal;
userBLL.Update(user);
add_journal(order.UserID, order.OrderTotal, 0, user.BonusAccount, jType, 99, "取消订单：" + order.OrderCode, "Delete orders", order.UserID);
}
else if (order.OrderType == 2)//重消币
{
jType = 5;
user.StockMoney += order.OrderTotal;
userBLL.Update(user);
add_journal(order.UserID, order.OrderTotal, 0, user.StockMoney, jType, 99, "取消订单：" + order.OrderCode, "Delete orders", order.UserID);
}
else if (order.OrderType == 3)//奖金币和重消币
{
jType = 5;
List <lgk.Model.tb_journal> jList = journalBLL.GetModelList("journal03='" + order.OrderCode + "'");
if (jList.Count > 0)
{
foreach (lgk.Model.tb_journal jModel in jList)
{
if (jModel.JournalType == 1)
{
user.BonusAccount += jModel.OutAmount;
AddJournal(order.UserID, jModel.OutAmount, 0, user.BonusAccount, 1, 99, "取消订单：" + order.OrderCode, "Delete orders", order.UserID);
}
else if (jModel.JournalType == 2)
{
user.StockMoney += jModel.OutAmount;
AddJournal(order.UserID, jModel.OutAmount, 0, user.StockMoney, 5, 99, "取消订单：" + order.OrderCode, "Delete orders", order.UserID);
}
}
}
}
// DeleteByCode(order.OrderCode);
// ob.Delete(order.OrderID);
order.IsDel = 2; //2：订单取消标记，1：申请取消
orderBLL.Update(order);
MessageBox.ShowAndRedirect(this, "取消订单成功!", "OrderProduct.aspx");
}
catch
{
MessageBox.ShowAndRedirect(this, "取消订单失败!", "OrderProduct.aspx");
}
}
if (e.CommandName.Equals("revoke")) //撤销申请
{
try
{
order.IsDel = 0; //2：订单取消标记，1：申请取消
orderBLL.Update(order);
MessageBox.ShowAndRedirect(this, "撤销申请成功!", "OrderProduct.aspx");
}
catch (Exception)
{
MessageBox.ShowAndRedirect(this, "撤销申请失败!", "OrderProduct.aspx");
}
}
if (e.CommandName.Equals("show"))
{
Response.Redirect("OrderDetail_1.aspx?oid=" + order.OrderCode);
}
if (e.CommandName.Equals("edit"))
{
link.Visible = false;
linkSave.Visible = true;
}
/*
* if (e.CommandName.Equals("save"))
* {
*
* if (string.IsNullOrEmpty(txtGongsi.Text))
* {
* MessageBox.Show(this, "快递公司不能为空");
* return;
* }
* if (string.IsNullOrEmpty(txtDanhao.Text))
* {
* MessageBox.Show(this, "快递单号不能为空");
* return;
* }
* order.order3 = txtGongsi.Text;
* order.order4 = txtDanhao.Text;
* // order.IsSend = 2;
* if (ob.Update(order))
* {
* MessageBox.Show(this, "编辑快递信息成功");
* bind();
* }
* else
* {
* MessageBox.Show(this, "编辑快递信息失败");
* }
* }
*/
return;
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.tb_Order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Order(");
strSql.Append("UserID,OrderCode,UserAddr,OrderSum,OrderTotal,PVTotal,OrderDate,IsSend,PayMethod,OrderType,Order1,Order2,Order3,Order4,Order5,Order6,Order7,TypeID,PareTopChild,BaodanOrder,IsDel,SendDate)");
strSql.Append(" values (");
strSql.Append("@UserID,@OrderCode,@UserAddr,@OrderSum,@OrderTotal,@PVTotal,@OrderDate,@IsSend,@PayMethod,@OrderType,@Order1,@Order2,@Order3,@Order4,@Order5,@Order6,@Order7,@TypeID,@PareTopChild,@BaodanOrder,@IsDel,@SendDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@OrderCode", SqlDbType.VarChar, 50),
new SqlParameter("@UserAddr", SqlDbType.VarChar, 100),
new SqlParameter("@OrderSum", SqlDbType.Int, 4),
new SqlParameter("@OrderTotal", SqlDbType.Decimal, 9),
new SqlParameter("@PVTotal", SqlDbType.Decimal, 9),
new SqlParameter("@OrderDate", SqlDbType.DateTime),
new SqlParameter("@IsSend", SqlDbType.Int, 4),
new SqlParameter("@PayMethod", SqlDbType.Int, 4),
new SqlParameter("@OrderType", SqlDbType.Int, 4),
new SqlParameter("@Order1", SqlDbType.Decimal, 9),
new SqlParameter("@Order2", SqlDbType.Decimal, 9),
new SqlParameter("@Order3", SqlDbType.VarChar, 100),
new SqlParameter("@Order4", SqlDbType.VarChar, 100),
new SqlParameter("@Order5", SqlDbType.VarChar, 100),
new SqlParameter("@Order6", SqlDbType.VarChar, 100),
new SqlParameter("@Order7", SqlDbType.VarChar, 100),
new SqlParameter("@TypeID", SqlDbType.Int, 4),
new SqlParameter("@PareTopChild", SqlDbType.VarChar, 100),
new SqlParameter("@BaodanOrder", SqlDbType.Int, 4),
new SqlParameter("@IsDel", SqlDbType.Int, 4),
new SqlParameter("@SendDate", SqlDbType.DateTime)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.OrderCode;
parameters[2].Value = model.UserAddr;
parameters[3].Value = model.OrderSum;
parameters[4].Value = model.OrderTotal;
parameters[5].Value = model.PVTotal;
parameters[6].Value = model.OrderDate;
parameters[7].Value = model.IsSend;
parameters[8].Value = model.PayMethod;
parameters[9].Value = model.OrderType;
parameters[10].Value = model.Order1;
parameters[11].Value = model.Order2;
parameters[12].Value = model.Order3;
parameters[13].Value = model.Order4;
parameters[14].Value = model.Order5;
parameters[15].Value = model.Order6;
parameters[16].Value = model.Order7;
parameters[17].Value = model.TypeID;
parameters[18].Value = model.PareTopChild;
parameters[19].Value = model.BaodanOrder;
parameters[20].Value = model.IsDel;
parameters[21].Value = model.SendDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
protected void rpOrderList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
long iID = Convert.ToInt64(e.CommandArgument);
lgk.Model.tb_Order orderModel = orderBLL.GetModel(iID);
if (e.CommandName.Equals("cancel"))
{
if (orderModel != null)
{
if (orderModel.IsDel == 0)
{
orderModel.IsDel = 1;
if (orderBLL.Update(orderModel))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('订单取消成功!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('订单取消失败!');", true);
return;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单已取消!');", true);
return;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单记录不存在!');", true);
return;
}
}
else if (e.CommandName.Equals("sure"))
{
if (orderModel != null)
{
if (orderModel.IsSend == 3)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单已收货!');", true);
return;
}
else if (orderModel.IsSend == 1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单未发货!');", true);
return;
}
else
{
orderModel.IsSend = 3;
if (orderBLL.Update(orderModel))
{
//发奖
#region 报单中心（20套）改为4万元
if (orderModel.OrderTotal >= getParamInt("Fuwu2"))//报单中心（20套）
{
int a = agentBLL.GetIDByIDUser(orderModel.UserID);
if (a == 0)//插入用户
{
var userModel = userBLL.GetModel(orderModel.UserID);
lgk.Model.tb_agent model = new lgk.Model.tb_agent();
model.UserID = userModel.UserID;
model.AgentCode = userModel.UserCode;
model.Flag = 1;
model.AgentType = 1;
model.Agent003 = userModel.TrueName;
model.AppliTime = DateTime.Now;
model.JoinMoney = 0;
model.Agent004 = "";
model.Agent001 = 0;
model.Agent002 = 0;
model.PicLink = "";
agentBLL.Add(model);
var model1 = userBLL.GetModel(userModel.UserID);
model1.AgentsID = agentBLL.GetIDByIDUser(userModel.UserID);
model1.IsAgent = 1;
userBLL.Update(model1);
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = userModel.UserID;
journalInfo.Remark = "一次性购买 " + getParamInt("Fuwu2") + "元的产品，成为服务网点";
journalInfo.RemarkEn = "Cash withdrawal";
journalInfo.InAmount = 0;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(userModel.UserID, "StockMoney");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = 2;
journalInfo.Journal01 = userModel.UserID;
journalBLL.Add(journalInfo);
}
}
long userid = orderModel.UserID;
decimal totalMoney = orderModel.OrderTotal;
#endregion
if (getParamInt("Fuwu") == 1)
{
//报单中心奖
long BD_UserID = userBLL.GetUserID(userBLL.GetModel(orderModel.UserID).User006);
decimal BD = getParamAmount("Fuwu1") / 100 * totalMoney;
int isLock = userBLL.GetModel(BD_UserID).IsLock;
int Ag = userBLL.GetModel(BD_UserID).IsAgent;
if (isLock == 0 && Ag == 1)
{
decimal shouxufei = BD * getParamAmount("PingTai") / 100;
BD -= shouxufei;
decimal jiangjin = getParamAmount("JJ");
decimal zhongzi = getParamAmount("ZZ");
decimal xiaofei = getParamAmount("XF");
decimal JJ = BD * jiangjin / 100;
decimal ZZ = BD * zhongzi / 100;
decimal XF = BD * xiaofei / 100;
UpdateAccount("Emoney", BD_UserID, JJ, 1); //奖金
UpdateAccount("AllBonusAccount", BD_UserID, ZZ, 1); //种子
if (XF > 0)
{
UpdateAccount("AllBonusAccount", BD_UserID, XF, 1);//种子
lgk.Model.tb_journal journal1 = new lgk.Model.tb_journal();
journal1.UserID = BD_UserID;
journal1.Remark = "服务网点获得" + (BD + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + xiaofei + "%进入消费积分";
journal1.RemarkEn = "";
journal1.InAmount = XF;
journal1.OutAmount = 0;
journal1.BalanceAmount = userBLL.GetMoney(BD_UserID, "BonusAccount");;
journal1.JournalDate = DateTime.Now;
journal1.JournalType = 3;
journal1.Journal01 = 0;
journalBLL.Add(journal1);
}
lgk.Model.tb_journal journal = new lgk.Model.tb_journal();
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + jiangjin + "%进入奖金积分";
journal.RemarkEn = "";
journal.InAmount = JJ;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "Emoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 1;
journal.Journal01 = 0;
journalBLL.Add(journal);
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + zhongzi + "%进入电子积分";
journal.RemarkEn = "";
journal.InAmount = ZZ;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "StockMoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 2;
journal.Journal01 = 0;
journalBLL.Add(journal);
SqlConnection conn = new SqlConnection(sconn);
conn.Open();
string sql_Add = "insert into tb_bonus(UserID,TypeID,Amount,Revenue,sf,AddTime,IsSettled,Source,SourceEn,SttleTime,FromUserID,Bonus005,Bonus006)";
sql_Add += "values (" + BD_UserID + ",6," + (BD + shouxufei) + "," + shouxufei + "," + BD + ",getdate(),1,'" + journal.Remark + "','',getdate()," + userid + "," + jiangjin + "," + zhongzi + ");";
SqlCommand cmd = new SqlCommand(sql_Add, conn);
int reInt = cmd.ExecuteNonQuery();
conn.Close();
}
}
////还有运营中心 Yunying1
//if (getParamInt("Yunying") == 1)
//{
// long YY_UserID = long.Parse(orderModel.Order5);
// int isLock = userBLL.GetModel(YY_UserID).IsLock;
// int Ag= agent1BLL.GetIDByIDUser(agent1BLL.GetIDByIDUser(YY_UserID));
// if (isLock==0&&Ag==1)
// {
// decimal YY = getParamAmount("Yunying1") / 100 * totalMoney;
// decimal shouxufei = YY * getParamAmount("PingTai") / 100;
// YY -= shouxufei;
// decimal jiangjin = getParamAmount("JJ");
// decimal zhongzi = getParamAmount("ZZ");
// decimal JJ = YY * jiangjin / 100;
// decimal ZZ = YY * zhongzi / 100;
// UpdateAccount("Emoney", YY_UserID, JJ, 1);//奖金
// UpdateAccount("AllBonusAccount", YY_UserID, ZZ, 1);//种子
// lgk.Model.tb_journal journal = new lgk.Model.tb_journal();
// journal.UserID = YY_UserID;
// journal.Remark = "运营中心奖获得" + (YY + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + jiangjin + "%进入奖金积分";
// journal.RemarkEn = "";
// journal.InAmount = JJ;
// journal.OutAmount = 0;
// journal.BalanceAmount = userBLL.GetMoney(YY_UserID, "Emoney"); ;
// journal.JournalDate = DateTime.Now;
// journal.JournalType = 1;
// journal.Journal01 = 0;
// journalBLL.Add(journal);
// journal.UserID = YY_UserID;
// journal.Remark = "运营中心奖获得" + (YY + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + zhongzi + "%进入种子积分";
// journal.RemarkEn = "";
// journal.InAmount = ZZ;
// journal.OutAmount = 0;
// journal.BalanceAmount = userBLL.GetMoney(YY_UserID, "AllBonusAccount"); ;
// journal.JournalDate = DateTime.Now;
// journal.JournalType = 4;
// journal.Journal01 = 0;
// journalBLL.Add(journal);
// SqlConnection conn = new SqlConnection(sconn);
// conn.Open();
// string sql_Add1 = "insert into tb_bonus(UserID,TypeID,Amount,Revenue,sf,AddTime,IsSettled,Source,SourceEn,SttleTime,FromUserID,Bonus005,Bonus006)";
// sql_Add1 += "values (" + YY_UserID + ",5," + (YY + shouxufei) + "," + shouxufei + "," + YY + ",getdate(),1,'" + journal.Remark + "','',getdate()," + userid + "," + jiangjin + "," + zhongzi + ");";
// SqlCommand cmd = new SqlCommand(sql_Add1, conn);
// int reInt1 = cmd.ExecuteNonQuery();
// conn.Close();
// }
//}
//用户账户更新
//MySQL(string.Format(" exec proc_Fenxiangjiang "+ orderModel.UserID+ ","+ orderModel.OrderTotal+ "" ));
//MySQL(string.Format(" exec proc_Yejijiang " + orderModel.UserID + "," + orderModel.OrderTotal + ""));
//MySQL(string.Format(" exec proc_YejiUp " + orderModel.UserID + "," + orderModel.OrderTotal + ""));
Response.Write("<script>alert('收货成功');location.href='OrderList.aspx';</script>");
return;
//ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('收货成功!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('收货失败!');", true);
return;
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单记录不存在!');", true);
return;
}
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
lgk.Model.tb_Order order = ob.GetModelByCode(e.CommandArgument.ToString());
if (order == null)
{
MessageBox.ShowAndRedirect(this, "已经删除过的记录!", "OrderAuction.aspx");
return;
}
if (order.IsDel == 2)
{
MessageBox.ShowAndRedirect(this, "已经删除过的记录!", "OrderAuction.aspx");
return;
}
TextBox txtGongsi = (TextBox)e.Item.FindControl("txtGongsi"); //快递公司
TextBox txtDanhao = (TextBox)e.Item.FindControl("txtDanhao"); //快递单号
if (e.CommandName.Equals("Send")) //确认发货
{
if (order.IsSend == 0)
{
MessageBox.ShowAndRedirect(this, "未付款的记录!", "OrderAuction.aspx");
return;
}
if (order.IsSend > 1)
{
MessageBox.ShowAndRedirect(this, "已发货的记录!", "OrderAuction.aspx");
return;
}
#region 1判断当前用户输入的快递名称及单号 2保存快递信息
if (string.IsNullOrEmpty(txtGongsi.Text))
{
MessageBox.Show(this, "发货失败，原因：快递公司不能为空");
return;
}
if (string.IsNullOrEmpty(txtDanhao.Text))
{
MessageBox.Show(this, "发货失败，原因：快递单号不能为空");
return;
}
order.Order3 = txtGongsi.Text;
order.Order4 = txtDanhao.Text;
if (!ob.Update(order))
{
MessageBox.Show(this, "发货失败，原因：保存快递信息失败");
return;
}
#endregion
if (string.IsNullOrEmpty(order.Order3) || string.IsNullOrEmpty(order.Order4))
{
MessageBox.ShowAndRedirect(this, "请先填写快递公司和快递单号!", "OrderAuction.aspx");
return;
}
if (order.OrderType == 3)
{
ob.Update(order);
MessageBox.ShowAndRedirect(this, "发货已成功！\r\n 由于还需要支付宝平台返回验证消息 \r\n 请稍后刷新查看发货状态", "OrderAuction.aspx");
}
else
{
order.IsSend = 2; //已发货
order.SendDate = DateTime.Now; //发货时间 结算奖金以发货时间为准
if (ob.Update(order))
{
MessageBox.ShowAndRedirect(this, "发货已成功!", "OrderAuction.aspx");
}
}
}
if (e.CommandName.Equals("Detail"))
{
Response.Redirect("OrderDetail.aspx?oid=" + order.OrderCode);
}
return;
}
