コード例 #1
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(string strConString, DYH_DB.Model.AU_LayerNode model)
 {
     return(dal.Update(strConString, model));
 }
コード例 #2
0
 public void Add(string strConString, DYH_DB.Model.AU_LayerNode model)
 {
     dal.Add(strConString, model);
 }
コード例 #3
0
 public void TransAdd(DYH_DB.Model.AU_LayerNode model, Hashtable SQLStringList, ArrayList arrayList)
 {
     dal.TransAdd(model, SQLStringList, arrayList);
 }
コード例 #4
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(DYH_DB.Model.AU_LayerNode model)
 {
     dal.Add(model);
 }
コード例 #5
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        //public List<DYH_DB.Model.AU_LayerNode> GetModelList(string strWhere)
        //{
        //    DataSet ds = dal.GetList(strWhere);
        //    return DataTableToList(ds.Tables[0]);
        //}
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <DYH_DB.Model.AU_LayerNode> DataTableToList(DataTable dt)
        {
            List <DYH_DB.Model.AU_LayerNode> modelList = new List <DYH_DB.Model.AU_LayerNode>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                DYH_DB.Model.AU_LayerNode model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new DYH_DB.Model.AU_LayerNode();
                    if (dt.Rows[n]["AU_LayerNodeID"].ToString() != "")
                    {
                        model.AU_LayerNodeID = int.Parse(dt.Rows[n]["AU_LayerNodeID"].ToString());
                    }
                    if (dt.Rows[n]["AU_ParentLayerNodeID"].ToString() != "")
                    {
                        model.AU_ParentLayerNodeID = int.Parse(dt.Rows[n]["AU_ParentLayerNodeID"].ToString());
                    }
                    model.AU_UrlAddress = dt.Rows[n]["AU_UrlAddress"].ToString();
                    model.AU_UrlTitle   = dt.Rows[n]["AU_UrlTitle"].ToString();
                    model.AU_UrlContent = dt.Rows[n]["AU_UrlContent"].ToString();
                    if (dt.Rows[n]["AU_UrlLayer"].ToString() != "")
                    {
                        model.AU_UrlLayer = int.Parse(dt.Rows[n]["AU_UrlLayer"].ToString());
                    }
                    if (dt.Rows[n]["AU_IsVisit"].ToString() != "")
                    {
                        model.AU_IsVisit = int.Parse(dt.Rows[n]["AU_IsVisit"].ToString());
                    }
                    if (dt.Rows[n]["AU_RemoveSameOffset1"].ToString() != "")
                    {
                        model.AU_RemoveSameOffset1 = int.Parse(dt.Rows[n]["AU_RemoveSameOffset1"].ToString());
                    }
                    if (dt.Rows[n]["AU_RemoveSameOffset2"].ToString() != "")
                    {
                        model.AU_RemoveSameOffset2 = int.Parse(dt.Rows[n]["AU_RemoveSameOffset2"].ToString());
                    }
                    if (dt.Rows[n]["AU_LastUpdateDate"].ToString() != "")
                    {
                        model.AU_LastUpdateDate = DateTime.Parse(dt.Rows[n]["AU_LastUpdateDate"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveInt1"].ToString() != "")
                    {
                        model.AU_ReserveInt1 = int.Parse(dt.Rows[n]["AU_ReserveInt1"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveInt2"].ToString() != "")
                    {
                        model.AU_ReserveInt2 = int.Parse(dt.Rows[n]["AU_ReserveInt2"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveInt3"].ToString() != "")
                    {
                        model.AU_ReserveInt3 = int.Parse(dt.Rows[n]["AU_ReserveInt3"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveInt4"].ToString() != "")
                    {
                        model.AU_ReserveInt4 = int.Parse(dt.Rows[n]["AU_ReserveInt4"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveInt5"].ToString() != "")
                    {
                        model.AU_ReserveInt5 = int.Parse(dt.Rows[n]["AU_ReserveInt5"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveInt6"].ToString() != "")
                    {
                        model.AU_ReserveInt6 = int.Parse(dt.Rows[n]["AU_ReserveInt6"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveInt7"].ToString() != "")
                    {
                        model.AU_ReserveInt7 = int.Parse(dt.Rows[n]["AU_ReserveInt7"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveInt8"].ToString() != "")
                    {
                        model.AU_ReserveInt8 = int.Parse(dt.Rows[n]["AU_ReserveInt8"].ToString());
                    }
                    model.AU_ReserveStr1   = dt.Rows[n]["AU_ReserveStr1"].ToString();
                    model.AU_ReserveStr2   = dt.Rows[n]["AU_ReserveStr2"].ToString();
                    model.AU_ReserveNStr1  = dt.Rows[n]["AU_ReserveNStr1"].ToString();
                    model.AU_ReserveNStr2  = dt.Rows[n]["AU_ReserveNStr2"].ToString();
                    model.AU_ReserveTEXT1  = dt.Rows[n]["AU_ReserveTEXT1"].ToString();
                    model.AU_ReserveTEXT2  = dt.Rows[n]["AU_ReserveTEXT2"].ToString();
                    model.AU_ReserveTEXT3  = dt.Rows[n]["AU_ReserveTEXT3"].ToString();
                    model.AU_ReserveNTEXT1 = dt.Rows[n]["AU_ReserveNTEXT1"].ToString();
                    model.AU_ReserveNTEXT2 = dt.Rows[n]["AU_ReserveNTEXT2"].ToString();
                    model.AU_ReserveNTEXT3 = dt.Rows[n]["AU_ReserveNTEXT3"].ToString();
                    if (dt.Rows[n]["AU_ReserveDateTime1"].ToString() != "")
                    {
                        model.AU_ReserveDateTime1 = DateTime.Parse(dt.Rows[n]["AU_ReserveDateTime1"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveDateTime2"].ToString() != "")
                    {
                        model.AU_ReserveDateTime2 = DateTime.Parse(dt.Rows[n]["AU_ReserveDateTime2"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveDateTime3"].ToString() != "")
                    {
                        model.AU_ReserveDateTime3 = DateTime.Parse(dt.Rows[n]["AU_ReserveDateTime3"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveDateTime4"].ToString() != "")
                    {
                        model.AU_ReserveDateTime4 = DateTime.Parse(dt.Rows[n]["AU_ReserveDateTime4"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveDecmial1"].ToString() != "")
                    {
                        model.AU_ReserveDecmial1 = decimal.Parse(dt.Rows[n]["AU_ReserveDecmial1"].ToString());
                    }
                    if (dt.Rows[n]["AU_ReserveDecmial2"].ToString() != "")
                    {
                        model.AU_ReserveDecmial2 = decimal.Parse(dt.Rows[n]["AU_ReserveDecmial2"].ToString());
                    }
                    modelList.Add(model);
                }
            }
            return(modelList);
        }