protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
double learnpt = cf.learnPart; //学习币比例
nID = Request.QueryString["uid"].ToString();
int PayMoneyNO = sh.getPayMoneyNO(nID); //申请中
int FenXiangYJ = tj.GetFenXiangYJ(nID); //分享佣金
int PayMoney = sh.getPayMoney(nID); //已提现
int jiangxj = tj.GetSumMoneyByUser(nID); //累计奖学金,分红
int jintie = tj.GetJx(nID); //绩效，津贴
//总金=分享佣金+全球分红+绩效+邀请关注(2016/3/30)
double allmakemoney = FenXiangYJ + jiangxj + jintie + tj.GetAttentionXF(nID);
//当前剩余资金=总金-已提现-已申请-转学习币
double allpri = allmakemoney - PayMoney - PayMoneyNO - tj.GetMoneyToXueBi(nID);
//总学习币=总金的一定比例
double allxxb = tj.Round((allmakemoney) * learnpt, 0);
//可用学习币=总学习币-已使用学习币+转入学习币+首次关注赠送(2016/3/30)
double canxxb = allxxb - sh.getUsedXueXb(nID) + tj.GetXueXibi(nID) + tj.GetAttentionXXB(nID);
//可提现资金=当前剩余资金-总学习币
double canpri = allpri - allxxb;
hidpri.Value = canpri.ToString();
//当前可提现资金=总金-已提现-已申请+全球分红+绩效-学习币
CanGetPri = StringDelHTML.DoublePriceToString(canpri);
}
else
{
Response.Redirect("errors.html");
}
}
//修改产品
public bool UpdateProduct(string ID, string dropGroup, string title, string urlPic, string urlVideo, string tMemo, string oNew, string oTop, string pbtime, string oHide, string pri)
{
SqlParameter sid0 = new SqlParameter("@sid0", dropGroup);
//SqlParameter VideoCode = new SqlParameter("@VideoCode", "0");
SqlParameter VideoName = new SqlParameter("@VideoName", title);
SqlParameter tPic = new SqlParameter("@tPic", urlPic);
SqlParameter tVideo = new SqlParameter("@tVideo", urlVideo);
SqlParameter tMemos = new SqlParameter("@tMemo", tMemo);
SqlParameter oNewest = new SqlParameter("@oNewest", int.Parse(oNew));
SqlParameter oTops = new SqlParameter("@oTop", int.Parse(oTop));
SqlParameter dtPubTime = new SqlParameter("@dtPubTime", Convert.ToDateTime(pbtime));
SqlParameter dtAddTime = new SqlParameter("@dtAddTime", System.DateTime.Now);
SqlParameter oHides = new SqlParameter("@oHide", int.Parse(oHide));
SqlParameter price = new SqlParameter("@Price", StringDelHTML.PriceToIntUp(pri));
SqlParameter[] count = { sid0, VideoName, tPic, tVideo, tMemos, oNewest, oTops, dtPubTime, dtAddTime, oHides, price };
string sql = @"update ML_Video set sid0=@sid0,VideoName=@VideoName,tPic=@tPic,tVideo=@tVideo,
tMemo=@tMemo,oNewest=@oNewest,oTop=@oTop,dtPubTime=@dtPubTime,dtAddTime=@dtAddTime,oHide=@oHide,Price=@Price where nID=" + ID;
bool success = her.ExecuteNonQuery(sql, count);
if (success)
{
return(true);
}
return(false);
}
protected void gridField_DataBound(object sender, EventArgs e)
{
for (int i = 0; i < gridField.Rows.Count; i++)
{
Label lbSex = (Label)gridField.Rows[i].FindControl("lbSex");
lbSex.Text = StringDelHTML.PriceToStringLow(Convert.ToInt32(lbSex.Text));
Label lbPhone = (Label)gridField.Rows[i].FindControl("lbPhone");
lbPhone.Text = StringDelHTML.PriceToStringLow(Convert.ToInt32(lbPhone.Text));
Label lbMemberPass = (Label)gridField.Rows[i].FindControl("lbMemberPass");
lbMemberPass.Text = (Convert.ToDouble(lbMemberPass.Text)) * 100 + "%";
//Label lbisJXS = (Label)gridField.Rows[i].FindControl("lbisJXS");
//if (lbisJXS.Text.ToLower() == "true")
//{
// lbisJXS.Text = "是";
//}
//else
//{
// lbisJXS.Text = "否";
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
StringBuilder sb = new StringBuilder();
nID = Request.QueryString["uid"].ToString();
DataTable dt = tj.GetFenXiangJL(nID);
foreach (DataRow dr in dt.Rows)
{
string pri = StringDelHTML.PriceToStringLow(Convert.ToInt32(dr["price"].ToString()));
string nickname = StringDelHTML.Centers(dr["nickname"].ToString(), 6);
//(" + dr["part"].ToString() + "%)
sb.AppendLine("<dd>" + nickname + "(" + pri + ")<span>" + dr["CreateTime"].ToString() + "</span></dd>");
}
if (string.IsNullOrEmpty(sb.ToString()))
{
sb.Append("<h1 style='text-align: center; margin-top: 20px'>这里什么也没留下 </h1>");
}
liststr = sb.ToString();
}
else
{
Response.Redirect("errors.html");
}
}
protected void gridField_DataBound(object sender, EventArgs e)
{
for (int i = 0; i < gridField.Rows.Count; i++)
{
Image img = gridField.Rows[i].FindControl("img1") as Image;
img.ImageUrl = "../../upload_Img/VideoImg/" + img.ImageUrl;
Label lbtMemo = gridField.Rows[i].FindControl("lbvMemo") as Label;
lbtMemo.Text = StringDelHTML.Centers(StringDelHTML.DelHTML(lbtMemo.Text), 30);
Label lbprice = gridField.Rows[i].FindControl("lbprice") as Label;
lbprice.Text = StringDelHTML.PriceToStringLow(Convert.ToInt32(lbprice.Text));
Label lballpri = gridField.Rows[i].FindControl("lballpri") as Label;
lballpri.Text = StringDelHTML.PriceToStringLow(Convert.ToInt32(lballpri.Text));
Label lblth = gridField.Rows[i].FindControl("lblth") as Label;
if (lblth.Text == "True")
{
lblth.Text = "是";
}
else
{
lblth.Text = "否";
}
}
}
/// <summary>
/// 添加产品
/// </summary>
/// <param name="dropGroup"></param>
/// <param name="title"></param>
/// <param name="urlPic"></param>
/// <param name="urlVideo"></param>
/// <param name="tMemo"></param>
/// <param name="oNewest"></param>
/// <param name="oTop"></param>
/// <param name="pbtime"></param>
/// <param name="oHide"></param>
/// <returns></returns>
public bool InsertProduct(string dropGroup, string title, string urlPic, string urlVideo, string tMemo, string oNew, string oTop, string pbtime, string oHide, string pri)
{
SqlParameter sid0 = new SqlParameter("@sid0", dropGroup);
SqlParameter VideoCode = new SqlParameter("@VideoCode", 0);
SqlParameter VideoName = new SqlParameter("@VideoName", title);
SqlParameter tPic = new SqlParameter("@tPic", urlPic);
SqlParameter tVideo = new SqlParameter("@tVideo", urlVideo);
SqlParameter tMemos = new SqlParameter("@tMemo", tMemo);
SqlParameter oNewest = new SqlParameter("@oNewest", int.Parse(oNew));
SqlParameter oTops = new SqlParameter("@oTop", int.Parse(oTop));
SqlParameter dtPubTime = new SqlParameter("@dtPubTime", Convert.ToDateTime(pbtime));
SqlParameter dtAddTime = new SqlParameter("@dtAddTime", System.DateTime.Now);
SqlParameter oHides = new SqlParameter("@oHide", int.Parse(oHide));
SqlParameter price = new SqlParameter("@Price", StringDelHTML.PriceToIntUp(pri));
SqlParameter[] count = { sid0, VideoCode, VideoName, tPic, tVideo, tMemos, oNewest, oTops, dtPubTime, dtAddTime, oHides, price };
string sql = @"insert into ML_Video values (@sid0,@VideoCode,@VideoName,@tPic,@tVideo,@tMemo,@oNewest,@oTop,@dtPubTime,@dtAddTime,@oHide,@Price)";
bool success = her.ExecuteNonQuery(sql, count);
if (success)
{
return(true);
}
return(false);
}
//修改产品系列
public bool UpdateProduct(string ID, string title, string urlPic, string urlVideo, string tMemo, string pbtime, string oHide, string pri
, string vd, string tid, string oFree)
{
SqlParameter sid = new SqlParameter("@sid0", Convert.ToInt32(0));
SqlParameter VideoName = new SqlParameter("@vName", title);
SqlParameter tPic = new SqlParameter("@vPic", urlPic);
SqlParameter tVideo = new SqlParameter("@vUrl", urlVideo);
SqlParameter tMemos = new SqlParameter("@vMemo", tMemo);
SqlParameter dtAddTime = new SqlParameter("@addTime", Convert.ToDateTime(pbtime));
SqlParameter oHides = new SqlParameter("@oHide", int.Parse(oHide));
SqlParameter price = new SqlParameter("@Price", StringDelHTML.PriceToIntUp(pri));
SqlParameter vdiscrib = new SqlParameter("@vdiscrib", vd);
SqlParameter teacherID = new SqlParameter("@teacherID", tid);
SqlParameter ofree = new SqlParameter("@oFree", int.Parse(oFree));
SqlParameter[] count = { sid, VideoName, tPic, tVideo, tMemos, dtAddTime, oHides, price,
vdiscrib, teacherID, ofree };
string sql = @"update ML_VideoComment set sid0=@sid0,vMemo=@vMemo,Price=@Price,vName=@vName,
vPic=@vPic,vUrl=@vUrl,oHide=@oHide,addTime=@addTime,vdiscrib=@vdiscrib,teacherID=@teacherID,oFree=@oFree where nID=" + ID;
bool success = her.ExecuteNonQuery(sql, count);
if (success)
{
return(true);
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
StringBuilder sb = new StringBuilder();
nID = Request.QueryString["uid"].ToString();
//DataTable dt = tj.GetFenXiangJL(nID);
string sql = @"select a.OcType,a.CreateTime,a.OrderPrice,b.vName from ML_Order a
left join ML_VideoComment b on a.OcID=b.nID where a.OrderUserid=" + nID + " and a.OcType='学习币支付' order by a.CreateTime desc ";
DataTable dt = her.ExecuteDataTable(sql);
foreach (DataRow dr in dt.Rows)
{
string pri = StringDelHTML.PriceToStringLow(Convert.ToInt32(dr["OrderPrice"].ToString()));
sb.AppendLine("<dd>" + dr["vName"].ToString() + "（" + pri + "）<span>" + dr["CreateTime"].ToString() + "</span></dd>");
}
if (string.IsNullOrEmpty(sb.ToString()))
{
sb.Append("<h1 style='text-align: center; margin-top: 20px'>这里什么也没留下 </h1>");
}
liststr = sb.ToString();
}
else
{
Response.Redirect("errors.html");
}
}
private void GetSumFenhong()
{
string sql = "select isnull( sum(AvgMoney),0) from T_AvgMoneyLastDay";
int allmoney = her.ExecuteScalar(sql) == null ? 0 : Convert.ToInt32(her.ExecuteScalar(sql));
Fenhong = StringDelHTML.PriceToStringLow(allmoney);
}
private void MoneyRequest()
{
string sql = "select AllPrice from MoneyOrder where nID=" + nID;
oprice = her.ExecuteScalar(sql) == DBNull.Value ? 0 : Convert.ToInt32(her.ExecuteScalar(sql).ToString());
allprice = Price = StringDelHTML.PriceToStringLow(oprice);
}
protected void ImgSrs_Click(object sender, EventArgs e)
{
int money = StringDelHTML.PriceToIntUp(price.Text.Trim());
//插入全球分红，每日
DateTime dt = System.DateTime.Now;
if (dt.Hour > 10)//每天10点以后的数据
{
DataTable table = tj.GetUserByLevel(_level);
if (table.Rows.Count > 0)
{
if (tj.InsertFenHongLastDay(table, _level, money, true))
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('分红成功')</script>");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('您已提交过昨日的分红')</script>");
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('无可分红对象')</script>");
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('每日10点后才能提交分红')</script>");
}
}
/// <summary>
/// 添加产品系列
/// </summary>
/// <param name="title"></param>
/// <param name="urlPic"></param>
/// <param name="urlVideo"></param>
/// <param name="tMemo"></param>
/// <param name="pbtime"></param>
/// <param name="oHide"></param>
/// <param name="pri"></param>
/// <returns></returns>
public bool InsertProduct(string title, string urlPic, string urlVideo, string tMemo, string pbtime, string oHide, string pri
, string vd, string tid, string oFree)
{
SqlParameter sid = new SqlParameter("@sid0", Convert.ToInt32(0));
SqlParameter VideoName = new SqlParameter("@vName", title);
SqlParameter tPic = new SqlParameter("@vPic", urlPic);
SqlParameter tVideo = new SqlParameter("@vUrl", "");
SqlParameter tMemos = new SqlParameter("@vMemo", tMemo);
SqlParameter dtAddTime = new SqlParameter("@addTime", Convert.ToDateTime(pbtime));
SqlParameter oHides = new SqlParameter("@oHide", int.Parse(oHide));
SqlParameter price = new SqlParameter("@Price", StringDelHTML.PriceToIntUp(pri));
SqlParameter vdiscrib = new SqlParameter("@vdiscrib", vd);
SqlParameter teacherID = new SqlParameter("@teacherID", tid);
SqlParameter ofree = new SqlParameter("@oFree", int.Parse(oFree));
SqlParameter[] count = { sid, VideoName, tPic, tVideo, tMemos, dtAddTime, oHides, price,
vdiscrib, teacherID, ofree };
string sql = @"insert into ML_VideoComment values (@sid0,@vMemo,@Price,@vName,@vPic,@vUrl,@oHide,@addTime
,@vdiscrib,@teacherID,@oFree)";
bool success = her.ExecuteNonQuery(sql, count);
if (success)
{
return(true);
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
StringBuilder sb = new StringBuilder();
nID = Request.QueryString["uid"].ToString();
uid = nID;
DataTable dt = tj.GetMoneyOrderList(nID);
foreach (DataRow dr in dt.Rows)
{
string pri = StringDelHTML.PriceToStringLow(Convert.ToInt32(dr["AllPrice"]));
if (dr["OrderState"].ToString().ToLower().Equals("true"))
{
sb.AppendLine("<dd>完成（" + pri + "）<span>" + dr["UpdateTime"].ToString() + "</span></dd>");
}
else
{
sb.AppendLine("<dd>处理中（" + pri + "）<span>" + dr["CreateTime"].ToString() + "</span></dd>");
}
}
if (string.IsNullOrEmpty(sb.ToString()))
{
sb.Append("<h1 style='text-align: center; margin-top: 20px'>这里什么也没留下 </h1>");
}
liststr = sb.ToString();
}
else
{
Response.Redirect("errors.html");
}
}
private void TongJi()
{
DataTable dtdl = dl.MemberSelectTongJi(); //代理商申请
DataTable dtor = or.GetOrderTongji(); //待发货
StringBuilder sb = new StringBuilder();
StringBuilder sb1 = new StringBuilder();
StringBuilder sb2 = new StringBuilder();
sb.AppendLine("<li><i><a href='../Members/MemberMain.aspx'>用户总数：</a></i>" + dl.MakSelectTongJi() + "人</li>");
sb.AppendLine("<li><i><a href='../Pruduct/ServceMain.aspx'>会员总数：</a></i>" + dl.ProductSelectTongJi() + "人</li>");
sb.AppendLine("<li><i><a href='../Order/OrderMain.aspx'>视频个数：</a></i>" + or.videoCount() + "部</li>");
sb.AppendLine("<li><i><a href='../Order/OrderMainFaHuo.aspx'>总成交额：</a></i>" + or.momeycount() + "元</li>");
sb.AppendLine("<li><i><a href='../Order/OrderMain.aspx'>日成交额：</a></i>" + or.momeycountDate() + "元</li>");
sb.AppendLine("<li><i><a href='../Order/OrderMainTuiHuo.aspx'>总订单量：</a></i>" + or.OrderCount() + "个</li>");
strTongJ = sb.ToString();
foreach (DataRow dr in dtdl.Rows)
{
string time = Convert.ToDateTime(dr["dtAddTime"]).ToString("yyyy-MM-dd HH:mm:ss");
string nicname = StringDelHTML.Centers(dr["nickname"].ToString(), 15);
sb1.AppendLine("<li><a href='../Members/Member_Main.aspx'>" + nicname + "</a><b>" + time + "</b></li>");
}
foreach (DataRow dr in dtor.Rows)
{
string time = Convert.ToDateTime(dr["CreateTime"]).ToString("yyyy-MM-dd HH:mm:ss");
sb2.AppendLine("<li><a href='../Order/OrderMain.aspx'>" + dr["OrderCode"].ToString() + "</a><b>" + time + "</b></li>");
}
strDaiLiList = sb1.ToString();
strQr = sb2.ToString();
}
protected void gridField_DataBound(object sender, EventArgs e)
{
for (int i = 0; i < gridField.Rows.Count; i++)
{
Label lbSex = (Label)gridField.Rows[i].FindControl("lbSex");
if (lbSex.Text == "1")
{
lbSex.Text = "男";
}
else if (lbSex.Text == "2")
{
lbSex.Text = "女";
}
else
{
lbSex.Text = "未确定";
}
Label lbAllMoney = (Label)gridField.Rows[i].FindControl("lbAllMoney");
lbAllMoney.Text = StringDelHTML.PriceToStringLow(Convert.ToInt32(lbAllMoney.Text));
//Label lbisJXS = (Label)gridField.Rows[i].FindControl("lbisJXS");
//if (lbisJXS.Text.ToLower() == "true")
//{
// lbisJXS.Text = "是";
//}
//else
//{
// lbisJXS.Text = "否";
//}
}
}
public DataTable GetSource(int level)
{
DataTable dt = new DataTable();
SqlHelper her = new SqlHelper();
string sql = string.Empty;
switch (level)
{
case 3: sql = @"select a.*,b.levelName from ML_Member a left join ML_MemberLevel b on a.fxslevel=b.nID
where datediff(day,a.fxsTimeBegin,getdate()-1)>=0 and a.fxslevel=3 or
datediff(day,a.fxsTimeEnd,getdate())=0 and a.fxslevel=4 or
datediff(day,a.level3Time,getdate())=0 and a.fxslevel=5
order by a.fxsTimeBegin desc"; break;
case 4: sql = @"select a.*,b.levelName from ML_Member a left join ML_MemberLevel b on a.fxslevel=b.nID
where datediff(day,a.fxsTimeEnd,getdate()-1)>=0 and a.fxslevel=4 or
datediff(day,a.level3Time,getdate())=0 and a.fxslevel=5
order by a.fxsTimeBegin desc"; break;
case 5: sql = @" select a.*,b.levelName from ML_Member a left join ML_MemberLevel b on a.fxslevel=b.nID
where datediff(day,a.level3Time,getdate()-1)>=0 and a.fxslevel=5 order by a.level3Time desc"; break;
default: break;
}
if (!string.IsNullOrEmpty(sql))
{
dt = her.ExecuteDataTable(sql);
userCount = dt.Rows.Count.ToString();
yingyee = StringDelHTML.PriceToStringLow(tj.AllMoneyToday());
}
return(dt);
}
private void tongji(DateTime dt)
{
DataTable table3 = GetFenhong(dt, 3);
if (table3.Rows.Count > 0)
{
banzhangrenshu = table3.Rows[0]["UserCount"].ToString();
banzhangfenhong = StringDelHTML.PriceToStringLow(Convert.ToInt32(table3.Rows[0]["AvgMoney"]));
banzhangAllmoney = StringDelHTML.PriceToStringLow(Convert.ToInt32(table3.Rows[0]["UserCount"]) * Convert.ToInt32(table3.Rows[0]["AvgMoney"]));
}
DataTable table4 = GetFenhong(dt, 4);
if (table4.Rows.Count > 0)
{
zhurenrenshu = table4.Rows[0]["UserCount"].ToString();
zhurenfenhong = StringDelHTML.PriceToStringLow(Convert.ToInt32(table4.Rows[0]["AvgMoney"]));
zhurenAllmoney = StringDelHTML.PriceToStringLow(Convert.ToInt32(table4.Rows[0]["UserCount"]) * Convert.ToInt32(table4.Rows[0]["AvgMoney"]));
}
DataTable table5 = GetFenhong(dt, 5);
if (table5.Rows.Count > 0)
{
xiaozhangrenshu = table5.Rows[0]["UserCount"].ToString();
xiaozhangfenhong = StringDelHTML.PriceToStringLow(Convert.ToInt32(table5.Rows[0]["AvgMoney"]));
xiaozhangAllmoney = StringDelHTML.PriceToStringLow(Convert.ToInt32(table5.Rows[0]["UserCount"]) * Convert.ToInt32(table5.Rows[0]["AvgMoney"]));
}
}
private string getFreeVideo()
{
StringBuilder sb = new StringBuilder();
string sql = @"select * from ML_VideoComment where oHide=1 and oFree=1 order by addTime desc ";//where oHide=1
DataTable dt = her.ExecuteDataTable(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string vname = StringDelHTML.Centers(dr["vName"].ToString(), 6);
string price = StringDelHTML.PriceToStringLow(Convert.ToInt32(dr["Price"]));
sb.AppendLine("<dd><a href='VideoShow.aspx?pid=" + dr["nID"].ToString() + "'>");
sb.AppendLine("<img src='../upload_Img/VideoImg/" + dr["vPic"].ToString() + "' />");
//sb.AppendLine("<h1>¥ " + price + " </h1>");
sb.AppendLine("<p>" + vname + "</p></a></dd>");
}
}
else
{
sb.Append("<h1 style='text-align: center'>敬请期待！ </h1>");
}
return(sb.ToString());
}
protected void gridField_DataBound(object sender, EventArgs e)
{
for (int i = 0; i < gridField.Rows.Count; i++)
{
Label lbuptime = gridField.Rows[i].FindControl("lbuptime") as Label;
Label lbprice = gridField.Rows[i].FindControl("lbprice") as Label;
lbprice.Text = StringDelHTML.PriceToStringLow(Convert.ToInt32(lbprice.Text));
Label lblName = gridField.Rows[i].FindControl("lbstate") as Label;
Button btnUpdate = gridField.Rows[i].FindControl("btnUpdate") as Button;
if (lblName.Text == "False")
{
lblName.Text = "未处理";
btnUpdate.Visible = true;
lbuptime.Text = "";
}
else
{
lblName.Text = "已处理";
btnUpdate.Visible = false;
//lbuptime.Text = lbuptime.Text;
}
}
}
protected void gridField_DataBound(object sender, EventArgs e)
{
for (int i = 0; i < gridField.Rows.Count; i++)
{
Label tMemo = gridField.Rows[i].FindControl("tMemo") as Label;
tMemo.Text = StringDelHTML.Centers(StringDelHTML.DelHTML(tMemo.Text), 70);
}
}
protected void gridField_DataBound(object sender, EventArgs e)
{
for (int i = 0; i < gridField.Rows.Count; i++)
{
Label lbprice = gridField.Rows[i].FindControl("lbprice") as Label;
lbprice.Text = StringDelHTML.PriceToStringLow(Convert.ToInt32(lbprice.Text));
}
}
public string momeycountDate()
{
DateTime dt = DateTime.Now;
string dateb = dt.ToString("yyyy-MM-dd");
string datee = dt.AddDays(1).ToString("yyyy-MM-dd");
string sql = string.Format(@" select ISNULL(sum(OrderPrice),0) from [ML_Order] where CreateTime>'{0}' and CreateTime<='{1}' ", dateb, datee);
return(hp.ExecuteScalar(sql) == DBNull.Value ? "0" : StringDelHTML.PriceToStringLow(Convert.ToInt32(hp.ExecuteScalar(sql))));
}
//根据ID查询信息并加载到界面
public void Interface(string id)
{
StringBuilder sb = new StringBuilder();
//sb.Append("<img id='viewImg" + i + "' src='../../upload_Img/" + arrPic[i].ToString() + "' style='width: 80px; height: 80px; float: left;'>");
DataTable dt = pc.GetProductByID(id);;
if (dt.Rows.Count > 0)
{
hidPurl.Value = dt.Rows[0]["tPic"].ToString(); //图片地址
picUrl = "<img id='viewImg' src='../../upload_Img/VideoImg/" + hidPurl.Value + "' style='width: 124px; height: 100px; float: left;'>";
hidVurl.Value = dt.Rows[0]["tVideo"].ToString(); //视频地址
//videoName = hidVurl.Value;
videoname.Text = hidVurl.Value;
DropGroup.SelectedValue = dt.Rows[0]["sid0"].ToString();
txtTlitle.Text = dt.Rows[0]["VideoName"].ToString(); //标题内容
content1.InnerText = dt.Rows[0]["tMemo"].ToString();
txtPubtime.Text = dt.Rows[0]["dtPubTime"].ToString();
txtPrice.Text = StringDelHTML.PriceToStringLow(dt.Rows[0]["Price"] == null ? 0 : Convert.ToInt32(dt.Rows[0]["Price"]));
if (dt.Rows[0]["oNewest"].ToString() == "1") //日韩
{
RadioState.SelectedValue = "1";
}
else
{
RadioState.SelectedValue = "0";
}
if (dt.Rows[0]["oTop"].ToString() == "1") //选购
{
RadioTh.SelectedValue = "1";
}
else
{
RadioTh.SelectedValue = "0";
}
if (dt.Rows[0]["oHide"].ToString() == "1") //上架
{
redioUPDown.SelectedValue = "1";
}
else
{
redioUPDown.SelectedValue = "0";
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('获取数据失败！')</script>");
}
}
/// <summary>
/// 插入上一日的全球分红
/// </summary>
/// <param name="dtuser"></param>
/// <param name="level"></param>
/// <returns></returns>
public bool InsertFenHongLastDay(DataTable dtuser, int level, int rmoney, bool shoudong)
{
bool flag = false;
int allmoney = AllMoneyToday();
int ucount = dtuser.Rows.Count;
int avg = 0;
double levellv = 0.0;
switch (level)
{
case 3: levellv = cf.leave_1; break;
case 4: levellv = cf.leave_2; break;
case 5: levellv = cf.leave_3; break;
}
if (ucount > 0) //有人分，才插入
{
if (shoudong) //是否手动分红
{
avg = rmoney;
}
else
{
avg = Convert.ToInt32(Round(Convert.ToDouble(allmoney * levellv / ucount), 0));//四舍五入取2位小数
}
//判断今日是否已经进行过分红操作,未分红，插入
if (!isFengHongToday(level))
{
InsertAllMoneyToday(level, ucount, allmoney, avg);
StringBuilder sql = new StringBuilder();
sql.Append("insert into T_AvgMoneyLastDay (userID,userlevel,AvgMoney,CreateTime) values ");
DateTime dt = System.DateTime.Now;
string dtDate = dt.ToLongDateString().ToString();
TemplateMsg tm = new TemplateMsg();
for (int i = 0; i < ucount; i++)
{
int uid = Convert.ToInt32(dtuser.Rows[i]["nID"]);
string opendid = dtuser.Rows[i]["openid"].ToString();
string url = "http://tv.gongxue168.com/wap/Global.aspx?uid=" + uid;
if (i == ucount - 1)//最后一个
{
sql.AppendLine("(" + uid + "," + level + "," + avg + ",'" + dt.ToString() + "')");
}
else
{
sql.AppendLine("(" + uid + "," + level + "," + avg + ",'" + dt.ToString() + "'),");
}
//微信模板，每日分红
tm.CommissionRemind(opendid, url, StringDelHTML.PriceToStringLow(avg), dtDate);
}
flag = her.ExecuteNonQuery(sql.ToString());
} //昨日已分红
} //没人分
return(flag);
}
private void GetProductPrice()
{
string sql = "select Price from ML_Video where nID=" + pID;
string price = her.ExecuteScalar(sql) == null ? "0.01" : her.ExecuteScalar(sql).ToString() == "" ? "0.01" : StringDelHTML.PriceToStringLow(Convert.ToInt32(her.ExecuteScalar(sql)));
LogUtil.WriteLog("产品价格=" + price);
this.proPrice = price;
orderprice.Value = StringDelHTML.PriceToIntUp(proPrice).ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
uID = Request.QueryString["uid"].ToString();
int userid = Convert.ToInt32(uID);
string sql = string.Format(@"select a.*,b.nickname fromname,b.MemberCode fromcode,c.MemberCode tocode,c.nickname toname from ML_ZhuanBi a
join ML_Member b on a.fromUser=b.nID
join ML_Member c on a.toUser=c.nID
where a.fromUser={0} or a.toUser={0} order by a.CreateTime desc", userid);
DataTable dt = her.ExecuteDataTable(sql);
StringBuilder sb = new StringBuilder();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string money = StringDelHTML.PriceToStringLow(Convert.ToInt32(dr["zrMoney"]));
if (dr["fromUser"].ToString().Equals(uID))//转出
{
string nickname = StringDelHTML.Centers(dr["toname"].ToString(), 5);
sb.AppendLine("<dd>");
sb.AppendLine("<h1>转让编号：" + dr["zrCode"].ToString() + "<span>转出</span></h1>");
sb.AppendLine("<h3>转给好友：" + nickname + " <span>共学ID：" + dr["tocode"].ToString() + "</span></h3>");
sb.AppendLine("<h4>转出金额：<span>¥ " + money + "</span></h4>");
sb.AppendLine("<h5>转出时间：<span>" + dr["CreateTime"].ToString() + "</span></h5>");
sb.AppendLine("<h5>备注：<span>" + dr["tMemo"].ToString() + "</span></h5>");
sb.AppendLine("<h2>转让状态：<span>已完成</span></h2>");
sb.AppendLine("</dd>");
}
else
{
string nickname = StringDelHTML.Centers(dr["fromname"].ToString(), 5);
sb.AppendLine("<dd>");
sb.AppendLine("<h1>转让编号：" + dr["zrCode"].ToString() + "<span class='cur'>转入</span></h1>");
sb.AppendLine("<h3>转入人：" + nickname + " <span>共学ID：" + dr["fromcode"].ToString() + "</span></h3>");
sb.AppendLine("<h4>转入金额：<span class='cur'>¥ " + money + "</span></h4>");
sb.AppendLine("<h5>转入时间：<span>" + dr["CreateTime"].ToString() + "</span></h5>");
sb.AppendLine("<h5>备注：<span>" + dr["tMemo"].ToString() + "</span></h5>");
sb.AppendLine("<h2>转让状态：<span class='cur'>已完成</span></h2>");
sb.AppendLine("</dd>");
}
}
}
else
{
sb.Append("<dd><h1 style='text-align: center'>这里什么也没留下 </h1></dd>");
}
fromstr = sb.ToString();
}
else
{
Response.Redirect("errors.html");
}
}
protected void gridField_DataBound(object sender, EventArgs e)
{
for (int i = 0; i < gridField.Rows.Count; i++)
{
Image img = gridField.Rows[i].FindControl("img1") as Image;
img.ImageUrl = "../../upload_Img/TeacherImg/" + img.ImageUrl;
Label lbtMemo = gridField.Rows[i].FindControl("lbvMemo") as Label;
lbtMemo.Text = StringDelHTML.Centers(StringDelHTML.DelHTML(lbtMemo.Text), 30);
}
}
private double learnpt = Convert.ToDouble(ConfigurationManager.AppSettings["learnPart"]);//学习币比例
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["pid"] != null && Request.QueryString["pid"].ToString() != "")
{
pID = Request.QueryString["pid"].ToString();
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
nID = Request.QueryString["uid"].ToString();
LogUtil.WriteLog("支付页面，用户=" + nID);
//获取用户openId
//GetUserOpenId();
GetOpenID(nID);
//生成欲支付订单
GetProductPrice();
PayMoney();
//下面这些是求 “可使用学习币”
int PayMoneyNO = sh.getPayMoneyNO(nID); //申请中
int FenXiangYJ = tj.GetFenXiangYJ(nID); //分享佣金
int PayMoneys = sh.getPayMoney(nID); //已提现
int jiangxj = tj.GetSumMoneyByUser(nID); //累计奖学金,分红
int jintie = tj.GetJx(nID); //绩效，津贴
//总金=分享佣金+全球分红+绩效+邀请关注(2016/3/30)
double allmakemoney = FenXiangYJ + jiangxj + jintie + tj.GetAttentionXF(nID);
//当前剩余资金=总金-已提现-已申请
// double allpri = allmakemoney - PayMoneys - PayMoneyNO;
//总学习币=总金的一定比例
double allxxb = tj.Round((allmakemoney) * learnpt, 0);
//可用学习币=总学习币-已使用学习币+转入学习币+首次关注赠送(2016/3/30)
double canxxb = allxxb - sh.getUsedXueXb(nID) + tj.GetXueXibi(nID) + tj.GetAttentionXXB(nID);
//可提现资金=当前剩余资金-总学习币
// double canpri = allpri - allxxb;
//学习币
xuexibi = StringDelHTML.DoublePriceToString(canxxb);
Gwb.Value = xuexibi;
}
else
{
LogUtil.WriteLog("用户ID丢失");
Response.Redirect("errors.html");
}
}
else
{
LogUtil.WriteLog("产品ID丢失");
Response.Redirect("errors.html");
}
}
}
private void getUser1()
{
StringBuilder sb = new StringBuilder();
Dictionary <string, UserInfo> dicPri = HttpRuntime.Cache["Ranking"] as Dictionary <string, UserInfo>;
if (HttpRuntime.Cache["Ranking"] == null)
{
HttpRuntime.Cache.Insert("Ranking", mp.getRadnking());
dicPri = HttpRuntime.Cache["Ranking"] as Dictionary <string, UserInfo>;
//HttpRuntime.Cache与HttpContext.Current.Cache是同一对象,建议使用HttpRuntime.Cache
}
int rows = 0;
foreach (KeyValuePair <string, UserInfo> dic in dicPri)
{
rows++;
while (rows <= 100)//100以内排名
{
string pri = StringDelHTML.DoublePriceToString(dic.Value.price);
string img = dic.Value.pic == "" ? "img/Styl_01.png" : dic.Value.pic;
sb.AppendLine("<dd><a><img src='" + img + "' />");
sb.AppendLine("<h1>昵称：" + dic.Value.nickname + "</h1>");
sb.AppendLine("<h2>" + dic.Value.levelname + "</h2>");
sb.AppendLine("<h2>学分：" + pri + "</h2>");
// sb.AppendLine("<span>" + rows + "</span></a></dd>");
if (!string.IsNullOrEmpty(uID))
{
if (uID.Equals(dic.Key))
{
sb.AppendLine("<span style='color:red;'>我</span></a></dd>");
MyTop = rows.ToString();
}
else
{
sb.AppendLine("<span>" + rows + "</span></a></dd>");
}
}
else
{
sb.AppendLine("<span>" + rows + "</span></a></dd>");
}
break;
}
}
if (string.IsNullOrEmpty(sb.ToString()))
{
sb.Append("<h1 style='text-align: center; margin-top: 20px'>这里什么也没留下 </h1>");
}
class1 = sb.ToString();
}
protected void gridField_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "apply")
{
string sql = " select sum(price) from T_UserJiXiao where bid= " + e.CommandArgument.ToString();
int pri = her.ExecuteScalar(sql) == null ? 0 : Convert.ToInt32(her.ExecuteScalar(sql));
string sql2 = " select tRealName from ML_Member where nID=" + e.CommandArgument.ToString();;
allJinTie = her.ExecuteScalar(sql2) + "_累计津贴：" + StringDelHTML.PriceToStringLow(pri);
// Response.Redirect("../Members/MyBranchMain.aspx?uid=" + + "&&ceid=" + gridField.PageIndex);
}
}