DAL/ContactMan.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
    public class ContactMan
    {
        /// <summary>
        /// 联系人增加
        /// </summary>
        /// <param name="model_contactman"></param>
        /// <returns></returns>
        public bool ContactManAdd(Model.ContactMan model_contactman)
        {
            string sql = "INSERT INTO y_ContactMan VALUES(@EmployeeId,@Relationship,@Name,@Tel,@Kuser,@Kdate)";
            SqlParameter[] sqlpa =
            {
                new SqlParameter("@EmployeeId",model_contactman.EmployeeId),
                new SqlParameter("@Relationship",model_contactman.Relationship),
                new SqlParameter("@Name",model_contactman.Name),
                new SqlParameter("@Tel",model_contactman.Tel),
                new SqlParameter("@Kuser",model_contactman.Kuser),
                new SqlParameter("@Kdate",model_contactman.Kdate)
            };
            return DBhelp.ExecuteComand(sql, sqlpa);
        }

        /// <summary>
        /// 联系人修改
        /// </summary>
        /// <param name="model_contactman"></param>
        /// <returns></returns>
        public bool ContactManUpdate(Model.ContactMan model_contactman)
        {
            string sql = "UPDATE  y_ContactMan SET  Relationship=@Relationship, Name=@Name, Tel=@Tel  WHERE  Rowid=@Rowid";
            SqlParameter[] sqlpa =
            {
                new SqlParameter("@Rowid",model_contactman.Rowid),
                new SqlParameter("@EmployeeId",model_contactman.EmployeeId),
                new SqlParameter("@Relationship",model_contactman.Relationship),
                new SqlParameter("@Name",model_contactman.Name),
                new SqlParameter("@Tel",model_contactman.Tel)
            };
            return DBhelp.ExecuteComand(sql, sqlpa);
        }
        /// <summary>
        /// 联系人修改
        /// </summary>
        /// <param name="model_contactman"></param>
        /// <returns></returns>
        public bool ContactManUpdate_uid(Model.ContactMan model_contactman)
        {
            string sql = "UPDATE  y_ContactMan SET  Relationship=@Relationship, Name=@Name, Tel=@Tel  WHERE  EmployeeId=@EmployeeId";
            SqlParameter[] sqlpa =
            {
                new SqlParameter("@EmployeeId",model_contactman.EmployeeId),
                new SqlParameter("@Relationship",model_contactman.Relationship),