using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Web.Script.Serialization;
|
using Newtonsoft.Json.Linq;
|
using Model;
|
using DBUtility;
|
|
namespace DAL
|
{
|
|
public class POInStockBillServices
|
{
|
public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
/// <summary>
|
/// 要货通知单
|
/// </summary>
|
/// <returns></returns>
|
public DataSet GetPOInStockBill()
|
{
|
try
|
{
|
DataSet dataSet = oCn.RunProcReturn("select * from h_v_Cg_POInStockBillList ", "ClsCg_POInStockBill"); //where hmaterid=" + sqlWhere
|
return dataSet;
|
}
|
catch (Exception)
|
{
|
|
throw;
|
}
|
}
|
/// <summary>
|
/// 采购订单列表
|
/// </summary>
|
/// <returns></returns>
|
public DataSet GetPOOrderBill()
|
{
|
try
|
{
|
DataSet dataSet = oCn.RunProcReturn("select * from h_v_Cg_POOrderBillList ", "h_v_Cg_POOrderBillList"); //where hmaterid=" + sqlWhere
|
return dataSet;
|
}
|
catch (Exception)
|
{
|
|
throw;
|
}
|
}
|
/// <summary>
|
/// 委外订单列表
|
/// </summary>
|
/// <returns></returns>
|
public DataSet GetICSubContractBill()
|
{
|
try
|
{
|
DataSet dataSet = oCn.RunProcReturn("select * from h_v_Kf_EntrustInBillList ", "h_v_Kf_EntrustInBillList"); //where hmaterid=" + sqlWhere
|
return dataSet;
|
}
|
catch (Exception)
|
{
|
|
throw;
|
}
|
}
|
/// <summary>
|
/// 条码档案列表
|
/// </summary>
|
/// <returns></returns>
|
public DataSet GetBarCodeBill()
|
{
|
try
|
{
|
DataSet dataSet = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill ", "h_v_Gy_BarCodeBill"); //where hmaterid=" + sqlWhere
|
return dataSet;
|
}
|
catch (Exception)
|
{
|
|
throw;
|
}
|
}
|
public List<ClsCg_POInStockBill> GetLabelPrintDetail(long sqlWhere)
|
{
|
List<ClsCg_POInStockBill> POInStockBillList = new List<ClsCg_POInStockBill>();
|
try
|
{
|
SqlParameter[] param = new SqlParameter[]
|
{
|
//new SqlParameter("@sqlWhere", sqlWhere)
|
//new SqlParameter("@JDInterID",""),
|
//new SqlParameter("@JDEntryID","")
|
};
|
SqlDataReader reader = SQLHelpers.GetReaderByProcedure("ClsCg_POInStockBill", param);
|
|
while (reader.Read())
|
{
|
POInStockBillList.Add(new ClsCg_POInStockBill()
|
{
|
HInterID = DBUtility.ClsPub.isLong(reader["HInterID"]),
|
HEntryID = DBUtility.ClsPub.isLong(reader["HEntryID"]),
|
|
HDateForWeb = DBUtility.ClsPub.isStrNull(reader["HDateForWeb"]),
|
HAddress = DBUtility.ClsPub.isStrNull(reader["HAddress"]),// varchar(200) --交货地点
|
HSupID = DBUtility.ClsPub.isLong(reader["HSupID"]),// int --供应商 （Gy_Supplier）
|
HCurID = DBUtility.ClsPub.isLong(reader["HCurID"]),// int --币别 (Gy_Currency)
|
HWHID = DBUtility.ClsPub.isLong(reader["HWHID"]),// int --仓库
|
HExRate = DBUtility.ClsPub.isLong(reader["HExRate"]),// money --汇率 (选择完币别带出)
|
HEmpID = DBUtility.ClsPub.isLong(reader["HEmpID"]),// int --业务员 (Gy_Employee)
|
HMangerID = DBUtility.ClsPub.isLong(reader["HMangerID"]),// int --主管 (Gy_Employee)
|
HDeptID = DBUtility.ClsPub.isLong(reader["HDeptID"]),// int --部门 (Gy_Employee)
|
HExplanation = DBUtility.ClsPub.isStrNull(reader["HExplanation"]),// varchar(200) --摘要
|
HInnerBillNo = DBUtility.ClsPub.isStrNull(reader["HInnerBillNo"]),// varchar(50) --内部单据号
|
HMaterID = DBUtility.ClsPub.isLong(reader["HMaterID"]),// int --物料ID (Gy_Material)
|
HUnitID = DBUtility.ClsPub.isLong(reader["HUnitID"]),// int --计量单位 (Gy_Unit)
|
HQty = DBUtility.ClsPub.isLong(reader["HQty"]),// dec(18,8) --要货数量
|
HCheckQty = DBUtility.ClsPub.isLong(reader["HCheckQty"]), //检验数
|
HPassQty = DBUtility.ClsPub.isLong(reader["HPassQty"]), //合格数
|
HBadQty = DBUtility.ClsPub.isLong(reader["HBadQty"]), //不合格数
|
HPrice = DBUtility.ClsPub.isLong(reader["HPrice"]),// dec(18,8) --原币单价
|
HMoney = DBUtility.ClsPub.isLong(reader["HMoney"]),// dec(18,8) --原币金额
|
// HWHID// --收料仓库
|
HPOOrderInterID = DBUtility.ClsPub.isLong(reader["HPOOrderInterID"]),//
|
HPOOrderEntryID = DBUtility.ClsPub.isLong(reader["HPOOrderEntryID"]),//
|
HPOOrderBillNo = DBUtility.ClsPub.isStrNull(reader["HPOOrderBillNo"]),//
|
HDate = DBUtility.ClsPub.isDate(reader["HDate"]), //要货时间
|
HState = DBUtility.ClsPub.isLong(reader["HState"]),
|
HBackDate = DBUtility.ClsPub.isStrNull(reader["HBackDate"]),
|
HBacker = DBUtility.ClsPub.isStrNull(reader["HBacker"]),
|
HBillerID = DBUtility.ClsPub.isLong(reader["HBillerID"]),
|
HBillNo = DBUtility.ClsPub.isStrNull(reader["HBillNo"]),
|
HBillStatus = DBUtility.ClsPub.isInt(reader["HBillStatus"]),
|
HBillSubType = DBUtility.ClsPub.isStrNull(reader["HBillSubType"]),
|
HBillType = DBUtility.ClsPub.isStrNull(reader["HBillType"]),
|
HCheckDate = DBUtility.ClsPub.isStrNull(reader["HCheckDate"]),
|
HChecker = DBUtility.ClsPub.isStrNull(reader["HChecker"]),
|
HCheckFlowID = DBUtility.ClsPub.isLong(reader["HCheckFlowID"]),
|
HCheckItemNextID = DBUtility.ClsPub.isLong(reader["HCheckItemNextID"]),
|
HCheckItemNowID = DBUtility.ClsPub.isLong(reader["HCheckItemNowID"]),
|
HCloseDate = DBUtility.ClsPub.isStrNull(reader["HCloseDate"]),
|
// HCloseMan= DBUtility.ClsPub.isLong(reader["HEntryID"]),
|
HCloseType = DBUtility.ClsPub.isBool(reader["HCloseType"]),
|
//HDate= DBUtility.ClsPub.isLong(reader["HEntryID"]),
|
HDeleteDate = DBUtility.ClsPub.isStrNull(reader["HDeleteDate"]),
|
HDeleteMan = DBUtility.ClsPub.isStrNull(reader["HDeleteMan"]),
|
HEmpCode = DBUtility.ClsPub.isStrNull(reader["HEmpCode"]),
|
HMainSourceBillNo = DBUtility.ClsPub.isStrNull(reader["HMainSourceBillNo"]),
|
HMainSourceBillType = DBUtility.ClsPub.isStrNull(reader["HMainSourceBillType"]),
|
HMainSourceEntryID = DBUtility.ClsPub.isLong(reader["HMainSourceEntryID"]),
|
HMainSourceInterID = DBUtility.ClsPub.isLong(reader["HMainSourceInterID"]),
|
HMakeDate = DBUtility.ClsPub.isStrNull(reader["HMakeDate"]),
|
HMaker = DBUtility.ClsPub.isStrNull(reader["HMaker"]),
|
HPeriod = DBUtility.ClsPub.isLong(reader["HPeriod"]),
|
HRemark = DBUtility.ClsPub.isStrNull(reader["HRemark"]),
|
HUpDateDate = DBUtility.ClsPub.isStrNull(reader["HUpDateDate"]),
|
HUpDater = DBUtility.ClsPub.isStrNull(reader["HUpDater"]),
|
HYear = DBUtility.ClsPub.isLong(reader["HYear"]),
|
// HCloseMan= DBUtility.ClsPub.isLong(reader["HEntryID"]),
|
// HCloseType= DBUtility.ClsPub.isLong(reader["HEntryID"]),
|
HEntryCloseDate = DBUtility.ClsPub.isDate(reader["HEntryCloseDate"]),
|
HRelationMoney = DBUtility.ClsPub.isLong(reader["HRelationMoney"]),
|
HRelationQty = DBUtility.ClsPub.isLong(reader["HRelationQty"]),
|
// HRemark= DBUtility.ClsPub.isStrNull(reader["HEntryID"]),
|
HSourceBillNo = DBUtility.ClsPub.isStrNull(reader["HSourceBillNo"]),
|
HSourceBillType = DBUtility.ClsPub.isStrNull(reader["HSourceBillType"]),
|
HSourceEntryID = DBUtility.ClsPub.isLong(reader["HSourceEntryID"]),
|
HSourceInterID = DBUtility.ClsPub.isLong(reader["HSourceInterID"]),
|
});
|
}
|
reader.Close();
|
return POInStockBillList;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
|
}
|
}
|
