44 lines
1.3 KiB
C#
44 lines
1.3 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using Dapper;
|
|
namespace dccdc.DAL
|
|
{
|
|
public class OA
|
|
{
|
|
public object getKSlist(string selected,string ksmc)
|
|
{
|
|
using (var db = CommHelper.GetSqlConnection("OADB"))
|
|
{
|
|
string sql = "select id,bumenname from erpbumen where dirid<>0";
|
|
if(!string.IsNullOrEmpty(ksmc))
|
|
{
|
|
sql += "and bumenname like @ksmc";
|
|
}
|
|
string[] sels = selected.Split(',');
|
|
if(sels.Length>0)
|
|
{
|
|
sql += " and id not in @sels";
|
|
}
|
|
return db.Query(sql, new { ksmc = "%" + ksmc + "%", sels });
|
|
}
|
|
}
|
|
|
|
public object getSelKSlist(string selected)
|
|
{
|
|
using (var db = CommHelper.GetSqlConnection("OADB"))
|
|
{
|
|
string sql = "select id,bumenname from erpbumen where dirid<>0";
|
|
|
|
string[] sels = selected.Split(',');
|
|
|
|
sql += " and id in @sels";
|
|
|
|
return db.Query(sql, new { sels });
|
|
}
|
|
}
|
|
}
|
|
}
|