DAL/DalSys.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using MODEL;
namespace DAL
{
    public class DalSys
    {
        public static Boolean ModifySys(ModelSys model)
        {
            int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text,"update mis_para set");
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        public static IList<ModelSys> GetSysList()
        {
            IList<ModelSys> list = new List<ModelSys>();
            DataTable dt = Dal.SqlHelpers.ExecuteGetDataTable(CommandType.Text,"select * from mis_para");
            foreach (DataRow dr in dt.Rows)
            {
                ModelSys model = new ModelSys();
                model.PID = int.Parse(dr["PID"].ToString());
                model.PNAME=dr["PNAME"].ToString();
                model.PARA=int.Parse(dr["PARA"].ToString());
                list.Add(model);
            }
            return list;
        }
    }
}