”Open棟梁”は、長年の.NETアプリケーション開発実績にて蓄積したノウハウに基づき開発した.NET用アプリケーション フレームワークです。 (”OpenTouryo” , is an application framework for .NET which was developed using the accumulated know-how with a long track record in .NET application development.)
Home Page: https://opentouryo.osscons.jp
Corresponding to the TextBox.TextChanged event handling.
FxCmnFunction.AddControlToDic(ctrl, controlHt);
listView.ItemCommand += (EventHandler<ListViewCommandEventArgs>)eventHandlers[5];
FxCmnFunction.AddControlToDic(ctrl, controlHt); For example, if you want to join after the start,
Start workflow definition may be present at WorkflowNo >= 2.
スタート後に合流する場合など、
WorkflowNo = 2以上でスタートするWorkflow定義が存在し得る。
Change to conditions such as ActionType = "Start".
ActionType="Start"などの条件に変更する。
I request to create a "readme.md" that is written AsyncProcessingService setup procedures for check the operation by using the sample program to you. Please create "readme.md" at following locations.
https://github.com/OpenTouryoProject/OpenTouryo/tree/develop/root/programs/C%23/Frameworks/Infrastructure/ServiceInterface/AsyncProcessingService
棟梁のTouryo.Infrastructure.Pulic.IO.UnZipperにおいて、ExtractFileFromZipメソッドを使用して、zipファイルを解凍するとエンコードを設定していてもファイル名の文字化けが起こります。調査したところ、解凍に使用しているIonic.Zipのバージョンが1.9.1.5であり、このバージョンの場合、zip = new ZipFile(zipFileName, enc)とすると、ファイル名が設定された後にエンコーディングが設定されるため、文字化けが起こるようです。
At the Touryo.Infrastructure.Pulic.IO.UnZipper, file name's garble occurs, even if you set the encoding type when unzip the zip file using the ExtractFileFromZip method. Results of the investigation, I found to be due to the following reasons. Encoding type is set after the file name is set at ZipFile class's constructor in Ionic.Zip version 1.9.1.5.
public ZipFile(string fileName, System.Text.Encoding encoding) {
...
_InitInstance(fileName, null);
ProvisionalAlternateEncoding = encoding;
...
}となっており、ファイル名⇒エンコーディングの順で設定されています。
It has become as above, It is set in the order of file name ---> encoding type.
public ZipFile(string fileName, System.Text.Encoding encoding) {
...
AlternateEncoding = encoding;
AlternateEncodingUsage = ZipOption.Always;
_InitInstance(fileName, null);
...
}と処理の順番が入れ替えられているようです。
Processing order is swapped.
CONTRIBUTING.mdをルート階層に置くと、Web上であればIssue作成時やPR作成時にそこへのリンクが表示されます。このリポジトリへの貢献の仕方/ルール(どういう風な貢献を期待するか、使う言語は何か、等)を書いておくといいでしょう。
The following warning is output at the time of build.
Please investigate the cause of this warning and resolve.
warning CS1685 : The predefined type 'System.Runtime.CompilerServices.ExtensionAttribute' is defined in multiple assemblies in the global alias; using definition from 'c:\Progr
am Files\Reference Assemblies\Microsoft\Framework.NETFramework\v4.0\System.Core
.dll'
Because it is in the merge work,
Please send as text without committing the modification for the following issues.
Check point.
This is the same in data maintenance and table maintenance.
However, time stamp names are supposed common,
Therefore, input field in Form3 of data maintenance, there is only 1.
Further, when the update method input field is specified,
Update the time stamp column use the was set update method at input field at the time of update the record.
(This process, which is bundled with SQL that is automatically generated.
Therefore, it is not necessary to prepare the setting field how to update the timestamp Form3. )
And will not be displayed.
Set Timestamp to SQL parameter.
キャストにはas演算子を使うべきでtry...catchすべきでない
It should not try ... catch you should use the as operator to cast
At D-layer automatic generation tool (D層自動生成ツールにて)
There is a consideration of the schema when getting the table, but there is no consideration of the schema when getting the column. This problem occurs only in the auto-generated using the Oracle Database.
テーブルを取得するスキーマの考慮されているが、列を取得するときに、スキーマは考慮されていない。この問題は、Oracleデータベースを使用した自動生成でのみ発生する。
変更をマージする（-9月30日までに）
Changes to current,(今までの変更を、)
Please merge in the following order. (次の順序でマージしてください。)
If you want to specify the option in the WCF communication control function, In the current implementation, it is possible only in the section of config file.
https://github.com/OpenTouryoProject/OpenTouryo/blob/develop/root/programs/C%23/Samples/WebApp_sample/ProjectX_sample/web.config#L279
Please modify to possible specify WCF options settings such as proxy and authentication by using the communication control function API.
At the moment, it is only possible in ASP.NET Web service.
https://github.com/OpenTouryoProject/OpenTouryo/blob/develop/root/programs/C%23/Frameworks/Infrastructure/Framework/Transmission/CallController.cs#L416
The row count of the result of ProductsTableAdapter.SelectMethod is one too many.
/// <summary>データ取得処理を実装</summary>
/// <param name="startRowIndex">開始位置</param>
/// <param name="maximumRows">取得行数</param>
/// <returns>DataTable</returns>
public DataTable SelectMethod(int startRowIndex, int maximumRows)
{ DataTable dt = productsTableAdapter.SelectMethod(0, 30);The second argument of SelectMethod is "maximumRows".
Therefore, above program must return 30 records.
Therefore it is necessary to generate a TableAdapter as follows.
selectPagingSQL = string.Format(
selectPagingSqlTemplate,
new string[] {
parameterValue.ColumnList,
parameterValue.SortExpression,
parameterValue.SortDirection,
s + parameterValue.TableName + e , whereSQL,
startRowNum.ToString(), (startRowNum + parameterValue.MaximumRows - 1).ToString()}
).Replace("_p_", p).Replace("_s_", s).Replace("_e_", e).Replace("_f_", f);Can't submit in IE11 by "double submit prevention function" 's problem.
Can be determined that the IE11 by the presence or absence of "Trident" in the navigator.appName string.
if (navigator.appName == "Microsoft Internet Explorer") {if (navigator.appName == "Microsoft Internet Explorer" || navigator.appVersion.indexOf("Trident") != -1) {Below, the user agent list
http://www.openspc2.org/userAgent/
The following is considering how to respond.
VS1x0COMNTOOLS=C:\Program Files\Microsoft Visual Studio 1x.0\Common7\Tools\
VS1x0COMNTOOLS=C:\Program Files (x86)\Microsoft Visual Studio 1x.0\Common7\Tools\
https://github.com/OpenTouryoProject/OpenTouryo/tree/develop/root/files/tools/DGenTemplates
TextBox in GridView is not WebCustomTextBox.
Please correct the template.
<asp:TemplateField SortExpression="ProductID">
<ItemTemplate>
<asp:TextBox ReadOnly="true" BackColor="lightgray" ID="txtProductID" runat="server" Text='<%# Bind("ProductID") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ProductName">
<ItemTemplate>
<asp:TextBox ReadOnly="true" ID="txtProductName" runat="server" Text='<%# Bind("ProductName") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>I want to merge the following two libraries to "Portable Class Library".
This merge task will be use the VS2010 "Portable Class Library".
In the beginning, Investigate that the merge is possible or impossible.
Please merge to "Portable Class Library", if possible.
args.get_postBackElement() returns "undefine".
AjaxPostBackElement.disabled = xxxx;
↓
if (AjaxPostBackElement) {
AjaxPostBackElement.disabled = xxxx;
}現状の問題点を挙げます。
.NETではMSBuildやNuGetによる管理が標準的であり、それに従った方がメリットが大きいと考えます。
I want to move these codes to CustomMarshaler class
as "StringFromPrimitivetype" and "PrimitivetypeFromString" method.
https://github.com/OpenTouryoProject/OpenTouryo/blob/develop/root/programs/C%23/Frameworks/Infrastructure/Public/Util/CustomMarshaler.cs
Please set the commandtimeout value taken out of the Command object before execution of Command.
However, the above is possible only in your own Dao,
Implement the process of setting the CommandTimeout property after the "This.SetSQL ();" statement in ExecXXXX method.
The license templates on the source files state that the copyright owner is the Apache Software Foundation. For example, root/programs/C#/Frameworks/Infrastructure/CustomControl/Control/WebCustomButton.cs says:
// The ASF licenses this file to you under the Apache License, Version 2.0
Is this true? If not, the license templates should better be updated to declare the copyright owner, using the template included in license/LICENSE.txt.
Sorry for the nit-picking / please forgive me if the ownership of copyright has in fact been transferred to ASF. Thank you and good luck to the people working on the project!
<?xml version="1.0" encoding="shift_jis" ?>
<ROOT>
-- 説明・説明・説明・説明・説明
-- 2013/09/30 名前・名前・名前
-- ITEM_ORDER 1:ｘｘｘｘｘｘｘｘｘｘ
-- 2:ｙｙｙｙｙｙｙｙｙｙ
-- 3:ｚｚｚｚｚｚｚｚｚｚ
-- ■説明・説明・説明
SELECT
・・・
</ROOT>パラメータ・バインディングが無効です
パラメーター名:項目セット
場所 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
場所 Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
場所 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
場所 Touryo.Infrastructure.Public.Db.DamOraOdp.ExecSelectFill_DT(DataTable dt)
場所 Touryo.Infrastructure.Framework.Dao.BaseDao.ExecSelectFill_DT(DataTable dt)
場所 Touryo.Infrastructure.Business.Dao.CmnDao.ExecSelectFill_DT(DataTable dt)
場所 ・・・The following comment might have been interpreted as variables by odp.net.
Because, the exception has not occur, after these colon were changed to full-width from half-width.
-- 1:ｘｘｘｘｘｘｘｘｘｘ
-- 2:ｙｙｙｙｙｙｙｙｙｙ
-- 3:ｚｚｚｚｚｚｚｚｚｚ
▼ ▼ ▼
-- 1：ｘｘｘｘｘｘｘｘｘｘ
-- 2：ｙｙｙｙｙｙｙｙｙｙ
-- 3：ｚｚｚｚｚｚｚｚｚｚ
I think this reason is that it was not recognized as a comment.
It is not clear whether ODP.NET( or OracleClient) problems or OpenTouryo problems at present.
IE 9 ignores postback possible dialog's Width-Height properties by using Frameset.
The solution is to add following at page that contains the frameset.
<meta http-equiv = "x-ua-compatible" content = "IE = 7">
Target
This issue's modification not yet started by following reasons.
Due to the implementation of Turnbuck in confluence, can't turnbuck continuous. Maybe, there is a need to modify the SQL. Logic that get the User of Turnbuck destination also need to be modify.
合流地点でのTurnbuckの実装のせいで、連続Turnbuckできなくなった。多分、SQLを修正する必要がありそう。Turnbuck先のUser取得のロジックも修正が必要だろう。
Current implementation is suppressed to submit by pressing enter key.
There is a requirement to allow submit by pressing the enter key by explicitly attributes.
I think following implementation can cope with it.
<input type="text" size="10" cansubmitbyenter="true">if ((event.keyCode == 13) && !(event.srcElement.type == "submit" || event.srcElement.type == "textarea")) {
// enterの場合 (submitボタンやtextarea領域以外)
if (event.srcElement.cansubmitbyenter == null || event.srcElement.cansubmitbyenter == undefined) {
// cansubmitbyenter属性が定義されていない場合、enter不許可
return false;
}
else {
// cansubmitbyenter属性が定義されている場合
if (event.srcElement.cansubmitbyenter == "true") {
// cansubmitbyenter属性がtrueの場合は、enter許可(TextBoxの場合submit)。
}
else {
// cansubmitbyenter属性がfalseの場合は、enter不許可。
return false;
}
}
}
else {
// enterの場合もsubmitボタンやtextarea領域はenter許可
}Do not directly call a SetUp(), put a SetUp attribute when there is a need to call.
を直接呼び出すのではなくSetUp属性を付ける。
I want you to add support for event handling of the ListView by referring to the code in the event handling of GridView.
Search using the keyword "GridView" the following pages.
Please consider the events to be supported.
Windows Service that achieve asynchronous processing by used DBMS as a queue.
C# - How to Create a Windows Service - Part 1-3 - YouTube
http://www.youtube.com/watch?v=uM9o8GsO_u4
I have uploaded to the following URL.
https://github.com/OpenTouryoProject/OpenTouryoDocuments/blob/develop/documents/1_User_Guide/en/AsyncProcessingService/AsyncProcessingService_EN.xlsx
Note: Refer to the develop branch.
This function will be used in the Copy tool of Azure Storage.
The following URL is Copy tool of Azure Storage of specifications.
https://github.com/OpenTouryoProject/CloudOS/blob/develop/documents/AzureStorageBlobDataCopyWebsite/Specification_EN.xlsx
I want to provide the following changes to VB version.
AsyncProcessingService :
note : I aborted the VB migration of ServiceInterface.AsyncProcessingService.
Therefor, There is no need to migrate ServiceInterface.AsyncProcessingService to VB.
README.mdの修正
兼、コミットメッセージによるissue操作のテスト
Modification of README.md
And, test the issue operation with the commit message.
This is because DynInsParameter have problem.
Because ELSE tag is not set in the IF tag.
Automatic generation process of automatic generation tool.
this.DynInsParameters +=
"<IF>" + this.ParamSign + col.Replace(' ', '_') + ",</IF>" + ","; ↓ Modify as follows.
this.DynInsParameters +=
"<IF>" + this.ParamSign + col.Replace(' ', '_') + ",<ELSE></ELSE></IF>" + ","; oldStirng = "<IF>" + this.ParamSign + this.TimeStampColName.Replace(' ', '_') + ",</IF>";↓ Modify as follows.
oldStirng = "<IF>" + this.ParamSign + this.TimeStampColName.Replace(' ', '_') + ",<ELSE></ELSE></IF>";/ ***** Implementation of VB ***** /
Dim Param As SqlParameter = _
Param.SqlDbType = SqlDbType.Structured
Param.TypeName = "[dbo].[User-defined table type]"/ ***** Implementation of user-defined function ***** /
CREATE FUNCTION XXXXX
(
@AAAAA Integer
, @BBBBB Integer
, @CCCCC [dbo].[User-defined table type] READONLY
)You can not specify a DataTable by SetParameter method at the moment.
However, it is available in a implementation the following methods of self-made Dao + α.
Please refer to the following.
In implementation of this self-made Dao,
((DamSqlSvr) Me._dam.).SqlCommand.Parameters.add(new SqlParameter(···));As described above, to add parameters (* In this case, dynamic SQL of XML format is not supported).
In the future, I consider the overload of Me.SetParameter method that added the TypeName argument.
Reference information:
e.g. :
Unify "\root\programs\C#\Frameworks\Tools" 's culture of resource files to "ja".
Point of test
To verify such as if there is a problem with the functional level of OpenTouryo,
for example, by use the information of workflow patterns in the following HP.
Can be add related check processing by this modify.
The meaning of "Related check" is a check using the information in the DB.
Inherit the _3TierEngine and Override the UOC_RelatedCheck.
Implement the related check processing to UOC_RelatedCheck.
And change the tableadapter code that generated by table maintenance screen auto generation tool.
Like this.
// B層を生成
// _3TierEngine b = new _3TierEngine();
// XXXX class is inherit the _3TierEngine and override the UOC_RelatedCheck.
XXXX b = new XXXX();Modify to support by selection of data provider on automatic generation tool.
This is necessary to change the auto-generated templates and tools.
https://github.com/OpenTouryoProject/OpenTouryoDocuments/tree/master/documents/2_Tutorial/en
「シングルトンとして利用されるデザイン パターンを採用」という誤ったコメント
https://github.com/OpenTouryoProject/OpenTouryo/blob/01-00/root/programs/C%23/Frameworks/Infrastructure/Framework/Business/TransactionControl.cs#L76
このクラスはシングルトンではありません。
コメントが間違っているか、シングルトンパターンを間違って認識しているかでしょう。
Please porting the above function to the following location of ASP.NET MVC.
Session timeout detection function to detect the Session timeout using the session timeout detection cookie.
I want you to add support for SelectedIndexChanged event handling of the RadioButtonList and CheckBoxList. by referring to the code in the event handling of RadioButton and CheckBox.
Search using the keyword "SelectedIndexChanged" the following pages.
Also, will need to add the definition of the prefix of a RadioButtonList and CheckBoxList in app.config.
https://github.com/OpenTouryoProject/OpenTouryo/blob/develop/root/programs/C%23/Samples/WebApp_sample/ProjectX_sample/app.config#L8
And add the RadioButtonList and CheckBoxList test code to the test code of below.
https://github.com/OpenTouryoProject/OpenTouryo/blob/develop/root/programs/C%23/Samples/WebApp_sample/ProjectX_sample/Aspx/testFxLayerP/normal/testScreen2.aspx
The test case ID, rather than a parameterized, should be included in the test name or should be included in the Description attribute.
テストケースIDは、パラメタライズではなく、テスト名に含めるか、Description属性に含めるべき。
（まだ指示できてないのでリマインダです）
I want to derive the recommended method in this project.
I have checked javascript's "null and undefined" value for just in case.
e.g. : https://github.com/OpenTouryoProject/OpenTouryo/blob/develop/root/programs/C%23/Samples/WebApp_sample/ProjectX_sample/Framework/Js/common.js#L82
// hiddenがnullになることがある・・・
if (childScreenType == null || childScreenType == undefined) {
return;
} The information on the Internet, there is a lot of suggestion of a variety of ways.
全DBのデータプロバイダがないとビルドできない。
If there is not a data provider of all DB, can't build.
Change of the following PR # 6 has been removed by PR # 7.
Please investigate the conditions of occurrence of this problem.
Column name that begin with "AND" or "OR" characters in the SQL is cut at the editing process of the "Where tag".
<?xml version="1.0" encoding="utf-8" ?>
<ROOT>
SELECT
XXX,
YYY,
FROM
ZZZ
<WHERE>
WHERE
<IF> ANDXXX = @ANDXXX</IF>
</WHERE>
<PARAM> ANDXXX, String, AAA </PARAM>
</ROOT>If you give the parameters to "@andxxx",
SELECT
XXX,
YYY,
FROM
ZZZ
WHERE
ANDXXX = @ANDXXX SELECT
XXX,
YYY,
FROM
ZZZ
WHERE
XXX = @ANDXXXThe head of the "AND" or "OR" is deleted.
Is it like this.
// ANDが最初に現れる位置（★半角スペースを追加）
andIndex = where.IndexOf("AND ", startIndex, StringComparison.OrdinalIgnoreCase);
// ORが最初に現れる位置 （★半角スペースを追加）
orIndex = where.IndexOf("OR ", startIndex, StringComparison.OrdinalIgnoreCase);.NETアプリケーション開発に造詣の深い棟梁さんは、おいくつくらいの方ですか?
あと Open 棟梁って名前を考えた方はおいくつですか?
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.