当前文件： myCRM/App_Code/BasicSet.cs[11K，2009-6-12 11:48:08]，打开代码结构图

		            
  1using System;
  2using System.Data;
  3using System.Text;
  4using System.Configuration;
  5using System.Data.SqlClient;
  6/**//// <summary>
  7/// 基础配置类
  8/// </summary>
  9//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
 10
 11public class BasicSet
 12...{
 13    //将参数名和T-SQL语句设置成常量，方便以后维护。
 14    private const string PARM_AREA_NAME = "@areaname";
 15    private const string SQL_INSERT_AREA = "INSERT INTO area VALUES(@areaname)";
 16
 17    private const string PARM_AREA_ID = "@areaid";
 18    private const string PARM_CITY_NAME = "@cityname";
 19    private const string SQL_INSERT_CITY = "INSERT INTO city VALUES(@areaid,@cityname)";
 20    private const string SQL_SELECT_AREAID = "SELECT areaid FROM area WHERE areaname=@areaname";
 21
 22    private const string PARM_STATE_NAME = "@statename";
 23    private const string SQL_INSERT_STATE = "INSERT INTO userstate VALUES(@statename)";
 24
 25    private const string PARM_GRADE_NAME = "@gradename";
 26    private const string SQL_INSERT_GRADE = "INSERT INTO usergrade VALUES(@gradename)";
 27
 28    private const string PARM_TYPE_NAME = "@typename";
 29    private const string SQL_INSERT_TYPE = "INSERT INTO usertype VALUES(@typename)";
 30    private const string PARM_DEPART_NAME = "@departname";
 31    private const string SQL_INSERT_DEPART = "INSERT INTO department VALUES(@departname)";
 32
 33
 34
 35    public BasicSet()
 36    ...{
 37    }
 38    /**//// <summary>
 39    /// 添加区域方法
 40    /// </summary>
 41    /// <param name="areaname">区域名称</param>
 42    /// <returns>是否成功</returns>
 43    public bool AddArea(string areaname)
 44    ...{
 45        //初始化输入参数并赋值
 46        SqlParameter parm = new SqlParameter(PARM_AREA_NAME, SqlDbType.NVarChar, 20);
 47        parm.Value = areaname;
 48        //将参数添加到SQL命令中
 49        SqlCommand cmd = new SqlCommand();
 50        cmd.Parameters.Add(parm);
 51        //初始化字符串连接
 52        StringBuilder strSQL = new StringBuilder();
 53        //初始化数据库连接
 54        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
 55        ...{
 56            //添加连接语句
 57            strSQL.Append(SQL_INSERT_AREA);
 58            //打开数据库连接
 59            conn.Open();
 60            //设置Sqlcommand命令的属性
 61            cmd.Connection = conn;
 62            cmd.CommandType = CommandType.Text;
 63            cmd.CommandText = strSQL.ToString();
 64            //执行添加的SqlCommand命令
 65            int val = cmd.ExecuteNonQuery();
 66            //清空SqlCommand命令中的参数
 67            cmd.Parameters.Clear();
 68            //判断是否添加成功，注意返回的是添加是否成功，不是影响的行数
 69            if (val > 0)
 70                return true;
 71            else
 72                return false;
 73        }
 74    }
 75    /**//// <summary>
 76    /// 为区域添加城市的方法
 77    /// </summary>
 78    /// <param name="areaname">区域名称</param>
 79    /// <param name="cityname">城市名称</param>
 80    /// <returns>是否添加成功</returns>
 81    public bool AddCity(string areaname,string cityname)
 82    ...{ 
 83
 84        //因为城市表中存放的是区域的ID，所以要先获取区域ID。
 85        int areaid = GetAreaID(areaname);
 86        //初始化输入参数并赋值
 87        SqlParameter [] parm = new SqlParameter[]...{new SqlParameter(PARM_AREA_ID, SqlDbType.Int),new SqlParameter(PARM_CITY_NAME, SqlDbType.NVarChar,20)};
 88        parm[0].Value = areaid;
 89        parm[1].Value = cityname;
 90        //将参数添加到SQL命令中
 91        SqlCommand cmd = new SqlCommand();
 92        //遍历所有参数，并将参数添加到SqlCommand命令中
 93        foreach (SqlParameter parm1 in parm)
 94            cmd.Parameters.Add(parm1);
 95
 96        //初始化字符串连接
 97        StringBuilder strSQL = new StringBuilder();
 98        //初始化数据库连接
 99        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
100        ...{
101            //添加连接语句
102            strSQL.Append(SQL_INSERT_CITY);
103            //打开数据库连接
104            conn.Open();
105            //设置Sqlcommand命令的属性
106            cmd.Connection = conn;
107            cmd.CommandType = CommandType.Text;
108            cmd.CommandText = strSQL.ToString();
109            //执行添加的SqlCommand命令
110            int val = cmd.ExecuteNonQuery();
111            //清空SqlCommand命令中的参数
112            cmd.Parameters.Clear();
113            //判断是否添加成功，注意返回的是添加是否成功，不是影响的行数
114            if (val > 0)
115                return true;
116            else
117                return false;
118        }
119
120
121    }
122    /**//// <summary>
123    /// 根据区域名称获取ID的内部方法
124    /// </summary>
125    /// <param name="areaname">区域名称</param>
126    /// <returns>返回区域ID</returns>
127    private int GetAreaID(string areaname)
128    ...{
129        //初始化输入参数并赋值
130        SqlParameter parm = new SqlParameter(PARM_AREA_NAME, SqlDbType.NVarChar, 20);
131        parm.Value = areaname;
132
133        //调用SqlHelper访问组件的方法返回第一行第一列的值
134        string tmpstr = SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_AREAID, parm).ToString();
135        //将返回值进行类型转换
136        int areaid = int.Parse(tmpstr);
137        //返回区域ID。
138        return areaid;
139    }
140    /**//// <summary>
141    /// 添加客户等级方法
142    /// </summary>
143    /// <param name="areaname">等级名称</param>
144    /// <returns>是否成功</returns>
145    public bool AddGrade(string gradename)
146    ...{
147        //初始化输入参数并赋值
148        SqlParameter parm = new SqlParameter(PARM_GRADE_NAME, SqlDbType.NVarChar, 20);
149        parm.Value = gradename;
150        //将参数添加到SQL命令中
151        SqlCommand cmd = new SqlCommand();
152        cmd.Parameters.Add(parm);
153        //初始化字符串连接
154        StringBuilder strSQL = new StringBuilder();
155        //初始化数据库连接
156        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
157        ...{
158            //添加连接语句
159            strSQL.Append(SQL_INSERT_GRADE);
160            //打开数据库连接
161            conn.Open();
162            //设置Sqlcommand命令的属性
163            cmd.Connection = conn;
164            cmd.CommandType = CommandType.Text;
165            cmd.CommandText = strSQL.ToString();
166            //执行添加的SqlCommand命令
167            int val = cmd.ExecuteNonQuery();
168            //清空SqlCommand命令中的参数
169            cmd.Parameters.Clear();
170            //判断是否添加成功，注意返回的是添加是否成功，不是影响的行数
171            if (val > 0)
172                return true;
173            else
174                return false;
175        }
176    }
177    /**//// <summary>
178    /// 添加客户状态方法
179    /// </summary>
180    /// <param name="areaname">状态名称</param>
181    /// <returns>是否成功</returns>
182    public bool AddState(string statename)
183    ...{
184        //初始化输入参数并赋值
185        SqlParameter parm = new SqlParameter(PARM_STATE_NAME, SqlDbType.NVarChar, 20);
186        parm.Value = statename;
187        //将参数添加到SQL命令中
188        SqlCommand cmd = new SqlCommand();
189        cmd.Parameters.Add(parm);
190        //初始化字符串连接
191        StringBuilder strSQL = new StringBuilder();
192        //初始化数据库连接
193        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
194        ...{
195            //添加连接语句
196            strSQL.Append(SQL_INSERT_STATE);
197            //打开数据库连接
198            conn.Open();
199            //设置Sqlcommand命令的属性
200            cmd.Connection = conn;
201            cmd.CommandType = CommandType.Text;
202            cmd.CommandText = strSQL.ToString();
203            //执行添加的SqlCommand命令
204            int val = cmd.ExecuteNonQuery();
205            //清空SqlCommand命令中的参数
206            cmd.Parameters.Clear();
207            //判断是否添加成功，注意返回的是添加是否成功，不是影响的行数
208            if (val > 0)
209                return true;
210            else
211                return false;
212        }
213    }
214    /**//// <summary>
215    /// 添加客户类型方法
216    /// </summary>
217    /// <param name="areaname">类型名称</param>
218    /// <returns>是否成功</returns>
219    public bool AddType(string typename)
220    ...{
221        //初始化输入参数并赋值
222        SqlParameter parm = new SqlParameter(PARM_TYPE_NAME, SqlDbType.NVarChar, 20);
223        parm.Value = typename;
224        //将参数添加到SQL命令中
225        SqlCommand cmd = new SqlCommand();
226        cmd.Parameters.Add(parm);
227        //初始化字符串连接
228        StringBuilder strSQL = new StringBuilder();
229        //初始化数据库连接
230        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
231        ...{
232            //添加连接语句
233            strSQL.Append(SQL_INSERT_TYPE);
234            //打开数据库连接
235            conn.Open();
236            //设置Sqlcommand命令的属性
237            cmd.Connection = conn;
238            cmd.CommandType = CommandType.Text;
239            cmd.CommandText = strSQL.ToString();
240            //执行添加的SqlCommand命令
241            int val = cmd.ExecuteNonQuery();
242            //清空SqlCommand命令中的参数
243            cmd.Parameters.Clear();
244            //判断是否添加成功，注意返回的是添加是否成功，不是影响的行数
245            if (val > 0)
246                return true;
247            else
248                return false;
249        }
250    }
251    /**//// <summary>
252    /// 添加部门方法
253    /// </summary>
254    /// <param name="areaname">类型名称</param>
255    /// <returns>是否成功</returns>
256    public bool AddDepart(string departname)
257    ...{
258        //初始化输入参数并赋值
259        SqlParameter parm = new SqlParameter(PARM_DEPART_NAME, SqlDbType.NVarChar, 20);
260        parm.Value = departname;
261        //将参数添加到SQL命令中
262        SqlCommand cmd = new SqlCommand();
263        cmd.Parameters.Add(parm);
264        //初始化字符串连接
265        StringBuilder strSQL = new StringBuilder();
266        //初始化数据库连接
267        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
268        ...{
269            //添加连接语句
270            strSQL.Append(SQL_INSERT_DEPART);
271            //打开数据库连接
272            conn.Open();
273            //设置Sqlcommand命令的属性
274            cmd.Connection = conn;
275            cmd.CommandType = CommandType.Text;
276            cmd.CommandText = strSQL.ToString();
277            //执行添加的SqlCommand命令
278            int val = cmd.ExecuteNonQuery();
279            //清空SqlCommand命令中的参数
280            cmd.Parameters.Clear();
281            //判断是否添加成功，注意返回的是添加是否成功，不是影响的行数
282            if (val > 0)
283                return true;
284            else
285                return false;
286        }
287    }
288}
289