Exemple #1
0
        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);
        }
Exemple #2
0
 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;
     }
 }
Exemple #3
0
        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);
                }
            }
        }