public List <ZKDInfoDto> GetWWZKD(string userId, string batchNo)
{
string sql = $@"
select
--t.d_mod_dt,t.n_status, t.c_linewh_code,t.c_mblinewh_code,t.c_linewh_id,t.C_MBLINEWH_ID,
t.*,t1.c_name as UserName from TRC_ROLL_ZKD t
left join ts_user t1 on t.c_emp_id = t1.c_id
where (t.c_linewh_code like '68%' or t.c_linewh_code like '16%') and (t.c_mblinewh_code like '68%' or t.c_mblinewh_code like '16%')
and t.n_status=3
";
if (string.IsNullOrEmpty(userId) == false && userId != "D68C3BC7690F4E19A5BFE4424E176E88")
{// 管理员可查询所有的
sql += $"and t.c_emp_id='{userId}' ";
}
if (string.IsNullOrEmpty(batchNo) == false)
{
sql += $"and t.c_batch_no like '%{batchNo}%'";
}
return(dalOrder.GetBySql(sql).DataTableToList2 <ZKDInfoDto>());
}
