private void gridViewColumn_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
try
{
int ID = ConvertType.ToInt(gridViewColumn.Rows[e.RowIndex].Cells["idCol"].Value);
string keys = gridViewColumn.Rows[e.RowIndex].Cells["KeysCol"].Value.ToString();
string name = gridViewColumn.Rows[e.RowIndex].Cells["namecol"].Value.ToString();
bool isActive = (Boolean)gridViewColumn.Rows[e.RowIndex].Cells["isActCol"].Value;
int vitri = ConvertType.ToInt(gridViewColumn.Rows[e.RowIndex].Cells["OrderidCol"].Value);
new Waiting((MethodInvoker) delegate
{
List <dm_column> model = SQLDatabase.Loaddm_column(string.Format("select * from dm_column where id='{0}'", ID));
if (model.Count > 0)
{
dm_column temp = model.FirstOrDefault();
temp.Keys = keys;
temp.name = name;
temp.act = isActive;
temp.orderid = ConvertType.ToInt(vitri);
SQLDatabase.Updatedm_column(temp);
}
}, "Vui Lòng Chờ").ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show("Unable to save the record. There might be a blank cell. ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private Label CreateLable(dm_column model, int index)
{
Label text = new Label();
text.Location = new Point(120, 20 + index * 35);
text.Name = string.Format("lbl_", model.ma);
text.Size = new Size(150, 20);
text.Tag = model.ma;
text.Text = model.name;
return(text);
}
private TextBox CreateTextbox(dm_column model, int index)
{
TextBox text = new TextBox();
text.Location = new Point(120, 20 + index * 35);
text.Name = string.Format("txt_", model.ma);
text.Tag = model.ma;
text.Size = new Size(300, 20);
text.Text = table.Rows[0][model.ma].ToString();
return(text);
}
private TableLayoutPanel CreateTableLayoutPanel(dm_column index)
{
TableLayoutPanel lbl = new TableLayoutPanel();
lbl.RowCount = 1;
lbl.ColumnCount = 2;
lbl.Name = string.Format("layoutPanel_", index.ma);
lbl.Height = 15;
lbl.AutoSize = true;
return(lbl);
}
private void button1_Click(object sender, EventArgs e)
{
try {
if (checkedListBox1.CheckedItems.Count == 0)
{
MessageBox.Show("Vui lòng chọn cột cần cập nhật", "Thông Báo");
return;
}
dm_column dm_Column = SQLDatabase.Loaddm_column("select * from dm_column where isKey=1").FirstOrDefault();
dm_batdongbo dm_Batdongbo = SQLDatabase.Loaddm_batdongbo("select * from dm_batdongbo where isAct=1").FirstOrDefault();
string strCommand = "";
if (IsUpdate)
{
if (checkBox1.Checked)
{
strCommand = " UPDATE t WITH(TABLOCK) " +
setColUp() +
string.Format(" from dbo.root t inner join dbo.import s on t.{0}=s.{0} ", dm_Column.ma) +
string.Format(" where EXISTS ( select 1 from (SELECT {0}, ", dm_Column.ma) +
setSelectUp() +
string.Format(" from dbo.import ) as qry UNPIVOT(col FOR column_name IN ({0})) AS unpvt WHERE CAST(col AS VARCHAR(15)) = '**NULL_VALUE**' AND t.{1} = {1} )", inSQL(), dm_Column.ma) +
string.Format(" {0}", dm_Batdongbo.ma);
}
else
{
strCommand = "update dbo.root WITH(TABLOCK)" +
setColUp2() +
" from dbo.root t1 , dbo.import t2" +
string.Format(" where t1.{0}=t2.{0} ", dm_Column.ma) +
string.Format(" {0} ", dm_Batdongbo.ma);
}
strSQL = strCommand;
}
else
{
strCommand = string.Format(" insert into dbo.root WITH(TABLOCK)({0}) ", setSelectInsert(""));
strCommand += string.Format(" select {0} from dbo.import a left join dbo.root b on a.{1}=b.{1} where b.{1} is null ", setSelectInsert("a"), dm_Column.ma);
strCommand += string.Format(" {0} ", dm_Batdongbo.ma);
strSQL = strCommand;
}
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ex) {
MessageBox.Show(ex.Message, "button1_Click");
}
}
private void AddController(dm_column model, int index)
{
TableLayoutPanel tableLayoutPanel = new TableLayoutPanel();
tableLayoutPanel = CreateTableLayoutPanel(model);
Label lbl = new Label();
lbl = CreateLable(model, index);
TextBox textBox = new TextBox();
textBox = CreateTextbox(model, index);
tableLayoutPanel.Controls.Add(lbl);
tableLayoutPanel.Controls.Add(textBox);
groupbox.Add(index, tableLayoutPanel);
tableLayoutPanelMain.Controls.Add(tableLayoutPanel);
}
