public tableinfo Post([FromBody] tablename req)
{
tableinfo resp = new tableinfo();
try
{
//从配置文件中读取字符串
Json_File _Json_File = new Json_File();
var configuration = _Json_File.Read_Json_File();
string connString = configuration["conn"];
MySqlConnection conn = new MySqlConnection(connString);
using (MySqlCommand cmd = new MySqlCommand())//创建查询命令
{
string sql = "select * from " + req.table;
cmd.Connection = conn;
cmd.CommandText = sql;
//cmd.Parameters.Add(new MySqlParameter("@tablename",req.table));表名不能进行参数化查询
MySqlDataAdapter reader = new MySqlDataAdapter(cmd); //创建一个执行命令的适配器对象
DataSet ds = new DataSet(); //相当于建立一个基于前台的虚拟数据库
DataTable dtable; //相当于数据库中的一张数据表
DataRowCollection coldrow; //相当于表中行的集合
DataRow drow; //相当于一行中列的数据集合
reader.Fill(ds, "ds"); //将查询的结果存储到虚拟数据库ds的虚拟表student中
dtable = ds.Tables["ds"]; //将数据表student的数据复制到DataTable对象（取库中的一张数据表）
coldrow = dtable.Rows; //获取数据表中的所有行
int len = coldrow[0].ItemArray.Length; //获取一行有多少字段
resp.countofcolumns = len; //数据表列数
resp.countofrows = coldrow.Count; //数据表行数
resp.tableheader = new string[0];
for (int i = 0; i < dtable.Columns.Count; i++)
{
List <string> b = resp.tableheader.ToList();
b.Add(dtable.Columns[i].ColumnName);
resp.tableheader = b.ToArray();
}
resp.tableinformation = new List <List <string> >();
for (int inti = 0; inti < coldrow.Count; inti++)
{
drow = coldrow[inti];
List <string> temp = new List <string>();
for (int j = 0; j < len; j++)
{
temp.Add(drow[j].ToString());
}
resp.tableinformation.Add(temp);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(resp);
}
private void ckbCreateNewTM_CheckedChanged(object sender, EventArgs e)
{
if (ckbCreateNewTM.Checked)
{
ckbUseTMCreated.Enabled = false;
cboTMName.Enabled = false;
tablename tb = cboTMName.SelectedItem as tablename;
Console.WriteLine(tb.name);
}
else
{
ckbUseTMCreated.Enabled = true;
cboTMName.Enabled = true;
}
}
private void createProject()
{
DAOTM tmdao = new DAOTM();
TextOfMessageBox a = new TextOfMessageBox();
string name = txtProjectName.Text;
string sourceFileLanguge = cboSourceFilesLanguage.Text;
string translatedFileLanguge = cboTranslatedFilesLanguage.Text;
//string locationFolder = txtLocation.Text + "\\" + txtProjectName.Text;
string locationFolder = Path.Combine(txtLocation.Text, txtProjectName.Text);
DateTime now = new DateTime();
now = DateTime.Now;
Project project = new Project();
project.setLanguage(sourceFileLanguge, translatedFileLanguge);
project.setNameProject(name);
project.setPathProject(locationFolder);
project.setCreationTime(now);
if (ckbUseTMCreated.Checked)
{
tablename tbn = cboTMName.SelectedItem as tablename;
project.setTMName(tbn.name);
mainForm.setProject(project);
closeForm();
mainForm.createNewProject();
//mainForm.creatNewProjectForm = null;
//closeForm();
}
if (ckbCreateNewTM.Checked)
{
string tmname = txtTMName.Text;
project.setTMName(tmname);
int result = tmdao.createTable(project.getTMName());
if (result == 0)
{
mainForm.setProject(project);
closeForm();
mainForm.createNewProject();
//mainForm.creatNewProjectForm = null;
closeForm();
}
else
{
MessageBox.Show(a.CREATE_TM_FAILED, "Cảnh báo", MessageBoxButtons.YesNo);
}
}
}
