2.0.1npoi的dll文件下载：
NPOI2.0.1.zip
public static void test1()
{
NpoiHelper np = new NpoiHelper();
DataTable dt1 = np.ReadExcel(AppDomain.CurrentDomain.BaseDirectory + "1测试数据.xls", 2).Tables[0];//读2003格式数据
DataSet ds1 = new DataSet();
ds1.Tables.Add(dt1.Copy());
ds1.AcceptChanges();
string SaveFileName = "output1.xls";
np.CreateExcel2003(SaveFileName, "sheet001", ds1, 0);//写2003格式数据
using LitJson;
//可到 http://sourceforge.net/projects/litjson/?source=dlp 下载
protected void Page_Load(object sender, EventArgs e)
{
String str = "{'name':'j1','id':1,'items':[{'itemid':1001,'itemname':'it1'},{'itemid':1002,'itemname':'it2'}]}";
//*** 读取JSON字符串中的数据 *******************************
JsonData jd = JsonMapper.ToObject(str);
String name = (String)jd["name"];
int id = (int)(jd["id"]);
Response.Write(string.Format("name:{0},id:{1}<br/>",name,id));
JsonData jdItems = jd["items"];
}
public static string DataSetToJson(DataTable dt)
{
string json = string.Empty;
try
{
if (dt==null||dt.Rows.Count == 0)
{
return "";
}
json = "{";
json += "'table" + 1 + "':[";
for (int i = 0; i < dt.Rows.Count; i++)
#region 获取快递信息
string ApiKey = "XXXXXX";//请把XXXXXX修改成您在快递100网站申请的APIKey
//string powered = "快递数据由: <a href="http://www.kuaidi100.com/?refer=hishop&a=e8bc69faf6f1270b" target="_blank">快递100</a> 提供";
//技术文档地址：http://code.google.com/p/kuaidi-api/wiki/Open_API_API_URL
Dictionary<string, string> dict = new Dictionary<string, string>();
switch (typeCom)
{
case "AAE全球专递":
typeCom = "aae";
break;
case "安捷快递":
typeCom = "anjiekuaidi";
break;
<%:Html.DropDownList("AwardClassMainID","请选择")%>
<%:Html.DropDownList("SubID",new List<SelectListItem> { (new SelectListItem(){Text="请选择",Value="0"})})%>
//jquery代码
$("#AwardClassMainID").change(function () {
检查不能为空
[Required]
public string ID { get; set; }
检查最大长度
//模版页面.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title></title> </head> <body> <a href="#">链接1</a><br/> <a href="#" id="link2" runat="server">链接2</a><br/> <a href="#">链接3</a> </body> </html>
//Template类
大型企业网站不同于一般的网站（几个页面就行了），大型网站有大量的页面，权限控制等也很复杂，为了提高开发效率，代码能有效重用，还是得注意一下项目的结构问题，不然乱开发效率是很低的，还不利于维护。
搞了半天的结果。。
//system.web下
之前用过一段时间，已经证实不能再用！
#region 免费发送飞们接口(2014-01-06 16:20测试有效)
/// <summary>
/// 免费发送飞们接口（要开通飞信把对方加为好友才能发，也可以给自己发做测试）
/// </summary>
/// <param name="sendNumber">登陆飞信手机号</param>
/// <param name="sendPassword">登陆密码</param>
/// <param name="receiveNumber">接收手机</param>
/// <param name="Content">短信内容</param>
/// <returns></returns>
public bool sendfetion(string sendNumber, string sendPassword, string receiveNumber, string Content)
{
string url = string.Format("https://quanapi.sinaapp.com/fetion.php?u={0}&p={1}&to={2}&m={3}", sendNumber, sendPassword, receiveNumber, HttpUtility.UrlEncode(Content));
string strRet = "";
try
{
HttpWebRequest hr = (HttpWebRequest)WebRequest.Create(url);
hr.UserAgent = "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)";
hr.Method = "GET";
hr.Timeout = 30 * 60 * 1000;
WebResponse hs = hr.GetResponse();
Stream sr = hs.GetResponseStream();
StreamReader ser = new StreamReader(sr, Encoding.Default);
strRet = ser.ReadToEnd();
}
catch (Exception er)
{
strRet = "";
}
if (!strRet.Contains(":0")) return false;//成功时返回数据：{"result":0,"message":"u53d1u9001u6210u529f"}
return true;
}
#endregionPowered By Z-BlogPHP 1.7.3
Copyright 2024-2027 pukuimin Rights Reserved.
粤ICP备17100155号