using Dapper;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Linq;
|
using System.Threading.Tasks;
|
using VueWebCoreApi.Models;
|
using VueWebCoreApi.Models.UnitMaterial;
|
using VueWebCoreApi.Models.WorkData;
|
using VueWebCoreApi.Tools;
|
|
namespace VueWebCoreApi.DLL.DAL
|
{
|
public class GeneralBasicDataDAL
|
{
|
public static DataTable dt; //定义全局变量dt
|
public static bool res; //定义全局变量dt
|
public static ToMessage mes = new ToMessage(); //定义全局返回信息对象
|
public static string strProcName = ""; //定义全局sql变量
|
public static List<SqlParameter> listStr = new List<SqlParameter>(); //定义全局参数集合
|
public static SqlParameter[] parameters; //定义全局SqlParameter参数数组
|
public static dynamic CompanyCode = AppSetting.GetAppSetting("CompanyCode");
|
public static dynamic CompanyName = AppSetting.GetAppSetting("CompanyName");
|
|
|
#region[组织架构类型资料]
|
public static ToMessage TOrganTypeDate()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
sql = @"select torgtype_code,torgtype_name from TOrganType where torgtype_code<>'C'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region [组织架构查找]
|
public static ToMessage PrentOrganization()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select * from TOrganization where status='Y'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[组织架构基础资料(无公司)]
|
public static ToMessage PrentOrganizationNoCompany()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select * from TOrganization where status='Y' and parent_id<>'0' or leve<>'0'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[组织架构车间基础资料]
|
public static ToMessage TorgWkshop()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
sql = @"select * from TOrganization where status='Y' and torgtype_code='W'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region [岗位基础资料]
|
public static ToMessage PostPermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select postcode,postname from TPost where status='Y'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region [角色基础资料]
|
public static ToMessage RolePermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select rolecode,rolename from TRole where status='Y'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region [班组基础资料]
|
public static ToMessage GroupsPermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select usergroupcode,usergroupname from TGroup where status='Y'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[人员基础资料]
|
public static ToMessage PersonPermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select usercode,username from TUser where status='Y'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[班组查找人员基础资料]
|
public static ToMessage GroupsPersonPermissions(string groupcode)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
sql = @"select stuff((select ',' + usercode
|
from (select usercode from TUser
|
where ',' + group_code + ',' LIKE @groupcode and status='Y') as A
|
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '') AS usercode_list";
|
dynamicParams.Add("@groupcode", "%," + groupcode + ",%");
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[按钮基础资料]
|
public static ToMessage ButtonData()
|
{
|
string sql = "";
|
try
|
{
|
sql = @"select buttoncode,buttonname from TButton";
|
var data = DapperHelper.selecttable(sql);
|
if (data.Rows.Count > 0)
|
{
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
else
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = "无按钮档案数据!";
|
mes.data = null;
|
}
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[数据权限基础资料]
|
public static ToMessage DataPermissions()
|
{
|
string sql = "";
|
try
|
{
|
sql = @"select datacode,dataname from TData";
|
var data = DapperHelper.selecttable(sql);
|
if (data.Rows.Count > 0)
|
{
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
else
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = "无数据权限档案数据!";
|
mes.data = null;
|
}
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
|
#region[单位信息查询]
|
public static ToMessage UnitSerch(string tunittype)
|
{
|
List<Unit> list = new List<Unit>();
|
var dynamicParams = new DynamicParameters();
|
string sql = "";
|
try
|
{
|
if (tunittype == "S")
|
{
|
sql = @"select code as unitcode,name as unitname,isSingleUnit,isMainUnit,isGroup
|
from TUnit where isSingleUnit='1' and isGroup='0' and disabled='0'";
|
var data = DapperHelper.selecttable(sql);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
if (tunittype == "M")
|
{
|
sql = @"select code as unitcode,name as unitname from TUnitGroup";
|
var data = DapperHelper.selectdatalist<Unit>(sql);
|
|
for (int i = 0; i < data.Count; i++)
|
{
|
sql = @"select code as unitcode,name as unitname,isSingleUnit,isMainUnit,isGroup
|
from TUnit where isGroup='1' and disabled='0' and idunitgroup=@unitcode";
|
dynamicParams.Add("@unitcode", data[i].unitcode);
|
var data0 = DapperHelper.select<unitporject>(sql, dynamicParams);
|
data[i].children = data0;
|
}
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[设备类型信息查询]
|
public static ToMessage DeviceTypeData()
|
{
|
string sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//获取设备类型数据
|
sql = @"select code,name from TEqpType";
|
var data = DapperHelper.selecttable(sql);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[设备基础资料]
|
public static ToMessage EqpPermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select code,name from TEqpInfo where enable='Y'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[车间查找设备基础资料]
|
public static ToMessage WkshopEqpPermissions(string wkshopcode)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
string[] wkshopcodelist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[]
|
sql = @"select code,name from TEqpInfo where enable='Y' and torg_code in @torg_code";
|
dynamicParams.Add("@torg_code", wkshopcodelist);
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[设备类型编码查找设备信息]
|
public static ToMessage EqpTypecodeSeachEqpPermissions(string eqptypecode)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
sql = @"select code,name from TEqpInfo where enable='Y' and eqptype_code=@eqptypecode";
|
dynamicParams.Add("@eqptypecode", eqptypecode);
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[仓库基础资料]
|
public static ToMessage WareHouse()
|
{
|
string sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//获取仓库数据
|
sql = @"select code,name from TSecStck";
|
var data = DapperHelper.selecttable(sql);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[仓库库位基础资料]
|
public static ToMessage WareHouseLocation()
|
{
|
string sql = "";
|
var dynamicParams = new DynamicParameters();
|
List<WareHouseLocation> list = new List<WareHouseLocation>();
|
try
|
{
|
//获取仓库数据
|
sql = @"select code,name from TSecStck where status='0'";
|
var data = DapperHelper.selecttable(sql);
|
for (int i = 0; i < data.Rows.Count; i++)
|
{
|
WareHouseLocation warhouse = new WareHouseLocation();
|
warhouse.value = data.Rows[i]["code"].ToString();
|
warhouse.text = data.Rows[i]["name"].ToString();
|
warhouse.children = new List<LocationData>();
|
//获取库位
|
sql = @"select code,name from TSecLoca where status='0' and idwarehouse=@idwarehouse";
|
dynamicParams.Add("@idwarehouse", data.Rows[i]["code"].ToString());
|
var data0 = DapperHelper.selectdata(sql, dynamicParams);
|
for (int j = 0; j < data0.Rows.Count; j++)
|
{
|
LocationData locat = new LocationData();
|
locat.value = data0.Rows[j]["code"].ToString();
|
locat.text = data0.Rows[j]["name"].ToString();
|
warhouse.children.Add(locat);
|
}
|
list.Add(warhouse);
|
}
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = list;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[仓库查找仓位信息]
|
public static ToMessage WareHouseSelectLocation(string warhousecode)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
sql = @"select code,name,depth from TSecLoca where status='0' and idwarehouse=@idwarehouse";
|
dynamicParams.Add("@idwarehouse", warhousecode);
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[工序基础资料]
|
public static ToMessage StepData()
|
{
|
string sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//获取仓库数据
|
sql = @"select stepcode,stepname from TStep where enable='Y'";
|
var data = DapperHelper.selecttable(sql);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[工序设备基础资料]
|
public static ToMessage StepEqpData()
|
{
|
var sql = "";
|
List<object> list = new List<object>();
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//查找工序信息
|
sql = @"select '' as id,'' as wo_code,'' as seq,S.stepcode as step_code,T.stepname,T.flwtype,'0' as unprice,'0' as produceq_qty,
|
'0' as good_qty,'0' as ng_qty,'0' as laborbad_qty,'0' as materielbad_qty,'0' as delive_qty,'' as isbott,'' as isend
|
from TStep S
|
left join TStep T on S.stepcode=T.stepcode";
|
var parents = DapperHelper.selectdatalist<WorkRouteStepEqp>(sql);
|
//获取工序对应设备信息
|
for (int i = 0; i < parents.Count; i++)
|
{
|
if (parents[i].flwtype == "Z")
|
{
|
//通过工艺路线工序表ID查找对应设备信息
|
sql = @"select R.eqp_code,E.name as eqp_name,'N' as enable,'0' as unprice,
|
'0' as produceq_qty, '0' as good_qty,'0' as ng_qty,'0' as laborbad_qty,'0' as materielbad_qty
|
from TFlw_Rteqp R
|
left join TEqpInfo E on R.eqp_code=E.code
|
where R.step_code=@step_code and R.style=@style";
|
dynamicParams.Add("@step_code", parents[i].step_code);
|
dynamicParams.Add("@style", "E"); //设备
|
var children = DapperHelper.select<WorkRouteStepEqpSub>(sql, dynamicParams);
|
parents[i].children = children.ToList();
|
}
|
else
|
{
|
//通过工艺路线工序表ID查找对应外协供应商信息
|
sql = @"select R.eqp_code,E.name as eqp_name,'N' as enable,'0' as unprice,
|
'0' as produceq_qty, '0' as good_qty,'0' as ng_qty,'0' as laborbad_qty,'0' as materielbad_qty
|
from TFlw_Rteqp R
|
inner join TCustomer E on R.eqp_code=E.code
|
where R.step_code=@step_code and R.style=@style";
|
dynamicParams.Add("@step_code", parents[i].step_code);
|
dynamicParams.Add("@style", parents[i].flwtype);
|
var children = DapperHelper.select<WorkRouteStepEqpSub>(sql, dynamicParams);
|
parents[i].children = children.ToList();
|
}
|
}
|
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.count = parents.Count;
|
mes.data = parents;
|
mes.message = "查询成功!";
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[缺陷基础资料]
|
public static ToMessage DefectPermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select code,name from TDefect";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[往来单位类型基础资料]
|
public static ToMessage CustomerTypePermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
sql = @"select code,name from TCustomerType";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[往来单位基础资料]
|
public static ToMessage CustomerPermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
sql = @"select code,name from TCustomer where status='0'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[往来单位类型查找往来单位基础资料]
|
public static ToMessage CustomerTypeSearchPermissions(string customertypecode)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
string[] customerTypecodelist = Array.ConvertAll<string, string>(customertypecode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[]
|
sql = @"select code,name from TCustomer where customertype in @customerTypecodelist";
|
dynamicParams.Add("@customerTypecodelist", customerTypecodelist);
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[存货树型基础资料]
|
public static ToMessage InventoryTreePermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
sql = @"WITH RecursiveCTE AS (
|
SELECT code, name, idparent
|
FROM TMateriel_Class
|
WHERE code in(select distinct idinventoryclass from TMateriel_Info where status='0')
|
UNION ALL
|
SELECT c.code, c.name, c.idparent
|
FROM TMateriel_Class c
|
INNER JOIN RecursiveCTE r ON c.code = r.idparent
|
)
|
SELECT distinct code, name, idparent as parentid
|
FROM RecursiveCTE CTE
|
union all
|
select partcode as code,partname as name,idinventoryclass as parentid
|
from TMateriel_Info
|
where status='0'";
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[模具检验项目下拉列表]
|
public static ToMessage MouldCheckItemSelect()
|
{
|
string sql = "";
|
try
|
{
|
//获取模具点检项目数据
|
sql = @"select code,name,description from TMouldchk_Item";
|
var data = DapperHelper.selecttable(sql);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[模具保养项目下拉列表]
|
public static ToMessage MouldRepairItemSelect()
|
{
|
string sql = "";
|
try
|
{
|
//获取模具保养项目数据
|
sql = @"select code,name,description from TMouldmai_Item";
|
var data = DapperHelper.selecttable(sql);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[查询工单/产品基础资料]
|
public static ToMessage WrkOrderDataSelect()
|
{
|
string sql = "";
|
try
|
{
|
sql = @"select P.wo_code,P.materiel_code,M.partname as materiel_name
|
from TK_Wrk_Man P
|
left join TMateriel_Info M on P.materiel_code=M.partcode";
|
var data = DapperHelper.selecttable(sql);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[存货查询物料清单Bom信息]
|
public static ToMessage PartSearchBomDate(string partnumber)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
sql = @"select id,version from TBom_Main where status='Y' and materiel_code=@materiel_code order by version desc";
|
dynamicParams.Add("@materiel_code", partnumber);
|
var data = DapperHelper.selectdata(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = data;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
}
|
}
|
