private void btnSet_Click(object sender, EventArgs e)
{
NestQueryParameter parameter = new NestQueryParameter();
#region strQueryColumns
string strQueryColumns = string.Empty;
foreach (var item in lstQueryFileds.CheckedItems)
{
var dr = item as DataRowView;
if (dr != null)
{
strQueryColumns = strQueryColumns + dr.Row["Name"] + ",";
}
}
strQueryColumns = strQueryColumns.TrimEnd(',');
#endregion
parameter.QueryColumns = strQueryColumns;
parameter.CodeGenType = CodeGenType.WinFromNestQuery;
FrmControlSetting frmSetting = new FrmControlSetting(parameter);
if (frmSetting.ShowDialog() == DialogResult.OK)
{
QueryDataTable = frmSetting.QueryDataTable;
this.DialogResult = DialogResult.OK;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
string strReturnMsg = CheckInput(m_codeGenType);
if (strReturnMsg != string.Empty)
{
MessageBox.Show(strReturnMsg);
return;
}
BasicParameter basicParameter = ParameterManager.GetBasicParameter(string.Empty);
StringBuilder sbSql = new StringBuilder();
sbSql.Append("\"");
sbSql.Append(txtSql.Text.Replace("\r\n", " "));
sbSql.Append(" WHERE \" + strWhere + \" ");
sbSql.Append(txtSql1.Text.Replace("\r\n", " "));
sbSql.Append(" ");
sbSql.Append(txtSql2.Text.Replace("\r\n", " "));
sbSql.Append("\"");
NestQueryParameter nestQueryParameter = new NestQueryParameter
{
CodeGenType = CodeGenType.WinFromNestQuery,
Key1 = txtKey.Text.Trim(),
Key2 = txtKey1.Text.Trim(),
Key3 = txtKey2.Text.Trim(),
Sql = sbSql.ToString(),
DataTableQuery = m_dtQuery,
FormClassName = txtClassName.Text.Trim()
};
CodeMakeDirector director = new CodeMakeDirector();
CodeMakeBulider bulider = new TemplateWinFormNestQuery();
string[] strArray = director.Construct(bulider, basicParameter, nestQueryParameter);
string strFrmDialogClassName = txtClassName.Text.Trim() + ".cs";
string strContentCS = strArray[0];
FileHelper.GenFile(basicParameter.OutFolderPath + "\\Code\\", strFrmDialogClassName, strContentCS, false);
string strFrmDialogClassNameDesigner = txtClassName.Text.Trim() + ".Designer.cs";
string strContentDesigner = strArray[1];
FileHelper.GenFile(basicParameter.OutFolderPath + "\\Code\\", strFrmDialogClassNameDesigner, strContentDesigner);
}
private void SetGlobal(BaseParameter baseParameter)
{
switch (baseParameter.CodeGenType)
{
#region WinFromSimpleQuery
case CodeGenType.WinFromSimpleQuery:
SimpleQueryParameter simpleQueryParameter = baseParameter as SimpleQueryParameter;
if (simpleQueryParameter != null)
{
m_strQueryColumns = simpleQueryParameter.QueryColumns;
m_strShowColumns = simpleQueryParameter.ShowColumns;
m_databaseTable = simpleQueryParameter.DatabaseTable;
m_codeGenType = simpleQueryParameter.CodeGenType;
m_frameworkType = simpleQueryParameter.FrameworkType;
m_uiStyle = simpleQueryParameter.UiStyle;
m_listBindType = simpleQueryParameter.ListBindType;
gridVEdit.Visible = false;
tabPageEdit.Parent = null;
tabPageEdit.Hide();
gridVShow.Visible = true;
tabPageShow.Parent = tabControl1;
tabPageShow.Show();
}
break;
#endregion
#region WinFromEditWithDialog/WinFromTreeEditWithDialog
case CodeGenType.WinFromEditWithDialog:
case CodeGenType.WinFromTreeEditWithDialog:
EditDialogParameter editDialogParameter = baseParameter as EditDialogParameter;
if (editDialogParameter != null)
{
m_strQueryColumns = editDialogParameter.QueryColumns;
m_strShowColumns = editDialogParameter.ShowColumns;
m_databaseTable = editDialogParameter.DatabaseTable;
m_codeGenType = editDialogParameter.CodeGenType;
m_frameworkType = editDialogParameter.FrameworkType;
m_uiStyle = editDialogParameter.UiStyle;
m_listBindType = editDialogParameter.ListBindType;
m_strEditColumns = editDialogParameter.EditColumns;
m_strCheckInputColumns = editDialogParameter.CheckInputColumns;
m_strDontRepeatColumns = editDialogParameter.DontRepeatColumns;
gridVEdit.Visible = true;
tabPageEdit.Parent = tabControl1;
tabPageEdit.Show();
gridVShow.Visible = true;
tabPageShow.Parent = tabControl1;
tabPageShow.Show();
}
break;
#endregion
#region WinFromNestQuery
case CodeGenType.WinFromNestQuery:
NestQueryParameter nestQueryParameter = baseParameter as NestQueryParameter;
if (nestQueryParameter != null)
{
m_strQueryColumns = nestQueryParameter.QueryColumns;
m_codeGenType = nestQueryParameter.CodeGenType;
gridVEdit.Visible = false;
tabPageShow.Parent = null;
tabPageShow.Hide();
gridVShow.Visible = false;
tabPageEdit.Parent = null;
tabPageEdit.Hide();
}
break;
#endregion
#region WinFromParentChildEditWithDialog
case CodeGenType.WinFromParentChildEditWithDialog:
ParentChildEditDialogParameter parentChildDialogParameter = baseParameter as ParentChildEditDialogParameter;
if (parentChildDialogParameter != null)
{
m_databaseTable = parentChildDialogParameter.DatabaseTable;
m_codeGenType = parentChildDialogParameter.CodeGenType;
m_frameworkType = parentChildDialogParameter.FrameworkType;
m_uiStyle = parentChildDialogParameter.UiStyle;
m_listBindType = parentChildDialogParameter.ListBindType;
m_strQueryColumns = parentChildDialogParameter.QueryColumns;
m_strShowColumns = parentChildDialogParameter.ShowColumns;
m_strEditColumns = parentChildDialogParameter.EditColumns;
m_strCheckInputColumns = parentChildDialogParameter.CheckInputColumns;
m_strDontRepeatColumns = parentChildDialogParameter.DontRepeatColumns;
m_strShowColumnsDetail = parentChildDialogParameter.ShowColumnsDetail;
m_strEditColumnsDetail = parentChildDialogParameter.EditColumnsDetail;
m_strCheckInputColumnsDetail = parentChildDialogParameter.CheckInputColumnsDetail;
m_strDontRepeatColumnsDetail = parentChildDialogParameter.DontRepeatColumnsDetail;
m_databaseTableDetail = parentChildDialogParameter.DatabaseTableDetail;
m_strKeyMaster = parentChildDialogParameter.KeyMaster;
m_strKeyDetail = parentChildDialogParameter.KeyDetail;
gridVEdit.Visible = true;
tabPageEdit.Parent = tabControl1;
tabPageEdit.Show();
gridVShow.Visible = true;
tabPageShow.Parent = tabControl1;
tabPageShow.Show();
}
break;
#endregion
}
if (baseParameter.CodeGenType != CodeGenType.WinFromParentChildEditWithDialog)
{
tabPageEditDetail.Parent = null;
tabPageShowDetail.Parent = null;
tabPageEditDetail.Hide();
tabPageShowDetail.Hide();
}
else
{
tabPageEditDetail.Parent = tabControl1;
tabPageShowDetail.Parent = tabControl1;
tabPageEditDetail.Show();
tabPageShowDetail.Show();
}
}
