internal void InsertStockChannelUsed(string orderDate, int batchNo, DataTable channelTable)
{
foreach (DataRow row in channelTable.Rows)
{
SqlCreate sqlCreate = new SqlCreate("AS_SC_STOCKCHANNELUSED", SqlType.INSERT);
sqlCreate.AppendQuote("ORDERDATE", orderDate);
sqlCreate.Append("BATCHNO", batchNo);
sqlCreate.AppendQuote("CHANNELCODE", row["CHANNELCODE"]);
sqlCreate.AppendQuote("CHANNELNAME", row["CHANNELNAME"]);
sqlCreate.AppendQuote("CHANNELTYPE", row["CHANNELTYPE"]);
sqlCreate.AppendQuote("CIGARETTECODE", row["CIGARETTECODE"]);
sqlCreate.AppendQuote("CIGARETTENAME", row["CIGARETTENAME"]);
sqlCreate.Append("QUANTITY", row["QUANTITY"]);
sqlCreate.Append("REMAINQUANTITY", row["REMAINQUANTITY"]);
sqlCreate.Append("ORDERNO", row["ORDERNO"]);
sqlCreate.Append("LEDNO", row["LEDNO"]);
sqlCreate.AppendQuote("STATUS", row["STATUS"]);
sqlCreate.AppendQuote("ISSTOCKIN", row["ISSTOCKIN"]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
/// <summary>
/// 2010-11-21
/// </summary>
/// <param name="channelTable"></param>
public void UpdateQuantity(DataTable channelTable, bool isUseBalance)
{
foreach (DataRow channelRow in channelTable.Rows)
{
string sql = "UPDATE AS_SC_CHANNELUSED SET CIGARETTECODE = '{0}',CIGARETTENAME = '{1}',QUANTITY={2} " +
" WHERE ORDERDATE='{3}' AND BATCHNO='{4}' AND LINECODE='{5}' AND CHANNELCODE='{6}'";
ExecuteNonQuery(string.Format(sql, channelRow["CIGARETTECODE"], channelRow["CIGARETTENAME"], channelRow["QUANTITY"],
channelRow["ORDERDATE"], channelRow["BATCHNO"].ToString().Trim(), channelRow["LINECODE"], channelRow["CHANNELCODE"]));
if (isUseBalance && channelRow["CHANNELTYPE"].ToString() == "3" && channelRow["CIGARETTECODE"].ToString() == channelRow["D_CIGARETTECODE"].ToString())
{
SqlCreate sqlCreate = new SqlCreate("AS_SC_BALANCE", SqlType.INSERT);
sqlCreate.AppendQuote("ORDERDATE", channelRow["ORDERDATE"]);
sqlCreate.Append("BATCHNO", channelRow["BATCHNO"]);
sqlCreate.AppendQuote("CHANNELID", channelRow["CHANNELID"]);
sqlCreate.AppendQuote("LINECODE", channelRow["LINECODE"]);
sqlCreate.AppendQuote("CHANNELCODE", channelRow["CHANNELCODE"]);
sqlCreate.AppendQuote("CHANNELNAME", channelRow["CHANNELNAME"]);
sqlCreate.AppendQuote("CIGARETTECODE", channelRow["CIGARETTECODE"]);
sqlCreate.AppendQuote("CIGARETTENAME", channelRow["CIGARETTENAME"]);
int quantity = Convert.ToInt32(channelRow["QUANTITY"]) % 50;
int balance = Convert.ToInt32(channelRow["BALANCE"]);
sqlCreate.Append("QUANTITY", balance >= quantity ? 0 - quantity : 50 - quantity);
ExecuteNonQuery(sqlCreate.GetSQL());
}
else
{
ExecuteNonQuery(string.Format("DELETE FROM AS_SC_BALANCE WHERE CHANNELID = '{0}'", channelRow["CHANNELID"]));
}
}
}
public void InsertHandSupplyOrders(DataTable newSupplyOrders)
{
foreach (DataRow dataRow in newSupplyOrders.Rows)
{
SqlCreate sqlCreate = new SqlCreate("AS_SC_HANDLESUPPLY", SqlType.INSERT);
sqlCreate.AppendQuote("ORDERDATE", dataRow["ORDERDATE"]);
sqlCreate.AppendQuote("BATCHNO", dataRow["BATCHNO"]);
sqlCreate.AppendQuote("LINECODE", dataRow["LINECODE"]);
sqlCreate.Append("SORTNO", dataRow["SORTNO"]);
sqlCreate.AppendQuote("SUPPLYBATCH", dataRow["SUPPLYBATCH"]);
sqlCreate.AppendQuote("ORDERID", dataRow["ORDERID"]);
sqlCreate.AppendQuote("CIGARETTECODE", dataRow["CIGARETTECODE"]);
sqlCreate.AppendQuote("CIGARETTENAME", dataRow["CIGARETTENAME"]);
sqlCreate.AppendQuote("CHANNELCODE", dataRow["CHANNELCODE"]);
sqlCreate.Append("QUANTITY", dataRow["QUANTITY"]);
sqlCreate.AppendQuote("STATUS", "0");
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
//public void SaveOrder(DataTable orderTable)
//{
// foreach (DataRow orderRow in orderTable.Rows)
// {
// SqlCreate sql = new SqlCreate("AS_SC_ORDER", SqlType.INSERT);
// sql.AppendQuote("ORDERDATE", orderRow["ORDERDATE"]);
// sql.Append("BATCHNO", orderRow["BATCHNO"]);
// sql.AppendQuote("LINECODE", orderRow["LINECODE"]);
// sql.Append("SORTNO", orderRow["SORTNO"]);
// sql.Append("PALLETNO", orderRow["PALLETNO"]);
// sql.AppendQuote("CHANNELCODE", orderRow["CHANNELCODE"]);
// sql.AppendQuote("CIGARETTECODE", orderRow["CIGARETTECODE"]);
// sql.AppendQuote("CIGARETTENAME", orderRow["CIGARETTENAME"]);
// sql.Append("QUANTITY", orderRow["QUANTITY"]);
// ExecuteNonQuery(sql.GetSQL());
// }
//}
public void SaveOrderMaster(DataTable masterTable)
{
foreach (DataRow orderRow in masterTable.Rows)
{
SqlCreate sql = new SqlCreate("AS_SC_PALLETMASTER", SqlType.INSERT);
sql.AppendQuote("ORDERDATE", orderRow["ORDERDATE"]);
sql.Append("BATCHNO", orderRow["BATCHNO"]);
sql.AppendQuote("LINECODE", orderRow["LINECODE"]);
sql.Append("SORTNO", orderRow["SORTNO"]);
sql.AppendQuote("ORDERID", orderRow["ORDERID"]);
sql.AppendQuote("AREACODE", orderRow["AREACODE"]);
sql.AppendQuote("AREANAME", orderRow["AREANAME"]);
sql.AppendQuote("ROUTECODE", orderRow["ROUTECODE"]);
sql.AppendQuote("ROUTENAME", orderRow["ROUTENAME"]);
sql.AppendQuote("CUSTOMERCODE", orderRow["CUSTOMERCODE"]);
sql.AppendQuote("CUSTOMERNAME", orderRow["CUSTOMERNAME"]);
sql.AppendQuote("ADDRESS", orderRow["ADDRESS"]);
sql.AppendQuote("ORDERNO", orderRow["ORDERNO"]);
sql.Append("QUANTITY", orderRow["QUANTITY"]);
sql.Append("ABNORMITY_QUANTITY", orderRow["ABNORMITY_QUANTITY"]);
ExecuteNonQuery(sql.GetSQL());
}
}
public void InsertNewSupplyOrders(DataTable newSupplyOrders)
{
foreach (DataRow dataRow in newSupplyOrders.Rows)
{
SqlCreate sqlCreate = new SqlCreate("AS_SC_ORDER", SqlType.INSERT);
sqlCreate.AppendQuote("ORDERDATE", dataRow["ORDERDATE"]);
sqlCreate.AppendQuote("BATCHNO", dataRow["BATCHNO"]);
sqlCreate.AppendQuote("LINECODE", dataRow["LINECODE"]);
sqlCreate.Append("SORTNO", dataRow["SORTNO"]);
sqlCreate.AppendQuote("ORDERID", dataRow["ORDERID"]);
sqlCreate.Append("ORDERNO", dataRow["ORDERNO"]);
sqlCreate.AppendQuote("CIGARETTECODE", dataRow["CIGARETTECODE"]);
sqlCreate.AppendQuote("CIGARETTENAME", dataRow["CIGARETTENAME"]);
sqlCreate.AppendQuote("CHANNELCODE", dataRow["CHANNELCODE"]);
sqlCreate.AppendQuote("CHANNELGROUP", dataRow["CHANNELGROUP"]);
sqlCreate.AppendQuote("CHANNELORDER", dataRow["CHANNELORDER"]);
sqlCreate.Append("QUANTITY", dataRow["QUANTITY"]);
sqlCreate.Append("EXPORTNO", dataRow["EXPORTNO"]);
sqlCreate.Append("PACKNO", dataRow["PACKNO"]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
public void Insert(int stockInID, int batchNo, string channelCode, string cigaretteCode, string cigaretteName, string barode, string state)
{
SqlCreate sqlCreate = new SqlCreate("AS_STOCK_IN", SqlType.INSERT);
sqlCreate.Append("STOCKINID", stockInID);
sqlCreate.Append("BATCHNO", batchNo);
sqlCreate.AppendQuote("CHANNELCODE", channelCode);
sqlCreate.AppendQuote("CIGARETTECODE", cigaretteCode);
sqlCreate.AppendQuote("CIGARETTENAME", cigaretteName);
sqlCreate.AppendQuote("BARCODE", barode);
sqlCreate.AppendQuote("STATE", state);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void InsertBatch(int batchNo, string channelCode, string cigaretteCode, string cigaretteName, int quantity, int StockRemainQuantity)
{
SqlCreate sqlCreate = new SqlCreate("AS_STOCK_IN_BATCH", SqlType.INSERT);
sqlCreate.Append("BATCHNO", batchNo);
sqlCreate.AppendQuote("CHANNELCODE", channelCode);
sqlCreate.AppendQuote("CIGARETTECODE", cigaretteCode);
sqlCreate.AppendQuote("CIGARETTENAME", cigaretteName);
sqlCreate.Append("QUANTITY", quantity);
sqlCreate.Append("INQUANTITY", StockRemainQuantity);
sqlCreate.AppendQuote("T1", DateTime.Now.ToString());
sqlCreate.AppendQuote("STATE", StockRemainQuantity == quantity ? "1" : "0");
string sql = sqlCreate.GetSQL();
ExecuteNonQuery(sql);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dataSet"></param>
public void UpdateEntity(string sortID, string areaCode)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_AREA", SqlType.UPDATE);
sqlCreate.Append("SORTID", sortID);
sqlCreate.AppendWhereQuote("AREACODE", areaCode);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void SaveOrderSchedule(DataTable orderTable)
{
foreach (DataRow orderRow in orderTable.Rows)
{
SqlCreate sql = new SqlCreate("AS_SC_ORDER", SqlType.INSERT);
sql.Append("SORTNO", orderRow["SORTNO"]);
sql.AppendQuote("LINECODE", orderRow["LINECODE"]);
sql.AppendQuote("BATCHNO", orderRow["BATCHNO"]);
sql.AppendQuote("ORDERID", orderRow["ORDERID"]);
sql.Append("ORDERNO", 1);
sql.AppendQuote("ORDERDATE", orderRow["ORDERDATE"]);
sql.AppendQuote("CIGARETTECODE", orderRow["CIGARETTECODE"]);
sql.AppendQuote("CIGARETTENAME", orderRow["CIGARETTENAME"]);
sql.AppendQuote("CHANNELCODE", orderRow["CHANNELCODE"]);
sql.Append("QUANTITY", orderRow["QUANTITY"]);
ExecuteNonQuery(sql.GetSQL());
}
}
//zys_2011-10-05
internal void Insert(int outID, DataTable supplyTable)
{
foreach (DataRow row in supplyTable.Rows)
{
SqlCreate sqlCreate = new SqlCreate("AS_STOCK_OUT", SqlType.INSERT);
sqlCreate.Append("STOCKOUTID", ++outID);
sqlCreate.AppendQuote("ORDERDATE", row["ORDERDATE"]);
sqlCreate.Append("BATCHNO", row["BATCHNO"]);
sqlCreate.AppendQuote("LINECODE", row["LINECODE"]);
sqlCreate.Append("SORTNO", row["SORTNO"]);
sqlCreate.Append("SERIALNO", row["SERIALNO"]);
sqlCreate.AppendQuote("CIGARETTECODE", row["CIGARETTECODE"]);
sqlCreate.AppendQuote("CIGARETTENAME", row["CIGARETTENAME"]);
sqlCreate.AppendQuote("BARCODE", row["BARCODE"]);
sqlCreate.AppendQuote("CHANNELCODE", row["CHANNELCODE"]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
/// <summary>
/// ¸üÐÂ
/// </summary>
/// <param name="dataSet"></param>
public void UpdateEntity(string sortID, string lineCode, string routeCode)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_ROUTE", SqlType.UPDATE);
sqlCreate.Append("SORTID", sortID);
sqlCreate.AppendQuote("LINECODE", lineCode);
sqlCreate.AppendWhereQuote("ROUTECODE", routeCode);
ExecuteNonQuery(sqlCreate.GetSQL());
}
/// <summary>
/// 2010-11-21
/// </summary>
/// <param name="channelTable"></param>
public void UpdateChannel(DataTable channelTable)
{
foreach (DataRow row in channelTable.Rows)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_STOCKCHANNEL", SqlType.UPDATE);
sqlCreate.AppendQuote("CIGARETTECODE", row["CIGARETTECODE"]);
sqlCreate.AppendQuote("CIGARETTENAME", row["CIGARETTENAME"]);
sqlCreate.Append("QUANTITY", row["QUANTITY"]);
sqlCreate.AppendWhereQuote("CHANNELCODE", row["CHANNELCODE"]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
public void InsertSupply(DataTable supplyTable, string lineCode, string orderDate, int batchNo)
{
if (this.lineCode != lineCode)
{
this.lineCode = lineCode;
string sql = string.Format("SELECT CASE WHEN MAX(SERIALNO) IS NULL THEN 1000 ELSE MAX(SERIALNO) END FROM AS_SC_SUPPLY WHERE LINECODE='{0}' AND ORDERDATE = '{1}' AND BATCHNO = {2} ", lineCode, orderDate, batchNo);
serialNo = Convert.ToInt32(ExecuteScalar(sql));
}
foreach (DataRow row in supplyTable.Rows)
{
SqlCreate sqlCreate = new SqlCreate("AS_SC_SUPPLY", SqlType.INSERT);
sqlCreate.AppendQuote("ORDERDATE", row["ORDERDATE"]);
sqlCreate.Append("BATCHNO", row["BATCHNO"]);
sqlCreate.Append("SERIALNO", serialNo++);
sqlCreate.AppendQuote("LINECODE", row["LINECODE"]);
sqlCreate.Append("ORIGINALSORTNO", row["SORTNO"]);
sqlCreate.Append("SORTNO", row["SORTNO"]);
sqlCreate.Append("GROUPNO", row["GROUPNO"]);
sqlCreate.Append("CHANNELGROUP", row["CHANNELGROUP"]);
sqlCreate.AppendQuote("CHANNELCODE", row["CHANNELCODE"]);
sqlCreate.AppendQuote("CIGARETTECODE", row["CIGARETTECODE"]);
sqlCreate.AppendQuote("CIGARETTENAME", row["CIGARETTENAME"]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
/// <summary>
/// 2010-11-21
/// </summary>
/// <param name="supplyTable"></param>
public void InsertSupply(DataTable supplyTable, bool isUseSerialNo)
{
DataRow[] rows = supplyTable.Select("", "BATCH,SERIALNO");
int serialNo = 1;
foreach (DataRow row in rows)
{
SqlCreate sqlCreate = new SqlCreate("AS_SC_SUPPLY", SqlType.INSERT);
sqlCreate.AppendQuote("ORDERDATE", row["ORDERDATE"]);
sqlCreate.Append("BATCHNO", row["BATCHNO"]);
sqlCreate.AppendQuote("LINECODE", row["LINECODE"]);
sqlCreate.Append("SERIALNO", isUseSerialNo ? row["SERIALNO"] : serialNo++);
sqlCreate.Append("ORIGINALSORTNO", row["SORTNO"]);
sqlCreate.Append("SORTNO", row["SORTNO"]);
sqlCreate.AppendQuote("CIGARETTECODE", row["CIGARETTECODE"]);
sqlCreate.AppendQuote("CIGARETTENAME", row["CIGARETTENAME"]);
sqlCreate.AppendQuote("CHANNELCODE", row["CHANNELCODE"]);
sqlCreate.Append("CHANNELGROUP", row["CHANNELGROUP"]);
sqlCreate.Append("GROUPNO", row["GROUPNO"]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
/// <summary>
/// 2010-11-21
/// </summary>
/// <param name="mixTable"></param>
public void InsertMixChannel(DataTable mixTable)
{
foreach (DataRow row in mixTable.Rows)
{
SqlCreate sqlCreate = new SqlCreate("AS_SC_STOCKMIXCHANNEL", SqlType.INSERT);
sqlCreate.AppendQuote("ORDERDATE", row["ORDERDATE"]);
sqlCreate.Append("BATCHNO", row["BATCHNO"]);
sqlCreate.AppendQuote("CHANNELCODE", row["CHANNELCODE"]);
sqlCreate.AppendQuote("CIGARETTECODE", row["CIGARETTECODE"]);
sqlCreate.AppendQuote("CIGARETTENAME", row["CIGARETTENAME"]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
/// <summary>
/// 2010-11-19
/// </summary>
/// <param name="lineTable"></param>
public void SaveLineSchedule(DataTable lineTable)
{
foreach (DataRow lineRow in lineTable.Rows)
{
SqlCreate sqlCreate = new SqlCreate("AS_SC_LINE", SqlType.INSERT);
sqlCreate.AppendQuote("LINECODE", lineRow["LINECODE"]);
sqlCreate.AppendQuote("ROUTECODE", lineRow["ROUTECODE"]);
sqlCreate.Append("QUANTITY", lineRow["QUANTITY"]);
sqlCreate.AppendQuote("BATCHNO", lineRow["BATCHNO"]);
sqlCreate.AppendQuote("ORDERDATE", lineRow["ORDERDATE"]);
string sql = sqlCreate.GetSQL();
ExecuteNonQuery(sql);
}
}
public void InsertEntity(string orderDate, int batchNo)
{
DateTime SCDATE = DateTime.Parse(orderDate);
SqlCreate sqlCreate = new SqlCreate("AS_BI_BATCH", SqlType.INSERT);
sqlCreate.Append("BATCHNO", batchNo);
sqlCreate.AppendQuote("BATCHNAME", string.Format("{0}第{1}批次", orderDate, batchNo));
sqlCreate.AppendQuote("ORDERDATE", orderDate);
sqlCreate.AppendQuote("ISVALID", 0);
sqlCreate.AppendQuote("EXECUTEUSER", 0);
sqlCreate.AppendQuote("EXECUTEIP", 0);
sqlCreate.AppendQuote("ISUPTONOONEPRO", 0);
sqlCreate.AppendQuote("SCDATE", DateTime.Now.ToShortDateString());
ExecuteNonQuery(sqlCreate.GetSQL());
}
//zys_2011-10-06
internal void InsertBatch(int batchNo, string lineCode, string channelGroup, string channelType, int sortNo, int quantity)
{
SqlCreate sqlCreate = new SqlCreate("AS_STOCK_OUT_BATCH", SqlType.INSERT);
sqlCreate.Append("BATCHNO", batchNo);
sqlCreate.AppendQuote("LINECODE", lineCode);
sqlCreate.Append("CHANNELGROUP", channelGroup);
sqlCreate.Append("CHANNELTYPE", channelType);
sqlCreate.Append("SORTNO", sortNo);
sqlCreate.Append("QUANTITY", quantity);
sqlCreate.Append("OUTQUANTITY", 0);
string sql = sqlCreate.GetSQL();
ExecuteNonQuery(sql);
}
/// <summary>
/// 2010-11-19 todo
/// </summary>
/// <param name="channelTable"></param>
/// <param name="orderDate"></param>
/// <param name="batchNo"></param>
public void SaveChannelSchedule(DataTable channelTable, string orderDate, int batchNo)
{
foreach (DataRow channelRow in channelTable.Rows)
{
SqlCreate sql = new SqlCreate("AS_SC_CHANNELUSED", SqlType.INSERT);
sql.AppendQuote("ORDERDATE", orderDate);
sql.AppendQuote("BATCHNO", batchNo);
sql.AppendQuote("CHANNELID", channelRow["CHANNELID"]);
sql.AppendQuote("LINECODE", channelRow["LINECODE"]);
sql.AppendQuote("CHANNELCODE", channelRow["CHANNELCODE"]);
sql.AppendQuote("CHANNELNAME", channelRow["CHANNELNAME"]);
sql.AppendQuote("CHANNELTYPE", channelRow["CHANNELTYPE"]);
sql.AppendQuote("CIGARETTECODE", channelRow["CIGARETTECODE"]);
sql.AppendQuote("CIGARETTENAME", channelRow["CIGARETTENAME"]);
sql.Append("QUANTITY", channelRow["QUANTITY"]);
sql.AppendQuote("STATUS", channelRow["STATUS"]);
sql.AppendQuote("LEDGROUP", channelRow["LEDGROUP"]);
sql.AppendQuote("LEDNO", channelRow["LEDNO"]);
sql.AppendQuote("LED_X", channelRow["LED_X"]);
sql.AppendQuote("LED_Y", channelRow["LED_Y"]);
sql.AppendQuote("LED_WIDTH", channelRow["LED_WIDTH"]);
sql.AppendQuote("LED_HEIGHT", channelRow["LED_HEIGHT"]);
sql.AppendQuote("GROUPNO", channelRow["GROUPNO"]);
sql.AppendQuote("CHANNELGROUP", channelRow["CHANNELGROUP"]);
sql.AppendQuote("CHANNELORDER", channelRow["CHANNELORDER"]);
sql.AppendQuote("CHANNELADDRESS", channelRow["CHANNELADDRESS"]);
sql.AppendQuote("SUPPLYADDRESS", channelRow["SUPPLYADDRESS"]);
ExecuteNonQuery(sql.GetSQL());
}
}
/// <summary>
/// 2010-11-21 todo
/// </summary>
/// <param name="masterTable"></param>
/// <param name="tableName"></param>
public void SaveOrderMaster(DataTable masterTable, string tableName)
{
foreach (DataRow orderRow in masterTable.Rows)
{
SqlCreate sql = new SqlCreate(tableName, SqlType.INSERT);
sql.AppendQuote("ORDERDATE", orderRow["ORDERDATE"]);
sql.Append("BATCHNO", orderRow["BATCHNO"]);
sql.AppendQuote("LINECODE", orderRow["LINECODE"]);
sql.Append("SORTNO", orderRow["SORTNO"]);
sql.AppendQuote("ORDERID", orderRow["ORDERID"]);
sql.AppendQuote("AREACODE", orderRow["AREACODE"]);
sql.AppendQuote("AREANAME", orderRow["AREANAME"]);
sql.AppendQuote("ROUTECODE", orderRow["ROUTECODE"]);
sql.AppendQuote("ROUTENAME", orderRow["ROUTENAME"]);
sql.AppendQuote("CUSTOMERCODE", orderRow["CUSTOMERCODE"]);
sql.AppendQuote("CUSTOMERNAME", orderRow["CUSTOMERNAME"]);
sql.AppendQuote("LICENSENO", orderRow["LICENSENO"]);
sql.AppendQuote("ADDRESS", orderRow["ADDRESS"]);
sql.AppendQuote("CUSTOMERSORTNO", orderRow["CUSTOMERSORTNO"]);
sql.AppendQuote("ORDERNO", orderRow["ORDERNO"]);
sql.Append("QUANTITY", orderRow["QUANTITY"]);
sql.Append("QUANTITY1", orderRow["QUANTITY1"]);
sql.Append("ABNORMITY_QUANTITY", orderRow["ABNORMITY_QUANTITY"]);
sql.Append("EXPORTNO", orderRow["EXPORTNO"]);
sql.Append("EXPORTNO1", orderRow["EXPORTNO1"]);
sql.AppendQuote("PACKNO", orderRow["PACKNO"]);
sql.AppendQuote("PACKNO1", orderRow["PACKNO1"]);
ExecuteNonQuery(sql.GetSQL());
}
}