private void btn1_Click(object sender, EventArgs e)
{
vshir vs = new vshir();
vs.typ = 1;
vs.ShowDialog(this);
con.connection();
dataGridViewX1.DataSource = con.show_data("select * from vshir");
con.Disconnect();
}
private void btn1_Click(object sender, EventArgs e)
{
gharardad gh = new gharardad();
gh.type = 1;
gh.ShowDialog(this);
con.connection();
dataGridViewX1.DataSource = con.show_data("select * from gharardademosh");
con.Disconnect();
}
private void btn1_Click(object sender, EventArgs e)
{
analizeshir ash = new analizeshir();
ash.type = 1;
ash.ShowDialog(this);
con.connection();
dataGridViewX1.DataSource = con.show_data("select * from analizeshir");
con.Disconnect();
}
private void buttonX3_Click(object sender, EventArgs e)
{
if (flag == 0)
{
mtxt1.Focus();
return;
}
if (flag == 1)
{
sql = "INSERT INTO moshtary(code, codemar, name, family, phon, kosoorat, shhesab, address)" +
"VALUES(N'" + mtxt1.Text + "', N'" + mtxt2.Text + "', N'" + txt3.Text + "', N'" + txt4.Text + "', N'" + txt5.Text + "', N'" + txt6.Text + "', N'" + txt7.Text + "', N'" + txt8.Text + "')";
}
else if (flag == 2)
{
sql = "UPDATE moshtary " +
"SET code = N'" + mtxt1.Text + "', codemar = N'" + mtxt2.Text + "', name = N'" + txt3.Text + "', family = N'" + txt4.Text + "', " +
"phon = N'" + txt5.Text + "', kosoorat = N'" + txt6.Text + "', shhesab = N'" + txt7.Text + "', address = N'" + txt8.Text + "' " +
" WHERE (code = N'" + dataGridViewX1.CurrentRow.Cells[0].Value.ToString() + "')";
}
con.connection();
if (con.exe_data(sql))
{
dataGridViewX1.DataSource = con.show_data("select * from moshtary");
FMessegeBox.FarsiMessegeBox.Show("اطلاعات با موفقیت ثبت شد");
}
else
{
FMessegeBox.FarsiMessegeBox.Show("مشکل در ذخیره اطلاعات", "اخطار", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error);
}
clear();
if (flag == 2)
{
key27();
}
else
{
mtxt1.Focus();
}
con.Disconnect();
}
private void maskedTextBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue == 27)
{
this.Close();
}
if (e.KeyValue == 13)
{
con.connection();
DataTable dt = con.show_data("select code'کد مشتری',name+N' '+family'نام و نام خانوادگی' from moshtary where code = N'" + txt1.Text + "' AND codemar = N'" + function.Code_markaz + "' ");
con.Disconnect();
if (dt.Rows.Count == 0)
{
txt2.Text = "";
txt1.Text = "";
}
else
{
txt1.Text = dt.Rows[0].ItemArray.GetValue(0).ToString();
txt2.Text = dt.Rows[0].ItemArray.GetValue(1).ToString();
}
Ptxt3.Focus();
}
if (e.KeyCode == Keys.Down)
{
dataGridViewX1.Visible = true;
dataGridViewX1.Focus();
con.connection();
if (txt1.Text == "")
{
sql = "select code'کد مشتری',name+N' '+family'نام و نام خانوادگی' from moshtary";
}
else
{
sql = "select code'کد مشتری',name+N' '+family'نام و نام خانوادگی' from moshtary where (code LIKE N'" + txt1.Text + "%') AND (codemar = N'" + function.Code_markaz + "')";
}
dataGridViewX1.DataSource = con.show_data(sql);
con.Disconnect();
}
}
private void mtxt1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue == 27)
{
this.Close();
}
if (e.KeyValue == 13)
{
con.connection();
DataTable dt = con.show_data("select codemar'کد مرکز',name'نام مرکز' from markaz where code = N'" + mtxt1.Text + "' ");
con.Disconnect();
if (dt.Rows.Count == 0)
{
txt2.Text = "";
mtxt1.Text = "";
}
else
{
mtxt1.Text = dt.Rows[0].ItemArray.GetValue(0).ToString();
txt2.Text = dt.Rows[0].ItemArray.GetValue(1).ToString();
}
PDtxt3.Focus();
}
if (e.KeyCode == Keys.Down)
{
dataGridViewX1.Visible = true;
dataGridViewX1.Focus();
con.connection();
if (mtxt1.Text == "")
{
sql = "select codemar'کد مرکز',name'نام مرکز' from markaz";
}
else
{
sql = "select codemar'کد مرکز',name'نام مرکز' from markaz where (codemar LIKE N'" + mtxt1.Text + "'%)";
}
dataGridViewX1.DataSource = con.show_data(sql);
con.Disconnect();
}
}
private void btn0_Click(object sender, EventArgs e)
{
if (flag == 0)
{
mtxt1.Focus();
return;
}
if (flag == 1)
{
sql = "INSERT INTO ranande(coderan, name, family, phon, shmashin, shhesab, address)" +
"VALUES(N'" + mtxt1.Text + "', N'" + txt2.Text + "', N'" + txt3.Text + "', N'" + txt4.Text + "', N'" + txt5.Text + "', N'" + txt6.Text + "', N'" + txt7.Text + "')";
}
else if (flag == 2)
{
sql = "UPDATE ranande SET " +
"coderan = N'" + mtxt1.Text + "', name = N'" + txt2.Text + "', family = N'3', phon = N'4', shmashin = N'5', " +
"shhesab = N'6', address = N'7' WHERE (coderan = N'" + dataGridViewX1.CurrentRow.Cells[0].Value.ToString() + "')";
}
con.connection();
if (con.exe_data(sql))
{
FMessegeBox.FarsiMessegeBox.Show("اطلاعات با موفقیت ثبت شد");
}
else
{
FMessegeBox.FarsiMessegeBox.Show("مشکل در ذخیره اطلاعات", "اخطار", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error);
}
clear();
dataGridViewX1.DataSource = con.show_data("select * from ranande");
if (flag == 2)
{
key27();
}
else
{
mtxt1.Focus();
}
con.Disconnect();
}
private void mtxt1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue == 13)
{
con.connection();
DataTable dt = con.show_data("select * from markaz where (codemar = N'" + mtxt1.Text + "') ");
con.Disconnect();
if (dt.Rows.Count != 0)
{
txt2.Text = dt.Rows[0].ItemArray.GetValue(1).ToString();
flag = 2;
}
txt2.Focus();
}
if (e.KeyValue == 27)
{
groupPanel1.Enabled = groupPanel3.Enabled = true;
groupPanel2.Enabled = false;
btn1.Focus();
}
}
private void buttonX3_Click(object sender, EventArgs e)
{
if (flag == 0)
{
mtxt1.Focus();
return;
}
if (flag == 1)
{
sql = "INSERT INTO karkhane (codekar, name, phon, ghimat, address)" +
" VALUES (N'" + mtxt1.Text + "', N'" + txt2.Text + "', N'" + txt3.Text + "', N'" + txt4.Text + "', N'" + txt5.Text + "')";
}
else if (flag == 2)
{
sql = "UPDATE karkhane SET codekar = N'" + mtxt1.Text + "', name = N'" + txt2.Text + "', phon = N'" + txt3.Text + "', ghimat = N'" + txt4.Text + "', address = N'" + txt5.Text + "' " +
" WHERE (codekar = N'" + code + "')";
}
con.connection();
if (con.exe_data(sql))
{
dataGridViewX1.DataSource = con.show_data("select * from karkhane");
FMessegeBox.FarsiMessegeBox.Show("اطلاعات با موفقیت ثبت شد");
}
else
{
FMessegeBox.FarsiMessegeBox.Show("مشکل در ذخیره اطلاعات", "اخطار", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error);
}
clear();
if (flag == 2)
{
key27();
}
else
{
mtxt1.Focus();
}
con.Disconnect();
}
private void mtxt1_KeyDown(object sender, KeyEventArgs e)
{
switch (e.KeyValue)
{
case 27:
this.Close();
break;
case 13:
con.connection();
DataTable dt = con.show_data("select * from foroosheshir where (codemah = N'" + mtxt1.Text + "')");
con.Disconnect();
if (dt.Rows.Count != 0)
{
txt2.Text = dt.Rows[0].ItemArray.GetValue(1).ToString();
txt3.Text = dt.Rows[0].ItemArray.GetValue(2).ToString();
txt4.Text = dt.Rows[0].ItemArray.GetValue(3).ToString();
txt5.Text = dt.Rows[0].ItemArray.GetValue(4).ToString();
txt6.Text = dt.Rows[0].ItemArray.GetValue(5).ToString();
txt7.Text = dt.Rows[0].ItemArray.GetValue(6).ToString();
txt8.Text = dt.Rows[0].ItemArray.GetValue(7).ToString();
txt9.Text = dt.Rows[0].ItemArray.GetValue(8).ToString();
txt10.Text = dt.Rows[0].ItemArray.GetValue(9).ToString();
txt11.Text = dt.Rows[0].ItemArray.GetValue(10).ToString();
txt12.Text = dt.Rows[0].ItemArray.GetValue(11).ToString();
txt13.Text = dt.Rows[0].ItemArray.GetValue(12).ToString();
ptxt14.Value = FreeControls.PersianDate.Parsewh(dt.Rows[0].ItemArray.GetValue(13).ToString());
txt15.Text = dt.Rows[0].ItemArray.GetValue(14).ToString();
txt16.Text = dt.Rows[0].ItemArray.GetValue(15).ToString();
txt17.Text = dt.Rows[0].ItemArray.GetValue(16).ToString();
txt18.Text = dt.Rows[0].ItemArray.GetValue(17).ToString();
type = 2;
}
txt2.Focus();
break;
}
}
