protected void Page_Load(object sender, EventArgs e)
{
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
var hkid = Request.QueryString["hkid"];
var hybh = Session["Member"].ToString();
if (!IsPostBack)
{
//获取标准币种
//string dt_one = "select w.id,w.hkid, w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,w.auditingtime from memberinfo m, withdraw w,remittances r where m.Number=w.number and w.hkid=r.ID and (w.shenhestate=11 or w.shenhestate=2) order by auditingtime desc";
//DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
//Hkid.Value = hkid;
//rep_km.DataSource = dt;
//rep_km.DataBind();
string dt_one = "select * from (select w.id,w.hkid,w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,RemittancesDate,w.auditingtime,m.Number from memberinfo m, withdraw w,remittances r where m.Number = w.number and w.hkid = r.ID and (w.shenhestate=11 or w.shenhestate=2) and m.Number!='" + hybh + "' and r.RemitNumber='" + hybh + "' union select id,ID as hkid,ImportNumber as bankcard,ImportBank as bankname,shenhestate,RemitMoney as WithdrawMoney,name,RemittancesDate,ReceivablesDate as auditingtime,RemitNumber as Number from Remittances where isjl = 1 and (shenhestate=11 or shenhestate=2) and RemitNumber='" + hybh + "' ) as t order by auditingtime desc";
//
DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
Hkid.Value = hkid;
var count = dt.Rows.Count;
rep_km.DataSource = dt;
rep_km.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Permissions.ComRedirect(Page, Permissions.redirUrl);
Response.Cache.SetExpires(DateTime.Now);
Permissions.CheckManagePermission(EnumCompanyPermission.BalanceDetialQuery);
Response.Cache.SetExpires(DateTime.Now);
if (!IsPostBack)
{
this.Panel1.Style.Add("display", "none");
//绑定货币
if (Session["Default_Currency"] == null)
{
Session["Default_Currency"] = "";
}
CommonDataBLL.BindCurrency_IDListBZ(this.DropCurrency, Session["Default_Currency"].ToString());
double dpCurrency = AjaxClass.GetCurrency(Convert.ToInt32(DropCurrency.SelectedValue), Convert.ToInt32(DropCurrency.SelectedValue));
Session["rate"] = dpCurrency;
getTypeBind(Session["Company"].ToString());
coll();
}
Translations();
}
//绑定信息
public void readInfo()
{
MemberInfoModel memberInfoModel = MemberInfoModifyBll.getMemberInfo(Session["Member"].ToString());
DataTable dt = DetialQueryBLL.GetMemberInfoBalanceByNumber(ExpectNum, Session["Member"].ToString());
if (dt.Rows.Count > 0)
{
lblNewPeople.Text = dt.Rows[0]["CurrentNewNetNum"].ToString();
if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
{
lblNewYeji.Text = "0.00";
lblTotalYeji.Text = "0.00";
lblCurrentOneMark2.Text = "0.00";
lblTotalOneMark2.Text = "0.00";
}
else
{
lblNewYeji.Text = (double.Parse(dt.Rows[0]["CurrentTotalNetRecord"].ToString())).ToString("0.00");
lblTotalYeji.Text = (double.Parse(dt.Rows[0]["TotalNetRecord"].ToString())).ToString("0.00");
lblCurrentOneMark2.Text = (double.Parse(dt.Rows[0]["CurrentOneMark2"].ToString())).ToString("0.00");
lblTotalOneMark2.Text = (double.Parse(dt.Rows[0]["TotalOneMark2"].ToString())).ToString("0.00");
}
lblTotalPeople.Text = dt.Rows[0]["TotalNetNum"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Permissions.MemRedirect(Page, Permissions.redirUrl);
//检查店铺权限
Response.Cache.SetExpires(DateTime.Now);
// Permissions.CheckMemberPermission();//检测是否已登录
int bzCurrency = CommonDataBLL.GetStandard();
if (!IsPostBack)
{
if (Request.QueryString["byy"] != null)
{
double currency = AjaxClass.GetCurrency(int.Parse(Session["Default_Currency"] == null ? bzCurrency.ToString() : Session["Default_Currency"].ToString()));
ViewState["url"] = Request.UrlReferrer.ToString();
string orderid = Request.QueryString["orderId"];
if (orderid.Length > 0)
{
BindData(orderid);
}
BLL.Registration_declarations.MemberOrderBLL memberOrderBLL = new BLL.Registration_declarations.MemberOrderBLL();
DataTable dt = memberOrderBLL.GetMemberByOrderID1(orderid, currency);
gvorder.DataSource = dt;
gvorder.DataBind();
}
}
Transllations();
}
public string GetLiuLanPro(string oType)
{
oType = Session["LUOrder"].ToString().Split(',')[1];
int mType1 = 0;
if (HttpContext.Current.Session["Company"] != null)
{
mType1 = 1;
}
else if (HttpContext.Current.Session["Store"] != null)
{
mType1 = 2;
}
else if (HttpContext.Current.Session["Member"] != null)
{
mType1 = 3;
}
string number = "";
if (Session["mbreginfo"] == null)
{
number = ((Model.MemberInfoModel)Session["fxMemberModel"]).Number;
}
else
{
number = ((Model.MemberInfoModel)Session["mbreginfo"]).Number;
}
string sql = "select top 7 * from MemShopCart,product where MemShopCart.proid=product.productid and memBh=@memBh and mType=@mType and odType=@odType order by id desc";
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@memBh", number),
new SqlParameter("@mType", SqlDbType.Int),
new SqlParameter("@odType", SqlDbType.Int)
};
sp[1].Value = mType1;
sp[2].Value = Convert.ToInt32(oType);
DataTable dt = DAL.DBHelper.ExecuteDataTable(sql, sp, CommandType.Text);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
if (dt.Rows.Count == 0)
{
sb.Append("");
}
int bzCurrency = CommonDataBLL.GetStandard();
double currency = AjaxClass.GetCurrency(int.Parse(Session["Default_Currency"] == null ? bzCurrency.ToString() : Session["Default_Currency"].ToString()));
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append(@" <div class='prcClassImg'><h6 class='pImages' style='margin-right: 30px;'><img src='" + FormatURL(dt.Rows[i]["ProductID"]) + "' width='64' height='54' /></h6> <ul> <li><a href='#'>" + dt.Rows[i]["productname"].ToString() + "</a></li>"
+ "<li><a href='#'>价格：" + (Convert.ToDouble(dt.Rows[i]["PreferentialPrice"]) * currency).ToString() + "</a></li> <li><a href='#'>PV：" + Convert.ToDouble(dt.Rows[i]["PreferentialPV"]).ToString() + "</a></li> </ul> <div style='clear:both'></div> </div>");
// sb.Append(@"<dl>
// <dd><img src='" + FormatURL(dt.Rows[i]["ProductID"]) + "' width='55' height='55' /></dd><dt>" + dt.Rows[i]["productname"].ToString() + "<br />金额：￥" + Convert.ToDouble(dt.Rows[i]["PreferentialPrice"]).ToString("0.00") + "<br />PV:" + Convert.ToDouble(dt.Rows[i]["PreferentialPV"]).ToString("0.00") + "</dt></dl>");
}
return(sb.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
string dt_one = "";
var hkid = Request.QueryString["hkid"];
var hybh = Session["Member"].ToString();
var time = DateTime.Now.AddHours(-10);
Hkid.Value = hkid;
if (hybh == "8888888888")
{
dt_one = "select * from (select w.id,w.hkid,w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,RemittancesDate,w.auditingtime,m.Number from memberinfo m, withdraw w,remittances r where m.Number = w.number and w.hkid = r.ID and w.shenhestate in(1, 3)and m.Number!='" + hybh + "' and w.auditingtime>='" + time + "' union select id,ID as hkid,ImportNumber as bankcard,ImportBank as bankname,shenhestate,RemitMoney as WithdrawMoney,name,RemittancesDate,ReceivablesDate as auditingtime,RemitNumber as Number from Remittances where isjl = 1 and shenhestate in(1, 3) and ReceivablesDate>='" + time + "' ) as t order by auditingtime desc";
}//
else
{
dt_one = "select * from (select w.id,w.hkid,w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,RemittancesDate,w.auditingtime,m.Number from memberinfo m, withdraw w,remittances r where m.Number = w.number and w.hkid = r.ID and w.shenhestate in(1, 3) and m.Number!='" + hybh + "' and w.auditingtime>='" + time + "' and r.RemitNumber='" + hybh + "' union select id,ID as hkid,ImportNumber as bankcard,ImportBank as bankname,shenhestate,RemitMoney as WithdrawMoney,name,RemittancesDate,ReceivablesDate as auditingtime,RemitNumber as Number from Remittances where isjl = 1 and shenhestate in(1, 3) and ReceivablesDate>='" + time + "' ) as t order by auditingtime desc";
}
//3-16去掉时间限制，超时的也显示
//
DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
var count = dt.Rows.Count;
rep_km.DataSource = dt;
rep_km.DataBind();
//string sql1 = "select * from Withdraw where hkid='" + hkid + "'";
//DataTable dt1 = DAL.DBHelper.ExecuteDataTable(sql1);
//if (dt1.Rows.Count == 0)
//{
// rep_km1.Visible = true;
// rep_km.Visible = false;
// dt_one = " select top(1)* from companybank order by ID desc";
// DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
// rep_km1.DataSource = dt;
// rep_km1.DataBind();
//}
//else
//{
// rep_km.Visible = true;
// rep_km1.Visible = false;
// dt_one = "select w.id,w.hkid,w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,RemittancesDate,w.auditingtime from memberinfo m, withdraw w,remittances r where m.Number=w.number and w.hkid=r.ID and w.shenhestate=3 and w.auditingtime>='" + time + "' order by w.auditingtime desc";
// DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
// rep_km.DataSource = dt;
// rep_km.DataBind();
//}
//this.ucPagerMb1.PageInit(dt_one, "rep_km");
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
if (!this.IsPostBack)
{
var HkID = Request.QueryString["HkID"];
var bishu = Request.QueryString["bishu"];
var RemitMoney = (Convert.ToDouble(Request.QueryString["RemitMoney"]) * huilv).ToString("f2");
int bishu1 = int.Parse(bishu);
rmoney.Text = RemitMoney;
rmoney1.Value = RemitMoney;
hkid.Value = HkID;
DataTable dt = null;// RemittancesBLL.jinliucx(HkID);
bishucount.Text = (dt.Rows.Count).ToString();
string sm = "select describe from JLparameter where jlcid=8";
DataTable sm2 = DAL.DBHelper.ExecuteDataTable(sm);
var shuomin = sm2.Rows[0]["describe"].ToString();
Label2.Text = shuomin;
if (bishucount.Text == "0")
{
bishucount.Text = "1";
string dt_one1 = "update Remittances set Ispipei=1 where ID=" + HkID;
DataTable dt3 = DAL.DBHelper.ExecuteDataTable(dt_one1);
DataTable dt_one3 = DAL.DBHelper.ExecuteDataTable("select * from remittances where ID=" + HkID);
string RemittancesID = dt_one3.Rows[0]["RemittancesID"].ToString(); //汇款单号
string RemBankBook = dt_one3.Rows[0]["ImportNumber"].ToString(); //汇款单号
string RemBankname = dt_one3.Rows[0]["name"].ToString(); //汇款单号
string RemBankaddress = dt_one3.Rows[0]["ImportBank"].ToString(); //汇款单号
RemittancesDAL.WithdrawMoney(Session["Member"].ToString(), Convert.ToDouble(RemitMoney) / huilv, RemittancesID, RemBankBook, RemBankname, RemBankaddress);
string dt_one = "select top(1) * from companybank order by ID desc";
DataTable dt2 = DAL.DBHelper.ExecuteDataTable(dt_one);
rep_km.Visible = false;
rep_km1.Visible = true;
rep_km1.DataSource = dt2;
rep_km1.DataBind();
}
else
{
rep_km1.Visible = false;
rep_km.Visible = true;
rep_km.DataSource = dt;
rep_km.DataBind();
}
Translations();
}
}
/*-------------------------------------------------------------------------------------------------------------------------------------------------------*/
public void readBonus()
{
int maxqs = BLL.CommonClass.CommonDataBLL.GetMaxqishu();
double curreny = AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()));
DataTable dt = MemberInfoModifyBll.getBonusTable(maxqs, Session["Member"].ToString());//第一个参数期数
if (dt.Rows.Count > 0)
{
if (curreny == 0)
{
//this.Label1.Text = "0";
this.Label1.Text = "0";
this.Label2.Text = "0";
this.Label3.Text = "0";
this.Label4.Text = "0";
this.Label5.Text = "0";
this.Label6.Text = "0";
this.Label7.Text = "0";
this.Label8.Text = "0";
this.Label9.Text = "0";
this.Label10.Text = "0";
}
else
{
//this.Label1.Text = (Convert.ToDouble(dt.Rows[0]["Bonus0"]) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
this.Label1.Text = (Convert.ToDouble(dt.Rows[0]["Bonus1"]) *
AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
this.Label2.Text = (Convert.ToDouble(dt.Rows[0]["Bonus2"]) * curreny).ToString("0.00");
this.Label3.Text = (Convert.ToDouble(dt.Rows[0]["Bonus3"]) * curreny).ToString("0.00");
this.Label4.Text = (Convert.ToDouble(dt.Rows[0]["Bonus4"]) * curreny).ToString("0.00");
this.Label5.Text = (Convert.ToDouble(dt.Rows[0]["Bonus5"]) * curreny).ToString("0.00");
this.Label6.Text = (Convert.ToDouble(dt.Rows[0]["Kougl"]) * curreny).ToString("0.00");
this.Label7.Text = (Convert.ToDouble(dt.Rows[0]["Koufl"]) * curreny).ToString("0.00");
this.Label8.Text = (Convert.ToDouble(dt.Rows[0]["Koufx"]) * curreny).ToString("0.00");
this.Label9.Text = (Convert.ToDouble(dt.Rows[0]["CurrentSolidSend"]) * curreny).ToString("0.00");
this.Label10.Text = (Convert.ToDouble(dt.Rows[0]["CurrentSolidSend"]) * curreny).ToString("0.00");
}
}
else
{
//this.Label1.Text = "0.00";
this.Label1.Text = "0.00";
this.Label2.Text = "0.00";
this.Label3.Text = "0.00";
this.Label4.Text = "0.00";
this.Label5.Text = "0.00";
this.Label6.Text = "0.00";
this.Label7.Text = "0.00";
this.Label8.Text = "0.00";
this.Label9.Text = "0.00";
this.Label10.Text = "0.00";
}
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
var id = Request.QueryString["id"];
string dt_one = "select * from Withdraw where shenhestate=11 and HkDj=1 and IsJL=1 and HkKhname is not null and id=" + id;
DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
rep_km.DataSource = dt;
rep_km.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
var hybh = Session["Member"].ToString();
string dt_one = "select id,hkid,Khname,bankcard,bankname,shenHestate,Ppje,WithdrawTime from withdraw where shenhestate=20 and IsJL=1 and number='" + hybh + "' order by WithdrawTime desc";//and HkDj=1 and TxDj=1
DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
rep_km.DataSource = dt;
rep_km.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
if (!this.IsPostBack)
{
var hkmoney = (Convert.ToDouble(Request.QueryString["hkmoney"]) * huilv).ToString();
//HkTime.Text = (DateTime.Now).ToString();
Money.Text = Math.Round(double.Parse(hkmoney)).ToString("#0.00");
}
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
var id = Request.QueryString["id"];
string dt_one = "select * from Withdraw where id=" + id;
DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
Image1.ImageUrl = "../hkpzimg/" + dt.Rows[0]["hkpzImglj"].ToString();
//rep_km.DataSource = dt;
//rep_km.DataBind();
}
protected string GetWithdrawMoney(string WithdrawMoney)
{
string money = "";
if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
{
money = "0.00";
}
else
{
money = (double.Parse(WithdrawMoney) * AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("f2");
}
return(money);
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
var hybh = Session["Member"].ToString();
var hkid = Request.QueryString["hkid"];
string dt_one = "select id,hkid,Ppje,Khname,bankcard,bankname,shenHestate,WithdrawMoney,HkDj,hkpzImglj from withdraw where shenhestate in(2,11) and IsJL=1 and Khname is not null and number='" + hybh + "' order by WithdrawTime desc";
if (!IsPostBack)
{
DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
rep_km.DataSource = dt;
rep_km.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Permissions.MemRedirect(Page, Permissions.redirUrl);
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
if (!IsPostBack)
{
if (Session["Default_Currency"] == null)
{
Session["Default_Currency"] = bzCurrency;
}
setStoreInfo();
search_rsj();
Translations();
}
}
/// <summary>
/// GridView行处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gv_browOrder_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "bg=this.style.backgroundColor;this.style.backgroundColor='#FFFFCC'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=bg");
Label lblTotalMoney = e.Row.FindControl("lblTotalMoney") as Label;
if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
{
lblTotalMoney.Text = "0.00";
}
else
{
lblTotalMoney.Text = (Convert.ToDouble(lblTotalMoney.Text) * AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("f2");
}
}
else if (e.Row.RowType == DataControlRowType.Header)
{
}
}
protected void gvorder_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#FFFFCC'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor");
DataRowView drv = (DataRowView)e.Row.DataItem;
string defrayType = drv["defraytype"].ToString();
string defrayState = drv["zhifu"].ToString();
string OrderID = drv["OrderID"].ToString();
string expectNum = drv["OrderExpectNum"].ToString();
double totalmoney = Convert.ToDouble(drv["totalmoney"]);
double totalcomm = 0;
double zongMoney = totalcomm + totalmoney;
ImageButton LinkPM = (ImageButton)e.Row.FindControl("HyperLinkPayMent");
ImageButton linkbtnModify = (ImageButton)e.Row.FindControl("linkbtnModify");
ImageButton linkbtnDelete = (ImageButton)e.Row.FindControl("linkbtnDelete");
Label lblTotalMoney = e.Row.FindControl("lblTotalMoney") as Label;
if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
{
lblTotalMoney.Text = "0.00";
}
else
{
lblTotalMoney.Text = (Convert.ToDouble(lblTotalMoney.Text) * AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("f2");
}
}
else if (e.Row.RowType == DataControlRowType.Header)
{
Transllations();
}
}
protected void givStoreInfo_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int curr = Convert.ToInt32(DBHelper.ExecuteScalar("select rate from Currency where id=standardMoney"));
e.Row.Attributes.Add("onmouseover", "bg=this.style.backgroundColor;this.style.backgroundColor='#FFFFCC'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=bg");
Label lab = (Label)e.Row.FindControl("StoreLevelInt");
string l = DBHelper.ExecuteScalar("select levelstr from bsco_level where levelflag=1 and levelint = " + Convert.ToInt32(lab.Text.ToString()) + "").ToString();
lab.Text = l.ToString();
e.Row.Cells[3].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[3].Text.ToString());
e.Row.Cells[4].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[4].Text.ToString());
e.Row.Cells[8].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[8].Text.ToString());
if (AjaxClass.GetCurrency(curr, Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[5].Text = "0";
}
else
{
e.Row.Cells[5].Text = (Convert.ToDouble(e.Row.Cells[5].Text) * AjaxClass.GetCurrency(curr, Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
}
Translations();
}
/// <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 void LoadData1()
{
double currency = AjaxClass.GetCurrency(int.Parse(Session["Default_Currency"] == null ? bzCurrency.ToString() : Session["Default_Currency"].ToString()));
string billid = ViewState["billid"].ToString();
int dotype = Convert.ToInt32(ViewState["dotype"]);
int roletype = Convert.ToInt32(ViewState["roletype"]);
this.lblorderid.Text = billid;
MemberOrderModel memberorder = null;
DataTable ordergoodstable = null;
DataTable dtcb = null; //查询会员汇入银行
string paymentnumber = ""; //被支付订单（汇款单）所属会员编号
double totalmoney = 0; // 被支付订单（汇款单）总金额
if (dotype == 1) //订单支付
{
lbltype.Text = GetTran("000907", "订单支付");
lblot.Text = GetTran("000079", "订单号");
}
else if (dotype == 2)//充值
{
div_1.Style.Add("display", "none");
div_2.Style.Add("display", "none");
div_5.Style.Add("display", "none");
div_6.Style.Add("display", "none");
lbltype.Text = GetTran("007451", "订单支付");
lblot.Text = GetTran("005854", "汇款单号");
ViewState["remid"] = billid;
RemittancesModel remittance = RemittancesDAL.GetRemitByHuidan(billid);
paymentnumber = remittance.RemitNumber.ToString(); //被支付订单（汇款单）所属会员编号
totalmoney = Convert.ToDouble(remittance.RemitMoney) * currency; // 被支付订单（汇款单）总金额
}
if (roletype == 1) //会员
{
//隐藏店铺操作
div_6.Style.Add("display", "none");
div_5.Style.Add("display", "none");
if (Session["Member"] != null)
{
loginnumber = Session["Member"].ToString();
}
else if (Session["Store"] != null)
{
loginnumber = Session["Store"].ToString();
//店铺支付会员订单
div_1.Style.Add("display", "none");
div_2.Style.Add("display", "none");
div_3.Style.Add("display", "none");
div_4.Style.Add("display", "none");
div_6.Style.Add("display", "none");
div_5.Style.Add("display", "");
}
if (dotype == 1) //订单支付
{
if (MemberOrderDAL.Getvalidteiscanpay(billid, loginnumber)) //限制订单必须有订货所属店铺中心支付)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007452", "该订单不属于您的协助或推荐报单，不能完成支付") + "'); window.location.href='../Logout.aspx'; </script>");
return;
}
memberorder = MemberOrderDAL.GetMemberOrder(billid);
if (loginnumber == "")
{
loginnumber = memberorder.Number;
}
else
{
ViewState["odnumber"] = memberorder.Number;
}
if (memberorder.Number == loginnumber)//如果是自己支付自己的订单则不需要确认收到款
{
div_sure.Visible = false; rdombsuregetmoney.Visible = false;
}
if (memberorder == null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("1").ToLower() + "';</script>");
return;
}
if (memberorder.DefrayState == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("2").ToLower() + "';</script>");
return;
}
paymentnumber = memberorder.Number.ToString(); //被支付订单（汇款单）所属会员编号
totalmoney = Convert.ToDouble(memberorder.TotalMoney); // 被支付订单（汇款单）总金额
}
dtcb = CompanyBankDAL.getdtcompanybankbynumber(loginnumber, 1);
}
else if (roletype == 2) //店铺
{
//隐藏店铺操作
div_2.Style.Add("display", "none");
div_1.Style.Add("display", "none");
div_5.Style.Add("display", "none");
loginnumber = Session["Store"].ToString();
dtcb = CompanyBankDAL.getdtcompanybankbynumber(loginnumber, 2);
if (dotype == 1) //订单操作
{
ordergoodstable = OrderDetailDAL.Getordergoodstablebyorderid(billid);
if (ordergoodstable != null && ordergoodstable.Rows.Count > 0)
{
if (ordergoodstable.Rows[0]["IsCheckOut"].ToString() == "Y")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("2").ToLower() + "';</script>");
return;
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("1").ToLower() + "';</script>");
return;
}
//paymentnumber = ordergoodstable.Rows[0]["storeid"].ToString();//被支付订单（汇款单）所属会员编号
totalmoney = Convert.ToDouble(ordergoodstable.Rows[0]["totalmoney"]);// 被支付订单（汇款单）总金额
}
}
lblstoreid1.Text = loginnumber;
lblstoreID2.Text = loginnumber;
lblordernumber.Text = loginnumber;
lbltotalmoney.Text = totalmoney.ToString("0.00");
lblordertmoney.Text = totalmoney.ToString("0.00");
ViewState["tm"] = totalmoney;
string cardstr = "";
int i = 1;
if (dtcb != null && dtcb.Rows.Count > 0)
{
foreach (DataRow item in dtcb.Rows)
{
cardstr += " <div id='bank" + i.ToString() + "' > " + GetTran("001243", "开户行") + "： " + item["Bank"].ToString() + "<br/> " + GetTran("007506", "账") + " " + GetTran("007453", "号") + "： " + getsplit(item["BankBook"].ToString()) + "<br/> " + GetTran("000086", "开户名") + "： " + item["Bankname"].ToString() + "</div>"; i++;
}
this.cardlist.InnerHtml = cardstr;//绑定银行信息
}
}
/// <summary>
/// 获取标示码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Loadmk()
{
string billid = ViewState["billid"].ToString();
int dotype = Convert.ToInt32(ViewState["dotype"]);
int roletype = Convert.ToInt32(ViewState["roletype"]);
double currency = AjaxClass.GetCurrency(int.Parse(Session["Default_Currency"] == null ? bzCurrency.ToString() : Session["Default_Currency"].ToString()));
string ip = Request.UserHostAddress.ToString();
string remark = "";
MemberOrderModel memberorder = null;
DataTable ordergoodstable = null;
DataTable ordergoodstable1 = null;
double ordertmoney = 0;
if (roletype == 1) //会员订单
{
if (dotype == 1)
{
memberorder = MemberOrderDAL.GetMemberOrder(billid);
ordertmoney = Convert.ToDouble(memberorder.TotalMoney);
}
}
else
if (roletype == 2) //店铺
{
if (dotype == 1)
{
ordergoodstable = OrderDetailDAL.Getordergoodstablebyorderid1(billid);
ordergoodstable1 = OrderDetailDAL.Getordergoodstablebyorderid2(billid);
if (ordergoodstable != null && ordergoodstable.Rows.Count > 0)
{
ordertmoney = Convert.ToDouble(ordergoodstable.Rows[0]["totalmoney"]);
}
else
{
if (ordergoodstable1 != null && ordergoodstable1.Rows.Count > 0)
{
ordertmoney = Convert.ToDouble(ordergoodstable1.Rows[0]["totalmoney"]);
}
}
}
}
string biaoshi = "";
if (dotype == 1) //订单支付生成尾数
{
remark = loginnumber + "汇款支付订单" + billid;
int c = 1; //数据库中1代表会员 0代表店铺
if (roletype == 2)
{
c = 0;
}
string rmid = RemittancesDAL.GetAddnewRemattice(loginnumber, ordertmoney, ip, billid, remark, c);
ViewState["remid"] = rmid;
DataTable dt = DBHelper.ExecuteDataTable("select totalrmbmoney ,totalmoney from remtemp where remittancesid='" + rmid + "'");
if (dt != null && dt.Rows.Count > 0)
{
// biaoshi = Convert.ToDouble(dt.Rows[0]["totalrmbmoney"]).ToString("f2");
biaoshi = Convert.ToDouble(dt.Rows[0]["totalmoney"]).ToString("#0.00");
}
}
else
if (dotype == 2) //汇款充值生成尾数
{
RemittancesDAL.GetAddnewRetmp(loginnumber, billid, ip, remark, roletype);
DataTable dt = DBHelper.ExecuteDataTable("select totalrmbmoney ,totalmoney from remtemp where remittancesid='" + billid + "'"); //查找出标识
if (dt != null && dt.Rows.Count > 0)
{
//biaoshi = Convert.ToDouble(dt.Rows[0]["totalrmbmoney"]).ToString("f2");
biaoshi = Convert.ToDouble(dt.Rows[0]["totalmoney"]).ToString("#0.00");
}
}
if (biaoshi != "" && biaoshi.ToString().IndexOf('.') > 0)
{
DataTable dt = new DataTable();
if (dotype == 1)
{
remark = loginnumber + "汇款支付订单" + billid;
int c = 1; //数据库中1代表会员 0代表店铺
if (roletype == 2)
{
c = 0;
}
string rmid = RemittancesDAL.GetAddnewRemattice(loginnumber, ordertmoney, ip, billid, remark, c);
ViewState["remid"] = rmid;
dt = DBHelper.ExecuteDataTable("select totalrmbmoney ,totalmoney from remtemp where remittancesid='" + rmid + "'");
}
else if (dotype == 2)
{
RemittancesDAL.GetAddnewRetmp(loginnumber, billid, ip, remark, roletype);
dt = DBHelper.ExecuteDataTable("select totalrmbmoney ,totalmoney from remtemp where remittancesid='" + billid + "'"); //查找出标识
}
string bb = (double.Parse(biaoshi) * currency).ToString();
//lblpartmoney.Text = (bb).Substring(0, (bb).IndexOf('.'));
//string chart = bb.Substring(bb.IndexOf('.') + 1);
this.lblmoneyre.Text = (double.Parse(bb)).ToString();
this.lblrmb.Text = double.Parse(lbltotalmoney.Text).ToString("#0.00");
//lblchat.Text = (double.Parse(chart) ).ToString(); ;
//lbljiao.Text = chart.Substring(0, 1);
//lblfen.Text = chart.Substring(1);
}
}
/*-------------------------------------------------------------------------------------------------------------------------------------------------------*/
public void readBonus(int expectnum)
{
int maxqs = BLL.CommonClass.CommonDataBLL.GetMaxqishu();
// int maxExpectNum = DetialQueryBLL.IsSuanceJj(expectnum); //最大公布期数
double curreny = AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()));
if (expectnum == 0)
{
expectnum = 1;
}
DataTable dt = MemberInfoModifyBll.getBonusTable(expectnum, Session["Member"].ToString());//第一个参数期数
DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select IsSuance from config where ExpectNum=" + expectnum);
string IsSuance = dt_one.Rows[0]["IsSuance"].ToString();//是否显示
if (dt.Rows.Count > 0)
{
if (curreny == 0)
{
}
else
{
if (IsSuance == "0")
{
//this.Label1.Text = "0.00";
//this.Label2.Text = "0.00";
//this.Label3.Text = "0.00";
//this.Label4.Text = "0.00";
//this.Label5.Text = "0.00";
//this.Label6.Text = "0.00";
//this.Label7.Text = "0.00";
//this.Label8.Text = "0.00";
//this.Label9.Text = "0.00";
//this.Label10.Text = "0.00";
//lbllbonus6.Text = "0.00";
}
else
{
//this.Label1.Text = (Convert.ToDouble(dt.Rows[0]["Bonus0"]) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
//this.Label1.Text = (Convert.ToDouble(dt.Rows[0]["Bonus1"]) *
//AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
//this.Label2.Text = (Convert.ToDouble(dt.Rows[0]["Bonus2"]) * curreny).ToString("0.00");
//this.Label3.Text = (Convert.ToDouble(dt.Rows[0]["Bonus3"]) * curreny).ToString("0.00");
//this.Label4.Text = (Convert.ToDouble(dt.Rows[0]["Bonus4"]) * curreny).ToString("0.00");
//this.Label5.Text = (Convert.ToDouble(dt.Rows[0]["Bonus5"]) * curreny).ToString("0.00");
//lbllbonus6.Text = (Convert.ToDouble(dt.Rows[0]["Bonus6"]) * curreny).ToString("0.00");
//this.Label6.Text = (Convert.ToDouble(dt.Rows[0]["Kougl"]) * curreny).ToString("0.00");
//this.Label7.Text = (Convert.ToDouble(dt.Rows[0]["Koufl"]) * curreny).ToString("0.00");
//this.Label8.Text = (Convert.ToDouble(dt.Rows[0]["Koufx"]) * curreny).ToString("0.00");
//this.Label9.Text = (Convert.ToDouble(dt.Rows[0]["CurrentSolidSend"]) * curreny).ToString("0.00");
//this.Label10.Text = (Convert.ToDouble(dt.Rows[0]["CurrentTotalMoney"]) * curreny).ToString("0.00");
}
}
}
else
{
//this.Label1.Text = "0.00";
//this.Label1.Text = "0.00";
//this.Label2.Text = "0.00";
//this.Label3.Text = "0.00";
//this.Label4.Text = "0.00";
//this.Label5.Text = "0.00";
//this.Label6.Text = "0.00";
//this.Label7.Text = "0.00";
//this.Label8.Text = "0.00";
//this.Label9.Text = "0.00";
//this.Label10.Text = "0.00";
}
}
//绑定信息
public void readInfo()
{
MemberInfoModel memberInfoModel = MemberInfoModifyBll.getMemberInfo(Number);
#region 读取个人信息
if (memberInfoModel != null)
{
this.storeid.Text = memberInfoModel.StoreID;
}
#endregion
DataTable dt = DetialQueryBLL.GetMemberInfoBalanceByNumber(ExpectNum, Number);
if (dt.Rows.Count > 0)
{
CurrentTotalNetRecord.Text = (Convert.ToDouble(dt.Rows[0]["CurrentTotalNetRecord"]) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
CurrentOneMark.Text = (Convert.ToDouble(dt.Rows[0]["CurrentOneMark"]) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
level.Text = dt.Rows[0]["levelstr"].ToString();
if (dt.Rows[0]["TotalNetNum"] == null || dt.Rows[0]["TotalNetNum"].ToString() == "")
{
labTotalNetNum.Text = "0";;
}
else
{
labTotalNetNum.Text = (Convert.ToDouble(dt.Rows[0]["TotalNetNum"]) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
}
labDTotalNetNum.Text = (Convert.ToDouble(dt.Rows[0]["DTotalNetNum"]) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
//个人总资格业绩
if (dt.Rows[0]["TotalOneMark"] == null || dt.Rows[0]["TotalOneMark"].ToString() == "")
{
labCurrentOneMark1.Text = "0.00";
}
else
{
labCurrentOneMark1.Text = (Convert.ToDouble(dt.Rows[0]["TotalOneMark"].ToString()) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
}
labCurrentTotalNetRecord.Text = (Convert.ToDouble(dt.Rows[0]["CurrentTotalNetRecord"].ToString()) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
if (dt.Rows[0]["TotalNetRecord"] == null || dt.Rows[0]["TotalNetRecord"].ToString() == "")
{
labTotalNetRecord1.Text = "0.00";
}
else
{
labTotalNetRecord1.Text = (Convert.ToDouble(dt.Rows[0]["TotalNetRecord"].ToString()) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
}
labdCurrentTotalNetRecord2.Text = Convert.ToDouble(dt.Rows[0]["dCurrentTotalNetRecord"].ToString()).ToString("0.00");
labdTotalNetRecord2.Text = (Convert.ToDouble(dt.Rows[0]["dTotalNetRecord"].ToString()) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
CurrentNewNetNum.Text = (Convert.ToDouble(dt.Rows[0]["DCurrentNewNetNum"].ToString()) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
}
else
{
CurrentTotalNetRecord.Text = "0.00";
CurrentOneMark.Text = "0.00";
level.Text = " ";
CurrentNewNetNum.Text = "0";
}
}
protected void gvRefundmentBrowse_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "bg=this.style.backgroundColor;this.style.backgroundColor='#FFFFCC'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=bg");
Label lblTotalMoney = e.Row.FindControl("Label2") as Label;
if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
{
lblTotalMoney.Text = "0.00";
}
else
{
lblTotalMoney.Text = (Convert.ToDouble(lblTotalMoney.Text) * AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("f2");
}
Label lbl_StatusFlag_NR = (Label)e.Row.FindControl("lbl_StatusFlag_NR");
LinkButton lbtn_Audit = (LinkButton)e.Row.FindControl("lbtn_Audit");
LinkButton lbtn_lock = (LinkButton)e.Row.FindControl("lbtn_lock");
LinkButton lbtn_unlock = (LinkButton)e.Row.FindControl("lbtn_unlock");
LinkButton lbl_Del = (LinkButton)e.Row.FindControl("lbl_Del");
Label lbl_IsLock = (Label)e.Row.FindControl("lbl_IsLock");
int StatusFlag_NR = int.Parse(lbl_StatusFlag_NR.Text);
int IsLock = int.Parse(lbl_IsLock.Text);
if (LoginIDEntity == 0)
{
if (lbl_StatusFlag_NR != null)
{
switch (StatusFlag_NR)
{
case (int)RefundmentOrderStatusEnum.UnAudit:
if (IsLock == 0)
{
lbtn_Audit.Visible = true;
lbl_Del.Visible = true;
//lbtn_lock.Visible = true;
//lbtn_unlock.Visible = false;
}
else
{
lbtn_Audit.Visible = false;
lbl_Del.Visible = false;
//lbtn_unlock.Visible = true;
//lbtn_lock.Visible = false;
}
break;
case (int)RefundmentOrderStatusEnum.AuditedUnPay:
//lbtn_unlock.Visible = false;
//lbtn_lock.Visible = false;
lbtn_Audit.Visible = false;
lbl_Del.Visible = false;
break;
case (int)RefundmentOrderStatusEnum.Audited:
//lbtn_unlock.Visible = false;
//lbtn_lock.Visible = false;
lbtn_Audit.Visible = false;
lbl_Del.Visible = false;
break;
}
if (IsLock == 0)
{
if (StatusFlag_NR == (int)RefundmentOrderStatusEnum.UnAudit)
{
lbtn_lock.Visible = true;
}
else
{
lbtn_lock.Visible = false;
lbtn_unlock.Visible = false;
}
}
else
{
lbtn_Audit.Visible = false;
lbl_Del.Visible = false;
lbtn_unlock.Visible = true;
lbtn_lock.Visible = false;
}
}
}
else
{
lbtn_Audit.Visible = false;
lbtn_lock.Visible = false;
lbtn_unlock.Visible = false;
switch (StatusFlag_NR)
{
case (int)RefundmentOrderStatusEnum.UnAudit:
if (IsLock == 0)
{
lbl_Del.Visible = true;
}
else
{
lbl_Del.Visible = false;
}
break;
case (int)RefundmentOrderStatusEnum.AuditedUnPay:
lbl_Del.Visible = false;
break;
case (int)RefundmentOrderStatusEnum.Audited:
lbl_Del.Visible = false;
break;
}
}
// (e.Row.FindControl("ltAuditing") as Literal).Text = "<a href='#' onclick='ShowTbInfo(\"" + docId + "\",'',\"" + totalMoney + "\",\"" + totalPv + "\",\"" + date + "\")' >" + GetTran("000761", "审核") + "</a>";
}
else if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Attributes.Add("style", "background-image:url('../images/tabledp.gif')");
Translations();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
i = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
Permissions.ThreeRedirect(Page, "../member/" + Permissions.redirUrl);
luo.SetVlaue();
AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxMemShopCart));
AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxClass));
Translations();
if (!IsPostBack)
{
BindRadioType();
if (Session["mbreginfo"] != null)
{
mim = (MemberInfoModel)Session["mbreginfo"];
}
if (Session["UserType"] != null && Session["UserType"].ToString() != "3" && Session["EditOrderID"] == null)
{
top.Visible = false;
bottom.Visible = false;
STop1.Visible = false;
SLeft1.Visible = false;
txtMemBh.Visible = true;
lblMemBh.Style.Value = "display:none;";
}
else
{
if (Session["UserType"].ToString() == "2")
{
top.Visible = false;
bottom.Visible = false;
STop1.Visible = true;
SLeft1.Visible = true;
}
else
{
top.Visible = false;
bottom.Visible = false;
STop1.Visible = false;
SLeft1.Visible = false;
}
txtMemBh.Style.Value = "display:none;";
lblMemBh.Style.Value = "display:block;";
txtMemBh.Text = luo.MemBh;
lblMemBh.Text = luo.MemBh;
}
BindData();
//不是注册过来的新会员
if (Session["mbreginfo"] == null)
{
if ((Session["UserType"] != null && Session["UserType"].ToString() == "3") || Session["EditOrderID"] != null)
{
top.Visible = true;
bottom.Visible = true;
STop1.Visible = false;
SLeft1.Visible = false;
Txtyddh.Visible = false;
txtName.Visible = false;
//不是注册过来的，就进行名称和邮编的查询
DataTable dt = DAL.DBHelper.ExecuteDataTable("select name,postalcode,mobiletele,cpccode,address,storeid from memberinfo where number='" + luo.MemBh + "'");
if (dt != null && dt.Rows.Count > 0)
{
this.txtName.Text = Encryption.Encryption.GetDecipherName(dt.Rows[0]["Name"].ToString());
this.labName.Text = Encryption.Encryption.GetDecipherName(dt.Rows[0]["Name"].ToString());
if (dt.Rows[0]["postalcode"].ToString() != "")
{
this.txtPostCode.Text = dt.Rows[0]["postalcode"].ToString();
this.labPostCode.Text = dt.Rows[0]["postalcode"].ToString();
}
else
{
this.txtPostCode.Text = "111111";
this.labPostCode.Text = "111111";
}
this.Txtyddh.Text = dt.Rows[0]["mobiletele"].ToString();
this.labyddh.Text = dt.Rows[0]["mobiletele"].ToString();
}
GetBindAddress();
}
else
{
if (Session["UserType"].ToString() == "2")
{
top.Visible = false;
bottom.Visible = false;
STop1.Visible = true;
SLeft1.Visible = true;
}
else
{
top.Visible = true;
bottom.Visible = true;
STop1.Visible = false;
SLeft1.Visible = false;
}
this.rbtAddress.Items.Add(GetTran("000200", "新地址"));
this.rbtAddress.SelectedIndex = 0;
txtName.Enabled = false;
Txtyddh.Enabled = false;
}
}
else
{
if (Session["UserType"] != null && Session["UserType"].ToString() != "3" && Session["EditOrderID"] == null)
{
top.Visible = false;
bottom.Visible = false;
STop1.Visible = false;
SLeft1.Visible = false;
txtMemBh.Visible = true;
lblMemBh.Style.Value = "display:none;";
}
else
{
if (Session["UserType"].ToString() == "2")
{
top.Visible = false;
bottom.Visible = false;
STop1.Visible = true;
SLeft1.Visible = true;
}
else
{
top.Visible = false;
bottom.Visible = false;
STop1.Visible = false;
SLeft1.Visible = false;
}
}
//邮编和姓名默认赋值进去
MemberInfoModel mi = (MemberInfoModel)Session["mbreginfo"];
mim = mi;
txtMemBh.Style.Value = "display:none;";
lblMemBh.Style.Value = "display:block;";
txtMemBh.Text = mi.Number;
lblMemBh.Text = mi.Number;
this.txtName.Text = Encryption.Encryption.GetDecipherName(mi.Name);
this.labName.Text = Encryption.Encryption.GetDecipherName(mi.Name);
this.txtPostCode.Text = mi.PostalCode;
this.labPostCode.Text = mi.PostalCode;
if (mi.PostalCode.Length == 0)
{
this.labPostCode.Text = "111111";
this.txtPostCode.Text = "111111";
}
this.Txtyddh.Text = mi.MobileTele;
this.labyddh.Text = mi.MobileTele;
txtConName.Text = Encryption.Encryption.GetDecipherName(mi.Name);
txtOtherPhone.Text = mi.MobileTele;
this.txtName.Attributes.Add("style", "display:none;");
this.txtPostCode.Attributes.Add("style", "display:none;");
this.Txtyddh.Attributes.Add("style", "display:none;");
if (mi.CPCCode.Trim().Length > 0)
{
CountryCity2.SetCityCode(mi.CPCCode);//将注册的地址设置为默认的
}
Txtdz.Text = mi.Address;
GetBindAddress();
}
p_content2.Style.Add("display", "none");
}
}
public void getTotalMoney(string number)
{
Label1.Text = "<b>" + GetTran("007591", "已支付付款金额") + "</b>" + "：<span style=\"color:red\">" +
(Convert.ToDouble(RemittancesBLL.GetTotalMoney("RemitMoney", " Remittances a left join Withdraw c on a.ID=c.hkid ", " where isgsqr=1 and isnull(c.shenhestate,-1)<>-1 and RemitStatus=1 and relationorderid='' and RemitNumber='" + number + "'")) * (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())))
).ToString("f2")
+ "</span>";
Label2.Text = "<b>" + GetTran("007592", "未支付付款金额") + "</b>" + "：<span style=\"color:red\">" +
(Convert.ToDouble(RemittancesBLL.GetTotalMoney("RemitMoney", " Remittances a left join Withdraw c on a.ID=c.hkid ", " where isgsqr=0 and isnull(c.shenhestate,-1)<>-1 and RemitStatus=1 and relationorderid='' and RemitNumber='" + number + "'")) / (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())))
).ToString("f2")
+ "</span>";
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Store"] != null)
{
Literal1.Text = "<a href='../Store/First.aspx'>我的首页</a><a href='../Store/auditingmemberorders.aspx'>注册确认</a><a href='../Store/auditingmemberagain.aspx'>复消确认</a><a href='../Store/CheckOutOrders.aspx'>订单支付</a><a href='../Store/ViewAccountCircs.aspx'>充值浏览</a><a href='../Logout.aspx'>退出系统</a>";
}
if (Session["Member"] != null)
{
Literal1.Text = "<a href='../Member/First.aspx'>我的首页</a><a href='../Member/AuditingMemberOrder.aspx'>报单支付</a><a href='../Member/ResultBrowse.aspx'>充值浏览</a><a href='../Logout.aspx'>退出系统</a>";
}
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
if (!IsPostBack)
{
double currency = AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()));
if (Request.QueryString["ef"] != null)
{
string ef = EncryKey.Decrypt(Request.QueryString["ef"].ToUpper()).ToString();
string typ = "";
double money = 0;
string bill = "";
string[] sf = ef.Split(',');
if (sf.Length >= 3)
{
typ = sf[0].ToString();
bill = sf[1].ToString();
money = Convert.ToDouble(sf[2]);
}
else
{
typ = ef;
}
string showinfo = "";
switch (typ)
{
case "0":
//showinfo = GetTran("007512", "成功支付订单") + bill + " ，" + GetTran("000789", "支付金额") + "：" + double.Parse(money.ToString("0.00")) / currency + GetTran("000564", "元");
showinfo = GetTran("007512", "成功支付订单") + bill + " ，" + GetTran("000789", "支付金额") + "：" + double.Parse(money.ToString("0.00")) + GetTran("000564", "元");
break;
case "1":
showinfo = GetTran("007513", "支付失败,订单已支付或订单号不存在");
break;
case "2":
showinfo = GetTran("007514", "支付失败,账户可用余额不足");
break;
case "3":
showinfo = GetTran("007515", "支付失败,账户类型不存在");
break;
case "4":
showinfo = GetTran("007370", "未到账");
break;
case "5":
showinfo = GetTran("007516", "支付失败,服务机构周转款不足");
break;
case "6":
showinfo = GetTran("007517", "支付失败,服务机构订货款不足");
break;
case "100":
//showinfo = GetTran("007518", "请您务必在 24 小时内完成向指定账户汇款") + double.Parse(money.ToString("0.00")) / currency + GetTran("000564", "元") + "，" + GetTran("007519", "否则将视为您自动放弃汇款");
showinfo = GetTran("007518", "请您务必在 24 小时内完成向指定账户汇款") + double.Parse(money.ToString("0.00")) + GetTran("000564", "元") + "，" + GetTran("007519", "否则将视为您自动放弃汇款");
break;
case "101":
//showinfo = GetTran("007520", "请将") + bill + GetTran("007521", "订单款额") + double.Parse(money.ToString("0.00")) / currency + GetTran("000564", "元") + GetTran("007522", "交给您的购货店铺，并要求其为您支付订单");
showinfo = GetTran("007520", "请将") + bill + GetTran("007521", "订单款额") + double.Parse(money.ToString("0.00")) + GetTran("000564", "元") + GetTran("007522", "交给您的购货店铺，并要求其为您支付订单");
break;
default:
showinfo = GetTran("007523", "未知错误");
break;
}
lblinfo.Text = showinfo;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
Permissions.ThreeRedirect(Page, "../Member/" + Permissions.redirUrl);
//AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxMemShopCart));
if (!IsPostBack)
{
Translations();
lbltype.Text = GetTran("007286", "报单支付");
lblot.Text = GetTran("000079", "订单号");
if (Request.QueryString["blif"] != null && Request.QueryString["blif"] != "")
{
string blif = Request.QueryString["blif"].ToString();
string[] strs = EncryKey.GetDecrypt(blif);
if (strs.Length >= 3)
{
ViewState["billid"] = strs[0];
ViewState["dotype"] = strs[1];
ViewState["roletype"] = strs[2];
if (ViewState["billid"] != null && ViewState["dotype"] != null && ViewState["roletype"] != null)
{
if (ViewState["dotype"].ToString() == "2")
{
loadpaytype();
LoadData1(); //数据加载
}
else
{
if (ViewState["roletype"].ToString() == "2")
{
loadpaytype();
LoadData1(); //数据加载
}
else
{
DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select ordertype from memberorder where OrderID=" + strs[0]);
string ordertype = dt_one.Rows[0]["ordertype"].ToString(); //订单类型
loadpaytype();
LoadData(ordertype); //数据加载
}
}
ViewState["loginnumber"] = loginnumber;
//店铺离线支付
if (DocTypeTableDAL.Getpaytypeisusebyid(1, 1) || DocTypeTableDAL.Getpaytypeisusebyid(6, 5))
{
Loadmk(); //生成标识
}
}
else
{
Response.Redirect("payerror1.aspx");
}
}
else
{
Response.Redirect("payerror1.aspx");
}
}
else
{
Response.Redirect("../default.aspx");
}
}
}
/// <summary>
/// 绑定数据
/// </summary>
private void DataBind()
{
StringBuilder sb = new StringBuilder();
string table = "";
//会员
if (ViewState["Kmtype"].ToString() == "AccountXJ")//现金账户
{
table = "memberaccount"; sb.Append("and number='" + Session["Member"].ToString() + "' and SfType=1 and happenmoney!=0");
}
else if (ViewState["Kmtype"].ToString() == "AccountXF")//消费账户
{
table = "memberaccount"; sb.Append("and number='" + Session["Member"].ToString() + "' and SfType=0 and happenmoney!=0");
}
else if (ViewState["Kmtype"].ToString() == "AccountFX")//复消账户
{
table = "memberaccount"; sb.Append("and number='" + Session["Member"].ToString() + "' and SfType=2 and happenmoney!=0");
}
else if (ViewState["Kmtype"].ToString() == "AccountFXth")//复消提货账户
{
table = "memberaccount"; sb.Append("and number='" + Session["Member"].ToString() + "' and SfType=3 and happenmoney!=0");
}
else if (ViewState["Kmtype"].ToString() == "AccountZSJF")//赠送积分
{
table = "memberaccount"; sb.Append("and number='" + Session["Member"].ToString() + "' and SfType=4 and happenmoney!=0");
}
else if (ViewState["Kmtype"].ToString() == "AccountSFJF")//释放积分
{
table = "memberaccount"; sb.Append("and number='" + Session["Member"].ToString() + "' and SfType=5 and happenmoney!=0");
}
//店铺
else if (ViewState["Kmtype"].ToString() == "AccountDH")//订货款账户
{
table = "storeaccount"; sb.Append("and number='" + Session["Store"].ToString() + "' and SfType=0 and happenmoney!=0");
}
else if (ViewState["Kmtype"].ToString() == "AccountZZ")//周转款账户
{
table = "storeaccount"; sb.Append("and number='" + Session["Store"].ToString() + "' and SfType=1 and happenmoney!=0");
}
string BeginRiQi = "";
string EndRiQi = "";
string kmtype = Request.Form["chb_name"];
if (kmtype != null)
{
sb.Append(" and kmtype in(" + kmtype + ")");
}
if (ddl_OutIn.SelectedValue != "-1")
{
sb.Append(" and Direction=" + ddl_OutIn.SelectedValue);
}
if (this.Datepicker1.Text != "")
{
DateTime time = DateTime.Now.ToUniversalTime();
bool b = DateTime.TryParse(Datepicker1.Text.Trim(), out time);
if (!b)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + GetTran("000827", "时间格式不正确！") + "')</script>");
return;
}
BeginRiQi = this.Datepicker1.Text.Trim().ToString();
DisposeString.DisString(BeginRiQi, "'", "");
if (this.Datepicker2.Text != "")
{
b = DateTime.TryParse(Datepicker2.Text.Trim(), out time);
if (!b)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + GetTran("000827", "时间格式不正确！") + "')</script>");
return;
}
EndRiQi = (DateTime.Parse(this.Datepicker2.Text).AddHours(23).AddMinutes(59).AddSeconds(59)).ToString();
DisposeString.DisString(EndRiQi, "'", "");
sb.Append(" and happentime>= '" + BeginRiQi + "' and happentime<='" + EndRiQi + "'");
}
else
{
sb.Append(" and happentime>= '" + BeginRiQi + "'");
}
}
else
{
if (this.Datepicker2.Text != "")
{
DateTime time = DateTime.Now.ToUniversalTime();
bool b = DateTime.TryParse(Datepicker2.Text.Trim(), out time);
if (!b)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + GetTran("000827", "时间格式不正确！") + "')</script>");
return;
}
EndRiQi = (DateTime.Parse(this.Datepicker2.Text.Trim()).AddHours(23).AddMinutes(59).AddSeconds(59)).ToString();
sb.Append(" and happentime<='" + EndRiQi + "'");
}
}
ViewState["Sql"] = "select isnull(sum(ABS(isnull(happenmoney,0))),0) as happenmoney from " + table + " where 1=1 " + sb.ToString();
//获取汇率
currency = AjaxClass.GetCurrency(int.Parse(Session["Default_Currency"] == null ? bzCurrency.ToString() : Session["Default_Currency"].ToString()));
//转入0 转出1
happenmoney = "happenmoney*" + currency + " as happenmoney";
//结余金额
string Balancemoney = "Balancemoney*" + currency + " as Balancemoney";
//
string cloumns = "id,number,happentime,Direction,sftype,kmtype,remark" + "," + happenmoney + "," + Balancemoney;
string key = "id";
if (table != "")
{
lit_heji.Text = GetHappenMoney(ViewState["Sql"].ToString());
string sql = "select " + cloumns + " from " + table + " where 1=1 " + sb.ToString() + " order by " + key + " desc ";
this.ucPagerMb1.PageSize = 10;
this.ucPagerMb1.PageInit(sql, rep_km.UniqueID);
}
else
{
Response.Redirect("../member/index.aspx");
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
string sql = ViewState["sql"].ToString();
sql = sql.Replace("|*|", " " + (1 - 1) * 10 + " ");
dt2 = DAL.DBHelper.ExecuteDataTable(sql);
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "bg=this.style.backgroundColor;this.style.backgroundColor='#FFFFCC'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=bg");
IDictionaryEnumerator myEnumerator = StringOfNumtable.GetEnumerator();
foreach (TableCell cell in e.Row.Cells)
{
cell.Text = cell.Text.Replace("<", "<");
cell.Text = cell.Text.Replace(">", ">");
cell.Text = cell.Text.Replace("<", "<");
cell.Text = cell.Text.Replace(" ", "");
cell.Text = cell.Text.Replace("&nbsp;", "");
try
{
DateTime time = DateTime.Parse(cell.Text);
}
catch
{
}
}
for (int i = 0; i < dt2.Columns.Count; i++)
{
string name = dt2.Columns[i].ColumnName;
if (name == GetTran("000000", "安置人姓名"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[i].Text);
}
else if (name == GetTran("000000", "推荐人姓名"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[i].Text);
}
else if (name == GetTran("000025", "会员姓名"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[i].Text);
}
else if (name == GetTran("000085", "性别"))
{
if (e.Row.Cells[i].Text == "0")
{
e.Row.Cells[i].Text = "女";
}
else
{
e.Row.Cells[i].Text = "男";
}
}
else if (name == GetTran("000086", "开户名"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[i].Text);
}
else if (name == GetTran("000065", "家庭电话"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherTele(e.Row.Cells[i].Text);
}
else if (name == GetTran("000044", "办公电话"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherTele(e.Row.Cells[i].Text);
}
else if (name == GetTran("000069", "移动电话"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherTele(e.Row.Cells[i].Text);
}
else if (name == GetTran("000071", "传真电话"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherTele(e.Row.Cells[i].Text);
}
else if (name == GetTran("000083", "证件号码"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherNumber(e.Row.Cells[i].Text);
}
else if (name == GetTran("000923", "卡号"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherCard(e.Row.Cells[i].Text);
}
else if (name == GetTran("000111", "银行账号"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[i].Text);
}
else if (name == GetTran("000920", "详细地址"))
{
e.Row.Cells[i].Text = Encryption.Encryption.GetDecipherAddress(e.Row.Cells[i].Text);
}
else if (name == GetTran("000057", "注册日期"))
{
e.Row.Cells[i].Text = PageBase.GetbyDT(e.Row.Cells[i].Text);
}
else if (name == GetTran("000105", "出生日期"))
{
e.Row.Cells[i].Text = Convert.ToDateTime(e.Row.Cells[i].Text).ToString("yyyy-MM-dd");
}
else if (name == GetTran("000916", "国家省份城市"))
{
CityModel model = DAL.CommonDataDAL.GetCPCCode(e.Row.Cells[i].Text.Trim());
e.Row.Cells[i].Text = model.Country + model.Province + model.City;
}
else if (name == GetTran("000087", "开户银行"))
{
e.Row.Cells[i].Text = DAL.CommonDataDAL.GetBankName(e.Row.Cells[i].Text.Trim());
}
else if (name == "新人激励奖")
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == "组织奖")
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == " 辅导奖")
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == "互动奖")
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == "销售提成")
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == "销售分红")
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == "管理奖")
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == "物流中心补贴")
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == "网上报单中心补贴")
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == GetTran("000247", "总计"))
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == GetTran("000249", "扣税"))
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == GetTran("000251", "扣款"))
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == GetTran("000254", "实发"))
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == GetTran("000951", "总计累计"))
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == GetTran("000953", "实发累计"))
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[i].Text = "0";
}
else
{
if (e.Row.Cells[i].Text != "")
{
e.Row.Cells[i].Text = (Convert.ToDouble(e.Row.Cells[i].Text) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
else
{
e.Row.Cells[i].Text = "0";
}
}
}
else if (name == GetTran("007598", "董事"))
{
string sql = "select levelstr from bsco_level where levelflag=2 and levelint=" + e.Row.Cells[i].Text;
e.Row.Cells[i].Text = DAL.DBHelper.ExecuteScalar(sql) == null ? " " : DAL.DBHelper.ExecuteScalar(sql).ToString();
}
else if (name == GetTran("007273", "资格"))
{
string sql = "select levelstr from bsco_level where levelflag=0 and levelint=" + e.Row.Cells[i].Text;
e.Row.Cells[i].Text = DAL.DBHelper.ExecuteScalar(sql) == null ? " " : DAL.DBHelper.ExecuteScalar(sql).ToString();
}
else if (name == GetTran("007460", "总监"))
{
string sql = "select levelstr from bsco_level where levelflag=3 and levelint=" + e.Row.Cells[i].Text;
e.Row.Cells[i].Text = DAL.DBHelper.ExecuteScalar(sql) == null ? " " : DAL.DBHelper.ExecuteScalar(sql).ToString();
}
else if (name == GetTran("000936", "新网分数") || name == GetTran("000937", "总网分数") || name == GetTran("000939", "新个分数") ||
name == GetTran("000940", "总个分数") || name == GetTran("000942", "未付款的总个分数") || name == GetTran("000944", "未付款的总网分数"))
{
e.Row.Cells[i].Text = Convert.ToDouble(e.Row.Cells[i].Text.ToString()).ToString("f2");
}
}
while (myEnumerator.MoveNext())
{
e.Row.Cells[(int)myEnumerator.Key].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
}
IDictionaryEnumerator myEnumerator1 = table.GetEnumerator();
while (myEnumerator1.MoveNext())
{
e.Row.Cells[(int)myEnumerator1.Key].HorizontalAlign = HorizontalAlign.Right;
}
}
if (e.Row.RowType == DataControlRowType.Footer)
{
IDictionaryEnumerator myEnumerator = table.GetEnumerator();
while (myEnumerator.MoveNext())
{
if (AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
{
e.Row.Cells[(int)myEnumerator.Key].Text = "0";
}
else
{
e.Row.Cells[(int)myEnumerator.Key].Text = (Convert.ToDouble(myEnumerator.Value) / AjaxClass.GetCurrency(Convert.ToInt32(Session["currency"]), Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
}
e.Row.Cells[(int)myEnumerator.Key].HorizontalAlign = HorizontalAlign.Right;
string name = dt2.Columns[(int)myEnumerator.Key].ColumnName;
if (name == GetTran("000933", "总网人数") || name == GetTran("000934", "新网人数"))
{
e.Row.Cells[(int)myEnumerator.Key].Text = Convert.ToDouble(e.Row.Cells[(int)myEnumerator.Key].Text).ToString();
}
}
e.Row.Cells[0].Text = GetTran("000630", "合计");
if (GridView1.PageIndex == GridView1.PageCount - 1)
{
GridView1.ShowFooter = true;
}
else
{
GridView1.ShowFooter = false;
}
}
else if (e.Row.RowType == DataControlRowType.Header)
{
for (int i = 0; i < e.Row.Cells.Count; i++)
{
e.Row.Cells[i].Text = " " + e.Row.Cells[i].Text + " ";
}
e.Row.Attributes.Add("style", "background-image:url('images/tabledp.gif')");
}
}