private void Form25_Load(object sender, EventArgs e) { Form_Load_set_color(); String Alltxtor; if (objDataSet.Tables["tbl_personel"].Rows.Count > 0) { Alltxtor = ""; for (int q = 0; q <= objDataSet.Tables["tbl_personel"].Rows.Count - 1; q++) { if (objDataSet.Tables["tbl_personel"].Rows[q]["selectid"].ToString() == "True") { database.Connection_Open(); database.Fill("SELECT * FROM Tbl_karkard WHERE (idgroup=" + id_group + ") AND (idyear=" + id_year + ") AND (idmoon=" + id_moon + ") AND (idpersonal=" + objDataSet.Tables["tbl_personel"].Rows[q]["tmpid"].ToString() + ")", objDataSet, "textexistTbl_karkard", true); database.Connection_Close(); if (objDataSet.Tables["textexistTbl_karkard"].Rows.Count.ToString() == "0") { SqlCommand objCommand = new SqlCommand(); objCommand.Connection = objConnection; objCommand.CommandText = "INSERT INTO Tbl_karkard (idgroup,idyear,idmoon,idpersonal) VALUES (@idgroup,@idyear,@idmoon,@idpersonal)"; objCommand.CommandType = CommandType.Text; objCommand.Parameters.AddWithValue("@idgroup", id_group); objCommand.Parameters.AddWithValue("@idyear", id_year); objCommand.Parameters.AddWithValue("@idmoon", id_moon); objCommand.Parameters.AddWithValue("@idpersonal", objDataSet.Tables["tbl_personel"].Rows[q]["tmpid"].ToString()); objConnection.Open(); objCommand.ExecuteNonQuery(); objConnection.Close(); objDataSet.Tables["textexistTbl_karkard"].Clear(); } Alltxtor += " (tmpid=" + objDataSet.Tables["tbl_personel"].Rows[q]["tmpid"].ToString() + ") OR "; } } if (Alltxtor.Length > 0) { Alltxtor = Alltxtor.Substring(1, Alltxtor.Length - 4); database.Connection_Open(); database.Fill("SELECT tmpid ,code ,name ,family ,name_pedar FROM tbl_personel WHERE ((idgroup=" + id_group + ") AND (idyear=" + id_year + ") AND (idmoon=" + id_moon + ") AND (NoeHoghog IN (3,4)) AND (" + Alltxtor + "))", objDataSet, "Tbl_karkardfill", true); database.Connection_Close(); dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = objDataSet; dataGridView1.DataMember = "Tbl_karkardfill"; dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[1].HeaderText = "کد پرسنل"; dataGridView1.Columns[2].HeaderText = "نام"; dataGridView1.Columns[3].HeaderText = "نام خانوادگی"; dataGridView1.Columns[4].HeaderText = "نام پدر"; } } }
private void Form2_Load(object sender, EventArgs e) { Form_Load_set_color(); Form_sec(); String Alltxtor; if (objDataSet.Tables["tbl_personel"].Rows.Count > 0) { Alltxtor = ""; for (int q = 0; q <= objDataSet.Tables["tbl_personel"].Rows.Count - 1; q++) { if (objDataSet.Tables["tbl_personel"].Rows[q]["selectid"].ToString() == "True") { database.Connection_Open(); database.Fill("SELECT * FROM Tbl_karkard WHERE (idgroup=" + id_group + ") AND (idyear=" + id_year + ") AND (idmoon=" + id_moon + ") AND (type1=" + personel_type1 + ") AND (idpersonal=" + objDataSet.Tables["tbl_personel"].Rows[q]["tmpid"].ToString() + ")", objDataSet, "textexistTbl_karkard", true); database.Connection_Close(); if (objDataSet.Tables["textexistTbl_karkard"].Rows.Count.ToString() == "0") { SqlCommand objCommand = new SqlCommand(); objCommand.Connection = objConnection; objCommand.CommandText = "INSERT INTO Tbl_karkard (idgroup,idyear,idmoon,idpersonal,type1) VALUES (@idgroup,@idyear,@idmoon,@idpersonal,@type1)"; objCommand.CommandType = CommandType.Text; objCommand.Parameters.AddWithValue("@idgroup", id_group); objCommand.Parameters.AddWithValue("@idyear", id_year); objCommand.Parameters.AddWithValue("@idmoon", id_moon); objCommand.Parameters.AddWithValue("@idpersonal", objDataSet.Tables["tbl_personel"].Rows[q]["tmpid"].ToString()); objCommand.Parameters.AddWithValue("@type1", personel_type1); objConnection.Open(); objCommand.ExecuteNonQuery(); objConnection.Close(); objDataSet.Tables["textexistTbl_karkard"].Clear(); } Alltxtor += " (a.idpersonal=" + objDataSet.Tables["tbl_personel"].Rows[q]["tmpid"].ToString() + ") OR "; } } if (Alltxtor.Length > 0) { Alltxtor = Alltxtor.Substring(1, Alltxtor.Length - 4); database.Connection_Open(); database.Fill("SELECT b.code ,b.name ,b.family ,b.name_pedar ,b.cod_mely ,a.q1 ,a.q6 ,a.q2 ,a.q3 ,a.q4 ,a.q5 ,a.tmpid FROM Tbl_karkard AS a INNER JOIN tbl_personel AS b ON a.idpersonal = b.tmpid AND a.idgroup = b.idgroup WHERE ((a.idgroup=" + id_group + ") AND (a.idyear=" + id_year + ") AND (a.idmoon=" + id_moon + ") AND (a.type1=" + personel_type1 + ") AND (b.NoeHoghog IN (1,2)) AND (" + Alltxtor + "))", objDataSet, "Tbl_karkardfill", true); database.Connection_Close(); database.Connection_Open(); database.Fill("SELECT * FROM Tbl_karkard AS a WHERE ((a.idgroup=" + id_group + ") AND (a.idyear=" + id_year + ") AND (a.idmoon=" + id_moon + ") AND (a.type1=" + personel_type1 + ") AND (" + Alltxtor + "))", objDataSet, "Tbl_karkardmain", true); database.Connection_Close(); dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = objDataSet; dataGridView1.DataMember = "Tbl_karkardfill"; dataGridView1.Columns[0].HeaderText = "کد پرسنل"; dataGridView1.Columns[1].HeaderText = "نام"; dataGridView1.Columns[2].HeaderText = "نام خانوادگی"; dataGridView1.Columns[3].HeaderText = "نام پدر"; dataGridView1.Columns[4].HeaderText = "کد ملی"; dataGridView1.Columns[5].HeaderText = "مرخصی بدون حقوق"; dataGridView1.Columns[6].HeaderText = "مرخصی با حقوق"; dataGridView1.Columns[7].HeaderText = "ساعات اضافه کار عادی"; dataGridView1.Columns[8].HeaderText = "ساعات اضافه کار تعطیلی"; dataGridView1.Columns[9].HeaderText = "ساعات تاخیر ورود"; dataGridView1.Columns[10].HeaderText = "ساعات تعجیل خروج"; dataGridView1.Columns[11].Visible = false; } } }