Problem of Table Maintenance screen automatic generation. about opentouryo

[daisukenishino]

[TableName]Detail.aspx.cs

https://github.com/OpenTouryoProject/OpenTouryo/tree/develop/root/files/tools/DGenTemplates

(1)

Cause a problem because the record information selected using the update button is left.
[TableName]Detail.UOC_FormInit method requires a "Session["PrimaryKeyAndTimeStamp"] = null;" processing. Please correct the template.

  this.txtReorderLevel.Text = returnValue.Dt.Rows[0]["ReorderLevel"].ToString();
  this.txtDiscontinued.Text = returnValue.Dt.Rows[0]["Discontinued"].ToString();
  // 編集
  this.SetControlReadOnly(true);
  Session["PrimaryKeyAndTimeStamp"] = null;
  }
}

(2)

Although primary key is grayed out by default,
change to read only and gray out manually at the time of automatic numbering.
Please correct the template.

/// <summary>編集可否の制御</summary>
/// <param name="readOnly">読取専用プロパティ</param>
private void SetControlReadOnly(bool readOnly)
{
  // 編集可否
  // ReadOnly

  // 主キー
  this.txtID.ReadOnly = false; // true;
  this.txtID2.ReadOnly = false; // true;

  // 主キー以外
  this.txtVal.ReadOnly = readOnly;
  this.txtTimestamp.ReadOnly = readOnly;

  // 背景色
  // BackColor
  System.Drawing.Color backColor;

  if (readOnly)
  {
    backColor = System.Drawing.Color.LightGray;
  }
  else
  {
    backColor = System.Drawing.Color.Empty;
  }

  // 主キー
  this.txtID.BackColor = backColor; // System.Drawing.Color.LightGray;
  this.txtID2.BackColor = backColor; // System.Drawing.Color.LightGray;

  // 主キー以外
  this.txtVal.BackColor = backColor;
  this.txtTimestamp.BackColor = backColor;
}

[daisukenishino]

[TableName]SearchAndUpdate.aspx.cs

Following parts ( ・・・ ) also I want to generate automatically.

// 主キー列
parameterValue.AndEqualSearchConditions.Add("ID(ColumnName)", "");
// タイムスタンプ列
// ・・・

As follows.

// 主キー列
parameterValue.AndEqualSearchConditions.Add("ID(ColumnName)", "");
// タイムスタンプ列
parameterValue.AndEqualSearchConditions.Add("Timestamp(ColumnName)", "");

[daisukenishino]

_3TierEngine

https://github.com/OpenTouryoProject/OpenTouryo/blob/develop/root/programs/C%23/Frameworks/Infrastructure/Business/Business/_3TierEngine.cs

(1) UOC_SelectMethod

The following problem occurs when be generated automatically to run on Oracle.
Double enclosure character ( ""SHIPPERS"" ).

SELECT "SHIPPERID", "COMPANYNAME", "PHONE" FROM (
  SELECT "SHIPPERID", "COMPANYNAME", "PHONE", ROW_NUMBER() OVER (ORDER BY "SHIPPERID" ASC) "RNUM"
    FROM ""SHIPPERS"" WHERE "SHIPPERID" = :SHIPPERID)
  WHERE "RNUM" BETWEEN 1 AND 31

There is a need to be modified as follows.
Before

private const string SELECT_PAGING_SQL_TEMPLATE_ORACLE = "SELECT {0} FROM ( SELECT {0}, ROW_NUMBER() OVER (ORDER BY \"{1}\" {2}) \"RNUM\" FROM \"{3}\" {4} ) WHERE \"RNUM\" BETWEEN {5} AND {6}"; 

After

private const string SELECT_PAGING_SQL_TEMPLATE_ORACLE = "SELECT {0} FROM ( SELECT {0}, ROW_NUMBER() OVER (ORDER BY \"{1}\" {2}) \"RNUM\" FROM {3} {4} ) WHERE \"RNUM\" BETWEEN {5} AND {6}";

(2) UOC_RelatedCheck

Can not be called only derivation ends with automatic sorting process.
Therefore, it is necessary to review the implementations of the related check process.

Change the signature of the CRUD methods. "private" ---> "protected virtual"

[daisukenishino2]

I ask to HODC.
Does this issue is complete by the pullrequest#81 ?
I think this issue has been completed. Please let me know.

[daisukenishino]

TableMaintenance was confirmed to operate properly by the pullrequest#81.

• Therefore, I will close this Issue.
• You can see the evidence.