DAL/Family.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 Family
    {
        /// <summary>
        /// 家庭成员添加
        /// </summary>
        /// <param name="mode_family"></param>
        /// <returns></returns>
        public bool FamilyAdd(Model.Family mode_family)
        {
            string sql = " INSERT INTO dbo.y_Family VALUES(@EmployeeId,@Appellation,@Name,@Age,@Vocation,@Job,@Income,@Kuser,@Kdate)";
            SqlParameter[] sqlpa =
           {
           new SqlParameter("@EmployeeId",mode_family.EmployeeId),
           new SqlParameter("@Appellation",mode_family.Appellation),
           new SqlParameter("@Name",mode_family.Name),
           new SqlParameter("@Age",mode_family.Age),
           new SqlParameter("@Vocation",mode_family.Vocation),
           new SqlParameter("@Job",mode_family.Job),
           new SqlParameter("@Income",mode_family.Income),
           new SqlParameter("@Kuser",mode_family.Kuser),
           new SqlParameter("@Kdate",mode_family.Kdate)
           };
            return DBhelp.ExecuteComand(sql, sqlpa);
        }

        /// <summary>
        /// 家庭成员修改
        /// </summary>
        /// <param name="mode_family"></param>
        /// <returns></returns>
        public bool FamilyUpdate(Model.Family mode_family)
        {
            string sql = "UPDATE dbo.y_Family SET  Appellation=@Appellation, Name=@Name, Age=@Age, Vocation=@Vocation, Job=@Job  WHERE  Rowid=@Rowid";
            SqlParameter[] sqlpa =
           {
           new SqlParameter("@Rowid",mode_family.Rowid),
           new SqlParameter("@EmployeeId",mode_family.EmployeeId),
           new SqlParameter("@Appellation",mode_family.Appellation),
           new SqlParameter("@Name",mode_family.Name),
           new SqlParameter("@Age",mode_family.Age),
           new SqlParameter("@Vocation",mode_family.Vocation),
           new SqlParameter("@Job",mode_family.Job),
           };
            return DBhelp.ExecuteComand(sql, sqlpa);
        }
        /// <summary>
        /// 家庭成员修改
        /// </summary>
        /// <param name="mode_family"></param>
        /// <returns></returns>
        public bool FamilyUpdate_uid(Model.Family mode_family)
        {