private void frmUpdateValues_Load(object sender, EventArgs e)
{
lbTableName.Text += " " + tb + " - " + db;
lbTableName.Left = (panel1.Right - panel1.Left) / 2 - lbTableName.Width / 2;
List <String[]> my_Table_Contents = rF.read_Table_Contents(tb, db, myField);
lbPK.Text += getPrimaryKey(myField);
dgvData.DataSource = dt.ConvertListToDataTable(myField, my_Table_Contents);
loadFKdata();
}
private void btnHoanThanh_Click(object sender, EventArgs e)
{
if (txtTableName.Text.Trim().Equals(""))
{
MessageBox.Show("Tên bảng không được để trống");
txtTableName.Focus();
return;
}
List <Field> myField_1 = new List <Field>();
if (isAlter == 1)
{
myField_1 = rF.read_File_Infor(cmbTables.SelectedValue.ToString(), cmbDatabase.SelectedValue.ToString());
}
List <int> delete_index = new List <int>();
List <Field> myField = new List <Field>();
for (int i = 0; i <= colCount; i++)
{
String text1 = getText("txtColName" + i.ToString());
String text2 = getText("txtColPro" + i.ToString());
bool text3 = isCheck("chk" + i.ToString());
if (!text1.Trim().Equals("") && !text2.Trim().Equals(""))
{
Field fi = new Field(text1, text2, text3);
myField.Add(fi);
}
else
{
if (isAlter == 1)
{
delete_index.Add(i);
}
}
}
if (isAlter == 1)
{
try
{
rF.delete_file("database/" + cmbDatabase.SelectedValue.ToString() + "/" + cmbTables.SelectedValue.ToString() + "inf_.txt");
}
catch
{
}
}
wF.write_Table_Infor(myField, txtTableName.Text.Trim(), cmbDatabase.SelectedValue.ToString());
if (isAlter == 1)
{
if (isSameField(myField, myField_1))
{
return;
}
// lấy myField ra trước
myField = rF.read_File_Infor(cmbTables.SelectedValue.ToString(), cmbDatabase.SelectedValue.ToString());
//Xóa file cũ.
//backup file mới.
List <String[]> my_Table_Contents = rF.read_Table_Contents(cmbTables.SelectedValue.ToString(), cmbDatabase.SelectedValue.ToString(), myField_1);
List <String> myContents = new List <String>();
foreach (String[] str in my_Table_Contents)
{
String temp = "";
for (int i = 0; i < str.Length; i++)
{
if (!isInDelete(i, delete_index))
{
temp += '\'' + str[i];
}
}
myContents.Add(temp);
}
if (isAlter == 1)
{
try
{
rF.delete_file("database/" + cmbDatabase.SelectedValue.ToString() + "/" + cmbTables.SelectedValue.ToString() + ".txt");
}
catch { }
}
wF.write_Table_Contents(myContents, txtTableName.Text.ToString(), cmbDatabase.SelectedValue.ToString());
}
if (isAlter == 1)
{
MessageBox.Show("Đã update table thành công");
}
resetTable();
isAlter = 0;
}