808 lines
40 KiB
C#
808 lines
40 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using WMS.IData;using Oracle.ManagedDataAccess.Client;
|
|
using WMS.Model.RK;
|
|
|
|
using WMS.DBUtility;
|
|
using System.Data;
|
|
using WMS.IData.IRK;
|
|
|
|
namespace WMS.SqlServerData.RKData
|
|
{
|
|
public class ReceveData : IReceve
|
|
{
|
|
/// <summary>
|
|
/// 写到货单
|
|
/// </summary>
|
|
/// <param name="model"></param>
|
|
public void UpdateErpDoc(ReceivingModel model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update T_RK_WARE_NOTICE set ");
|
|
strSql.Append("AMOUNT= ISNULL(AMOUNT,0)+:AMOUNT,");
|
|
strSql.Append("REAL_DELIVERY_DATE=:REAL_DELIVERY_DATE,");
|
|
strSql.Append("RECIPIENTS=:RECIPIENTS,");
|
|
strSql.Append("CLASS_GROUP=:CLASS_GROUP,");
|
|
strSql.Append("STATE=:STATE");
|
|
strSql.Append(" where WAREHOUSING_ID=:WAREHOUSING_ID ");
|
|
OracleParameter[] noParameters = {
|
|
new OracleParameter(":AMOUNT", OracleDbType.Decimal),
|
|
new OracleParameter(":REAL_DELIVERY_DATE", OracleDbType.Date),
|
|
new OracleParameter(":RECIPIENTS",OracleDbType.Varchar2),
|
|
new OracleParameter(":CLASS_GROUP",OracleDbType.Varchar2),
|
|
new OracleParameter(":STATE",OracleDbType.Varchar2),
|
|
new OracleParameter(":WAREHOUSING_ID",OracleDbType.Varchar2),
|
|
};
|
|
noParameters[0].Value = model.ARR_NUM_SUM;
|
|
noParameters[1].Value = model.RECE_DATE;
|
|
noParameters[2].Value = model.RECE_MAN;
|
|
noParameters[3].Value = model.TEAM;
|
|
noParameters[4].Value = "2";
|
|
noParameters[5].Value = model.NOTICE_ID;
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString());
|
|
}
|
|
public void AddReciveGoods(ReceivingModel model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("insert into T_RK_RECEIVING(");
|
|
strSql.Append("RECE_ID,NOTICE_ID,TEAM,RECE_DATE,DRIVER,RECE_MAN,CAR_ID,VERSION,PRINT_MAN,PRINT_DATE,PRINT_NUM,ENTRY_MAN,ENTRY_DATE,STATIC,REMARK,BUY_NUM_SUM,ARR_NUM_SUM,SHELVE_NUM_SUM,STO_NUM_SUM,PROVIDER_ID,SHIPPERS,ORI_BILL)");
|
|
strSql.Append(" values (");
|
|
strSql.Append(":RECE_ID,:NOTICE_ID,:TEAM,:RECE_DATE,:DRIVER,:RECE_MAN,:CAR_ID,:VERSION,:PRINT_MAN,:PRINT_DATE,:PRINT_NUM,:ENTRY_MAN,:ENTRY_DATE,:STATIC,:REMARK,:BUY_NUM_SUM,:ARR_NUM_SUM,:SHELVE_NUM_SUM,:STO_NUM_SUM,:PROVIDER_ID,:SHIPPERS,:ORI_BILL)");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":NOTICE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":TEAM",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_DATE", OracleDbType.Date),
|
|
new OracleParameter(":DRIVER",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_MAN",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":VERSION",OracleDbType.Varchar2),
|
|
new OracleParameter(":PRINT_MAN",OracleDbType.Varchar2),
|
|
new OracleParameter(":PRINT_DATE", OracleDbType.Date),
|
|
new OracleParameter(":PRINT_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ENTRY_MAN",OracleDbType.Varchar2),
|
|
new OracleParameter(":ENTRY_DATE", OracleDbType.Date),
|
|
new OracleParameter(":STATIC",OracleDbType.Varchar2),
|
|
new OracleParameter(":REMARK",OracleDbType.Varchar2),
|
|
new OracleParameter(":BUY_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ARR_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":SHELVE_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":STO_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":PROVIDER_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":SHIPPERS",OracleDbType.Varchar2),
|
|
new OracleParameter(":ORI_BILL",OracleDbType.Varchar2),
|
|
};
|
|
|
|
parameters[0].Value = model.RECE_ID;
|
|
parameters[1].Value = model.NOTICE_ID;
|
|
parameters[2].Value = model.TEAM;
|
|
parameters[3].Value = model.RECE_DATE;
|
|
parameters[4].Value = model.DRIVER;
|
|
parameters[5].Value = model.RECE_MAN;
|
|
parameters[6].Value = model.CAR_ID;
|
|
parameters[7].Value = model.VERSION;
|
|
parameters[8].Value = model.PRINT_MAN;
|
|
parameters[9].Value = model.PRINT_DATE;
|
|
parameters[10].Value = model.PRINT_NUM;
|
|
parameters[11].Value = model.ENTRY_MAN;
|
|
parameters[12].Value = model.ENTRY_DATE;
|
|
parameters[13].Value = model.STATIC;
|
|
parameters[14].Value = model.REMARK;
|
|
parameters[15].Value = model.BUY_NUM_SUM;
|
|
parameters[16].Value = model.ARR_NUM_SUM;
|
|
parameters[17].Value = model.SHELVE_NUM_SUM;
|
|
parameters[18].Value = model.STO_NUM_SUM;
|
|
parameters[19].Value = model.PROVIDER_ID;
|
|
parameters[20].Value = model.SHIPPERS;
|
|
parameters[21].Value = model.ORI_BILL;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString());
|
|
}
|
|
/// <summary>
|
|
/// 增加一条数据
|
|
/// </summary>
|
|
public void AddGodsInfodList(ReceivingInfoModel infoModel)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
strSql.Append("insert into T_RK_RECEIVING_INFO(");
|
|
strSql.Append("RECE_ID,GOODS_ID,BUY_NUM,ARR_NUM,SHELVE_NUM,MADE_DATE,STO_TRAY,RECE_VOLUEM,GRO_WEIGHT,NET_WEIGHT,RECE_MONEY,UNIT,VOLUME_UNIT,STO_NUM,OPERATORID,OPERATEDATE,PRICE,SCALE_UNIT)");
|
|
strSql.Append(" values (");
|
|
strSql.Append(":RECE_ID,:GOODS_ID,:BUY_NUM,:ARR_NUM,:SHELVE_NUM,:MADE_DATE,:STO_TRAY,:RECE_VOLUEM,:GRO_WEIGHT,:NET_WEIGHT,:RECE_MONEY,:UNIT,:VOLUME_UNIT,:STO_NUM,:OPERATORID,:OPERATEDATE,:PRICE,:SCALE_UNIT)");
|
|
OracleParameter[] infoParameters = {
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":GOODS_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":BUY_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ARR_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":SHELVE_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":MADE_DATE", OracleDbType.Date),
|
|
new OracleParameter(":STO_TRAY",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_VOLUEM", OracleDbType.Decimal),
|
|
new OracleParameter(":GRO_WEIGHT", OracleDbType.Decimal),
|
|
new OracleParameter(":NET_WEIGHT", OracleDbType.Decimal),
|
|
new OracleParameter(":RECE_MONEY", OracleDbType.Decimal),
|
|
new OracleParameter(":UNIT",OracleDbType.Varchar2),
|
|
new OracleParameter(":VOLUME_UNIT", OracleDbType.Decimal),
|
|
new OracleParameter(":STO_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":OPERATORID",OracleDbType.Varchar2),
|
|
new OracleParameter(":OPERATEDATE", OracleDbType.Date),
|
|
new OracleParameter(":PRICE", OracleDbType.Decimal),
|
|
new OracleParameter(":SCALE_UNIT",OracleDbType.Varchar2),
|
|
};
|
|
infoParameters[0].Value = infoModel.RECE_ID;
|
|
infoParameters[1].Value = infoModel.GOODS_ID;
|
|
infoParameters[2].Value = infoModel.BUY_NUM;
|
|
infoParameters[3].Value = infoModel.ARR_NUM;
|
|
infoParameters[4].Value = infoModel.SHELVE_NUM;
|
|
infoParameters[5].Value = infoModel.MADE_DATE;
|
|
infoParameters[6].Value = infoModel.STO_TRAY;
|
|
infoParameters[7].Value = infoModel.RECE_VOLUEM;
|
|
infoParameters[8].Value = infoModel.GRO_WEIGHT;
|
|
infoParameters[9].Value = infoModel.NET_WEIGHT;
|
|
infoParameters[10].Value = infoModel.RECE_MONEY;
|
|
infoParameters[11].Value = infoModel.UNIT;
|
|
infoParameters[12].Value = infoModel.VOLUME_UNIT;
|
|
infoParameters[13].Value = infoModel.STO_NUM;
|
|
infoParameters[14].Value = infoModel.OPERATORID;
|
|
infoParameters[15].Value = infoModel.OPERATEDATE;
|
|
infoParameters[16].Value = infoModel.PRICE;
|
|
infoParameters[17].Value = infoModel.SCALE_UNIT;
|
|
|
|
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString());
|
|
|
|
// SystemDataObject.Instance.ExecuteList(sqlList, paraList);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 更新一条数据
|
|
/// </summary>
|
|
public void Update(ReceivingModel model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
strSql.Append("update T_RK_RECEIVING set ");
|
|
strSql.Append("NOTICE_ID=:NOTICE_ID,");
|
|
strSql.Append("TEAM=:TEAM,");
|
|
strSql.Append("RECE_DATE=:RECE_DATE,");
|
|
strSql.Append("DRIVER=:DRIVER,");
|
|
strSql.Append("RECE_MAN=:RECE_MAN,");
|
|
strSql.Append("CAR_ID=:CAR_ID,");
|
|
strSql.Append("VERSION=:VERSION,");
|
|
strSql.Append("PRINT_MAN=:PRINT_MAN,");
|
|
strSql.Append("PRINT_DATE=:PRINT_DATE,");
|
|
strSql.Append("PRINT_NUM=:PRINT_NUM,");
|
|
strSql.Append("ENTRY_MAN=:ENTRY_MAN,");
|
|
strSql.Append("ENTRY_DATE=:ENTRY_DATE,");
|
|
strSql.Append("STATIC=:STATIC,");
|
|
strSql.Append("REMARK=:REMARK,");
|
|
strSql.Append("BUY_NUM_SUM=:BUY_NUM_SUM,");
|
|
strSql.Append("ARR_NUM_SUM= ISNULL(ARR_NUM_SUM,0)+:ARR_NUM_SUM,");
|
|
strSql.Append("SHELVE_NUM_SUM=:SHELVE_NUM_SUM,");
|
|
strSql.Append("STO_NUM_SUM=:STO_NUM_SUM,");
|
|
strSql.Append("PROVIDER_ID=:PROVIDER_ID,");
|
|
strSql.Append("SHIPPERS=:SHIPPERS,");
|
|
strSql.Append("ORI_BILL=:ORI_BILL");
|
|
strSql.Append(" where RECE_ID=:RECE_ID ");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":NOTICE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":TEAM",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_DATE", OracleDbType.Date),
|
|
new OracleParameter(":DRIVER",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_MAN",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":VERSION",OracleDbType.Varchar2),
|
|
new OracleParameter(":PRINT_MAN",OracleDbType.Varchar2),
|
|
new OracleParameter(":PRINT_DATE", OracleDbType.Date),
|
|
new OracleParameter(":PRINT_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ENTRY_MAN",OracleDbType.Varchar2),
|
|
new OracleParameter(":ENTRY_DATE", OracleDbType.Date),
|
|
new OracleParameter(":STATIC",OracleDbType.Varchar2),
|
|
new OracleParameter(":REMARK",OracleDbType.Varchar2),
|
|
new OracleParameter(":BUY_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ARR_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":SHELVE_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":STO_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":PROVIDER_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":SHIPPERS",OracleDbType.Varchar2),
|
|
new OracleParameter(":ORI_BILL",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2)
|
|
};
|
|
parameters[0].Value = model.NOTICE_ID;
|
|
parameters[1].Value = model.TEAM;
|
|
parameters[2].Value = model.RECE_DATE;
|
|
parameters[3].Value = model.DRIVER;
|
|
parameters[4].Value = model.RECE_MAN;
|
|
parameters[5].Value = model.CAR_ID;
|
|
parameters[6].Value = model.VERSION;
|
|
parameters[7].Value = model.PRINT_MAN;
|
|
parameters[8].Value = model.PRINT_DATE;
|
|
parameters[9].Value = model.PRINT_NUM;
|
|
parameters[10].Value = model.ENTRY_MAN;
|
|
parameters[11].Value = model.ENTRY_DATE;
|
|
parameters[12].Value = model.STATIC;
|
|
parameters[13].Value = model.REMARK;
|
|
parameters[14].Value = model.BUY_NUM_SUM;
|
|
parameters[15].Value = model.ARR_NUM_SUM;
|
|
parameters[16].Value = model.SHELVE_NUM_SUM;
|
|
parameters[17].Value = model.STO_NUM_SUM;
|
|
parameters[18].Value = model.PROVIDER_ID;
|
|
parameters[19].Value = model.SHIPPERS;
|
|
parameters[20].Value = model.ORI_BILL;
|
|
parameters[21].Value = model.RECE_ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新一条数据
|
|
/// </summary>
|
|
public void Update(ReceivingModel model, List<ReceivingInfoModel> infoModelList)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
List<string> sqlList = new List<string>();
|
|
List<OracleParameter[]> paraList = new List<OracleParameter[]>();
|
|
|
|
if (!string.IsNullOrEmpty(model.RECE_ID))
|
|
{
|
|
strSql.Append("update T_RK_RECEIVING set ");
|
|
strSql.Append("NOTICE_ID=:NOTICE_ID,");
|
|
strSql.Append("TEAM=:TEAM,");
|
|
strSql.Append("RECE_DATE=:RECE_DATE,");
|
|
strSql.Append("DRIVER=:DRIVER,");
|
|
strSql.Append("RECE_MAN=:RECE_MAN,");
|
|
strSql.Append("CAR_ID=:CAR_ID,");
|
|
strSql.Append("VERSION=:VERSION,");
|
|
strSql.Append("PRINT_MAN=:PRINT_MAN,");
|
|
strSql.Append("PRINT_DATE=:PRINT_DATE,");
|
|
strSql.Append("PRINT_NUM=:PRINT_NUM,");
|
|
strSql.Append("ENTRY_MAN=:ENTRY_MAN,");
|
|
strSql.Append("ENTRY_DATE=:ENTRY_DATE,");
|
|
strSql.Append("STATIC=:STATIC,");
|
|
strSql.Append("REMARK=:REMARK,");
|
|
strSql.Append("BUY_NUM_SUM=:BUY_NUM_SUM,");
|
|
strSql.Append("ARR_NUM_SUM= ISNULL(ARR_NUM_SUM,0)+:ARR_NUM_SUM,");
|
|
strSql.Append("SHELVE_NUM_SUM=:SHELVE_NUM_SUM,");
|
|
strSql.Append("STO_NUM_SUM=:STO_NUM_SUM,");
|
|
strSql.Append("PROVIDER_ID=:PROVIDER_ID,");
|
|
strSql.Append("SHIPPERS=:SHIPPERS,");
|
|
strSql.Append("ORI_BILL=:ORI_BILL");
|
|
strSql.Append(" where RECE_ID=:RECE_ID ");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":NOTICE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":TEAM",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_DATE", OracleDbType.Date),
|
|
new OracleParameter(":DRIVER",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_MAN",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":VERSION",OracleDbType.Varchar2),
|
|
new OracleParameter(":PRINT_MAN",OracleDbType.Varchar2),
|
|
new OracleParameter(":PRINT_DATE", OracleDbType.Date),
|
|
new OracleParameter(":PRINT_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ENTRY_MAN",OracleDbType.Varchar2),
|
|
new OracleParameter(":ENTRY_DATE", OracleDbType.Date),
|
|
new OracleParameter(":STATIC",OracleDbType.Varchar2),
|
|
new OracleParameter(":REMARK",OracleDbType.Varchar2),
|
|
new OracleParameter(":BUY_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ARR_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":SHELVE_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":STO_NUM_SUM", OracleDbType.Decimal),
|
|
new OracleParameter(":PROVIDER_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":SHIPPERS",OracleDbType.Varchar2),
|
|
new OracleParameter(":ORI_BILL",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2)
|
|
};
|
|
parameters[0].Value = model.NOTICE_ID;
|
|
parameters[1].Value = model.TEAM;
|
|
parameters[2].Value = model.RECE_DATE;
|
|
parameters[3].Value = model.DRIVER;
|
|
parameters[4].Value = model.RECE_MAN;
|
|
parameters[5].Value = model.CAR_ID;
|
|
parameters[6].Value = model.VERSION;
|
|
parameters[7].Value = model.PRINT_MAN;
|
|
parameters[8].Value = model.PRINT_DATE;
|
|
parameters[9].Value = model.PRINT_NUM;
|
|
parameters[10].Value = model.ENTRY_MAN;
|
|
parameters[11].Value = model.ENTRY_DATE;
|
|
parameters[12].Value = model.STATIC;
|
|
parameters[13].Value = model.REMARK;
|
|
parameters[14].Value = model.BUY_NUM_SUM;
|
|
parameters[15].Value = model.ARR_NUM_SUM;
|
|
parameters[16].Value = model.SHELVE_NUM_SUM;
|
|
parameters[17].Value = model.STO_NUM_SUM;
|
|
parameters[18].Value = model.PROVIDER_ID;
|
|
parameters[19].Value = model.SHIPPERS;
|
|
parameters[20].Value = model.ORI_BILL;
|
|
parameters[21].Value = model.RECE_ID;
|
|
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(parameters);
|
|
strSql.Clear();
|
|
}
|
|
|
|
foreach (ReceivingInfoModel infoModel in infoModelList)
|
|
{
|
|
strSql.Append("update T_RK_RECEIVING_INFO set ");
|
|
strSql.Append("BUY_NUM=:BUY_NUM,");
|
|
strSql.Append("ARR_NUM=:ARR_NUM,");
|
|
strSql.Append("SHELVE_NUM=:SHELVE_NUM,");
|
|
strSql.Append("MADE_DATE=:MADE_DATE,");
|
|
strSql.Append("STO_TRAY=:STO_TRAY,");
|
|
strSql.Append("RECE_VOLUEM=:RECE_VOLUEM,");
|
|
strSql.Append("GRO_WEIGHT=:GRO_WEIGHT,");
|
|
strSql.Append("NET_WEIGHT=:NET_WEIGHT,");
|
|
strSql.Append("RECE_MONEY=:RECE_MONEY,");
|
|
strSql.Append("UNIT=:UNIT,");
|
|
strSql.Append("VOLUME_UNIT=:VOLUME_UNIT,");
|
|
strSql.Append("STO_NUM=:STO_NUM,");
|
|
strSql.Append("OPERATORID=:OPERATORID,");
|
|
strSql.Append("OPERATEDATE=:OPERATEDATE,");
|
|
strSql.Append("PRICE=:PRICE,");
|
|
strSql.Append("SCALE_UNIT=:SCALE_UNIT");
|
|
strSql.Append(" where RECE_ID=:RECE_ID and GOODS_ID=:GOODS_ID");
|
|
OracleParameter[] infoParameters = {
|
|
new OracleParameter(":BUY_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ARR_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":SHELVE_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":MADE_DATE", OracleDbType.Date),
|
|
new OracleParameter(":STO_TRAY",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_VOLUEM", OracleDbType.Decimal),
|
|
new OracleParameter(":GRO_WEIGHT", OracleDbType.Decimal),
|
|
new OracleParameter(":NET_WEIGHT", OracleDbType.Decimal),
|
|
new OracleParameter(":RECE_MONEY", OracleDbType.Decimal),
|
|
new OracleParameter(":UNIT",OracleDbType.Varchar2),
|
|
new OracleParameter(":VOLUME_UNIT", OracleDbType.Decimal),
|
|
new OracleParameter(":STO_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":OPERATORID",OracleDbType.Varchar2),
|
|
new OracleParameter(":OPERATEDATE", OracleDbType.Date),
|
|
new OracleParameter(":PRICE", OracleDbType.Decimal),
|
|
new OracleParameter(":SCALE_UNIT",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":GOODS_ID",OracleDbType.Varchar2)};
|
|
|
|
infoParameters[0].Value = infoModel.BUY_NUM;
|
|
infoParameters[1].Value = infoModel.ARR_NUM;
|
|
infoParameters[2].Value = infoModel.SHELVE_NUM;
|
|
infoParameters[3].Value = infoModel.MADE_DATE;
|
|
infoParameters[4].Value = infoModel.STO_TRAY;
|
|
infoParameters[5].Value = infoModel.RECE_VOLUEM;
|
|
infoParameters[6].Value = infoModel.GRO_WEIGHT;
|
|
infoParameters[7].Value = infoModel.NET_WEIGHT;
|
|
infoParameters[8].Value = infoModel.RECE_MONEY;
|
|
infoParameters[9].Value = infoModel.UNIT;
|
|
infoParameters[10].Value = infoModel.VOLUME_UNIT;
|
|
infoParameters[11].Value = infoModel.STO_NUM;
|
|
infoParameters[12].Value = infoModel.OPERATORID;
|
|
infoParameters[13].Value = infoModel.OPERATEDATE;
|
|
infoParameters[14].Value = infoModel.PRICE;
|
|
infoParameters[15].Value = infoModel.SCALE_UNIT;
|
|
infoParameters[16].Value = infoModel.RECE_ID;
|
|
infoParameters[17].Value = infoModel.GOODS_ID;
|
|
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(infoParameters);
|
|
strSql.Clear();
|
|
}
|
|
if (!string.IsNullOrEmpty(model.NOTICE_ID))
|
|
{
|
|
strSql.Append("update T_RK_WARE_NOTICE set ");
|
|
strSql.Append("AMOUNT= ISNULL(AMOUNT,0)+:AMOUNT,");
|
|
strSql.Append("REAL_DELIVERY_DATE=:REAL_DELIVERY_DATE,");
|
|
strSql.Append("RECIPIENTS=:RECIPIENTS,");
|
|
strSql.Append("CLASS_GROUP=:CLASS_GROUP");
|
|
strSql.Append(" where WAREHOUSING_ID=:WAREHOUSING_ID ");
|
|
OracleParameter[] noParameters = {
|
|
new OracleParameter(":AMOUNT", OracleDbType.Decimal),
|
|
new OracleParameter(":REAL_DELIVERY_DATE", OracleDbType.Date),
|
|
new OracleParameter(":RECIPIENTS",OracleDbType.Varchar2),
|
|
new OracleParameter(":CLASS_GROUP",OracleDbType.Varchar2),
|
|
new OracleParameter(":WAREHOUSING_ID",OracleDbType.Varchar2),
|
|
};
|
|
noParameters[0].Value = model.ARR_NUM_SUM;
|
|
noParameters[1].Value = model.RECE_DATE;
|
|
noParameters[2].Value = model.RECE_MAN;
|
|
noParameters[3].Value = model.TEAM;
|
|
noParameters[4].Value = model.NOTICE_ID;
|
|
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(noParameters);
|
|
strSql.Clear();
|
|
}
|
|
|
|
SystemDataObject.Instance.ExecuteList(sqlList, paraList);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除收货录入数据
|
|
/// </summary>
|
|
/// <param name="RECE_ID">单据号</param>
|
|
/// <param name="flag">联动删除</param>
|
|
/// <returns></returns>
|
|
public void Delete(ReceivingModel model, List<ReceivingInfoModel> listModel, bool flag)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
List<string> sqlList = new List<string>();
|
|
List<OracleParameter[]> paraList = new List<OracleParameter[]>();
|
|
|
|
foreach (ReceivingInfoModel infomodel in listModel)
|
|
{
|
|
strSql.Append("delete from T_RK_RECEIVING_INFO ");
|
|
strSql.Append(" where RECE_ID=:RECE_ID and GOODS_ID=:GOODS_ID");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":GOODS_ID",OracleDbType.Varchar2)
|
|
};
|
|
parameters[0].Value = infomodel.RECE_ID;
|
|
parameters[1].Value = infomodel.GOODS_ID;
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(parameters);
|
|
strSql.Clear();
|
|
}
|
|
if (flag)
|
|
{
|
|
strSql.Append("delete from T_RK_RECEIVING ");
|
|
strSql.Append(" where RECE_ID=:RECE_ID ");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2)};
|
|
parameters[0].Value = model.RECE_ID;
|
|
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(parameters);
|
|
strSql.Clear();
|
|
if (!string.IsNullOrEmpty(model.NOTICE_ID))
|
|
{
|
|
strSql.Append("update T_RK_WARE_NOTICE set ");
|
|
strSql.Append("AMOUNT= ISNULL(AMOUNT,0)-:AMOUNT,");
|
|
strSql.Append("REAL_DELIVERY_DATE=:REAL_DELIVERY_DATE,");
|
|
strSql.Append("RECIPIENTS=:RECIPIENTS,");
|
|
strSql.Append("CLASS_GROUP=:CLASS_GROUP");
|
|
strSql.Append(" where WAREHOUSING_ID=:WAREHOUSING_ID ");
|
|
OracleParameter[] noParameters = {
|
|
new OracleParameter(":AMOUNT", OracleDbType.Decimal),
|
|
new OracleParameter(":REAL_DELIVERY_DATE", OracleDbType.Date),
|
|
new OracleParameter(":RECIPIENTS",OracleDbType.Varchar2),
|
|
new OracleParameter(":CLASS_GROUP",OracleDbType.Varchar2),
|
|
new OracleParameter(":WAREHOUSING_ID",OracleDbType.Varchar2),
|
|
};
|
|
noParameters[0].Value = model.ARR_NUM_SUM;
|
|
noParameters[1].Value = model.RECE_DATE;
|
|
noParameters[2].Value = model.RECE_MAN;
|
|
noParameters[3].Value = model.TEAM;
|
|
noParameters[4].Value = model.NOTICE_ID;
|
|
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(noParameters);
|
|
strSql.Clear();
|
|
}
|
|
}
|
|
|
|
|
|
SystemDataObject.Instance.ExecuteList(sqlList, paraList);
|
|
|
|
}
|
|
|
|
/// <summary>
|
|
/// 作废收货录入数据
|
|
/// </summary>
|
|
/// <param name="RECE_ID">单据号</param>
|
|
/// <returns></returns>
|
|
public void Cancel(ReceivingModel model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
List<string> sqlList = new List<string>();
|
|
List<OracleParameter[]> paraList = new List<OracleParameter[]>();
|
|
|
|
if (!string.IsNullOrEmpty(model.RECE_ID))
|
|
{
|
|
strSql.Append("update T_RK_RECEIVING set ");
|
|
strSql.Append("STATIC=:STATIC");
|
|
strSql.Append(" where RECE_ID=:RECE_ID ");
|
|
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":STATIC",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2),
|
|
};
|
|
parameters[0].Value = "2";
|
|
parameters[1].Value = model.RECE_ID;
|
|
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(parameters);
|
|
strSql.Clear();
|
|
}
|
|
if (!string.IsNullOrEmpty(model.NOTICE_ID))
|
|
{
|
|
strSql.Append("update T_RK_WARE_NOTICE set ");
|
|
strSql.Append("AMOUNT= ISNULL(AMOUNT,0)-:AMOUNT,");
|
|
strSql.Append("REAL_DELIVERY_DATE=:REAL_DELIVERY_DATE,");
|
|
strSql.Append("RECIPIENTS=:RECIPIENTS,");
|
|
strSql.Append("CLASS_GROUP=:CLASS_GROUP,");
|
|
strSql.Append("STATE=:STATE");
|
|
strSql.Append(" where WAREHOUSING_ID=:WAREHOUSING_ID ");
|
|
OracleParameter[] noParameters = {
|
|
new OracleParameter(":AMOUNT", OracleDbType.Decimal),
|
|
new OracleParameter(":REAL_DELIVERY_DATE", OracleDbType.Date),
|
|
new OracleParameter(":RECIPIENTS",OracleDbType.Varchar2),
|
|
new OracleParameter(":CLASS_GROUP",OracleDbType.Varchar2),
|
|
new OracleParameter(":STATE",OracleDbType.Varchar2),
|
|
new OracleParameter(":WAREHOUSING_ID",OracleDbType.Varchar2),
|
|
};
|
|
noParameters[0].Value = model.ARR_NUM_SUM;
|
|
noParameters[1].Value = "0001-01-01";
|
|
noParameters[2].Value = "";
|
|
noParameters[3].Value = "";
|
|
noParameters[4].Value = "1";
|
|
noParameters[5].Value = model.NOTICE_ID;
|
|
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(noParameters);
|
|
strSql.Clear();
|
|
}
|
|
|
|
SystemDataObject.Instance.ExecuteList(sqlList, paraList);
|
|
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获得数据列表
|
|
/// </summary>
|
|
public DataTable GetList(ReceivingModel model)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select t.RECE_ID,");
|
|
strSql.Append("t.NOTICE_ID,");
|
|
strSql.Append("t.TEAM,");
|
|
strSql.Append("t.RECE_DATE,");
|
|
strSql.Append("t.DRIVER,");
|
|
strSql.Append("t.RECE_MAN,");
|
|
strSql.Append("a.NAME RECE_MAN_NAME,");
|
|
strSql.Append("t.CAR_ID,");
|
|
strSql.Append("t.VERSION,");
|
|
strSql.Append("t.PRINT_MAN,");
|
|
strSql.Append("b.NAME PRINT_MAN_NAME,");
|
|
strSql.Append("t.PRINT_DATE,");
|
|
strSql.Append("t.PRINT_NUM,");
|
|
strSql.Append("t.ENTRY_MAN,");
|
|
strSql.Append("c.NAME ENTRY_MAN_NAME,");
|
|
strSql.Append("t.ENTRY_DATE,");
|
|
strSql.Append("t.STATIC,");
|
|
strSql.Append("t.REMARK, ");
|
|
strSql.Append("t.BUY_NUM_SUM,");
|
|
strSql.Append("t.ARR_NUM_SUM,");
|
|
strSql.Append("t.SHELVE_NUM_SUM,");
|
|
strSql.Append("t.STO_NUM_SUM,");
|
|
strSql.Append("t.PROVIDER_ID,");
|
|
strSql.Append("d.PROVIDER_NAME PROVIDER_NAME,");
|
|
strSql.Append("t.SHIPPERS,");
|
|
strSql.Append("t.ORI_BILL ");
|
|
strSql.Append(" FROM T_RK_RECEIVING t");
|
|
strSql.Append(" LEFT JOIN T_BASE_USERINFO a ON a.USER_ID = t.RECE_MAN");
|
|
strSql.Append(" LEFT JOIN T_BASE_USERINFO b ON b.USER_ID = t.PRINT_MAN");
|
|
strSql.Append(" LEFT JOIN T_BASE_USERINFO c ON c.USER_ID = t.ENTRY_MAN");
|
|
strSql.Append(" LEFT JOIN T_BASE_PROVIDER_DICTIONARY d ON t.PROVIDER_ID = d.PROVIDER_ID");
|
|
strSql.Append(" where 1 =1 ");
|
|
if (!string.IsNullOrEmpty(model.RECE_ID))
|
|
{
|
|
strSql.Append(" and RECE_ID like'%" + model.RECE_ID + "%'");
|
|
}
|
|
if (!string.IsNullOrEmpty(model.NOTICE_ID))
|
|
{
|
|
strSql.Append(" and NOTICE_ID like'%" + model.NOTICE_ID + "%'");
|
|
}
|
|
if (!string.IsNullOrEmpty(model.STATIC))
|
|
{
|
|
strSql.Append(" and STATIC ='" + model.STATIC + "'");
|
|
}
|
|
else
|
|
{
|
|
strSql.Append(" and STATIC !='" +"2"+ "'");
|
|
}
|
|
strSql.Append(" order by RECE_DATE desc");
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|
}
|
|
/// <summary>
|
|
/// 获得数据列表
|
|
/// </summary>
|
|
public DataTable GetInfoList(string strWhere)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select ");
|
|
strSql.Append("t.RECE_ID,");
|
|
strSql.Append("t.GOODS_ID,");
|
|
strSql.Append("a.GOODS_NAME GOODS_NAME,");
|
|
strSql.Append("t.BUY_NUM,");
|
|
strSql.Append("t.ARR_NUM,");
|
|
strSql.Append("t.SHELVE_NUM,");
|
|
strSql.Append("t.MADE_DATE,");
|
|
strSql.Append("t.STO_TRAY,");
|
|
strSql.Append("t.RECE_VOLUEM,");
|
|
strSql.Append("t.GRO_WEIGHT,");
|
|
strSql.Append("t.NET_WEIGHT,");
|
|
strSql.Append("t.RECE_MONEY,");
|
|
strSql.Append("t.UNIT,");
|
|
strSql.Append("t.VOLUME_UNIT,");
|
|
strSql.Append("t.STO_NUM,");
|
|
strSql.Append("t.OPERATORID,");
|
|
strSql.Append("b.NAME OPERATORNAME,");
|
|
strSql.Append("t.OPERATEDATE,");
|
|
strSql.Append("t.PRICE,");
|
|
strSql.Append("t.SCALE_UNIT");
|
|
|
|
strSql.Append(" FROM T_RK_RECEIVING_INFO t");
|
|
strSql.Append(" LEFT JOIN T_BASE_GOODS a ON a.GOODS_ID = t.GOODS_ID");
|
|
strSql.Append(" LEFT JOIN T_BASE_USERINFO b ON b.USER_ID = t.OPERATORID");
|
|
if (strWhere.Trim() != "")
|
|
{
|
|
strSql.Append(" where RECE_ID='" + strWhere + "'");
|
|
}
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|
}
|
|
/// <summary>
|
|
/// 更新收货记录
|
|
/// </summary>
|
|
/// <param name="upmenu"></param>
|
|
/// <param name="upFuc"></param>
|
|
/// <param name="insertFuc"></param>
|
|
/// <param name="delFuc"></param>
|
|
/// <returns></returns>
|
|
public void newReceivingInfoFuc(List<ReceivingInfoModel> upFuc, List<ReceivingInfoModel> insertFuc, List<ReceivingInfoModel> delFuc)
|
|
{
|
|
List<string> sqlList = new List<string>();
|
|
List<OracleParameter[]> paraList = new List<OracleParameter[]>();
|
|
StringBuilder strSql = new StringBuilder();
|
|
//菜单功能删除
|
|
if (delFuc.Count > 0)
|
|
{
|
|
foreach (ReceivingInfoModel infomodel in delFuc)
|
|
{
|
|
strSql.Append("delete from T_RK_RECEIVING_INFO ");
|
|
strSql.Append(" where RECE_ID=:RECE_ID and GOODS_ID=:GOODS_ID");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":GOODS_ID",OracleDbType.Varchar2)
|
|
};
|
|
parameters[0].Value = infomodel.RECE_ID;
|
|
parameters[1].Value = infomodel.GOODS_ID;
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(parameters);
|
|
strSql.Clear();
|
|
}
|
|
}
|
|
//菜单功能更改
|
|
if (upFuc.Count > 0)
|
|
{
|
|
foreach (ReceivingInfoModel infoModel in upFuc)
|
|
{
|
|
strSql.Append("update T_RK_RECEIVING_INFO set ");
|
|
strSql.Append("BUY_NUM=:BUY_NUM,");
|
|
strSql.Append("ARR_NUM=:ARR_NUM,");
|
|
strSql.Append("SHELVE_NUM=:SHELVE_NUM,");
|
|
strSql.Append("MADE_DATE=:MADE_DATE,");
|
|
strSql.Append("STO_TRAY=:STO_TRAY,");
|
|
strSql.Append("RECE_VOLUEM=:RECE_VOLUEM,");
|
|
strSql.Append("GRO_WEIGHT=:GRO_WEIGHT,");
|
|
strSql.Append("NET_WEIGHT=:NET_WEIGHT,");
|
|
strSql.Append("RECE_MONEY=:RECE_MONEY,");
|
|
strSql.Append("UNIT=:UNIT,");
|
|
strSql.Append("VOLUME_UNIT=:VOLUME_UNIT,");
|
|
strSql.Append("STO_NUM=:STO_NUM,");
|
|
strSql.Append("OPERATORID=:OPERATORID,");
|
|
strSql.Append("OPERATEDATE=:OPERATEDATE,");
|
|
strSql.Append("PRICE=:PRICE,");
|
|
strSql.Append("SCALE_UNIT=:SCALE_UNIT");
|
|
strSql.Append(" where RECE_ID=:RECE_ID and GOODS_ID=:GOODS_ID");
|
|
OracleParameter[] infoParameters = {
|
|
new OracleParameter(":BUY_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ARR_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":SHELVE_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":MADE_DATE", OracleDbType.Date),
|
|
new OracleParameter(":STO_TRAY",OracleDbType.Varchar2,20),
|
|
new OracleParameter(":RECE_VOLUEM", OracleDbType.Decimal),
|
|
new OracleParameter(":GRO_WEIGHT", OracleDbType.Decimal),
|
|
new OracleParameter(":NET_WEIGHT", OracleDbType.Decimal),
|
|
new OracleParameter(":RECE_MONEY", OracleDbType.Decimal),
|
|
new OracleParameter(":UNIT",OracleDbType.Varchar2),
|
|
new OracleParameter(":VOLUME_UNIT", OracleDbType.Decimal),
|
|
new OracleParameter(":STO_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":OPERATORID",OracleDbType.Varchar2),
|
|
new OracleParameter(":OPERATEDATE", OracleDbType.Date),
|
|
new OracleParameter(":PRICE", OracleDbType.Decimal),
|
|
new OracleParameter(":SCALE_UNIT",OracleDbType.Varchar2),
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":GOODS_ID",OracleDbType.Varchar2)};
|
|
|
|
infoParameters[0].Value = infoModel.BUY_NUM;
|
|
infoParameters[1].Value = infoModel.ARR_NUM;
|
|
infoParameters[2].Value = infoModel.SHELVE_NUM;
|
|
infoParameters[3].Value = infoModel.MADE_DATE;
|
|
infoParameters[4].Value = infoModel.STO_TRAY;
|
|
infoParameters[5].Value = infoModel.RECE_VOLUEM;
|
|
infoParameters[6].Value = infoModel.GRO_WEIGHT;
|
|
infoParameters[7].Value = infoModel.NET_WEIGHT;
|
|
infoParameters[8].Value = infoModel.RECE_MONEY;
|
|
infoParameters[9].Value = infoModel.UNIT;
|
|
infoParameters[10].Value = infoModel.VOLUME_UNIT;
|
|
infoParameters[11].Value = infoModel.STO_NUM;
|
|
infoParameters[12].Value = infoModel.OPERATORID;
|
|
infoParameters[13].Value = infoModel.OPERATEDATE;
|
|
infoParameters[14].Value = infoModel.PRICE;
|
|
infoParameters[15].Value = infoModel.SCALE_UNIT;
|
|
infoParameters[16].Value = infoModel.RECE_ID;
|
|
infoParameters[17].Value = infoModel.GOODS_ID;
|
|
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(infoParameters);
|
|
strSql.Clear();
|
|
}
|
|
}
|
|
//菜单功能添加
|
|
if (insertFuc.Count > 0)
|
|
{
|
|
foreach (ReceivingInfoModel infoModel in insertFuc)
|
|
{
|
|
strSql.Append("insert into T_RK_RECEIVING_INFO(");
|
|
strSql.Append("RECE_ID,GOODS_ID,BUY_NUM,ARR_NUM,SHELVE_NUM,MADE_DATE,STO_TRAY,RECE_VOLUEM,GRO_WEIGHT,NET_WEIGHT,RECE_MONEY,UNIT,VOLUME_UNIT,STO_NUM,OPERATORID,OPERATEDATE,PRICE,SCALE_UNIT)");
|
|
strSql.Append(" values (");
|
|
strSql.Append(":RECE_ID,:GOODS_ID,:BUY_NUM,:ARR_NUM,:SHELVE_NUM,:MADE_DATE,:STO_TRAY,:RECE_VOLUEM,:GRO_WEIGHT,:NET_WEIGHT,:RECE_MONEY,:UNIT,:VOLUME_UNIT,:STO_NUM,:OPERATORID,:OPERATEDATE,:PRICE,:SCALE_UNIT)");
|
|
OracleParameter[] infoParameters = {
|
|
new OracleParameter(":RECE_ID",OracleDbType.Varchar2,50),
|
|
new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,20),
|
|
new OracleParameter(":BUY_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":ARR_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":SHELVE_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":MADE_DATE", OracleDbType.Date),
|
|
new OracleParameter(":STO_TRAY",OracleDbType.Varchar2,20),
|
|
new OracleParameter(":RECE_VOLUEM", OracleDbType.Decimal),
|
|
new OracleParameter(":GRO_WEIGHT", OracleDbType.Decimal),
|
|
new OracleParameter(":NET_WEIGHT", OracleDbType.Decimal),
|
|
new OracleParameter(":RECE_MONEY", OracleDbType.Decimal),
|
|
new OracleParameter(":UNIT",OracleDbType.Varchar2),
|
|
new OracleParameter(":VOLUME_UNIT", OracleDbType.Decimal),
|
|
new OracleParameter(":STO_NUM", OracleDbType.Decimal),
|
|
new OracleParameter(":OPERATORID",OracleDbType.Varchar2),
|
|
new OracleParameter(":OPERATEDATE", OracleDbType.Date),
|
|
new OracleParameter(":PRICE", OracleDbType.Decimal),
|
|
new OracleParameter(":SCALE_UNIT",OracleDbType.Varchar2)};
|
|
infoParameters[0].Value = infoModel.RECE_ID;
|
|
infoParameters[1].Value = infoModel.GOODS_ID;
|
|
infoParameters[2].Value = infoModel.BUY_NUM;
|
|
infoParameters[3].Value = infoModel.ARR_NUM;
|
|
infoParameters[4].Value = infoModel.SHELVE_NUM;
|
|
infoParameters[5].Value = infoModel.MADE_DATE;
|
|
infoParameters[6].Value = infoModel.STO_TRAY;
|
|
infoParameters[7].Value = infoModel.RECE_VOLUEM;
|
|
infoParameters[8].Value = infoModel.GRO_WEIGHT;
|
|
infoParameters[9].Value = infoModel.NET_WEIGHT;
|
|
infoParameters[10].Value = infoModel.RECE_MONEY;
|
|
infoParameters[11].Value = infoModel.UNIT;
|
|
infoParameters[12].Value = infoModel.VOLUME_UNIT;
|
|
infoParameters[13].Value = infoModel.STO_NUM;
|
|
infoParameters[14].Value = infoModel.OPERATORID;
|
|
infoParameters[15].Value = infoModel.OPERATEDATE;
|
|
infoParameters[16].Value = infoModel.PRICE;
|
|
infoParameters[17].Value = infoModel.SCALE_UNIT;
|
|
|
|
sqlList.Add(strSql.ToString());
|
|
paraList.Add(infoParameters);
|
|
strSql.Clear();
|
|
}
|
|
}
|
|
SystemDataObject.Instance.ExecuteList(sqlList, paraList);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取流水号
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public string GetSerialNum()
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select NEXT VALUE FOR seq_rk_receve ");
|
|
DataSet ds = SystemDataObject.Instance.GetDataSet( strSql.ToString());
|
|
return ds.Tables[0].Rows[0][0].ToString();
|
|
}
|
|
}
|
|
}
|