public static void OutputExcel(System.Web.HttpServerUtility server, System.Web.HttpResponse response, string filename, MemoryStream ms)
{
byte[] bytes = ms.GetBuffer();
response.Charset = "UTF8";
response.ContentEncoding = Encoding.UTF8;
response.AddHeader("Content-Disposition",
"attachment; filename=" + server.UrlEncode(filename + ".xls"));
response.ContentType = "application/vnd.ms-excel";
response.BinaryWrite(bytes);
response.End();
}
public static void OutputExcel(System.Web.HttpServerUtility server, System.Web.HttpResponse response, string filename)
{
string path = server.MapPath(filename + ".xls");
FileInfo file = new FileInfo(path);
response.Clear();
response.Charset = "GB2312";
response.ContentEncoding = Encoding.UTF8;
response.AddHeader("Content-Disposition", "attachment; filename=" + server.UrlEncode(file.Name));
response.AddHeader("Content-Length", file.Length.ToString());
response.ContentType = "application/ms-excel";
response.WriteFile(file.FullName);
response.End();
}
public override string UrlEncode(string s)
{
return(w.UrlEncode(s));
}
/// <summary>
/// 搜索店铺
/// </summary>
/// <returns></returns>
public void SearchShops()
{
string page_url = "action=list";
StringBuilder strHTML = new StringBuilder();
QueryInfo Query = new QueryInfo();
Query.PageSize = 6;
Query.CurrentPage = tools.CheckInt(Request["page"]);
if (Query.CurrentPage <= 0)
{
Query.CurrentPage = 1;
}
Query.ParamInfos.Add(new ParamInfo("AND", "str", "SupplierShopInfo.Shop_Site", "=", pub.GetCurrentSite()));
Query.ParamInfos.Add(new ParamInfo("AND", "int", "SupplierShopInfo.Shop_Status", "=", "1"));
string keyword = tools.CheckStr(Request["keyword"]);
if (keyword.Length > 0)
{
Query.ParamInfos.Add(new ParamInfo("AND", "str", "SupplierShopInfo.Shop_Name", "like", keyword));
page_url += "&keyword=" + Server.UrlEncode(keyword);
}
Query.OrderInfos.Add(new OrderInfo("SupplierShopInfo.Shop_ID", "ASC"));
PageInfo pageinfo = myshop.GetPageInfo(Query);
IList <SupplierShopInfo> entitys;
strHTML.Append("<h2 class=\"title10\">共找到<strong>" + pageinfo.RecordCount + "</strong>条信息</h2>");
if (pageinfo.RecordCount >= 1)
{
string targetURL = string.Empty;
SupplierInfo supplierInfo;
entitys = myshop.GetSupplierShops(Query);
if (entitys != null)
{
foreach (SupplierShopInfo entity in entitys)
{
#region 循环体
supplierInfo = supplier.GetSupplierByID(entity.Shop_SupplierID);
if (supplierInfo == null)
{
supplierInfo = new SupplierInfo();
}
targetURL = supplier.GetShopURL(entity.Shop_Domain);
strHTML.Append("<div class=\"blk61\">");
strHTML.Append(" <div class=\"b61_left\">");
strHTML.Append(" <h2><a href=\""+ targetURL + "\" target=\"_blank\">" + entity.Shop_Name + "</a><span onclick=\"NTKF.im_openInPageChat('sz_" + (entity.Shop_SupplierID + 1000) + "_9999');\"><img style=\"display:inline-block; vertical-align:middle; margin-left:15px;width:74px;margin-right:10px;\" src=\"/images/icon04.png\"></span><span><a href=\"javascript:void(0);\">推广</a></span></h2>");
strHTML.Append(" <div class=\"b61_left_main\">");
strHTML.Append(" <ul>");
strHTML.Append(" <li><span>主营产品：</span>"+ entity.Shop_MainProduct + "</li>");
strHTML.Append(" <li><span>经营年限：</span>"+ supplierInfo.Supplier_OperateYear + "</li>");
strHTML.Append(" <li><span>所在地：</span>"+ addr.DisplayAddress(supplierInfo.Supplier_State, supplierInfo.Supplier_City, supplierInfo.Supplier_County) + "</li>");
strHTML.Append(" <li><span>注册资金：</span>"+ (supplierInfo.Supplier_RegisterFunds == 0 ? "无需验证" : supplierInfo.Supplier_RegisterFunds + "万") + "</li>");
strHTML.Append(" </ul>");
strHTML.Append(" <div class=\"clear\"></div>");
strHTML.Append("<p>");
IList <SupplierCertInfo> certs = supplier.GetSupplierCertByType(0);
if (certs != null)
{
int icert = 0;
foreach (SupplierCertInfo cert in certs)
{
if (supplier.Get_Supplier_Cert(cert.Supplier_Cert_ID, supplierInfo.SupplierRelateCertInfos).Length > 0)
{
icert++;
if (icert >= 2)
{
strHTML.Append(" > ");
}
strHTML.Append(cert.Supplier_Cert_Name);
}
}
}
strHTML.Append("</p>");
strHTML.Append(" </div>");
strHTML.Append(" </div>");
strHTML.Append(" <div class=\"b61_right\">");
strHTML.Append(" <h2><a href=\""+ targetURL + "\" target=\"_blank\">进入本店铺 ></a></h2>");
strHTML.Append(" <div class=\"b61_right_main\">");
strHTML.Append(" <ul>");
strHTML.Append(ShopProducts(entity.Shop_SupplierID));
strHTML.Append(" </ul>");
strHTML.Append(" <div class=\"clear\"></div>");
strHTML.Append(" </div>");
strHTML.Append(" </div>");
strHTML.Append(" <div class=\"clear\"></div>");
strHTML.Append(" <em><img src=\"/images/div_bg.jpg\"></em>");
strHTML.Append("</div>");
#endregion
}
}
}
Response.Write(strHTML.ToString());
page_url = Request.Path + "?" + page_url.TrimStart('&');
pub.Page(pageinfo.PageCount, pageinfo.CurrentPage, page_url, pageinfo.PageSize, pageinfo.RecordCount);
}
//会员登录
public void Member_Login()
{
int chk_UserName = tools.CheckInt(Request["chk_UserName"]);
Response.Cookies["BoHaiUserName"].Expires = DateTime.Now.AddYears(1);
string Member_Username = tools.CheckStr(tools.NullStr(Request["member_name"]).Trim());
string Member_Password = Request["member_password"];
Member_Password = encrypt.MD5(Member_Password);
if (tools.NullStr(Session["logintype"]) == "False")
{
string Trade_Verify = tools.CheckStr(Request["Trade_Verify"]);
if (Trade_Verify != tools.NullStr(Session["Trade_Verify"]))
{
Session["logintype"] = "False";
if (chk_UserName == 1)
{
Response.Cookies["BoHaiUserName"].Value = Server.UrlEncode(Member_Username);
}
else
{
Response.Cookies["BoHaiUserName"].Value = "";
}
//Response.Redirect("/member/login.aspx?login=vmsg");
Response.Write("验证码错误");
Response.End();
}
}
if (Member_Username == "")
{
Session["logintype"] = "False";
//Response.Redirect("/member/login.aspx?login=umsg_k");
Response.Write("请输入您的用户名");
Response.End();
}
MemberInfo memberinfo = MyMember.GetMemberByNickName(Member_Username, pub.CreateUserPrivilege("833b9bdd-a344-407b-b23a-671348d57f76"));
if (memberinfo != null)
{
if (memberinfo.Member_Password != Member_Password)
{
Session["logintype"] = "False";
if (chk_UserName == 1)
{
Response.Cookies["BoHaiUserName"].Value = Server.UrlEncode(Member_Username);
}
else
{
Response.Cookies["BoHaiUserName"].Value = "";
}
//Response.Redirect("/member/login.aspx?login=pmsg");
Response.Write("密码错误");
Response.End();
}
Response.Write("成功");
Session["member_id"] = memberinfo.Member_ID;
Session["member_email"] = memberinfo.Member_Email;
Session["member_nickname"] = memberinfo.Member_NickName;
Session["member_logined"] = "True";
Session["member_logincount"] = memberinfo.Member_LoginCount + 1;
Session["member_lastlogin_time"] = memberinfo.Member_LastLogin_Time;
Session["member_lastlogin_ip"] = memberinfo.Member_LastLogin_IP;
Session["member_coinremain"] = memberinfo.Member_CoinRemain;
Session["member_coincount"] = memberinfo.Member_CoinCount;
Session["member_grade"] = memberinfo.Member_Grade;
Session["Member_AllowSysEmail"] = memberinfo.Member_AllowSysEmail;
//Session["Member_Type"] = memberinfo.U_Member_Type;
//if (chk_UserName == 1) { Response.Cookies["BoHaiUserName"].Value = Server.UrlEncode(memberinfo.Member_NickName); }
//else { Response.Cookies["BoHaiUserName"].Value = ""; }
//更新购物车价格
Cart_Price_Update();
//更新用户登录信息
MyMember.UpdateMemberLogin(memberinfo.Member_ID, memberinfo.Member_LoginCount + 1, Request.ServerVariables["Remote_Addr"], pub.CreateUserPrivilege("833b9bdd-a344-407b-b23a-671348d57f76"));
//更新会员等级
Update_MemberGrade();
Member_Log(memberinfo.Member_ID, "会员登录");
//判断是否经过了邮件验证
//if(memberinfo.Member_Emailverify==0)
//{
Session["member_emailverify"] = memberinfo.Member_Emailverify;
// //Response.Redirect("/member/emailverify.aspx");
// Response.Write("/member/emailverify.aspx");
//}
//else
//{
if (Session["url_after_login"] == null)
{
Session["url_after_login"] = "";
}
if (tools.NullStr(Session["url_after_login"].ToString()) != "")
{
//Response.Redirect(Session["url_after_login"].ToString());
Response.Write(Session["url_after_login"].ToString());
}
else
{
//Response.Redirect("/member/index.aspx");
Response.Write("/member/index.aspx");
}
//}
}
else
{
Session["logintype"] = "False";
if (chk_UserName == 1)
{
Response.Cookies["BoHaiUserName"].Value = Server.UrlEncode(Member_Username);
}
else
{
Response.Cookies["BoHaiUserName"].Value = "";
}
//Response.Redirect("/member/login.aspx?login=umsg_w");
Response.Write("账号未注册");
Response.End();
}
}
/// <summary>
/// See <see cref="HttpServerUtility"/> for a description.
/// </summary>
public string UrlEncode(string s)
{
return(_httpServerUtility.UrlEncode(s));
}
/// <summary>
/// Take a comma-separated length of text and create links from it
/// </summary>
/// <param name="server">An <see cref="HttpServerUtility"/> for context information</param>
/// <param name="stringCsvList">The comma-separated list of strings</param>
/// <param name="urlFormat">a string.Format where {0} will be replaced with the search
/// terms</param>
/// <returns>A string containing search links to each of the comma-separated search values
/// </returns>
private string CreateSearchLinks(HttpServerUtility server,
string stringCsvList,
string urlFormat)
{
string[] items;
if (stringCsvList.Contains(','))
{
items = stringCsvList.Split(',');
}
else
{
items = new string[1] { stringCsvList };
}
StringBuilder stringWithLinks = null;
foreach (string stringItem in items)
{
string link = string.Format(urlFormat, server.UrlEncode(stringItem.Trim()));
if (stringWithLinks != null)
{
stringWithLinks.Append(", ");
}
else
{
stringWithLinks = new StringBuilder();
}
stringWithLinks.AppendFormat("<a href=\"{0}\" target=\"_blank\">{1} <small><span class=\"glyphicon glyphicon-new-window\"></span></small></a>",
VirtualPathUtility.ToAbsolute(link),
stringItem.Trim());
}
return stringWithLinks.ToString();
}