public List <string> GetAll() { SQLControl sql = new SQLControl(estimateDatabaseString); sql.ExecQuery("SELECT JobNumber FROM EstimateHeader"); if (sql.HasException()) { throw new Exception("The JobNumberRepository was unable to populate the list of job numbers"); } else if (sql.DBDT.Rows.Count == 0) { //MessageBox.Show("There doesn't appear to be a record for the system: " + systemName + " in Job Number: " + _jobNumber + ". This could be: \n" + // "1. Because of a mismatch in system names between the name contained in the estimate sheet and the name contained in the report. \n" + // "2. Because a phase code was included on the CSV report that wasn't included in the original Estimate." ); return(null); } else { List <string> jobNumberList = new List <string>(); for (int i = 0; i < sql.DBDT.Rows.Count; i++) { string jobNumber = sql.DBDT.Rows[i].ItemArray[0].ToString(); jobNumberList.Add(jobNumber); } return(jobNumberList); } }
/// <summary> /// Returns the 'Earned' (estimated) hours from [EstimateMain] for the provided phase code and system name. /// </summary> /// <remarks> /// Connects to the "BudgetVSTO" database. /// </remarks> /// <param name="phaseCode"></param> /// <returns></returns> public double GetEarnedHours(string systemName, string phaseCode) { if (ValidateSystemName(systemName)) { SQLControl sql = new SQLControl(estimateDatabaseString); sql.AddParam("@jobNumber", _jobNumber); sql.AddParam("@systemName", systemName); sql.AddParam("@phaseCode", phaseCode); sql.ExecQuery("SELECT TOP(1) EarnedHours FROM EstimateMain WHERE SystemName = @systemName AND PhaseCode = @phaseCode AND JobNumber = @jobNumber"); //sql.ExecQuery("SELECT * FROM EstimateMain"); if (sql.HasException()) { throw new Exception(sql.Exception.ToString()); } else if (sql.DBDT.Rows.Count == 0) { //MessageBox.Show("There doesn't appear to be a record for the system: " + systemName + " in Job Number: " + _jobNumber + ". This could be: \n" + // "1. Because of a mismatch in system names between the name contained in the estimate sheet and the name contained in the report. \n" + // "2. Because a phase code was included on the CSV report that wasn't included in the original Estimate." ); return(0); } else { double earnedHours = Convert.ToDouble(sql.DBDT.Rows[0].ItemArray[0].ToString()); return(earnedHours); } } else { return(0); } }
private void Add_Click(object sender, EventArgs e) { SQLControl controle = new SQLControl(); controle.InsertLocalTable(Nome.Text, Endereco.Text); MessageBox.Show("Inserido com sucesso.", "Sucesso!"); }
public IActionResult DownLoad() { string token = Request.Cookies["Token"]; string[] p = Request.Headers["Path"].ToString().Split('/'); //string[] p = "./ALL01UMD.sav".Split('/'); if (Token.CheckToken(token)) { string ID = token.Split("-")[0]; ID = ID.Substring(0, ID.Length - 10); DataTable table; if ((table = SQLControl.Select($"SELECT * FROM testbase.UserTable where ID={ID};")) == null) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } string name = table.Rows[0][1].ToString(); if ((table = SQLControl.Select($"SELECT * FROM testbase.UserFileTable where UserName='******';")) == null) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } JToken file = JToken.Parse(table.Rows[0][1].ToString()); Queue <string> pathlist = new Queue <string>(p); JToken nowdir = Dir.Intodir(file, pathlist); if (nowdir == null) { return(BadRequest(JsonConvert.SerializeObject(new ReturnMode() { Data = "文件路径错误", Message = "Error" }))); } if ((table = SQLControl.Select($"SELECT * FROM testbase.HashTable where ID={nowdir["data"]};")) == null) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } string filepath = table.Rows[0][2].ToString(); return(File(new FileStream(filepath, FileMode.Open), "application/octet-stream", p[p.Length - 1])); } else { return(BadRequest(JsonConvert.SerializeObject(new ReturnMode() { Data = "Token错误", Message = "Error" }))); } }
public string Register() { string Json = ""; string a = new StreamReader(HttpContext.Request.Body).ReadToEnd(); SingInMode user = JsonConvert.DeserializeObject <SingInMode>(a); if (!string.IsNullOrEmpty(user.Name) | !string.IsNullOrWhiteSpace(user.Name) | !string.IsNullOrEmpty(user.Pwds) | !string.IsNullOrWhiteSpace(user.Pwds)) { if (0 != SQLControl.Execute($"insert CDNABASE.UserTable value (0 ,'{user.Name}','{user.Pwds}');")) { if (0 != SQLControl.Execute($"insert CDNABASE.UserDataTable value ('{user.Name}','{user.PhoneNumber}','InitialImage.jpg');")) { if (0 != SQLControl.Execute($"insert CDNABASE.UserFileTable value ('{user.Name}','{Token.s}',1);")) { Json = JsonConvert.SerializeObject(new ReturnMode() { Data = "注册成功", Message = "OK" }); } else { Json = JsonConvert.SerializeObject(new ReturnMode() { Data = "注册失败,服务器错误", Message = "Error" }); } } else { Json = JsonConvert.SerializeObject(new ReturnMode() { Data = "注册失败,服务器错误", Message = "Error" }); } } else { Json = JsonConvert.SerializeObject(new ReturnMode() { Data = "注册失败,或有重复用户名", Message = "Error" }); } } else { Json = JsonConvert.SerializeObject(new ReturnMode() { Data = "空!", Message = "Error" }); } return(Json); }
/// <summary> /// Returns the 'Original_Est_Hours' from [JC_PHASE_MASTER_MC] for the provided Job Number and Phase Code, where Cost Type is always "L" for "Labor" /// </summary> /// <param name="phaseCode"></param> /// <returns></returns> //public double GetBudgetedHoursByPhaseCode(string phaseCode) //{ // phaseCode = phaseCode.Remove(4, 1); // SQLControl sql = new SQLControl(spectrumDatabaseString); // //sql.AddParam("@jobNumber", _jobNumber); // sql.AddParam("@jobNumber", " " + _jobNumber); // sql.AddParam("@phaseCode", phaseCode); // sql.AddParam("@costType", "L"); // //sql.AddParam("@costType", "L"); // //sql.ExecQuery("SELECT TOP(1) Original_Est_Hours FROM JC_PHASE_MASTER_MC WHERE Phase_Code = @phaseCode AND Job_Number = @jobNumber AND Cost_Type = @costType"); // sql.ExecQuery("SELECT TOP(1) Projected_Hours FROM JC_PROJ_COST_HISTORY_MC WHERE Phase = @phaseCode AND Job = @jobNumber AND Cost_Type = @costType"); // //sql.ExecQuery("SELECT * FROM EstimateMain"); // if (sql.HasException()) // { // throw new Exception(sql.Exception.ToString()); // } // else if (sql.DBDT.Rows.Count == 0) // { // //MessageBox.Show("There doesn't appear to be a record for the system: " + systemName + " in Job Number: " + _jobNumber + ". This could be: \n" + // // "1. Because of a mismatch in system names between the name contained in the estimate sheet and the name contained in the report. \n" + // // "2. Because a phase code was included on the CSV report that wasn't included in the original Estimate." ); // return 0; // } // else // { // //int budgetedHours = Convert.ToInt32(sql.DBDT.Rows[0].ItemArray[0].ToString()); // double budgetedHours = Convert.ToDouble(sql.DBDT.Rows[0].ItemArray[0].ToString()); // return budgetedHours; // } //} /// <summary> /// Returns the "Projected_Hours" field from the "JC_PROJ_COST_HISTORY_MC" table in SPECTRUM. /// </summary> /// <param name="phaseCode"></param> /// <returns></returns> public double GetProjectedHoursByPhaseCode(string phaseCode) { if (_dataProvider.UsingExternalCache == true) { return(externalDataCache.GetProjectedHoursByPhaseCode(phaseCode)); } else { try { phaseCode = phaseCode.Remove(4, 1); //SQLControl sql = new SQLControl(spectrumDatabaseString); SQLControl sql = new SQLControl(spectrumDatabaseString); //sql.AddParam("@jobNumber", _jobNumber); sql.AddParam("@jobNumber", " " + _jobNumber); sql.AddParam("@phaseCode", phaseCode); sql.AddParam("@costType", "L"); sql.ExecQuery("SELECT SUM(Projected_Hours) FROM JC_PROJ_COST_HISTORY_MC WHERE Phase = @phaseCode AND Job = @jobNumber AND Cost_Type = @costType"); //sql.ExecQuery("SELECT * FROM EstimateMain"); if (sql.HasException()) { return(externalDataCache.GetProjectedHoursByPhaseCode(phaseCode)); } else if (sql.DBDT.Rows.Count == 0) { //MessageBox.Show("There doesn't appear to be a record for the system: " + systemName + " in Job Number: " + _jobNumber + ". This could be: \n" + // "1. Because of a mismatch in system names between the name contained in the estimate sheet and the name contained in the report. \n" + // "2. Because a phase code was included on the CSV report that wasn't included in the original Estimate." ); return(0); } else { //int budgetedHours = Convert.ToInt32(sql.DBDT.Rows[0].ItemArray[0].ToString()); double projectedHours = Convert.ToDouble(sql.DBDT.Rows[0].ItemArray[0].ToString()); return(projectedHours); } } catch (Exception e) { MessageBox.Show(e.Message); throw; } } }
public IActionResult PostList() { string Json = ""; string[] p = new StreamReader(Request.Body).ReadToEnd().Split('/'); Queue <string> path = new Queue <string>(p); string a = Request.Cookies["Token"]; if (Token.CheckToken(a)) { string ID = a.Split("-")[0]; ID = ID.Substring(0, ID.Length - 10); DataTable table; if ((table = SQLControl.Select($"SELECT * FROM testbase.UserTable where ID = {ID};")) == null) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } string name = table.Rows[0][1].ToString(); table = null; if ((table = SQLControl.Select($"SELECT * FROM testbase.UserFileTable where UserName = '******';")) == null) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } JToken file = JToken.Parse(table.Rows[0][1].ToString()); JToken nowdir = Dir.Intodir(file, path); Json = JsonConvert.SerializeObject(new ReturnMode() { Data = nowdir.ToString(), Message = "OK" }); return(Ok(Json)); } else { return(BadRequest(JsonConvert.SerializeObject(new ReturnMode() { Data = "Token错误", Message = "Error" }))); } }
private bool ProbeSpectrumDatabase() { string spectrumDatabaseString = ConnectionStringService.GetConnectionString("Spectrum"); SQLControl sql = new SQLControl(spectrumDatabaseString); //sql.AddParam("@jobNumber", _jobNumber); //sql.AddParam("@costType", "L"); sql.ExecQuery("SELECT * FROM JC_TRANSACTION_HISTORY_MC WHERE Job_Number = ' 2190302'"); if (sql.HasException()) { return(false); } else { return(true); } }
public string Post() { string Json = ""; string a = new StreamReader(HttpContext.Request.Body).ReadToEnd(); UserMode user = JsonConvert.DeserializeObject<UserMode>(a); if (!string.IsNullOrEmpty(user.Name) | !string.IsNullOrWhiteSpace(user.Name) | !string.IsNullOrEmpty(user.Pwds) | !string.IsNullOrWhiteSpace(user.Pwds)) { DataTable s; if ((s = SQLControl.Select($"SELECT * FROM CDNABASE.UserTable where UserName='******'and PassWord='******';")) == null) Json = JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }); if (s.Rows.Count != 0) Json = JsonConvert.SerializeObject(new ReturnMode() { Data = Token.GetToken(s.Rows[0][0].ToString()), Message = "OK" }); else Json = JsonConvert.SerializeObject(new ReturnMode() { Data = "用户名密码错误", Message = "Error" }); } else Json = JsonConvert.SerializeObject(new ReturnMode() { Data = "空!", Message = "Error" }); return Json; }
//TODO: Refence this function in the SPECTRUM-related procedures above. private bool ValidateSPECTRUMPhaseCode(string phaseCode) { SQLControl sql = new SQLControl(estimateDatabaseString); sql.AddParam("@jobNumber", _jobNumber); sql.AddParam("@phaseCode", phaseCode); sql.ExecQuery("SELECT * FROM EstimateMain WHERE JobNumber = @jobNumber AND PhaseCode = @phaseCode"); if (sql.HasException()) { throw new Exception(sql.Exception.ToString()); } else if (sql.DBDT.Rows.Count == 0) { return(false); } else { return(true); } }
/// <summary> /// Commits the SystemEstimate objects contained in the provided list to the database. /// </summary> /// <param name="systemEstimateList"></param> public void Commit(List <SystemEstimate> systemEstimateList) { //Convert the systemEstimateLIst into EstimateTransaction form, ready for database commit. List <EstimateTransaction> transactionData = ConvertToEstimateTransaction(systemEstimateList); if (transactionData != null && transactionData.Count != 0) { try { //Insert a new header entry into the database. SQLControl sql = new SQLControl(ConnectionStringService.GetConnectionString("Estimate")); sql.AddParam("@jobNumber", _jobNumber); sql.AddOutputParam("@estimateID", SqlDbType.Int, 4); int nextEstimateID = (int)sql.GetReturnValueFromStoredProcedure("spInsertEstimateHeader", "@estimateID"); //If the new estimate header was successfully added, continue with the process. if (nextEstimateID > 0) { //Assign the estimate ID to the transaction objects. //int newEstimateID = 12; foreach (EstimateTransaction t in transactionData) { t.EstimateID = nextEstimateID; } //Send the transaction list to be inserted in the database. InsertMultipleRecords(transactionData); } } catch (Exception e) { MessageBox.Show(e.Message.ToString()); throw; } } else { throw new Exception("Estimate commit aborted because transaction data list failed to populate correctly."); } }
/// <summary> /// Returns true if the job number is found in the estimating database. Only one estimate record is allowed per job number. /// </summary> /// <param name="jobNumber"></param> /// <returns></returns> public bool IsDuplicateJobNumber(string jobNumber) { using (SQLControl sql = new SQLControl(ConnectionStringService.GetConnectionString("Estimate"))) { sql.AddParam("@jobNumber", jobNumber); sql.ExecQuery("SELECT * FROM EstimateHeader WHERE JobNumber = @jobNumber"); if (sql.HasException()) { throw new Exception("Error in SQLControl class while attempting to detect duplicate job numbers."); } if (sql.DBDT.Rows.Count == 0) { return(false); } else { return(true); } }; }
/// <summary> /// Validates the provided system name by matching it with a corresponding entry in the 'EstimateMain' table. /// </summary> /// <param name="systemName"></param> /// <returns></returns> public bool ValidateSystemName(string systemName) { //To avoid displaying multiple error messages for the same system, a list of systems for which errors have been displayed is kept. When the next error //is triggered, the message will only display if the system is not found in this list. List <string> uniqueSystemsList = new List <string>(); SQLControl sql = new SQLControl(estimateDatabaseString); sql.AddParam("@jobNumber", _jobNumber); sql.AddParam("@systemName", systemName); sql.ExecQuery("SELECT * FROM EstimateMain WHERE SystemName = @systemName AND JobNumber = @jobNumber"); if (sql.HasException()) { throw new Exception(sql.Exception.ToString()); } else if (sql.DBDT.Rows.Count == 0) { if (uniqueSystemsList.Contains(systemName)) { //Do nothing. } else { MessageBox.Show("The system: " + systemName + " was not found in the Estimate record. This could be due to a mismatch between the case/spelling used in " + "CSV report file. Check the Estimate sheet for the job and make sure the system names match exactly. If they do not, alter the CSV file entry and try again"); //Add the system name to the uniqueSystemsList so that no more error messages appear for this system. uniqueSystemsList.Add(systemName); } return(false); } else { return(true); } }
/// <summary> /// Returns the summed earnedhours from EstimateMain for provided jobnumber and phase code /// </summary> /// <param name="phaseCode"></param> /// <returns></returns> public double GetTeamBudgetHours(string phaseCode) { if (ValidateEstimatePhaseCode(phaseCode)) { SQLControl sql = new SQLControl(estimateDatabaseString); //sql.AddParam("@jobNumber", _jobNumber); sql.AddParam("@jobNumber", _jobNumber); sql.AddParam("@phaseCode", phaseCode); //sql.AddParam("@costType", "L"); sql.ExecQuery("SELECT SUM(EarnedHours) FROM EstimateMain WHERE JobNumber = @jobNumber AND PhaseCode = @phaseCode"); //sql.ExecQuery("SELECT * FROM EstimateMain"); if (sql.HasException()) { throw new Exception(sql.Exception.ToString()); } else if (sql.DBDT.Rows.Count == 0 || sql.DBDT == null) { //MessageBox.Show("There doesn't appear to be a record for the system: " + systemName + " in Job Number: " + _jobNumber + ". This could be: \n" + // "1. Because of a mismatch in system names between the name contained in the estimate sheet and the name contained in the report. \n" + // "2. Because a phase code was included on the CSV report that wasn't included in the original Estimate." ); return(0); } else { //int budgetedHours = Convert.ToInt32(sql.DBDT.Rows[0].ItemArray[0].ToString()); //int teamBudgetHours = Convert.ToInt32(sql.DBDT.Rows[0].ItemArray[0].ToString()); double teamBudgetHours = Convert.ToDouble(sql.DBDT.Rows[0].ItemArray[0].ToString()); return(teamBudgetHours); } } else { return(0); } }
// events --------------------------------------------------------------------- private void LoginWindow1_Load(object sender, EventArgs e) { // Create Folder / File structure InitilizeFolderStructure(); // Initilize Profile Window PW = new ProfileWindow(this); // Initilize SQL Control SQLControl SC = new SQLControl(textBox4.Text, textBox3.Text, "192.168.86.38");// update after we add a textbox for serverip input Globals._SC = SC; // Load Last SQL Settings Functions.LoadSettings(); textBox3.Text = Globals._Settings["SQL Database"]; textBox4.Text = Globals._Settings["SQL Server"]; try { if (Globals._Settings["Remember Username"] == "true") { checkBox1.Checked = true; textBox2.Text = Globals._Settings["SQL Username"]; } } catch (Exception ex) { } // Initilize Verification Thread and run it if (textBox3.Text != "" && textBox4.Text != "") { new Thread(VerifyConnection).Start(); } }
public IActionResult DownLoad() { string token = Request.Cookies["Token"]; string[] p = Request.Headers["Path"].ToString().Split('/'); //string[] p = "./ALL01UMD.sav".Split('/'); if (Token.CheckToken(token)) { string ID = token.Split("-")[0]; ID = ID.Substring(0, ID.Length - 10); DataTable table; if ((table = SQLControl.Select($"SELECT * FROM CDNABASE.UserTable where ID={ID};")) == null) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } string name = table.Rows[0][1].ToString(); if ((table = SQLControl.Select($"SELECT * FROM CDNABASE.UserFileTable where UserName='******';")) == null) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } JToken file = JToken.Parse(table.Rows[0][1].ToString()); Queue <string> pathlist = new Queue <string>(p); JToken nowdir = Dir.Intodir(file, pathlist); if (nowdir == null) { return(BadRequest(JsonConvert.SerializeObject(new ReturnMode() { Data = "文件路径错误", Message = "Error" }))); } if ((table = SQLControl.Select($"SELECT * FROM CDNABASE.HashTable where ID={nowdir["data"]};")) == null) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } string filepath = table.Rows[0][2].ToString(); bool k = false; CDNAFileStream filestream = null; foreach (string key in streamtable.Keys) { if (key == filepath) { k = true; filestream = streamtable[key]; break; } } if (!k) { filestream = new CDNAFileStream(filepath, FileMode.Open); streamtable.Add(filepath, filestream); } long length = filestream.Length; byte[] data = new byte[length]; for (long i = 0; i < filestream.Length; i++) { while (!filestream.ISREAD) { ; } filestream.ISREAD = false; long nowpo = filestream.Position; filestream.Seek(i, SeekOrigin.Begin); data[i] = (byte)filestream.ReadByte(); filestream.Seek(nowpo, SeekOrigin.Begin); filestream.ISREAD = true; } return(File(data, "application/octet-stream", p[p.Length - 1])); } else { return(BadRequest(JsonConvert.SerializeObject(new ReturnMode() { Data = "Token错误", Message = "Error" }))); } }
//[DisableFormValueModelBinding] //[RequestFormLimits(MultipartBodyLengthLimit = 200 * 1024 * 1024)] public IActionResult UpLoad() { string token = Request.Cookies["Token"]; string[] p = Request.Headers["Path"].ToString().Split('/'); //string[] p = "./A/".Split('/'); var files = Request.Form.Files; if (Token.CheckToken(token) && files != null) { Stream stream = null; string saveFilePath = null; JArray filestr = null; string name = null; try { foreach (var file in files) { string ID = token.Split("-")[0]; ID = ID.Substring(0, ID.Length - 10); DataTable table; if ((table = SQLControl.Select($"SELECT * FROM testbase.UserTable where ID={ID};")) == null) { throw new NewSqlException(); } name = table.Rows[0][1].ToString(); filestr = null; stream = file.OpenReadStream(); byte[] hash = Save_ReadFile.GetHash(stream); MySqlParameter hashParameter = new MySqlParameter("@hash", MySqlDbType.TinyBlob); hashParameter.Value = hash; int fileID = 0; //检查Hash表里是否有这个文件 if (-1 == (fileID = SQLControl.Select($"SELECT * FROM testbase.HashTable where Hash = @hash;", hashParameter))) {//没有就加进去 string filename = DateTime.Now.ToString("yyyyMMddhhmmss"); while (System.IO.File.Exists(FilePath + filename)) { filename = DateTime.Now.ToString("yyyyMMddhhmmss") + new Random().Next(10); } if (!Save_ReadFile.SaveFile(FilePath + filename, file)) { throw new IOException(); } MySqlParameter blobParameter = new MySqlParameter("@hash", MySqlDbType.TinyBlob); blobParameter.Value = hash; if (0 == SQLControl.Execute($"insert testbase.HashTable value (0,@hash,'{FilePath + filename}');", blobParameter)) { throw new NewSqlException(); } fileID = SQLControl.Select($"SELECT * FROM testbase.HashTable where Hash = @hash;", blobParameter); } //把Hash绑定到用户文件列表上 do { table = null; if ((table = SQLControl.Select($"SELECT * FROM testbase.UserFileTable where UserName='******';")) == null) { throw new NewSqlException(); } } while (int.Parse(table.Rows[0][2].ToString()) != 1); filestr = JArray.Parse(table.Rows[0][1].ToString()); Queue <string> pathlist = new Queue <string>(p); JObject jo = new JObject(); Encoding encoding = Encoding.Default; jo.Add("time", DateTime.Now.ToString("yyyy-MM-dd")); jo.Add("name", file.FileName); jo.Add("type", "file"); jo.Add("size", file.Length); jo.Add("data", fileID); JToken newdir = Dir.AddJson(filestr, pathlist, JToken.Parse(jo.ToString())); SQLControl.Execute($"UPDATE testbase.UserFileTable SET File='' , State = 0 where UserName='******';"); SQLControl.Execute($"UPDATE testbase.UserFileTable SET File='{newdir.ToString()}',State = 1 where UserName='******';"); } } catch (IOException) { if (stream != null) { stream.Close(); } if (System.IO.File.Exists(saveFilePath)) { System.IO.File.Delete(saveFilePath); } return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "服务器保存错误", Message = "Error" }))); } catch (NewSqlException) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } catch (MySqlException) { if (filestr != null) { SQLControl.Execute($"UPDATE testbase.UserFileTable SET File='{filestr.ToString()}' , State = 1 where UserName='******';"); } } } else { return(BadRequest(JsonConvert.SerializeObject(new ReturnMode() { Data = "Token错误", Message = "Error" }))); } return(Ok(JsonConvert.SerializeObject(new ReturnMode() { Data = "保存完成!", Message = "OK" }))); }
public CreateAccount(SQLControl SControl) { InitializeComponent(); SC = SControl; }
public IActionResult AddDir() { string token = Request.Cookies["Token"]; string[] p = Request.Headers["Path"].ToString().Split('/'); string dirname = Request.Headers["DirName"].ToString(); string name = ""; JArray filestr = null; Queue <string> q = new Queue <string>(p); DataTable table = null; try { if (Token.CheckToken(token)) { string ID = token.Split("-")[0]; ID = ID.Substring(0, ID.Length - 10); if ((table = SQLControl.Select($"SELECT * FROM testbase.UserTable where ID={ID};")) == null) { throw new NewSqlException(); } name = table.Rows[0][1].ToString(); if ((table = SQLControl.Select($"SELECT * FROM testbase.UserFileTable where UserName='******';")) == null) { throw new NewSqlException(); } do { table = null; if ((table = SQLControl.Select($"SELECT * FROM testbase.UserFileTable where UserName='******';")) == null) { throw new NewSqlException(); } } while (int.Parse(table.Rows[0][2].ToString()) != 1); filestr = JArray.Parse(table.Rows[0][1].ToString()); JObject job = new JObject(); job["time"] = DateTime.Now.ToString("yyyy-MM-dd"); job["name"] = dirname; job["type"] = "dir"; job["data"] = "[]"; JToken newdir = Dir.AddJson(filestr, q, JToken.Parse(job.ToString())); SQLControl.Execute($"UPDATE testbase.UserFileTable SET File='' , State = 0 where UserName='******';"); SQLControl.Execute($"UPDATE testbase.UserFileTable SET File='{newdir.ToString()}',State = 1 where UserName='******';"); } else { return(BadRequest(JsonConvert.SerializeObject(new ReturnMode() { Data = "Token错误", Message = "Error" }))); } } catch (NewSqlException) { return(StatusCode(500, JsonConvert.SerializeObject(new ReturnMode() { Data = "数据库错误", Message = "Error" }))); } catch (MySqlException) { if (filestr != null) { SQLControl.Execute($"UPDATE testbase.UserFileTable SET File='{filestr.ToString()}' , State = 1 where UserName='******';"); } } return(Ok()); }