private void Form26_Load(object sender, EventArgs e)
{
DB_Base database = new DB_Base();
database.Connection_Open();
database.Fill("SELECT * FROM [PKH] WHERE (no1 = 1)", objDataSet, "PKH1_1", true);
database.Connection_Close();
if (objDataSet.Tables["PKH1_1"].Rows[0]["no2"].ToString() == "1")
{
radioButton1.Checked = true;
}
else if (objDataSet.Tables["PKH1_1"].Rows[0]["no2"].ToString() == "2")
{
radioButton2.Checked = true;
}
else if (objDataSet.Tables["PKH1_1"].Rows[0]["no2"].ToString() == "3")
{
radioButton3.Checked = true;
}
else if (objDataSet.Tables["PKH1_1"].Rows[0]["no2"].ToString() == "4")
{
radioButton4.Checked = true;
}
textBox1.Text = objDataSet.Tables["PKH1_1"].Rows[0]["q1"].ToString();
maskedTextBox1.Text = objDataSet.Tables["PKH1_1"].Rows[0]["q2"].ToString();
textBox2.Text = objDataSet.Tables["PKH1_1"].Rows[0]["q3"].ToString();
textBox3.Text = objDataSet.Tables["PKH1_1"].Rows[0]["q4"].ToString();
textBox4.Text = objDataSet.Tables["PKH1_1"].Rows[0]["q5"].ToString();
textBox5.Text = objDataSet.Tables["PKH1_1"].Rows[0]["q5"].ToString();
database.Connection_Open();
database.Fill("SELECT * FROM [PKH] WHERE (no1 = 2)", objDataSet, "PKH1_2", true);
database.Connection_Close();
if (objDataSet.Tables["PKH1_2"].Rows[0]["no2"].ToString() == "1")
{
radioButton5.Checked = true;
}
else if (objDataSet.Tables["PKH1_2"].Rows[0]["no2"].ToString() == "2")
{
radioButton6.Checked = true;
}
else if (objDataSet.Tables["PKH1_2"].Rows[0]["no2"].ToString() == "3")
{
radioButton7.Checked = true;
}
else if (objDataSet.Tables["PKH1_2"].Rows[0]["no2"].ToString() == "4")
{
radioButton8.Checked = true;
}
textBox6.Text = objDataSet.Tables["PKH1_2"].Rows[0]["q1"].ToString();
maskedTextBox2.Text = objDataSet.Tables["PKH1_2"].Rows[0]["q2"].ToString();
textBox7.Text = objDataSet.Tables["PKH1_2"].Rows[0]["q3"].ToString();
textBox8.Text = objDataSet.Tables["PKH1_2"].Rows[0]["q4"].ToString();
textBox9.Text = objDataSet.Tables["PKH1_2"].Rows[0]["q5"].ToString();
textBox10.Text = objDataSet.Tables["PKH1_2"].Rows[0]["q5"].ToString();
}
private void call_comboBox3_SelectedIndexChanged()
{
if (comboBox3.Items.Count > 0)
{
if (comboBox3.SelectedValue != null)
{
if (comboBox3.SelectedValue.ToString() != "System.Data.DataRowView")
{
DataBase1.Connection_Open();
DataBase1.Fill("SELECT DISTINCT moh_sal FROM tbl_month WHERE (idgroup=" + comboBox3.SelectedValue.ToString() + ") ORDER BY moh_sal ASC ", objDataSet, "tbl_month1", true);
DataBase1.Connection_Close();
comboBox2.Items.Clear();
if (objDataSet.Tables["tbl_month1"].Rows.Count > 0)
{
for (int q = 0; q <= objDataSet.Tables["tbl_month1"].Rows.Count - 1; q++)
{
comboBox2.Items.Add(objDataSet.Tables["tbl_month1"].Rows[q]["moh_sal"].ToString());
}
}
objDataSet.Tables["tbl_month1"].Clear();
}
}
}
}
private void Form28_Load(object sender, EventArgs e)
{
database.Connection_Open();
database.Fill("SELECT * FROM Excel_read_karkard", objDataSet, "Excel_read_karkard", true);
database.Connection_Close();
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = objDataSet;
dataGridView1.DataMember = "Excel_read_karkard";
DataGridViewCellStyle objAlignRightCellStyle = new DataGridViewCellStyle();
objAlignRightCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
DataGridViewCellStyle objAlternatingCellStyle = new DataGridViewCellStyle();
objAlternatingCellStyle.BackColor = Color.WhiteSmoke;
dataGridView1.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle;
DataGridViewCellStyle objCurrencyCellStyle = new DataGridViewCellStyle();
objCurrencyCellStyle.Format = "c";
objCurrencyCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "نام فیلد";
dataGridView1.Columns[2].HeaderText = "نام ستون کادر بالا";
objCurrencyCellStyle = null;
objAlternatingCellStyle = null;
objAlignRightCellStyle = null;
}
private void Form21_Load(object sender, EventArgs e)
{
maskedTextBox5.Text = U_set.u_date();
database.Connection_Open();
database.Fill("SELECT * FROM Tbl_login WHERE (tmpid= 0)", objDataSet, "View_Process_2", true);
database.Connection_Close();
database.Connection_Open();
database.Fill("SELECT * FROM Tbl_login WHERE (tmpid= 0)", objDataSet, "View1_Process_2", true);
database.Connection_Close();
}
public void Form_Load_set_color()
{
DataSet objDataSet1 = new DataSet();
Database.Connection_Open();
Database.Fill("SELECT * FROM Color_Font_Set ORDER BY tmpid", objDataSet1, "Color_Font_Set", true);
Database.Connection_Close();
TypeConverter tc0 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor0 = (Color)tc0.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[6]["promp"].ToString());
foreach (SplitContainer spc in this.Controls)
{
foreach (Control ct in spc.Panel2.Controls)
{
if (ct.GetType() == typeof(Button))
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Font));
Font newFont = (Font)tc.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[13]["promp"].ToString());
ct.Font = newFont;
TypeConverter tc1 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor = (Color)tc1.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[14]["promp"].ToString());
ct.ForeColor = newColor;
}
}
}
this.BackColor = newColor0;
objDataSet1.Clear();
}
private void ShowLoan_payment()
{
database.Connection_Open();
database.Fill("SELECT * FROM tbl_loan_payment WHERE (loan_code = " + loan_code + ")", loan_peymentDataSet, "tbl_loan_payment", true);
database.Connection_Close();
dgvLoan_payment.DataSource = loan_peymentDataSet;
dgvLoan_payment.DataMember = "tbl_loan_payment";
dgvLoan_payment.AutoGenerateColumns = true;
dgvLoan_payment.Columns[0].Visible = false;
dgvLoan_payment.Columns[1].HeaderText = "کد وام";
dgvLoan_payment.Columns[2].HeaderText = "تاریخ قسط";
dgvLoan_payment.Columns[3].HeaderText = "مبلغ";
dgvLoan_payment.Columns[4].HeaderText = "وضعیت پرداخت";
}
private void call_comboBox3_SelectedIndexChanged()
{
if (comboBox3.Items.Count > 0)
{
if (comboBox3.SelectedValue.ToString() != "System.Data.DataRowView")
{
DataBase1.Connection_Open();
DataBase1.Fill("SELECT DISTINCT moh_sal FROM tbl_month WHERE (idgroup=" + comboBox3.SelectedValue.ToString() + ") ORDER BY moh_sal ASC ", objDataSet, "tbl_month", true);
DataBase1.Connection_Close();
comboBox2.Items.Clear();
if (objDataSet.Tables["tbl_month"].Rows.Count > 0)
{
for (int q = 0; q <= objDataSet.Tables["tbl_month"].Rows.Count - 1; q++)
{
comboBox2.Items.Add(objDataSet.Tables["tbl_month"].Rows[q]["moh_sal"].ToString());
}
}
else
{
روشهایمحاسبهToolStripMenuItem.Visible = false;
اطلاعاتپرسنلToolStripMenuItem.Visible = false;
پرداختکنندهحقوقToolStripMenuItem.Visible = false;
ورودکارکردازاکسلToolStripMenuItem1.Visible = false;
}
objDataSet.Tables["tbl_month"].Clear();
}
}
}
private void ShowLoan()
{
database.Connection_Open();
database.Fill("SELECT * FROM tbl_loan WHERE (receiver = " + id_idmen + ")", LoanDataSet, "tbl_loan", true);
database.Connection_Close();
dgvLoan.DataSource = LoanDataSet;
dgvLoan.DataMember = "tbl_loan";
dgvLoan.AutoGenerateColumns = true;
dgvLoan.Columns[0].Visible = false;
dgvLoan.Columns[1].HeaderText = "کد وام";
dgvLoan.Columns[2].HeaderText = "مبلغ وام";
dgvLoan.Columns[3].HeaderText = "تاریخ پرداخت وام";
dgvLoan.Columns[4].Visible = false;
dgvLoan.Columns[5].HeaderText = "تسویه";
}
private void Form1_Load(object sender, EventArgs e)
{
int amin2 = DataBase.Look_base();
if (amin2 != 0)
{
MessageBox.Show("عدم شناسایی قفل " + amin2.ToString(), "", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
}
DataBase.Connection_Open();
DataBase.Fill("SELECT tmpid ,(log_Name + ' ' + log_Family) as myname FROM Tbl_login", objDataSet, "Tbl_login", true);
DataBase.Connection_Close();
comboBox1.DataSource = objDataSet.Tables["Tbl_login"];
comboBox1.DisplayMember = "myname";
comboBox1.ValueMember = "tmpid";
}
public string u_date()
{
Database.Connection_Open();
Database.Fill("SELECT GETDATE() AS Expr1, DATEPART(HOUR, GETDATE()) AS Expr2, DATEPART(MINUTE, GETDATE()) AS Expr3, DATEPART(SECOND, GETDATE()) AS Expr4", objDataSet, "Server_Date1", true);
Database.Connection_Close();
int y, m, d;
PersianCalendar pr = new PersianCalendar();
string amin = objDataSet.Tables["Server_Date1"].Rows[0]["Expr1"].ToString();
d = pr.GetDayOfMonth(Convert.ToDateTime(amin));
m = pr.GetMonth(Convert.ToDateTime(amin));
y = pr.GetYear(Convert.ToDateTime(amin));
string date;
date = y.ToString().PadLeft(2, '0') + "/" + m.ToString().PadLeft(2, '0') + "/" + d.ToString().PadLeft(2, '0');
return(date);
}
public void Bind_Data1(string Qry, string DisplayMember, string ValueMember)
{
DB_Base DataBase = new DB_Base();
DataBase.Connection_Open();
DataBase.Fill(Qry, objDataSet, "MyTble", true);
DataBase.Connection_Close();
this.DataSource = objDataSet.Tables["MyTble"];
this.DisplayMember = DisplayMember;
this.ValueMember = ValueMember;
}
private void Color_Font_Set_Load(object sender, EventArgs e)
{
database.Connection_Open();
database.Fill("SELECT * FROM Color_Font_Set", objDataSet, "Color_Font_Set", true);
database.Connection_Close();
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = objDataSet;
dataGridView1.DataMember = "Color_Font_Set";
DataGridViewCellStyle objAlignRightCellStyle = new DataGridViewCellStyle();
objAlignRightCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
DataGridViewCellStyle objAlternatingCellStyle = new DataGridViewCellStyle();
objAlternatingCellStyle.BackColor = Color.WhiteSmoke;
dataGridView1.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle;
DataGridViewCellStyle objCurrencyCellStyle = new DataGridViewCellStyle();
objCurrencyCellStyle.Format = "c";
objCurrencyCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGridView1.Columns[1].Visible = false;
dataGridView1.Columns[2].HeaderText = "شرح";
dataGridView1.Columns[2].Width = 250;
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[4].Visible = false;
objCurrencyCellStyle = null;
objAlternatingCellStyle = null;
objAlignRightCellStyle = null;
for (int q = 0; q <= dataGridView1.RowCount - 1; q++)
{
if (dataGridView1.Rows[q].Cells["noe"].FormattedValue.ToString() == "1")
{
TypeConverter tc2 = TypeDescriptor.GetConverter(typeof(Font));
Font newFont2 = (Font)tc2.ConvertFromString(dataGridView1.Rows[q].Cells["promp"].FormattedValue.ToString());
dataGridView1.Rows[q].Cells["name"].Style.Font = newFont2;
}
if (dataGridView1.Rows[q].Cells["noe"].FormattedValue.ToString() == "2")
{
TypeConverter tc3 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor3 = (Color)tc3.ConvertFromString(dataGridView1.Rows[q].Cells["promp"].FormattedValue.ToString());
dataGridView1.Rows[q].Cells["name"].Style.BackColor = newColor3;
}
}
}
private void Form31_Load(object sender, EventArgs e)
{
noe_style(style);
Database.Connection_Open();
Database.Fill("SELECT tmpid, name_makaz FROM Tbl_markaz", objDataSet, "Tbl_markaz", true);
Database.Connection_Close();
comboBox1.DataSource = objDataSet.Tables["Tbl_markaz"];
comboBox1.DisplayMember = "name_makaz";
comboBox1.ValueMember = "tmpid";
}
private void combo_bank_1_sabzkosh()
{
string file_name = Application.StartupPath.ToString() + @"\Bank\" + id_year.ToString() + id_moon.ToString().PadLeft(2, '0');
if (Directory.Exists(file_name) == false)
{
Directory.CreateDirectory(file_name);
}
open_file_name = file_name;
file_name += @"\" + "FL" + id_year.ToString() + id_moon.ToString().PadLeft(2, '0') + ".TXT";
Database.Connection_Open();
Database.Fill("SELECT Count(tbl_personel.tmpid) AS rsnumber ,SUM(Khales) AS rssum FROM Tbl_process INNER JOIN tbl_personel ON Tbl_process.idgroup = tbl_personel.idgroup AND Tbl_process.idyear = tbl_personel.idyear AND Tbl_process.idmoon = tbl_personel.idmoon AND Tbl_process.idpersonal = tbl_personel.tmpid AND Tbl_process.type1 = 1 AND tbl_personel.list2 = 1 WHERE (Tbl_process.idgroup=" + id_group + ") AND (Tbl_process.idyear=" + id_year + ") AND (Tbl_process.idmoon=" + id_moon + ")", objDataSet, "Tbl_process1", true);
Database.Connection_Close();
Database.Connection_Open();
Database.Fill("SELECT sh_hesab ,Khales FROM Tbl_process INNER JOIN tbl_personel ON Tbl_process.idgroup = tbl_personel.idgroup AND Tbl_process.idyear = tbl_personel.idyear AND Tbl_process.idmoon = tbl_personel.idmoon AND Tbl_process.idpersonal = tbl_personel.tmpid AND Tbl_process.type1 = 1 AND tbl_personel.list2 = 1 WHERE (Tbl_process.idgroup=" + id_group + ") AND (Tbl_process.idyear=" + id_year + ") AND (Tbl_process.idmoon=" + id_moon + ")", objDataSet, "Tbl_process2", true);
Database.Connection_Close();
string[] installs = new string[(objDataSet.Tables["Tbl_process2"].Rows.Count + 1)];
installs[0] = objDataSet.Tables["Tbl_process1"].Rows[0]["rsnumber"].ToString().PadLeft(10, '0');
installs[0] += "0000000";
installs[0] += Math.Round(Convert.ToDecimal(objDataSet.Tables["Tbl_process1"].Rows[0]["rssum"].ToString())).ToString();
for (int q = 1; q <= objDataSet.Tables["Tbl_process2"].Rows.Count; q++)
{
installs[q] = objDataSet.Tables["Tbl_process2"].Rows[q - 1]["sh_hesab"].ToString();
installs[q] += "0000000";
installs[q] += Math.Round(Convert.ToDecimal(objDataSet.Tables["Tbl_process2"].Rows[q - 1]["Khales"].ToString())).ToString();
}
System.IO.File.WriteAllLines(file_name, installs, Encoding.ASCII);
objDataSet.Clear();
}
public void Form_Load_set_color()
{
Database.Connection_Open();
Database.Fill("SELECT * FROM Color_Font_Set ORDER BY tmpid", objDataSet, "Color_Font_Set", true);
Database.Connection_Close();
TypeConverter tc0 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor0 = (Color)tc0.ConvertFromString(objDataSet.Tables["Color_Font_Set"].Rows[6]["promp"].ToString());
foreach (Control ct in this.Controls)
{
if (ct.GetType() == typeof(GroupBox))
{
foreach (Control Gt1 in ct.Controls)
{
if (Gt1.GetType() == typeof(Label))
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Font));
Font newFont = (Font)tc.ConvertFromString(objDataSet.Tables["Color_Font_Set"].Rows[0]["promp"].ToString());
Gt1.Font = newFont;
TypeConverter tc1 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor = (Color)tc1.ConvertFromString(objDataSet.Tables["Color_Font_Set"].Rows[1]["promp"].ToString());
Gt1.ForeColor = newColor;
}
if ((Gt1.GetType() == typeof(TextBox)) || (Gt1.GetType() == typeof(ComboBox)) || (Gt1.GetType() == typeof(Db_Combo)) || (Gt1.GetType() == typeof(MaskedTextBox)))
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Font));
Font newFont = (Font)tc.ConvertFromString(objDataSet.Tables["Color_Font_Set"].Rows[4]["promp"].ToString());
Gt1.Font = newFont;
TypeConverter tc1 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor = (Color)tc1.ConvertFromString(objDataSet.Tables["Color_Font_Set"].Rows[5]["promp"].ToString());
Gt1.ForeColor = newColor;
}
if (Gt1.GetType() == typeof(Button))
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Font));
Font newFont = (Font)tc.ConvertFromString(objDataSet.Tables["Color_Font_Set"].Rows[13]["promp"].ToString());
Gt1.Font = newFont;
TypeConverter tc1 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor = (Color)tc1.ConvertFromString(objDataSet.Tables["Color_Font_Set"].Rows[14]["promp"].ToString());
Gt1.ForeColor = newColor;
}
}
}
if (ct.GetType() == typeof(Button))
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Font));
Font newFont = (Font)tc.ConvertFromString(objDataSet.Tables["Color_Font_Set"].Rows[13]["promp"].ToString());
ct.Font = newFont;
TypeConverter tc1 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor = (Color)tc1.ConvertFromString(objDataSet.Tables["Color_Font_Set"].Rows[14]["promp"].ToString());
ct.ForeColor = newColor;
}
}
this.BackColor = newColor0;
objDataSet.Clear();
}
private void btnSave_Click(object sender, EventArgs e)
{
string file_name;
saveFileDialog.DefaultExt = "txt";
saveFileDialog.Filter = "Text Format (*.txt) |*.txt";
saveFileDialog.FilterIndex = 1;
saveFileDialog.OverwritePrompt = true;
saveFileDialog.Title = "ذخیره فایل";
database.Connection_Open();
database.Fill("SELECT * FROM Tbl_process INNER JOIN tbl_personel ON Tbl_process.idgroup = tbl_personel.idgroup AND Tbl_process.idyear = tbl_personel.idyear AND Tbl_process.idmoon = tbl_personel.idmoon AND Tbl_process.idpersonal = tbl_personel.tmpid AND Tbl_process.type1 = 2", objDataSet, "Tbl_process", true);
database.Connection_Close();
database.Connection_Open();
database.Fill("SELECT * FROM Tab_Shrkat WHERE (tmpid=" + id_group + ")", objDataSet, "Tab_Shrkat", true);
database.Connection_Close();
string[] installs = new string[(objDataSet.Tables["Tbl_process"].Rows.Count + 1)];
installs[0] = objDataSet.Tables["Tab_Shrkat"].Rows[0]["sh_parvande"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["kod_shobe"].ToString();
installs[0] += "," + id_year;
installs[0] += "," + id_moon;
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["noeasliepardakhtkonande"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["noefareiepardakhtkonande"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["pardakht_name"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["pardakht_family"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["pardakht_codemelli"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["idposti"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["phone"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["address"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["emza1_name"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["emza1_family"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["emza1_codemelli"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["emza1_semat"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["kod_shobe"].ToString();
installs[0] += "," + objDataSet.Tables["Tab_Shrkat"].Rows[0]["kod_shobe"].ToString();
installs[0] += ",";
installs[0] += ",";
installs[0] += ",";
installs[0] += "";
for (int q = 1; q <= objDataSet.Tables["Tbl_process"].Rows.Count; q++)
{
installs[q] = objDataSet.Tables["Tbl_process"].Rows[q - 1]["cod_mely"].ToString();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["name"].ToString();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["family"].ToString();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["name_pedar"].ToString();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["noe_garardad"].ToString();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["code_posti"].ToString();
database.Connection_Open();
database.Fill("SELECT * FROM Maliat_coding WHERE (MCode = 2) AND (SCode = " + objDataSet.Tables["Tbl_process"].Rows[q - 1]["maliat_onvanShoghl"].ToString() + ")", objDataSet, "maliat_onvanShoghl", true);
database.Connection_Close();
installs[q] += "," + objDataSet.Tables["maliat_onvanShoghl"].Rows[q - 1]["SDesc"].ToString();
objDataSet.Tables["maliat_onvanShoghl"].Clear();
//installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["family"].ToString();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["maliat_madrak"].ToString();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["maliat_rasteshoghli"].ToString();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["code_moafiat_maliat"].ToString();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["maliat_meliat"].ToString();
database.Connection_Open();
database.Fill("SELECT * FROM Maliat_coding WHERE (MCode = 12) AND (SCode = " + objDataSet.Tables["Tbl_process"].Rows[q - 1]["maliat_namekeshvar"].ToString() + ")", objDataSet, "maliat_namekeshvar", true);
database.Connection_Close();
installs[q] += "," + objDataSet.Tables["maliat_namekeshvar"].Rows[q - 1]["SDesc"].ToString();
objDataSet.Tables["maliat_namekeshvar"].Clear();
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["noe_bimeh"].ToString();
installs[q] += ",";
installs[q] += "," + objDataSet.Tables["Tbl_process"].Rows[q - 1]["sh_bimeh"].ToString();
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
installs[q] += ",0";
}
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
file_name = saveFileDialog.FileName;
System.IO.File.WriteAllLines(file_name, installs, Encoding.Unicode);
}
objDataSet.Tables["Tbl_process"].Clear();
}
private void Form17_Load(object sender, EventArgs e)
{
Form_sec();
string file_name = Application.StartupPath.ToString();
file_name += @"\Pey4_BG.Dll";
string[] installs = new string[1];
installs = System.IO.File.ReadAllLines(file_name, Encoding.ASCII);
if (File.Exists(installs[0]) == true)
{
if (installs[0] != "")
{
if (Directory.Exists(installs[0]) == false)
{
pictureBox1.Image = Image.FromFile(installs[0]);
}
}
}
DataBase.Connection_Open();
DataBase.Fill("SELECT * FROM Tab_Shrkat ORDER BY tmpid ASC", objDataSet, "Tab_Shrkat", true);
DataBase.Connection_Close();
comboBox3.Items.Clear();
comboBox3.DataSource = objDataSet.Tables["Tab_Shrkat"];
comboBox3.DisplayMember = "Groupname";
comboBox3.ValueMember = "tmpid";
if (objDataSet.Tables["Tab_Shrkat"].Rows.Count > 0)
{
comboBox3.SelectedIndex = 0;
call_comboBox3_SelectedIndexChanged();
PersianCalendar persian = new PersianCalendar();
if (comboBox2.Items.Count > 0)
{
int y = persian.GetYear(DateTime.Now);
for (int q = 0; q <= comboBox2.Items.Count - 1; q++)
{
comboBox2.SelectedIndex = q;
if (comboBox2.Text == y.ToString())
{
break;
}
}
}
int m = persian.GetMonth(DateTime.Now);
comboBox1.SelectedIndex = m - 1;
}
else
{
اطلاعاتپرسنلToolStripMenuItem.Visible = false;
ورودکارکردازاکسلToolStripMenuItem1.Visible = false;
پرداختکنندهحقوقToolStripMenuItem.Visible = false;
روشهایمحاسبهToolStripMenuItem.Visible = false;
}
}
private void button2_Click(object sender, EventArgs e)
{
if (maskedTextBox5.ToString().IndexOf("_").ToString() != "-1")
{
MessageBox.Show("لطفا فیلد تاریخ ثبت روزنامه را تکمیل نمایید", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
maskedTextBox5.Focus();
return;
}
button2.Enabled = false;
string file_name = @"DD.dll";
string[] installs = new string[1];
installs[0] = maskedTextBox5.Text;
System.IO.File.WriteAllLines(file_name, installs, Encoding.Unicode);
SqlCommand objCommand = new SqlCommand();
objCommand.Connection = objConnection;
objCommand.CommandText = "DELETE FROM loan_view WHERE (idgroup=" + id_group + ") AND (idyear=" + id_year + ") AND (idmoon=" + id_moon + ")";
objCommand.CommandType = CommandType.Text;
objConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();
database.Connection_Open();
database.Fill("SELECT * FROM tbl_personel WHERE (idgroup=" + id_group + ") AND (idyear=" + id_year + ") AND (idmoon=" + id_moon + ") ORDER BY tmpid", objDataSet, "tbl_personel", true);
database.Connection_Close();
if (objDataSet.Tables["tbl_personel"].Rows.Count > 0)
{
progressBar1.Minimum = 0;
progressBar1.Maximum = objDataSet.Tables["tbl_personel"].Rows.Count - 1;
string amin = id_year + "/" + id_moon.ToString().PadLeft(2, '0');
for (int q = 0; q <= objDataSet.Tables["tbl_personel"].Rows.Count - 1; q++)
{
progressBar1.Value = q;
//وام
string vamt1 = "0";
string vamt2 = "0";
string vamt3 = "0";
database1.Connection_Open();
database1.Fill("SELECT a.tmpid, a.loan_price, a.loan_payment_date, a.receiver, b.tmpid AS Expr1, b.loan_code AS Expr2, b.payment_date, b.payment_price, b.payment_status AS Expr3 FROM tbl_loan AS a INNER JOIN tbl_loan_payment AS b ON a.tmpid = b.loan_code WHERE (LEFT(b.payment_date,7) = '" + amin + "') AND (a.receiver = " + objDataSet.Tables["tbl_personel"].Rows[q]["code"].ToString() + ")", objDataSet, "vam", true);
database1.Connection_Close();
if (objDataSet.Tables["vam"].Rows.Count > 0)
{
if (objDataSet.Tables["vam"].Rows.Count >= 1)
{
vamt1 = objDataSet.Tables["vam"].Rows[0]["payment_price"].ToString();
SqlCommand objCommand1 = new SqlCommand();
objCommand1.Connection = objConnection;
objCommand1.CommandText = "UPDATE tbl_loan_payment SET [payment_status]=1 WHERE tmpid=" + objDataSet.Tables["vam"].Rows[0]["Expr1"].ToString();
objCommand1.CommandType = CommandType.Text;
objConnection.Open();
objCommand1.ExecuteNonQuery();
objConnection.Close();
}
if (objDataSet.Tables["vam"].Rows.Count >= 2)
{
vamt2 = objDataSet.Tables["vam"].Rows[1]["payment_price"].ToString();
SqlCommand objCommand1 = new SqlCommand();
objCommand1.Connection = objConnection;
objCommand1.CommandText = "UPDATE tbl_loan_payment SET [payment_status]=1 WHERE tmpid=" + objDataSet.Tables["vam"].Rows[1]["Expr1"].ToString();
objCommand1.CommandType = CommandType.Text;
objConnection.Open();
objCommand1.ExecuteNonQuery();
objConnection.Close();
}
if (objDataSet.Tables["vam"].Rows.Count >= 3)
{
vamt3 = objDataSet.Tables["vam"].Rows[2]["payment_price"].ToString();
SqlCommand objCommand1 = new SqlCommand();
objCommand1.Connection = objConnection;
objCommand1.CommandText = "UPDATE tbl_loan_payment SET [payment_status]=1 WHERE tmpid=" + objDataSet.Tables["vam"].Rows[2]["Expr1"].ToString();
objCommand1.CommandType = CommandType.Text;
objConnection.Open();
objCommand1.ExecuteNonQuery();
objConnection.Close();
}
}
SqlCommand objCommand2 = new SqlCommand();
objCommand2.Connection = objConnection;
objCommand2.CommandText = "INSERT INTO loan_view (tmpid,idgroup,idyear,idmoon,vam1,vam2,vam3) VALUES (@tmpid,@idgroup,@idyear,@idmoon,@vam1,@vam2,@vam3)";
objCommand2.CommandType = CommandType.Text;
objCommand2.Parameters.AddWithValue("@tmpid", objDataSet.Tables["tbl_personel"].Rows[q]["tmpid"].ToString());
objCommand2.Parameters.AddWithValue("@idgroup", id_group);
objCommand2.Parameters.AddWithValue("@idyear", id_year);
objCommand2.Parameters.AddWithValue("@idmoon", id_moon);
objCommand2.Parameters.AddWithValue("@vam1", vamt1);
objCommand2.Parameters.AddWithValue("@vam2", vamt2);
objCommand2.Parameters.AddWithValue("@vam3", vamt3);
objConnection.Open();
objCommand2.ExecuteNonQuery();
objConnection.Close();
//مالیات
database1.Connection_Open();
database1.Fill("SELECT * FROM View_calc_maliat WHERE (tmpid=" + objDataSet.Tables["tbl_personel"].Rows[q]["tmpid"].ToString() + ")", objDataSet, "View1_Process_1_Maliat", true);
database1.Connection_Close();
database1.Connection_Open();
database1.Fill("SELECT * FROM Tbl_maliat ORDER BY maliat_az", objDataSet, "Maliat", true);
database1.Connection_Close();
int w;
Double maliat1 = 0;
Double maliat2 = 0;
Double maliat3 = 0;
if (objDataSet.Tables["Maliat"].Rows.Count > 0)
{
for (w = objDataSet.Tables["Maliat"].Rows.Count - 1; w >= 0; w--)
{
//MessageBox.Show(Convert.ToInt64(objDataSet.Tables["View1_Process_1_Maliat"].Rows[0]["SUM_MASHMOL_MALIAT"]).ToString());
if ((Convert.ToInt64(objDataSet.Tables["View1_Process_1_Maliat"].Rows[0]["SUM_MASHMOL_MALIAT"]) >= Convert.ToInt64(objDataSet.Tables["Maliat"].Rows[w]["maliat_az"])) && (Convert.ToInt64(objDataSet.Tables["View1_Process_1_Maliat"].Rows[0]["SUM_MASHMOL_MALIAT"]) <= Convert.ToInt64(objDataSet.Tables["Maliat"].Rows[w]["maliat_ta"])))
{
//مالیات
maliat1 = Convert.ToDouble(objDataSet.Tables["View1_Process_1_Maliat"].Rows[0]["SUM_MASHMOL_MALIAT"]);
Double q1 = Convert.ToInt64(objDataSet.Tables["Maliat"].Rows[w]["maliat_az"]);
Double q2 = maliat1;
maliat2 = q2 - q1;
maliat3 += (maliat2 * Convert.ToInt64(objDataSet.Tables["Maliat"].Rows[w]["nerkh"])) / 100;
for (int f = (w - 1); f >= 0; f--)
{
q1 = Convert.ToInt64(objDataSet.Tables["Maliat"].Rows[f]["maliat_az"]);
q2 = Convert.ToInt64(objDataSet.Tables["Maliat"].Rows[f]["maliat_ta"]);
maliat2 = q2 - q1;
maliat3 += (maliat2 * Convert.ToInt64(objDataSet.Tables["Maliat"].Rows[f]["nerkh"])) / 100;
}
break;
}
}
}
SqlCommand objCommand3 = new SqlCommand();
objCommand3.Connection = objConnection;
objCommand3.CommandText = "UPDATE loan_view SET view_maliat=@view_maliat WHERE tmpid = " + objDataSet.Tables["tbl_personel"].Rows[q]["tmpid"].ToString();
objCommand3.CommandType = CommandType.Text;
objCommand3.Parameters.AddWithValue("@view_maliat", Math.Round(maliat3));
objConnection.Open();
objCommand3.ExecuteNonQuery();
objConnection.Close();
objDataSet.Tables["vam"].Clear();
objDataSet.Tables["Maliat"].Clear();
objDataSet.Tables["View1_Process_1_Maliat"].Clear();
}
}
//ثبت قانونی
objDataSet.Tables.Remove("View1_Process_2");
database.Connection_Open();
database.Fill("SELECT * FROM View1_Process_2 WHERE ((idgroup=" + id_group + ") AND (idyear=" + id_year + ") AND (idmoon=" + id_moon + ") AND (type1=2))", objDataSet, "View1_Process_2", true);
database.Connection_Close();
SqlCommand objCommand10 = new SqlCommand();
objCommand10.Connection = objConnection;
objCommand10.CommandText = "DELETE FROM Tbl_process WHERE (idgroup=" + id_group + ") AND (idyear=" + id_year + ") AND (idmoon=" + id_moon + ")";
objCommand10.CommandType = CommandType.Text;
objConnection.Open();
objCommand10.ExecuteNonQuery();
objConnection.Close();
if (objDataSet.Tables["View1_Process_2"].Rows.Count > 0)
{
progressBar1.Minimum = 0;
progressBar1.Maximum = objDataSet.Tables["View1_Process_2"].Rows.Count - 1;
for (int q = 0; q <= objDataSet.Tables["View1_Process_2"].Rows.Count - 1; q++)
{
progressBar1.Value = q;
SqlCommand objCommand2 = new SqlCommand();
objCommand2.Connection = objConnection;
objCommand2.CommandText = "INSERT INTO Tbl_process (idgroup,idyear,idmoon,idpersonal,w1,w2,w3,w4,w5,w6,vam1,vam2,vam3,SUM_hogogh_mazaya,SUM_MASHMOL_BIMEH,Haghe_bime_personal,moafiat_Haghe_bime_personal,Haghe_bime_bikari,moafiat_Haghe_bime_bikari,Haghe_bime_karfarma,moafiat_Haghe_bime_karfarma,SUM_MASHMOL_MALIAT,moafiat_MASHMOL_MALIAT,view_maliat,ALL_kosorat,Khales,type1,wt1,wt2,wt3,wt4,wt5,wt6,SUM_mazaya,bime2,SUM_mazaya_maliat) VALUES (@idgroup,@idyear,@idmoon,@idpersonal,@w1,@w2,@w3,@w4,@w5,@w6,@vam1,@vam2,@vam3,@SUM_hogogh_mazaya,@SUM_MASHMOL_BIMEH,@Haghe_bime_personal,@moafiat_Haghe_bime_personal,@Haghe_bime_bikari,@moafiat_Haghe_bime_bikari,@Haghe_bime_karfarma,@moafiat_Haghe_bime_karfarma,@SUM_MASHMOL_MALIAT,@moafiat_MASHMOL_MALIAT,@view_maliat,@ALL_kosorat,@Khales,@type1,@wt1,@wt2,@wt3,@wt4,@wt5,@wt6,@SUM_mazaya,@bime2,@SUM_mazaya_maliat)";
objCommand2.CommandType = CommandType.Text;
objCommand2.Parameters.AddWithValue("@idgroup", objDataSet.Tables["View1_Process_2"].Rows[q]["idgroup"].ToString());
objCommand2.Parameters.AddWithValue("@idyear", objDataSet.Tables["View1_Process_2"].Rows[q]["idyear"].ToString());
objCommand2.Parameters.AddWithValue("@idmoon", objDataSet.Tables["View1_Process_2"].Rows[q]["idmoon"].ToString());
objCommand2.Parameters.AddWithValue("@idpersonal", objDataSet.Tables["View1_Process_2"].Rows[q]["tmpid"].ToString());
objCommand2.Parameters.AddWithValue("@w1", objDataSet.Tables["View1_Process_2"].Rows[q]["w1"].ToString());
objCommand2.Parameters.AddWithValue("@w2", objDataSet.Tables["View1_Process_2"].Rows[q]["w2"].ToString());
objCommand2.Parameters.AddWithValue("@w3", objDataSet.Tables["View1_Process_2"].Rows[q]["w3"].ToString());
objCommand2.Parameters.AddWithValue("@w4", objDataSet.Tables["View1_Process_2"].Rows[q]["w4"].ToString());
objCommand2.Parameters.AddWithValue("@w5", objDataSet.Tables["View1_Process_2"].Rows[q]["w5"].ToString());
objCommand2.Parameters.AddWithValue("@w6", objDataSet.Tables["View1_Process_2"].Rows[q]["w6"].ToString());
objCommand2.Parameters.AddWithValue("@vam1", objDataSet.Tables["View1_Process_2"].Rows[q]["vam1"].ToString());
objCommand2.Parameters.AddWithValue("@vam2", objDataSet.Tables["View1_Process_2"].Rows[q]["vam2"].ToString());
objCommand2.Parameters.AddWithValue("@vam3", objDataSet.Tables["View1_Process_2"].Rows[q]["vam3"].ToString());
objCommand2.Parameters.AddWithValue("@SUM_hogogh_mazaya", objDataSet.Tables["View1_Process_2"].Rows[q]["SUM_hogogh_mazaya"].ToString());
objCommand2.Parameters.AddWithValue("@SUM_MASHMOL_BIMEH", objDataSet.Tables["View1_Process_2"].Rows[q]["SUM_MASHMOL_BIMEH"].ToString());
objCommand2.Parameters.AddWithValue("@Haghe_bime_personal", objDataSet.Tables["View1_Process_2"].Rows[q]["Haghe_bime_personal"].ToString());
objCommand2.Parameters.AddWithValue("@moafiat_Haghe_bime_personal", objDataSet.Tables["View1_Process_2"].Rows[q]["moafiat_Haghe_bime_personal"].ToString());
objCommand2.Parameters.AddWithValue("@Haghe_bime_bikari", objDataSet.Tables["View1_Process_2"].Rows[q]["Haghe_bime_bikari"].ToString());
objCommand2.Parameters.AddWithValue("@moafiat_Haghe_bime_bikari", objDataSet.Tables["View1_Process_2"].Rows[q]["moafiat_Haghe_bime_bikari"].ToString());
objCommand2.Parameters.AddWithValue("@Haghe_bime_karfarma", objDataSet.Tables["View1_Process_2"].Rows[q]["Haghe_bime_karfarma"].ToString());
objCommand2.Parameters.AddWithValue("@moafiat_Haghe_bime_karfarma", objDataSet.Tables["View1_Process_2"].Rows[q]["moafiat_Haghe_bime_karfarma"].ToString());
objCommand2.Parameters.AddWithValue("@SUM_MASHMOL_MALIAT", objDataSet.Tables["View1_Process_2"].Rows[q]["SUM_MASHMOL_MALIAT"].ToString());
objCommand2.Parameters.AddWithValue("@moafiat_MASHMOL_MALIAT", objDataSet.Tables["View1_Process_2"].Rows[q]["moafiat_MASHMOL_MALIAT"].ToString());
objCommand2.Parameters.AddWithValue("@view_maliat", objDataSet.Tables["View1_Process_2"].Rows[q]["view_maliat"].ToString());
objCommand2.Parameters.AddWithValue("@ALL_kosorat", objDataSet.Tables["View1_Process_2"].Rows[q]["ALL_kosorat"].ToString());
objCommand2.Parameters.AddWithValue("@Khales", objDataSet.Tables["View1_Process_2"].Rows[q]["Khales"].ToString());
objCommand2.Parameters.AddWithValue("@type1", objDataSet.Tables["View1_Process_2"].Rows[q]["type1"].ToString());
objCommand2.Parameters.AddWithValue("@wt1", "کل روزهای کارکرد");
objCommand2.Parameters.AddWithValue("@wt2", "روزهای کارکرد");
objCommand2.Parameters.AddWithValue("@wt3", "حقوق روزانه");
objCommand2.Parameters.AddWithValue("@wt4", "حقوق ماهانه");
objCommand2.Parameters.AddWithValue("@wt5", "اضافه کار عادی");
objCommand2.Parameters.AddWithValue("@wt6", "اضافه کار تعطیلی");
objCommand2.Parameters.AddWithValue("@SUM_mazaya", objDataSet.Tables["View1_Process_2"].Rows[q]["SUM_mazaya"].ToString());
objCommand2.Parameters.AddWithValue("@bime2", objDataSet.Tables["View1_Process_2"].Rows[q]["bime2"].ToString());
objCommand2.Parameters.AddWithValue("@SUM_mazaya_maliat", objDataSet.Tables["View1_Process_2"].Rows[q]["SUM_mazaya_maliat"].ToString());
objConnection.Open();
objCommand2.ExecuteNonQuery();
objConnection.Close();
}
}
//توافقی
objDataSet.Tables.Remove("View_Process_2");
database.Connection_Open();
database.Fill("SELECT * FROM View_Process_2 WHERE ((idgroup=" + id_group + ") AND (idyear=" + id_year + ") AND (idmoon=" + id_moon + ") AND (type1=1))", objDataSet, "View_Process_2", true);
database.Connection_Close();
//ثبت
if (objDataSet.Tables["View_Process_2"].Rows.Count > 0)
{
progressBar1.Minimum = 0;
progressBar1.Maximum = objDataSet.Tables["View_Process_2"].Rows.Count - 1;
for (int q = 0; q <= objDataSet.Tables["View_Process_2"].Rows.Count - 1; q++)
{
progressBar1.Value = q;
SqlCommand objCommand2 = new SqlCommand();
objCommand2.Connection = objConnection;
objCommand2.CommandText = "INSERT INTO Tbl_process (idgroup,idyear,idmoon,idpersonal,w1,w2,w3,w4,w5,w6,vam1,vam2,vam3,SUM_hogogh_mazaya,SUM_MASHMOL_BIMEH,Haghe_bime_personal,moafiat_Haghe_bime_personal,Haghe_bime_bikari,moafiat_Haghe_bime_bikari,Haghe_bime_karfarma,moafiat_Haghe_bime_karfarma,SUM_MASHMOL_MALIAT,moafiat_MASHMOL_MALIAT,view_maliat,ALL_kosorat,Khales,type1,wt1,wt2,wt3,wt4,wt5,wt6,SUM_mazaya,bime2,SUM_mazaya_maliat) VALUES (@idgroup,@idyear,@idmoon,@idpersonal,@w1,@w2,@w3,@w4,@w5,@w6,@vam1,@vam2,@vam3,@SUM_hogogh_mazaya,@SUM_MASHMOL_BIMEH,@Haghe_bime_personal,@moafiat_Haghe_bime_personal,@Haghe_bime_bikari,@moafiat_Haghe_bime_bikari,@Haghe_bime_karfarma,@moafiat_Haghe_bime_karfarma,@SUM_MASHMOL_MALIAT,@moafiat_MASHMOL_MALIAT,@view_maliat,@ALL_kosorat,@Khales,@type1,@wt1,@wt2,@wt3,@wt4,@wt5,@wt6,@SUM_mazaya,@bime2,@SUM_mazaya_maliat)";
objCommand2.CommandType = CommandType.Text;
objCommand2.Parameters.AddWithValue("@idgroup", objDataSet.Tables["View_Process_2"].Rows[q]["idgroup"].ToString());
objCommand2.Parameters.AddWithValue("@idyear", objDataSet.Tables["View_Process_2"].Rows[q]["idyear"].ToString());
objCommand2.Parameters.AddWithValue("@idmoon", objDataSet.Tables["View_Process_2"].Rows[q]["idmoon"].ToString());
objCommand2.Parameters.AddWithValue("@idpersonal", objDataSet.Tables["View_Process_2"].Rows[q]["tmpid"].ToString());
objCommand2.Parameters.AddWithValue("@w1", objDataSet.Tables["View_Process_2"].Rows[q]["w1"].ToString());
objCommand2.Parameters.AddWithValue("@w2", objDataSet.Tables["View_Process_2"].Rows[q]["w2"].ToString());
objCommand2.Parameters.AddWithValue("@w3", objDataSet.Tables["View_Process_2"].Rows[q]["w3"].ToString());
objCommand2.Parameters.AddWithValue("@w4", objDataSet.Tables["View_Process_2"].Rows[q]["w4"].ToString());
objCommand2.Parameters.AddWithValue("@w5", objDataSet.Tables["View_Process_2"].Rows[q]["w5"].ToString());
objCommand2.Parameters.AddWithValue("@w6", objDataSet.Tables["View_Process_2"].Rows[q]["w6"].ToString());
objCommand2.Parameters.AddWithValue("@vam1", objDataSet.Tables["View_Process_2"].Rows[q]["vam1"].ToString());
objCommand2.Parameters.AddWithValue("@vam2", objDataSet.Tables["View_Process_2"].Rows[q]["vam2"].ToString());
objCommand2.Parameters.AddWithValue("@vam3", objDataSet.Tables["View_Process_2"].Rows[q]["vam3"].ToString());
objCommand2.Parameters.AddWithValue("@SUM_hogogh_mazaya", objDataSet.Tables["View_Process_2"].Rows[q]["SUM_hogogh_mazaya"].ToString());
objCommand2.Parameters.AddWithValue("@SUM_MASHMOL_BIMEH", objDataSet.Tables["View_Process_2"].Rows[q]["SUM_MASHMOL_BIMEH"].ToString());
objCommand2.Parameters.AddWithValue("@Haghe_bime_personal", objDataSet.Tables["View_Process_2"].Rows[q]["Haghe_bime_personal"].ToString());
objCommand2.Parameters.AddWithValue("@moafiat_Haghe_bime_personal", objDataSet.Tables["View_Process_2"].Rows[q]["moafiat_Haghe_bime_personal"].ToString());
objCommand2.Parameters.AddWithValue("@Haghe_bime_bikari", objDataSet.Tables["View_Process_2"].Rows[q]["Haghe_bime_bikari"].ToString());
objCommand2.Parameters.AddWithValue("@moafiat_Haghe_bime_bikari", objDataSet.Tables["View_Process_2"].Rows[q]["moafiat_Haghe_bime_bikari"].ToString());
objCommand2.Parameters.AddWithValue("@Haghe_bime_karfarma", objDataSet.Tables["View_Process_2"].Rows[q]["Haghe_bime_karfarma"].ToString());
objCommand2.Parameters.AddWithValue("@moafiat_Haghe_bime_karfarma", objDataSet.Tables["View_Process_2"].Rows[q]["moafiat_Haghe_bime_karfarma"].ToString());
objCommand2.Parameters.AddWithValue("@SUM_MASHMOL_MALIAT", objDataSet.Tables["View_Process_2"].Rows[q]["SUM_MASHMOL_MALIAT"].ToString());
objCommand2.Parameters.AddWithValue("@moafiat_MASHMOL_MALIAT", objDataSet.Tables["View_Process_2"].Rows[q]["moafiat_MASHMOL_MALIAT"].ToString());
objCommand2.Parameters.AddWithValue("@view_maliat", objDataSet.Tables["View_Process_2"].Rows[q]["view_maliat"].ToString());
objCommand2.Parameters.AddWithValue("@ALL_kosorat", objDataSet.Tables["View_Process_2"].Rows[q]["ALL_kosorat"].ToString());
objCommand2.Parameters.AddWithValue("@Khales", objDataSet.Tables["View_Process_2"].Rows[q]["Khales"].ToString());
objCommand2.Parameters.AddWithValue("@type1", objDataSet.Tables["View_Process_2"].Rows[q]["type1"].ToString());
objCommand2.Parameters.AddWithValue("@wt1", "کل روزهای کارکرد");
objCommand2.Parameters.AddWithValue("@wt2", "روزهای کارکرد");
objCommand2.Parameters.AddWithValue("@wt3", "حقوق روزانه");
objCommand2.Parameters.AddWithValue("@wt4", "حقوق ماهانه");
objCommand2.Parameters.AddWithValue("@wt5", "اضافه کار عادی");
objCommand2.Parameters.AddWithValue("@wt6", "اضافه کار تعطیلی");
objCommand2.Parameters.AddWithValue("@SUM_mazaya", objDataSet.Tables["View_Process_2"].Rows[q]["SUM_mazaya"].ToString());
objCommand2.Parameters.AddWithValue("@bime2", objDataSet.Tables["View_Process_2"].Rows[q]["bime2"].ToString());
objCommand2.Parameters.AddWithValue("@SUM_mazaya_maliat", objDataSet.Tables["View_Process_2"].Rows[q]["SUM_mazaya_maliat"].ToString());
objConnection.Open();
objCommand2.ExecuteNonQuery();
objConnection.Close();
}
}
MessageBox.Show("ثبت انجام شد", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
button2.Enabled = true;
this.Hide();
}
public void Form_Load_set_color()
{
DataSet objDataSet1 = new DataSet();
Database.Connection_Open();
Database.Fill("SELECT * FROM Color_Font_Set ORDER BY tmpid", objDataSet1, "Color_Font_Set", true);
Database.Connection_Close();
TypeConverter tc0 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor0 = (Color)tc0.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[6]["promp"].ToString());
foreach (SplitContainer spc in this.Controls)
{
foreach (Control ct in spc.Panel2.Controls)
{
if (ct.GetType() == typeof(Button))
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Font));
Font newFont = (Font)tc.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[13]["promp"].ToString());
ct.Font = newFont;
TypeConverter tc1 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor = (Color)tc1.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[14]["promp"].ToString());
ct.ForeColor = newColor;
}
}
}
this.BackColor = newColor0;
TypeConverter tc2 = TypeDescriptor.GetConverter(typeof(Font));
Font newFont2 = (Font)tc2.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[2]["promp"].ToString());
TypeConverter tc3 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor3 = (Color)tc3.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[8]["promp"].ToString());
TypeConverter tc7 = TypeDescriptor.GetConverter(typeof(Font));
Font newFont7 = (Font)tc7.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[7]["promp"].ToString());
TypeConverter tc8 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor8 = (Color)tc8.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[8]["promp"].ToString());
TypeConverter tc9 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor9 = (Color)tc9.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[9]["promp"].ToString());
TypeConverter tc10 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor10 = (Color)tc10.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[10]["promp"].ToString());
TypeConverter tc11 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor11 = (Color)tc11.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[11]["promp"].ToString());
TypeConverter tc12 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor12 = (Color)tc12.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[12]["promp"].ToString());
DataGridViewCellStyle objAlignRightCellStyle1 = new DataGridViewCellStyle();
objAlignRightCellStyle1.Font = newFont2;
objAlignRightCellStyle1.BackColor = newColor3;
DataGridViewCellStyle objAlignRightCellStyle2 = new DataGridViewCellStyle();
objAlignRightCellStyle2.BackColor = newColor9;
objAlignRightCellStyle2.ForeColor = newColor10;
DataGridViewCellStyle objAlignRightCellStyle3 = new DataGridViewCellStyle();
objAlignRightCellStyle3.BackColor = newColor11;
objAlignRightCellStyle3.ForeColor = newColor12;
dataGridView1.Font = newFont7;
dataGridView1.BackgroundColor = newColor8;
dataGridView1.ColumnHeadersDefaultCellStyle = objAlignRightCellStyle1;
dataGridView1.AlternatingRowsDefaultCellStyle = objAlignRightCellStyle2;
dataGridView1.DefaultCellStyle = objAlignRightCellStyle3;
objDataSet1.Clear();
}
private void Form24_Load(object sender, EventArgs e)
{
DataBase.Connection_Open();
DataBase.Fill("SELECT * FROM Tab_Shrkat ORDER BY tmpid ASC", objDataSet, "Tab_Shrkat1", true);
DataBase.Connection_Close();
comboBox3.Items.Clear();
comboBox3.DataSource = objDataSet.Tables["Tab_Shrkat1"];
comboBox3.DisplayMember = "Groupname";
comboBox3.ValueMember = "tmpid";
if (objDataSet.Tables["Tab_Shrkat1"].Rows.Count > 0)
{
comboBox3.SelectedIndex = 0;
call_comboBox3_SelectedIndexChanged();
PersianCalendar persian = new PersianCalendar();
if (comboBox2.Items.Count > 0)
{
int y = persian.GetYear(DateTime.Now);
for (int q = 0; q <= comboBox2.Items.Count - 1; q++)
{
comboBox2.SelectedIndex = q;
if (comboBox2.Text == y.ToString())
{
break;
}
}
}
int m = persian.GetMonth(DateTime.Now);
comboBox1.SelectedIndex = m - 1;
}
DataBase.Connection_Open();
DataBase.Fill("SELECT * FROM Tab_Shrkat ORDER BY tmpid ASC", objDataSet, "Tab_Shrkat2", true);
DataBase.Connection_Close();
comboBox6.Items.Clear();
comboBox6.DataSource = objDataSet.Tables["Tab_Shrkat2"];
comboBox6.DisplayMember = "Groupname";
comboBox6.ValueMember = "tmpid";
if (objDataSet.Tables["Tab_Shrkat2"].Rows.Count > 0)
{
comboBox6.SelectedIndex = 0;
call_comboBox6_SelectedIndexChanged();
PersianCalendar persian = new PersianCalendar();
if (comboBox5.Items.Count > 0)
{
int y = persian.GetYear(DateTime.Now);
for (int q = 0; q <= comboBox5.Items.Count - 1; q++)
{
comboBox5.SelectedIndex = q;
if (comboBox5.Text == y.ToString())
{
break;
}
}
}
int m = persian.GetMonth(DateTime.Now);
comboBox4.SelectedIndex = m - 1;
}
}
public void Form_Load_set_color()
{
DataSet objDataSet1 = new DataSet();
Database.Connection_Open();
Database.Fill("SELECT * FROM Color_Font_Set ORDER BY tmpid", objDataSet1, "Color_Font_Set", true);
Database.Connection_Close();
TypeConverter tc0 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor0 = (Color)tc0.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[6]["promp"].ToString());
this.BackColor = newColor0;
TypeConverter tc2 = TypeDescriptor.GetConverter(typeof(Font));
Font newFont2 = (Font)tc2.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[2]["promp"].ToString());
TypeConverter tc3 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor3 = (Color)tc3.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[8]["promp"].ToString());
TypeConverter tc7 = TypeDescriptor.GetConverter(typeof(Font));
Font newFont7 = (Font)tc7.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[7]["promp"].ToString());
TypeConverter tc8 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor8 = (Color)tc8.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[8]["promp"].ToString());
TypeConverter tc9 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor9 = (Color)tc9.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[9]["promp"].ToString());
TypeConverter tc10 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor10 = (Color)tc10.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[10]["promp"].ToString());
TypeConverter tc11 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor11 = (Color)tc11.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[11]["promp"].ToString());
TypeConverter tc12 = TypeDescriptor.GetConverter(typeof(Color));
Color newColor12 = (Color)tc12.ConvertFromString(objDataSet1.Tables["Color_Font_Set"].Rows[12]["promp"].ToString());
DataGridViewCellStyle objAlignRightCellStyle1 = new DataGridViewCellStyle();
objAlignRightCellStyle1.Font = newFont2;
objAlignRightCellStyle1.BackColor = newColor3;
DataGridViewCellStyle objAlignRightCellStyle2 = new DataGridViewCellStyle();
objAlignRightCellStyle2.BackColor = newColor9;
objAlignRightCellStyle2.ForeColor = newColor10;
DataGridViewCellStyle objAlignRightCellStyle3 = new DataGridViewCellStyle();
objAlignRightCellStyle3.BackColor = newColor11;
objAlignRightCellStyle3.ForeColor = newColor12;
dataGridViewZarayeb.Font = newFont7;
dataGridViewZarayeb.BackgroundColor = newColor8;
dataGridViewZarayeb.ColumnHeadersDefaultCellStyle = objAlignRightCellStyle1;
dataGridViewZarayeb.AlternatingRowsDefaultCellStyle = objAlignRightCellStyle2;
dataGridViewZarayeb.DefaultCellStyle = objAlignRightCellStyle3;
dataGridViewMaliat.Font = newFont7;
dataGridViewMaliat.BackgroundColor = newColor8;
dataGridViewMaliat.ColumnHeadersDefaultCellStyle = objAlignRightCellStyle1;
dataGridViewMaliat.AlternatingRowsDefaultCellStyle = objAlignRightCellStyle2;
dataGridViewMaliat.DefaultCellStyle = objAlignRightCellStyle3;
dataGridViewMoafiat.Font = newFont7;
dataGridViewMoafiat.BackgroundColor = newColor8;
dataGridViewMoafiat.ColumnHeadersDefaultCellStyle = objAlignRightCellStyle1;
dataGridViewMoafiat.AlternatingRowsDefaultCellStyle = objAlignRightCellStyle2;
dataGridViewMoafiat.DefaultCellStyle = objAlignRightCellStyle3;
dataGridView1.Font = newFont7;
dataGridView1.BackgroundColor = newColor8;
dataGridView1.ColumnHeadersDefaultCellStyle = objAlignRightCellStyle1;
dataGridView1.AlternatingRowsDefaultCellStyle = objAlignRightCellStyle2;
dataGridView1.DefaultCellStyle = objAlignRightCellStyle3;
objDataSet1.Clear();
}
private void Bind_2_Grid_Good()
{
string Qry = "";
string[] Search_Data;
string search = Txt_Search.Text;
//int i;
//bool first = true;
DB_Base fix = new DB_Base();
if (Txt_Search.Text.Trim() == "")
{
FormLoad();
}
else
{
//Search_Data = fix.FixPersianString(Txt_Search.Text).Split(' ');
Search_Data = Txt_Search.Text.Split(' ');
Qry = "SELECT tmpid,selectid,code,name,family,name_pedar,sex,cod_mely,sh_sh FROM tbl_personel WHERE (";
//for (i = 0; i < Search_Data.Length; i++)
//{
// if (Search_Data[i].Trim() != "")
// {
// //if (first == false)
// // Qry += "And";
// //Qry += "(";
// if (Database.Is_Numeric(Search_Data[i]))
// {
// Qry += "([code] like '%" + Search_Data[i] + "%')";
// Qry += "Or ([cod_mely] like '%" + Search_Data[i] + "%')";
// Qry += "Or ([sh_sh] like '%" + Search_Data[i] + "%')";
// Qry += "Or ([code_posti] like '%" + Search_Data[i] + "%')";
// Qry += "Or ([sh_bimeh] like '%" + Search_Data[i] + "%')";
// Qry += "Or ([sh_hesab] like '%" + Search_Data[i] + "%')";
// Qry += "Or ([tedah_farzand] like '%" + Search_Data[i] + "%')";
// Qry += "Or ([phon_manzel] like '%" + Search_Data[i] + "%')";
// Qry += "Or ([phon_sabt] like '%" + Search_Data[i] + "%')";
// Qry += "Or ([sh_kart] like '%" + Search_Data[i] + "%')";
// }
// else if (Database.Is_Nominal(Search_Data[i]))
// search += Search_Data[i];
// //first = false;
// }
//}
Qry += "(code LIKE '%" + search + "%')";
Qry += " OR (name LIKE '%" + search + "%')";
Qry += " OR (family LIKE '%" + search + "%')";
Qry += " OR (name_pedar LIKE '%" + search + "%')";
Qry += " OR (sex like '%" + search + "%')";
Qry += " OR (cod_mely like '%" + search + "%')";
Qry += " OR (sh_sh like '%" + search + "%')";
Qry += ")";
Qry += " AND ((idgroup = " + id_group + ") AND (idyear = " + id_year + ") AND (idmoon = " + id_moon + "))";
//Qry += ")";
//MessageBox.Show(Qry);
objDataSet1.Tables["tbl_personel"].Clear();
Database.Connection_Open();
Database.Fill(Qry, objDataSet1, "tbl_personel", true);
Database.Connection_Close();
grdAuthorTitles.AutoGenerateColumns = true;
grdAuthorTitles.DataSource = objDataSet1;
grdAuthorTitles.DataMember = "tbl_personel";
}
}