SqlDao 1.0.0

SqlDao

项目介绍

C# 操作数据库ORM类库，支持所有支持标准Sql语句的主流数据库

软件架构

软件架构说明

安装教程

1. clone 项目 用Vs2017 打开重先生成，把新生成的SqlDao.dll 添加到你的项目 还可以在你的项目里添加一个现有项，作为类库。在你的主项目时添加项目的引用

2. 连接数据库字符串（和平时开发一样）

   connectionString="Database=ticket;Data Source=127.0.0.1;User Id=admin;Password=;pooling=false;CharSet=utf8;port=3306;"

3. 连接数据库 （以mysql 为例）

   public class DatabaseOPtionHelper {

    private static DbHelper Instance;
   
   
    public static DbHelper GetInstance()
    {
        string conn = ConfigurationHelper.GetConnectionConfig(ConfigItemName.mysqlConn.ToString());
        Instance = new MySqlHelper(conn);
        App.Current.Dispatcher.BeginInvoke(new Action(delegate
        {
            if (Instance == null)
            {
                Instance = new MySqlHelper(conn);
            }
        }));
        return Instance;
    }
   

   }

使用说明

1. select

List<Company> tempList = CompanyModel.IndistinctSearchByNameOrNameFirstCase(tempStr);

 WeighingBillModel里的方法

  public static List<Company> IndistinctSearchByNameOrNameFirstCase(String nameOrCase)
    {
        string condition = null;
        if (!String.IsNullOrEmpty(nameOrCase))
        {
            condition = CompanyColumns.name.ToString() + " like '%" + nameOrCase + "%' " + " OR " +              CompanyColumns.name_first_case.ToString() + " like '%" + nameOrCase.ToUpper() + "%'";
        }
        String sql = DatabaseOPtionHelper.GetInstance().getSelectSql(TableName.company.ToString(), null, condition);
        List<Company> list = DatabaseOPtionHelper.GetInstance().select<Company>(sql);
        return list;
    }

2. insert

   int res = WeighingBillModel.Create(mWeighingBill);

   WeighingBillModel里的方法

    public static int Create(WeighingBill mWeighingBill)
    {
        return DatabaseOPtionHelper.GetInstance().insert(mWeighingBill);
    }
   

3. update

int res = WeighingBillModel.update(mWeighingBill);

WeighingBillModel里的方法

    public static int Create(WeighingBill mWeighingBill)
    {
        return DatabaseOPtionHelper.GetInstance().update(mWeighingBill);
    }

4.del

int res = WeighingBillModel.del(mWeighingBill);

WeighingBillModel里的方法

    public static int del(WeighingBill mWeighingBill)
    {
        return DatabaseOPtionHelper.GetInstance().del(mWeighingBill);
    }

5. 类似 GreenDao 操作，功能大至相似