/// <summary>
/// 调网
/// </summary>
/// <param name="tran"></param>
/// <param name="number">编号</param>
/// <param name="old">原位置</param>
/// <param name="newbh">新位置</param>
/// <param name="isAzTj">0：推荐；1：安置</param>
/// <param name="qishu">期数</param>
public static int ExecuteUpdateNet(string number, string old, string newbh, int isAzTj, int qishu, string opreateBH, DateTime adjustdate)
{
int newqushu = 1;
if (isAzTj == 1)
{
newqushu = AddOrderDataDAL.GetDistrict(newbh, 1);
}
SqlParameter[] parm2 = { new SqlParameter("@Number", SqlDbType.VarChar, 30),
new SqlParameter("@old", SqlDbType.VarChar, 30),
new SqlParameter("@new", SqlDbType.VarChar, 30),
new SqlParameter("@IsAz", SqlDbType.Bit, 2),
new SqlParameter("@qishu", SqlDbType.Int),
new SqlParameter("@newqushu", SqlDbType.Int),
new SqlParameter("@opreateBH", SqlDbType.VarChar, 50),
new SqlParameter("@adjustdate", SqlDbType.DateTime) };
parm2[0].Value = number;
parm2[1].Value = old;
parm2[2].Value = newbh;
parm2[3].Value = isAzTj;
parm2[4].Value = qishu;
parm2[5].Value = newqushu;
parm2[6].Value = opreateBH;
parm2[7].Value = adjustdate;
return(DBHelper.ExecuteDataTable("js_UpdateNet_w", parm2, CommandType.StoredProcedure).Rows.Count);
}
/// <summary>
/// 删除复消单
/// </summary>
public string DelOredrAgain(string orderId, double totalPv, string number, int except, string storeId)
{
double totalMoney = AddOrderDataDAL.GetTotalMoneyByOrderId(orderId);
MemberOrderModel order = MemberOrderDAL.GetMemberOrder(orderId);
string info = null;
using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("memberorder", "orderid"); //实例日志类
cl_h_info.AddRecordtran(tran, orderId); //添加日志，修改前记录原来数据
//如果该订单不存在
if (!BrowsememberordersDAL.CheckOrderIdExists(orderId))
{
info = BLL.Translation.Translate("001661", "抱歉，该订单不存在！");
tran.Rollback();
conn.Close();
return(info);
}
if (order.DefrayState == 1)
{
if (totalMoney > 0)
{
D_AccountBLL.AddAccount(storeId, totalMoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金扣添加，订单号为【" + orderId + "】", tran);
if (order.DefrayType == 2)
{
IsElecPay(tran, order);
D_AccountBLL.AddAccount(order.Number, Convert.ToDouble(order.TotalMoney), D_AccountSftype.MemberType, D_AccountKmtype.OrderUpdateIn, DirectionEnum.AccountsIncreased, "会员【" + order.Number + "】报单删除现金扣添加，订单号为【" + order.OrderId + "】", tran);
D_AccountBLL.AddAccount(order.StoreId, Convert.ToDouble(order.TotalMoney), D_AccountSftype.StoreType, D_AccountKmtype.OrderUpdateOut, DirectionEnum.AccountReduced, "会员【" + order.Number + "】报单删除现金添加扣，订单号为【" + order.OrderId + "】", tran, true);
}
}
int result = addOrderDataDAL.Js_delfuxiao(number, totalPv, except, 1, tran);
}
//删除复消单
addOrderDataDAL.Del_Horder(tran, orderId, storeId, CommonDataBLL.OperateBh, CommonDataBLL.OperateIP);
cl_h_info.DeletedIntoLogstran(tran, BLL.CommonClass.ChangeCategory.store1, orderId, BLL.CommonClass.ENUM_USERTYPE.objecttype5);//插入日志
tran.Commit();
}
catch
{
info = BLL.Translation.Translate("000417", "删除失败！");
tran.Rollback();
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(info);
}
/// <summary>
/// 分析购物条件
/// </summary>
/// <param name="mode"></param>
/// <param name="prevJine"></param>
/// <param name="notEnProMoney">用户选择货物不足时，计算出的不足数量*不足数量单价</param>
/// <param name="orderID"></param>
/// <param name="storeID"></param>
/// <param name="list"></param>
/// <param name="selectValue"></param>
public static string CheckOption(bool isEdit, double notEnProMoney, string orderID, string storeID, IList <MemberDetailsModel> list, string selectValue, out double storeLeftMoney2, out double prvMoney2, out bool judge)
{
judge = true;
//storeDataDAL数据类对象
StoreDataDAL storeDataDAL = new StoreDataDAL();
//上次报单金额
double prevMoney = 0;
//支付状态
int defreyState = 0;
//错误信息
string msg = null;
//如果是编辑
if (isEdit)
{
//补回上次该报单上传不足货物时补交的钱
prevMoney += new AddOrderDataDAL().NeedReturnMoney(orderID, storeID);
}
//需要修改
double storeLeftMoney = storeDataDAL.GetLeftRegisterMemberMoney(storeID) + prevMoney;
//将店剩余金额带出方法
storeLeftMoney2 = storeLeftMoney;
//将上次报单的费用带出方法
prvMoney2 = prevMoney;
//判断是否已经注册
//得到
double currentMoney = new RegistermemberBLL().getZongJing(list);
double bottonLine = new AddOrderBLL().GetBottomLine();
//如果报单额不足
if (notEnProMoney > storeLeftMoney)
{
if (selectValue == "1")
{
msg = "alert('" + BLL.Translation.Translate("006018", "对不起，您的报单额不足！") + "');";
judge = false;
}
}
//没有库存
if (currentMoney < bottonLine)
{
msg = "alert('" + BLL.Translation.Translate("006019", "对不起，报单金额必须大于等于报单底线") + " " + bottonLine + "');";
judge = false;
}
return(msg);
}
/// <summary>
/// 会员自由注册记录到MemberOrder和MemberDetails
/// </summary>
/// <param name="model">用户注册定单</param>
/// <param name="list">用户注册定单列表</param>
/// <returns></returns>
public static bool AddOrder(MemberOrderModel model, IList <MemberDetailsModel> list)
{
bool state = false;
int record = 0;
using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString))
{
//打开连接
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
record += new AddFreeOrderDAL().AddOrder(model, tran);
foreach (MemberDetailsModel item in list)
{
record += new AddOrderDataDAL().insert_MemberOrderDetails(model, item, tran);
}
if (record == 0)
{
tran.Rollback();
conn.Close();
}
else
{
//更信结算表,注意此时保单时未确认的所以flag为0
new AddOrderDataDAL().Js_addfuxiao(model.Number, Convert.ToDouble(model.TotalMoney), model.OrderExpect, 0, tran);
state = true;
tran.Commit();
}
}
catch
{
tran.Rollback();
}
finally
{
conn.Close();
}
}
return(state);
}
/// <summary>
/// 行命令事件
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvSecanRemits_RowCommand(object sender, GridViewCommandEventArgs e)
{
string rimid = e.CommandArgument.ToString();
if (e.CommandName == "cof")
{
//Response.Redirect("Tochangmoney.aspx?rmid="+rimid);
//double xinyuedu = D_AccountDAL.getAccountxinyuedu(Session["member"].ToString()) ;
//double curremtmoney= RemittancesDAL.GetnewRemitmoneybyrmid(rimid);
//if (xinyuedu >= curremtmoney)
//{
//int isc = MemberInfoDAL.Getisconfirmuse(Session["member"].ToString());
//if (isc == 0)
//{
string opnumber = "";
string opip = Request.UserHostAddress.ToString();
int ges = AddOrderDataDAL.PaymentRemitmoney(rimid, opnumber, opip, 1);
if (ges == 0 || ges == 7)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007630", "汇款充值确认操作成功") + "！');</script>");
LoadDatabyorderid();
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007631", "汇款充值确认失败，再次进行确认") + "！');</script>");
}
//}
//else
//{
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('由于您之前的不当操作导致您的信誉额度不足，不能进行此操作！');</script>");
//}
//}
//else
//{
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('由于您之前的不当操作导致您的信誉额度不足，不能进行此操作！');</script>");
//}
}
if (e.CommandName == "upd")
{
// Response.Redirect("Tochangmoney.aspx?rmid=" + rimid);
}
}
/// <summary>
/// 行命令事件
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvSecanRemits_RowCommand(object sender, RepeaterCommandEventArgs e)
{
string rimid = e.CommandArgument.ToString();
if (e.CommandName == "cof")
{
string opnumber = "";
string opip = Request.UserHostAddress.ToString();
int ges = AddOrderDataDAL.PaymentRemitmoney(rimid, opnumber, opip, 1);
if (ges == 0 || ges == 7)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007630", "汇款充值确认操作成功") + "！');location.href='Remsecan.aspx';</script>");
//LoadDatabyorderid();alert('" + GetTran("009050", "到账成功") + "！');location.href='TxDetailYDZ.aspx'
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007631", "汇款充值确认失败，再次进行确认") + "！');</script>");
}
}
if (e.CommandName == "upd")
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string number = Request.QueryString["number"];
string rmid = Request.QueryString["repid"];
string ip = Request.UserHostAddress.ToString();
string orderid = Request.QueryString["orderid"];
double remark = 0;
if (TextBox1.Text.Trim() != "")
{
bool b = double.TryParse(TextBox1.Text.Trim(), out remark);
if (!b)
{
ClientScript.RegisterStartupScript(GetType(), "aaa", "alert('实汇金额只能输入数字！');", true);
return;
}
//if (remark > Convert.ToDouble(Label2.Text.Trim().Substring(1)))
//{
// ClientScript.RegisterStartupScript(GetType(), "aaa", "alert('实汇金额不能大于汇款金额！');", true);
// return;
//}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "aaa", "alert('实汇金额不能为空！');", true);
return;
}
int res = -1;
int res1 = -1;
DataTable remittancedt = RemittancesDAL.GetRemittanceinfobyremid(rmid);
string oper = Session["company"].ToString();
string opip = Request.UserHostAddress.ToString();
if (remittancedt != null && remittancedt.Rows.Count > 0)
{
int roltype = Convert.ToInt32(remittancedt.Rows[0]["RemitStatus"]) == 0 ? 2 : 1;
string ord = remittancedt.Rows[0]["RelationOrderID"].ToString();
double totalrmbmoney = Convert.ToDouble(TextBox1.Text.Trim());
int isgsqr = Convert.ToInt32(remittancedt.Rows[0]["isgsqr"]);
int dotype = 0;
if (ord == "")
{
dotype = 2;
}
else
{
dotype = 1;
}
if (isgsqr == 0)
{
res = AddOrderDataDAL.OrderPayment(oper, ord, opip, roltype, dotype, 0, oper, "", 3, 1, 1, 1, rmid, totalrmbmoney, "");
DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select Ispipei,IsJL from remittances where RemittancesID='" + rmid + "'");
string Ispipie = dt_one.Rows[0]["Ispipei"].ToString(); //汇款id
string IsJL = dt_one.Rows[0]["IsJL"].ToString(); //汇款id
if (Ispipie == "1" && IsJL == "1")
{
res1 = AddOrderDataDAL.OrderPayment1(rmid);
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该汇款单已确认，不能重复操作！');window.close();</script>");
}
}
if (res == 0)
{
PublicClass.SendMsg(1, remittancedt.Rows[0]["RelationOrderID"].ToString(), "");
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('确认收款成功！');window.opener.location.href='DoSeecan.aspx';window.close();;</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('确认收款失败！');</script>");
}
}
/// <summary>
/// 填写退货退款单 ——ds2012——tianfeng
/// </summary>
/// <param name="DocID">订单号</param>
/// <param name="StoreID">店编号</param>
/// <returns></returns>
public static Boolean UPtInventoryDoc(string DocID, string StoreID, int flag, double money, string reason, Boolean bol, string opbh, string opip, int qishu)
{
SqlParameter[] parameter =
{
new SqlParameter("@DocID", SqlDbType.VarChar, 20),
new SqlParameter("@StoreID", SqlDbType.VarChar, 20),
new SqlParameter("@Flag", SqlDbType.Int),
new SqlParameter("@Charged", SqlDbType.Money, 20),
new SqlParameter("@Reason", SqlDbType.VarChar, 250),
new SqlParameter("@error", SqlDbType.VarChar, 20)
};
parameter[0].Value = DocID;
parameter[1].Value = StoreID;
parameter[2].Value = flag;
parameter[3].Value = money;
parameter[4].Value = reason;
parameter[5].Direction = ParameterDirection.Output;
double totalFmoney = GetInventoryTotalMoney(DocID);
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
//修改
double Fmoney = GetInventoryMoney(tran, DocID);
string huidan = "HK" + Model.Other.MYDateTime.ToYYMMDDHHmmssString();
//判断汇单号是否存在:true存在,false不存在
bool isExist = RemittancesDAL.isMemberExistsHuiDan(huidan);
while (isExist)
{
huidan = "HK" + Model.Other.MYDateTime.ToYYMMDDHHmmssString();
isExist = RemittancesDAL.isMemberExistsHuiDan(huidan);
}
if (bol)
{
AddOrderDataDAL.AddDataTORemittances(tran, huidan, StoreID, (Fmoney * (-1)), DocID, opip, opbh, qishu);
DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney - @money where storeid=@storeid", new SqlParameter[2] {
new SqlParameter("@money", Fmoney), new SqlParameter("@storeid", StoreID)
}, CommandType.Text);
D_AccountDAL.AddStoreAccount(StoreID, Fmoney, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnCharge, DirectionEnum.AccountReduced, "返回上次店铺退货单款" + DocID, tran);
DBHelper.ExecuteNonQuery(tran, "UPtInventoryDoc", parameter, CommandType.StoredProcedure);
AddOrderDataDAL.AddDataTORemittances(tran, "", StoreID, totalFmoney, DocID, opip, opbh, qishu);
DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney + @money where storeid=@storeid", new SqlParameter[2] {
new SqlParameter("@money", totalFmoney), new SqlParameter("@storeid", StoreID)
}, CommandType.Text);
D_AccountDAL.AddStoreAccount(StoreID, totalFmoney, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnRebate, DirectionEnum.AccountsIncreased, "店铺退货单退款" + DocID, tran);
AddOrderDataDAL.AddDataTORemittances(tran, huidan, StoreID, (money * (-1)), DocID, opip, opbh, qishu);
DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney - @money where storeid=@storeid", new SqlParameter[2] {
new SqlParameter("@money", money), new SqlParameter("@storeid", StoreID)
}, CommandType.Text);
D_AccountDAL.AddStoreAccount(StoreID, money, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnCharge, DirectionEnum.AccountReduced, "店铺退货单扣款" + DocID, tran);
}
else
{
//添加
DBHelper.ExecuteNonQuery(tran, "UPtInventoryDoc", parameter, CommandType.StoredProcedure);
AddOrderDataDAL.AddDataTORemittances(tran, huidan, StoreID, totalFmoney, DocID, opip, opbh, qishu);
DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney + @money where storeid=@storeid", new SqlParameter[2] {
new SqlParameter("@money", totalFmoney), new SqlParameter("@storeid", StoreID)
}, CommandType.Text);
D_AccountDAL.AddStoreAccount(StoreID, totalFmoney, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnRebate, DirectionEnum.AccountsIncreased, "店铺退货单退款" + DocID, tran);
AddOrderDataDAL.AddDataTORemittances(tran, huidan, StoreID, (money * (-1)), DocID, opip, opbh, qishu);
DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney - @money where storeid=@storeid", new SqlParameter[2] {
new SqlParameter("@money", money), new SqlParameter("@storeid", StoreID)
}, CommandType.Text);
D_AccountDAL.AddStoreAccount(StoreID, money, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnRebate, DirectionEnum.AccountReduced, "店铺退货单扣款" + DocID, tran);
}
tran.Commit();
}
catch (Exception ex1)
{
tran.Rollback();
return(false);
}
finally
{
conn.Close();
}
}
}
return(int.Parse(parameter[5].Value.ToString()) == 0 ? true : false);
}
/// <summary>
/// 注册报单流程（包括判断）
/// 调用逻辑层中的所有方法
/// </summary>
public void AddOrderAndInfoProcess()
{
string xjnumber = lblxjnumber.Text;
string placement = this.hidplacemnet.Value;
string direct = hiddirect.Value;
if (placement == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('安置编号不能为空');</script>", false);
return;
}
if (placement == xjnumber)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('安置编号不能与会员编号相同');</script>", false);
return;
}
string GetError1 = new AjaxClass().CheckNumberNetAn(direct, placement);
if (GetError1 != null && GetError1 != "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('安置编号必须在推荐编号的安置网络下面！');</script>", false);
return;
}
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState in(0,2) and Number='" + CommonDataBLL.quanjiao(direct) + "'")) != 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('推荐编号未激活');</script>", false);
return;
}
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState in(0,2) and Number='" + CommonDataBLL.quanjiao(placement) + "'")) != 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请先激活当前会员的安置人，或重新设置安置编号！');</script>", false);
return;
}
string placement_check = registermemberBLL.GetHavePlacedOrDriect(xjnumber, "", placement, direct);
if (placement_check != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + placement_check + "');</script>", false);
return;
}
string pass = txtpassword.Text;
if (pass == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请输入二级密码！');</script>", false);
return;
}
string EnPass = Encryption.Encryption.GetEncryptionPwd(pass, direct);
int n = PwdModifyBLL.check(direct, EnPass, 1);
if (n <= 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('二级密码不正确！');</script>", false);
return;
}
string District = hidDistrict.Value;
if (placement != "8888888888")
{
if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + placement + "' and District=" + District + " and memberstate=1 ").ToString() != "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('安置人所选区位已有人安置！');</script>", false);
return;
}
}
string orderid = hidorderid.Value;
int maxexp = BLL.CommonClass.CommonDataBLL.getMaxqishu();
string curip = Request.UserHostAddress.ToString();
int rec = -1;
SqlConnection conn = null;
SqlTransaction tran = null;
try
{
conn = DBHelper.SqlCon();
conn.Open();
tran = conn.BeginTransaction();
string sql = " update memberinfo set placement=@placement ,District=" + District + " where number=@number ";
SqlParameter[] sps = new SqlParameter[] {
new SqlParameter("@placement", placement),
new SqlParameter("@number", xjnumber)
};
rec = DBHelper.ExecuteNonQuery(tran, sql, sps, CommandType.Text);
rec = AddOrderDataDAL.OrderPayment(tran, direct, orderid, curip, 1, 1, 1, direct, "", 2, -1, 1, 1, "", 0, "");
if (rec == 0)
{
tran.Commit();
//ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('激活会员成功！');window.location.href='BrowseMemberOrders.aspx'</script>");
// Response.Redirect("../payserver/chosepaysjpay.aspx?blif=" + EncryKey.GetEncryptstr(orderid, 1, 1) + "");
}
else
if (rec == 2)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('可用石斛积分不足，激活失败！');</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('安置激活失败，请重新输入安置编号！');</script>");
this.hidplacemnet.Value = "";
this.txtplacemnet.Text = "";
}
}
catch (Exception)
{
tran.Rollback();
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('安置激活失败！');</script>");
this.hidplacemnet.Value = "";
this.txtplacemnet.Text = "";
}
finally {
tran.Dispose();
conn.Close();
conn.Dispose();
}
double jbb = Convert.ToDouble(lblkcjb.Text);
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='../payserver/payerror1.aspx?ef=" + EncryKey.Encrypt(rec.ToString() + "," + orderid + "," + jbb) + "';</script>");
}
protected void btnOk_Click(object sender, EventArgs e)
{
string number = this.labBh.Text;
string placement = SearchPlacement_DoubleLines1.Placement;
string direct = DisposeString.DisString(this.txtDirect.Text, "'", "").Trim();
string oldplacement = ViewState["placement"].ToString();
string olddirect = ViewState["direct"].ToString();
string storeid = ViewState["storeid"].ToString();
if (placement == "" || direct == "")
{
lblmessage.Text = GetTran("000716", "推荐编号或安置编号都不能为空!");
return;
}
if (ChangeTeamBLL.CheckNum(direct))
{
lblmessage.Text = GetTran("000717", "推荐编号不存在!");
return;
}
if (ChangeTeamBLL.CheckNum(placement))
{
lblmessage.Text = GetTran("000718", "安置编号不存在!");
return;
}
string topMemberId = BLL.CommonClass.CommonDataBLL.getManageID(3);
int district = Convert.ToInt32(ViewState["district"]);;
if (placement != topMemberId)
{
int flag_xiou = ChangeTeamBLL.GetPlacementCount(placement, number);
if (flag_xiou >= 2)
{
ScriptHelper.SetAlert(Page, GetTran("000000", "此安置编号下已经安置了两个人！"));
return;
}
if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + placement + "' and District=" + direct + "").ToString() != "0")
{
district = AddOrderDataDAL.GetDistrict(placement, 1);
if (district == 1)
{
if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + placement + "' and District=2").ToString() != "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "安置人所选区位已有人安置！") + "');</script>", false);
return;
}
}
else if (district == 2)
{
if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + placement + "' and District=1").ToString() != "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "安置人所选区位已有人安置！") + "');</script>", false);
return;
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "安置人所选区位已有人安置！") + "');</script>", false);
return;
}
}
RegistermemberBLL registermemberBLL = new RegistermemberBLL();
string CheckMember = registermemberBLL.CheckMemberInProc(number, placement, direct, storeid);
CheckMember = new GroupRegisterBLL().GerCheckErrorInfo(CheckMember);
if (CheckMember != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + CheckMember + "');</script>", false);
return;
}
string p_info = registermemberBLL.GetHavePlacedOrDriect(number, "", placement, direct);
if (p_info != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + p_info + "');</script>", false);
return;
}
//判断该编号是否有安置，推荐
string GetError = registermemberBLL.GetError(direct, placement);
if (GetError != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetError + "');</script>", false);
return;
}
string GetError1 = new AjaxClass().CheckNumberNetAn(direct, placement);
if (GetError1 != null && GetError1 != "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("005986", "安置编号必须在推荐编号的安置网络下面！") + "');</script>", false);
return;
}
#region 安置推荐人必须要激活
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState=1 and Number='" + direct + "'")) == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "招商编号未激活！") + "');</script>", false);
return;
}
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState=1 and Number='" + placement + "'")) == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "互助编号未激活！") + "');</script>", false);
return;
}
#endregion
}
bool ispass = false;
if (ViewState["placement"].ToString() != placement || ViewState["direct"].ToString() != direct)
{
Application.Lock();
string msg = ChangeTeamBLL.UpdateNet(number, placement, direct, oldplacement, olddirect, district, ChangeTeamBLL.GetFlag(number), out ispass);
Application.UnLock();
ScriptHelper.SetAlert(Page, msg);
}
else
{
ScriptHelper.SetAlert(Page, this.GetTran("000000", "推荐、安置人编号未变化！"));
}
}
public int DoControlRemit(int ctype, string rmidstr)
{
int errorinfo = 0;
int ges = -1;
NumberByBit nbt = new NumberByBit();
string desstrm = nbt.DecryptDES(rmidstr, "20120518");
string[] srmps = desstrm.Split(',');
string rmid = "";
string oper = "";
string opip = "";
if (srmps.Length >= 3)
{
rmid = srmps[0].ToString();
oper = srmps[1].ToString();
opip = srmps[2].ToString();
}
DataTable remittancedt = RemittancesDAL.GetRemittanceinfobyremid(rmid);
if (remittancedt != null && remittancedt.Rows.Count > 0)
{
int roltype = Convert.ToInt32(remittancedt.Rows[0]["RemitStatus"]) == 0 ? 2 : 1;
string orderid = remittancedt.Rows[0]["RelationOrderID"].ToString();
double totalrmbmoney = Convert.ToDouble(DBHelper.ExecuteScalar("select isnull(totalrmbmoney,0) from remtemp where remittancesid='" + rmid + "'"));
int dotype = 0;
if (orderid == "")
{
dotype = 2;
}
else
{
dotype = 1;
}
ges = AddOrderDataDAL.OrderPayment(oper, orderid, opip, roltype, dotype, -1, oper, "", 3, ctype, 1, 1, rmid, totalrmbmoney, "");;// AddOrderDataDAL.PaymentChongzhi(desstrm, ctype);
}
double tomoney = 0;
//if (ges == 0 || ges == 7)
//{
//// 短信
//SqlConnection con = null;
//SqlTransaction tran = null;
//string info = string.Empty;
//tomoney = Convert.ToDouble(DBHelper.ExecuteScalar("select isnull(totalrmbmoney,0) from dbo.remtemp where remittancesid='" + rmid + "'"));
//string acnumber = DBHelper.ExecuteScalar("select number from dbo.MemberRemittances where remittancesid='" + rmid + "'").ToString();
////手机号码
//object mt = DAL.DBHelper.ExecuteScalar("select MobileTele from memberinfo where number ='" + acnumber + "'");
//string sjhm = mt == null ? "" : mt.ToString();
////支付的金额
//string zfje = tomoney.ToString("f2");
//if (sjhm != "" && oper != "")
//{
// string sendinfo = "管理员" + oper + "已经成功确认发展商 " + acnumber + " 的支付【" + zfje + "元人民币】，充值成功，请及时登录查看！";
// if (ges == 7)
// {
// sendinfo = "管理员" + oper + "已经成功确认发展商 " + acnumber + " 的支付【" + zfje + "元人民币】，发展商 " + acnumber + " 的账号已成功激活，请及时登录查看！";
// }
// try
// {
// con = DAL.DBHelper.SqlCon();
// con.Open();
// tran = con.BeginTransaction();
// bool bo = true;// BLL.MobileSMS.SendMsgMode(tran, "", sendinfo, acnumber, sjhm, "", Model.SMSCategory.sms_Active);
// if (bo)
// tran.Commit();
// else
// tran.Rollback();
// }
// catch (Exception ee)
// {
// if (tran != null)
// tran.Rollback();
// }
// finally
// {
// con.Close();
// }
//}
// errorinfo = 1;
//}
//else
//{
// errorinfo = 0;
//}
return(ges);
}
/// <summary>
/// 控件翻译方法
/// </summary>
//public void Translate()
//{
// this.TranControls(this.dplCardType, new string[][] {
// new string[] { "005898", "无" },
// new string[] { "005776", "身份证" },
// new string[] { "005775", "护照" },
// new string[] { "005774", "港澳台证" },
// });
//}
/// <summary>
/// 注册报单流程（包括判断）
/// 调用逻辑层中的所有方法
/// </summary>
public void AddOrderAndInfoProcess()
{
string number = CommonDataBLL.quanjiao(HFNumber.Value.Trim());
string direct = txtDirect.Text.Trim();
//会员名是否小于6位
if (!registermemberBLL.NumberLength(number))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000306", "抱歉！您输入的会员编号小于6位！") + "');</script>", false);
return;
}
if (!registermemberBLL.NumberCheckAgain(number))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000309", "编号请输入字母，数字，横线！") + "');</script>", false);
return;
}
string name = CommonDataBLL.quanjiao(txtName.Text.Trim());
if (name == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("008360", "真实姓名不能为空") + "！" + "');</script>", false);
return;
}
string tel = CommonDataBLL.quanjiao(txtTele.Text.Trim());
if (tel == "" || tel.Length != 11)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('手机号格式不正确！');</script>", false);
return;
}
//string storeid = CommonDataBLL.quanjiao(txtStore.Text.Trim());
//if (storeid == "")
//{
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("008361", "所属店铺不能为空") + "！" + "');</script>", false);
// return;
//}
//else
//{
// if (!StoreInfoDAL.CheckStoreId(storeid))
// {
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("008362", "所属店铺编号不存在！") + "');</script>", false);
// return;
// }
//}
//判断用胡地址是否输入
if (this.CountryCity2.Country == "请选择" || this.CountryCity2.Province == "请选择" || this.CountryCity2.City == "请选择" || this.CountryCity2.Xian == "请选择" || this.CountryCity2.Country == "" || this.CountryCity2.Province == "" || this.CountryCity2.City == "" || this.CountryCity2.Xian == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("001548", "对不起，请选择国家省份城市！") + "');</script>", false);
return;
}
if (DAL.CommonDataDAL.GetCPCCode(this.CountryCity2.Country, this.CountryCity2.Province, this.CountryCity2.City, this.CountryCity2.Xian) == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("001548", "对不起，请选择国家省份城市！") + "');</script>", false);
return;
}
//string direct = CommonDataBLL.quanjiao(txtDirect.Text.Trim());
string placement = hidplacemnet.Value;// CommonDataBLL.quanjiao(SearchPlacement_DoubleLines1.Placement);
//if (direct == "" || placement == "")
//{
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000716", "推荐编号和安置编号不能为空！") + "');</script>", false);
// return;
//}
//if (direct == number)
//{
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("006700", "推荐编号不能与会员编号相同") + "');</script>", false);
// return;
//}
if (placement == number)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("001650", "安置编号不能与会员编号相同") + "');</script>", false);
return;
}
//验证年龄是否大于18岁
//string birthDate = CommonDataBLL.quanjiao(txtBirthDate.Text.Trim());
//if (this.dplCardType.SelectedValue != "2")
//{
// string alert = registermemberBLL.AgeIs18(birthDate);
// if (alert != null)
// {
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + alert + "');</script>", false);
// return;
// }
//}
////检查会员生日
//if (this.dplCardType.SelectedValue != "2")
//{
// if (registermemberBLL.CheckBirthDay(birthDate) == "error")
// {
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000148", "对不起，请选择正确的出生日期！") + "');</script>", false);
// return;
// }
//}
////检测身份证需要新方法
//string CardResult = "";
//if (this.dplCardType.SelectedValue == "2")
//{
// string papernumber = CommonDataBLL.quanjiao(this.txtPapernumber.Text.Trim());
// string result = BLL.Registration_declarations.CheckMemberInfo.CHK_IdentityCard(papernumber);
// if (result.IndexOf(",") <= 0)
// {
// return;
// }
// else
// {
// CardResult = result;
// }
// DateTime birthday = Convert.ToDateTime(CardResult.Substring(0, CardResult.IndexOf(",")));
// string alerta = registermemberBLL.AgeIs18(birthday.ToString());
// if (alerta != null)
// {
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + alerta + "');</script>", false);
// return;
// }
//}
//ViewState["CardResult"] = CardResult;
//验证会员编号是否重复
if (registermemberBLL.CheckNumberTwice(number) != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000406", "抱歉！该会员编号重复！") + "');</script>", false);
if (Request.QueryString["Much"] == null)
{
string bb = BLL.CommonClass.CommonDataBLL.GetMemberNumber();
this.txtNumber.Text = bb;
this.HFNumber.Value = bb;
this.txtNumber.ReadOnly = true;
}
return;
}
//验证手机号码是否重复
if (registermemberBLL.CheckTeleTwice(txtTele.Text.Trim()) != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('抱歉！该手机号码已被注册！');</script>", false);
return;
}
MemberInfoModel mi = AddUserInfo();
if (mi.Placement != "8888888888")
{
if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + mi.Placement + "' and District=" + mi.District + " and memberstate=1 ").ToString() != "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("007433", "安置人所选区位已有人安置！") + "');</script>", false);
return;
}
}
//注册会员检错1.无上级 2.无此店 3..死循环
string CheckMember = registermemberBLL.CheckMemberInProc(mi.Number, mi.Placement, mi.Direct, mi.StoreID);
CheckMember = new GroupRegisterBLL().GerCheckErrorInfo(CheckMember);
ViewState["Error"] = CheckMember;
if (Request.QueryString["Much"] == null)
{
if (CheckMember != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + CheckMember + "');</script>", false);
return;
}
string placement_check = registermemberBLL.GetHavePlacedOrDriect(mi.Number, "", mi.Placement, mi.Direct);
if (placement_check != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + placement_check + "');</script>", false);
return;
}
//判断该编号是否有安置，推荐
string GetError = registermemberBLL.GetError(mi.Direct, mi.Placement);
if (GetError != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetError + "');</script>", false);
return;
}
string GetError1 = new AjaxClass().CheckNumberNetAn(direct, placement);
if (GetError1 != null && GetError1 != "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("005986", "安置编号必须在推荐编号的安置网络下面！") + "');</script>", false);
return;
}
string GetError2 = new AjaxClass().CheckNumberNetAn(Session["Member"].ToString(), direct);
if (GetError2 != null && GetError2 != "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "推荐编号必须在自己的安置网络下面！") + "');</script>", false);
return;
}
#region 安置推荐人必须要激活
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState=0 and Number='" + CommonDataBLL.quanjiao(Session["Member"].ToString()) + "'")) != 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "推荐编号未激活！") + "');</script>", false);
return;
}
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState=2 and Number='" + CommonDataBLL.quanjiao(Session["Member"].ToString()) + "'")) != 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("009090", "推荐编号已注销！") + "');</script>", false);
return;
}
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState=0 and Number='" + CommonDataBLL.quanjiao(hidplacemnet.Value) + "'")) != 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "安置编号未激活！") + "');</script>", false);
return;
}
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState=2 and Number='" + CommonDataBLL.quanjiao(hidplacemnet.Value) + "'")) != 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("009107", "安置编号已注销！") + "');</script>", false);
return;
}
#endregion
//int placementXuHao = registermemberBLL.GetXuHao(mi.Direct);
//if (placementXuHao >= 0)
//{
// string GetError1 = new AjaxClass().CheckNumberNetAn(txtDirect.Text.Trim(), SearchPlacement_DoubleLines1.Placement);
// if (GetError1 != null && GetError1 != "")
// {
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("005986", "安置编号必须在推荐编号的安置网络下面！") + "');</script>", false);
// return;
// }
//}
//如果是零购注册，判断推荐人和安置人的注册期数是否合格
//if (Session["Company"] != null)
//{
// int tjExpectNum = registermemberBLL.GetError2(this.Txttj.Text.Trim());
// if (tjExpectNum > Convert.ToInt32(this.ddlQishu.SelectedValue))
// {
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("006013", "推荐人的注册期数必须大于") + this.ddlQishu.SelectedValue + "！');</script>", false);
// return;
// }
// int anExpectNum = registermemberBLL.GetError2(SearchPlacement_DoubleLines1.Placement.Trim());
// if (anExpectNum > Convert.ToInt32(this.ddlQishu.SelectedValue))
// {
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("006014", "安置人的注册期数必须大于") + this.ddlQishu.SelectedValue + "！');</script>", false);
// return;
// }
//}
}
mi.PhotoPath = "";
if (Session["UserType"] != null && Session["UserType"].ToString() == "1") //公司注册
{
mi.OrderType = 31;
Session["LUOrder"] = mi.Number + ",31,1";
}
else if (Session["UserType"] != null && Session["UserType"].ToString() == "2") //店铺注册
{
mi.OrderType = 11;
Session["LUOrder"] = mi.Number + ",11,2";
}
else if (Session["UserType"] != null && Session["UserType"].ToString() == "3") //会员注册
{
mi.OrderType = 21;
Session["LUOrder"] = mi.Number + ",21,3";
mi.Assister = Session["Member"].ToString();
}
else //默认店铺注册
{
mi.OrderType = 11;
Session["LUOrder"] = mi.Number + ",11,2";
}
Session["mbreginfo"] = mi;
if (Session["mbreginfo"] != null)
{
decimal totalmoeny = 0.00M;
decimal bili = 0.00M;
DataTable dts = DAL.DBHelper.ExecuteDataTable("select top 1 * from config order by createdate desc");
if (dts.Rows != null && dts.Rows.Count > 0)
{
decimal htm = Convert.ToDecimal(hidtzmoney.Value);
if (htm == Convert.ToDecimal(dts.Rows[0]["para1"]))
{
bili = Convert.ToDecimal(dts.Rows[0]["para4"]);
}
if (htm == Convert.ToDecimal(dts.Rows[0]["para2"]))
{
bili = Convert.ToDecimal(dts.Rows[0]["para5"]);
}
if (htm == Convert.ToDecimal(dts.Rows[0]["para3"]))
{
bili = Convert.ToDecimal(dts.Rows[0]["para6"]);
}
}
OrderFinalModel ofm = new OrderFinalModel();
var dayPrice = CommonDataBLL.GetMaxDayPrice();
totalmoeny = Convert.ToDecimal(hidtzmoney.Value);; //投资金额
var value = Convert.ToDecimal(totalmoeny) / Convert.ToDecimal(dayPrice); //投资金额换化石斛积分
var expect = CommonDataBLL.getMaxqishu();
ofm.InvestJB = Convert.ToDecimal(value * bili); //投资石斛积分数量
ofm.PriceJB = Convert.ToDecimal(dayPrice); //石斛积分当前市价
ofm.SendWay = 1;
ofm.Number = mi.Number;
ofm.Placement = mi.Placement;
ofm.Direct = mi.Direct;
ofm.ExpectNum = expect;
ofm.OrderID = registermemberBLL.GetOrderInfo("add", null);
ofm.StoreID = mi.StoreID;
ofm.Name = mi.Name;
ofm.PetName = mi.PetName;
ofm.LoginPass = mi.LoginPass;
ofm.AdvPass = mi.AdvPass;
ofm.LevelInt = mi.LevelInt;
ofm.RegisterDate = mi.RegisterDate;
ofm.Birthday = mi.Birthday;
ofm.Sex = mi.Sex;
ofm.HomeTele = mi.HomeTele;
ofm.OfficeTele = mi.OfficeTele;
ofm.MobileTele = mi.MobileTele;
ofm.FaxTele = mi.FaxTele;
ofm.CPCCode = mi.CPCCode;
ofm.Address = mi.Address;
ofm.PostalCode = mi.PostalCode;
ofm.PaperType.PaperTypeCode = mi.PaperType.PaperTypeCode;
ofm.PaperNumber = mi.PaperNumber;
ofm.BankCode = mi.BankCode;
ofm.BankAddress = mi.BankAddress;
ofm.BankCard = mi.BankCard;
ofm.BCPCCode = mi.BCPCCode;
ofm.BankBook = mi.BankBook;
ofm.Remark = mi.Remark;
ofm.ChangeInfo = mi.ChangeInfo;
ofm.PhotoPath = mi.PhotoPath;
ofm.Email = mi.Email;
ofm.IsBatch = mi.IsBatch;
ofm.Language = mi.Language;
ofm.OperateIp = mi.OperateIp;
ofm.OperaterNum = mi.OperaterNum;
ofm.Answer = mi.Answer;
ofm.Question = mi.Question;
ofm.Error = mi.Error;
ofm.Bankbranchname = mi.Bankbranchname;
ofm.Flag = mi.Flag;
ofm.Assister = mi.Assister;
ofm.District = mi.District;
ofm.Type = Convert.ToInt32(rbltotaltype.SelectedValue);
ofm.TotalMoney = Convert.ToDecimal(totalmoeny);
ofm.TotalPv = Convert.ToDecimal(value);//投资金额兑换成石斛
ofm.OrderType = mi.OrderType;
ofm.OrderExpect = expect;
ofm.StandardcurrencyMoney = ofm.TotalMoney;
ofm.PaymentMoney = ofm.TotalMoney;
ofm.OrderDate = DateTime.UtcNow;
ofm.RemittancesId = "";
ofm.ElectronicaccountId = "";
ofm.ConCity.Country = "";
ofm.ConCity.Province = "";
ofm.ConCity.City = "";
ofm.ConCity.Xian = "";
ofm.ConAddress = mi.Address;
ofm.CCPCCode = mi.CPCCode;
ofm.ConTelPhone = mi.MobileTele;
ofm.ConMobilPhone = mi.MobileTele;
ofm.CarryMoney = 0;
ofm.ConPost = mi.Email;
ofm.Consignee = mi.PetName;
ofm.ConZipCode = mi.PostalCode;
ofm.ProductIDList = "";
ofm.QuantityList = "";
ofm.NotEnoughProductList = "";
ofm.PhotoPath = "";
Boolean flag = new AddOrderDataDAL().AddFinalOrder(ofm);
if (flag)
{
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>$('#tiaoz').show();document.getElementById('tiaoz').href = '../payserver/chosepaysjpay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID.ToString(), 1, 1) + "'; alertt('注册订单已生成，请及时支付！');</script>", false);
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>location.href = '../payserver/chosepaysjpay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID.ToString(), 1, 1) + "'; </script>", false);
}
}
else
{
Response.Redirect("registermember.aspx");
}
}
/// <summary>
/// 获取报单信息
/// </summary>
/// <param name="OrderId">报单编号</param>
/// <returns>单据信息</returns>
public static MemberOrderModel GetMemberOrderByOrderId(string OrderId)
{
return(AddOrderDataDAL.SelectMemberOrderByOrderId(OrderId));
}
/// <summary>
/// 读取会员信息
/// </summary>
/// <param name="number">会员</param>
/// <param name="storeId">店铺编号</param>
/// <returns>返回会员信息</returns>
public static MemberInfoModel GetMemberInfoByNumber(string number)
{
return(AddOrderDataDAL.GetMemberInfoByNumber(number));
}
/// <summary>
/// 添加订单信息
/// </summary>
/// <param name="mode"></param>
/// <param name="memberOrderModel"></param>
/// <param name="totalPv"></param>
/// <param name="except"></param>
/// <param name="memberDetailsModel"></param>
/// <param name="storeInfoModel"></param>
public static bool AddOrderData(bool isEdit, MemberOrderModel memberOrderModel, IList <MemberDetailsModel> list)
{
bool state = false;
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
//如果是编辑
if (isEdit)
{
BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("memberorder", "orderid"); //实例日志类
cl_h_info.AddRecordtran(tran, memberOrderModel.OrderId); //添加日志，修改前记录原来数据
MemberOrderModel order = MemberOrderBLL.GetMemberOrder(memberOrderModel.OrderId);
if (order.LackProductMoney > 0)
{
D_AccountBLL.AddAccount(order.StoreId, Convert.ToDouble(order.LackProductMoney), D_AccountSftype.StoreType, D_AccountKmtype.OrderUpdateIn, DirectionEnum.AccountsIncreased, "会员【" + order.Number + "】报单修改现金扣添加，订单号为【" + order.OrderId + "】", tran);
if (order.DefrayType == 2)
{
new Registration_declarations.MemberOrderAgainBLL().IsElecPay(tran, order);
D_AccountBLL.AddAccount(order.Number, Convert.ToDouble(order.LackProductMoney), D_AccountSftype.MemberType, D_AccountKmtype.OrderUpdateIn, DirectionEnum.AccountsIncreased, "会员【" + order.Number + "】报单修改现金扣添加，订单号为【" + order.OrderId + "】", tran);
D_AccountBLL.AddAccount(order.StoreId, Convert.ToDouble(order.LackProductMoney), D_AccountSftype.StoreType, D_AccountKmtype.OrderUpdateOut, DirectionEnum.AccountReduced, "会员【" + order.Number + "】报单修改现金添加扣，订单号为【" + order.OrderId + "】", tran, true);
}
}
int delResult = new AddOrderDataDAL().Del_Horder(tran, memberOrderModel.OrderId, memberOrderModel.StoreId, CommonDataBLL.OperateBh, CommonDataBLL.OperateIP);
if (memberOrderModel.DefrayState == 1)//店铺复消减去业绩
{
int js_delfuxiao_Result = new AddOrderDataDAL().Js_delfuxiao(memberOrderModel.Number, Convert.ToDouble(memberOrderModel.TotalPv), memberOrderModel.PayExpect, memberOrderModel.DefrayState, tran);
}
cl_h_info.ModifiedIntoLogstran(tran, ChangeCategory.Order, memberOrderModel.OrderId, ENUM_USERTYPE.objecttype5);//插入日志
}
//添加订单
new AddOrderBLL().SaveHOrder(tran, list, memberOrderModel);
//顾客购物业绩上传(注意支付money要改)
if (memberOrderModel.DefrayState == 1)
{
new AddOrderDataDAL().Js_addfuxiao(memberOrderModel.Number, Convert.ToDouble(memberOrderModel.TotalPv), memberOrderModel.PayExpect, memberOrderModel.DefrayState, tran);
CommonDataBLL.SetMemberLevel(tran, memberOrderModel.Number, memberOrderModel.OrderId);
}
state = true;
tran.Commit();
}
catch
{
tran.Rollback();
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(state);
}
//报单调用的类
public void SaveHOrder(SqlTransaction tran, IList <MemberDetailsModel> list, MemberOrderModel memberOrderModel)
{
RegistermemberBLL RegistermemberBLL = new RegistermemberBLL();
//添加对账单
if (memberOrderModel.DefrayType == 2)
{
BLL.Logistics.D_AccountBLL.AddAccount(memberOrderModel.ElectronicaccountId, Convert.ToDouble(memberOrderModel.TotalMoney), D_AccountSftype.MemberType, D_AccountKmtype.Declarations, DirectionEnum.AccountReduced, "会员【" + memberOrderModel.Number + "】用会员【" + memberOrderModel.ElectronicaccountId + "】电子货币报单，订单号为【" + memberOrderModel.OrderId + "】", tran);
BLL.Logistics.D_AccountBLL.AddAccount(memberOrderModel.StoreId, Convert.ToDouble(memberOrderModel.TotalMoney), D_AccountSftype.StoreType, D_AccountKmtype.AccountTransfer, DirectionEnum.AccountsIncreased, "会员【" + memberOrderModel.Number + "】用会员【" + memberOrderModel.ElectronicaccountId + "】电子货币报单转入，订单号为【" + memberOrderModel.OrderId + "】", tran);
// 电子帐户支付
IsElecPay(tran, memberOrderModel);
}
AddOrderDataDAL addOrderDataDAL = new AddOrderDataDAL();
//插入memberOrder表
addOrderDataDAL.INSERT_H_Order(memberOrderModel, tran);
foreach (Model.MemberDetailsModel mDetails in list)
{
//插入订单明细
addOrderDataDAL.insert_MemberOrderDetails(memberOrderModel, mDetails, tran);
//未支付报单不算库存
if (memberOrderModel.DefrayState == 1)
{
//更新减去店库存
int result = 0;
result = addOrderDataDAL.updateStore(memberOrderModel.StoreId, mDetails, tran);
////添加该类型的记录,用负数表示
if (result <= 0)
{
addOrderDataDAL.updateStore2(memberOrderModel.StoreId, mDetails, tran);
}
}
}
if (memberOrderModel.DefrayState == 1)
{
//报单生成订单
int count = 0;
decimal totalMoney = 0;
decimal totalPv = 0;
foreach (MemberDetailsModel mDetails in list)
{
if (mDetails.NotEnoughProduct > 0)
{
totalMoney += mDetails.NotEnoughProduct * mDetails.Price;
totalPv += mDetails.NotEnoughProduct * mDetails.Pv;
count++;
}
}
if (count > 0)
{
string orderId = "";
orderId = BLL.Logistics.OrderGoodsBLL.GetNewOrderID();
//自动为店铺生成要货申请单
OrderGoodsMedel storeItem = GetOrderModel(orderId, memberOrderModel, tran, totalMoney, totalPv);
//插入要货申请单明细
OrderSubmit(memberOrderModel.OrderId.ToString(), list, storeItem, tran);
}
int sd = addOrderDataDAL.updateStoreL(tran, memberOrderModel.OrderId);
//添加对账单
if (memberOrderModel.DefrayType == 1 || memberOrderModel.DefrayType == 2)
{
if (Convert.ToDouble(memberOrderModel.LackProductMoney) > 0)
{
BLL.Logistics.D_AccountBLL.AddAccount(memberOrderModel.StoreId, Convert.ToDouble(memberOrderModel.LackProductMoney), D_AccountSftype.StoreType, D_AccountKmtype.Declarations, DirectionEnum.AccountReduced, "会员【" + memberOrderModel.Number + "】报单现金扣除额，订单号为【" + memberOrderModel.OrderId + "】", tran);
}
}
//增加该店铺的总报单的费用（累计）
addOrderDataDAL.updateStore3(memberOrderModel.StoreId, tran, Convert.ToDouble(memberOrderModel.LackProductMoney));
}
}
/// <summary>
/// 确认 当期,未支付的自由注册 信息
/// </summary>
/// <param name="Number"></param>
/// <param name="OrderID"></param>
/// <param name="StoreID"></param>
/// <returns></returns>
public string ConfirmCurretMemberinfo(string Number, string OrderID, string StoreID, string TotalPV, string TotalMoney, int DefrayType, string ElectronicAccountID)
{
//根据订单编号获得订单详细
string info = "";
//获取电子账号
string elcAccountId = new AddOrderDataDAL().GerExcNuber(OrderID);
//try
//{
BrowseMemberOrdersBLL browseMemberOrdersBLL = new BrowseMemberOrdersBLL();
ViewFuXiaoBLL viewFuXiaoBLL = new ViewFuXiaoBLL();
using (SqlConnection con = new SqlConnection(DAL.DBHelper.connString))
{
con.Open();
SqlTransaction tran = con.BeginTransaction();
//获得会员电子账户剩余金额
object zhifumoney = CommonDataBLL.EctIsEnough(Number);
//获得会员订单信息
DataTable dt = BrowseMemberOrdersBLL.DeclarationProduct(StoreID, OrderID);
if (DefrayType == 2)//支付类型，1是现金，2电子转帐，3网上支付，
{
//电子钱包余额是否大于订单金额
if (Convert.ToDouble(zhifumoney) < Convert.ToDouble(TotalMoney))
{
info = BLL.Translation.Translate("000599", "会员") + ":" + Number + BLL.Translation.Translate("001736", "的电子帐户不够支付本报单！");
return(info);
}
}
//获得店铺不足货时可以报单的金额
object memberordermoney = CommonDataBLL.StoreLaveAmount(StoreID);
//获得该订单所以不足货所的报单的金额
double sumNotenoughMoney = ViewFuXiaoBLL.GetNotEnoughMoney(OrderID, tran);
// 店铺剩余可报单额是否大于订单金额
if (Convert.ToDouble(memberordermoney) < sumNotenoughMoney)
{
info = BLL.Translation.Translate("000388", "店铺") + ": " + StoreID + BLL.Translation.Translate("001739", "的可以用来报单的费用不足！");
return(info);
}
//是否是网上银行支付
if (DefrayType == 3)
{
//info = "网上银行支付";
////Response.Write("<script>location.href='../Send.aspx?V_amount=" + Totalmoney.Value + "&V_oid=" + orderId + "';</script>");
//return info;
}
//获得最大期数(测试)
int maxQs = CommonDataBLL.getMaxqishu();
//更新会员订单信息
if (!CommonDataBLL.ConfirmMembersOrder(tran, OrderID, maxQs))
{
info = BLL.Translation.Translate("000979", "支付失败");
return(info);
}
//更新结算（需要修改存储过程）
if (!BLL.CommonClass.CommonDataBLL.UPMemberInfoBalance(tran, Number, decimal.Parse(TotalPV), maxQs))
{
info = BLL.Translation.Translate("001741", "结算失败");
return(info);
}
//更新店铺库存
List <Model.MemberDetailsModel> list = ViewFuXiaoBLL.GetDetails(OrderID);
int result = 0;
bool real = true;
foreach (Model.MemberDetailsModel memberDetailsModel in list)
{
//循环根据订单明细跟新库存
if (memberDetailsModel.IsGroupItem == "" || memberDetailsModel.IsGroupItem == null)
{
if (memberDetailsModel.HasGroupItem == "true")
{
result = new AddMemberInfomDAL().updateStore11(StoreID, memberDetailsModel, tran);
real = false;
}
else
{
result = ViewFuXiaoBLL.UptStock(tran, StoreID, memberDetailsModel.ProductId, memberDetailsModel.Quantity, memberDetailsModel.NotEnoughProduct);
real = false;
}
}
if (result <= 0 && real == false)
{
if (browseMemberOrdersBLL.updateStore2(memberDetailsModel, tran) <= 0)
{
tran.Rollback();
con.Close();
return(info);
}
}
}
if (DefrayType == 2)
{
//添加到店汇款表
int result3 = new AddOrderDataDAL().AddDataTORemittances(tran, MemberOrderBLL.GetMemberOrder(OrderID));
if (result3 > 0)
{
//跟新被转账会员的电子帐户
if (!BLL.CommonClass.CommonDataBLL.UPMemberEct(elcAccountId, Convert.ToDecimal(TotalMoney)))
{
tran.Rollback();
con.Close();
return(info);
}
;
//更新店铺的汇款
int result2 = new AddOrderDataDAL().Add_Remittances(tran, Convert.ToDouble(TotalMoney), StoreID);
}
else
{
tran.Rollback();
con.Close();
return(info);
}
}
//更新店铺总保单额(累计)
if (new AddOrderBLL().updateStore4(StoreID, tran, Convert.ToDouble(TotalMoney)) <= 0)
{
tran.Rollback();
con.Close();
return(info);
}
//提交事务
tran.Commit();
}
//}
//catch
//{
//}
info = BLL.Translation.Translate("001743", "确定完成!");
return(info);
}
/// <summary>
/// 删除会员复销信息
/// </summary>
/// <param name="strId">报单编号</param>
/// <returns></returns>
public string DelMembersDeclaration(string orderId, double totalPv, string number, int except, string storeId, double lackproductmoney)
{
string info = null;
MemberOrderModel order = MemberOrderDAL.GetMemberOrder(orderId);
using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
#region 处理组合商品库存
/*
* List<MemberDetailsModel> groupItemList2 = new AddOrderBLL().GetDetails(orderId);
* List<OrderProduct3> oldSmallItem = new List<OrderProduct3>();
* for (int i = 0; i < groupItemList2.Count; i++)
* {
* if (groupItemList2[i].IsGroupItem != "")
* {
* oldSmallItem = new AddMemberInfomDAL().GetSamllItemList(groupItemList2[i].ProductId.ToString());
* for (int j = 0; j < oldSmallItem.Count; j++)
* {
* int hasOnly = new AddOrderDataDAL().SmallItemIsOnlyInGroup(oldSmallItem[j].Id, orderId);
* if (hasOnly <= 0)
* {
* oldSmallItem[j].Count *= groupItemList2[i].Quantity;
* int never = new AddOrderDataDAL().updateStore10(storeId, oldSmallItem[j], tran);
* if (never <= 0)
* {
* tran.Rollback();
* conn.Close();
* conn.Dispose();
* info = BLL.Translation.Translate("001730", "抱歉！系统异常！");
* return info;
* }
* }
*
* }
* }
* }*/
#endregion
//如果该订单不存在
if (!BrowsememberordersDAL.CheckOrderIdExists(tran, orderId))
{
info = BLL.Translation.Translate("001661", "抱歉，该订单不存在！");
tran.Rollback();
conn.Close();
conn.Dispose();
return(info);
}
//删除复消单
if (order.DefrayState == 1)
{
if (lackproductmoney > 0)
{
D_AccountBLL.AddAccount(storeId, lackproductmoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还，订单号为【" + orderId + "】", tran);
}
}
else if (order.DefrayState == 2)
{
string electronicaccountid = order.ElectronicaccountId;;
if (lackproductmoney > 0)
{
IsElecPay(tran, order);
D_AccountBLL.AddAccount(storeId, lackproductmoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还，订单号为【" + orderId + "】", tran);
D_AccountBLL.AddAccount(electronicaccountid, lackproductmoney, D_AccountSftype.MemberType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还，订单号为【" + orderId + "】", tran);
}
}
if (order.DefrayState == 1)
{
int result = new AddOrderDataDAL().Js_delfuxiao(number, totalPv, except, order.DefrayState, tran);
}
try
{
new AddOrderDataDAL().Del_Horder(tran, orderId, storeId, CommonDataBLL.OperateBh, CommonDataBLL.OperateIP);
tran.Commit();
}
catch (Exception)
{
tran.Rollback();
info = BLL.Translation.Translate("001730", "抱歉！系统异常！");
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(info);
}
/// <summary>
/// 注册报单流程（包括判断）
/// 调用逻辑层中的所有方法
/// </summary>
public void AddOrderAndInfoProcess()
{
string number = CommonDataBLL.quanjiao(txtNumber.Text.Trim());
number = number.Remove(0, number.Length - 8);
txtNumber.Text = number.Remove(0, number.Length - 8);
//会员名是否小于6位
if (!registermemberBLL.NumberLength(number))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('抱歉！您输入的会员编号小于6位！');</script>", false);
return;
}
if (!registermemberBLL.NumberCheckAgain(number))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('编号请输入字母，数字，横线！');</script>", false);
return;
}
//验证手机号码是否重复
if (registermemberBLL.CheckTeleTwice(txtTele.Text.Trim()) != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('抱歉！该手机号码已被注册！');</script>", false);
return;
}
string name = CommonDataBLL.quanjiao(txtNamee.Text.Trim());
if (name == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('真实姓名不能为空');</script>", false);
return;
}
//判断用胡地址是否输入
if (this.CountryCity2.Country == "请选择" || this.CountryCity2.Province == "请选择" || this.CountryCity2.City == "请选择" || this.CountryCity2.Xian == "请选择" || this.CountryCity2.Country == "" || this.CountryCity2.Province == "" || this.CountryCity2.City == "" || this.CountryCity2.Xian == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('对不起，请选择国家省份城市！');</script>", false);
return;
}
if (DAL.CommonDataDAL.GetCPCCode(this.CountryCity2.Country, this.CountryCity2.Province, this.CountryCity2.City, this.CountryCity2.Xian) == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('对不起，请选择国家省份城市！');</script>", false);
return;
}
MemberInfoModel mi = AddUserInfo();
//if (mi.Placement != "8888888888")
//{
// if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + mi.Placement + "' and District=" + mi.District + "").ToString() != "0")
// {
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('安置人所选区位已有人安置！');</script>", false);
// return;
// }
//}
Session["mbreginfo"] = mi;
Session["OrderType"] = mi.OrderType;
Session["UserType"] = 1;
if (Session["mbreginfo"] != null)
{
decimal totalmoeny = 0.00M;
decimal bili = 0.00M;
DataTable dts = DAL.DBHelper.ExecuteDataTable("select top 1 * from config order by createdate desc");
if (dts.Rows != null && dts.Rows.Count > 0)
{
totalmoeny = Convert.ToDecimal(dts.Rows[0]["para1"]);//投资金额
bili = Convert.ToDecimal(dts.Rows[0]["para4"]);
}
OrderFinalModel ofm = new OrderFinalModel();
var dayPrice = CommonDataBLL.GetMaxDayPrice();
var value = Convert.ToDecimal(totalmoeny) / Convert.ToDecimal(dayPrice);//投资金额换化石斛积分
decimal totalpv = 0.0M;
var expect = CommonDataBLL.getMaxqishu();
totalpv = Convert.ToDecimal(value);
ofm.InvestJB = Convert.ToDecimal(value * bili); //投资石斛积分币数量
ofm.PriceJB = Convert.ToDecimal(dayPrice); //石斛积分当前市价
ofm.SendWay = 1;
ofm.Number = mi.Number;
ofm.Placement = mi.Placement;
ofm.Direct = mi.Direct;
ofm.ExpectNum = expect;
ofm.OrderID = registermemberBLL.GetOrderInfo("add", null);
ofm.StoreID = mi.StoreID;
ofm.Name = mi.Name;
ofm.PetName = mi.PetName;
ofm.LoginPass = mi.LoginPass;
ofm.AdvPass = mi.AdvPass;
ofm.LevelInt = mi.LevelInt;
ofm.RegisterDate = mi.RegisterDate;
ofm.Birthday = mi.Birthday;
ofm.Sex = mi.Sex;
ofm.HomeTele = mi.HomeTele;
ofm.OfficeTele = mi.OfficeTele;
ofm.MobileTele = mi.MobileTele;
ofm.FaxTele = mi.FaxTele;
ofm.CPCCode = mi.CPCCode;
ofm.Address = mi.Address;
ofm.PostalCode = mi.PostalCode;
ofm.PaperType.PaperTypeCode = mi.PaperType.PaperTypeCode;
ofm.PaperNumber = mi.PaperNumber;
ofm.BankCode = mi.BankCode;
ofm.BankAddress = mi.BankAddress;
ofm.BankCard = mi.BankCard;
ofm.BCPCCode = mi.BCPCCode;
ofm.BankBook = mi.BankBook;
ofm.Remark = mi.Remark;
ofm.ChangeInfo = mi.ChangeInfo;
ofm.PhotoPath = mi.PhotoPath;
ofm.Email = mi.Email;
ofm.IsBatch = mi.IsBatch;
ofm.Language = mi.Language;
ofm.OperateIp = mi.OperateIp;
ofm.OperaterNum = mi.OperaterNum;
ofm.Answer = mi.Answer;
ofm.Question = mi.Question;
ofm.Error = mi.Error;
ofm.Bankbranchname = mi.Bankbranchname;
ofm.Flag = mi.Flag;
ofm.Assister = mi.Assister;
ofm.District = mi.District;
ofm.TotalMoney = Convert.ToDecimal(totalmoeny);
ofm.TotalPv = Convert.ToDecimal(totalpv);//投资金额兑换成石斛积分
ofm.OrderType = mi.OrderType;
ofm.OrderExpect = expect;
ofm.StandardcurrencyMoney = ofm.TotalMoney;
ofm.PaymentMoney = ofm.TotalMoney;
ofm.OrderDate = DateTime.UtcNow;
ofm.RemittancesId = "";
ofm.ElectronicaccountId = "";
ofm.Type = Convert.ToInt32(rbltotaltype.SelectedValue);
ofm.ConCity.Country = "";
ofm.ConCity.Province = "";
ofm.ConCity.City = "";
ofm.ConCity.Xian = "";
ofm.ConAddress = "";
ofm.CCPCCode = "";
ofm.ConTelPhone = "";
ofm.ConMobilPhone = "";
ofm.CarryMoney = 0;
ofm.ConPost = "";
ofm.Consignee = "";
ofm.ConZipCode = "";
ofm.ProductIDList = "";
ofm.QuantityList = "";
ofm.NotEnoughProductList = "";
ofm.PhotoPath = "";
Boolean flag = new AddOrderDataDAL().AddFinalOrder(ofm);
if (flag)
{
ClientScript.RegisterStartupScript(GetType(), "msg", "<script>alert('注册成功');location.href='index.aspx';</script>", false);
//if (Session["UserType"].ToString() == "1")
//{
// int val = AddOrderDataDAL.OrderPayment(ofm.StoreID, ofm.OrderID, ofm.OperateIp, 3, 1, 10, "管理员", "", 1, -1, 1, 1, "", 0, "");
// if (val == 0)
// {
// PublicClass.SendMsg(1, ofm.OrderID, "");
// }
//}
}
}
//string CheckMember = registermemberBLL.CheckMemberInProc1(mi.Number, mi.LoginPass, mi.Direct, mi.MobileTele);
//CheckMember = new GroupRegisterBLL().GerCheckErrorInfo(CheckMember);
//if(CheckMember=="1")
//{
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('注册成功！');</script>", false);
// return;
//}
}
/// <summary>
/// 购买矿机
/// </summary>
/// <param name="chosenum"></param>
/// <returns></returns>
public void GetRegSendPost()
{
int chosenum = Convert.ToInt32(hidetp.Value);
if (Session["Member"] == null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('未登录！');</script>", false);
return; //未登录
}
string number = Session["Member"].ToString();
int cc = Convert.ToInt32(DBHelper.ExecuteScalar("select count(0) from memberorder where DefrayState=1 and isactive=0 and ordertype<>0 and number='" + number + "' "));
if (cc > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('您有未激活的矿机，请激活后再升级！'); setTimeout(function(){ window.location.href='orderlist.aspx'},2000); </script>", false);
return;
}
int re = 0;
///获取usdt账户
int lv = 0;
//檢測是否有未支付的單子 如果有則走未支付的訂單
double ddmm = 0;
string orderid = "";
//DataTable ddt = DBHelper.ExecuteDataTable("select top 1 OrderID,TotalMoney from memberorder where DefrayState=0 order by id ");
//if (ddt != null && ddt.Rows.Count > 0)
//{
// DataRow dr = ddt.Rows[0];
// ddmm = Convert.ToDouble(dr["TotalMoney"]);
// orderid = dr["orderid"].ToString();
// return;
//}
//清除未支付订单
DBHelper.ExecuteNonQuery(@" insert into memberorderdel(id,[Number],[OrderID],[StoreID],[TotalMoney]
,[TotalPv],[CarryMoney],[OrderExpectNum],[PayExpectNum]
,[IsAgain],[OrderDate],[Error],[Remark],[DefrayState],[Consignee]
,[CCPCCode],[ConCity],[ConAddress]
,[ConZipCode],[ConTelphone]
,[ConMobilPhone],[ConPost]
,[DefrayType],[PayMoney]
,[PayCurrency],[StandardCurrency]
,[StandardCurrencyMoney],[OperateIP]
,[OperateNum],[RemittancesID],[ElectronicAccountID],[ordertype]
,[IsReceivables],[PayMentMoney],[ReceivablesDate],[EnoughProductMoney]
,[LackProductMoney],[IsReturn],[SendType],[SendWay],[TotalMoneyReturned]
,[TotalPvReturned],[OrderStatus],[TotalMoneyReturning],[TotalPvReturning]
,[OrderStatus_NR],[Isjjff],[trackingnum],[InvestJB]
,[PriceJB],[isSend],[xjpay],[xfpay],[bdpay],[ISSettle])
select id,[Number],[OrderID],[StoreID],[TotalMoney]
,[TotalPv],[CarryMoney],[OrderExpectNum],[PayExpectNum]
,[IsAgain],[OrderDate],[Error],[Remark],[DefrayState],[Consignee]
,[CCPCCode],[ConCity],[ConAddress]
,[ConZipCode],[ConTelphone]
,[ConMobilPhone],[ConPost]
,[DefrayType],[PayMoney]
,[PayCurrency],[StandardCurrency]
,[StandardCurrencyMoney],[OperateIP]
,[OperateNum],[RemittancesID],[ElectronicAccountID],[ordertype]
,[IsReceivables],[PayMentMoney],[ReceivablesDate],[EnoughProductMoney]
,[LackProductMoney],[IsReturn],[SendType],[SendWay],[TotalMoneyReturned]
,[TotalPvReturned],[OrderStatus],[TotalMoneyReturning],[TotalPvReturning]
,[OrderStatus_NR],[Isjjff],[trackingnum],[InvestJB]
,[PriceJB],[isSend],[xjpay],[xfpay],[bdpay],[ISSettle]
from MemberOrder where DefrayState = 0
and number ='" + number + "' ");
//删除未支付的订单
DBHelper.ExecuteNonQuery("delete from memberorder where DefrayState=0 and number='" + number + "' ");
DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select LevelInt from memberinfo where Number='" + number + "'");
if (dt_one.Rows != null && dt_one.Rows.Count > 0)
{
lv = Convert.ToInt32(dt_one.Rows[0]["LevelInt"]);//获取账户等级
}
double zhye = 0;
int jd = Common.GetcurJieDuan();//获取阶段状态
if ((lv == 1 || (lv == 0 && chosenum > 1)) && jd == 1)
{
zhye = CommandAPI.GetActMoney();
}
if (chosenum < 0 || chosenum > 8 || lv > chosenum)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('请选择矿机！');</script>", false);
return;
} //选择购买的矿机
ConfigModel cm = ConfigDAL.GetConfig();
double ttmoney = 0;
double ttpv = 0;
int ordertype = 22; // 0 第一次购买 1 补差升级
int isagain = 0;
double yymoney = 0;
// int ispay = 0; ///支付状态
if (lv == 0)
{
ordertype = 22; //抢购20u
}
if (lv == 1 || (lv == 0 && chosenum > 1))
{
ordertype = 23; //购买
}
if (lv == 2)
{
yymoney = cm.Para2;
}
if (lv == 3)
{
yymoney = cm.Para3;
}
if (lv == 4)
{
yymoney = cm.Para4;
}
if (lv == 5)
{
yymoney = cm.Para5;
}
if (lv == 6)
{
yymoney = cm.Para6;
}
if (lv == 7)
{
yymoney = cm.Para7;
}
if (lv == 7)
{
ordertype = 25; //复投
}
if (chosenum == 1)
{
ttmoney = cm.Para1; ttpv = 0;
} //20u 不计算业绩
if (chosenum == 2)
{
ttmoney = cm.Para2 - yymoney; ttpv = cm.Para2 - yymoney;
}
if (chosenum == 3)
{
ttmoney = cm.Para3 - yymoney; ttpv = cm.Para3 - yymoney;
}
if (chosenum == 4)
{
ttmoney = cm.Para4 - yymoney; ttpv = cm.Para4 - yymoney;
}
if (chosenum == 5)
{
ttmoney = cm.Para5 - yymoney; ttpv = cm.Para5 - yymoney;
}
if (chosenum == 6)
{
ttmoney = cm.Para6 - yymoney; ttpv = cm.Para6 - yymoney;
}
if (chosenum == 7)
{
ttmoney = cm.Para7 - yymoney; ttpv = cm.Para7 - yymoney;
}
//if (chosenum == 8) { ttmoney = cm.Para28 - yymoney; ttpv = cm.Para28 - yymoney; }
if (yymoney > 0)
{
isagain = 1; ordertype = 24;
} //升级
DataTable dtmb = DBHelper.ExecuteDataTable("select pointAin-pointAout as ablc,pointbin-pointbout as bblc,pointcin-pointcout as cblc,pointdin-pointdout as dblc,pointein-pointeout as eblc from memberinfo where number='" + number + "'");
DataTable conp = DBHelper.ExecuteDataTable("select CoinIndex ,coinnewprice from CoinPlant order by id ");
double ablc = 0; double bblc = 0; double cblc = 0; double dblc = 0; double eblc = 0;
double cap = 0; double cbp = 0; double ccp = 0; double cdp = 0; double cep = 0;
if (dtmb != null && dtmb.Rows.Count > 0)
{
DataRow dr = dtmb.Rows[0];
ablc = Convert.ToDouble(dr["ablc"]);
bblc = Convert.ToDouble(dr["bblc"]);
cblc = Convert.ToDouble(dr["cblc"]);
dblc = Convert.ToDouble(dr["dblc"]);
eblc = Convert.ToDouble(dr["eblc"]);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足！');</script>", false);
return;
}
if (conp != null && conp.Rows.Count > 0)
{
foreach (DataRow item in conp.Rows)
{
string s = item["CoinIndex"].ToString();
if (s == "CoinA")
{
cap = Convert.ToDouble(item["coinnewprice"]);
}
if (s == "CoinB")
{
cbp = Convert.ToDouble(item["coinnewprice"]);
}
if (s == "CoinC")
{
ccp = Convert.ToDouble(item["coinnewprice"]);
}
if (s == "CoinD")
{
cdp = Convert.ToDouble(item["coinnewprice"]);
}
if (s == "CoinE")
{
cep = Convert.ToDouble(item["coinnewprice"]);
}
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足！');</script>", false);
return;
}
double aneed = 0;
double bneed = 0;
double cneed = 0;
double eneed = 0;
if (lv > 0)
{
if (jd == 1)
{
if (zhye < ttmoney)
{
//ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足！');</script>", false);
//return;
}//余额不足
else if (jd == 2 || jd == 3)
{
aneed = ttmoney / cap;
if (aneed > ablc)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足！');</script>", false);
return;
}
; //余额不足
}
else if (jd == 4 || jd == 5)
{
aneed = (ttmoney * 0.5) / cap;
bneed = (ttmoney * 0.5) / cbp;
if (aneed > ablc || bneed > bblc)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足！');</script>", false);
return;
}//余额不足
}
else if (jd == 6 || jd == 7)
{
aneed = (ttmoney * 0.2) / cap;
bneed = (ttmoney * 0.3) / cbp;
cneed = (ttmoney * 0.5) / ccp;
if (aneed > ablc || bneed > bblc || cneed > cblc)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> showsuc('账户余额不足！');</script>", false);
return;
}//余额不足
}
}
if (jd > 0 && chosenum > 1) /// 如果是20u以上 则需要额外支付 5% 的E
{
eneed = (ttmoney * 0.05) / cep;
//if (eneed > eblc)
//{
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('火星币余额不足，请先去抢购兑换！');</script>", false);
// return;
//}
//余额不足
Session["Eneed"] = eneed;
}
}
RegistermemberBLL registermemberBLL = new RegistermemberBLL();
orderid = registermemberBLL.GetOrderInfo("add", null);
int maxexpt = ConfigDAL.GetMaxExpectNum();
Boolean flag = new AddOrderDataDAL().AddOrderInfo(number, orderid, maxexpt, isagain, ttmoney, ttpv, ordertype);
Session["choselv"] = chosenum; //保存当前选中级别
if (flag) //插入订单成功 开始支付
{
if (jd == 1 && chosenum > 1) //说明是第一阶段的所有购买都 必须使用USDT买
{
Session["orderid"] = orderid;
string postf = CommandAPI.GetFunction(orderid, ttmoney.ToString(), "recast.aspx", RadioButtonList1.SelectedValue);
ClientScript.RegisterStartupScript(this.GetType(), "", postf, false);
return;
}
else
{
//本地支付开始
int r = MemberOrderDAL.PayOrder(number, orderid, aneed, bneed, cneed, eneed, chosenum, "使用本地币种账户支付");
if (r == 1)
{
//销毁
if (aneed > 0)
{
CommandAPI.Destruction("A", aneed);
}
if (bneed > 0)
{
CommandAPI.Destruction("B", bneed);
}
if (cneed > 0)
{
CommandAPI.Destruction("C", cneed);
}
// if (eneed > 0) CommandAPI.Destruction("E", eneed);
if (eneed > 0)
{
int ee = MemberOrderDAL.payOrderEcoin(number, orderid, eneed, "E币支付，激活成功");
if (ee == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买矿机激活成功！');</script>", false);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('支付成功，请使用E币激活矿机！'); setTimeout(function(){ window.location.href='orderlist.aspx'},3000); </script>", false);
}
}
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买成功！');</script>", false);
return;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买失败！');</script>", false);
return;
}
}
}
}
/// <summary>
/// 支付按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnsure_Click(object sender, EventArgs e)
{
double currency = AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()));
int res = -1;
string usemoney = lbltotalmoney.Text.Trim();
string billid = ViewState["billid"].ToString();
int roletype = Convert.ToInt32(ViewState["roletype"]);
int dotype = Convert.ToInt32(ViewState["dotype"]);
loginnumber = ViewState["loginnumber"].ToString();
string curip = Request.UserHostAddress.ToString();
if (!rdorempay.Checked) //非离线支付
{
if (ViewState["remid"] != null)
{
RemittancesDAL.DelRemittancesrelationremtemp(ViewState["remid"].ToString());
}
}
else //使用离线支付方式
{
if (ViewState["remid"] != null)
{
RemittancesDAL.UPRemittancesre(ViewState["remid"].ToString());
}
}
if (rdoonlinepay.Checked) //在线支付
{
string hkid = billid;
ClientScript.RegisterStartupScript(GetType(), "msg", "alert('该功能正在开发中，请耐心等候！！！');", true);
return;
if (dotype == 1)
{
hkid = RemittancesDAL.AddRemittancebytypeOnline(billid, roletype, curip, loginnumber, 1);
}
else if (dotype == 2)
{
RemittancesDAL.UpdateOnlinepayway(billid, 4);
}
string posturl = Getposturl(hkid);
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>window.open ('" + posturl + "');</script>");
this.btnsure.Enabled = false;
return;
}
else if (rdorempay.Checked) //离线支付
{
//usemoney = (double.Parse(lblrmb.Text.Trim()) * currency).ToString();
usemoney = double.Parse(lblrmb.Text.Trim()).ToString("0.00");
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("100" + "," + billid + "," + usemoney) + "';</script>");
return;
}
else if (rdostorepay.Checked) //去店铺支付
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("101" + "," + billid + "," + usemoney) + "';</script>");
return;
}
else if (rdoectpay.Checked) //会员电子货币支付
{
if (MemberOrderDAL.Getvalidteiscanpay(billid, loginnumber)) //限制订单必须有订货所属店铺推荐人协助人支付)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007452", "该订单不属于您的协助或推荐报单，不能完成支付！") + "'); window.location.href='../Logout.aspx'; </script>");
return;
}
if (ViewState["odnumber"].ToString() != loginnumber)//如果不是自己给自己支付
{
if (this.rdombsuregetmoney.SelectedValue == "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007455", "请确认已收到该会员支付的报单金额") + "'); </script>");
return;
}
}
if (this.txtadvpass.Text == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("006656", "二级密码不能为空！") + "');</script>");
return;
}
string oldPass = Encryption.Encryption.GetEncryptionPwd(this.txtadvpass.Text.ToString(), loginnumber);
int n = PwdModifyBLL.check(loginnumber, oldPass, 1);
if (n <= 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("006058", "二级密码不正确！") + "'); </script>");
return;
}
if (MemberInfoDAL.CheckState(Session["Member"].ToString()))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007456", "会员账户已冻结，不能完成支付!") + "'); </script>");
return;
}
DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select ordertype from MemberOrder where OrderID=" + billid);
string ordertype = dt_one.Rows[0]["ordertype"].ToString();//订单类型
int act;
if (ordertype == "22" || ordertype == "12")
{
act = Convert.ToInt32(rdoaccounttype2.SelectedValue);
}
else if (ordertype == "25")
{
act = Convert.ToInt32(rdoaccounttype3.SelectedValue);
}
else
{
act = Convert.ToInt32(rdoaccounttype.SelectedValue);
}
res = AddOrderDataDAL.OrderPayment(loginnumber, billid, curip, roletype, dotype, act, loginnumber, "", 2, -1, 1, 1, "", double.Parse(usemoney), "");
this.btnsure.Enabled = false;
}
else if (rdostpaymb.Checked) //店铺支付 会员订单
{
if (MemberOrderDAL.Getvalidteiscanpay(billid, loginnumber)) //限制订单必须有订货所属店铺推荐人协助人支付)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007452", "该订单不属于您的协助或推荐报单，不能完成支付！") + "'); window.location.href='../Logout.aspx'; </script>");
return;
}
if (this.rdoisagree.SelectedValue == "0") //验证是否确认收到款
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007455", "请确认已收到该会员支付的报单金额") + "！'); </script>");
return;
}
if (this.txtpayadbpass.Text == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("006656", "二级密码不能为空！") + "');</script>");
return;
}
string oldPass = Encryption.Encryption.GetEncryptionPwd(this.txtpayadbpass.Text.ToString(), Session["Store"].ToString());
int n = PwdModifyBLL.checkstore(loginnumber, oldPass, 1);
if (n <= 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("006058", "二级密码不正确！") + "'); </script>");
return;
}
int act = Convert.ToInt32(rdostactypepaymb.SelectedValue);
res = AddOrderDataDAL.OrderPayment(loginnumber, billid, curip, 2, 3, act, loginnumber, "", 5, -1, 1, 1, "", double.Parse(usemoney), "");
this.btnsure.Enabled = false;
}
else if (rdostopayorder.Checked) //店铺电子账户支付 订货单
{
if (this.txtstadvpass.Text == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("006656", "二级密码不能为空！") + "');</script>");
return;
}
string oldPass = Encryption.Encryption.GetEncryptionPwd(this.txtstadvpass.Text.ToString(), Session["Store"].ToString());
int n = PwdModifyBLL.checkstore(loginnumber, oldPass, 1);
if (n <= 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("006058", "二级密码不正确！") + "'); </script>");
return;
}
int act = Convert.ToInt32(rdostaccount.SelectedValue);
res = AddOrderDataDAL.OrderPayment(loginnumber, billid, curip, roletype, dotype, act, loginnumber, "", 2, -1, 1, 1, "", double.Parse(usemoney), ""); this.btnsure.Enabled = false;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("000000", "请至少选择一种支付方式！") + "'); </script>");
return;
}
PublicClass.SendMsg(1, billid, "");
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt(res.ToString() + "," + billid + "," + usemoney) + "';</script>");
return;
}
public static string AuditingOrder(string orderid)
{
string error = ""; //返回错误信息
MemberOrderModel mo = MemberOrderDAL.GetMemberOrder(orderid); //获取报单信息
List <MemberDetailsModel> list = ViewFuXiaoBLL.GetDetails(mo.OrderId); //获取订单明细
//判断报单是否支付
if (mo.DefrayState != 0)
{
return(BLL.Translation.Translate("000987", "报单不可重复确认"));// "报单不可重复确认！";
}
//验证店铺钱是否够支付保单
double notEnoughmoney = new RegistermemberBLL().CheckMoneyIsEnough(list, mo.StoreId);
double storeLeftMoney = new StoreDataDAL().GetLeftRegisterMemberMoney(mo.StoreId);
if (storeLeftMoney < notEnoughmoney)
{
return(BLL.Translation.Translate("006018", "对不起，您的报单额不足！"));// "报单不可重复确认！";
}
//更改--报单信息
mo.RemittancesId = MYDateTime.ToYYMMDDHHmmssString();
mo.DefrayState = 1;
mo.PayExpect = CommonDataBLL.getMaxqishu();
//double notEnoughmoney = new RegistermemberBLL().CheckMoneyIsEnough(list, mo.StoreId);
IList <MemberDetailsModel> listnew = CommonDataBLL.GetNewOrderDetail1(list);
for (int i = 0; i < list.Count; i++)
{
int left = BLL.CommonClass.CommonDataBLL.GetLeftLogicProductInventory(Convert.ToInt32(listnew[i].ProductId));
if (left < listnew[i].Quantity)
{
return(BLL.Translation.Translate("005967", "对不起，公司库存不够") + "！" + listnew[i].ProductName + BLL.Translation.Translate("005970", "库存数只有") + "：" + left);
}
}
//转化汇率
notEnoughmoney = new RegistermemberBLL().ChangeNotEnoughMoney(mo.StoreId, notEnoughmoney);
double EnoughProductMoney = Convert.ToDouble(new RegistermemberBLL().getEnoughProductMoney(list, mo.StoreId));
mo.EnoughProductMoney = Convert.ToInt32(EnoughProductMoney);
mo.LackProductMoney = Convert.ToInt32(notEnoughmoney);
//拆分组合产品
IList <MemberDetailsModel> md = BLL.CommonClass.CommonDataBLL.GetNewOrderDetail1(list);
System.Web.HttpContext.Current.Application.UnLock();
System.Web.HttpContext.Current.Application.Lock();
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
//更新会员订单信息
if (!CommonDataBLL.ConfirmMembersOrder(tran, mo.OrderId, mo.PayExpect, mo.EnoughProductMoney, mo.LackProductMoney))
{
tran.Rollback();
System.Web.HttpContext.Current.Application.UnLock();
return(BLL.Translation.Translate("000993", "确认失败"));
}
//更新店铺库存
foreach (MemberDetailsModel memberDetailsModel in list)
{
//循环根据订单明细跟新库存
int result = ViewFuXiaoBLL.UptStock(tran, memberDetailsModel.StoreId, memberDetailsModel.ProductId, memberDetailsModel.Quantity, memberDetailsModel.NotEnoughProduct);
//如果该店铺无盖商品记录，则在店库存表中加记录
if (result <= 0)
{
new BrowseMemberOrdersBLL().updateStore2(memberDetailsModel, tran);
}
if (memberDetailsModel.NotEnoughProduct > 0)
{
if (!CommonDataBLL.ConfirmMembersDetails(tran, memberDetailsModel.ProductId, mo.OrderId, memberDetailsModel.NotEnoughProduct))
{
tran.Rollback();
System.Web.HttpContext.Current.Application.UnLock();
return(BLL.Translation.Translate("000993", "确认失败"));
}
}
}
//处理公司逻辑库存
int sd = new DAL.AddOrderDataDAL().updateStoreL(tran, md);
//报单生成订单
Insert_OrderGoods(list, mo, tran);
if (mo.DefrayType == 1)
{
if (Convert.ToDouble(mo.LackProductMoney) > 0)
{
//记录对账单明细
BLL.Logistics.D_AccountBLL.AddAccount(mo.StoreId, Convert.ToDouble(mo.LackProductMoney), D_AccountSftype.StoreType, D_AccountKmtype.Declarations, DirectionEnum.AccountReduced, "会员【" + mo.Number + "】报单现金扣除额，订单号为【" + mo.OrderId + "】", tran);
}
}
if (mo.DefrayType == 2)
{
//记录对账单明细
BLL.Logistics.D_AccountBLL.AddAccount(mo.ElectronicaccountId, Convert.ToDouble(mo.TotalMoney), D_AccountSftype.MemberType, D_AccountKmtype.Declarations, DirectionEnum.AccountReduced, "会员【" + mo.Number + "】用会员【" + mo.ElectronicaccountId + "】电子货币报单，订单号为【" + mo.OrderId + "】", tran);
BLL.Logistics.D_AccountBLL.AddAccount(mo.StoreId, Convert.ToDouble(mo.TotalMoney), D_AccountSftype.StoreType, D_AccountKmtype.Declarations, DirectionEnum.AccountsIncreased, "会员【" + mo.Number + "】用会员【" + mo.ElectronicaccountId + "】电子货币报单转入，订单号为【" + mo.OrderId + "】", tran);
if (Convert.ToDouble(mo.LackProductMoney) > 0)
{
BLL.Logistics.D_AccountBLL.AddAccount(mo.StoreId, Convert.ToDouble(mo.LackProductMoney), D_AccountSftype.StoreType, D_AccountKmtype.Declarations, DirectionEnum.AccountReduced, "会员【" + mo.Number + "】报单现金扣除额，订单号为【" + mo.OrderId + "】", tran);
}
//更新电子账户余额
AddOrderDataDAL.UpdateECTPay(tran, mo.ElectronicaccountId, mo.LackProductMoney);
//更新店铺汇款
new AddOrderDataDAL().Add_Remittances(tran, Convert.ToDouble(mo.LackProductMoney), mo.StoreId);
//插入汇款信息
new AddOrderDataDAL().AddDataTORemittances(tran, mo);
}
//更新店铺报单款
new AddOrderDataDAL().updateStore3(mo.StoreId, tran, Convert.ToDouble(mo.LackProductMoney));
//判断是否是注册的会员
if (mo.IsAgain == 0)
{
//获取会员信息
MemberInfoModel mi = MemberOrderDAL.GetMemberInfo(orderid, tran);
//更新会员业绩,会员进入网络图
new AddOrderDataDAL().Upt_UpdateNew1(mi, tran);
//激活会员
int resultActive = new GroupRegisterBLL().uptIsActive(mi.Number, tran);
}
//实时更新会员级别
CommonDataBLL.SetMemberLevel(tran, mo.Number, mo.OrderId);
//提交事务
tran.Commit();
}
catch (Exception ex)
{
string sga = ex.Message;
error = BLL.Translation.Translate("000993", "确认失败");// "确认失败！";
tran.Rollback();
}
finally
{
conn.Close();
conn.Dispose();
System.Web.HttpContext.Current.Application.UnLock();
}
}
return(error);
}
protected void btnsureget_Click(object sender, EventArgs e)
{
int mtype = Convert.ToInt32(this.hidtype.Value);
if (this.hidremid.Value == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("007813", "请选择待支付的汇款单") + "！');</script>"); return;
}
if (this.txtgettime.Text == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("007814", "请填写收款时间") + "！');</script>"); return;
}
DateTime time = Convert.ToDateTime(this.txtgettime.Text + " " + this.ddlhours.SelectedValue + ":" + this.ddlmins.SelectedValue + ":" + this.ddlsecs.SelectedValue);
int res = -1;
string opip = Request.UserHostAddress.ToString();
string opter = Session["company"].ToString();
string rmid = this.hidremid.Value;
DataTable remittancedt = RemittancesDAL.GetRemittanceinfobyremid(rmid);
if (remittancedt != null && remittancedt.Rows.Count > 0)
{
int roltype = Convert.ToInt32(remittancedt.Rows[0]["RemitStatus"]) == 0?2:1;
string ord = remittancedt.Rows[0]["RelationOrderID"].ToString();
double totalrmbmoney = Convert.ToDouble(lblmoney.Text.Trim());
string remitnumber = remittancedt.Rows[0]["remitnumber"].ToString();
int isgsqr = Convert.ToInt32(remittancedt.Rows[0]["isgsqr"]);
int dotype = 0;
if (ord == "")
{
dotype = 2;
}
else
{
dotype = 1;
}
if (isgsqr == 0)
{
res = AddOrderDataDAL.OrderPayment(remitnumber, ord, opip, roltype, dotype, 0, opter, "", 4, 1, 1, 1, rmid, totalrmbmoney, ""); //
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("007815", "该汇款单已确认，不能重复操作") + "！');window.close();</script>");
}
}
if (res == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("007816", "确认收款成功") + "！');</script>");
RemittancesDAL.UpdateRemittancereceivabledate(this.hidremid.Value, time);//更新收款时间
this.hidremid.Value = "";
this.lblmoney.Text = GetTran("007809", "未选择");
this.lblname.Text = GetTran("007809", "未选择");
this.lblnumber.Text = GetTran("007809", "未选择");
this.lblremid.Text = GetTran("007809", "未选择");
this.lblremittancesdate.Text = GetTran("007809", "未选择");
this.txtgettime.Text = "";
this.ddlhours.SelectedIndex = 0;
this.ddlmins.SelectedIndex = 0;
this.ddlsecs.SelectedIndex = 0;
Binddatalist();
return;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("007817", "确认收款失败") + "！');</script>"); return;
}
}
/// <summary>
/// 调整网络方法
/// </summary>
/// <param name="number">会员编号</param>
/// <param name="placement">新安置</param>
/// <param name="direct">新推荐</param>
/// <param name="oldplacement">原安置</param>
/// <param name="olddirect">原推荐</param>
/// <returns></returns>
public static string ChenageNet(string number, string placement, string direct, string oldplacement, string olddirect, int flag, out bool isPass)
{
string topMemberID = BLL.CommonClass.CommonDataBLL.GetTopManageID(3);
int newqushu = 1;
//调安置
if (oldplacement.Trim() != placement.Trim())
{
newqushu = AddOrderDataDAL.GetDistrict(placement, 1);
}
int xs = 0;
if (placement != topMemberID)
{
xs = 3;
}
//@bianhao--调网编号
//@srcAnZhi--原安置
//@dirAnZhi--新安置
//@srcTuiJian--原推荐
//@dirTuiJian--新推荐
//@azXianShu--0:表示无限制，大于0则表示最大的线数
//@info output --失败时返回错误信息，反之返回'OK'
string info = "";
/*
* @bianhao nvarchar(20), --调网编号
* @srcAnZhi nvarchar(20), --原安置
* @dirAnZhi nvarchar(20), --新安置
* @srcTuiJian nvarchar(20), --原推荐
* @dirTuiJian nvarchar(20), --新推荐
* @azXianShu int, --0:表示无限制，大于0则表示最大的线数
* @info nvarchar(200) output --失败时返回错误信息，反之返回'OK' */
info = TempHistoryDAL.ChangeCheck(number, placement, direct, oldplacement, olddirect, newqushu, xs, info);
if (info != "OK")
{
isPass = false;
return(info);
}
int maxExpectNum = CommonDataBLL.GetMaxqishu();
//调层位序号
//@bianhao varchar(20), --编号
//@old varchar(20),--原位置
//@new varchar(20),--新位置
//@IsAz bit, --0：推荐；1：安置
//@qishu int --调网期
//TempHistoryDAL.ExecuteUpdateNew(number, placement, direct, tran, maxExpectNum, flag);
DateTime nowTime = DateTime.UtcNow;
int j = 0;
//调安置
if (oldplacement.Trim() != placement.Trim())
{
j = TempHistoryDAL.ExecuteUpdateNet(number, oldplacement, placement, 1, maxExpectNum, newqushu, CommonDataBLL.OperateBh, nowTime);
}
//调推荐
if (olddirect.Trim() != direct.Trim())
{
j = TempHistoryDAL.ExecuteUpdateNet(number, olddirect, direct, 0, maxExpectNum, newqushu, CommonDataBLL.OperateBh, nowTime);
}
if (j >= 0)
{
isPass = true;
return(new BLL.TranslationBase().GetTran("007134", "调网成功") + "!");
}
else
{
isPass = false;
return(new BLL.TranslationBase().GetTran("007135", "调网失败") + "!");
}
}
public MemberInfoModel AddUserInfo()
{
MemberInfoModel memberInfoModel = new MemberInfoModel();
memberInfoModel.Number = CommonDataBLL.quanjiao(HFNumber.Value.ToUpper());
memberInfoModel.Placement = CommonDataBLL.quanjiao(hidplacemnet.Value);
memberInfoModel.Direct = txtDirect.Text.Trim(); //Session["Member"].ToString();
memberInfoModel.ExpectNum = BLL.CommonClass.CommonDataBLL.getMaxqishu();
memberInfoModel.OrderID = "";
memberInfoModel.StoreID = "8888888888";
memberInfoModel.Name = "";
memberInfoModel.PetName = Encryption.Encryption.GetEncryptionName(txtName.Text.Trim());
memberInfoModel.OrderType = 21;
memberInfoModel.LoginPass = Encryption.Encryption.GetEncryptionPwd(memberInfoModel.Number, memberInfoModel.Number);
memberInfoModel.AdvPass = Encryption.Encryption.GetEncryptionPwd(memberInfoModel.Number, memberInfoModel.Number);
memberInfoModel.LevelInt = 0;//会员级别
memberInfoModel.RegisterDate = DateTime.UtcNow;
memberInfoModel.PaperType.Id = 0;
memberInfoModel.Birthday = Convert.ToDateTime("1990-01-01");
memberInfoModel.Sex = 0;
memberInfoModel.Assister = "";
memberInfoModel.OfficeTele = "";
memberInfoModel.HomeTele = "";
memberInfoModel.MobileTele = txtTele.Text;
memberInfoModel.FaxTele = "";
string country = this.CountryCity2.Country; //控件
string province = this.CountryCity2.Province; //控件
string city = this.CountryCity2.City; //控件
string xian = this.CountryCity2.Xian;
memberInfoModel.City.Country = country;
memberInfoModel.City.Province = province;
memberInfoModel.City.City = city;
memberInfoModel.City.Xian = xian;
memberInfoModel.CPCCode = DAL.CommonDataDAL.GetCPCCode(country, province, city, xian);
memberInfoModel.Address = Encryption.Encryption.GetEncryptionAddress(CommonDataBLL.quanjiao(this.txtAddress.Text.Trim()));
memberInfoModel.PostalCode = ""; //CommonDataBLL.quanjiao(this.Txtyb.Text.Trim());
var insert = @"INSERT INTO [ConsigneeInfo]
([Number],[Consignee],[MoblieTele],[CPCCode],[Address]
,IsDefault
)
VALUES
(@Number,@Consignee,@MoblieTele,@CPCCode,@Address,@IsDefault)";
SqlParameter[] insertpara =
{
new SqlParameter("@Number", SqlDbType.VarChar),
new SqlParameter("@Consignee", SqlDbType.VarChar),
new SqlParameter("@MoblieTele", SqlDbType.VarChar),
new SqlParameter("@CPCCode", SqlDbType.VarChar),
new SqlParameter("@Address", SqlDbType.VarChar),
new SqlParameter("@IsDefault", SqlDbType.Bit),
};
insertpara[0].Value = CommonDataBLL.quanjiao(HFNumber.Value.ToUpper());
insertpara[1].Value = Encryption.Encryption.GetEncryptionName(txtName.Text.Trim());
insertpara[2].Value = txtTele.Text;
insertpara[3].Value = DAL.CommonDataDAL.GetCPCCode(country, province, city, xian);
insertpara[4].Value = Encryption.Encryption.GetEncryptionAddress(CommonDataBLL.quanjiao(this.txtAddress.Text.Trim()));
insertpara[5].Value = true;
var insertvalue = DBHelper.ExecuteNonQuery(insert, insertpara, CommandType.Text);
string paperCode = null;
paperCode = "";
memberInfoModel.PaperType.PaperTypeCode = ""; //证件类型
memberInfoModel.PaperNumber = "";
memberInfoModel.BankCode = "";
memberInfoModel.BankAddress = "";
memberInfoModel.BankBook = memberInfoModel.Name;
memberInfoModel.BankCard = "";
//country = "";
//province = "";//控件
//city = "";//控件
//xian = "";
memberInfoModel.BCPCCode = DAL.CommonDataDAL.GetCPCCode(country, province, city, xian);
memberInfoModel.Remark = "";
memberInfoModel.ChangeInfo = "";
memberInfoModel.Email = "";
//memberInfoModel.District = SearchPlacement_DoubleLines1.District;
memberInfoModel.District = AddOrderDataDAL.GetDistrict(hidplacemnet.Value, Convert.ToInt32(hidDistrict.Value));
memberInfoModel.Answer = "";
memberInfoModel.Question = "";
memberInfoModel.IsBatch = Convert.ToInt32(ViewState["isBatch"]); //不是批量注册 modify
memberInfoModel.Language = 1;
memberInfoModel.OperateIp = CommonDataBLL.OperateIP; //调用方法
memberInfoModel.OperaterNum = CommonDataBLL.OperateBh; //调用方法
memberInfoModel.Error = ViewState["Error"] == null ? "" : ViewState["Error"].ToString();
memberInfoModel.Bankbranchname = "";
return(memberInfoModel);
}
protected void StartRecord_click(object sender, EventArgs e)
{
ConsigneeInfo cinfo = null;
var member = Session["Member"];
if (member != null)
{
cinfo = MemberInfoModifyBll.getconsigneeInfo(member.ToString(), true);
if (cinfo == null)
{
ScriptHelper.SetAlert(Page, "请先选择收货地址！", "PhoneSettings/SetConAddress.aspx?type=" + type + "&&url=AddLsOrder");
return;
}
}
else
{
Response.Redirect("~/MemberMobile/Index.aspx");
return;
}
string count = DBHelper.ExecuteScalar("select count(*) from MemShopCart where memBh='" + luo.MemBh + "' and mType=" + Session["UserType"].ToString() + " and odType=" + luo.OrderType).ToString();
if (count == "0" && Session["UserType"].ToString() != "1")
{
ScriptHelper.SetAlert(Page, GetTran("007430", "您至少要选择一种产品") + "!", "ShopingList.aspx");
return;
}
else
{
IList <MemberDetailsModel> choseProList = new List <MemberDetailsModel>();
OrderDeal od = new OrderDeal();
OrderFinalModel ofm = new OrderFinalModel();
ofm.SendWay = 1;//收货途径 会员收货
if (Session["EditOrderID"] != null)
{
OrderFinalModel model = new OrderFinalModel();
ofm = od.GetDataModelFx(Convert.ToInt32(Session["UserType"]), luo.OrderType, out choseProList, ofm.SendWay);
ofm.Assister = "";
}
else
{
if (luo.OrderType == 21 || luo.OrderType == 11 || luo.OrderType == 31)
{
ofm = od.GetDataModel(Convert.ToInt32(Session["UserType"]), luo.OrderType, out choseProList, ofm.SendWay);
if (new RegistermemberBLL().CheckNumberTwice(ofm.Number) != null)
{
ScriptHelper.SetAlert(Page, GetTran("007432", "会员编号已存在") + "！");
AgainTime.Value = "0";
DAL.DBHelper.ExecuteNonQuery("delete from MemShopCart where memBh='" + luo.MemBh + "' and mType=" + Session["UserType"].ToString());
return;
}
string placement = new RegistermemberBLL().GetHavePlacedOrDriect(ofm.Number, "", ofm.Placement, ofm.Direct);
if (placement != null)
{
ScriptHelper.SetAlert(Page, placement);
AgainTime.Value = "0";
DAL.DBHelper.ExecuteNonQuery("delete from MemShopCart where memBh='" + luo.MemBh + "' and mType=" + Session["UserType"].ToString());
return;
}
if (ofm.Placement != "8888888888")
{
if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + ofm.Placement + "' and District=" + ofm.District + "").ToString() != "0")
{
ScriptHelper.SetAlert(Page, GetTran("007433", "安置人所选区位已有人安置") + "！");
AgainTime.Value = "0";
DAL.DBHelper.ExecuteNonQuery("delete from MemShopCart where memBh='" + luo.MemBh + "' and mType=" + Session["UserType"].ToString());
return;
}
}
}
else
{
ofm = od.GetDataModelFx(Convert.ToInt32(Session["UserType"]), luo.OrderType, out choseProList, ofm.SendWay);
if (!MemberInfoDAL.IsMemberExist(ofm.Number))
{
ScriptHelper.SetAlert(Page, GetTran("000725", "会员编号不存在") + "！");
AgainTime.Value = "0";
return;
}
ofm.Assister = "";
}
if (luo.OrderType == 21 || luo.OrderType == 11)
{
if (Convert.ToDouble(ofm.TotalMoney) < SetParametersBLL.GetMemOrderLineOrderBaseLine())
{
ScriptHelper.SetAlert(Page, GetTran("000000", "会员注册金额不能低于") + SetParametersBLL.GetMemOrderLineOrderBaseLine().ToString("f2") + "！");
AgainTime.Value = "0";
return;
}
}
}
ofm.StoreID = "8888888888";
ofm.Type = 2;// 运货方式 邮寄 //Convert.ToInt32(this.ddth.SelectedValue);
//if (lblOdType.Text == GetTran("004008", "注册报单"))
//{
// ofm.IsAgain = 0;
//}
//else
//{
ofm.IsAgain = 1;
//}
ofm.OrderType = 12;
double yfStr = 0;
//地址
if (cinfo != null)
{
ofm.CCPCCode = cinfo.CPCCode;
ofm.ConTelPhone = cinfo.MoblieTele;
ofm.ConMobilPhone = cinfo.MoblieTele;
ofm.ConPost = "";
ofm.Consignee = Encryption.Encryption.GetEncryptionName(cinfo.Consignee);
ofm.ConZipCode = cinfo.ConZipCode;
ofm.ConAddress = Encryption.Encryption.GetEncryptionAddress(cinfo.Address);
}
//ofm.ConCity.Country = this.CountryCity2.Country;
//ofm.ConCity.Province = this.CountryCity2.Province;
//ofm.ConCity.City = this.CountryCity2.City;
//ofm.ConCity.Xian = this.CountryCity2.Xian;
//ofm.ConAddress = Encryption.Encryption.GetEncryptionAddress(this.Txtdz.Text);
//ofm.CCPCCode = DAL.CommonDataDAL.GetCPCCode(CountryCity2.Country, CountryCity2.Province, CountryCity2.City, CountryCity2.Xian);
yfStr = 0;
//ofm.ConTelPhone = txtOtherPhone.Text.Trim();
//ofm.ConMobilPhone = txtOtherPhone.Text.Trim(); //Txtyddh.Text.Trim();
//ofm.CarryMoney = Convert.ToDecimal(yfStr);
//ofm.ConPost = "";
//ofm.Consignee = Encryption.Encryption.GetEncryptionName(txtConName.Text.Trim());
//ofm.ConZipCode = txtPostCode.Text;
//ofm.Number = txtMemBh.Text;
//产品总费用、年费、运费、应付总金额
double pdtMoney = 0; //double.Parse(this.ltPrice.Text);
double CarriageMoney = 0; //运费
ofm.CarryMoney = decimal.Parse("0.00");
var dayPrice = CommonDataBLL.GetMaxDayPrice();
decimal yfje = Convert.ToDecimal(ofm.TotalMoney / Convert.ToDecimal(dayPrice));
ofm.TotalMoney = yfje + Convert.ToDecimal(CarriageMoney);
//运费类型
//if (ddth.SelectedValue == "1")//自提
//{
// ofm.CarryMoney = decimal.Parse("0.00");
// this.txtYunfei.Text = ofm.CarryMoney.ToString();
//}
//else
//{
// this.txtYunfei.Text = ofm.CarryMoney.ToString();
// ofm.TotalMoney = Convert.ToDecimal(ofm.TotalMoney) + Convert.ToDecimal(CarriageMoney);//加运费
//}
ofm.OrderExpect = CommonDataBLL.getMaxqishu();
ofm.StandardcurrencyMoney = yfje;
ofm.TotalPv = 0;
ofm.PaymentMoney = yfje;
ofm.LevelInt = 1;
ofm.StoreID = "8888888888";
ofm.InvestJB = yfje; //投资石斛积分币数量
ofm.PriceJB = Convert.ToDecimal(dayPrice); //石斛积分当前市价
ofm.OrderID = registermemberBLL.GetOrderInfo("add", null);
if (Session["EditOrderID"] != null)
{
int zhifuZt = Convert.ToInt32(DBHelper.ExecuteScalar("select defraystate from memberorder where orderid='" + Session["EditOrderID"] + "'"));
if (zhifuZt == 1)
{
ScriptHelper.SetAlert(Page, "该单已支付！不能修改！");
return;
}
SqlConnection conn = new SqlConnection(DBHelper.connString);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
ofm.OrderID = Session["EditOrderID"].ToString();
new AddOrderDataDAL().Del_Horder(Session["EditOrderID"].ToString(), tran);
Boolean flag = new DAL.AddOrderDataDAL().AddFinalOrderNoInfo(ofm, tran);
if (flag)
{
//p_content.Visible = false;
Session.Remove("mbreginfo");
Session.Remove("fxMemberModel");
Session.Remove("LUOrder");
Session.Remove("OrderType");
Session.Remove("EditOrderID");
Session.Remove("MemberUpgradeStore");
Session["MemberInfo_NP"] = ofm.Number + "," + ofm.Number; //储存会员的编号
tran.Commit();
conn.Close();
conn.Dispose();
DAL.DBHelper.ExecuteNonQuery("delete from MemShopCart where memBh='" + ofm.Number + "' and mType=" + Session["UserType"].ToString());//订单提交成功后，删除购物车
if (Session["UserType"].ToString() == "1")
{
int val = AddOrderDataDAL.OrderPayment(ofm.StoreID, ofm.OrderID, ofm.OperateIp, 1, 1, 1, "管理员", "", 4, -1, 1, 1, "", 0, "");
if (val == 0)
{
ClientScript.RegisterStartupScript(GetType(), "msg", "<script>alert('" + GetTran("000222", "修改成功") + "');location.href='../company/BrowseMemberOrders.aspx';</script>", false);
}
else
{
ClientScript.RegisterStartupScript(GetType(), "msg", "<script>alert('" + GetTran("007435", "修改成功自动支付失败") + "！');location.href='../company/BrowseMemberOrders.aspx';</script>", false);
}
}
else if (Session["UserType"].ToString() == "2")
{
if (ofm.IsAgain == 0)
{
//ClientScript.RegisterStartupScript(GetType(), "msg", "<script>var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../store/browsememberorders.aspx';</script>", false);
//ScriptManager.RegisterStartupScript(this, GetType(), "mag", "var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../store/browsememberorders.aspx';", true);
}
else
{
//ClientScript.RegisterStartupScript(GetType(), "msg", "<script>var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../store/viewfuxiao.aspx';</script>", false);
//ScriptManager.RegisterStartupScript(this, GetType(), "mag", "var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../store/browsememberorders.aspx';", true);
}
}
else
{
if (ofm.IsAgain == 0)
{
//ClientScript.RegisterStartupScript(GetType(), "msg", "<script>var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../member/browsememberorders.aspx';</script>", false);
//ScriptManager.RegisterStartupScript(this, GetType(), "mag", "var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../member/browsememberorders.aspx';", true);
}
else
{
//ClientScript.RegisterStartupScript(GetType(), "msg", "<script>var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../member/memberorder.aspx';</script>", false);
//ScriptManager.RegisterStartupScript(this, GetType(), "mag", "var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../member/browsememberorders.aspx';", true);
Response.Redirect("../payserver/chosepaysjpay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "");
}
}
}
else
{
tran.Rollback();
conn.Close();
conn.Dispose();
ScriptHelper.SetAlert(Page, GetTran("000225", "修改失败"));
}
}
else
{
Boolean flag = new DAL.AddOrderDataDAL().AddFinalOrder(ofm);
if (flag)
{
//p_content.Visible = false;
Session.Remove("mbreginfo");
Session.Remove("fxMemberModel");
Session.Remove("LUOrder");
Session.Remove("OrderType");
Session.Remove("EditOrderID");
Session.Remove("MemberUpgradeStore");
Session["MemberInfo_NP"] = ofm.Number + "," + ofm.Number; //储存会员的编号
DAL.DBHelper.ExecuteNonQuery("delete from MemShopCart where memBh='" + luo.MemBh + "' and mType=" + Session["UserType"].ToString()); //订单提交成功后，删除购物车
if (Session["UserType"].ToString() == "1")
{
int val = AddOrderDataDAL.OrderPayment(ofm.StoreID, ofm.OrderID, ofm.OperateIp, 1, 1, 1, "管理员", "", 5, -1, 1, 1, "", 0, "");
if (val == 0)
{
PublicClass.SendMsg(1, ofm.OrderID, "");
ClientScript.RegisterStartupScript(GetType(), "msg", "<script>alert('" + GetTran("000000", "购买成功") + "');location.href='../company/BrowseMemberOrders.aspx';</script>", false);
}
else
{
ClientScript.RegisterStartupScript(GetType(), "msg", "<script>alert('" + GetTran("000000", "报单成功，支付失败，店铺账户余额不足") + "！');location.href='../company/BrowseMemberOrders.aspx';</script>", false);
}
}
else if (Session["UserType"].ToString() == "2")
{
if (ofm.IsAgain == 0)
{
//Response.Redirect("../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1), true);
Response.Redirect("../payserver/chosepaysjpay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "");
}
else
{
Response.Redirect("../payserver/chosepaysjpay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "");
//Response.Redirect("../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1), true);
//ClientScript.RegisterStartupScript(GetType(), "msg", "<script>var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';</script>" , false);//+
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../store/viewfuxiao.aspx';"
}
}
else
{
if (ofm.IsAgain == 0)
{
Response.Redirect("../payserver/chosepaysjpay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "");
//Response.Redirect("../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1), true);
//ClientScript.RegisterStartupScript(GetType(), "msg", "<script>var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../membermobile/browsememberorders.aspx';</script>", false);
}
else
{
Response.Redirect("../payserver/chosepaysjpay.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "");
//Response.Redirect("../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1), true);
//ClientScript.RegisterStartupScript(GetType(), "msg", "<script>var formobj=document.createElement('form');"
// + "formobj.action='../payserver/chosepaysj.aspx?blif=" + EncryKey.GetEncryptstr(ofm.OrderID, 1, 1) + "';" +
// "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();location.href='../membermobile/memberorder.aspx';</script>", false);
}
}
}
else
{
ScriptHelper.SetAlert(Page, GetTran("001557", "报单失败！"));
}
}
}
}
/// <summary>
/// 审核支付报单
/// </summary>
/// <param name="orderid"> 报单编号 </param>
/// <returns>是否审核成功</returns>
public static string AuditingOrder(string orderid)
{
string error = ""; //返回错误信息
MemberOrderModel mo = MemberOrderDAL.GetMemberOrder(orderid); //获取报单信息
//判断报单是否支付
if (mo.DefrayState != 0)
{
return("报单不可重复确认！");
}
//获得店铺不足货时可以报单的金额
if (mo.DefrayType == 2)
{
double emoney = new AddOrderDataDAL().HaveMoney(mo.ElectronicaccountId);
if (Convert.ToDouble(mo.TotalMoney) > emoney)
{
return("电子账户余额不足，不能确认！");
}
}
//更改--报单信息
mo.RemittancesId = MYDateTime.ToYYMMDDHHmmssString();
mo.DefrayState = 1;
mo.PayExpect = CommonDataBLL.getMaxqishu();
List <MemberDetailsModel> list = ViewFuXiaoBLL.GetDetails(mo.OrderId);//获取订单明细
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
//更新会员订单信息
CommonDataBLL.ConfirmMembersOrder(tran, mo.OrderId, mo.PayExpect);
//更新店铺库存
foreach (MemberDetailsModel memberDetailsModel in list)
{//循环根据订单明细跟新库存
int result = ViewFuXiaoBLL.UptStock(tran, memberDetailsModel.StoreId, memberDetailsModel.ProductId, memberDetailsModel.Quantity, memberDetailsModel.NotEnoughProduct);
//如果该店铺无盖商品记录，则在店库存表中加记录
if (result <= 0)
{
new BrowseMemberOrdersBLL().updateStore2(memberDetailsModel, tran);
}
}
//更新店铺报单款
new AddOrderDataDAL().updateStore3(mo.StoreId, tran, Convert.ToDouble(mo.TotalMoney));
if (mo.DefrayType == 2)
{
//更新电子账户余额
AddOrderDataDAL.UpdateECTPay(tran, mo.ElectronicaccountId, mo.TotalMoney);
//更新店铺汇款
new AddOrderDataDAL().Add_Remittances(tran, Convert.ToDouble(mo.TotalMoney), mo.StoreId);
//插入汇款信息
new AddOrderDataDAL().AddDataTORemittances(tran, mo);
}
//更新会员业绩
new AddOrderDataDAL().Js_addfuxiao(mo.Number, Convert.ToDouble(mo.TotalPv), mo.PayExpect, mo.DefrayType, tran);//添加网络业绩
//插入订货单
AddOrderGoods(list, tran, mo);
//提交事务
tran.Commit();
}
catch
{
error = "确认失败！";
tran.Rollback();
}
finally
{
conn.Close();
}
}
return(error);
}
/// <summary>
/// 注册报单流程（包括判断）
/// 调用逻辑层中的所有方法
/// </summary>
public void AddOrderAndInfoProcess(string access_token)
{
try
{
string xx = "https://oauth.factorde.com/api/sns/user/info";
Dictionary <String, String> myD = new Dictionary <String, String>();
myD.Add("app_id", PublicClass.app_id);
myD.Add("access_token", access_token);
myD.Add("lang", "zh_CN");
myD.Add("version", "1.0");
myD.Add("charset", "utf8");
myD.Add("openid", Session["Member"].ToString());
//string jsonStr = PublicClass.GetSignContent(myD);
//jsonStr = HttpUtility.UrlEncode(jsonStr);//字符串进行编码，参数中有中文时一定需要这一步转换，否则接口接收的到参数会乱码
string hz = PublicClass.GetFunction(xx, myD);
//ck.Text = hz;
JObject studentsJson = JObject.Parse(hz);
Session["Member"] = studentsJson["data"]["openid"].ToString();
//if (studentsJson["data"]["nickname"].ToString() == null || studentsJson["data"]["nickname"].ToString() == "")
//{
// ClientScript.RegisterStartupScript(GetType(), "msg", "<script>alert('" + GetTran("000000", "请先实名认证") + "');</script>", false);
// return;
//}
int countdls = Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select count(0) from memberinfo where number='" + Session["Member"].ToString() + "'"));
if (countdls <= 0)
{
string number = Session["Member"].ToString();
string name = studentsJson["data"]["nickname"].ToString();
string mobile_number = studentsJson["data"]["mobile_number"].ToString();
string email = studentsJson["data"]["email"].ToString();
string parent_mobile_number = studentsJson["data"]["parent_mobile_number"].ToString();
string parent_email = studentsJson["data"]["parent_email"].ToString();
if (mobile_number == "")
{
mobile_number = email;
}
if (parent_mobile_number == "")
{
parent_mobile_number = parent_email;
}
DataTable dtdr = DAL.DBHelper.ExecuteDataTable("select number from memberinfo where MobileTele='" + parent_mobile_number + "'");
if (dtdr.Rows != null && dtdr.Rows.Count > 0)
{
parent_mobile_number = dtdr.Rows[0]["number"].ToString();//投资金额
}
MemberInfoModel mi = AddUserInfo(number, name, mobile_number, email, parent_mobile_number);
Session["mbreginfo"] = mi;
//Session["OrderType"] = 22;
Session["UserType"] = 3;
Session["LUOrder"] = Session["Member"].ToString() + ",12";
Session["languageCode"] = "L001";
if (Session["mbreginfo"] != null)
{
decimal totalmoeny = 0.00M;
decimal bili = 0.00M;
OrderFinalModel ofm = new OrderFinalModel();
var dayPrice = CommonDataBLL.GetMaxDayPrice();
var value = 0;//投资金额换化石斛积分
decimal totalpv = 0.0M;
var expect = CommonDataBLL.getMaxqishu();
totalpv = 0;
ofm.InvestJB = 0; //投资石斛积分币数量
ofm.PriceJB = Convert.ToDecimal(dayPrice); //石斛积分当前市价
ofm.SendWay = 1;
ofm.Number = mi.Number;
ofm.Placement = mi.Placement;
ofm.Direct = mi.Direct;
ofm.ExpectNum = expect;
ofm.OrderID = registermemberBLL.GetOrderInfo("add", null);
ofm.StoreID = mi.StoreID;
ofm.Name = mi.Name;
ofm.PetName = mi.PetName;
ofm.LoginPass = mi.LoginPass;
ofm.AdvPass = mi.AdvPass;
ofm.LevelInt = mi.LevelInt;
ofm.RegisterDate = mi.RegisterDate;
ofm.Birthday = mi.Birthday;
ofm.Sex = mi.Sex;
ofm.HomeTele = mi.HomeTele;
ofm.OfficeTele = mi.OfficeTele;
ofm.MobileTele = mi.MobileTele;
ofm.FaxTele = mi.FaxTele;
ofm.CPCCode = mi.CPCCode;
ofm.Address = mi.Address;
ofm.PostalCode = mi.PostalCode;
ofm.PaperType.PaperTypeCode = mi.PaperType.PaperTypeCode;
ofm.PaperNumber = mi.PaperNumber;
ofm.BankCode = mi.BankCode;
ofm.BankAddress = mi.BankAddress;
ofm.BankCard = mi.BankCard;
ofm.BCPCCode = mi.BCPCCode;
ofm.BankBook = mi.BankBook;
ofm.Remark = mi.Remark;
ofm.ChangeInfo = mi.ChangeInfo;
ofm.PhotoPath = mi.PhotoPath;
ofm.Email = mi.Email;
ofm.IsBatch = mi.IsBatch;
ofm.Language = mi.Language;
ofm.OperateIp = mi.OperateIp;
ofm.OperaterNum = mi.OperaterNum;
ofm.Answer = mi.Answer;
ofm.Question = mi.Question;
ofm.Error = mi.Error;
ofm.Bankbranchname = mi.Bankbranchname;
ofm.Flag = mi.Flag;
ofm.Assister = mi.Assister;
ofm.District = mi.District;
ofm.TotalMoney = Convert.ToDecimal(totalmoeny);
ofm.TotalPv = Convert.ToDecimal(totalpv);//投资金额兑换成石斛积分
ofm.OrderType = mi.OrderType;
ofm.OrderExpect = expect;
ofm.StandardcurrencyMoney = ofm.TotalMoney;
ofm.PaymentMoney = ofm.TotalMoney;
ofm.OrderDate = DateTime.UtcNow;
ofm.RemittancesId = "";
ofm.ElectronicaccountId = "";
ofm.Type = 0;
ofm.ConCity.Country = "";
ofm.ConCity.Province = "";
ofm.ConCity.City = "";
ofm.ConCity.Xian = "";
ofm.ConAddress = "";
ofm.CCPCCode = "";
ofm.ConTelPhone = "";
ofm.ConMobilPhone = "";
ofm.CarryMoney = 0;
ofm.ConPost = "";
ofm.Consignee = "";
ofm.ConZipCode = "";
ofm.ProductIDList = "";
ofm.QuantityList = "";
ofm.NotEnoughProductList = "";
ofm.PhotoPath = "";
Boolean flag = new AddOrderDataDAL().AddFinalOrder(ofm);
if (flag)
{
string sqljs = "exec dbo.js_addnew '" + Session["Member"].ToString() + "','','" + mi.Direct + "',0,1,0";
DBHelper.ExecuteNonQuery(sqljs);
int val = AddOrderDataDAL.OrderPayment(ofm.StoreID, ofm.OrderID, ofm.OperateIp, 3, 1, 10, "管理员", "", 1, -1, 1, 1, "", 0, "");
if (val == 0)
{
//PublicClass.SendMsg(1, ofm.OrderID, "");
DataTable dt = ChangeTeamBLL.GetMemberInfoDataTable(Session["Member"].ToString());
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() != "" && dt.Rows[0][0].ToString() != null)
{
string sqlqq = "select Number from memberinfo where MobileTele='" + dt.Rows[0][0].ToString() + "'";
DataTable dtt = DBHelper.ExecuteDataTable(sqlqq);
if (dtt.Rows.Count > 0)
{
string sql = "update memberinfo set Direct='" + dt.Rows[0][0].ToString() + "' where number='" + Session["Member"].ToString() + "'";
DBHelper.ExecuteNonQuery(sql);
string sqll = "update MemberInfoBalance" + CommonDataBLL.getMaxqishu() + " set Direct='" + dt.Rows[0][0].ToString() + "' where number='" + Session["Member"].ToString() + "'";
DBHelper.ExecuteNonQuery(sqll);
string sqljss = "exec dbo.js_addnew '" + Session["Member"].ToString() + "','','" + dt.Rows[0][0].ToString() + "',0,1,0";
DBHelper.ExecuteNonQuery(sqljss);
}
}
}
Response.Redirect("First.aspx");
ClientScript.RegisterStartupScript(GetType(), "msg", "<script>alert('" + GetTran("000436", "注册成功") + "');location.href='index.aspx';</script>", false);
}
else
{
ClientScript.RegisterStartupScript(GetType(), "msg", "<script>alert('" + GetTran("000000", "登陆失败，请联系管理员") + "');</script>", false);
}
}
}
}
else
{
string mobile_number = studentsJson["data"]["mobile_number"].ToString();
string email = studentsJson["data"]["email"].ToString();
string parent_mobile_number = studentsJson["data"]["parent_mobile_number"].ToString();
string parent_email = studentsJson["data"]["parent_email"].ToString();
DataTable dt = ChangeTeamBLL.GetMemberInfoDataTable(Session["Member"].ToString());
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() != "" && dt.Rows[0][0].ToString() != null)
{
if (dt.Rows[0][0].ToString() == parent_mobile_number || dt.Rows[0][0].ToString() == parent_email)
{
string sqlqq = "select Number,Direct,name from memberinfo where MobileTele='" + dt.Rows[0][0].ToString() + "'";
DataTable dtt = DBHelper.ExecuteDataTable(sqlqq);
if (dtt.Rows.Count > 0)
{
if (dtt.Rows[0]["Direct"].ToString() != null && dtt.Rows[0]["Direct"].ToString() != "")
{
string sql = "update memberinfo set Direct='" + dtt.Rows[0][0].ToString() + "' where number='" + Session["Member"].ToString() + "'";
DBHelper.ExecuteNonQuery(sql);
string sqll = "update MemberInfoBalance" + CommonDataBLL.getMaxqishu() + " set Direct='" + dtt.Rows[0][0].ToString() + "' where number='" + Session["Member"].ToString() + "'";
DBHelper.ExecuteNonQuery(sqll);
string sqljs = "exec dbo.js_addnew '" + Session["Member"].ToString() + "','','" + dtt.Rows[0][0].ToString() + "',0,1,0";
DBHelper.ExecuteNonQuery(sqljs);
}
if (dtt.Rows[0]["name"].ToString() == "" || dtt.Rows[0]["name"].ToString() == null)
{
string name = studentsJson["data"]["nickname"].ToString();
string sql = "update memberinfo set name='" + name + "' where number='" + Session["Member"].ToString() + "'";
DBHelper.ExecuteNonQuery(sql);
}
}
}
}
}
Response.Redirect("First.aspx");
}
}
catch (Exception)
{
ClientScript.RegisterStartupScript(GetType(), "msg", "<script>alert('" + GetTran("000000", "登陆失败，请确认云端钱包是否登录") + "');</script>", false);
}
}
protected void gvStoreOrder_RowCommand(object sender, GridViewCommandEventArgs e)
{
string[] args = e.CommandArgument.ToString().Split(':');
string orderId = args[0];
string storeId = args[1];
string isCheckOut = args[2];
double totalMoney = Convert.ToDouble(args[3]);
string payWay = args[4];
if (e.CommandName == "OK")
{
//判断选中正确否(判断金额)
int count = 0;
int paycount = 0;
IList <StoreOrderModel> orders = new List <StoreOrderModel>();
string[] storeMoney = CheckOutOrdersBLL.GetStoreTotalOrderGoodsMoney(storeId);
double ordermoney = double.Parse(storeMoney[0]); //订货款
double turnmonty = double.Parse(storeMoney[1]); //周转款
StoreOrderModel order = new StoreOrderModel();
order.StoreorderId = orderId;
if (payWay == "0")
{
order.OrderType = 0;
if (totalMoney > ordermoney)
{
msg = "<script>alert('" + GetTran("000957", "订货款不足！") + "');</script>";
return;
}
}
else if (payWay == "1")
{
order.OrderType = 1;
if (totalMoney > turnmonty)
{
msg = "<script>alert('" + GetTran("000965", "周转款不足！") + "');</script>";
return;
}
}
order.TotalMoney = Convert.ToDecimal(totalMoney);
orders.Add(order);
//if (!CheckOutOrdersBLL.CheckLogicProductInventory(orders))
//{
// msg = "<script>alert('" + GetTran("000974", "公司库存不足，请通知公司及时进货！") + "')</script>";
// return;
//}
if (AddOrderDataDAL.OrderPayment(storeId, orderId, CommonDataBLL.OperateIP, 2, 1, 10, "管理员", "", 2, -1, 1, 1, "", 0, "") == 0)
{
msg = "<script>alert('" + GetTran("000978", "支付成功！") + "')</script>";
Bind();
}
else
{
msg = "<script>alert('" + GetTran("000979", "支付失败请重新支付！") + "')</script>";
}
//if (payWay == "3")//支付宝支付
//{
// msg = "<script>window.open('../Store/payment/default.aspx?zongMoney=" + totalMoney + "&TotalMoney=" + totalMoney + "&TotalComm=0 &OrderID =" + orderId + "&OnlineOrder=1');</script>";
// return;
//}
//else
//{
//}
}
else if (e.CommandName == "D")
{
//验证订单
if (OrdersBrowseBLL.GetOrderIsExist(orderId))
{
msg = "<script>alert('" + GetTran("005993", "对不起，订单已被删除！") + "');</script>";
Bind();
return;
}
else if (OrdersBrowseBLL.GetOrderCheckState(orderId))
{
msg = "<script>alert('" + GetTran("005994", "对不起，该订单已支付，不能删除！") + "');</script>";
Bind();
return;
}
if (OrdersBrowseBLL.DelStoreOrderItem(orderId))
{
msg = "<script>alert('" + GetTran("000749", "删除成功！") + "');</script>";
}
else
{
msg = "<script>alert('" + GetTran("000417", "删除失败！") + "');</script>";
}
Bind();
}
}
