private void WriteConfiguration() { //保存5条信息,默认取第一条,新登录的顶到第一条,删除最后一条,逗号分隔 1,2,3,'','' string[] serverNameArray = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "sqlserver", "ServerName", ".").Split(','); string[] newServerNameArray = new string[] { comboBox2.Text, "", "", "", "" };//save 5 lines int newServerNameIndex = 1; foreach (var item in serverNameArray) { if (!newServerNameArray.Contains(item)) { newServerNameArray[newServerNameIndex] = item; newServerNameIndex++; } } IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "sqlserver", "ServerName", string.Join(",", newServerNameArray)); IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "sqlserver", "Authentication", comboBox3.Text); if (checkBox1.Checked) { string[] saLoginArray = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "sqlserver", "SaLogin", ".").Split(','); string[] newSaLoginArray = new string[] { comboBox4.Text, "", "", "", "" };//save 5 lines int newsaLoginIndex = 1; foreach (var item in saLoginArray) { if (!newSaLoginArray.Contains(item)) { newSaLoginArray[newsaLoginIndex] = item; newsaLoginIndex++; } } IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "sqlserver", "SaLogin", string.Join(",", newSaLoginArray)); IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "sqlserver", "SaPassword", textBox1.Text); } }
private void WriteConfiguration() { IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "mysql", "ServerName", textBox1.Text.Trim()); IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "mysql", "Port", textBox2.Text.Trim()); IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "mysql", "Login", textBox3.Text.Trim()); IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "mysql", "Password", textBox4.Text.Trim()); }
private void ReadConfiguration() { string[] serverNameArray = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "sqlserver", "ServerName", ".").Split(','); comboBox2.Text = serverNameArray[0]; comboBox2.Items.Clear(); foreach (var item in serverNameArray) { if (!string.IsNullOrEmpty(item)) { comboBox2.Items.Add(item); } } comboBox3.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "sqlserver", "Authentication", "Windows Authentication"); string[] saLoginArray = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "sqlserver", "SaLogin", "sa").Split(','); comboBox4.Items.Clear(); foreach (var item in saLoginArray) { if (!string.IsNullOrEmpty(item)) { comboBox4.Items.Add(item); } } if (comboBox3.Text.Equals("SQL Server Authentication")) { comboBox4.Text = saLoginArray[0]; textBox1.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "sqlserver", "SaPassword", "123456"); } }
private void ReadConfiguration() { textBox1.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "mysql", "ServerName", "localhost"); textBox2.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "mysql", "Port", "3306"); textBox3.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "mysql", "Login", ""); textBox4.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "mysql", "Password", ""); }
/// <summary> /// constructor /// </summary> public ConfigBootStrap() { Trace.WriteLine("configuration bootstraping ..."); JObject jobject_qx_frame_config = IO_Helper_DG.Json_GetJObjectFromJsonFile("../../config/qx_frame.config.json");//get json configuration file QX_Frame_Helper_DG_Config.ConnectionString_DB_QX_Frame_Default = jobject_qx_frame_config["database"]["connectionStrings"]["QX_Frame_Default"].ToString(); QX_Frame_Helper_DG_Config.DataBaseType = QX_Frame.Bantina.Options.Opt_DataBaseType.SqlServer; QX_Frame_Helper_DG_Config.Log_Location_General = jobject_qx_frame_config["log"]["Log_Location_General"].ToString(); QX_Frame_Helper_DG_Config.Log_Location_Error = jobject_qx_frame_config["log"]["Log_Location_Error"].ToString(); QX_Frame_Helper_DG_Config.Log_Location_Use = jobject_qx_frame_config["log"]["Log_Location_Use"].ToString(); QX_Frame_Helper_DG_Config.Cache_IsCache = jobject_qx_frame_config["cache"]["IsCache"].ToInt() == 1; QX_Frame_Helper_DG_Config.Cache_CacheExpirationTimeSpan_Minutes = jobject_qx_frame_config["cache"]["CacheExpirationTime_Minutes"].ToInt(); QX_Frame_Helper_DG_Config.Cache_CacheServer = QX_Frame.Bantina.Options.Opt_CacheServer.Redis; QX_Frame_Helper_DG_Config.Cache_Redis_Host_ReadWrite_Array = jobject_qx_frame_config["cache"]["Cache_Redis_Host_ReadWrite_Array"].ToString().Split(','); QX_Frame_Helper_DG_Config.Cache_Redis_Host_OnlyRead_Array = jobject_qx_frame_config["cache"]["Cache_Redis_Host_OnlyRead_Array"].ToString().Split(','); QX_Frame_Helper_DG_Config.MSMQ_RabbitMQ_Host = jobject_qx_frame_config["rabbitmq"]["Host"].ToString(); QX_Frame_Helper_DG_Config.MSMQ_RabbitMQ_UserName = jobject_qx_frame_config["rabbitmq"]["UserName"].ToString(); QX_Frame_Helper_DG_Config.MSMQ_RabbitMQ_Password = jobject_qx_frame_config["rabbitmq"]["Password"].ToString(); QX_Frame_Helper_DG_Config.MSMQ_RabbitMQ_VirtualHost = jobject_qx_frame_config["rabbitmq"]["VirtualHost"].ToString(); QX_Frame_Helper_DG_Config.MSMQ_RabbitMQ_RequestedHeartBeat = Convert.ToUInt16(jobject_qx_frame_config["rabbitmq"]["RequestedHeartBeat"]); QX_Frame_Helper_DG_Config.International_ConfigFileLocation = @"../../config/qx_frame.internationalization.json"; QX_Frame_Helper_DG_Config.International_Language = "english"; Trace.WriteLine("configuration bootstrap succeed !"); }
//POST : api/Picture/id public async Task <IHttpActionResult> Post(string id) { string SAVE_DIR = string.IsNullOrEmpty(id) ? UPLOAD_DIR : Path.Combine(UPLOAD_DIR, id); //check file type if (!Request.Content.IsMimeMultipartContent()) { throw new Exception_DG("unsupported media type", 2005); } string dir = Path.Combine(IO_Helper_DG.RootPath_MVC, "/temp"); IO_Helper_DG.CreateDirectoryIfNotExist(dir); var provider = new MultipartFormDataStreamProvider(dir); // Read the form data. await Request.Content.ReadAsMultipartAsync(provider); List <string> fileNameList = new List <string>(); StringBuilder sb = new StringBuilder(); long fileTotalSize = 0; int fileIndex = 1; // This illustrates how to get the file names. foreach (MultipartFileData file in provider.FileData) { //new folder string saveDir = Path.Combine(IO_Helper_DG.RootPath_MVC, SAVE_DIR); IO_Helper_DG.CreateDirectoryIfNotExist(saveDir); if (File.Exists(file.LocalFileName)) { //get file name string fileName = file.Headers.ContentDisposition.FileName.Substring(1, file.Headers.ContentDisposition.FileName.Length - 2); //create new file name string newFileName = String.Concat(Guid.NewGuid(), ".", fileName.Split('.')[1]); string newFullFileName = Path.Combine(saveDir, newFileName); fileNameList.Add(Path.Combine(SAVE_DIR, newFileName)); FileInfo fileInfo = new FileInfo(file.LocalFileName); fileTotalSize += fileInfo.Length; sb.Append($" #{fileIndex} Uploaded file: {newFileName} ({ fileInfo.Length} bytes)"); fileIndex++; File.Move(file.LocalFileName, newFullFileName); Trace.WriteLine("1 file copied , filePath=" + newFullFileName); } } return(OK($"{fileNameList.Count} file(s) /{fileTotalSize} bytes uploaded successfully! Details -> {sb.ToString()} -- qx_frame {DateTime_Helper_DG.Get_DateTime_Now_24HourType()}", fileNameList, fileNameList.Count)); }
/// <summary> /// Get JObject from json config file /// </summary> /// <returns></returns> private static JObject GetJObject() { if (string.IsNullOrEmpty(QX_Frame_Helper_DG_Config.International_ConfigFileLocation)) { throw new Exception_DG("QX_Frame_Config.International_ConfigFileLocation must be provide correctly ! -- QX_Frame.Bantina.Extends.Exception_DG line:18"); } return(IO_Helper_DG.Json_GetJObjectFromJsonFile(QX_Frame_Helper_DG_Config.International_ConfigFileLocation));//get json configuration file }
protected static string GetERROR_XXX(int ERROR_Code) { if (string.IsNullOrEmpty(QX_Frame_Helper_DG_Config.International_ConfigFileLocation)) { throw new Exception_DG("QX_Frame_Helper_DG_Config.International_ConfigFileLocation must be provide correctly ! -- QX_Frame.Bantina.Extends.Exception_DG line:18"); } JObject jobject = IO_Helper_DG.Json_GetJObjectFromJsonFile(QX_Frame_Helper_DG_Config.International_ConfigFileLocation);//get json configuration file return(jobject[QX_Frame_Helper_DG_Config.International_Language][$"ERROR_{ERROR_Code}"].ToString()); }
public Exception_DG_Internationalization(int errorCode) : base("Refrence Message_DG") { if (string.IsNullOrEmpty(QX_Frame_Helper_DG_Config.International_ConfigFileLocation)) { throw new Exception_DG("QX_Frame_Helper_DG_Config.International_ConfigFileLocation must be provide correctly ! -- QX_Frame.Bantina.Extends.Exception_DG line:69"); } JObject jobject = IO_Helper_DG.Json_GetJObjectFromJsonFile(QX_Frame_Helper_DG_Config.International_ConfigFileLocation);//get json configuration file this.Message_DG = jobject[QX_Frame_Helper_DG_Config.International_Language][$"ERROR_{errorCode}"].ToString(); this.ErrorCode = errorCode; }
//Export To Excel private void button22_Click(object sender, EventArgs e) { string filePath = textBox6.Text.Trim(); string fileComplexPath = $"{ filePath + DataBaseName}.xlsx"; IO_Helper_DG.CreateDirectoryIfNotExist(filePath); new Thread(() => { Office_Helper_DG.DataTableToExcel(fileComplexPath, textBox9.Text.Trim(), this.DataBaseTable); }).Start(); MessageBox.Show("OutPut->" + fileComplexPath); }
//将文本框文件保存到桌面 private void saveCodeToFile() { string dirPath = textBox6.Text; string fileComplexPath = dirPath + textBox4.Text + comboBox1.Text; IO_Helper_DG.CreateDirectoryIfNotExist(dirPath); using (FileStream fs = new FileStream(fileComplexPath, FileMode.Create)) { StreamWriter sw = new StreamWriter(fs); sw.Write(CodeTxt); sw.Close(); } }
//POST : api/File public async Task <IHttpActionResult> Post() { string SAVE_DIR = UPLOAD_DIR; //save folder string root = Path.Combine(IO_Helper_DG.RootPath_MVC, SAVE_DIR); //check path is exist if not create it IO_Helper_DG.CreateDirectoryIfNotExist(root); IList <string> fileNameList = new List <string>(); StringBuilder sb = new StringBuilder(); long fileTotalSize = 0; int fileIndex = 1; //get files from request HttpFileCollection files = HttpContext.Current.Request.Files; await Task.Run(() => { foreach (var f in files.AllKeys) { HttpPostedFile file = files[f]; if (!string.IsNullOrEmpty(file.FileName)) { string fileLocalFullName = Path.Combine(root, file.FileName); file.SaveAs(fileLocalFullName); fileNameList.Add(Path.Combine(SAVE_DIR, file.FileName)); FileInfo fileInfo = new FileInfo(fileLocalFullName); fileTotalSize += fileInfo.Length; sb.Append($" #{fileIndex} Uploaded file: {file.FileName} ({ fileInfo.Length} bytes)"); fileIndex++; Trace.WriteLine("1 file copied , filePath=" + fileLocalFullName); } } }); return(OK($"{fileNameList.Count} file(s) /{fileTotalSize} bytes uploaded successfully! Details -> {sb.ToString()} -- qx_frame {DateTime_Helper_DG.Get_DateTime_Now_24HourType()}", fileNameList, fileNameList.Count)); }
//write ini config record the opration history private void setInitConfigFile() { //set config IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "config", "outputType", comboBox2.Text);//output type //set code builder config //IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "code", "usings", textBox3.Text.Replace("\n","&")); //using IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "code", "namespace", textBox2.Text); //namespace IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "code", "namespaceCommonPlus", textBox10.Text); //namespace IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "code", "TableName", textBox9.Text); //table name IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "code", "class", textBox5.Text); //class name IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "code", "ClassNamePlus", textBox7.Text); // ClassExtends IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "code", "ClassExtends", textBox8.Text); // ClassExtends IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "code", "fileName", textBox4.Text); //fileName IO_Helper_DG.Ini_Update(CommonVariables.configFilePath, "code", "fileNameSuffix", comboBox1.Text); //fileName }
//Generate Three-Layout-Frame private void button15_Click(object sender, EventArgs e) { //Generate QX_Frame.Data.Entities textBox2.Text = "QX_Frame.Data.Entities"; textBox7.Text = ""; textBox8.Text = $"Entity<{DataBaseName}, {TableName}>"; CommonComponent(() => NetEntityWithBantina.CreateCode(CreateInfoDic)); //Generate QX_Frame.Data.QueryObject textBox3.Text = "using QX_Frame.App.Base;\nusing QX_Frame.Data.Entities;\nusing System;\nusing System.Linq.Expressions;"; textBox2.Text = "QX_Frame.Data.QueryObject"; textBox7.Text = "QueryObject"; textBox8.Text = $"WcfQueryObject<{DataBaseName}, {TableName}>"; CommonComponent(() => QX_FrameToQueryObject.CreateCode(CreateInfoDic)); //Generate QX_Frame.Data.Service textBox3.Text = "using QX_Frame.App.Base;\nusing QX_Frame.Data.Contract;\nusing QX_Frame.Data.Entities;"; textBox2.Text = "QX_Frame.Data.Service"; textBox7.Text = "Service"; string tableNameRelace = TableName.Replace("TB_", "").Replace("tb_", "").Replace("t_", "").Replace("T_", ""); textBox5.Text = tableNameRelace; textBox8.Text = $"WcfService, I{tableNameRelace}Service"; CommonComponent(() => QX_FrameToDataService.CreateCode(CreateInfoDic)); string dirPath = textBox6.Text; string fileComplexPath = dirPath + "ClassRegister.txt"; IO_Helper_DG.CreateDirectoryIfNotExist(dirPath); using (StreamWriter sw = new StreamWriter(fileComplexPath, true)) { sw.WriteLine($"AppBase.Register(c => new {tableNameRelace}Service());"); sw.Close(); } //Generate QX_Frame.Data.Contract textBox3.Text = "using QX_Frame.Data.Entities;"; textBox2.Text = "QX_Frame.Data.Contract"; textBox5.Text = $"I{textBox5.Text.Replace("TB_", "").Replace("tb_", "").Replace("t_", "").Replace("T_", "")}"; textBox7.Text = "Service"; textBox8.Text = ""; CommonComponent(() => QX_FrameToDataContract.CreateCode(CreateInfoDic)); }
/// <summary> /// DownLoad Images /// </summary> /// <param name="id"></param> /// <returns></returns> public JsonResult DownLoadImages(Guid id, string title) { string dirInput = Path.Combine(Server.MapPath("~/Uploads"), id.ToString()); string outPutZipFile = Path.Combine(Server.MapPath("~/Uploads/OutPut"), title + ".zip"); string OutPutZipDir = Server.MapPath("~/Uploads/OutPut"); if (!Directory.Exists(dirInput)) { Directory.CreateDirectory(dirInput); } IO_Helper_DG.ZipDir(dirInput, outPutZipFile); Task_Helper_DG.TaskRun(() => { foreach (var item in Directory.GetFiles(OutPutZipDir)) { if (!item.Equals(outPutZipFile)) { System.IO.File.Delete(item); } } }); FileStream fileStream = new FileStream(outPutZipFile, FileMode.Open); long fileSize = fileStream.Length; byte[] fileBuffer = new byte[fileSize]; fileStream.Read(fileBuffer, 0, (int)fileSize); //如果不写fileStream.Close()语句,用户在下载过程中选择取消,将不能再次下载 fileStream.Close(); Response.ContentType = "application/octet-stream"; Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(title + ".zip", Encoding.UTF8)); Response.AddHeader("Content-Length", fileSize.ToString()); Response.BinaryWrite(fileBuffer); Response.End(); Response.Close(); return(OK("download success")); }
/// <summary> /// constructor /// </summary> public ConfigBootStrap() { JObject jobject_qx_frame_config = IO_Helper_DG.Json_GetJObjectFromJsonFile("../../config/qx_frame.config.json");//get json configuration file QX_Frame_Helper_DG_Config.ConnectionString_DB_QX_Frame_Default = jobject_qx_frame_config["database"]["connectionStrings"]["QX_Frame_Default"].ToString(); QX_Frame_Helper_DG_Config.Log_Location_General = jobject_qx_frame_config["log"]["Log_Location_General"].ToString(); QX_Frame_Helper_DG_Config.Log_Location_Error = jobject_qx_frame_config["log"]["Log_Location_Error"].ToString(); QX_Frame_Helper_DG_Config.Log_Location_Use = jobject_qx_frame_config["log"]["Log_Location_Use"].ToString(); QX_Frame_Helper_DG_Config.Cache_IsCache = jobject_qx_frame_config["cache"]["IsCache"].ToInt() == 1; QX_Frame_Helper_DG_Config.Cache_CacheExpirationTimeSpan_Minutes = jobject_qx_frame_config["cache"]["CacheExpirationTime_Minutes"].ToInt(); QX_Frame_Helper_DG_Config.Cache_CacheServer = QX_Frame.Bantina.Options.Opt_CacheServer.HttpRuntimeCache; QX_Frame_Helper_DG_Config.Cache_Redis_Host_ReadWrite_Array = jobject_qx_frame_config["cache"]["Cache_Redis_Host_ReadWrite_Array"].ToString().Split(','); QX_Frame_Helper_DG_Config.Cache_Redis_Host_OnlyRead_Array = jobject_qx_frame_config["cache"]["Cache_Redis_Host_OnlyRead_Array"].ToString().Split(','); QX_Frame_Helper_DG_Config.International_ConfigFileLocation = @"../../config/qx_frame.internationalization.json"; QX_Frame_Helper_DG_Config.International_Language = "english"; QX_Frame_Data_Config.ConnectionString_DB_QX_Frame_Test = jobject_qx_frame_config["database"]["connectionStrings"]["DB_QX_Frame_Test"].ToString(); Trace.WriteLine("configuration bootstrap succeed !"); }
private void MainForm_Load(object sender, EventArgs e) { try { // set copyright label_Author.Text += Info.Author; label_Version.Text += Info.VersionNum; label_Description.Text += Info.Description; //set config comboBox2.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "config", "outputType");//output type //set code builder config // textBox3.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "code", "usings").Replace('&','\n'); //using textBox2.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "code", "namespace"); //namespace textBox10.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "code", "namespaceCommonPlus"); //namespace textBox9.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "code", "TableName"); //table name textBox5.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "code", "class"); //class name textBox7.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "code", "ClassNamePlus"); //ClassExtends textBox8.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "code", "ClassExtends"); //ClassExtends textBox4.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "code", "fileName"); //fileName comboBox1.Text = IO_Helper_DG.Ini_SelectStringValue(CommonVariables.configFilePath, "code", "fileNameSuffix", ".txt"); //fileNameSuffix textBox6.Text = dir + "\\qixiaoCodeBuilder\\"; colorRichTextBox1.Language = CSharp_FlowchartToCode_DG.Controls.ColorRichTextBox.Languages.SQL; colorRichTextBox1.Language = CSharp_FlowchartToCode_DG.Controls.ColorRichTextBox.Languages.SQL; dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView2.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; dataGridView1.ColumnHeadersHeight = 22; timer1.Interval = 50;//progress refresh time } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }