public static void ServiceRemove(string toolsFolder, string toolsTempFolder, string servicedesc, string exepath, bool isshow)
{
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
dtPar.Rows.Add(new object[] { "servicedesc", servicedesc });
dtPar.Rows.Add(new object[] { "exepath", exepath });
setConfig setconfig = new setConfig();
setconfig.repalceParByDefine(toolsFolder, "Service_Unistall.bat", toolsTempFolder, dtPar);
setBAT.RunBat(toolsTempFolder + @"\Service_Unistall.bat", isshow);
}
public static void SqlExec(string toolsFolder, string toolsTempFolder, string user, string password, string datasource, string sqlfilename, List <string[]> inputList, bool isShow)
{
string batfilePath = toolsFolder + "\\sql_exec.bat";
string sqlfilePath = toolsFolder + "\\sqls\\" + sqlfilename + ".sql";
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
foreach (string[] str in inputList)
{
dtPar.Rows.Add(new object[] { str[0], str[1] });
}
setConfig setconfig = new setConfig();
setconfig.repalceParByDefine(toolsFolder + "\\sqls", sqlfilename + ".sql", toolsTempFolder, dtPar);
string sqlpath = toolsTempFolder + "\\" + sqlfilename + ".sql";
string logpath = toolsTempFolder + "\\" + sqlfilename + System.Guid.NewGuid().ToString() + ".log";
List <string[]> BatinputList = new List <string[]>();
string[] str1 = new string[2];
str1[0] = "user";
str1[1] = user;
BatinputList.Add(str1);
string[] str2 = new string[2];
str2[0] = "password";
str2[1] = password;
BatinputList.Add(str2);
string[] str3 = new string[2];
str3[0] = "datasource";
str3[1] = datasource;
BatinputList.Add(str3);
string[] str4 = new string[2];
str4[0] = "sqlpath";
str4[1] = sqlpath;
BatinputList.Add(str4);
string[] str5 = new string[2];
str5[0] = "logpath";
str5[1] = logpath;
BatinputList.Add(str5);
RunBatByDefine(toolsFolder, toolsTempFolder, "sql_exec", BatinputList, isShow);
}