using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Web;
|
using WebAPI.Models;
|
|
namespace WebAPI.Service
|
{
|
public class LuBaoSevice
|
{
|
|
/// <summary>
|
/// 工序汇报扫码方法
|
/// </summary>
|
public static ApiResult<DataSet> GetHbarCodeDetail(string sBillBarCode)
|
{
|
if (string.IsNullOrEmpty(sBillBarCode))
|
return new ApiResult<DataSet> { code = -1, msg = "条码不能为空" };
|
sBillBarCode = sBillBarCode.CompareTo("#") > 0 ? sBillBarCode.Split(Convert.ToChar("#"))[0] : sBillBarCode;
|
var dataSet = GetBarCodeDb(sBillBarCode);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在派工单号" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetBarCodeDb(string billBarCode)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessSendWorkList where HBillType='3712' and 单据号= '" + billBarCode + "'", "h_v_Sc_ProcessSendWorkList");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 委外工序汇报扫码方法
|
/// </summary>
|
public static ApiResult<DataSet> WWGetHbarCodeDetail(string sBillBarCode)
|
{
|
if (string.IsNullOrEmpty(sBillBarCode))
|
return new ApiResult<DataSet> { code = -1, msg = "条码不能为空" };
|
sBillBarCode = sBillBarCode.CompareTo("#") > 0 ? sBillBarCode.Split(Convert.ToChar("#"))[0] : sBillBarCode;
|
var dataSet = WWGetBarCodeDb(sBillBarCode);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在委外派工单号" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet WWGetBarCodeDb(string billBarCode)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_WW_EntrustProcSendWorkBillList where HBillType='3740' and 单据号= '" + billBarCode + "'", "h_v_WW_EntrustProcSendWorkBillList");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// PDA汇报单回车方法
|
/// </summary>
|
public static ApiResult<DataSet> GetProcDetail(string sBillNo, string sProcNo)
|
{
|
if (string.IsNullOrEmpty(sBillNo) || string.IsNullOrEmpty(sProcNo))
|
return new ApiResult<DataSet> { code = -1, msg = "条码和流转卡不能为空" };
|
var dataSet = GetProcDb(sBillNo, sProcNo);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "流水号或流转卡号为空" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetProcDb(string sBillNo, string sProcNo)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessSendWorkList where HBillType='3712' and 单据号= '" + sBillNo + "' and HprocID='" + sProcNo + "'", "h_v_Sc_ProcessSendWorkList");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// PDA委外汇报单回车方法
|
/// </summary>
|
public static ApiResult<DataSet> WWGetProcDetail(string sBillNo, string sProcNo)
|
{
|
if (string.IsNullOrEmpty(sBillNo) || string.IsNullOrEmpty(sProcNo))
|
return new ApiResult<DataSet> { code = -1, msg = "条码和流转卡不能为空" };
|
var dataSet = WWGetProcDb(sBillNo, sProcNo);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "流水号或流转卡号为空" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet WWGetProcDb(string sBillNo, string sProcNo)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_WW_EntrustProcSendWorkBillList where HBillType='3740' and 单据号= '" + sBillNo + "' and HprocID='" + sProcNo + "'", "h_v_WW_EntrustProcSendWorkBillList");
|
return dataSet;
|
}
|
|
|
/// <summary>
|
/// 检验方案根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetCheckProjectDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetProjectDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在检验单号" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetProjectDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_Edit_QCCheckProjectList where hmainid= " + HID +" ", "h_v_Gy_Edit_QCCheckProjectList");
|
return dataSet;
|
}
|
|
|
/// <summary>
|
/// 来料检验根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetPOStockInCheckBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetPOStockInDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在来料检验单号" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetPOStockInDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_QC_Edit_POStockInCheckBillList where hmainid= " + HID + " ", "h_v_QC_Edit_POStockInCheckBillList");
|
return dataSet;
|
}
|
|
|
/// <summary>
|
/// 首料检验根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetQC_FirstPieceCheckBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetFirstPieceCheckDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在首料检验单号" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetFirstPieceCheckDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_QC_Edit_FirstPieceCheckBillList where hmainid= " + HID + " ", "h_v_QC_Edit_FirstPieceCheckBillList");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 巡检单根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetQC_PatrolProcCheckBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetPatrolProcCheckDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在巡检单号" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetPatrolProcCheckDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_QC_Edit_PatrolProcCheckBillList where hmainid= " + HID + " ", "h_v_QC_Edit_PatrolProcCheckBillList");
|
return dataSet;
|
}
|
|
|
/// <summary>
|
/// 不良原因根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_BadReasonBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_BadReasonDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在不良原因数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetGy_BadReasonDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_IF_Edit_BadReasonList where HItemID= " + HID + " ", "h_v_IF_Edit_BadReasonList");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 不良后果根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_BadResultBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_BadResultDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在不良后果数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_BadResultDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_BadResult where HItemID= " + HID + " ", "h_v_Gy_BadResult");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 不良现象根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_BadPhenomenaDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_BadPhenomenaDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在不良后果数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_BadPhenomenaDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_BadPhenomena where HItemID= " + HID + " ", "h_v_Gy_BadPhenomena");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 检测值根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_InspectValueBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_InspectValueDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在检测值数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetGy_InspectValueDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_InspectValue where HItemID= " + HID + " ", "h_v_Gy_InspectValue");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 检验方法根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_InspectMethodBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_InspectMethodDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在检测方法数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_InspectMethodDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_InspectMethod where HItemID= " + HID + " ", "h_v_Gy_InspectMethod");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 质量标准根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_QualityStdBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_QualityStdDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在质量标准数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_QualityStdDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_QualityStd where HItemID= " + HID + " ", "h_v_Gy_QualityStd");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 检验仪器根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_InspectInstruMentBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_InspectInstruMentDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在检验仪器数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_InspectInstruMentDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_InspectInstruMent where HItemID= " + HID + " ", "h_v_Gy_InspectInstruMent");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 检验依据根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_InspectBasisBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_UserProcessDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在用户关联工序数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_UserProcessDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select * from h_v_Gy_InspectBasis_Edit where HItemID= " + HID + " ", "h_v_Gy_InspectBasis_Edit");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 用户关联工序根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_UserProcessBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_InspectBasisDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在用户关联工序数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_InspectBasisDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select * from h_v_Gy_UserProcess where 用户代码= '" + HID + "' ", "h_v_Gy_UserProcess");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 用户关联班组根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_UserGroupBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_UserGroupBasisDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在用户关联班组数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetGy_UserGroupBasisDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select * from h_v_Gy_UserGroupRelationList_Query where 用户代码= '" + HID + "' ", "h_v_Gy_UserGroupRelationList_Query");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 用户关联供应商根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_UserSupplierBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_UserSupplierBasisDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在用户关联供应商数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetGy_UserSupplierBasisDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select * from h_v_Gy_UserSupplierRelationList_Query where 用户代码= '" + HID + "' ", "h_v_Gy_UserSupplierRelationList_Query");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 用户关联仓库根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_UserStockRelationDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_UserStockRelationDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在用户关联仓库数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
|
|
public static DataSet GetGy_UserStockRelationDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select * from h_v_Gy_UserStockRelation where 用户代码= '" + HID + "' ", "h_v_Gy_UserStockRelation");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 用户关联用户根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> Gy_UserByUserEdit(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = Gy_UserByUserEdittDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在用户关联仓库数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet Gy_UserByUserEdittDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select * from h_v_Gy_UserByUserRelationList where 用户代码= '" + HID + "' ", "h_v_Gy_UserByUserRelationList");
|
return dataSet;
|
}
|
|
|
/// <summary>
|
/// 用户关联物料根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_UserMaterDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_UserMaterDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在用户关联物料数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_UserMaterDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select * from h_v_Gy_UserMater where 用户代码= '" + HID + "' ", "h_v_Gy_UserMater");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 岗位技能根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_PostSkillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_PostSkillDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在岗位技能数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_PostSkillDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_PostSkill where HItemID= " + HID + " ", "h_v_Gy_PostSkill");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 岗位根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_PostDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_PostDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在岗位数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_PostDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_Post where HItemID= " + HID + " ", "h_v_Gy_Post");
|
return dataSet;
|
}
|
|
/// <summary>
|
///调拨类型根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_StockMoveStyleDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_StockMoveStyleDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在调拨类型数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_StockMoveStyleDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_StockMoveStyle where HItemID= " + HID + " ", "h_v_Gy_StockMoveStyle");
|
return dataSet;
|
}
|
|
|
/// <summary>
|
///入库类型根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_StockInStyleDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_StockInStyleDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在入库类型数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_StockInStyleDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_StockInStyle where HItemID= " + HID + " ", "h_v_Gy_StockInStyle");
|
return dataSet;
|
}
|
|
/// <summary>
|
///出库类型根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_StockOutStyleDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_StockOutStyleDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在出库类型数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_StockOutStyleDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_StockOutStyle where HItemID= " + HID + " ", "h_v_Gy_StockOutStyle");
|
return dataSet;
|
}
|
|
/// <summary>
|
///地区据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_AreaSetDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_AreaSetDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在地区数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_AreaSetDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_AreaSet where HItemID= " + HID + " ", "h_v_Gy_AreaSet");
|
return dataSet;
|
}
|
|
/// <summary>
|
///销售方式根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_SellStyleDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_SellStyleDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在销售方式数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_SellStyleDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_SellStyle where HItemID= " + HID + " ", "h_v_Gy_SellStyle");
|
return dataSet;
|
}
|
|
/// <summary>
|
///采购方式根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_PoStockStyleDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_PoStockStyleDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在采购方式数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_PoStockStyleDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_PoStockStyle where HItemID= " + HID + " ", "h_v_Gy_PoStockStyle");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 供应商分类根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_SupTypeDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_SupTypeDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在采购方式数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_SupTypeDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_SupType where HItemID= " + HID + " ", "h_v_Gy_SupType");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 项目费用根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_ProjectMoneyDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_ProjectMoneyDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在项目费用数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_ProjectMoneyDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_ProjectMoney where HItemID= " + HID + " ", "h_v_Gy_ProjectMoney");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 防错装置根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_PreventErrMouldDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_PreventErrMouldDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在防错装置数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_PreventErrMouldDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_PreventErrMould where HItemID= " + HID + " ", "h_v_Gy_PreventErrMould");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 休息日根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_RestDayDetailEdit(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "名称不能为空" };
|
var dataSet = GetGy_RestDayEditDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在休息日数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_RestDayEditDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select * from h_v_Gy_RestDay where HItemID= '" + HID + "' ", "h_v_Gy_RestDay");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 休息日根据登录人获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_RestDayDetail(string HName)
|
{
|
if (string.IsNullOrEmpty(HName))
|
return new ApiResult<DataSet> { code = -1, msg = "名称不能为空" };
|
var dataSet = GetGy_RestDayDb(HName);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在休息日数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_RestDayDb(string HName)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select a.HDeptID,b.HNumber 部门编码,b.HName 部门名称,c.HNumber 组织编码,c.Hname 组织名称 from Gy_Czygl a left join Gy_Department b on a.HDeptID = b.HItemID left join Xt_ORGANIZATIONS c on a.HUSEORGID = c.HItemID where a.Czymc = '" + HName + "' ", "Gy_Czygl");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 保养级别根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_MaintainLevDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_MaintainLevDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在保养级别数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_MaintainLevDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_MaintainLev where HItemID= " + HID + " ", "h_v_Gy_MaintainLev");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 启动检查项目根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_CheckNoteItemDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_CheckNoteItemDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在启动检查项目数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_CheckNoteItemDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_CheckNoteItem where HItemID= " + HID + " ", "h_v_Gy_CheckNoteItem");
|
return dataSet;
|
}
|
|
|
/// <summary>
|
/// 项目类别根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_ProjectClassDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_ProjectClassDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在项目类别数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_ProjectClassDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_ProjectClass where HItemID= " + HID + " ", "h_v_Gy_ProjectClass");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 任务类别根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_TaskClassDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_TaskClassDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在任务类别数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_TaskClassDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_TaskClass where HItemID= " + HID + " ", "h_v_Gy_TaskClass");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 异常反馈类型根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_ErrMsgBackTypeDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_ErrMsgBackTypeDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在异常反馈类型数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_ErrMsgBackTypeDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_ErrMsgBackType where HItemID= " + HID + " ", "h_v_Gy_ErrMsgBackType");
|
return dataSet;
|
}
|
|
/// <summary>
|
///客户分类根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_CusTypeDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_CusTypeDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在客户分类数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_CusTypeDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_CusType where HItemID= " + HID + " ", "h_v_Gy_CusType");
|
return dataSet;
|
}
|
|
/// <summary>
|
///盘点方案根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_StockCheckItemDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_StockCheckItemDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在盘点方案数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
public static DataSet GetGy_StockCheckItemDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_StockCheckItem where HItemID= " + HID + " ", "h_v_Gy_StockCheckItem");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 计量单位根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_UnitBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_UnitDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在计量单位数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetGy_UnitDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Edit_Gy_UnitList where HItemID= " + HID + " ", "h_v_Edit_Gy_UnitList");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 货币设置根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_CurrencyBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_CurrencyDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在货币设置数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetGy_CurrencyDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Edit_Gy_CurrencyList where HItemID= " + HID + " ", "h_v_Edit_Gy_CurrencyList");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 生产资源根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_SourceBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_SourceDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在生产资源数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetGy_SourceDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Edit_IF_SourceList where HItemID= " + HID + " ", "h_v_Edit_IF_SourceList");
|
return dataSet;
|
}
|
|
/// <summary>
|
/// 职员设置根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_EmployeeBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = GetGy_EmployeeDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在职员设置数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet GetGy_EmployeeDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Edit_IF_EmployeeList where HItemID= " + HID + " ", "h_v_Edit_IF_EmployeeList");
|
return dataSet;
|
}
|
|
|
/// <summary>
|
/// 物料设置根据id获取信息
|
/// </summary>
|
public static ApiResult<DataSet> GetGy_MaterialBillDetail(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
var dataSet = Gy_MaterialDb(HID);
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在此物料数据" };
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
|
public static DataSet Gy_MaterialDb(string HID)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Edit_Gy_MaterialList where HItemID= " + HID + " ", "h_v_Edit_Gy_MaterialList");
|
return dataSet;
|
}
|
|
}
|
}
|
