1
#region
ToVCF
2 protected void btn_outvcf_Click( object sender, EventArgs e)
3 {
4 string code = Request[ " hid_code " ].ToString().Trim( ' , ' );
5 StringBuilder sb = new StringBuilder();
6 if ( ! string .IsNullOrEmpty(code))
7 {
8 string sql = string .Format( @" select u_name,u_birthday,u_mobile,U_ZAnimal,u_tel,U_Constellation,u_blood,u_sex,u_email,
9 u_linkadd,u_remark,u_company,u_job,u_companyemail,u_companymobile,u_companytel,
10 u_companyfax,u_companyadd,u_postalcode from Mobile_CardInfo where m_id in({0}) " , code);
11 DataView dv = zhan.Data.Sql.PubClass.ExecuteDataView( "" , sql);
12 if (dv != null )
13 {
14
15 foreach (DataRow dr in dv.Table.Rows)
16 {
17 sb.Append(ExportVCF(dr));
18 }
19 }
20 Response.ContentEncoding = Encoding.Default; // GetEncoding("gb2312");
21 Response.ContentType = " text/x-vCard " ;
22 string rename = HttpUtility.UrlEncode( " 通讯录 " , Encoding.GetEncoding( " utf-8 " ));
23 Response.ClearHeaders();
24 Response.AppendHeader( " Content-disposition " , string .Format( " attachment;filename={0}.vcf " , rename));
25 Response.Write(sb.ToString());
26 Response.End();
27 }
28 }
29 public string ExportVCF(DataRow dr)
30 {
31 StringWriter stringWrite = new StringWriter();
32 stringWrite.WriteLine( " BEGIN:VCARD " );
33 stringWrite.WriteLine( " VERSION:2.1 " );
34 stringWrite.WriteLine( string .Format( " NAME:{0} " , dr[ " u_name " ])); // 姓名
35 stringWrite.WriteLine( string .Format( " N:;{0};; " , dr[ " u_name " ])); // 姓名
36 stringWrite.WriteLine( string .Format( " FN:{0} " , dr[ " u_name " ])); // 姓名
37 stringWrite.WriteLine( string .Format( " ADR;DOM;PARCEL;HOME:;;{0};;;; " , dr[ " u_linkadd " ])); // 家庭住址
38 stringWrite.WriteLine( string .Format( " ADR;INTL;PARCEL;WORK:;;{0};;;{1}; " , dr[ " u_companyadd " ], dr[ " u_postalcode " ])); // 公司地址 公司邮编
39 stringWrite.WriteLine( string .Format( " BDAY:{0} " , Convert.ToDateTime(dr[ " u_birthday " ].ToString()).ToString( " yyyy-MM-dd " ))); // 生日
40 stringWrite.WriteLine( string .Format( " EMAIL;INTERNET:{0} " , dr[ " u_companyemail " ])); // 商务邮箱
41 stringWrite.WriteLine( string .Format( " EMAIL;PRODIGY:{0} " , dr[ " u_email " ])); // 电子邮件
42 stringWrite.WriteLine( string .Format( " ORG:{0} " , dr[ " u_company " ])); // 公司名称
43 stringWrite.WriteLine( string .Format( " TEL;HOME;VOICE:{0} " , dr[ " u_tel " ])); // 常用固话
44 stringWrite.WriteLine( string .Format( " TEL;WORK;CELL:{0} " , dr[ " u_companymobile " ])); // 商务手机
45 stringWrite.WriteLine( string .Format( " TEL;WORK;VOICE:{0} " , dr[ " u_companytel " ])); // 公司固话
46 stringWrite.WriteLine( string .Format( " TEL;WORK;FAX:{0} " , dr[ " u_companyfax " ])); // 公司传真
47 stringWrite.WriteLine( string .Format( " TEL;PREF:{0} " , dr[ " u_mobile " ])); // 手机号码
48 stringWrite.WriteLine( string .Format( " TITLE:{0} " , dr[ " u_job " ])); // 职位
49 stringWrite.WriteLine( string .Format( " 性别:{0} " , dr[ " u_sex " ])); // 性别
50 stringWrite.WriteLine( string .Format( " 血型:{0} " , dr[ " u_blood " ])); // 血型
51 stringWrite.WriteLine( string .Format( " 生肖:{0} " , dr[ " U_ZAnimal " ])); // 生肖
52 stringWrite.WriteLine( string .Format( " 星座:{0} " , dr[ " U_Constellation " ])); // 星座
53 stringWrite.WriteLine( string .Format( " NOTE:{0} " , dr[ " u_remark " ])); // 备注
54 stringWrite.WriteLine( " END:VCARD " );
55 stringWrite.WriteLine( "" );
56 return stringWrite.ToString();
57 }
58 #endregion
2 protected void btn_outvcf_Click( object sender, EventArgs e)
3 {
4 string code = Request[ " hid_code " ].ToString().Trim( ' , ' );
5 StringBuilder sb = new StringBuilder();
6 if ( ! string .IsNullOrEmpty(code))
7 {
8 string sql = string .Format( @" select u_name,u_birthday,u_mobile,U_ZAnimal,u_tel,U_Constellation,u_blood,u_sex,u_email,
9 u_linkadd,u_remark,u_company,u_job,u_companyemail,u_companymobile,u_companytel,
10 u_companyfax,u_companyadd,u_postalcode from Mobile_CardInfo where m_id in({0}) " , code);
11 DataView dv = zhan.Data.Sql.PubClass.ExecuteDataView( "" , sql);
12 if (dv != null )
13 {
14
15 foreach (DataRow dr in dv.Table.Rows)
16 {
17 sb.Append(ExportVCF(dr));
18 }
19 }
20 Response.ContentEncoding = Encoding.Default; // GetEncoding("gb2312");
21 Response.ContentType = " text/x-vCard " ;
22 string rename = HttpUtility.UrlEncode( " 通讯录 " , Encoding.GetEncoding( " utf-8 " ));
23 Response.ClearHeaders();
24 Response.AppendHeader( " Content-disposition " , string .Format( " attachment;filename={0}.vcf " , rename));
25 Response.Write(sb.ToString());
26 Response.End();
27 }
28 }
29 public string ExportVCF(DataRow dr)
30 {
31 StringWriter stringWrite = new StringWriter();
32 stringWrite.WriteLine( " BEGIN:VCARD " );
33 stringWrite.WriteLine( " VERSION:2.1 " );
34 stringWrite.WriteLine( string .Format( " NAME:{0} " , dr[ " u_name " ])); // 姓名
35 stringWrite.WriteLine( string .Format( " N:;{0};; " , dr[ " u_name " ])); // 姓名
36 stringWrite.WriteLine( string .Format( " FN:{0} " , dr[ " u_name " ])); // 姓名
37 stringWrite.WriteLine( string .Format( " ADR;DOM;PARCEL;HOME:;;{0};;;; " , dr[ " u_linkadd " ])); // 家庭住址
38 stringWrite.WriteLine( string .Format( " ADR;INTL;PARCEL;WORK:;;{0};;;{1}; " , dr[ " u_companyadd " ], dr[ " u_postalcode " ])); // 公司地址 公司邮编
39 stringWrite.WriteLine( string .Format( " BDAY:{0} " , Convert.ToDateTime(dr[ " u_birthday " ].ToString()).ToString( " yyyy-MM-dd " ))); // 生日
40 stringWrite.WriteLine( string .Format( " EMAIL;INTERNET:{0} " , dr[ " u_companyemail " ])); // 商务邮箱
41 stringWrite.WriteLine( string .Format( " EMAIL;PRODIGY:{0} " , dr[ " u_email " ])); // 电子邮件
42 stringWrite.WriteLine( string .Format( " ORG:{0} " , dr[ " u_company " ])); // 公司名称
43 stringWrite.WriteLine( string .Format( " TEL;HOME;VOICE:{0} " , dr[ " u_tel " ])); // 常用固话
44 stringWrite.WriteLine( string .Format( " TEL;WORK;CELL:{0} " , dr[ " u_companymobile " ])); // 商务手机
45 stringWrite.WriteLine( string .Format( " TEL;WORK;VOICE:{0} " , dr[ " u_companytel " ])); // 公司固话
46 stringWrite.WriteLine( string .Format( " TEL;WORK;FAX:{0} " , dr[ " u_companyfax " ])); // 公司传真
47 stringWrite.WriteLine( string .Format( " TEL;PREF:{0} " , dr[ " u_mobile " ])); // 手机号码
48 stringWrite.WriteLine( string .Format( " TITLE:{0} " , dr[ " u_job " ])); // 职位
49 stringWrite.WriteLine( string .Format( " 性别:{0} " , dr[ " u_sex " ])); // 性别
50 stringWrite.WriteLine( string .Format( " 血型:{0} " , dr[ " u_blood " ])); // 血型
51 stringWrite.WriteLine( string .Format( " 生肖:{0} " , dr[ " U_ZAnimal " ])); // 生肖
52 stringWrite.WriteLine( string .Format( " 星座:{0} " , dr[ " U_Constellation " ])); // 星座
53 stringWrite.WriteLine( string .Format( " NOTE:{0} " , dr[ " u_remark " ])); // 备注
54 stringWrite.WriteLine( " END:VCARD " );
55 stringWrite.WriteLine( "" );
56 return stringWrite.ToString();
57 }
58 #endregion
本文转自94cool博客园博客,原文链接:http://www.cnblogs.com/94cool/archive/2010/12/23/1914783.html,如需转载请自行联系原作者