Exemple #1
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int  Add(Hownet.Model.Employee model)
 {
     return(dal.Add(model));
 }
Exemple #2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(Hownet.Model.Employee model)
 {
     dal.Update(model);
 }
Exemple #3
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <Hownet.Model.Employee> DataTableToList(DataTable dt)
        {
            List <Hownet.Model.Employee> modelList = new List <Hownet.Model.Employee>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                Hownet.Model.Employee model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new Hownet.Model.Employee();
                    if (dt.Rows[n]["ID"].ToString() != "")
                    {
                        model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
                    }
                    model.Name = dt.Rows[n]["Name"].ToString();
                    if (dt.Rows[n]["IntroducerID"].ToString() != "")
                    {
                        model.IntroducerID = int.Parse(dt.Rows[n]["IntroducerID"].ToString());
                    }
                    model.IdentityCard = dt.Rows[n]["IdentityCard"].ToString();
                    if (dt.Rows[n]["Sex"].ToString() != "")
                    {
                        model.Sex = int.Parse(dt.Rows[n]["Sex"].ToString());
                    }
                    model.Sn = dt.Rows[n]["Sn"].ToString();
                    if (dt.Rows[n]["Province"].ToString() != "")
                    {
                        model.Province = int.Parse(dt.Rows[n]["Province"].ToString());
                    }
                    model.Address = dt.Rows[n]["Address"].ToString();
                    model.Phone   = dt.Rows[n]["Phone"].ToString();
                    if (dt.Rows[n]["AccessionDate"].ToString() != "")
                    {
                        model.AccessionDate = DateTime.Parse(dt.Rows[n]["AccessionDate"].ToString());
                    }
                    if (dt.Rows[n]["WorkTypeID"].ToString() != "")
                    {
                        model.WorkTypeID = int.Parse(dt.Rows[n]["WorkTypeID"].ToString());
                    }
                    if (dt.Rows[n]["PayID"].ToString() != "")
                    {
                        model.PayID = int.Parse(dt.Rows[n]["PayID"].ToString());
                    }
                    if (dt.Rows[n]["DimissionDate"].ToString() != "")
                    {
                        model.DimissionDate = DateTime.Parse(dt.Rows[n]["DimissionDate"].ToString());
                    }
                    if (dt.Rows[n]["BedID"].ToString() != "")
                    {
                        model.BedID = int.Parse(dt.Rows[n]["BedID"].ToString());
                    }
                    if (dt.Rows[n]["TableID"].ToString() != "")
                    {
                        model.TableID = int.Parse(dt.Rows[n]["TableID"].ToString());
                    }
                    if (dt.Rows[n]["DepartmentID"].ToString() != "")
                    {
                        model.DepartmentID = int.Parse(dt.Rows[n]["DepartmentID"].ToString());
                    }
                    if (dt.Rows[n]["DegreeID"].ToString() != "")
                    {
                        model.DegreeID = int.Parse(dt.Rows[n]["DegreeID"].ToString());
                    }
                    if (dt.Rows[n]["PolityID"].ToString() != "")
                    {
                        model.PolityID = int.Parse(dt.Rows[n]["PolityID"].ToString());
                    }
                    model.SOSPhone   = dt.Rows[n]["SOSPhone"].ToString();
                    model.SOSMan     = dt.Rows[n]["SOSMan"].ToString();
                    model.NowAddress = dt.Rows[n]["NowAddress"].ToString();
                    if (dt.Rows[n]["FillDate"].ToString() != "")
                    {
                        model.FillDate = DateTime.Parse(dt.Rows[n]["FillDate"].ToString());
                    }
                    if (dt.Rows[n]["FillUser"].ToString() != "")
                    {
                        model.FillUser = int.Parse(dt.Rows[n]["FillUser"].ToString());
                    }
                    if (dt.Rows[n]["LassMoney"].ToString() != "")
                    {
                        model.LassMoney = decimal.Parse(dt.Rows[n]["LassMoney"].ToString());
                    }
                    if (dt.Rows[n]["Royalty"].ToString() != "")
                    {
                        model.Royalty = decimal.Parse(dt.Rows[n]["Royalty"].ToString());
                    }
                    model.Image = dt.Rows[n]["Image"].ToString();
                    if (dt.Rows[n]["IsUse"].ToString() != "")
                    {
                        if ((dt.Rows[n]["IsUse"].ToString() == "1") || (dt.Rows[n]["IsUse"].ToString().ToLower() == "true"))
                        {
                            model.IsUse = true;
                        }
                        else
                        {
                            model.IsUse = false;
                        }
                    }
                    modelList.Add(model);
                }
            }
            return(modelList);
        }