869 lines
43 KiB
C#
869 lines
43 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Data;
|
|
using WMS.Model.Base;
|
|
using WMS.IData.IBase;
|
|
using WMS.IData;
|
|
using Oracle.ManagedDataAccess.Client;
|
|
|
|
|
|
namespace WMS.SqlServerData.BaseData
|
|
{
|
|
public class GoodsData : IGoods
|
|
{
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataTable GetGoodsSts()
|
|
{
|
|
|
|
string sqlStr = "select GOODS_ID from [dbo].[T_SC_GOODS_MATERIAL] group by GOODS_ID ";
|
|
|
|
return SystemDataObject.Instance.GetDataTable(sqlStr);
|
|
|
|
}
|
|
|
|
/// <summary>
|
|
/// 更新状态
|
|
/// </summary>
|
|
/// <param name="goodsId"></param>
|
|
public void UpGoodsCtData(string goodsId)
|
|
{
|
|
string sqlStr = " update T_BASE_GOODS set SEMISTS='1' where GOODS_ID='"+ goodsId + "'";
|
|
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
|
}
|
|
/// <summary>
|
|
/// 通过商品编号集合获取商品信息集合
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataTable GetGoodsDTByIDList(List<string> goodsIDList)
|
|
{
|
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.AppendLine("select ");
|
|
strSQL.AppendLine(" T_BASE_GOODS.* , ");
|
|
strSQL.AppendLine(" T_BASE_GOODS_TYPE.GOODS_TYPE_NAME, ");
|
|
strSQL.AppendLine(" a.Vc_Dictionary_Name SCALE_UNIT_NAME, ");
|
|
strSQL.AppendLine(" b.Vc_Dictionary_Name UNIT_NAME, ");
|
|
strSQL.AppendLine(" T_BASE_PROVIDER_DICTIONARY.PROVIDER_NAME, ");
|
|
strSQL.AppendLine(" c.Vc_Dictionary_Name ABC_NAME,");
|
|
strSQL.AppendLine(" d.Vc_Dictionary_Name STORED_NAME,");
|
|
strSQL.AppendLine(" e.Vc_Dictionary_Name PERIODUNIT_NAME,");
|
|
strSQL.AppendLine(" f.Vc_Dictionary_Name SEASON_NAME,");
|
|
strSQL.AppendLine(" g.Vc_Dictionary_Name STATUS_NAME,");
|
|
strSQL.AppendLine(" case when HAZARDOUS in ('','0') then '否' when HAZARDOUS = '1' then '是' end HAZARDOUS_NAME");
|
|
strSQL.AppendLine("from");
|
|
strSQL.AppendLine(" T_BASE_GOODS");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_BASE_GOODS_TYPE");
|
|
strSQL.AppendLine(" on T_BASE_GOODS.GOODS_TYPE_ID = T_BASE_GOODS_TYPE.GOODS_TYPE_ID");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_SYS_DICTIONARY_TAB a --商品重量UNIT");
|
|
strSQL.AppendLine(" on T_BASE_GOODS.SCALE_UNIT = a.VC_CHAR_VALUE and a.Vc_Dictionary_Type = 'kg_unit'");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_SYS_DICTIONARY_TAB b --商品UNIT");
|
|
strSQL.AppendLine(" on T_BASE_GOODS.UNIT = b.VC_CHAR_VALUE and b.Vc_Dictionary_Type = 'vc_uom'");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_BASE_PROVIDER_DICTIONARY --供应商");
|
|
strSQL.AppendLine(" on T_BASE_GOODS.PROVIDER_ID = T_BASE_PROVIDER_DICTIONARY.PROVIDER_ID");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_SYS_DICTIONARY_TAB c --ABC等级");
|
|
strSQL.AppendLine(" on T_BASE_GOODS.Abc = c.VC_CHAR_VALUE and c.Vc_Dictionary_Type = 'loc_adc_class'");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_SYS_DICTIONARY_TAB d --存储条件");
|
|
strSQL.AppendLine(" on T_BASE_GOODS.Abc = d.VC_CHAR_VALUE and d.Vc_Dictionary_Type = 'loc_storage'");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_SYS_DICTIONARY_TAB e --保质期");
|
|
strSQL.AppendLine(" on T_BASE_GOODS.Abc = e.VC_CHAR_VALUE and e.Vc_Dictionary_Type = 'qg_unit'");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_SYS_DICTIONARY_TAB f --季节");
|
|
strSQL.AppendLine(" on T_BASE_GOODS.Abc = f.VC_CHAR_VALUE and f.Vc_Dictionary_Type = 'loc_season'");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_SYS_DICTIONARY_TAB g --Status");
|
|
strSQL.AppendLine(" on T_BASE_GOODS.Status = g.VC_CHAR_VALUE and g.Vc_Dictionary_Type = 'good_status' ");
|
|
strSQL.AppendLine("where 1 = 1");
|
|
foreach (var ID in goodsIDList)
|
|
{
|
|
strSQL.AppendLine(" or T_BASE_GOODS.GOODS_ID = '" + ID + "' ");
|
|
}
|
|
|
|
return SystemDataObject.Instance.GetDataTable(strSQL.ToString());
|
|
}
|
|
|
|
/// <summary>
|
|
/// 写入back表
|
|
/// </summary>
|
|
/// <param name="goodsId"></param>
|
|
public void AddGoodsDataBak(string goodsId)
|
|
{ //备份
|
|
string sqlStr = "insert into T_BASE_GOODS_BACK select * from T_BASE_GOODS where GOODS_ID=:GOODS_ID";
|
|
OracleParameter[] parameters0 = {
|
|
new OracleParameter(":GOODS_ID",OracleDbType.Varchar2)};
|
|
parameters0[0].Value = goodsId;
|
|
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
|
|
|
}
|
|
/// <summary>
|
|
/// 获取商品信息
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataTable GetGoodsDataTable(string strGoodsID, string strGoodsName, string strPyName, string strProviderName)
|
|
{
|
|
string strSQL = string.Empty;
|
|
strSQL= "select * from CUX_WMS_SYSTEM_ITEMS_INTERFACE T where 1 = 1 ";
|
|
if (!string.IsNullOrEmpty(strGoodsID))
|
|
{
|
|
strSQL+= " and T.ORGANIZATION_ID = '" + strGoodsID + "' ";
|
|
}
|
|
|
|
if (!string.IsNullOrEmpty(strGoodsName))
|
|
{
|
|
strSQL += " and T.ORGANIZATION_CODE like '%" + strGoodsName + "%' ";
|
|
}
|
|
|
|
if (!string.IsNullOrEmpty(strPyName))
|
|
{
|
|
strSQL += " and T.ITEM_TYPE like '%" + strPyName + "%' ";
|
|
}
|
|
|
|
if (!string.IsNullOrEmpty(strProviderName))
|
|
{
|
|
strSQL += " and T.ITEM_DESCRIPTION like '%" + strProviderName + "%' ";
|
|
}
|
|
strSQL += " and rownum <= 1000 ";
|
|
return SystemDataObject.Instance.GetDataTable(strSQL.ToString());
|
|
}
|
|
|
|
/// <summary>
|
|
/// 得到某商品可选UNIT
|
|
/// </summary>
|
|
/// <param name="goodsID"></param>
|
|
/// <returns></returns>
|
|
public DataTable GetGoodsUnit(string goodsID)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.AppendLine("(select ");
|
|
strSql.AppendLine(" a.unit_id as UNIT, ");
|
|
strSql.AppendLine(" VC_DICTIONARY_NAME as UNIT_NAME,");
|
|
strSql.AppendLine(" a.CONVERSION_RATIO ");
|
|
strSql.AppendLine("from ");
|
|
strSql.AppendLine(" T_BASE_GOODS_MEASURE a ");
|
|
strSql.AppendLine("left outer join ");
|
|
strSql.AppendLine(" T_SYS_DICTIONARY_TAB b ");
|
|
strSql.AppendLine(" on a.Unit_Id = b.VC_CHAR_VALUE ");
|
|
strSql.AppendLine("and ");
|
|
strSql.AppendLine(" b.Vc_Dictionary_Type = 'vc_uom' ");
|
|
strSql.AppendLine("where ");
|
|
strSql.AppendLine(" Goods_ID = '" + goodsID + "') ");
|
|
strSql.AppendLine("UNION ALL ");
|
|
strSql.AppendLine("(select ");
|
|
strSql.AppendLine(" a.unit, ");
|
|
strSql.AppendLine(" VC_DICTIONARY_NAME as UNIT_NAME,");
|
|
strSql.AppendLine(" 1 as CONVERSION_RATIO ");
|
|
strSql.AppendLine("from ");
|
|
strSql.AppendLine(" T_BASE_GOODS a ");
|
|
strSql.AppendLine(" left outer join ");
|
|
strSql.AppendLine(" T_SYS_DICTIONARY_TAB b ");
|
|
strSql.AppendLine(" on a.unit = b.VC_CHAR_VALUE ");
|
|
strSql.AppendLine("and ");
|
|
strSql.AppendLine(" b.Vc_Dictionary_Type = 'vc_uom' ");
|
|
strSql.AppendLine("where ");
|
|
strSql.AppendLine(" Goods_ID = '" + goodsID + "') ");
|
|
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|
}
|
|
public DataTable GetGoodsBarCode(string barCode)
|
|
{
|
|
|
|
string sqlstr = "select t.goods_id,t.goods_name,t.goods_type_id from T_BASE_GOODS t where t.barcode='" + barCode + "'";
|
|
|
|
return SystemDataObject.Instance.GetDataTable(sqlstr.ToString());
|
|
}
|
|
/// <summary>
|
|
/// 获取商品UNIT
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataTable GetGoodsMeasureDataTable(string strGoodsID)
|
|
{
|
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.AppendLine("select");
|
|
strSQL.AppendLine(" T_BASE_GOODS_MEASURE.*,");
|
|
strSQL.AppendLine(" T_SYS_DICTIONARY_TAB.VC_DICTIONARY_NAME UNIT_NAME ");
|
|
strSQL.AppendLine("from");
|
|
strSQL.AppendLine(" T_BASE_GOODS_MEASURE");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_SYS_DICTIONARY_TAB");
|
|
strSQL.AppendLine(" on T_BASE_GOODS_MEASURE.Unit_Id = T_SYS_DICTIONARY_TAB.VC_CHAR_VALUE and T_SYS_DICTIONARY_TAB.Vc_Dictionary_Type = 'vc_uom'");
|
|
strSQL.AppendLine("where 1 = 1");
|
|
if (strGoodsID != "")
|
|
{
|
|
strSQL.AppendLine(" and Goods_ID = '" + strGoodsID + "' ");
|
|
}
|
|
strSQL.AppendLine(" order by UNIT_ID");
|
|
return SystemDataObject.Instance.GetDataTable(strSQL.ToString());
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取商品供应商
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataTable GetGoodsPrividerDataTale(string strGoodsID)
|
|
{
|
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.AppendLine("select");
|
|
strSQL.AppendLine(" T_BASE_GOODS_PROVIDER.*,");
|
|
strSQL.AppendLine(" T_BASE_PROVIDER_DICTIONARY.PROVIDER_NAME");
|
|
strSQL.AppendLine("from");
|
|
strSQL.AppendLine(" T_BASE_GOODS_PROVIDER");
|
|
strSQL.AppendLine("left outer join");
|
|
strSQL.AppendLine(" T_BASE_PROVIDER_DICTIONARY");
|
|
strSQL.AppendLine(" on T_BASE_GOODS_PROVIDER.PROVIDER_ID = T_BASE_PROVIDER_DICTIONARY.PROVIDER_ID");
|
|
strSQL.AppendLine("where 1 = 1");
|
|
if (strGoodsID != "")
|
|
{
|
|
strSQL.AppendLine(" and Goods_ID = '" + strGoodsID + "' ");
|
|
}
|
|
return SystemDataObject.Instance.GetDataTable(strSQL.ToString());
|
|
}
|
|
|
|
/// <summary>
|
|
/// 新增商品信息
|
|
/// </summary>
|
|
/// <param name="model">商品信息实体</param>
|
|
/// <returns></returns>
|
|
public void AddGoodsInfo(JWGoodsInfoModel model)
|
|
{
|
|
|
|
// StringBuilder strSql = new StringBuilder();
|
|
// strSql.Append("insert into T_BASE_GOODS(");
|
|
// strSql.Append("GOODS_ID,GOODS_NAME,GOODS_SHORT_NAME,PY_NAME,GOODS_TYPE_ID,SPECIFICATION,MODEL,PRICE,BARCODE,GLENGTH,GWIDTH,GHEIGHT,GVOLUME,SCALE_UNIT,UNIT,WARN_UP,WARN_DOWN,PRODUCE_AREA,GROSS_WEIGHT,NET_WEIGHT,PROVIDER_ID,HSNUMBER,ABC,HAZARDOUS,STORED,PERIOD,PERIODUNIT,ADDTAX,SEASON,TARIFFRATE,REMARK,STATUS,VERSION,CREATE_MAN,CREATE_DATE,SC_FLAG,COST_PRICE)");
|
|
// strSql.Append(" values (");
|
|
// strSql.Append(":GOODS_ID,:GOODS_NAME,:GOODS_SHORT_NAME,:PY_NAME,:GOODS_TYPE_ID,:SPECIFICATION,:MODEL,:PRICE,:BARCODE,:GLENGTH,:GWIDTH,:GHEIGHT,:GVOLUME,:SCALE_UNIT,:UNIT,:WARN_UP,:WARN_DOWN,:PRODUCE_AREA,:GROSS_WEIGHT,:NET_WEIGHT,:PROVIDER_ID,:HSNUMBER,:ABC,:HAZARDOUS,:STORED,:PERIOD,:PERIODUNIT,:ADDTAX,:SEASON,:TARIFFRATE,:REMARK,:STATUS,:VERSION,:CREATE_MAN,sysdate,:SC_FLAG,:COST_PRICE)");
|
|
// OracleParameter[] parameters = {
|
|
// new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,50),//0
|
|
//new OracleParameter(":GOODS_NAME",OracleDbType.Varchar2,100),//1
|
|
//new OracleParameter(":GOODS_SHORT_NAME",OracleDbType.Varchar2,50),//2
|
|
// new OracleParameter(":PY_NAME",OracleDbType.Varchar2,50),//3
|
|
// new OracleParameter(":GOODS_TYPE_ID",OracleDbType.Varchar2,50),//4
|
|
// new OracleParameter(":SPECIFICATION",OracleDbType.Varchar2,50),//5
|
|
// new OracleParameter(":MODEL",OracleDbType.Varchar2,50),//6
|
|
// new OracleParameter(":PRICE", OracleDbType.Decimal,4),//7
|
|
// new OracleParameter(":BARCODE",OracleDbType.Varchar2,50),//8
|
|
// new OracleParameter(":GLENGTH", OracleDbType.Decimal,4),//9
|
|
// new OracleParameter(":GWIDTH", OracleDbType.Decimal,4),//10
|
|
// new OracleParameter(":GHEIGHT", OracleDbType.Decimal,4),//11
|
|
// new OracleParameter(":GVOLUME", OracleDbType.Decimal,4),//12
|
|
// new OracleParameter(":SCALE_UNIT",OracleDbType.Varchar2,50),//13
|
|
// new OracleParameter(":UNIT",OracleDbType.Varchar2,50),//14
|
|
// new OracleParameter(":WARN_UP", OracleDbType.Decimal,4),//15
|
|
// new OracleParameter(":WARN_DOWN", OracleDbType.Decimal,4),//16
|
|
// new OracleParameter(":PRODUCE_AREA",OracleDbType.Varchar2,50),//17
|
|
// new OracleParameter(":GROSS_WEIGHT", OracleDbType.Decimal,4),//18
|
|
// new OracleParameter(":NET_WEIGHT", OracleDbType.Decimal,4),//19
|
|
// new OracleParameter(":PROVIDER_ID",OracleDbType.Varchar2,50),//20
|
|
// new OracleParameter(":HSNUMBER",OracleDbType.Varchar2,50),//21
|
|
// new OracleParameter(":ABC",OracleDbType.Varchar2,50),//22
|
|
// new OracleParameter(":HAZARDOUS", OracleDbType.Char,1),//23
|
|
// new OracleParameter(":STORED",OracleDbType.Varchar2,50),//24
|
|
// new OracleParameter(":PERIOD", OracleDbType.Decimal,4),//25
|
|
// new OracleParameter(":PERIODUNIT",OracleDbType.Varchar2,50),//26
|
|
// new OracleParameter(":ADDTAX", OracleDbType.Decimal,4),//27
|
|
// new OracleParameter(":SEASON",OracleDbType.Varchar2,50),//28
|
|
// new OracleParameter(":TARIFFRATE", OracleDbType.Decimal,4),//29
|
|
// new OracleParameter(":REMARK",OracleDbType.Varchar2,300),//30
|
|
// new OracleParameter(":STATUS",OracleDbType.Varchar2,50),//31
|
|
// new OracleParameter(":VERSION",OracleDbType.Varchar2,50),//32
|
|
// // new OracleParameter(":IMG", OracleDbType.Blob),//33
|
|
// new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2,50),//34
|
|
// new OracleParameter(":SC_FLAG", OracleDbType.Char,1),//35
|
|
// new OracleParameter(":COST_PRICE", OracleDbType.Decimal),//36
|
|
// };
|
|
// parameters[0].Value = model.GOODS_ID;
|
|
// parameters[1].Value = model.GOODS_NAME;
|
|
// parameters[2].Value = model.GOODS_SHORT_NAME;
|
|
// parameters[3].Value = model.PY_NAME;
|
|
// parameters[4].Value = model.GOODS_TYPE_ID;
|
|
// parameters[5].Value = model.SPECIFICATION;
|
|
// parameters[6].Value = model.MODEL;
|
|
// parameters[7].Value = model.PRICE;
|
|
// parameters[8].Value = model.BARCODE;
|
|
// parameters[9].Value = model.GLENGTH;
|
|
// parameters[10].Value = model.GWIDTH;
|
|
// parameters[11].Value = model.GHEIGHT;
|
|
// parameters[12].Value = model.GVOLUME;
|
|
// parameters[13].Value = model.SCALE_UNIT;
|
|
// parameters[14].Value = model.UNIT;
|
|
// parameters[15].Value = model.WARN_UP;
|
|
// parameters[16].Value = model.WARN_DOWN;
|
|
// parameters[17].Value = model.PRODUCE_AREA;
|
|
// parameters[18].Value = model.GROSS_WEIGHT;
|
|
// parameters[19].Value = model.NET_WEIGHT;
|
|
// parameters[20].Value = model.PROVIDER_ID;
|
|
// parameters[21].Value = model.HSNUMBER;
|
|
// parameters[22].Value = model.ABC;
|
|
// parameters[23].Value = model.HAZARDOUS;
|
|
// parameters[24].Value = model.STORED;
|
|
// parameters[25].Value = model.PERIOD;
|
|
// parameters[26].Value = model.PERIODUNIT;
|
|
// parameters[27].Value = model.ADDTAX;
|
|
// parameters[28].Value = model.SEASON;
|
|
// parameters[29].Value = model.TARIFFRATE;
|
|
// parameters[30].Value = model.REMARK;
|
|
// parameters[31].Value = model.STATUS;
|
|
// parameters[32].Value = model.VERSION;
|
|
// // parameters[33].Value = model.IMG == null ? new byte[10] : model.IMG;
|
|
// parameters[33].Value = model.CREATE_MAN;
|
|
// parameters[34].Value = model.SC_FLAG;
|
|
// parameters[35].Value = model.COST_PRICE;
|
|
|
|
// SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
|
|
public void UpdateGoodsInfo(JWGoodsInfoModel model)
|
|
{
|
|
// StringBuilder strSql = new StringBuilder();
|
|
// strSql.Append("update T_BASE_GOODS set ");
|
|
// strSql.Append("GOODS_NAME=:GOODS_NAME,");
|
|
// strSql.Append("GOODS_SHORT_NAME=:GOODS_SHORT_NAME,");
|
|
// strSql.Append("PY_NAME=:PY_NAME,");
|
|
// strSql.Append("GOODS_TYPE_ID=:GOODS_TYPE_ID,");
|
|
// strSql.Append("SPECIFICATION=:SPECIFICATION,");
|
|
// strSql.Append("MODEL=:MODEL,");
|
|
// strSql.Append("PRICE=:PRICE,");
|
|
// strSql.Append("BARCODE=:BARCODE,");
|
|
// strSql.Append("GLENGTH=:GLENGTH,");
|
|
// strSql.Append("GWIDTH=:GWIDTH,");
|
|
// strSql.Append("GHEIGHT=:GHEIGHT,");
|
|
// strSql.Append("GVOLUME=:GVOLUME,");
|
|
// strSql.Append("SCALE_UNIT=:SCALE_UNIT,");
|
|
// strSql.Append("UNIT=:UNIT,");
|
|
// strSql.Append("WARN_UP=:WARN_UP,");
|
|
// strSql.Append("WARN_DOWN=:WARN_DOWN,");
|
|
// strSql.Append("PRODUCE_AREA=:PRODUCE_AREA,");
|
|
// strSql.Append("GROSS_WEIGHT=:GROSS_WEIGHT,");
|
|
// strSql.Append("NET_WEIGHT=:NET_WEIGHT,");
|
|
// strSql.Append("PROVIDER_ID=:PROVIDER_ID,");
|
|
// strSql.Append("HSNUMBER=:HSNUMBER,");
|
|
// strSql.Append("ABC=:ABC,");
|
|
// strSql.Append("HAZARDOUS=:HAZARDOUS,");
|
|
// strSql.Append("STORED=:STORED,");
|
|
// strSql.Append("PERIOD=:PERIOD,");
|
|
// strSql.Append("PERIODUNIT=:PERIODUNIT,");
|
|
// strSql.Append("ADDTAX=:ADDTAX,");
|
|
// strSql.Append("SEASON=:SEASON,");
|
|
// strSql.Append("TARIFFRATE=:TARIFFRATE,");
|
|
// strSql.Append("REMARK=:REMARK,");
|
|
// strSql.Append("STATUS=:STATUS,");
|
|
// strSql.Append("VERSION=:VERSION,");
|
|
// strSql.Append("IMG=:IMG,");
|
|
// strSql.Append("UPDATE_MAN=:UPDATE_MAN,");
|
|
// strSql.Append("UPDATE_DATE=getdate(),");
|
|
// strSql.Append("SC_FLAG=:SC_FLAG,");
|
|
// strSql.Append("COST_PRICE=:COST_PRICE");
|
|
// strSql.Append(" where GOODS_ID=:GOODS_ID ");
|
|
// OracleParameter[] parameters = {
|
|
// new OracleParameter(":GOODS_NAME",OracleDbType.Varchar2,100),
|
|
// new OracleParameter(":GOODS_SHORT_NAME",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":PY_NAME",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":GOODS_TYPE_ID",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":SPECIFICATION",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":MODEL",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":PRICE", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":BARCODE",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":GLENGTH", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":GWIDTH", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":GHEIGHT", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":GVOLUME", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":SCALE_UNIT",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":UNIT",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":WARN_UP", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":WARN_DOWN", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":PRODUCE_AREA",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":GROSS_WEIGHT", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":NET_WEIGHT", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":PROVIDER_ID",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":HSNUMBER",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":ABC",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":HAZARDOUS", OracleDbType.Char,1),
|
|
// new OracleParameter(":STORED",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":PERIOD", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":PERIODUNIT",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":ADDTAX", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":SEASON",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":TARIFFRATE", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":REMARK",OracleDbType.Varchar2,300),
|
|
// new OracleParameter(":STATUS",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":VERSION",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":IMG", OracleDbType.Blob),
|
|
// new OracleParameter(":UPDATE_MAN",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":SC_FLAG", OracleDbType.Char,1),
|
|
// new OracleParameter(":COST_PRICE", OracleDbType.Decimal),
|
|
// //new OracleParameter(":UPDATE_DATE", OracleDbType.Date),
|
|
//new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,50)};
|
|
// parameters[0].Value = model.GOODS_NAME;
|
|
// parameters[1].Value = model.GOODS_SHORT_NAME;
|
|
// parameters[2].Value = model.PY_NAME;
|
|
// parameters[3].Value = model.GOODS_TYPE_ID;
|
|
// parameters[4].Value = model.SPECIFICATION;
|
|
// parameters[5].Value = model.MODEL;
|
|
// parameters[6].Value = model.PRICE;
|
|
// parameters[7].Value = model.BARCODE;
|
|
// parameters[8].Value = model.GLENGTH;
|
|
// parameters[9].Value = model.GWIDTH;
|
|
// parameters[10].Value = model.GHEIGHT;
|
|
// parameters[11].Value = model.GVOLUME;
|
|
// parameters[12].Value = model.SCALE_UNIT;
|
|
// parameters[13].Value = model.UNIT;
|
|
// parameters[14].Value = model.WARN_UP;
|
|
// parameters[15].Value = model.WARN_DOWN;
|
|
// parameters[16].Value = model.PRODUCE_AREA;
|
|
// parameters[17].Value = model.GROSS_WEIGHT;
|
|
// parameters[18].Value = model.NET_WEIGHT;
|
|
// parameters[19].Value = model.PROVIDER_ID;
|
|
// parameters[20].Value = model.HSNUMBER;
|
|
// parameters[21].Value = model.ABC;
|
|
// parameters[22].Value = model.HAZARDOUS;
|
|
// parameters[23].Value = model.STORED;
|
|
// parameters[24].Value = model.PERIOD;
|
|
// parameters[25].Value = model.PERIODUNIT;
|
|
// parameters[26].Value = model.ADDTAX;
|
|
// parameters[27].Value = model.SEASON;
|
|
// parameters[28].Value = model.TARIFFRATE;
|
|
// parameters[29].Value = model.REMARK;
|
|
// parameters[30].Value = model.STATUS;
|
|
// parameters[31].Value = model.VERSION;
|
|
// parameters[32].Value = model.IMG == null ? new byte[10] : model.IMG;
|
|
// parameters[33].Value = model.UPDATE_MAN;
|
|
// parameters[34].Value = model.SC_FLAG;
|
|
// parameters[35].Value = model.COST_PRICE;
|
|
// //parameters[34].Value = model.UPDATE_DATE;
|
|
// parameters[36].Value = model.GOODS_ID;
|
|
// SystemDataObject.Instance.ExecuteSql(strSql.ToString(),parameters);
|
|
|
|
|
|
}
|
|
|
|
///// <summary>
|
|
///// 新增商品信息
|
|
///// </summary>
|
|
///// <param name="model">商品信息实体</param>
|
|
///// <returns></returns>
|
|
//public string AddGoodsInfo(JWGoodsInfoModel model, List<GoodsMeasureModel> ListMeasureModel, List<GoodsProviderModel> ListProviderModel)
|
|
//{
|
|
// string strSEQ = string.Empty;
|
|
// string strSqlSeq = string.Empty;
|
|
// DataTable dt = new DataTable();
|
|
// bool had = true;
|
|
|
|
// //if (string.IsNullOrEmpty(model.GOODS_ID))
|
|
// //{
|
|
// // while (had)
|
|
// // {
|
|
// // strSqlSeq = "select SEQ_BASE_GOODS_ID.NEXTVAL from dual";
|
|
// // dt = SystemDataObject.Instance.GetDataTable(strSqlSeq);
|
|
// // strSEQ = "SP" + dt.Rows[0][0].ToString();
|
|
|
|
// // string str = "select * from T_BASE_GOODS where GOODS_ID = '" + strSEQ + "'";
|
|
// // if (SystemDataObject.Instance.GetDataTable(str).Rows.Count == 0)
|
|
// // {
|
|
// // had = false;
|
|
// // }
|
|
// // }
|
|
// //}
|
|
// //else
|
|
// //{
|
|
// // strSEQ = model.GOODS_ID;
|
|
// //}
|
|
|
|
// List<string> listSQL = new List<string>();
|
|
// List<OracleParameter[]> listPar = new List<OracleParameter[]>();
|
|
// string strSQL = string.Empty;
|
|
// #region 商品信息
|
|
// StringBuilder strSql = new StringBuilder();
|
|
// strSql.Append("insert into T_BASE_GOODS(");
|
|
// strSql.Append("GOODS_ID,GOODS_NAME,GOODS_SHORT_NAME,PY_NAME,GOODS_TYPE_ID,SPECIFICATION,MODEL,PRICE,BARCODE,GLENGTH,GWIDTH,GHEIGHT,GVOLUME,SCALE_UNIT,UNIT,WARN_UP,WARN_DOWN,PRODUCE_AREA,GROSS_WEIGHT,NET_WEIGHT,PROVIDER_ID,HSNUMBER,ABC,HAZARDOUS,STORED,PERIOD,PERIODUNIT,ADDTAX,SEASON,TARIFFRATE,REMARK,STATUS,VERSION,IMG,CREATE_MAN,CREATE_DATE,SC_FLAG,COST_PRICE)");
|
|
// strSql.Append(" values (");
|
|
// strSql.Append(":GOODS_ID,:GOODS_NAME,:GOODS_SHORT_NAME,:PY_NAME,:GOODS_TYPE_ID,:SPECIFICATION,:MODEL,:PRICE,:BARCODE,:GLENGTH,:GWIDTH,:GHEIGHT,:GVOLUME,:SCALE_UNIT,:UNIT,:WARN_UP,:WARN_DOWN,:PRODUCE_AREA,:GROSS_WEIGHT,:NET_WEIGHT,:PROVIDER_ID,:HSNUMBER,:ABC,:HAZARDOUS,:STORED,:PERIOD,:PERIODUNIT,:ADDTAX,:SEASON,:TARIFFRATE,:REMARK,:STATUS,:VERSION,:IMG,:CREATE_MAN,getdate(),:SC_FLAG,:COST_PRICE)");
|
|
// OracleParameter[] parameters = {
|
|
// new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":GOODS_NAME",OracleDbType.Varchar2,100),
|
|
// new OracleParameter(":GOODS_SHORT_NAME",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":PY_NAME",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":GOODS_TYPE_ID",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":SPECIFICATION",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":MODEL",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":PRICE", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":BARCODE",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":GLENGTH", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":GWIDTH", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":GHEIGHT", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":GVOLUME", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":SCALE_UNIT",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":UNIT",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":WARN_UP", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":WARN_DOWN", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":PRODUCE_AREA",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":GROSS_WEIGHT", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":NET_WEIGHT", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":PROVIDER_ID",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":HSNUMBER",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":ABC",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":HAZARDOUS", OracleDbType.Char,1),
|
|
// new OracleParameter(":STORED",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":PERIOD", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":PERIODUNIT",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":ADDTAX", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":SEASON",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":TARIFFRATE", OracleDbType.Decimal,4),
|
|
// new OracleParameter(":REMARK",OracleDbType.Varchar2,300),
|
|
// new OracleParameter(":STATUS",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":VERSION",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":IMG", OracleDbType.Image),
|
|
// new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2,50),
|
|
// new OracleParameter(":SC_FLAG", OracleDbType.Char,1),
|
|
// new OracleParameter(":COST_PRICE", OracleDbType.Decimal)};
|
|
// //new OracleParameter(":CREATE_DATE", OracleDbType.Date)
|
|
// parameters[0].Value = strSEQ;
|
|
// parameters[1].Value = model.GOODS_NAME;
|
|
// parameters[2].Value = model.GOODS_SHORT_NAME;
|
|
// parameters[3].Value = model.PY_NAME;
|
|
// parameters[4].Value = model.GOODS_TYPE_ID;
|
|
// parameters[5].Value = model.SPECIFICATION;
|
|
// parameters[6].Value = model.MODEL;
|
|
// parameters[7].Value = model.PRICE;
|
|
// parameters[8].Value = model.BARCODE;
|
|
// parameters[9].Value = model.GLENGTH;
|
|
// parameters[10].Value = model.GWIDTH;
|
|
// parameters[11].Value = model.GHEIGHT;
|
|
// parameters[12].Value = model.GVOLUME;
|
|
// parameters[13].Value = model.SCALE_UNIT;
|
|
// parameters[14].Value = model.UNIT;
|
|
// parameters[15].Value = model.WARN_UP;
|
|
// parameters[16].Value = model.WARN_DOWN;
|
|
// parameters[17].Value = model.PRODUCE_AREA;
|
|
// parameters[18].Value = model.GROSS_WEIGHT;
|
|
// parameters[19].Value = model.NET_WEIGHT;
|
|
// parameters[20].Value = model.PROVIDER_ID;
|
|
// parameters[21].Value = model.HSNUMBER;
|
|
// parameters[22].Value = model.ABC;
|
|
// parameters[23].Value = model.HAZARDOUS;
|
|
// parameters[24].Value = model.STORED;
|
|
// parameters[25].Value = model.PERIOD;
|
|
// parameters[26].Value = model.PERIODUNIT;
|
|
// parameters[27].Value = model.ADDTAX;
|
|
// parameters[28].Value = model.SEASON;
|
|
// parameters[29].Value = model.TARIFFRATE;
|
|
// parameters[30].Value = model.REMARK;
|
|
// parameters[31].Value = model.STATUS;
|
|
// parameters[32].Value = model.VERSION;
|
|
// parameters[33].Value = model.IMG;
|
|
// parameters[34].Value = model.CREATE_MAN;
|
|
// //parameters[35].Value = model.CREATE_DATE;
|
|
// parameters[35].Value = model.SC_FLAG;
|
|
// parameters[36].Value = model.COST_PRICE;
|
|
|
|
// listSQL.Add(strSql.ToString());
|
|
// listPar.Add(parameters);
|
|
// #endregion
|
|
|
|
|
|
|
|
// SystemDataObject.Instance.ExecuteList(listSQL,listPar);
|
|
|
|
// return strSEQ;
|
|
//}
|
|
public DataTable GetGoodsData(string goodsId)
|
|
{
|
|
string sqlStr = " select goods_name,barcode from t_base_goods where goods_id='" + goodsId + "' ";
|
|
|
|
|
|
return SystemDataObject.Instance.GetDataTable(goodsId);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改商品信息
|
|
/// </summary>
|
|
/// <param name="GoodsModel"></param>
|
|
/// <returns></returns>
|
|
public void UpGoodsInfo(JWGoodsInfoModel model) //UpdateGoodsInfo
|
|
{
|
|
//StringBuilder strSql = new StringBuilder();
|
|
//strSql.Append("update T_BASE_GOODS set ");
|
|
//if (model.GOODS_ID != null)
|
|
//{
|
|
// strSql.Append("GOODS_ID='" + model.GOODS_ID + "',");
|
|
//}
|
|
//if (model.GOODS_NAME != null)
|
|
//{
|
|
// strSql.Append("GOODS_NAME='" + model.GOODS_NAME + "',");
|
|
//}
|
|
//if (model.GOODS_SHORT_NAME != null)
|
|
//{
|
|
// strSql.Append("GOODS_SHORT_NAME='" + model.GOODS_SHORT_NAME + "',");
|
|
//}
|
|
//if (model.PY_NAME != null)
|
|
//{
|
|
// strSql.Append("PY_NAME='" + model.PY_NAME + "',");
|
|
//}
|
|
//if (model.GOODS_TYPE_ID != null)
|
|
//{
|
|
// strSql.Append("GOODS_TYPE_ID='" + model.GOODS_TYPE_ID + "',");
|
|
//}
|
|
//if (model.SPECIFICATION != null)
|
|
//{
|
|
// strSql.Append("SPECIFICATION='" + model.SPECIFICATION + "',");
|
|
//}
|
|
//if (model.MODEL != null)
|
|
//{
|
|
// strSql.Append("MODEL='" + model.MODEL + "',");
|
|
//}
|
|
//if (model.PRICE != null)
|
|
//{
|
|
// strSql.Append("PRICE=" + model.PRICE + ",");
|
|
//}
|
|
//if (model.BARCODE != null)
|
|
//{
|
|
// strSql.Append("BARCODE='" + model.BARCODE + "',");
|
|
//}
|
|
//if (model.GLENGTH != null)
|
|
//{
|
|
// strSql.Append("GLENGTH=" + model.GLENGTH + ",");
|
|
//}
|
|
//if (model.GWIDTH != null)
|
|
//{
|
|
// strSql.Append("GWIDTH=" + model.GWIDTH + ",");
|
|
//}
|
|
//if (model.GHEIGHT != null)
|
|
//{
|
|
// strSql.Append("GHEIGHT=" + model.GHEIGHT + ",");
|
|
//}
|
|
//if (model.GVOLUME != null)
|
|
//{
|
|
// strSql.Append("GVOLUME=" + model.GVOLUME + ",");
|
|
//}
|
|
//if (model.SCALE_UNIT != null)
|
|
//{
|
|
// strSql.Append("SCALE_UNIT='" + model.SCALE_UNIT + "',");
|
|
//}
|
|
//if (model.UNIT != null)
|
|
//{
|
|
// strSql.Append("UNIT='" + model.UNIT + "',");
|
|
//}
|
|
//if (model.WARN_UP != null)
|
|
//{
|
|
// strSql.Append("WARN_UP=" + model.WARN_UP + ",");
|
|
//}
|
|
//if (model.WARN_DOWN != null)
|
|
//{
|
|
// strSql.Append("WARN_DOWN=" + model.WARN_DOWN + ",");
|
|
//}
|
|
//if (model.PRODUCE_AREA != null)
|
|
//{
|
|
// strSql.Append("PRODUCE_AREA='" + model.PRODUCE_AREA + "',");
|
|
//}
|
|
//if (model.GROSS_WEIGHT != null)
|
|
//{
|
|
// strSql.Append("GROSS_WEIGHT=" + model.GROSS_WEIGHT + ",");
|
|
//}
|
|
//if (model.NET_WEIGHT != null)
|
|
//{
|
|
// strSql.Append("NET_WEIGHT=" + model.NET_WEIGHT + ",");
|
|
//}
|
|
//if (model.PROVIDER_ID != null)
|
|
//{
|
|
// strSql.Append("PROVIDER_ID='" + model.PROVIDER_ID + "',");
|
|
//}
|
|
//if (model.HSNUMBER != null)
|
|
//{
|
|
// strSql.Append("HSNUMBER='" + model.HSNUMBER + "',");
|
|
//}
|
|
//if (model.ABC != null)
|
|
//{
|
|
// strSql.Append("ABC='" + model.ABC + "',");
|
|
//}
|
|
//if (model.HAZARDOUS != null)
|
|
//{
|
|
// strSql.Append("HAZARDOUS='" + model.HAZARDOUS + "',");
|
|
//}
|
|
//if (model.STORED != null)
|
|
//{
|
|
// strSql.Append("STORED='" + model.STORED + "',");
|
|
//}
|
|
//if (model.PERIOD != null)
|
|
//{
|
|
// strSql.Append("PERIOD=" + model.PERIOD + ",");
|
|
//}
|
|
//if (model.PERIODUNIT != null)
|
|
//{
|
|
// strSql.Append("PERIODUNIT='" + model.PERIODUNIT + "',");
|
|
//}
|
|
//if (model.ADDTAX != null)
|
|
//{
|
|
// strSql.Append("ADDTAX=" + model.ADDTAX + ",");
|
|
//}
|
|
//if (model.SEASON != null)
|
|
//{
|
|
// strSql.Append("SEASON='" + model.SEASON + "',");
|
|
//}
|
|
//if (model.TARIFFRATE != null)
|
|
//{
|
|
// strSql.Append("TARIFFRATE=" + model.TARIFFRATE + ",");
|
|
//}
|
|
//if (model.REMARK != null)
|
|
//{
|
|
// strSql.Append("REMARK='" + model.REMARK + "',");
|
|
//}
|
|
//if (model.STATUS != null)
|
|
//{
|
|
// strSql.Append("STATUS='" + model.STATUS + "',");
|
|
//}
|
|
//if (model.VERSION != null)
|
|
//{
|
|
// strSql.Append("VERSION='" + model.VERSION + "',");
|
|
//}
|
|
//if (model.IMG != null)
|
|
//{
|
|
// strSql.Append("IMG='" + model.IMG + "',");
|
|
//}
|
|
//if (model.CREATE_MAN != null)
|
|
//{
|
|
// strSql.Append("CREATE_MAN='" + model.CREATE_MAN + "',");
|
|
//}
|
|
//if (model.CREATE_DATE != null)
|
|
//{
|
|
// strSql.Append("CREATE_DATE=convert(varchar(100),'" + model.CREATE_DATE.ToString() + "',21),");
|
|
//}
|
|
//if (model.UPDATE_MAN != null)
|
|
//{
|
|
// strSql.Append("UPDATE_MAN='" + model.UPDATE_MAN + "',");
|
|
//}
|
|
//if (model.UPDATE_DATE != null)
|
|
//{
|
|
// strSql.Append("UPDATE_DATE=convert(varchar(100),'" + model.UPDATE_DATE.ToString() + "',21),");
|
|
//}
|
|
//if (model.SC_FLAG != null)
|
|
//{
|
|
// strSql.Append("SC_FLAG='" + model.SC_FLAG + "',");
|
|
//}
|
|
//if (model.COST_PRICE != null)
|
|
//{
|
|
// strSql.Append("COST_PRICE=" + model.COST_PRICE + ",");
|
|
//}
|
|
//int n = strSql.ToString().LastIndexOf(",");
|
|
//strSql.Remove(n, 1);
|
|
//strSql.Append(" where GOODS_ID='" + model.GOODS_ID + "' ");
|
|
|
|
//SystemDataObject.Instance.ExecuteSql(strSql.ToString());
|
|
}
|
|
public void AddMeaureGoodsInfo(GoodsMeasureModel Measure)
|
|
{
|
|
|
|
string strSQL = "insert into T_BASE_GOODS_MEASURE(";
|
|
strSQL = strSQL + "GOODS_ID,UNIT_ID,CONVERSION_RATIO,STORAGE_LOCATION,CASES_STORED,BOX_CASES_STORED,GLONG,GWIDTH,GHEIGHT,GVOLUME,REMARK,CREATE_MAN,CREATE_DATE,VERSION";
|
|
strSQL = strSQL + ")";
|
|
strSQL = strSQL + " values (";
|
|
|
|
strSQL = strSQL + "'" + Measure.GOODS_ID + "',";
|
|
strSQL = strSQL + "'" + Measure.UNIT_ID + "',";
|
|
strSQL = strSQL + "'" + Measure.CONVERSION_RATIO + "',";
|
|
strSQL = strSQL + "'" + Measure.STORAGE_LOCATION + "',";
|
|
strSQL = strSQL + "'" + Measure.CASES_STORED + "',";
|
|
strSQL = strSQL + "'" + Measure.BOX_CASES_STORED + "',";
|
|
strSQL = strSQL + "'" + Measure.GLONG + "',";
|
|
strSQL = strSQL + "'" + Measure.GWIDTH + "',";
|
|
strSQL = strSQL + "'" + Measure.GHEIGHT + "',";
|
|
strSQL = strSQL + "'" + Measure.GVOLUME + "',";
|
|
strSQL = strSQL + "'" + Measure.REMARK + "',";
|
|
strSQL = strSQL + "'" + Measure.UPDATE_MAN + "',";
|
|
strSQL = strSQL + "getdate(),";
|
|
strSQL = strSQL + "'" + Measure.VERSION + "'";
|
|
strSQL = strSQL + ")";
|
|
SystemDataObject.Instance.ExecuteSql(strSQL.ToString());
|
|
}
|
|
/// <summary>
|
|
/// 删除一个商品的规格
|
|
/// </summary>
|
|
/// <param name="GOODS_ID">商品ID</param>
|
|
public void DeleteGoodsMeasure(string GOODS_ID)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("delete from T_BASE_GOODS_MEASURE ");
|
|
strSql.Append(" where GOODS_ID=:GOODS_ID ");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":GOODS_ID",OracleDbType.Varchar2) };
|
|
parameters[0].Value = GOODS_ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 修改商品信息
|
|
/// </summary>
|
|
/// <param name="model">商品信息实体</param>
|
|
/// <returns></returns>
|
|
public void UpdateGoodsInfoProVider(JWGoodsInfoModel model, GoodsProviderModel providerModel)
|
|
{
|
|
|
|
|
|
//string strSQL = "";
|
|
//strSQL = strSQL + "insert into T_BASE_GOODS_PROVIDER(";
|
|
//strSQL = strSQL + "GOODS_ID,PROVIDER_ID,REMARK,VERSION";
|
|
//strSQL = strSQL + ")";
|
|
//strSQL = strSQL + " values (";
|
|
|
|
//strSQL = strSQL + "'" + model.GOODS_ID + "',";
|
|
//strSQL = strSQL + "'" + providerModel.PROVIDER_ID + "',";
|
|
//strSQL = strSQL + "'" + providerModel.REMARK + "',";
|
|
//strSQL = strSQL + "'" + providerModel.VERSION + "'";
|
|
//strSQL = strSQL + ")";
|
|
//SystemDataObject.Instance.ExecuteSql(strSQL.ToString());
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除商品信息
|
|
/// </summary>
|
|
/// <param name="strGoodsID">商品编号</param>
|
|
/// <returns></returns>
|
|
public void DeleteGoodsInfoMeasure(string strGoodsID )
|
|
{
|
|
string strSQL = "delete from T_BASE_GOODS_MEASURE where GOODS_ID = '" + strGoodsID + "' ";
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSQL);
|
|
|
|
}
|
|
public void DeleteMeasure(string strGoodsID, string GOODS_MEASURE_ID)
|
|
{
|
|
string strSQL = "delete from T_BASE_GOODS_MEASURE where GOODS_ID = '" + strGoodsID + "' and GOODS_MEASURE_ID='" + GOODS_MEASURE_ID + "' ";
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSQL);
|
|
|
|
}
|
|
/// <summary>
|
|
/// 删除商品信息
|
|
/// </summary>
|
|
/// <param name="strGoodsID">商品编号</param>
|
|
/// <returns></returns>
|
|
public void InsertGoodsBak(string strGoodsID)
|
|
{
|
|
string sqlStr = "insert into T_BASE_GOODS_BAK select * from T_BASE_GOODS where GOODS_ID='" + strGoodsID + "'";
|
|
|
|
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
|
}
|
|
/// <summary>
|
|
/// 删除商品信息
|
|
/// </summary>
|
|
/// <param name="strGoodsID">商品编号</param>
|
|
/// <returns></returns>
|
|
public void DeleteGoods(string strGoodsID)
|
|
{
|
|
string strSQL = string.Empty;
|
|
|
|
strSQL = "delete from T_BASE_GOODS where GOODS_ID = '" + strGoodsID + "' ";
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSQL);
|
|
}
|
|
}
|
|
}
|