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()); } }