everlight.eap/backend/UFP/DllUfpDal/StaffRoleDal.cs

using Cksoft.Data;
using DllUfpEntity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DllUfpDal
{
    public class StaffRoleDal
    {
        public IDatabase CurrDb;

        public StaffRoleDal(IDatabase db)
        {
            CurrDb = db;
        }

        public IEnumerable<StaffRole> Get(string filter,ref string errorinfo)
        {
            return CurrDb.FindListForCondition<StaffRole>(filter, ref errorinfo);
        }

        public int Add(StaffRole staffRole,string usercode)
        {
            return CurrDb.InsertFor<StaffRole>(staffRole, usercode);
        }

        public int AddByTrans(IEnumerable<StaffRole> staffRoles,string usercode)
        {
            if (staffRoles != null && staffRoles.Count() > 0)
            {
                foreach(var item in staffRoles) 
                {
                    var sql = $@"insert into staffrole(roleid,staffcode,reccode,rectime,
                    modcode,modtime) values({item.RoleId},'{item.StaffCode}','{usercode}',
                    '{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}','{usercode}',
                    '{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}')";
                    if (CurrDb.ExecuteBySql(sql) < 0)
                    {
                        return -1;
                    }
                }
            }
            return 1;
        }

        public int Delete(string filter)
        {
            return CurrDb.ExecuteBySql($"delete from StaffRole where 1=1 {filter}");
        }
    }
}