DAL/dalContact.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data.SqlClient;
using System.Data;

namespace DAL
{
    public class dalContact
    {
        /// <summary>
        /// 客户新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int insertContact(t_Contact model)
        {
            Database db = DatabaseFactory.CreateDatabase();
            int val = -1;
            SqlConnection con = new SqlConnection(db.ConnectionString.ToString());
            con.Open();
            // 使用事务，要么都执行成功，要么都执行失败
            SqlTransaction tran = con.BeginTransaction();
            try
            {
                //插入主表信息
                SqlParameter[] para = new SqlParameter[9];
                para[0] = new SqlParameter("@FContactID", model.FContactID);
                para[1] = new SqlParameter("@FNumber", model.FNumber.ToString());
                para[2] = new SqlParameter("@FName", model.FName);
                para[3] = new SqlParameter("@FDuty", model.FDuty);
                para[4] = new SqlParameter("@FPhone", model.FPhone);
                para[5] = new SqlParameter("@FMobile", model.FMobile);
                para[6] = new SqlParameter("@FEmail", model.FEmail);
                para[7] = new SqlParameter("@FFocus", model.FFocus);
                para[8] = new SqlParameter("@FNote", model.FNote);
                SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[insertContact]", para);
                tran.Commit();
            }
            catch (Exception)
            {
                tran.Rollback();
            }
            finally
            {
                if (con.State != ConnectionState.Closed)
                    con.Close();
            }
            return val;
        }

        /// <summary>
        /// 获取联系人列表
        /// </summary>
        /// <param name="pagesize">页大小</param>
        /// <param name="pageno">当前页码</param>
        /// <param name="recordCount">总行数</param>
        /// <returns></returns>