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;
}
}
}
