仿京东点滴收获

我们这周的项目是用asp.net做仿京东购物网，通过这两天做项目有了一下收货，下面就分享一下：

验证码生成,删除,插入,update,动态生成ul的函数：

usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
usingSystem.Drawing;
usingSystem.Drawing.Imaging;
usingSystem.Web.UI.HtmlControls;
usingSystem.IO;

///<summary>
///Class1的摘要说明
///</summary>
publicclassClass1
{
publicClass1()
{
//
//TODO:在此处添加构造函数逻辑
//
}

publicstaticreadonlystringcnnstring=ConfigurationManager.ConnectionStrings["con"].ConnectionString;

publicstaticobjectexecutenum(stringsqltext,paramsSqlParameter[]parass)
{
using(SqlConnectioncon=newSqlConnection(cnnstring))
{
using(SqlCommandcmd=newSqlCommand(sqltext,con))
{
con.Open();
Addcmd(parass,cmd);
returncmd.ExecuteNonQuery();

}
}

}//这时是执行增删改的操作

privatestaticvoidAddcmd(SqlParameter[]parass,SqlCommandcmd)
{
foreach(SqlParameteriteminparass)
{
cmd.Parameters.Add(item);
}
}//这里是添加命令的参数

publicstaticDataTableexecutetable(stringsqltext,paramsSqlParameter[]parass)
{
using(SqlConnectioncon=newSqlConnection(cnnstring))
{
using(SqlCommandcmd=newSqlCommand(sqltext,con))
{
con.Open();
Addcmd(parass,cmd);
using(SqlDataReadermyreader=cmd.ExecuteReader())
{
DataTabletable=newDataTable();
table.Clear();
table.Load(myreader);
returntable;
}

}
}