private void grooh_Load(object sender, EventArgs e) { Languge_Keybord.Persian(); dataGridViewX1.DataSource = DataManagement.Search(sqlAllReshte); setData(); flag = true; }
private void dataGridViewX1_RowEnter(object sender, DataGridViewCellEventArgs e) { if (!flag) { return; } this.UseWaitCursor = true; clearData(); if (dataGridViewX1.RowCount != 0) { sqlAllPerson = "SELECT person.codeMeli AS کدملی, person.family + ' ' + person.name AS [نام و نام خانوادگی], [P&R].nomreA AS [نمره عملی], [P&R].nomreN AS [نمره نظری], " + " [P&R].dateSodoor AS [تاریخ صدور], [P&R].shGovahi AS [شماره گواهینامه] FROM [P&R] INNER JOIN person ON [P&R].PID = person.codeMeli WHERE ([P&R].Rname = N'" + dataGridViewX1.Rows[e.RowIndex].Cells[1].Value.ToString() + "') AND ([P&R].Ronvan = N'" + dataGridViewX1.Rows[e.RowIndex].Cells[2].Value.ToString() + "') ORDER BY [نام و نام خانوادگی]"; dataGridViewX2.DataSource = DataManagement.Search(sqlAllPerson); txtCode.Text = dataGridViewX1.Rows[e.RowIndex].Cells[0].Value.ToString(); txtNameMaharat.Text = dataGridViewX1.Rows[e.RowIndex].Cells[1].Value.ToString(); txtOnvan.Text = dataGridViewX1.Rows[e.RowIndex].Cells[2].Value.ToString(); txtModat.Value = int.Parse(dataGridViewX1.Rows[e.RowIndex].Cells[3].Value.ToString()); txtShoroo.Text = dataGridViewX1.Rows[e.RowIndex].Cells[4].Value.ToString(); txtAzmoon.Text = dataGridViewX1.Rows[e.RowIndex].Cells[5].Value.ToString(); if (dataGridViewX2.RowCount != 0) { txtNomreA.Text = dataGridViewX2.Rows[0].Cells[2].Value.ToString(); txtNomreN.Text = dataGridViewX2.Rows[0].Cells[3].Value.ToString(); txtSodoor.Text = dataGridViewX2.Rows[0].Cells[4].Value.ToString(); txtGovahi.Text = dataGridViewX2.Rows[0].Cells[5].Value.ToString(); } } btnSabt.Enabled = false; this.UseWaitCursor = false; }
private void setData() { clearData(); if (dataGridViewX1.RowCount != 0) { sqlAllPerson = "SELECT person.codeMeli[کدملی], person.family + ' ' + person.name[نام و نام خانوادگی], [P&R].nomreA[نمره عملی], [P&R].nomreN[نمره نظری], [P&R].dateSodoor[تاریخ صدور], [P&R].shGovahi[شماره گواهینامه] " + "FROM [P&R] INNER JOIN person ON [P&R].PID = person.codeMeli WHERE([P&R].Rname = N'" + dataGridViewX1.CurrentRow.Cells[1].Value.ToString() + "') AND ([P&R].Ronvan = N'" + dataGridViewX1.CurrentRow.Cells[2].Value.ToString() + "') ORDER BY [نام و نام خانوادگی]"; dataGridViewX2.DataSource = DataManagement.Search(sqlAllPerson); txtCode.Text = dataGridViewX1.CurrentRow.Cells[0].Value.ToString(); txtNameMaharat.Text = dataGridViewX1.CurrentRow.Cells[1].Value.ToString(); txtOnvan.Text = dataGridViewX1.CurrentRow.Cells[2].Value.ToString(); txtModat.Value = int.Parse(dataGridViewX1.CurrentRow.Cells[3].Value.ToString()); txtShoroo.Text = dataGridViewX1.CurrentRow.Cells[4].Value.ToString(); txtAzmoon.Text = dataGridViewX1.CurrentRow.Cells[5].Value.ToString(); if (dataGridViewX2.RowCount != 0) { txtNomreA.Text = dataGridViewX2.CurrentRow.Cells[2].Value.ToString(); txtNomreN.Text = dataGridViewX2.CurrentRow.Cells[3].Value.ToString(); txtSodoor.Text = dataGridViewX2.CurrentRow.Cells[4].Value.ToString(); txtGovahi.Text = dataGridViewX2.CurrentRow.Cells[5].Value.ToString(); } } }
private void comboBoxEx4_SelectedIndexChanged(object sender, EventArgs e) { if (combosal1.Text == "") { combomah1.Text = ""; combosal1.Focus(); } dataGridViewX1.DataSource = DataManagement.Search(sqlAll + " WHERE ([P&R].Rname = N'" + comboreshte1.SelectedItem.ToString() + "')AND([P&R].Ronvan = N'" + comboonvan1.Text + "')AND(person.sal=N'" + combosal1.Text + "')AND(person.mah=N'" + combomah1.Text + "') ORDER BY [نام و نام خانوادگی]"); }
private void textBoxX1_TextChanged(object sender, EventArgs e) { if (comboreshte2.Text == "") { return; } dataGridViewX2.DataSource = datatable = DataManagement.Search(sqlperson + " where([P&R].Rname = N'" + comboreshte2.Text + "') AND (person.codeMeli = N'" + textBoxX1.Text + "') "); }
private void buttonX1_Click(object sender, EventArgs e) { if (comboreshte2.Text == "" || dataGridViewX2.RowCount == 0) { return; } dataGridViewX2.DataSource = datatable = DataManagement.Search(sqlperson + " WHERE ([P&R].Rname = N'" + comboreshte2.Text + "')AND(person.codeMeli = N'" + textBoxX1.Text + "') ORDER BY name"); }
void setItemscomboBox() { dataGridViewX1.DataSource = DataManagement.Search(sqlAll); DataManagement.DT = DataManagement.Search("select distinct name from reshte"); for (int i = 0; i < DataManagement.DT.Rows.Count; i++) { comboreshte1.Items.Add(DataManagement.DT.Rows[i][0]); } }
private void buttonX1_Click(object sender, EventArgs e) { Hide(); NewPerson newp = new NewPerson(); DetectForm.F = 1; newp.ShowDialog(this); Show(); dataGridViewX1.DataSource = DataManagement.Search(sqlAll); }
private void frm_rptsabtenam_Load(object sender, EventArgs e) { dataGridViewX2.DataSource = datatable = DataManagement.Search(sqlperson); DataTable dd = DataManagement.Search("select name from reshte"); for (int i = 0; i < dd.Rows.Count; i++) { comboreshte2.Items.Add(dd.Rows[i][0].ToString()); } }
private void txtReshte_SelectedIndexChanged(object sender, EventArgs e) { DataManagement.DT = DataManagement.Search("select onvan from reshte where (name = N'" + txtReshte.Text + "')"); txtonvan.Items.Clear(); for (int i = 0; i < DataManagement.DT.Rows.Count; i++) { string tmp = DataManagement.DT.Rows[i][0].ToString(); txtonvan.Items.Add(tmp); } }
private void comboBoxEx1_SelectedIndexChanged(object sender, EventArgs e) { DataManagement.DT = DataManagement.Search("select distinct onvan from reshte where(name = N'" + comboreshte1.Text + "')"); comboonvan1.Items.Clear(); for (int i = 0; i < DataManagement.DT.Rows.Count; i++) { comboonvan1.Items.Add(DataManagement.DT.Rows[i][0].ToString()); } dataGridViewX1.DataSource = DataManagement.Search(sqlAll + " WHERE ([P&R].Rname = N'" + comboreshte1.SelectedItem.ToString() + "') ORDER BY [نام و نام خانوادگی]"); comboonvan1.Text = combosal1.Text = combomah1.Text = ""; }
private void NewPerson_Load(object sender, EventArgs e) { Languge_Keybord.Persian(); DataManagement.DT = DataManagement.Search("SELECT distinct name FROM reshte"); for (int i = 0; i < DataManagement.DT.Rows.Count; i++) { txtReshte.Items.Add(DataManagement.DT.Rows[i][0].ToString()); } Languge_Keybord.Persian(); txtMeli.Focus(); }
private void Form1_Load(object sender, EventArgs e) { Languge_Keybord.Persian(); buttonX3_Click_1(null, null); DataTable dt = DataManagement.Search("select usernamesms,passwordsms from setup"); txtUserName.Text = dt.Rows[0][0].ToString(); txtPass.Text = dt.Rows[0][1].ToString(); dataGridView2.DataSource = DataManagement.Search("select mah'ماه',sal'سال' from person"); }
private void buttonX2_Click(object sender, EventArgs e) { if (dataGridViewX1.RowCount == 0) { return; } NewPerson np = new NewPerson(); DetectForm.F = 2; np.loadEdit(dataGridViewX1, dataGridViewX1.CurrentRow.Index); np.ShowDialog(this); dataGridViewX1.DataSource = DataManagement.Search(sqlAll); }
private void setup_Load(object sender, EventArgs e) { DataTable dt = DataManagement.Search("select nazari, amali, usernamesms, passwordsms from setup"); if (dt.Rows.Count > 0) { txtNazari.Text = dt.Rows[0][0].ToString(); txtAmali.Text = dt.Rows[0][1].ToString(); txtUser.Text = dt.Rows[0][2].ToString(); txtPass.Text = dt.Rows[0][3].ToString(); buttonX1.Enabled = btnSabt.Enabled = false; } }
private void buttonX3_Click(object sender, EventArgs e) { if (dataGridViewX1.RowCount == 0) { return; } if (FMessegeBox.FarsiMessegeBox.Show("آیا برای حذف مطمئن هستید؟", "اخطار", FMessegeBox.FMessegeBoxButtons.YesNo) != DialogResult.Yes) { return; } DataManagement.I_U_D("select * from reshte", "DELETE FROM person WHERE (codeMeli = N'" + dataGridViewX1.CurrentRow.Cells[0].Value.ToString() + "')"); dataGridViewX1.DataSource = DataManagement.Search(sqlAll); }
private void textBoxX1_TextChanged(object sender, EventArgs e) { string sql = ""; if (textBoxX1.Text == "" && textBoxX2.Text == "" && textBoxX3.Text == "") { dataGridViewX1.DataSource = DataManagement.Search(sqlAll); } else { sql = sqlAll + " WHERE (codeMeli LIKE N'" + textBoxX1.Text + "%') AND (name LIKE N'" + textBoxX2.Text + "%') AND (family LIKE N'" + textBoxX3.Text + "%')"; dataGridViewX1.DataSource = DataManagement.Search(sql); } }
private void btnSabt_Click(object sender, EventArgs e) { if (dataGridViewX2.RowCount == 0) { btnSabt.Enabled = false; return; } this.UseWaitCursor = true; string sqlUpdate = "UPDATE [P&R] SET nomreA = N'" + txtNomreA.Text + "', nomreN = N'" + txtNomreN.Text + "', dateSodoor = N'" + txtSodoor.Text + "', shGovahi = N'" + txtGovahi.Text + "' WHERE (Rname = N'" + txtNameMaharat.Text + "') AND (PID = N'" + dataGridViewX2.CurrentRow.Cells[0].Value.ToString() + "') AND (Ronvan = N'" + txtOnvan.Text + "')"; DataManagement.I_U_D(sqlAllPerson, sqlUpdate); dataGridViewX2.DataSource = DataManagement.Search(sqlAllPerson); FMessegeBox.FarsiMessegeBox.Show("اطلاعات با موفقیت ثبت شد"); this.UseWaitCursor = false; }
private void textBoxX1_TextChanged(object sender, EventArgs e) { string sql = "", sqlAllPer = "SELECT person.codeMeli AS کدملی, person.family + ' ' + person.name AS [نام و نام خانوادگی], [P&R].nomreA AS [نمره عملی], [P&R].nomreN AS [نمره نظری], " + " [P&R].dateSodoor AS [تاریخ صدور], [P&R].shGovahi AS [شماره گواهینامه] FROM [P&R] INNER JOIN person ON [P&R].PID = person.codeMeli WHERE ([P&R].Rname = N'" + dataGridViewX1.Rows[dataGridViewX1.CurrentRow.Index].Cells[1].Value.ToString() + "') AND ([P&R].Ronvan = N'" + dataGridViewX1.Rows[dataGridViewX1.CurrentRow.Index].Cells[2].Value.ToString() + "') "; if (textBoxX1.Text == "" && textBoxX2.Text == "") { dataGridViewX2.DataSource = DataManagement.Search(sqlAllPer + "ORDER BY [نام و نام خانوادگی]"); } else { sql = sqlAllPer + " AND (codeMeli LIKE N'" + textBoxX1.Text + "%') AND (person.family + ' ' + person.name LIKE N'" + textBoxX2.Text + "%') "; dataGridViewX2.DataSource = DataManagement.Search(sql + " ORDER BY [نام و نام خانوادگی]"); } }
private void timer1_Tick(object sender, EventArgs e) { if (timer1.Interval >= 50) { DataManagement.Search("select name from reshte"); this.Hide(); flag = true; } if (flag) { new Main().Show(); timer1.Stop(); } timer1.Interval++; }
private void printPerson() { if (comboreshte2.Text == "" || dataGridViewX2.RowCount == 0) { return; } string sqlperson = "SELECT person.family + ' ' + person.name[name], person.father, person.tarikht[tavalod], " + " person.codeMeli[meli], person.shsh, person.sadere, [P&R].nomreN[nazari],[P&R].nomreA[amali], [P&R].shGovahi[govahiname] " + " FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID WHERE ([P&R].Rname = N'" + comboreshte2.Text + "')AND(person.codeMeli = N'" + textBoxX1.Text + "') ORDER BY name"; string sqlVariable = "SELECT reshte.code[codeEstandard], reshte.name[nameReshte], reshte.date[DateAzmoon], reshte.onvan[onvanReshte], reshte.dateShoroo[DateShoroo], [P&R].dateSodoor[DateSodoor] " + "FROM reshte INNER JOIN [P&R] ON reshte.code = [P&R].RID WHERE (reshte.name = N'" + comboreshte2.Text + "')"; string str = Application.StartupPath + "\\rep\\perrep.mrt"; DataManagement.DT = DataManagement.Search(sqlperson); try { Stimulsoft.Report.StiReport stikol = new Stimulsoft.Report.StiReport(); stikol.Load(str); stikol.RegData("person", DataManagement.DT); stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT; DataManagement.DT = DataManagement.Search(sqlVariable); DataManagement.DT.Columns.Add("number"); DataManagement.DT.Columns.Add("nameMarkaz"); DataManagement.DT.Columns.Add("nahiye"); DataManagement.DT.Columns.Add("sal"); DataManagement.DT.Columns.Add("nobat"); //DataManagement.DT.Rows[0]["number"] = dataGridViewX1.RowCount.ToString(); //DataManagement.DT.Rows[0]["nameMarkaz"] = txtNameMarkaz.Text; //DataManagement.DT.Rows[0]["nahiye"] = txtNahiye.Text; //DataManagement.DT.Rows[0]["sal"] = txtSal.Text; //DataManagement.DT.Rows[0]["nobat"] = txtNobat.Text; stikol.Load(str); stikol.RegData("variable", DataManagement.DT); stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT; stikol.Show(); } catch { FMessegeBox.FarsiMessegeBox.Show("مشکل در چاپ اطلاعات", "اخطار"); } }
private void btnDel_Click(object sender, EventArgs e) { if (dataGridViewX1.RowCount == 0) { return; } if (FMessegeBox.FarsiMessegeBox.Show("آیا برای حذف مطمئن هستید؟", "توجه", FMessegeBox.FMessegeBoxButtons.YesNo) != DialogResult.Yes) { return; } string sqldel = "DELETE FROM reshte WHERE (code = N'" + dataGridViewX1.CurrentRow.Cells[0].Value.ToString() + "')"; DataManagement.I_U_D(sqlAll, sqldel); sqldel = "DELETE FROM [P&R] WHERE (RID = N'" + dataGridViewX1.CurrentRow.Cells[0].Value.ToString() + "')"; DataManagement.I_U_D(sqlAll, sqldel); dataGridViewX1.DataSource = DataManagement.Search(sqlAll); }
public void loadEdit(DataGridView dgv, int index) { oldCode = txtMeli.Text = dgv.Rows[index].Cells[0].Value.ToString(); txtName.Text = dgv.Rows[index].Cells[1].Value.ToString(); txtFamily.Text = dgv.Rows[index].Cells[2].Value.ToString(); txtFather.Text = dgv.Rows[index].Cells[3].Value.ToString(); txtShsh.Text = dgv.Rows[index].Cells[4].Value.ToString(); txtTavalod.Text = dgv.Rows[index].Cells[5].Value.ToString(); txtSadere.Text = dgv.Rows[index].Cells[6].Value.ToString(); txtMtavalod.Text = dgv.Rows[index].Cells[7].Value.ToString(); txtmobile.Text = dgv.Rows[index].Cells[8].Value.ToString(); txtsal.Text = dgv.Rows[index].Cells[9].Value.ToString(); txtmah.Text = dgv.Rows[index].Cells[10].Value.ToString(); DataManagement.DT = DataManagement.Search("select Rname,Ronvan from [P&R] where (PID = N'" + txtMeli.Text + "')"); for (int i = 0; i < DataManagement.DT.Rows.Count; i++) { listReshte.Rows.Add(DataManagement.DT.Rows[i][0].ToString(), DataManagement.DT.Rows[i][1].ToString()); } }
private void dataGridViewX1_RowEnter(object sender, DataGridViewCellEventArgs e) { try { string sqls = "SELECT modat, date, onvan, name FROM reshte WHERE (onvan = N'" + dataGridViewX1.Rows[e.RowIndex].Cells[11].Value.ToString() + "') AND (name = N'" + dataGridViewX1.Rows[e.RowIndex].Cells[12].Value.ToString() + "')"; DataTable dts = DataManagement.Search(sqls); if (dts.Rows.Count > 0) { txtAzmoon.Text = dts.Rows[0]["date"].ToString(); txtModat.Text = dts.Rows[0]["modat"].ToString(); txtOnvan.Text = dts.Rows[0]["onvan"].ToString(); } } catch (Exception eX) { FMessegeBox.FarsiMessegeBox.Show("عنوان رشته یا نام رشته برای این شخص ثبت نشده است\nبعد از بروزرسانی اطلاعات مجددا سعی کنید"); } }
private void btnfaragir_Click(object sender, EventArgs e) { string sqlselectperson = "SELECT codeMeli, name, family, father, shsh, tarikht, sadere, mtavalod, sal, mah, mobile " + " FROM person WHERE(codeMeli = N'" + dataGridViewX2.CurrentRow.Cells[3].Value.ToString() + "')"; string sqlselectreshte = "SELECT name, onvan, vamali, vnazari FROM reshte WHERE (name = N'" + comboreshte2.Text + "')"; string sqlRP = "SELECT [P&R].PID, reshte.name, reshte.onvan, reshte.vamali, reshte.vnazari " + " FROM [P&R] INNER JOIN reshte ON [P&R].RID = reshte.code " + " WHERE([P&R].PID = N'" + dataGridViewX2.CurrentRow.Cells[3].Value.ToString() + "') AND (reshte.name = N'" + comboreshte2.Text + "')"; try { string str = Application.StartupPath + "\\rep\\Sabtnam.mrt"; Stimulsoft.Report.StiReport stikol = new Stimulsoft.Report.StiReport(); Stimulsoft.Report.StiReport stitmp = new Stimulsoft.Report.StiReport(); stitmp.Load(str); //DataSet ds = new DataSet(); DataTable dt1 = DataManagement.Search(sqlselectperson); //ds.Tables.Add(dt1); DataTable dt2 = DataManagement.Search(sqlRP); //ds.Tables.Add(dt2); //ds.Tables[0].TableName = "khate1"; //ds.Tables[1].TableName = "variable1"; stitmp.RegData("khate1", dt1); stitmp.RegData("variable1", dt2); //stikol.Report = stitmp; stikol.Show(this); //stikol.Dictionary.DataSources.Items[0].Dictionary.DataSources = ds; //stikol.RegData("variable1", dtPerson); //stikol.Dictionary.DataSources.Items[1].DataTable = dtPerson; } catch (Exception ex) { FMessegeBox.FarsiMessegeBox.Show(ex.Message); } }
private void comboBoxEx2_SelectedIndexChanged(object sender, EventArgs e) { if (comboreshte1.Text == "") { comboonvan1.Text = ""; comboreshte1.Focus(); } DataManagement.DT = DataManagement.Search("SELECT code, name, modat, date, onvan, dateShoroo FROM reshte where (name = N'" + comboreshte1.SelectedItem.ToString() + "')AND(onvan = N'" + comboonvan1.Text + "')"); if (DataManagement.DT.Rows.Count == 0) { return; } txtCode.Text = DataManagement.DT.Rows[0]["code"].ToString(); txtAzmoon.Text = DataManagement.DT.Rows[0]["date"].ToString(); txtNameMaharat.Text = DataManagement.DT.Rows[0]["name"].ToString(); txtModat.Text = DataManagement.DT.Rows[0]["modat"].ToString(); txtNameMarkaz.Text = "آموزشگاه آزاد هنری معرق روشن"; txtNum.Text = DataManagement.DT.Rows.Count.ToString(); txtOnvan.Text = DataManagement.DT.Rows[0]["onvan"].ToString(); txtshoroo.Text = DataManagement.DT.Rows[0]["dateShoroo"].ToString(); dataGridViewX1.DataSource = DataManagement.Search(sqlAll + " WHERE ([P&R].Rname = N'" + comboreshte1.SelectedItem.ToString() + "')AND([P&R].Ronvan = N'" + comboonvan1.Text + "') ORDER BY [نام و نام خانوادگی]"); combosal1.Text = combomah1.Text = ""; }
private void btnSabt_Click(object sender, EventArgs e) { string sqlIU = "", sqlUtmp = ""; if (DetectForm.F == 1) { sqlIU = "INSERT INTO reshte (code, name, onvan ,modat, dateShoroo, date, vamali, vnazari) VALUES(N'" + txtCode.Text + "', N'" + txtName.Text + "',N'" + txtonvan.Text + "', N'" + txtmodat.Value.ToString() + "', N'" + txtShoro.Text + "',N'" + txtDate.Text + "',N'" + txtamali.Text + "',N'" + txtnazari.Text + "')"; } else { sqlUtmp = "UPDATE [P&R] SET Rname = N'" + txtName.Text + "' WHERE (Rname = N'" + dataGridViewX1.CurrentRow.Cells[1].Value.ToString() + "')"; DataManagement.I_U_D(sqlAll, sqlUtmp); sqlIU = "UPDATE reshte SET code = N'" + txtCode.Text + "', name = N'" + txtName.Text + "', onvan = N'" + txtonvan.Text + "',modat = N'" + txtmodat.Value.ToString() + "', dateShoroo = N'" + txtShoro.Text + "',date = N'" + txtDate.Text + "',vamali = N'" + txtamali.Text + "',vnazari = N'" + txtnazari.Text + "' where (code = N'" + DetectForm.Cod + "')"; } DataManagement.I_U_D(sqlAll, sqlIU); dataGridViewX1.DataSource = DataManagement.Search(sqlAll); btnCancel_Click(null, null); }
private void persons_Load(object sender, EventArgs e) { Languge_Keybord.Persian(); dataGridViewX1.DataSource = DataManagement.Search(sqlAll); }
private void printGovahi(string type) { string CodeMeli = "", NameReshte = ""; string sqlGovahi = ""; string str = Application.StartupPath + "\\rep\\govarpt.mrt"; Stimulsoft.Report.StiReport stikol = new Stimulsoft.Report.StiReport(); try { stikol.Load(str); } catch (Exception ex) { FMessegeBox.FarsiMessegeBox.Show(ex.Message); } if (type == "one") { CodeMeli = dataGridViewX1.CurrentRow.Cells[0].Value.ToString(); NameReshte = comboreshte1.Text; sqlGovahi = "SELECT person.codeMeli AS meli, person.name + ' ' + person.family AS name, person.father, person.shsh, person.tarikht AS tavalod, person.sadere, [P&R].nomreA, " + "[P&R].nomreN, [P&R].dateSodoor AS sodoor, [P&R].shGovahi AS govahi, person.mtavalod AS shahr, [P&R].RID AS codeStandard FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID " + "WHERE (person.codeMeli = N'" + CodeMeli + "') AND ([P&R].Rname = N'" + dataGridViewX1.CurrentRow.Cells[12].Value.ToString() + "')AND([P&R].Ronvan = N'" + dataGridViewX1.CurrentRow.Cells[11].Value.ToString() + "')"; //sqlGovahi = "SELECT person.codeMeli[meli], person.name + ' ' + person.family[name], person.father, person.shsh, person.tarikht[tavalod], person.sadere, [P&R].nomreA, " + // "[P&R].nomreN, [P&R].dateSodoor[sodoor], [P&R].shGovahi[govahi], reshte.onvan, reshte.date[azmon], reshte.modat, reshte.code[codeStandard], person.mtavalod[shahr] " + // "FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID INNER JOIN reshte ON [P&R].RID = reshte.code " + // "WHERE (person.codeMeli = N'" + CodeMeli + "') AND ([P&R].Rname = N'" + comboBoxEx1.SelectedItem.ToString() + // "')AND([P&R].Ronvan = N'" + comboBoxEx2.Text + "')"; DataManagement.DT = DataManagement.Search(sqlGovahi); try { stikol.RegData("variable", DataManagement.DT); DataManagement.DT.Columns.Add("mahal"); DataManagement.DT.Columns.Add("onvan"); DataManagement.DT.Columns.Add("azmon"); DataManagement.DT.Columns.Add("modat"); DataManagement.DT.Rows[0]["mahal"] = txtNameMarkaz.Text; DataManagement.DT.Rows[0]["onvan"] = txtOnvan.Text; DataManagement.DT.Rows[0]["azmon"] = txtAzmoon.Text; DataManagement.DT.Rows[0]["modat"] = txtModat.Text; stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT; stikol.Show(this); } catch (Exception ex) { FMessegeBox.FarsiMessegeBox.Show(ex.Message, "اخطار"); } }/* * else * { * NameReshte = comboBoxEx1.Text; * * for (int i = 0; i< dataGridViewX1.RowCount; i++) * { * CodeMeli = dataGridViewX1.Rows[i].Cells[0].Value.ToString(); * sqlGovahi = "SELECT person.codeMeli[meli], person.name + ' ' + person.family[name], person.father, person.shsh, person.tarikht[tavalod], person.sadere, [P&R].nomreA, " + * "[P&R].nomreN, [P&R].dateSodoor[sodoor], [P&R].shGovahi[govahi], reshte.onvan, reshte.date[azmon], reshte.modat, reshte.code[codeStandard], person.mtavalod[shahr] " + * "FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID INNER JOIN reshte ON [P&R].RID = reshte.code " + * "WHERE (person.codeMeli = N'" + CodeMeli + "') AND (reshte.name = N'" + NameReshte + "')"; * * DataManagement.DT = DataManagement.Search(sqlGovahi); * try * { * * DataManagement.DT.Columns.Add("mahal"); * DataManagement.DT.Columns.Add("onvan"); * DataManagement.DT.Columns.Add("azmon"); * DataManagement.DT.Columns.Add("modat"); * DataManagement.DT.Rows[0]["mahal"] = txtNameMarkaz.Text; * DataManagement.DT.Rows[0]["onvan"] = txtOnvan.Text; * DataManagement.DT.Rows[0]["azmon"] = txtAzmoon.Text; * DataManagement.DT.Rows[0]["modat"] = txtModat.Text; * * stikol.RegData("variable", DataManagement.DT); * stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT; * * stikol.Print(); * } * catch(Exception ex) * { * FMessegeBox.FarsiMessegeBox.Show(ex.Message, "اخطار"); * break; * } * } * }*/ }
private void printPerson() { if (comboreshte1.Text == "" || dataGridViewX1.RowCount == 0 || comboonvan1.Text == "") { return; } string sqlperson = "SELECT person.family + ' ' + person.name[name], person.father, person.tarikht[tavalod], " + " person.codeMeli[meli], person.shsh, person.sadere, [P&R].nomreN[nazari],[P&R].nomreA[amali], [P&R].shGovahi[govahiname] " + " FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID WHERE ([P&R].Rname = N'" + comboreshte1.Text + "'){0}{1}{2} ORDER BY name"; string.Format(sqlperson, (comboonvan1.Text == "" ? "" : "AND([P&R].Ronvan = N'" + comboreshte1.Text + "')"), (combosal1.Text == "" ? "" : "AND(person.sal = N'" + combosal1.Text + "')") , (combomah1.Text == "" ? "" : "AND(person.mah = N'" + combomah1.Text + "')")); string sqlVariable = "SELECT reshte.code[codeEstandard], reshte.name[nameReshte], reshte.date[DateAzmoon], reshte.onvan[onvanReshte], reshte.dateShoroo[DateShoroo], [P&R].dateSodoor[DateSodoor] " + "FROM reshte INNER JOIN [P&R] ON reshte.code = [P&R].RID WHERE (reshte.name = N'" + comboreshte1.Text + "')AND(reshte.onvan = N'" + comboonvan1.Text + "')"; string str = Application.StartupPath + "\\rep\\perrep.mrt"; DataManagement.DT = DataManagement.Search(sqlperson); try { for (int i = 0; i < DataManagement.DT.Rows.Count; i++) { bool x = false; int j = 0; for (; j < dataGridViewX1.SelectedRows.Count; j++) { if (dataGridViewX1.SelectedRows[j].Cells[0].Value.ToString() == DataManagement.DT.Rows[i][0].ToString()) { x = true; break; } } if (x) { continue; } DataManagement.DT.Rows.RemoveAt(i); i--; } Stimulsoft.Report.StiReport stikol = new Stimulsoft.Report.StiReport(); stikol.Load(str); stikol.RegData("person", DataManagement.DT); stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT; DataManagement.DT = DataManagement.Search(sqlVariable); DataManagement.DT.Columns.Add("number"); DataManagement.DT.Columns.Add("nameMarkaz"); DataManagement.DT.Columns.Add("nahiye"); DataManagement.DT.Columns.Add("sal"); DataManagement.DT.Columns.Add("nobat"); DataManagement.DT.Rows[0]["number"] = dataGridViewX1.RowCount.ToString(); DataManagement.DT.Rows[0]["nameMarkaz"] = txtNameMarkaz.Text; DataManagement.DT.Rows[0]["nahiye"] = txtNahiye.Text; DataManagement.DT.Rows[0]["sal"] = txtSal.Text; DataManagement.DT.Rows[0]["nobat"] = txtNobat.Text; stikol.Load(str); stikol.RegData("variable", DataManagement.DT); stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT; stikol.Show(); } catch { FMessegeBox.FarsiMessegeBox.Show("مشکل در چاپ اطلاعات", "اخطار"); } }