public void ChangeDbLaravel(Window frmParent)
{
if (!CheckSelectedDB())
{
return;
}
string sourceUrl = GetSourceCodePath();
string filePath = Directory.GetFiles(sourceUrl, "*.env").FirstOrDefault();
string[] lines = File.ReadAllLines(filePath);
string[] lstDBs = SQLDBUtil.GetDataTableByDataSet(SQLDBUtil.GetAllDatabases()).Select().Select(x => x[0].ToString()).ToArray();
string DBVal = lines.ToList().Find(x => x.StartsWith("DB_DATABASE")).Split('=').LastOrDefault();
if (PromptForm.ShowCombobox("Change Database Name", "Database Name", lstDBs, ref DBVal) == MessageBoxResult.OK)
{
SQLAppWaitingDialog.ShowDialog();
int idx = lines.ToList().FindIndex(x => x.StartsWith("DB_DATABASE"));
lines[idx] = string.Format("{0}={1}", "DB_DATABASE", DBVal);
File.WriteAllLines(filePath, lines);
FunctionListObject functionObj = new FunctionListObject();
functionObj.FuncName = "CmdLaravelConfigCache";
ExecutedScriptCommand(functionObj, frmParent);
SQLAppWaitingDialog.HideDialog();
}
}
public void AddForeignKey(string strTblName, string strColName, string strReferenTblName, string strReferenColName)
{
string str = MethodInfo.GetCurrentMethod().Name;
int iResult = SQLDBUtil.ExecuteNonQuery(string.Format("ALTER TABLE {0} ADD CONSTRAINT FK_{0}_{2}_{1} FOREIGN KEY {1} REFERENCES {2} ({3})", strTblName, strColName, strReferenTblName, strReferenColName));
ShowMessenger(iResult);
}
public void RenameColumn()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTblName = "";
MessageBoxResult result = PromptForm.ShowText(str, "Table Name", ref strTblName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strColOld = "";
result = PromptForm.ShowText(str, "Column Name", ref strColOld);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strColNew = "";
result = PromptForm.ShowText(str, "New Column Name", ref strColNew);
if (result == MessageBoxResult.Cancel)
{
return;
}
int iResult = SQLDBUtil.ExecuteNonQuery(string.Format("ALTER TABLE {0} RENAME COLUMN {1} TO {2}", strTblName, strColOld, strColNew));
ShowMessenger(iResult);
}
//public void LoadFunction(frmMain frmParent)
//{
// ListViewItem obj = frmParent.lstFunction.SelectedItems.Cast<ListViewItem>().FirstOrDefault();
// if (obj == null) return;
// string strCnt = SQLApp.GetIniFile(strFileCfgScript, strDynPara, obj.Text + "Cnt");
// if (string.IsNullOrEmpty(strCnt)) return;
// int idxCnt = Convert.ToInt32(strCnt);
// Dictionary<string, string> dicPara = new Dictionary<string, string>();
// for (int i = 1; i <= idxCnt; i++)
// {
// string strName = SQLApp.GetIniFile(strFileCfgScript, strDynPara, obj.Text + "Name" + i);
// string strVal = SQLApp.GetIniFile(strFileCfgScript, strDynPara, obj.Text + "Val" + i);
// string strValList = SQLApp.GetIniFile(strFileCfgScript, strDynPara, obj.Text + "ValList" + i);
// MessageBoxResult result = MessageBoxResult.Cancel;
// if (strName.Contains("TableName"))
// result = PromptForm.ShowCombobox(obj.Text, strName, ref strVal);
// else if(!string.IsNullOrEmpty(strValList))
// result = PromptForm.ShowCombobox(obj.Text, strName, strValList.Split('|'), ref strVal);
// else
// result = PromptForm.ShowText(obj.Text, strName, ref strVal);
// if (result == MessageBoxResult.Cancel) return;
// dicPara.AddItem(strName, strVal);
// }
// string strQuery = SQLApp.GetFile(strPath + obj.Text + ".sql");
// foreach (KeyValuePair<string,string> item in dicPara)
// {
// strQuery = strQuery.Replace(item.Key, item.Value);
// }
// SQLDBUtil.GetDataSet(strQuery);
//}
#region Sync DB
public DataSet SynchronizeTable(int indexFrom, int indexTo, string strDBFrom, string strDBTo)
{
int iResult = CreateLinkServer(indexFrom, indexTo, strDBFrom, strDBTo);
string strSrvName = GetDescriptionConfig(indexFrom);
string strSrvAdd = GetServerConfig(indexFrom);
string strUser = GetUserNameConfig(indexFrom);
string strPassWord = GetPassWordConfig(indexFrom);
string strSrvNameTo = GetDescriptionConfig(indexTo);
string strSrvAddTo = GetServerConfig(indexFrom);
string strUserTo = GetUserNameConfig(indexTo);
string strPassWordTo = GetPassWordConfig(indexTo);
string strQuery = SQLApp.GetFile(strPath + "SyncDB.sql");
strQuery = strQuery.Replace("@serverName@", strSrvName);
strQuery = strQuery.Replace("@serverAddress@", strSrvAdd);
strQuery = strQuery.Replace("@serverUser@", strUser);
strQuery = strQuery.Replace("@serverPass@", strPassWord);
strQuery = strQuery.Replace("@serverDB@", strDBFrom);
strQuery = strQuery.Replace("@serverNameTo@", strSrvNameTo);
strQuery = strQuery.Replace("@serverAddressTo@", strSrvAddTo);
strQuery = strQuery.Replace("@serverUserTo@", strUserTo);
strQuery = strQuery.Replace("@serverPassTo@", strPassWordTo);
strQuery = strQuery.Replace("@serverDBTo@", strDBTo);
return(SQLDBUtil.GetDataSet(strQuery));
}
public int CreateLinkServer(int indexFrom, int indexTo, string strDBFrom, string strDBTo)
{
string strSrvName = GetDescriptionConfig(indexFrom);
string strSrvAdd = GetServerConfig(indexFrom);
string strUser = GetUserNameConfig(indexFrom);
string strPassWord = GetPassWordConfig(indexFrom);
string strSrvNameTo = GetDescriptionConfig(indexTo);
string strSrvAddTo = GetServerConfig(indexFrom);
string strUserTo = GetUserNameConfig(indexTo);
string strPassWordTo = GetPassWordConfig(indexTo);
string strQuery = SQLApp.GetFile(strPath + "LinkServer.sql");
strQuery = strQuery.Replace("@serverName@", strSrvName);
strQuery = strQuery.Replace("@serverAddress@", strSrvAdd);
strQuery = strQuery.Replace("@serverUser@", strUser);
strQuery = strQuery.Replace("@serverPass@", strPassWord);
strQuery = strQuery.Replace("@serverDB@", strDBFrom);
strQuery = strQuery.Replace("@serverNameTo@", strSrvNameTo);
strQuery = strQuery.Replace("@serverAddressTo@", strSrvAddTo);
strQuery = strQuery.Replace("@serverUserTo@", strUserTo);
strQuery = strQuery.Replace("@serverPassTo@", strPassWordTo);
strQuery = strQuery.Replace("@serverDBTo@", strDBTo);
return(SQLDBUtil.ExecuteNonQuery(strQuery));
}
/// <summary>
/// ウィンドウ表示状態取得
/// </summary>
/// <param name="sessionId"></param>
/// <param name="windowName"></param>
/// <returns></returns>
public DataTable GetWindowState(string loginId, string windowName)
{
SQLDBUtil db = new SQLDBUtil(_logger);
DataTable ret = null;
DataSet tmp = null;
List <SqlParameter> param = new List <SqlParameter>();
try {
db.Open(_connectString);
param.Add(new SqlParameter("@window_name", windowName));
param.Add(new SqlParameter("@login_id", ""));
tmp = db.ExecSelect(SQLSrc.t_window_state.SELECT_STATE, param.ToArray());
ret = tmp.Tables[0].Clone();
foreach (DataRow dr in tmp.Tables[0].Rows)
{
string ctlName = dr[CommonConsts.control_name].ToString();
DataTable tmpTbl = GetWindowState(loginId, windowName, ctlName);
DataRow newRow = ret.NewRow();
newRow.ItemArray = tmpTbl.Rows[0].ItemArray;
ret.Rows.Add(newRow);
}
ret.TableName = "WindowState";
return(ret);
} finally {
db.Close();
}
}
//Ctrl + F Find Column
public void FindColumn(Window frmParent)
{
PromptForm._frmParent = frmParent;
string tableName = "";
MessageBoxResult result = PromptForm.ShowCombobox("FindColumn", "Table Name", ref tableName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string colName = "";
result = PromptForm.ShowText("FindColumn", "Column Name", ref colName);
if (result == MessageBoxResult.Cancel)
{
return;
}
DataSet ds = SQLDBUtil.GetAllTableColumns(tableName, colName);
DataTable dtData = SQLDBUtil.GetDataTableByDataSet(ds);
if (dtData == null)
{
return;
}
dtData.TableName = tableName;
ShowResultData(frmParent, dtData, "");
}
//Ctrl + Shift + A : Create Module
public void CreateMoudle()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strModuleName = "";
MessageBoxResult result = PromptForm.ShowText(str, "Module Name", ref strModuleName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strModuleDesc = "";
result = PromptForm.ShowText(str, "Module Descreiption", ref strModuleDesc);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strModuleCode = "";
result = PromptForm.ShowText(str, "Module Code", ref strModuleCode);
if (result == MessageBoxResult.Cancel)
{
return;
}
if (!string.IsNullOrEmpty(strModuleName) && !string.IsNullOrEmpty(strModuleDesc) && !string.IsNullOrEmpty(strModuleCode))
{
string strQuery = SQLApp.GetFile(strPath + "CreateModule.sql");
strQuery = strQuery.Replace("@ModuleName@", strModuleName);
strQuery = strQuery.Replace("@ModuleCode@", strModuleCode);
strQuery = strQuery.Replace("@ModuleDesc@", strModuleDesc);
int iResult = SQLDBUtil.ExecuteNonQuery(strQuery);
ShowMessenger(iResult);
}
}
/// <summary>
/// ウィンドウ表示状態取得
/// </summary>
/// <param name="sessionId"></param>
/// <param name="windowName"></param>
/// <param name="ctlName"></param>
/// <returns></returns>
public DataTable GetWindowState(string loginId, string windowName, string ctlName)
{
SQLDBUtil db = new SQLDBUtil(_logger);
DataSet ret = null;
List <SqlParameter> param = new List <SqlParameter>();
try {
db.Open(_connectString);
param.Add(new SqlParameter("@window_name", windowName));
param.Add(new SqlParameter("@control_name", ctlName));
param.Add(new SqlParameter("@login_id", loginId));
ret = db.ExecSelect(SQLSrc.t_window_state.SELECT_STATE_ONE, param.ToArray());
if (ret.Tables[0].Rows.Count == 0)
{
List <SqlParameter> param2 = new List <SqlParameter>();
param2.Add(new SqlParameter("@window_name", windowName));
param2.Add(new SqlParameter("@control_name", ctlName));
param2.Add(new SqlParameter("@login_id", ""));
ret = db.ExecSelect(SQLSrc.t_window_state.SELECT_STATE_ONE, param2.ToArray());
}
ret.Tables[0].TableName = "WindowState";
return((DataTable)_dcu.DeepCopy(ret.Tables[0]));
} finally {
db.Close();
}
}
//Alt + 1 View Data by No
public void GetViewDataByNo(Window frmParent)
{
PromptForm._frmParent = frmParent;
string tableName = "";
MessageBoxResult result = PromptForm.ShowCombobox("ViewDataByNo", "Table Name", ref tableName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string colName = "";
result = PromptForm.ShowText("ViewDataByNo", "Column Name", ref colName);
if (result == MessageBoxResult.Cancel)
{
return;
}
if (string.IsNullOrEmpty(colName))
{
colName = "*";
}
string strWhere = string.Empty;
if (SQLDBUtil.ColumnIsExistInTable(tableName, "AAStatus"))
{
strWhere = "AAStatus = 'Alive'";
}
string strQuery = SQLDBUtil.GenerateQuery(tableName, strWhere, colName);
//DataTable dtData = SQLDBUtil.GetDataByTable(tableName, strWhere, colName);
//if (dtData == null) return;
//dtData.TableName = tableName;
ShowResultData(frmParent, null, strQuery);
}
//Ctrl + 0 View Connect Sql
public void GetViewConnectToSQL(Window frmParent)
{
string strQuery = SQLApp.GetFile(strPath + "ViewConnectSql.sql");
DataTable dtSource = SQLDBUtil.GetDataTable(strQuery);
ShowResultData(frmParent, dtSource, strQuery);
}
/// <summary>
/// グリッド設定情報を取得
/// </summary>
/// <param name="windowName"></param>
/// <param name="gridName"></param>
/// <param name="loginId"></param>
/// <returns></returns>
public DataSet GetGridConfig(string windowName, string gridName, string loginId)
{
DataSet ret = null;
List <SqlParameter> param = new List <SqlParameter>();
SQLDBUtil db = new SQLDBUtil(_logger);
try {
db.Open(_connectString);
param.Add(new SqlParameter("@window_name", windowName));
param.Add(new SqlParameter("@grid_name", gridName));
param.Add(new SqlParameter("@login_id", loginId));
ret = db.ExecSelect(SQLSrc.t_grid_config.SELECT_CONDITION, param.ToArray());
if (ret.Tables[0].Rows.Count == 0)
{
//自分の設定がない場合は、デフォルト設定を取得
List <SqlParameter> param2 = new List <SqlParameter>();
param2.Add(new SqlParameter("@window_name", windowName));
param2.Add(new SqlParameter("@grid_name", gridName));
param2.Add(new SqlParameter("@login_id", ""));
ret = db.ExecSelect(SQLSrc.t_grid_config.SELECT_CONDITION, param2.ToArray());
}
ret.Tables[0].TableName = "GridConfig";
return(ret);
} finally {
db.Close();
}
}
public void ExecuteScriptFile(Window frmParent)
{
OpenFileDialog openFile = new OpenFileDialog();
if (openFile.ShowDialog() == DialogResult.OK)
{
string allLines = File.ReadAllText(openFile.FileName);
string[] allChar = new string[] { ";" + Environment.NewLine };
string[] arrLines = allLines.Split(allChar, StringSplitOptions.None);
SQLAppWaitingDialog.ShowDialog();
foreach (string line in arrLines)
{
try
{
SQLDBUtil.ExecuteNonQuery(line);
}
catch (Exception ex)
{
SQLAppWaitingDialog.HideDialog();
ShowMessengeWarning("Có lỗi xảy ra");
}
}
SQLAppWaitingDialog.HideDialog();
ShowMessengeInfo("Thành công");
}
}
public void AddIndex()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTblName = "";
MessageBoxResult result = PromptForm.ShowCombobox(str, "Table Name", ref strTblName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strColName = "";
result = PromptForm.ShowText(str, "Column Name", ref strColName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strIdxName = "";
result = PromptForm.ShowText(str, "Index Name", ref strIdxName);
if (result == MessageBoxResult.Cancel)
{
return;
}
int iResult = SQLDBUtil.ExecuteNonQuery(string.Format("CREATE INDEX {0} ON {1}({2})", strIdxName, strTblName, strColName));
ShowMessenger(iResult);
}
public void AlterColumn()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTblName = "";
MessageBoxResult result = PromptForm.ShowText("Table Name", "Table Name", ref strTblName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strColName = "";
result = PromptForm.ShowText("Column Name", "Column Name", ref strColName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strColType = SQLDBUtil.GetColumnDBType(strTblName, strColName);
result = PromptForm.ShowText("Column Type", "Column Type", ref strColType);
if (result == MessageBoxResult.Cancel)
{
return;
}
int iResult = SQLDBUtil.ExecuteNonQuery(string.Format("ALTER TABLE {0} ALTER COLUMN {1} {2}", strTblName, strColName, strColType));
ShowMessenger(iResult);
}
/// <summary>
/// グリッド設定情報を取得
/// </summary>
/// <returns></returns>
public DataSet GetGridConfig(HttpRequestMessage req, string loginId)
{
List <SqlParameter> param = new List <SqlParameter>();
SQLDBUtil db = new SQLDBUtil(_logger);
DataSet ds = JsonConvert.DeserializeObject <DataSet>(req.Content.ReadAsStringAsync().Result);
DataTable dt = ds.Tables[0];
string windowName = StringUtil.NullToBlank(dt.Rows[0][CommonConsts.window_name]);
string gridName = StringUtil.NullToBlank(dt.Rows[0][CommonConsts.grid_name]);
return(GetGridConfig(windowName, gridName, loginId));
}
/// <summary>
/// グリッド設定を更新(Delete-Insert)
/// </summary>
/// <param name="dt"></param>
public void UpdateGridConfigInfo(DataTable dt, string loginId)
{
SQLDBUtil db = new SQLDBUtil(_logger);
SetNewDispOrder(dt);
lock (_lockObj) {
try {
db.Open(_connectString);
db.BeginTransaction();
//Delete
DataRow r = dt.Rows[0];
List <SqlParameter> delParam = new List <SqlParameter>();
delParam.Add(new SqlParameter("@window_name", r[CommonConsts.window_name]));
delParam.Add(new SqlParameter("@grid_name", r[CommonConsts.grid_name]));
delParam.Add(new SqlParameter("@login_id", loginId));
db.ExecuteNonQuery(SQLSrc.t_grid_config.DELETE, delParam.ToArray());
//Insert
foreach (DataRow dr in dt.Rows)
{
List <SqlParameter> insParam = new List <SqlParameter>();
insParam.Add(new SqlParameter("@window_name", dr[CommonConsts.window_name]));
insParam.Add(new SqlParameter("@grid_name", dr[CommonConsts.grid_name]));
insParam.Add(new SqlParameter("@db_name", dr[CommonConsts.db_name]));
insParam.Add(new SqlParameter("@login_id", loginId));
insParam.Add(new SqlParameter("@width", dr[CommonConsts.width]));
insParam.Add(new SqlParameter("@height", dr[CommonConsts.height]));
insParam.Add(new SqlParameter("@conf_editable", dr[CommonConsts.conf_editable]));
insParam.Add(new SqlParameter("@visible", dr[CommonConsts.visible]));
insParam.Add(new SqlParameter("@editable", dr[CommonConsts.editable]));
insParam.Add(new SqlParameter("@disp_order", dr[CommonConsts.disp_order]));
insParam.Add(new SqlParameter("@col_fixed", dr[CommonConsts.col_fixed]));
insParam.Add(new SqlParameter("@data_type", dr[CommonConsts.data_type]));
insParam.Add(new SqlParameter("@max_length", dr[CommonConsts.max_length]));
insParam.Add(new SqlParameter("@required", dr[CommonConsts.required]));
insParam.Add(new SqlParameter("@primary_key", dr[CommonConsts.primary_key]));
insParam.Add(new SqlParameter("@password_char", dr[CommonConsts.password_char]));
insParam.Add(new SqlParameter("@note", dr[CommonConsts.note]));
db.ExecuteNonQuery(SQLSrc.t_grid_config.INSERT, insParam.ToArray());
}
db.Commit();
} catch (Exception) {
db.Rollback();
throw;
} finally {
db.Close();
}
}
}
protected void CompareDifferrentData(Dictionary <string, SqlDbConnection> lstCons, string strQuery, string tblName)
{
SQLDBUtil.CurrentDatabase = lstCons[CtrlFrom];
DataTable dtSource = SQLDBUtil.GetDataTable(string.Format(strQuery, SQLDBUtil.CurrentDatabase.Connection.Database));
SQLDBUtil.CurrentDatabase = lstCons[CtrlTo];
DataTable dtTarget = SQLDBUtil.GetDataTable(string.Format(strQuery, SQLDBUtil.CurrentDatabase.Connection.Database));
IEnumerable <DataRow> lstSameTable = dtSource.AsEnumerable().Except(dtTarget.AsEnumerable(), DataRowComparer.Default);
DataTable dtSame = ConvertDataRowToTable(lstSameTable, tblName);
ShowCompareResultView(dtSame);
}
/// <summary>
/// プルダウンの候補をセット
/// </summary>
/// <param name="db"></param>
/// <param name="ds"></param>
protected virtual void SetPulldownCandidate(SQLDBUtil db, DataSet ds)
{
foreach (DataRow r in ds.Tables[CommonConsts.SearchItemTbl].Rows)
{
if (r[CommonConsts.ctl_type].ToString() == CommonConsts.CtlTypePulldownlist)
{
//プルダウンリストの候補を取得
DataSet dsTmp = db.ExecSelect(r[CommonConsts.value1].ToString());
dsTmp.Tables[0].TableName = r[CommonConsts.db_name].ToString();
ds.Tables.Add(dsTmp.Tables[r[CommonConsts.db_name].ToString()].Copy());
}
}
}
public DataTable LoadDatabaseByServer(string keySection, int idx)
{
if (idx == -1)
{
return(new DataTable());
}
strServer = GetServerConfig(keySection, idx);
strUserName = GetUserNameConfig(keySection, idx);
strPassWord = GetPassWordConfig(keySection, idx);
//strDBOld = SQLApp.GetIniFile(strFileName, section, _serverDBOld + (cboServer.SelectedIndex + 1));
SQLDBUtil.ChangeConnection((SqlDbConnectionType)Enum.Parse(typeof(SqlDbConnectionType), keySection), strServer, strUserName, strPassWord);
return(SQLDBUtil.GetDataTableByDataSet(SQLDBUtil.GetAllDatabases()));
}
public void DropForeignKey()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTblName = "";
MessageBoxResult result = PromptForm.ShowText("Table Name", "Table Name", ref strTblName);
if (result == MessageBoxResult.Cancel)
{
return;
}
int iResult = SQLDBUtil.ExecuteNonQuery(string.Format("ALTER TABLE {0} DROP CONSTRAINT FK_{1}", strTblName));
ShowMessenger(iResult);
}
public string GetScriptCreateTable(string strDBName, string strTable)
{
string strQuery = SQLApp.GetFile(strPath + "CreateTable.sql");
strQuery = strQuery.Replace("@tablename@", strTable);
strQuery = strQuery.Replace("@schemaname@", strDBName);
DataTable dt = SQLDBUtil.GetDataTable(strQuery);
if (dt != null && dt.Rows.Count > 0)
{
return(string.Format("{0}", dt.Rows[0][0]));
}
return("");
}
public void DropDatabase()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strDBName = "";
MessageBoxResult result = PromptForm.ShowText("Database Name", "Database Name", ref strDBName);
if (result == MessageBoxResult.Cancel)
{
return;
}
int iResult = SQLDBUtil.ExecuteNonQuery(string.Format("DROP DATABASE {0}", strDBName));
ShowMessenger(iResult);
}
/// <summary>
/// データディクショナリ情報取得
/// </summary>
/// <returns></returns>
public DataSet GetDataDictionary(ILog logger, string connectString)
{
List <SqlParameter> param = new List <SqlParameter>();
SQLDBUtil db = new SQLDBUtil(logger);
try {
db.Open(connectString);
DataSet ret = db.ExecSelect(SQLSrc.m_data_dictionary.SELECT_ALL);
ret.Tables[0].TableName = CommonConsts.TableNameMDataDictionary;
return(ret);
} finally {
db.Close();
}
}
/// <summary>
/// 共通設定情報取得
/// </summary>
/// <returns></returns>
public DataSet GetCommonConf()
{
List <SqlParameter> param = new List <SqlParameter>();
SQLDBUtil db = new SQLDBUtil(_logger);
try {
db.Open(_connectString);
DataSet ret = db.ExecSelect(SQLSrc.m_common_conf.SELECT_ALL);
ret.Tables[0].TableName = CommonConsts.TableNameMCommonConf;
return(ret);
} finally {
db.Close();
}
}
/// <summary>
/// メッセージ情報取得
/// </summary>
/// <returns></returns>
public DataSet GetMessageInfo()
{
SQLDBUtil db = new SQLDBUtil(_logger);
DataSet ret = null;
List <SqlParameter> param = new List <SqlParameter>();
try {
db.Open(_connectString);
ret = db.ExecSelect(SQLSrc.m_message.SELECT_ALL, param.ToArray());
ret.Tables[0].TableName = "MessageInfo";
return(ret);
} finally {
db.Close();
}
}
public void LoadQueryPath(FunctionListObject obj, Window frmParent)
{
string strQuery = SQLApp.GetFile(obj.Path);
strQuery = GenerateScriptWithParameters(obj, strQuery, frmParent);
if (string.IsNullOrEmpty(strQuery))
{
return;
}
DataTable dt = SQLDBUtil.GetDataTable(strQuery);
if (dt == null)
{
return;
}
ShowResultData(frmParent, dt, strQuery);
}
//Ctrl + Alt + T : Gen Script Create Table
public void GenScriptCreateTable(Window frmParent)
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTableName = "";
MessageBoxResult result = PromptForm.ShowCombobox(str, "Table Name", ref strTableName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strQuery = SQLApp.GetFile(strPath + "GenCreateTable.sql");
strQuery = strQuery.Replace("@TableName@", strTableName);
DataTable dt = SQLDBUtil.GetDataTable(strQuery);
ShowResultData(frmParent, dt, strQuery);
}
/// <summary>
/// 共通設定情報取得(1項目)
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public DataSet GetCommonConfItem(string key)
{
List <SqlParameter> param = new List <SqlParameter>();
SQLDBUtil db = new SQLDBUtil(_logger);
try {
db.Open(_connectString);
param.Add(new SqlParameter("@key", key));
DataSet ret = db.ExecSelect(SQLSrc.m_common_conf.SELECT_ITEM, param.ToArray());
ret.Tables[0].TableName = CommonConsts.TableNameMCommonConf;
return(ret);
} finally {
db.Close();
}
}
//Ctrl + 6: Gen Info / Controller
public void GenInfoController()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTableName = "";
MessageBoxResult result = PromptForm.ShowCombobox(str, "Table Name", ref strTableName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strType = string.Empty;
result = PromptForm.ShowCombobox(str, "Gen Controller", new string[] { "YES", "NO" }, ref strType);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strQuery = SQLApp.GetFile(strPath + "GenInfo.sql");
strQuery = strQuery.Replace("@TableName@", strTableName);
strQuery = strQuery.Replace("@Version@", System.Windows.Forms.Application.ProductName + " - " + System.Windows.Forms.Application.ProductVersion);
strQuery = strQuery.Replace("@CreatedDate@", DateTime.Now.ToShortDateString());
DataTable dt = SQLDBUtil.GetDataTable(strQuery);
if (dt != null)
{
string strContent = Convert.ToString(dt.Rows[0][0]);
SQLApp.WriteFile("D:\\" + strTableName + "Info.cs", strContent);
//NotifycationAler aler = new NotifycationAler();
//aler.ShowDialog();
}
if (strType == "YES")
{
strQuery = SQLApp.GetFile(strPath + "GenController.sql");
strQuery = strQuery.Replace("@TableName@", strTableName);
strQuery = strQuery.Replace("@Version@", System.Windows.Forms.Application.ProductName + " - " + System.Windows.Forms.Application.ProductVersion);
strQuery = strQuery.Replace("@CreatedDate@", DateTime.Now.ToShortDateString());
dt = SQLDBUtil.GetDataTable(strQuery);
if (dt != null)
{
string strContent = Convert.ToString(dt.Rows[0][0]);
SQLApp.WriteFile("D:\\" + strTableName + "Controller.cs", strContent);
}
}
}
