你好，我需要激活正式版本，需要多少费用呢！客服能帮忙解决吗？

工作流缺文件啊

大部分控件都封装了，没有源码。

收信人收不到内网邮箱的附件，如何解决 ？

系统左边的导航栏位置在哪？如何处理的？51帮忙！！！

求完整的需求文档和完整流程图！！！

怎么流程部分好像却不少东西啊，有完整的吗

测试页面时，提示：在System.Data.SqlClient.SqlException中第一次偶然出现的“System.Data.dll”类型的异常 参考网上也没有解决，请教高手。

本人发帖求教过，也得到论坛中两位高手指点，按照提供的解决问题的途径去做了（http://bbs.51aspx.com/showtopic-16431.html），并且尝试了许多办法（网上查到的），但问题依然未能得到解决，很是郁闷。aspx.com论坛里藏龙卧虎，高手云集，偶不过是个刚踏入这个门坎的小生，所学到的微乎其微。真诚渴望能得到各位高手倾力指教，谢谢。现将代码贴上： 当我点击“添加”按钮时没有反应，问题出在何处？望能尽量说得详细些 数据访问类代码： using System; using System.Data; using System.Data.Common; using System.Text; using System.Collections; using System.Collections.Generic; namespace SqlServerDAL { /// <summary> /// 数据访问类 Assets /// </summary> public class Assets : DALHelper { /// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Assets model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO Assets("); strSql.Append("ZCMC)"); strSql.Append(" VALUES ("); strSql.Append("@in_ZCMC)"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ZCMC", DbType.AnsiString, model.ZCMC)}; return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms); } /// <summary> /// 更新一条数据 /// </summary> public int Update(Model.Assets model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE Assets SET "); strSql.Append("ZCMC=@in_ZCMC,"); strSql.Append(" WHERE ID=@in_ID"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ZCMC", DbType.AnsiString, model.ZCMC), DataBaseOAHelper.CreateInDbParameter("@in_ID", DbType.Int32, model.ID)}; return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms); } /// <summary> /// 删除一条数据 /// </summary> public int Delete(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("DELETE FROM Assets "); strSql.Append(" WHERE ID=@in_ID"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ID", DbType.Int32, ID)}; return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms); } /// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { object obj = DataBaseOAHelper.ExecuteScalar(CommandType.Text, "SELECT MAX(ID) FROM Assets", null); return DataBaseOAHelper.GetInt(obj); } /// <summary> /// 是否存在该记录 /// </summary> public bool Exists(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT COUNT(1) FROM Assets"); strSql.Append(" WHERE ID=@in_ID"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ID", DbType.Int32, ID)}; object obj = DataBaseOAHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), cmdParms); return DataBaseOAHelper.GetInt(obj) > 0; } /// <summary> /// 得到一个对象实体 /// </summary> public Model.Assets GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM Assets "); strSql.Append(" WHERE ID=@in_ID"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ID", DbType.Int32, ID)}; Model.Assets model = null; using (DbDataReader dr = DataBaseOAHelper.ExecuteReader(CommandType.Text, strSql.ToString(), cmdParms)) { while (dr.Read()) { model = GetModel(dr); } return model; } } /// <summary> /// 获取泛型数据列表 /// </summary> public List<Model.Assets> GetList() { StringBuilder strSql = new StringBuilder("SELECT * FROM Assets"); using (DbDataReader dr = DataBaseOAHelper.ExecuteReader(CommandType.Text, strSql.ToString(), null)) { List<Model.Assets> lst = GetList(dr); return lst; } } /// <summary> /// 得到数据条数 /// </summary> public int GetCount(string condition) { return DataBaseOAHelper.GetCount("Assets", condition); } /// <summary> /// 分页获取泛型数据列表 /// </summary> public List<Model.Assets> GetPageList(int pageSize, int pageIndex, string fldSort, bool fldDir, string condition) { using (DbDataReader dr = DataBaseOAHelper.GetPageList("Assets", pageSize, pageIndex, fldSort, fldDir, condition)) { List<Model.Assets> lst = GetList(dr); return lst; } } #region -------- 私有方法，通常情况下无需修改 -------- /// <summary> /// 由一行数据得到一个实体 /// </summary> private Model.Assets GetModel(DbDataReader dr) { Model.Assets model = new Model.Assets(); model.ID = DataBaseOAHelper.GetInt(dr["ID"]); model.ZCMC = DataBaseOAHelper.GetString(dr["ZCMC"]); return model; } /// <summary> /// 由DbDataReader得到泛型数据列表 /// </summary> private List<Model.Assets> GetList(DbDataReader dr) { List<Model.Assets> lst = new List<Model.Assets>(); while (dr.Read()) { lst.Add(GetModel(dr)); } return lst; } #endregion } } 下面是实体类代码： using System; namespace Model { /// <summary> /// 实体类 Assets /// </summary> [Serializable] public class Assets { public Assets() { } /// <summary> /// 构造函数 Assets /// </summary> /// <param name="iD">ID</param> /// <param name="ZCMC">ZCMC</param> public Assets(int iD, string zCMC) { _iD = iD; _zCMC = zCMC; } #region Model private int _iD; private string _zCMC; /// <summary> /// ID /// </summary> public int ID { set { _iD = value; } get { return _iD; } } /// <summary> /// ZCMC /// </summary> public string ZCMC { set { _zCMC = value; } get { return _zCMC; } } #endregion Model } } 以下是业务逻辑类代码： using System; using System.Data; using System.Collections.Generic; using System.Text; using System.Web; using System.Web.Caching; namespace BLL { /// <summary> /// 业务逻辑类 Assets /// </summary> public class Assets { private readonly SqlServerDAL.Assets dal = new SqlServerDAL.Assets(); public Assets() { } /// <summary> /// 增加一条数据 /// </summary> public void Add(Model.Assets model) { if(model == null) throw new Exception("实体参数不能为空。"); //请在此处添加更多与业务逻辑有关的验证，例如： //if(string.IsNullOrEmpty(model.Name)) // throw new Exception("名称不能为空。"); //if (!Regex.IsMatch(style, @"^[\s\w\u4e00-\u9fa5]{1,20}$")) // throw new Exception("名称格式不正确。"); dal.Add(model); } /// <summary> /// 更新一条数据 /// </summary> public void Update(Model.Assets model) { if(model == null) throw new Exception("实体参数不能为空。"); //请在此处添加更多与业务逻辑有关的验证，例如： //if(string.IsNullOrEmpty(model.Name)) // throw new Exception("名称不能为空。"); //if (!Regex.IsMatch(style, @"^[\s\w\u4e00-\u9fa5]{1,20}$")) // throw new Exception("名称格式不正确。"); dal.Update(model); } /// <summary> /// 删除一条数据 /// </summary> public void Delete(int ID) { if (ID <= 0) throw new Exception("参数不正确。"); dal.Delete(ID); } /// <summary> /// 是否存在该记录 /// </summary> public bool Exists(int ID) { if (ID <= 0) throw new Exception("参数不正确。"); return dal.Exists(ID); } /// <summary> /// 得到一个对象实体 /// </summary> public Model.Assets GetModel(int ID) { if (ID <= 0) throw new Exception("参数不正确。"); return dal.GetModel(ID); } /// <summary> /// 获得泛型数据列表 /// </summary> public List<Model.Assets> GetList() { return dal.GetList(); } /// <summary> /// 取得数据行数,不建议直接使用此方法,请根据业务逻辑重写 /// </summary> public int GetCount(string condition) { return dal.GetCount(condition); } /// <summary> /// 分页获取泛型数据列表,不建议直接使用此方法,请根据业务逻辑重写 /// </summary> public List<Model.Assets> GetPageList(int pageSize, int pageIndex, string fldSort, bool fldDir, string condition) { if (pageSize <= 0) throw new Exception("每页数据条数必须大于0。"); if (pageIndex <= 0) throw new Exception("页索引必须大于0。"); if (string.IsNullOrEmpty(fldSort)) throw new Exception("排序字段不能为空。如果是默认排序，可以填写主键字段。"); return dal.GetPageList(pageSize, pageIndex, fldSort, fldDir, condition); } } } 以下是页面文件代码： <%@ Page Language="C#" AutoEventWireup="true" CodeFile="AssetsAdd.aspx.cs" Inherits="Assets_AssetsAdd" %> <!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 id="Head1" runat="server"> <title>无标题页</title> <link href="css/main.css" type="text/css" rel="stylesheet" /> <script language="JavaScript" src="js/calendar.js"></script> </head> <body> <form runat="server" id="fm1"> <br /> <table class="usertableborder" cellspacing="1" cellpadding="3" width="96%" style="text-align: center" border="0"> <tr> <th colspan="3" style="height: 25px"> 添加信息</th> </tr> <tr> <td class="usertablerow2" align="right" style="height: 32px;" colspan="2"> <table style="text-align: center" style="bgcolor000000" border="0" cellpadding="2" cellspacing="1" class="small" width="95%" id="TABLE1"> <tr> <td class="usertablerow2"> 姓名：</td> <td class="usertablerow2"> <aspextBox ID="KeyValue_ZCMC" runat="server" ToolTip="姓名" MaxLength="50"></aspextBox> </td> </tr> </table> </td> </tr> <tr> <td align="center" class="usertablerow1" colspan="2"> <asp:Button ID="Button1" runat="server" CssClass="ptsbutton" Text="添加" /></td> </tr> </table> </form> </body> </html> 后台代码如下： using System; using System.Data; using System.Configuration; using System.Collections.Generic; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class Assets_AssetsAdd : System.Web.UI.Page { //模板 Model.Assets MA = new Model.Assets(); //业务 BLL.Assets BA = new BLL.Assets(); protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { try { MA.ZCMC = KeyValue_ZCMC.Text; BA.Add(MA); MessageBox.Show("添加信息成功"); KeyValue_ZCMC.Text = ""; } catch (Exception exp) { MessageBox.Show(exp.Message); } } }

现在我把代码贴上来，望能得到高手的不吝指教。先谢谢了。 数据访问类代码： using System; using System.Data; using System.Data.Common; using System.Text; using System.Collections; using System.Collections.Generic; namespace SqlServerDAL { /// <summary> /// 数据访问类 Assets /// </summary> public class Assets : DALHelper { /// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Assets model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO Assets("); strSql.Append("ZCMC)"); strSql.Append(" VALUES ("); strSql.Append("@in_ZCMC)"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ZCMC", DbType.AnsiString, model.ZCMC)}; return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms); } /// <summary> /// 更新一条数据 /// </summary> public int Update(Model.Assets model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE Assets SET "); strSql.Append("ZCMC=@in_ZCMC,"); strSql.Append(" WHERE ID=@in_ID"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ZCMC", DbType.AnsiString, model.ZCMC), DataBaseOAHelper.CreateInDbParameter("@in_ID", DbType.Int32, model.ID)}; return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms); } /// <summary> /// 删除一条数据 /// </summary> public int Delete(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("DELETE FROM Assets "); strSql.Append(" WHERE ID=@in_ID"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ID", DbType.Int32, ID)}; return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms); } /// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { object obj = DataBaseOAHelper.ExecuteScalar(CommandType.Text, "SELECT MAX(ID) FROM Assets", null); return DataBaseOAHelper.GetInt(obj); } /// <summary> /// 是否存在该记录 /// </summary> public bool Exists(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT COUNT(1) FROM Assets"); strSql.Append(" WHERE ID=@in_ID"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ID", DbType.Int32, ID)}; object obj = DataBaseOAHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), cmdParms); return DataBaseOAHelper.GetInt(obj) > 0; } /// <summary> /// 得到一个对象实体 /// </summary> public Model.Assets GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM Assets "); strSql.Append(" WHERE ID=@in_ID"); DbParameter[] cmdParms = { DataBaseOAHelper.CreateInDbParameter("@in_ID", DbType.Int32, ID)}; Model.Assets model = null; using (DbDataReader dr = DataBaseOAHelper.ExecuteReader(CommandType.Text, strSql.ToString(), cmdParms)) { while (dr.Read()) { model = GetModel(dr); } return model; } } /// <summary> /// 获取泛型数据列表 /// </summary> public List<Model.Assets> GetList() { StringBuilder strSql = new StringBuilder("SELECT * FROM Assets"); using (DbDataReader dr = DataBaseOAHelper.ExecuteReader(CommandType.Text, strSql.ToString(), null)) { List<Model.Assets> lst = GetList(dr); return lst; } } /// <summary> /// 得到数据条数 /// </summary> public int GetCount(string condition) { return DataBaseOAHelper.GetCount("Assets", condition); } /// <summary> /// 分页获取泛型数据列表 /// </summary> public List<Model.Assets> GetPageList(int pageSize, int pageIndex, string fldSort, bool fldDir, string condition) { using (DbDataReader dr = DataBaseOAHelper.GetPageList("Assets", pageSize, pageIndex, fldSort, fldDir, condition)) { List<Model.Assets> lst = GetList(dr); return lst; } } #region -------- 私有方法，通常情况下无需修改 -------- /// <summary> /// 由一行数据得到一个实体 /// </summary> private Model.Assets GetModel(DbDataReader dr) { Model.Assets model = new Model.Assets(); model.ID = DataBaseOAHelper.GetInt(dr["ID"]); model.ZCMC = DataBaseOAHelper.GetString(dr["ZCMC"]); return model; } /// <summary> /// 由DbDataReader得到泛型数据列表 /// </summary> private List<Model.Assets> GetList(DbDataReader dr) { List<Model.Assets> lst = new List<Model.Assets>(); while (dr.Read()) { lst.Add(GetModel(dr)); } return lst; } #endregion } } 下面是实体类代码： using System; namespace Model { /// <summary> /// 实体类 Assets /// </summary> [Serializable] public class Assets { public Assets() { } /// <summary> /// 构造函数 Assets /// </summary> /// <param name="iD">ID</param> /// <param name="ZCMC">ZCMC</param> public Assets(int iD, string zCMC) { _iD = iD; _zCMC = zCMC; } #region Model private int _iD; private string _zCMC; /// <summary> /// ID /// </summary> public int ID { set { _iD = value; } get { return _iD; } } /// <summary> /// ZCMC /// </summary> public string ZCMC { set { _zCMC = value; } get { return _zCMC; } } #endregion Model } } 以下是业务逻辑类代码： using System; using System.Data; using System.Collections.Generic; using System.Text; using System.Web; using System.Web.Caching; namespace BLL { /// <summary> /// 业务逻辑类 Assets /// </summary> public class Assets { private readonly SqlServerDAL.Assets dal = new SqlServerDAL.Assets(); public Assets() { } /// <summary> /// 增加一条数据 /// </summary> public void Add(Model.Assets model) { if(model == null) throw new Exception("实体参数不能为空。"); //请在此处添加更多与业务逻辑有关的验证，例如： //if(string.IsNullOrEmpty(model.Name)) // throw new Exception("名称不能为空。"); //if (!Regex.IsMatch(style, @"^[\s\w\u4e00-\u9fa5]{1,20}$")) // throw new Exception("名称格式不正确。"); dal.Add(model); } /// <summary> /// 更新一条数据 /// </summary> public void Update(Model.Assets model) { if(model == null) throw new Exception("实体参数不能为空。"); //请在此处添加更多与业务逻辑有关的验证，例如： //if(string.IsNullOrEmpty(model.Name)) // throw new Exception("名称不能为空。"); //if (!Regex.IsMatch(style, @"^[\s\w\u4e00-\u9fa5]{1,20}$")) // throw new Exception("名称格式不正确。"); dal.Update(model); } /// <summary> /// 删除一条数据 /// </summary> public void Delete(int ID) { if (ID <= 0) throw new Exception("参数不正确。"); dal.Delete(ID); } /// <summary> /// 是否存在该记录 /// </summary> public bool Exists(int ID) { if (ID <= 0) throw new Exception("参数不正确。"); return dal.Exists(ID); } /// <summary> /// 得到一个对象实体 /// </summary> public Model.Assets GetModel(int ID) { if (ID <= 0) throw new Exception("参数不正确。"); return dal.GetModel(ID); } /// <summary> /// 获得泛型数据列表 /// </summary> public List<Model.Assets> GetList() { return dal.GetList(); } /// <summary> /// 取得数据行数,不建议直接使用此方法,请根据业务逻辑重写 /// </summary> public int GetCount(string condition) { return dal.GetCount(condition); } /// <summary> /// 分页获取泛型数据列表,不建议直接使用此方法,请根据业务逻辑重写 /// </summary> public List<Model.Assets> GetPageList(int pageSize, int pageIndex, string fldSort, bool fldDir, string condition) { if (pageSize <= 0) throw new Exception("每页数据条数必须大于0。"); if (pageIndex <= 0) throw new Exception("页索引必须大于0。"); if (string.IsNullOrEmpty(fldSort)) throw new Exception("排序字段不能为空。如果是默认排序，可以填写主键字段。"); return dal.GetPageList(pageSize, pageIndex, fldSort, fldDir, condition); } } } 以下是页面文件代码： <%@ Page Language="C#" AutoEventWireup="true" CodeFile="AssetsAdd.aspx.cs" Inherits="Assets_AssetsAdd" %> <!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 id="Head1" runat="server"> <title>无标题页</title> <link href="css/main.css" type="text/css" rel="stylesheet" /> <script language="JavaScript" src="js/calendar.js"></script> </head> <body> <form runat="server" id="fm1"> <br /> <table class="usertableborder" cellspacing="1" cellpadding="3" width="96%" style="text-align: center" border="0"> <tr> <th colspan="3" style="height: 25px"> 添加信息</th> </tr> <tr> <td class="usertablerow2" align="right" style="height: 32px;" colspan="2"> <table style="text-align: center" style="bgcolor:#000000" border="0" cellpadding="2" cellspacing="1" class="small" width="95%" id="TABLE1"> <tr> <td class="usertablerow2"> 姓名：</td> <td class="usertablerow2"> <asp:TextBox ID="KeyValue_ZCMC" runat="server" ToolTip="姓名" MaxLength="50"></asp:TextBox> </td> </tr> </table> </td> </tr> <tr> <td align="center" class="usertablerow1" colspan="2"> <asp:Button ID="Button1" runat="server" CssClass="ptsbutton" Text="添加" /></td> </tr> </table> </form> </body> </html> 后台代码如下： using System; using System.Data; using System.Configuration; using System.Collections.Generic; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class Assets_AssetsAdd : System.Web.UI.Page { //模板 Model.Assets MA = new Model.Assets(); //业务 BLL.Assets BA = new BLL.Assets(); protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { try { MA.ZCMC = KeyValue_ZCMC.Text; BA.Add(MA); MessageBox.Show("添加信息成功"); KeyValue_ZCMC.Text = ""; } catch (Exception exp) { MessageBox.Show(exp.Message); } } }