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.Tools;
|
|
namespace VueWebCoreApi.DLL.DAL
|
{
|
public class ErpSyncMesDAL
|
{
|
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参数数组
|
|
#region[物料管理：计量单位同步]
|
public static ToMessage SaveSearchUnit(User us)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//存储过程名
|
sql = @"h_p_IFCLD_ERPUnit";
|
dynamicParams.Add("@username", us.usercode);
|
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
|
if (a)
|
{
|
mes.code = "200";
|
mes.count = 0;
|
mes.message = "同步计量单位成功!";
|
mes.data = null;
|
}
|
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 SaveSearchMateriel_Info(User us)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//存储过程名
|
sql = @"h_p_IFCLD_ERPInventory";
|
dynamicParams.Add("@username", us.usercode);
|
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
|
if (a)
|
{
|
mes.code = "200";
|
mes.count = 0;
|
mes.message = "同步存货档案成功!";
|
mes.data = null;
|
}
|
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 SaveSearchWareHouse(User us)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//存储过程名
|
sql = @"h_p_IFCLD_ERPWhareHouses";
|
dynamicParams.Add("@username", us.usercode);
|
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
|
if (a)
|
{
|
mes.code = "200";
|
mes.count = 0;
|
mes.message = "同步仓库成功!";
|
mes.data = null;
|
}
|
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 SeaveSearchPartner(User us)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//存储过程名
|
sql = @"h_p_IFCLD_ERPPartner";
|
dynamicParams.Add("@username", us.usercode);
|
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
|
if (a)
|
{
|
mes.code = "200";
|
mes.count = 0;
|
mes.message = "同步仓库成功!";
|
mes.data = null;
|
}
|
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[生产管理：ERP生产订单同步]
|
public static ToMessage SeaveSearchErpOrder(User us)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//存储过程名
|
sql = @"h_p_IFCLD_ERPMO";
|
dynamicParams.Add("@username", us.usercode);
|
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
|
if (a)
|
{
|
mes.code = "200";
|
mes.count = 0;
|
mes.message = "同步生产订单成功!";
|
mes.data = null;
|
}
|
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
|
}
|
}
|
