コード例 #1
0
    /// <summary>
    /// 更新表结构,返回true表示更新成功!
    /// </summary>
    /// <param name="table">Table.</param>
    /// <typeparam name="T">The 1st type parameter.</typeparam>
    public bool UpdateTable <T>(table_data_base table)  where T : table_data_base
    {
        OpenSql(_config.DataBaseIP, _config.DataBaseName, _config.DbUserID, _config.DbPassword, _config.DbPort);
        var selectOld = SelectList <T> ("id='" + table.id + "'");

        if (selectOld == null || selectOld.Count == 0)
        {
            return(false);
        }
        string setValStr = "";
        var    oldItem   = selectOld [0];

        for (int index = 0; index < table.memNameList.Count; index++)
        {
            string memberName = table.memNameList [index];
            if (oldItem.getMemberValue(memberName) != table.getMemberValue(memberName))
            {
                string valStr = "'" + table.getMemberValue(memberName) + "'";
                if (table.getMemberType(memberName).Name == "int")
                {
                    valStr = table.getMemberValue(memberName) + "";
                }
                setValStr += memberName + "=" + valStr + ",";
            }
        }
        setValStr = setValStr.TrimEnd(',');
        string newSql = "update " + table.GetType().Name + " set " + setValStr + " where id='" + table.id + "'";

        QuerySet(newSql, _config);
        Close();
        return(true);
    }
コード例 #2
0
    /// <summary>
    /// 从DataSet生成数据表实体对象
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="dataSet"></param>
    /// <returns></returns>
    public static List <table_data_base> getListfromDataSet <T>(DataSet dataSet) where T : table_data_base
    {
        var list = new List <table_data_base>();// as List<T>;// new table_data_base() as T;

        for (int index = 0; index < dataSet.Tables[0].Rows.Count; index++)
        {
            var tableItem = new table_data_base() as T;
            if (tableItem.memNameList.Count == 0)
            {
                Logger.LogError("类型=" + list.GetType().Name + "的构造函数错误!必须继承自 table_data_base");
                return(null);
            }
            for (int subIndex = 0; subIndex < tableItem.memNameList.Count; subIndex++)
            {
                tableItem.setMemberValue(tableItem.memNameList[subIndex], dataSet.Tables[0].Rows[index][tableItem.memNameList[subIndex]]);
            }
            list.Add(tableItem);
        }
        return(list);
    }