基本信息
源码名称:C# NOPI导出EXCEL
源码大小:1.37M
文件格式:.zip
开发语言:C#
更新时间:2015-10-22
友情提示:(无需注册或充值,赞助后即可获取资源下载链接)
嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):78630559
本次赞助数额为: 2 元×
微信扫码支付:2 元
×
请留下您的邮箱,我们将在2小时内将文件发到您的邮箱
源码介绍
using System;
using System.Collections.Generic;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace Web.sitemanager.hongbao
{
public partial class User_Hongbao : Administrator.UI.ManagerBaseUIPage
{
//页面功能
private string txtEditTitle = "会员管理";
//导航路径
public string txtManageTitle = "会员信息管理 > 会员信息";
//传值
public static string txtLocal = "";
public static List<CMS.Model.UserHongbao> list = new List<CMS.Model.UserHongbao>();
public static List<CMS.Security.User> listuser = new List<CMS.Security.User>();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
RptBind();
}
}
//数据绑定
private void RptBind()
{
//初始值
ToolsPannel.Visible = true;
ListPanel.Visible = true;
contentTab.Visible = false;
string SQLStr = "";
if (DropDownList1.SelectedValue != "")
SQLStr = " AND Type = " DropDownList1.SelectedValue;
list = CMS.BLL.UserHongbao.Search(0, SQLStr, "");
listuser_inf();
this.rptList.DataSource = list;
this.rptList.DataBind();
decimal summoney = 0;
for (int i = 0; i < list.Count; i )
{
summoney = list[i].MoneyAmount;
}
lbltext.Text = Math.Round(summoney, 2).ToString();
if (DropDownList1.SelectedValue == "")
{
Label2.Text = "";
}
else if (DropDownList1.SelectedValue == "1")
{
Label2.Text = "考试满分";
}
else if (DropDownList1.SelectedValue == "2")
{
Label2.Text = "关注有礼";
}
}
/// <summary>
/// 获取答题用户列表
/// </summary>
private void listuser_inf()
{
string list_userid = "";
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i )
{
list_userid = list[i].UserId ",";
}
listuser = CMS.Security.User.get(" and UserId in (" list_userid.TrimEnd(',') ")");
}
}
/// <summary>
/// 根据用户ID获取用户姓名
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public string getusername(int userid)
{
string result = "";
foreach (CMS.Security.User item in listuser)
{
if (item.UserId == userid)
{
result = item.Name;
break;
}
}
return result;
}
/// <summary>
/// 调出添加、编辑界面
/// </summary>
/// <param name="hidValue"></param>
public void GetAddEditPanel(int hideValue)
{
//控制界面
ObjectId.Value = hideValue.ToString();
ToolsPannel.Visible = false;
ListPanel.Visible = false;
contentTab.Visible = true;
if (hideValue == 0)
{
EditTitle.Text = txtEditTitle "新增";
//txtpassword.CssClass = "txtInput normal required";
}
else
{
EditTitle.Text = txtEditTitle "编辑";
//txtpassword.CssClass = "txtInput normal";
CMS.Security.User user = CMS.Security.User.GetUserByUserID(hideValue);
txtname.Text = user.Name;
txtTel.Text = user.Telephone;
}
}
//提交按钮
public void btnSubmit_Click(object sender, EventArgs e)
{
int intObjectId = Convert.ToInt32(ObjectId.Value);
if (intObjectId > 0)
{
CMS.Security.User editinfo = CMS.Security.User.GetUserByUserID(intObjectId);
editinfo.Name = txtname.Text;
editinfo.Telephone = txtTel.Text;
editinfo.Update();
JscriptMsg("修改成功啦!", "UserList.aspx", "Success");
}
else
{
CMS.Security.User addinfo = CMS.Security.User.GetUserByTelephone(txtTel.Text.Trim());
if (addinfo != null)
{
JscriptMsg("该手机号已经注册!", "", "Warning");
}
else
{
addinfo.Name = txtname.Text.Trim();
addinfo.Telephone = txtTel.Text.Trim();
addinfo.Joined = DateTime.Now;
addinfo.Create();
JscriptMsg("创建成功啦!", "UserList.aspx", "Success");
JscriptMsg("确认密码不正确!", "", "Warning");
}
}
}
//分页
protected void Repeater1_PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
{
rptList.CurrentPageIndex = e.NewPageIndex;
RptBind();
}
//绑定操作按钮
protected void Repeater1_ItemCommand(object sender, RepeaterCommandEventArgs e)
{
if (e.CommandName == "edit")
{
GetAddEditPanel(Convert.ToInt32(e.CommandArgument));
}
}
//新增
protected void btnAdd_Click(object sender, EventArgs e)
{
GetAddEditPanel(0);
}
//保存排序
protected void btnSave_Click(object sender, EventArgs e)
{
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
for (int i = 0; i < rptList.Items.Count; i )
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
CMS.Security.User delinfo = CMS.Security.User.GetUserByUserID(id);
delinfo.Delete();
}
}
JscriptMsg("批量删除成功啦!", "UserList.aspx", "Success");
}
public string GetOrderNumber(string v_mid)
{
string v_oid;
DateTime dt = DateTime.Now;
string v_ymd = dt.ToString("yyyyMMdd", DateTimeFormatInfo.InvariantInfo); // yyyyMMdd
string timeStr = dt.ToString("HHmmss", DateTimeFormatInfo.InvariantInfo); // HHmmss
v_oid = "SH" v_ymd v_mid timeStr;
return v_oid;
}
protected void GroupDropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
RptBind();
}
public void outExcel_Click(object sender, EventArgs e)
{
//string SQLStr = "";
//if (DropDownList1.SelectedValue != "")
// SQLStr = " AND Type = " DropDownList1.SelectedValue;
//list = CMS.BLL.UserHongbao.Search(0, SQLStr, "");
//listuser_inf();
string name = "/uploads/" DateTime.Now.ToString("yyyy-MM-dd") DateTime.Now.Millisecond ".csv";
FileStream fs = new FileStream(Server.MapPath(name), FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("gb2312"));
sw.WriteLine("姓名,红包类型,红包金额,创建时间");
foreach (CMS.Model.UserHongbao item in list)
{
sw.WriteLine(getusername(item.UserId) "," (item.Type == 1 ? "满分试卷" : "关注有礼") "," Math.Round(Convert.ToDecimal(item.MoneyAmount), 2) "," item.CreateTime.ToString());
}
sw.Close();
HttpContext.Current.Response.Redirect(name);
}
}
}