/// <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 UpdateEntity(string lineCode, string status)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_LINEINFO", SqlType.UPDATE);
sqlCreate.AppendQuote("STATUS", status);
sqlCreate.AppendWhereQuote("LINECODE", lineCode);
ExecuteNonQuery(sqlCreate.GetSQL());
}
internal void Update(string cigaretteCode, string classSymbol, string cigaretteName)
{
SqlCreate sqlCreate = new SqlCreate("CIGARETTE", SqlType.UPDATE);
sqlCreate.AppendQuote("CIGARETTENAME", cigaretteName);
sqlCreate.AppendQuote("CLASS", classSymbol);
sqlCreate.AppendWhereQuote("CIGARETTECODE", cigaretteCode);
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());
}
public void UpdateEntity(string departmentID, string departmentName, string remark)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_DEPARTMENT", SqlType.UPDATE);
sqlCreate.AppendQuote("DEPARTMENTNAME", departmentName);
sqlCreate.AppendQuote("REMARK", remark);
sqlCreate.AppendWhereQuote("DEPARTMENTID", departmentID);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void UpdateEntity(string cigaretteCode,string cigaretteName,string isAbnormity, string barcode)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_CIGARETTE", SqlType.UPDATE);
sqlCreate.AppendQuote("CIGARETTENAME", cigaretteName);
sqlCreate.AppendQuote("ISABNORMITY", isAbnormity);
sqlCreate.AppendQuote("BARCODE", barcode);
sqlCreate.AppendWhereQuote("CIGARETTECODE", cigaretteCode);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void Update(DataRow row)
{
SqlCreate sqlCreate = new SqlCreate("AREA", SqlType.UPDATE);
sqlCreate.AppendQuote("AREANAME", row["AREANAME"]);
sqlCreate.AppendQuote("MEMO", row["MEMO"]);
sqlCreate.AppendWhereQuote("AREACODE", row["AREACODE"]);
string sql = sqlCreate.GetSQL();
ExecuteNonQuery(sql);
}
public void UpdateEntity(Dictionary<string, string> parameters)
{
foreach (string key in parameters.Keys)
{
SqlCreate sqlCreate = new SqlCreate("AS_SYS_PARAMETER", SqlType.UPDATE);
sqlCreate.AppendQuote("PARAMETERVALUE", parameters[key]);
sqlCreate.AppendWhereQuote("PARAMETERNAME", key);
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
public void UpdateEntity(string channelCode, string cigaretteCode, string cigaretteName, int quantity, string status, string isStockIn)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_STOCKCHANNEL", SqlType.UPDATE);
sqlCreate.AppendQuote("CIGARETTECODE", cigaretteCode.Trim());
sqlCreate.AppendQuote("CIGARETTENAME", cigaretteName.Trim());
sqlCreate.AppendQuote("REMAINQUANTITY", quantity);
sqlCreate.AppendQuote("STATUS", status);
sqlCreate.AppendQuote("ISSTOCKIN", isStockIn);
sqlCreate.AppendWhereQuote("CHANNELCODE", channelCode);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void UpdateEntity(string employeeCode, string employeeName, string departmentID, string status, string remark)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_EMPLOYEE", SqlType.UPDATE);
sqlCreate.AppendQuote("EMPLOYEECODE", employeeCode);
sqlCreate.AppendQuote("EMPLOYEENAME", employeeName);
sqlCreate.AppendQuote("DEPARTMENTID", departmentID);
sqlCreate.AppendQuote("STATUS", status);
sqlCreate.AppendQuote("REMARK", remark);
sqlCreate.AppendWhereQuote("EMPLOYEECODE", employeeCode);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void Update(DataRow row)
{
SqlCreate sqlCreate = new SqlCreate("SHELF", SqlType.UPDATE);
sqlCreate.AppendQuote("SHELFNAME", row["SHELFNAME"]);
sqlCreate.Append("SHELFCOLUMN", row["SHELFCOLUMN"]);
sqlCreate.Append("SHELFROW", row["SHELFROW"]);
sqlCreate.AppendQuote("CRANENO", row["CRANENO"]);
sqlCreate.AppendQuote("MEMO", row["MEMO"]);
sqlCreate.AppendWhereQuote("SHELFCODE", row["SHELFCODE"]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void Update(string billCode, string billName, int billType, int taskLevel, string memo)
{
SqlCreate sqlCreate = new SqlCreate("BILLTYPE", SqlType.UPDATE);
sqlCreate.AppendQuote("BILLNAME", billName);
sqlCreate.AppendQuote("BTYPE", billType);
sqlCreate.Append("TASKLEVEL", taskLevel);
sqlCreate.AppendQuote("MEMO", memo);
sqlCreate.AppendWhereQuote("BILLCODE", billCode);
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 UpdateEntity(DataSet dataSet)
{
foreach (DataRow dataRow in dataSet.Tables["AS_SYS_BARCODE"].Rows)
{
if (dataRow.RowState == DataRowState.Modified)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_CHANNEL", SqlType.UPDATE);
sqlCreate.AppendQuote("CIGARETTECODE", dataRow["CIGARETTECODE"]);
sqlCreate.AppendWhereQuote("CHANNELID", dataRow["CHANNELID", DataRowVersion.Original]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
}
}
public void UpdateMasterState(string billNo, string state, string userField, string userID, string dateField, string date)
{
SqlCreate sqlCreate = new SqlCreate("BILLMASTER", SqlType.UPDATE);
sqlCreate.AppendQuote("STATE", state);
sqlCreate.AppendQuote(userField, userID);
if (date.Trim().Length == 0)
sqlCreate.AppendQuote(dateField, "");
else
sqlCreate.Append(dateField, string.Format("TO_DATE('{0}','YYYY-MM-DD')", date));
sqlCreate.AppendWhereQuote("BILLNO", billNo);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void Update(string balanceID, string state, string userID, string balanceDate)
{
SqlCreate sqlCreate = new SqlCreate("BALANCEMASTER", SqlType.UPDATE);
sqlCreate.AppendQuote("STATE", state);
sqlCreate.AppendQuote("OPERATER", userID);
if (balanceDate != null)
sqlCreate.Append("BALANCEDATE", string.Format("TO_DATE('{0}', 'YYYY-MM-DD')", balanceDate));
else
sqlCreate.AppendQuote("BALANCEDATE", "");
sqlCreate.AppendWhereQuote("BALANCEID", balanceID);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void UpdateMaster(string formulaCode, string formulaName, string formulaDate, string cigaretteName, string quantity, string formulaNo, string operater)
{
SqlCreate sqlCreate = new SqlCreate("FORMULAMASTER", SqlType.UPDATE);
sqlCreate.AppendQuote("FORMULANAME", formulaName);
sqlCreate.Append("FORMULADATE", string.Format("TO_DATE('{0}','YYYY-MM-DD')", formulaDate));
sqlCreate.AppendQuote("CIGARETTENAME", THOKUtil.ToDBC(cigaretteName));
sqlCreate.Append("USECOUNT", quantity);
sqlCreate.Append("FORMULANO", formulaNo);
sqlCreate.AppendQuote("OPERATER", operater);
sqlCreate.AppendWhereQuote("FORMULACODE", formulaCode);
ExecuteNonQuery(sqlCreate.GetSQL());
}
internal void UpdateEntity(string channelID, string cigaretteCode, string cigaretteName, string status)
{
SqlCreate sqlCreate = new SqlCreate("AS_BI_CHANNEL", SqlType.UPDATE);
sqlCreate.AppendQuote("CIGARETTECODE", cigaretteCode.Trim());
sqlCreate.AppendQuote("CIGARETTENAME", cigaretteName.Trim());
sqlCreate.AppendQuote("STATUS", status);
sqlCreate.AppendWhereQuote("CHANNELID", channelID);
ExecuteNonQuery(sqlCreate.GetSQL());
string sql = "INSERT INTO AS_SC_BALANCE_OUT"+
" SELECT GETDATE(),LINECODE,CHANNELCODE,CHANNELNAME,CIGARETTECODE, CIGARETTENAME, "+
" SUM(QUANTITY) AS QUANTITY,0"+
" FROM AS_SC_BALANCE"+
" WHERE CHANNELID = '{0}'" +
" GROUP BY LINECODE,CHANNELCODE,CHANNELNAME,CIGARETTECODE, CIGARETTENAME"+
" HAVING ISNULL(SUM(QUANTITY),0) > 0 ";
ExecuteNonQuery(string.Format(sql, channelID));
sql = "DELETE FROM AS_SC_BALANCE WHERE CHANNELID = '{0}'";
ExecuteNonQuery(string.Format(sql, channelID));
}
internal void UpdateMaster(string billNo, string operater)
{
SqlCreate sqlCreate = new SqlCreate("PALLETMASTER", SqlType.UPDATE);
sqlCreate.AppendQuote("OPERATER", operater);
sqlCreate.Append("OPERATEDATE", "SYSDATE");
sqlCreate.AppendWhereQuote("BILLNO", billNo);
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void Update(string productCode, string original, string years, string grade, string style)
{
SqlCreate sqlCreate = new SqlCreate("PRODUCT", SqlType.UPDATE);
if (style == "其他")
sqlCreate.AppendQuote("PRODUCTNAME", "其他");
else
sqlCreate.AppendQuote("PRODUCTNAME", grade + original + years + style);
sqlCreate.AppendQuote("ORIGINAL", original);
sqlCreate.AppendQuote("YEARS", years);
sqlCreate.AppendQuote("GRADE", THOKUtil.ToDBC(grade));
sqlCreate.AppendQuote("STYLE", style);
sqlCreate.AppendWhereQuote("PRODUCTCODE", THOKUtil.ToDBC(productCode.Trim()));
ExecuteNonQuery(sqlCreate.GetSQL());
}
public void UpdateMaster2(DataRow masterRow)
{
SqlCreate sqlCreate = new SqlCreate("BILLMASTER", SqlType.UPDATE);
sqlCreate.AppendQuote("SCHEDULENO", masterRow["SCHEDULENO"]);
sqlCreate.AppendQuote("OPERATER", masterRow["OPERATER"]);
sqlCreate.Append("OPERATEDATE", string.Format("TO_DATE('{0}','YYYY-MM-DD')", masterRow["OPERATEDATE"]));
sqlCreate.AppendWhereQuote("BILLNO", masterRow["BILLNO"]);
ExecuteNonQuery(sqlCreate.GetSQL());
}
