public IntercepIntervals(string User) { InitializeComponent(); FillcbxHole(); fillComboBoxVhmod(); this.Usuario = User.Trim(); GlobalValue.Permissions = LoadLog.GetPermissiinRol("SPGet_RolesForUser", this.Usuario, this.Name); this.Permission = GlobalValue.Permissions; ValidatePermission(this.Controls); }
private void btnExport_Click(object sender, EventArgs e) { exportForm popup = new exportForm(); popup.StartPosition = FormStartPosition.CenterParent; DialogResult dialogResult = popup.ShowDialog(); if (dialogResult == DialogResult.OK) { switch (popup.ExportType) { case "HOLE": exportByHoleId(); break; case "SOURCE": exportBySource(popup.Source); break; case "TARGET": exportByTarget(popup.Target, popup.Source); break; default: break; } return; } else if (dialogResult == DialogResult.Cancel) { return; } //exportIntercept(cbxSource.Text); var culturaCol = CultureInfo.GetCultureInfo("es-CO"); DateTime dateReporte = Convert.ToDateTime(DateTime.Now, culturaCol); LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, "Generate Report", "Report"); Clear(); }
private void init_golobal_solusi() { Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Memulai inisial solusi"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); //agro //12 agro GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Agro Bisnis", Kelas = "12 AGRO A", Tingkat = 3, Visit = false })); GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Agro Bisnis", Kelas = "12 AGRO B", Tingkat = 3, Visit = false })); //11 agro GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Agro Bisnis", Kelas = "11 AGRO A", Tingkat = 2, Visit = false })); GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Agro Bisnis", Kelas = "11 AGRO B", Tingkat = 2, Visit = false })); //10 agro GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Agro Bisnis", Kelas = "10 AGRO A", Tingkat = 1, Visit = false })); GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Agro Bisnis", Kelas = "10 AGRO B", Tingkat = 1, Visit = false })); //////pm ////12 PM //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "12 PM A", Tingkat = 3, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "12 PM B", Tingkat = 3, Visit = false })); ////11 PM //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "11 PM A", Tingkat = 2, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "11 PM B", Tingkat = 2, Visit = false })); ////10 PM //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "10 PM A", Tingkat = 1, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "10 PM B", Tingkat = 1, Visit = false })); ////TKJ ////12 TKJ //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "12 TKJ A", Tingkat = 3, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "12 TKJ B", Tingkat = 3, Visit = false })); ////11 TKJ //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "11 TKJ A", Tingkat = 2, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "11 TKJ B", Tingkat = 2, Visit = false })); ////10 TKJ //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "10 TKJ A", Tingkat = 1, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "10 TKJ B", Tingkat = 1, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "10 TKJ K", Tingkat = 1, Visit = false })); ////RPL ////12 RPL //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "12 RPL A", Tingkat = 3, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "12 RPL B", Tingkat = 3, Visit = false })); ////11 PM //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "11 RPL A", Tingkat = 2, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "11 RPL B", Tingkat = 2, Visit = false })); ////10 PM //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "10 RPL A", Tingkat = 1, Visit = false })); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "10 RPL B", Tingkat = 1, Visit = false })); ////KI ////11 PM //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Kimia Industri", Kelas = "11 KI A", Tingkat = 2, Visit = false})); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Kimia Industri", Kelas = "11 KI B", Tingkat = 2, Visit = false})); ////10 PM //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Kimia Industri", Kelas = "10 KI A", Tingkat = 1, Visit = false})); //GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Kimia Industri", Kelas = "10 KI B", Tingkat = 1, Visit = false })); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 12 Agro A"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); GlobalJadwal.GlobalSolusi[0].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[0].Solusi, sql.data_mengajar(3, 1, "12 AGRO A", "NEWID()"), LoadLog, Log); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 12 Agro A"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); Thread.Sleep(500); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 12 Agro B"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); GlobalJadwal.GlobalSolusi[1].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[1].Solusi, sql.data_mengajar(3, 1, "12 AGRO B", "detail_mtp.sks asc"), LoadLog, Log); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 12 Agro B"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); Thread.Sleep(500); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 11 Agro A"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); GlobalJadwal.GlobalSolusi[2].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[2].Solusi, sql.data_mengajar(2, 1, "11 AGRO A", "guru.nama_guru desc"), LoadLog, Log); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 1a Agro A"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); Thread.Sleep(500); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 11 Agro B"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); GlobalJadwal.GlobalSolusi[3].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[3].Solusi, sql.data_mengajar(2, 1, "11 AGRO B", "mata_pelajaran.mata_pelajaran asc"), LoadLog, Log); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 1a Agro A"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); Thread.Sleep(500); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 10 Agro A"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); GlobalJadwal.GlobalSolusi[4].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[4].Solusi, sql.data_mengajar(1, 1, "10 AGRO A", "NEWID()"), LoadLog, Log); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 10 Agro A"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); Thread.Sleep(500); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 10 Agro B"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); GlobalJadwal.GlobalSolusi[5].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[5].Solusi, sql.data_mengajar(1, 1, "10 AGRO B", "detail_mtp.sks asc"), LoadLog, Log); Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 10 Agro B"; Log.Rows.Add(Row); LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log)); Thread.Sleep(500); //GlobalJadwal.GlobalSolusi[6].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[6].Solusi, sql.data_mengajar(3, 3, "12 PM A", "guru.nama_guru desc")); //GlobalJadwal.GlobalSolusi[7].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[7].Solusi, sql.data_mengajar(3, 3, "12 PM B", "mata_pelajaran.mata_pelajaran asc")); //GlobalJadwal.GlobalSolusi[8].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[8].Solusi, sql.data_mengajar(2, 3, "11 PM A", "detail_mtp.sks desc")); //GlobalJadwal.GlobalSolusi[9].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[9].Solusi, sql.data_mengajar(2, 3, "11 PM B", "NEWID()")); //GlobalJadwal.GlobalSolusi[10].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[10].Solusi, sql.data_mengajar(1, 3, "10 PM A", "guru.nama_guru desc")); //GlobalJadwal.GlobalSolusi[11].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[11].Solusi, sql.data_mengajar(1, 3, "10 PM B", "mata_pelajaran.mata_pelajaran asc")); //GlobalJadwal.GlobalSolusi[12].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[12].Solusi, sql.data_mengajar(3, 5, "12 TKJ A", "detail_mtp.sks desc")); //GlobalJadwal.GlobalSolusi[13].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[13].Solusi, sql.data_mengajar(3, 5, "12 TKJ B", "detail_mtp.sks asc")); //GlobalJadwal.GlobalSolusi[14].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[14].Solusi, sql.data_mengajar(2, 5, "11 TKJ A", "detail_mtp.sks desc")); //GlobalJadwal.GlobalSolusi[15].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[15].Solusi, sql.data_mengajar(2, 5, "11 TKJ B", "detail_mtp.sks asc")); //GlobalJadwal.GlobalSolusi[16].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[16].Solusi, sql.data_mengajar(1, 5, "10 TKJ A", "detail_mtp.sks desc")); //GlobalJadwal.GlobalSolusi[17].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[17].Solusi, sql.data_mengajar(1, 5, "10 TKJ B", "detail_mtp.sks asc")); //GlobalJadwal.GlobalSolusi[18].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[18].Solusi, sql.data_mengajar(1, 5, "10 TKJ k", "detail_mtp.sks desc")); //GlobalJadwal.GlobalSolusi[19].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[19].Solusi, sql.data_mengajar(3, 4, "12 RPL A", "detail_mtp.sks desc")); //GlobalJadwal.GlobalSolusi[20].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[20].Solusi, sql.data_mengajar(3, 4, "12 RPL B", "detail_mtp.sks asc")); //GlobalJadwal.GlobalSolusi[21].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[21].Solusi, sql.data_mengajar(2, 4, "11 RPL A", "detail_mtp.sks desc")); //GlobalJadwal.GlobalSolusi[22].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[22].Solusi, sql.data_mengajar(2, 4, "11 RPL B", "detail_mtp.sks asc")); //GlobalJadwal.GlobalSolusi[23].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[23].Solusi, sql.data_mengajar(1, 4, "10 RPL A", "detail_mtp.sks desc")); //GlobalJadwal.GlobalSolusi[24].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[24].Solusi, sql.data_mengajar(1, 4, "10 RPL B", "detail_mtp.sks asc")); //GlobalJadwal.GlobalSolusi[25].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[25].Solusi, sql.data_mengajar(2, 2, "11 KI A", "rand()")); //GlobalJadwal.GlobalSolusi[26].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[26].Solusi, sql.data_mengajar(2, 2, "11 KI B", "rand()")); //GlobalJadwal.GlobalSolusi[27].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[27].Solusi, sql.data_mengajar(1, 2, "10 KI A", "rand()")); //GlobalJadwal.GlobalSolusi[28].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[28].Solusi, sql.data_mengajar(1, 2, "10 KI B", "rand()")); }
private void btnSave_Click(object sender, EventArgs e) { if (dtgValueCalculate.RowCount > 1) { string contextValue = string.Empty; try { foreach (DataGridViewRow row in dtgDetailHoleID.Rows) { if (row.Cells[0].Value != null && Convert.ToBoolean(row.Cells[0].Value) && !String.IsNullOrEmpty(row.Cells[0].Value.ToString())) { if (row.Cells[1].Value == null) { MessageBox.Show("Select all value Column Vn_mod this select"); return; } } } var culturaCol = CultureInfo.GetCultureInfo("es-CO"); DateTime dateReporte = Convert.ToDateTime(DateTime.Now, culturaCol); foreach (DataGridViewRow row in dtgDetailHoleID.Rows) { if (row.Cells[0].Value != null && Convert.ToBoolean(row.Cells[0].Value) && !String.IsNullOrEmpty(row.Cells[0].Value.ToString())) { contextValue = "UPDATE [dbo].[DH_Samples] SET Vn_mod = '" + row.Cells[1].Value.ToString() + "' WHERE SKDHSamples =" + Convert.ToInt32(row.Cells[dtgDetailHoleID.Columns["SKDHSamples"].Index].Value) + " and HoleID ='" + row.Cells[dtgDetailHoleID.Columns["dhid"].Index].Value.ToString() + "'"; LoadLog.alterdataBase(contextValue); LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "update"); } else { if (row.Cells[dtgDetailHoleID.Columns["Vn_mod_codes"].Index].Value != null && !String.IsNullOrEmpty(row.Cells[dtgDetailHoleID.Columns["Vn_mod_codes"].Index].Value.ToString())) { contextValue = "UPDATE [dbo].[DH_Samples] SET Vn_mod = Null WHERE SKDHSamples =" + Convert.ToInt32(row.Cells[dtgDetailHoleID.Columns["SKDHSamples"].Index].Value) + " and HoleID ='" + row.Cells[dtgDetailHoleID.Columns["dhid"].Index].Value.ToString() + "'"; LoadLog.alterdataBase(contextValue); LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "update"); } } } foreach (DataGridViewRow row in dtgValueCalculate.Rows) { if (row.Cells[1].Value != null && !String.IsNullOrEmpty(row.Cells[1].Value.ToString())) { contextValue = String.Format("SELECT Count(1) FROM DH_IntercepInterval WHERE HoleID = @HoleID and SKDHSamples= @SKDHSamples"); object count = LoadLog.Exist_DB(contextValue, row.Cells[1].Value.ToString(), Convert.ToDecimal(row.Cells[9].Value)); LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "Search"); if (Convert.ToInt32(count) > 0) { string valueDescrioption = string.Empty; if (!string.IsNullOrEmpty(txtComment.Text.Trim())) { //valueDescrioption = string.Concat(txtComent.Text, " Con intervale inicial de ", Convert.ToDecimal(row.Cells[2].Value), " hasta ", valueTo); contextValue = "update dbo.DH_IntercepInterval set Tov=" + Convert.ToDecimal(row.Cells[3].Value) + ",Length_Grade=" + Convert.ToDecimal(row.Cells[4].Value) + ", Au_Grade=" + Convert.ToDecimal(row.Cells[5].Value) + ",Ag_Grade= " + Convert.ToDecimal(row.Cells[6].Value) + ",Comments='" + valueDescrioption + "',TotalRegister=" + Convert.ToInt32(row.Cells[7].Value) + " , Date_Event ='" + dateReporte.ToString() + "' where HoleID ='" + row.Cells[1].Value.ToString() + "' AND SKDHSamples =" + Convert.ToDecimal(row.Cells[9].Value); LoadLog.alterdataBase(contextValue); LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "Update"); } else { MessageBox.Show("Comment is required for the rank update"); return; } } else { contextValue = "INSERT INTO dbo.DH_IntercepInterval(HoleID,Fromv,Tov,Length_Grade,Au_Grade,Ag_Grade,Comments,TotalRegister,Vn_mod,SKDHSamples,Date_Event)VALUES(" + "'" + row.Cells[1].Value.ToString() + "'," + Convert.ToDecimal(row.Cells[2].Value) + " ," + Convert.ToDecimal(row.Cells[3].Value) + "," + Convert.ToDecimal(row.Cells[4].Value) + " ," + Convert.ToDecimal(row.Cells[5].Value) + "," + Convert.ToDecimal(row.Cells[6].Value) + ",'" + txtComment.Text + "'," + Convert.ToInt32(row.Cells[7].Value) + ",'" + row.Cells[8].Value.ToString() + "'," + row.Cells[9].Value.ToString() + ",'" + dateReporte + "')"; LoadLog.alterdataBase(contextValue); LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "Update"); } } } MessageBox.Show("The Calculated items were save successful.", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information); txtComment.Text = String.Empty; lblSavedItems.Visible = false; } catch (Exception ex) { MessageBox.Show("Error:" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("There is not data to save.", "Save", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }