public int GetAnimateWindowTime()
{
int dwTime = 5000;
dwTime = Convert.ToInt32(SQLApp.GetIniFile(strFileName, "AnimateWindow", "AnimateTime"));
return(dwTime);
}
private void ExecutedScriptCommand(FunctionListObject functionObj, Window frmParent)
{
//string funcName = System.Reflection.MethodBase.GetCurrentMethod().Name;
//Lấy tên function hiện tại
string strScript = GetScriptCommandByFuncName(functionObj.FuncName);
strScript = GenerateScriptWithParameters(functionObj, strScript, frmParent);
if (string.IsNullOrEmpty(strScript))
{
ShowMessengeInfo("Không có mã thực thi");
return;
}
SQLAppWaitingDialog.ShowDialog();
string sourceUrl = GetSourceCodePath();
string output = SQLApp.ExecutedPowerShell(string.Format("cd {0} {1} {2}", sourceUrl, Environment.NewLine, strScript));
string strType = SQLApp.GetIniFile(strFileCfgScript, strDynPara, functionObj.Name + "Show");
if (!string.IsNullOrEmpty(strType))
{
ShowScriptCommand(output, strType);
SQLAppWaitingDialog.HideDialog();
return;
}
SQLAppWaitingDialog.HideDialog();
ShowMessengeInfo(output);
}
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));
}
//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);
}
//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));
}
//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);
}
}
public string GetItemConfig(string keySection, string keyPrefix, int idx)
{
if (string.IsNullOrEmpty(keySection))
{
keySection = section;
}
return(SQLApp.GetIniFile(strFileName, keySection, keyPrefix + (idx + 1)));
}
public string GetThemeName()
{
string _themeName = SQLApp.GetIniFile(StrFileName, StrThemeApp, StrThemeName);
if (string.IsNullOrEmpty(_themeName))
{
_themeName = Properties.Resources.ThemeName;
}
return(_themeName);
}
public void ShowFunctionList(string strFuncName, Window frmParent)
{
string sourceUrl = SQLApp.GetIniFile(strFileName, "SourceCode", "SourceUrl");
bool isReturn = false;
if (string.IsNullOrEmpty(sourceUrl) || !Directory.Exists(sourceUrl))
{
isReturn = true;
FolderBrowserDialog folder = new FolderBrowserDialog();
if (folder.ShowDialog() == DialogResult.OK)
{
SQLApp.SetIniFile(strFileName, "SourceCode", "SourceUrl", folder.SelectedPath);
isReturn = false;
}
}
if (isReturn)
{
return;
}
List <string> lstFuncs = SQLApp.GetKeysIniFile(strCfgScriptName, strFuncName, 3000);
List <FunctionListObject> lstObjectFuncs = new List <FunctionListObject>();
lstFuncs.ForEach(x =>
{
string caption = SQLApp.GetIniFile(strCfgScriptName, "Captions", x);
if (string.IsNullOrEmpty(caption))
{
caption = string.Join(" ", x.ToUpper().Split('_'));
}
lstObjectFuncs.Add(new FunctionListObject {
Name = x, Text = caption
});
});
PromptForm._frmParent = frmParent;
string value = string.Empty;
MessageBoxResult messageResult = PromptForm.ShowCombobox("Function List In Source", "Function Name", lstObjectFuncs.Select(x => x.Text).ToArray(), ref value);
if (messageResult == MessageBoxResult.OK)
{
FunctionListObject functionObj = lstObjectFuncs.Find(x => x.Text.Equals(value));
string strKey = (functionObj != null) ? functionObj.Name : string.Empty;
string functionName = SQLApp.GetIniFile(strCfgScriptName, strFuncName, strKey);
if (functionName.StartsWith("Cmd"))
{
functionObj.FuncName = functionName;
ExecutedScriptCommand(functionObj, frmParent);
}
else
{
CallMethodName(functionName, frmParent);
}
}
}
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("");
}
//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);
}
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 + 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);
}
}
}
public List <string> LoadConfigInitToList(string keySection = null)
{
List <string> lst = new List <string>();
if (string.IsNullOrEmpty(keySection))
{
keySection = section;
}
string count = SQLApp.GetIniFile(strFileName, keySection, serverCnt);
if (!string.IsNullOrEmpty(count))
{
for (int i = 0; i < Convert.ToInt32(count); i++)
{
lst.Add(SQLApp.GetIniFile(strFileName, keySection, ServerDesc + (i + 1)));
}
}
return(lst);
}
public void MoveFileFolder(Window frmParent)
{
string sourceUrl = GetSourceCodePath();
SQLAppWaitingDialog.ShowDialog();
List <string> funcKeysIni = SQLApp.GetKeysIniFile(strPath, "FileToFolder");
foreach (string item in funcKeysIni)
{
string strText = SQLApp.GetIniFile(strPath, "FileToFolder", item);
string[] arr = item.Split('.');
DirectoryInfo directory = Directory.CreateDirectory(sourceUrl + "/" + string.Join("/", arr));
foreach (string file in strText.Split('|'))
{
string[] lstFile = Directory.GetFiles(sourceUrl + "/" + arr.FirstOrDefault(), file, SearchOption.AllDirectories);
foreach (var filePath in lstFile)
{
string[] lines = File.ReadAllLines(filePath);
for (int i = 0; i < lines.Length - 1; i++)
{
foreach (string item1 in funcKeysIni)
{
string[] arr1 = item1.Split('.');
if (lines[i].Contains("App\\" + arr1.FirstOrDefault()))
{
lines[i].Replace("App\\" + arr1.FirstOrDefault(), "App\\" + string.Join("\\", arr1));
}
}
}
File.WriteAllLines(filePath, lines);
File.Move(filePath, directory.FullName);
}
}
}
SQLAppWaitingDialog.HideDialog();
}
public void GetAllLanguage(Window frmParent)
{
try
{
string sourceUrl = SQLApp.GetIniFile(strFileName, "SourceCode", "SourceUrl");
string[] listFiles = Directory.GetFiles(string.Format("{0}\\database\\seeds\\lang", sourceUrl), "*_lang.php", SearchOption.AllDirectories);
DataTable dtLang = new DataTable("Language");
DataColumn col = new DataColumn("Group");
dtLang.Columns.Add(col);
col = new DataColumn("Key");
dtLang.Columns.Add(col);
col = new DataColumn("Text_vi");
dtLang.Columns.Add(col);
col = new DataColumn("Text_en");
dtLang.Columns.Add(col);
col = new DataColumn("Text_ja");
dtLang.Columns.Add(col);
foreach (string item in listFiles)
{
string strContent = SQLApp.ExecutedPowerShell(string.Format("php -r \"echo json_encode(require '{0}');\"", item));
object obj = JsonConvert.DeserializeObject(strContent);
string objGroup = (obj as Newtonsoft.Json.Linq.JObject).GetValue("group").ToString();
Newtonsoft.Json.Linq.JArray objLang = (obj as Newtonsoft.Json.Linq.JObject).GetValue("lang") as Newtonsoft.Json.Linq.JArray;
foreach (object objItem in objLang)
{
DataRow dr = dtLang.NewRow();
dr["Group"] = objGroup;
dr["Key"] = (objItem as Newtonsoft.Json.Linq.JObject).GetValue("key").ToString();
dr["Text_vi"] = (objItem as Newtonsoft.Json.Linq.JObject).SelectToken("text.vi").ToString();
dr["Text_en"] = (objItem as Newtonsoft.Json.Linq.JObject).SelectToken("text.en").ToString();
dr["Text_ja"] = (objItem as Newtonsoft.Json.Linq.JObject).SelectToken("text.ja").ToString();
dtLang.Rows.Add(dr);
}
}
ShowResultData(frmParent, dtLang);
}
catch (Exception ex)
{
}
}
protected void ShowScriptCommand(string output, string strType)
{
if (strType.Equals("table"))
{
string[] arr = output.Split('\n');
DataTable dtSoure = new DataTable();
dtSoure.TableName = "Route List";
int idx = 0;
arr.ToList().ForEach(r =>
{
string[] row = r.Split('|');
if (row.Length > 1)
{
if (idx == 0)
{
row.Where(c => !string.IsNullOrEmpty(c.Trim())).ToList().ForEach(c =>
{
DataColumn col = new DataColumn(c.Trim(), typeof(string));
dtSoure.Columns.Add(col);
});
}
else
{
dtSoure.LoadDataRow(row.Where(c => !string.IsNullOrEmpty(c.Trim())).Select(c => c.Trim()).ToArray(), false);
}
idx++;
}
});
ShowResultData(null, dtSoure);
}
else
{
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.Filter = "*." + strType.Replace("file", "");
if (saveFile.ShowDialog() == DialogResult.OK)
{
SQLApp.WriteFile(saveFile.FileName, output);
}
}
}
//Ctrl + 1 tìm module
public void FindModule(Window frmParent)
{
PromptForm._frmParent = frmParent;
string moduleName = "";
MessageBoxResult result = PromptForm.ShowText("Find Module", "ModuleName", ref moduleName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strQuery = SQLApp.GetFile(strPath + "FindModule.sql");
strQuery = strQuery.Replace("@ModuleName@", moduleName);
DataTable dt = SQLDBUtil.GetDataTable(strQuery);
if (dt == null)
{
return;
}
dt.TableName = "STModules";
ShowResultData(frmParent, dt, strQuery);
}
public string GetServerHistoryConfig()
{
return(SQLApp.GetIniFile(strFileName, "LoginHistory", "ServerOld"));
}
public void SetDBHistoryConfig(int idx, string strDBOld)
{
SQLApp.SetIniFile(strFileName, section, ServerDBOld + (idx + 1), strDBOld);
}
public void SetServerHistoryConfig(string strSVOld)
{
SQLApp.SetIniFile(strFileName, "LoginHistory", "ServerOld", strSVOld);
}
public string GetDescriptionConfig(int idx)
{
return(SQLApp.GetIniFile(strFileName, section, ServerDesc + (idx + 1)));
}
public string GetDBHistoryConfig(int idx)
{
return(SQLApp.GetIniFile(strFileName, section, ServerDBOld + (idx + 1)));
}
public string GetPassWordConfig(int idx)
{
return(SQLApp.GetIniFile(strFileName, section, ServerPWD + (idx + 1)));
}
public string GetUserNameConfig(int idx)
{
return(SQLApp.GetIniFile(strFileName, section, ServerUID + (idx + 1)));
}
public void GetConfigConnectSQL(string status, int idx = 0)
{
string cnt = SQLApp.GetIniFile(strFileName, section, serverCnt);
int index = Convert.ToInt32(cnt);
switch (status)
{
case "Add":
case "Edit":
string strDesc = SQLApp.GetIniFile(strFileName, section, ServerDesc + idx);
MessageBoxResult result = PromptForm.ShowText("Description", "Description", ref strDesc);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strServer = SQLApp.GetIniFile(strFileName, section, ServerName + idx);
result = PromptForm.ShowText("Server", "Server", ref strServer);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strUser = SQLApp.GetIniFile(strFileName, section, ServerUID + idx);
result = PromptForm.ShowText("User", "User", ref strUser);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strPass = SQLApp.GetIniFile(strFileName, section, ServerPWD + idx);
result = PromptForm.ShowText("Pass", "Pass", ref strPass);
if (result == MessageBoxResult.Cancel)
{
return;
}
if (!string.IsNullOrEmpty(strDesc) && !string.IsNullOrEmpty(strServer) && !string.IsNullOrEmpty(strUser))
{
if (status == "Add")
{
index += 1;
SQLApp.SetIniFile(strFileName, section, serverCnt, index.ToString());
}
else
{
index = idx;
}
SQLApp.SetIniFile(strFileName, section, ServerDesc + index, strDesc);
SQLApp.SetIniFile(strFileName, section, ServerName + index, strServer);
SQLApp.SetIniFile(strFileName, section, ServerUID + index, strUser);
SQLApp.SetIniFile(strFileName, section, ServerPWD + index, strPass);
SQLApp.SetIniFile(strFileName, section, ServerDBOld + index, "");
}
break;
case "Del":
SQLApp.SetIniFile(strFileName, section, serverCnt, (index - 1).ToString());
SQLApp.SetIniFile(strFileName, section, ServerDesc + idx, null);
SQLApp.SetIniFile(strFileName, section, ServerName + idx, null);
SQLApp.SetIniFile(strFileName, section, ServerUID + idx, null);
SQLApp.SetIniFile(strFileName, section, ServerPWD + idx, null);
SQLApp.SetIniFile(strFileName, section, ServerDBOld + idx, null);
break;
}
}
public void SetThemeName(string themeName)
{
SQLApp.SetIniFile(StrFileName, StrThemeApp, StrThemeName, themeName);
}
public string GetScriptCommandByFuncName(string strFuncName)
{
return(SQLApp.GetIniFile(string.Concat(strPath, "ScriptCommand.ini"), "Laravel", strFuncName));
}
