private void PupolateControls() { int userId = 0; if (Request.QueryString["userId"] != "" && Request.QueryString["userId"] != null) { userId = Convert.ToInt32(Request.QueryString["userId"]); } DataTable user = user_bll.GetUserDataTableByUserId(userId); UserList.DataSource = user; UserList.DataBind(); OAuthList.DataSource = oauth_bll.GetOAuthListDataTableByUserId(userId); OAuthList.DataBind(); int categoryRate = Convert.ToInt32(user.Rows[0]["CategoryRate"]); UserCategoryList.DataSource = cat_bll.GetUserCategoryList(userId, categoryRate); UserCategoryList.DataBind(); ZhuanTiList.DataSource = zt_bll.GetZhuanTiList(userId); ZhuanTiList.DataBind(); CardList.DataSource = card_bll.GetCardList(userId); CardList.DataBind(); List.DataSource = bll.GetItemListByUserId(userId); List.DataBind(); }
//加载数据 private void PopulateControls() { this.UserImage.ImageUrl = ImageHelper.GetUserImage(user.UserImage); this.UserNickName.Text = user.UserNickName; this.UserEmail.Text = user.UserEmail; this.UserPhone.Text = user.UserPhone; this.UserWorkDay.Items.FindByValue(user.UserWorkDay).Selected = true; this.CategoryRate.Text = user.CategoryRate.ToString(); this.JoinDay.Text = UserHelper.JoinDay(user.CreateDate).ToString(); DataTable items = item_bll.GetItemListByUserId(userId); this.ItemCount.Text = items.Rows.Count.ToString(); }
//导出数据到App protected void Button1_Click(object sender, EventArgs e) { string strUserId = this.UserIDBox.Text.Trim(); if (strUserId == "") { Utility.Alert(this, "用户ID不能为空!"); return; } int userId = Convert.ToInt32(strUserId); UserInfo user = user_bll.GetUserByUserId(userId); string fileName = "aalife2(" + user.UserID + user.UserName + ").bak"; StringBuilder sb = new StringBuilder(); //备份用户表 if (user.UserID > 0) { decimal userMoney = user.UserMoney; if (user.IsUpdate == 1) { userMoney = user.MoneyStart; } string result = "{"; result += "\"userid\":\"" + user.UserID + "\","; result += "\"username\":\"" + user.UserName + "\","; result += "\"userpass\":\"" + user.UserPassword + "\","; result += "\"usernickname\":\"" + user.UserNickName + "\","; result += "\"createdate\":\"" + user.CreateDate.ToString("yyyy-MM-dd") + "\","; result += "\"useremail\":\"" + user.UserEmail + "\","; result += "\"userphone\":\"" + user.UserPhone + "\","; result += "\"userimage\":\"" + user.UserImage + "\","; result += "\"userworkday\":\"" + user.UserWorkDay + "\","; result += "\"usermoney\":\"" + userMoney + "\","; result += "\"categoryrate\":\"" + user.CategoryRate + "\","; result += "\"login\":\"true\","; OAuthInfo oauth = oauth_bll.GetOAuthByUserId(user.UserID); if (oauth.OAuthBound == 0) { result += "\"userbound\":\"0\""; } else { result += "\"userbound\":\"1\""; } result += "}"; sb.AppendLine(result); sb.AppendLine(""); } //备份消费表 DataTable itemListTab = bll.GetItemListByUserId(userId); if (itemListTab.Rows.Count > 0) { sb.AppendLine("DELETE FROM ItemTable;"); for (int i = itemListTab.Rows.Count - 1; i >= 0; i--) { DataRow dr = itemListTab.Rows[i]; sb.AppendLine("INSERT INTO ItemTable (ItemWebID, ItemName, ItemPrice, ItemBuyDate, CategoryID, Recommend, Synchronize, RegionID, RegionType, ItemType, ZhuanTiID, CardID) VALUES ('" + dr["ItemID"].ToString() + "', '" + Utility.ReplaceSql(dr["ItemName"].ToString()) + "', '" + dr["ItemPrice"].ToString() + "', '" + String.Format("{0:yyyy-MM-dd}", dr["ItemBuyDate"]) + "', '" + dr["CategoryTypeID"].ToString() + "', '" + dr["Recommend"].ToString() + "', '0', '" + dr["RegionID"].ToString() + "', '" + dr["RegionType"].ToString() + "', '" + dr["ItemType"].ToString() + "', '" + dr["ZhuanTiID"].ToString() + "', '" + dr["CardID"].ToString() + "');"); } sb.AppendLine(""); } //备份类别表 DataTable catListTab = cat_bll.GetUserCategoryList(userId); if (catListTab.Rows.Count > 0) { sb.AppendLine("DELETE FROM CategoryTable;"); foreach (DataRow dr in catListTab.Rows) { sb.AppendLine("INSERT INTO CategoryTable (CategoryID, CategoryName, CategoryPrice, CategoryRank, CategoryDisplay, CategoryLive, Synchronize) VALUES ('" + dr["CategoryTypeID"].ToString() + "', '" + Utility.ReplaceSql(dr["CategoryTypeName"].ToString()) + "', '" + dr["CategoryTypePrice"].ToString() + "', '" + dr["CategoryTypeID"].ToString() + "', '" + dr["CategoryTypeLive"].ToString() + "', '" + dr["CategoryTypeLive"].ToString() + "', '0');"); } sb.AppendLine(""); } //备份专题表 DataTable zhuanTiTab = zt_bll.GetZhuanTiList(userId); if (zhuanTiTab.Rows.Count > 0) { sb.AppendLine("DELETE FROM ZhuanTiTable;"); foreach (DataRow dr in zhuanTiTab.Rows) { sb.AppendLine("INSERT INTO ZhuanTiTable (ZTID, ZhuanTiName, ZhuanTiImage, ZhuanTiLive, Synchronize) VALUES ('" + dr["ZTID"].ToString() + "', '" + Utility.ReplaceSql(dr["ZhuanTiName"].ToString()) + "', '" + dr["ZhuanTiImage"].ToString() + "', '" + dr["ZhuanTiLive"].ToString() + "', '0');"); } sb.AppendLine(""); } //备份转账表 DataTable zhangTab = zz_bll.GetZhuanZhangList(userId); if (zhangTab.Rows.Count > 0) { sb.AppendLine("DELETE FROM ZhuanZhangTable;"); foreach (DataRow dr in zhangTab.Rows) { sb.AppendLine("INSERT INTO ZhuanZhangTable (ZZID, ZhangFrom, ZhangTo, ZhangMoney, ZhangDate, ZhangNote, ZhangLive, Synchronize) VALUES ('" + dr["ZZID"].ToString() + "', '" + dr["ZhuanZhangFrom"].ToString() + "', '" + dr["ZhuanZhangTo"].ToString() + "', '" + dr["ZhuanZhangMoney"].ToString() + "', '" + String.Format("{0:yyyy-MM-dd}", dr["ZhuanZhangDate"]) + "', '" + Utility.ReplaceSql(dr["ZhuanZhangNote"].ToString()) + "', '" + dr["ZhuanZhangLive"].ToString() + "', '0');"); } sb.AppendLine(""); } //备份钱包表 DataTable cardTab = card_bll.GetCardList(userId); if (cardTab.Rows.Count > 0) { sb.AppendLine("DELETE FROM CardTable;"); foreach (DataRow dr in cardTab.Rows) { if (dr["CardID"].ToString() == "0") { continue; } string cardMoney = dr["CardMoney"].ToString(); if (user.IsUpdate == 1) { cardMoney = dr["MoneyStart"].ToString(); } sb.AppendLine("INSERT INTO CardTable (CDID, CardName, CardMoney, CardLive, Synchronize) VALUES ('" + dr["CDID"].ToString() + "', '" + Utility.ReplaceSql(dr["CardName"].ToString()) + "', '" + cardMoney + "', '" + dr["CardLive"].ToString() + "', '0');"); } } string pathFileName = GetFilePathName(fileName); BackupHelper.WriteBackupFile(pathFileName, sb.ToString()); bll.UpdateItemListWebBackByUserId(userId); cat_bll.UpdateCategoryListWebBack(userId); zt_bll.UpdateZhuanTiListWebBack(userId); card_bll.UpdateCardListWebBack(userId); DownBackFile(pathFileName, fileName); }