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