private void UpdateOperationNumber() { int SqlExecResult = 0; string SqlExecString = ""; string NewValue = GetNewOperationNumber(); SqlExecString = "update DDGeneralParemeters set ParamValue='" + NewValue + "' where ParamName='OperationNumber'"; SqlExecResult = SqlTemp.Exec(SqlExecString); }
private void RemoveOperationLine(string iOperationID) { string SqlExecString = ""; int SqlExecResult = 0; string DeleteOperationID = ""; string NextOperationID = ""; string PreOperationID = ""; SqlResultTemp = SqlTemp.Query("select PreOperationID, NextOperationID from DDOperation where OperationID='" + iOperationID + "'"); SqlDataTemp = SqlResultTemp.GetResult(); while (SqlDataTemp.Read()) { DeleteOperationID = SqlDataTemp[0].ToString(); NextOperationID = SqlDataTemp[1].ToString(); } SqlDataTemp.Close(); SqlResultTemp = SqlTemp.Query("select PreOperationID, NextOperationID from DDOperation where OperationID='" + DeleteOperationID + "'"); SqlDataTemp = SqlResultTemp.GetResult(); while (SqlDataTemp.Read()) { PreOperationID = SqlDataTemp[0].ToString(); } SqlDataTemp.Close(); SqlExecString = "update DDOperation set NextOperationID='" + NextOperationID + "' where OperationID='" + PreOperationID + "'"; SqlExecResult = SqlTemp.Exec(SqlExecString); SqlExecString = "update DDOperation set OperationType=6 where OperationID='" + DeleteOperationID + "'"; SqlExecResult = SqlTemp.Exec(SqlExecString); SqlExecString = "update DDOperation set NextOperationID='" + NextOperationID + "' where OperationID='" + DeleteOperationID + "'"; SqlExecResult = SqlTemp.Exec(SqlExecString); SqlExecString = "delete from DDOperation where OperationID='" + iOperationID + "'"; SqlExecResult = SqlTemp.Exec(SqlExecString); SqlExecString = "update DDOperation set PreOperationID='" + PreOperationID + "' where OperationID='" + NextOperationID + "'"; SqlExecResult = SqlTemp.Exec(SqlExecString); }