private void cmbOK_Click(object sender, EventArgs e) { CegatanLaporanSPV(); CegatanLaporanYYK(); //if (dtYYK.Rows.Count > 0 || dtSPV.Rows.Count > 0) if (dtYYK.Rows.Count > 0) //mus rubah { //this.Cursor = Cursors.WaitCursor; //using (Database db = new Database()) //{ // db.Commands.Add(db.CreateCommand("rsp_AnalisaOA4Bulan_YYK")); // db.Commands[0].Parameters.Add(new Parameter("@fromdate", SqlDbType.DateTime, rangeDateBox1.FromDate)); // db.Commands[0].Parameters.Add(new Parameter("@todate", SqlDbType.DateTime, rangeDateBox1.ToDate)); // dsDataYYK = db.Commands[0].ExecuteDataSet(); //} DisplayReportYYK(); Pin.frmPinDaily ifrmpin = new Pin.frmPinDaily(this, PinId.Bagian.OAYYK, DateTime.Today, "Pin OA Support/YYK"); ifrmpin.MdiParent = Program.MainForm; Program.MainForm.RegisterChild(ifrmpin); ifrmpin.Show(); } //else if (dtYYK.Rows.Count == 0 && dtSPV.Rows.Count > 0) else if (dtSPV.Rows.Count > 0) //mus rubah { this.Cursor = Cursors.WaitCursor; using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("rsp_AnalisaOA4Bulan_SPV")); db.Commands[0].Parameters.Add(new Parameter("@fromdate", SqlDbType.DateTime, rangeDateBox1.FromDate)); db.Commands[0].Parameters.Add(new Parameter("@todate", SqlDbType.DateTime, rangeDateBox1.ToDate)); dsDataSPV = db.Commands[0].ExecuteDataSet(); } if (dsDataSPV.Tables.Count > 0) { DisplayReportSPV(); } else { MessageBox.Show("Tidak Ada Data"); } Pin.frmPinDaily ifrmpin = new Pin.frmPinDaily(this, PinId.Bagian.OASPV, DateTime.Today, "Pin OA SPV"); ifrmpin.MdiParent = Program.MainForm; Program.MainForm.RegisterChild(ifrmpin); ifrmpin.Show(); } else { Getdata(); } }
private void cmdYes_Click(object sender, EventArgs e) { if (txtPin.Text.ToString().Length != 7) { MessageBox.Show("Pin Yang anda masukan salah, silhakan Ulangi"); txtPin.Text = ""; return; } string baseCode = string.Empty; int multiplier = 1; if (this._bagian == PinId.Bagian.Rekon) { baseCode = key.BaseCode.Rekon; multiplier = 16; } if (this._bagian == PinId.Bagian.PO) { baseCode = key.BaseCode.PO; multiplier = 17; } if (this._bagian == PinId.Bagian.RekonsPJT) { baseCode = key.BaseCode.RekonsPJT; multiplier = 18; } if (this._bagian == PinId.Bagian.OASPV) { baseCode = key.BaseCode.OASPV; multiplier = 25; } if (this._bagian == PinId.Bagian.OAYYK) { baseCode = key.BaseCode.OASupport; multiplier = 26; } string dailyPin = ISA.Pin.key.CreateDailyPin(this._tanggal, GlobalVar.Gudang, baseCode, multiplier); if (txtPin.Text == dailyPin) { //GlobalVar.pinResult = true; if (this.Caller is Rekon.frmrekonclosing) { DataTable dtCekRekon = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_Rekon_Cek_Now")); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, _tanggal)); dtCekRekon = db.Commands[0].ExecuteDataTable(); } if (this._bagian == PinId.Bagian.RekonsPJT) { DataTable dtOVD120 = new DataTable(); DataTable dtpjvspiut = new DataTable(); DataTable dtRekonNow = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_Rekon_List_Now")); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, DateTime.Today)); dtRekonNow = db.Commands[0].ExecuteDataTable(); } using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("psp_rekons_overdue120")); db.Commands[0].Parameters.Add(new Parameter("@tglclosing", SqlDbType.Date, DateTime.Now)); dtOVD120 = db.Commands[0].ExecuteDataTable(); } DateTime tglawalrekon = Convert.ToDateTime(dtRekonNow.Rows[0]["periode1"].ToString()); DateTime tglakhirrekon = Convert.ToDateTime(dtRekonNow.Rows[0]["periode2"].ToString()); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("psp_Rekon_Chek_PJKVSPIUT_Prepare")); db.Commands[0].Parameters.Add(new Parameter("@tglclsawal", SqlDbType.Date, tglawalrekon)); db.Commands[0].Parameters.Add(new Parameter("@tglclsakhir", SqlDbType.Date, tglakhirrekon)); dtpjvspiut = db.Commands[0].ExecuteDataTable(); } int hari = (int)DateTime.Now.DayOfWeek; if (hari == 1) { if (dtpjvspiut.Rows.Count > 0 || dtOVD120.Rows.Count > 0) { Pin.frmPinDaily ifrmChild1 = new Pin.frmPinDaily(this, (Guid)dtCekRekon.Rows[0]["RowID"], PinId.Bagian.Rekon, DateTime.Today, "Pin rekon PJK"); ifrmChild1.MdiParent = Program.MainForm; Program.MainForm.RegisterChild(ifrmChild1); ifrmChild1.Show(); } else { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this._rowID)); db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dt = db.Commands[0].ExecuteDataTable(); db.Commands[0].ExecuteNonQuery(); MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai"); } } } else { if (dtpjvspiut.Rows.Count > 0) { Pin.frmPinDaily ifrmChild1 = new Pin.frmPinDaily(this, (Guid)dtCekRekon.Rows[0]["RowID"], PinId.Bagian.Rekon, DateTime.Today, "Pin rekon PJK"); ifrmChild1.MdiParent = Program.MainForm; Program.MainForm.RegisterChild(ifrmChild1); ifrmChild1.Show(); } else { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this._rowID)); db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dt = db.Commands[0].ExecuteDataTable(); db.Commands[0].ExecuteNonQuery(); MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai"); } } } } } if (this._bagian == PinId.Bagian.Rekon) { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this._rowID)); db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dt = db.Commands[0].ExecuteDataTable(); db.Commands[0].ExecuteNonQuery(); MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai"); } } //using (Database db = new Database()) //{ // DataTable dt = new DataTable(); // db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update")); // db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this._rowID)); // db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text)); // db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); // dt = db.Commands[0].ExecuteDataTable(); // db.Commands[0].ExecuteNonQuery(); // MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai"); //} //if (this.Caller is frmMain) //{ // PSReport.frmLaporanPenjualanPerItem ifrmChild1 = new PSReport.frmLaporanPenjualanPerItem(); // ifrmChild1.MdiParent = Program.MainForm; // Program.MainForm.RegisterChild(ifrmChild1); // ifrmChild1.Show(); //} if (this._bagian == PinId.Bagian.PO) { PSReport.frmLaporanPenjualanPerItem ifrmChild1 = new PSReport.frmLaporanPenjualanPerItem(); ifrmChild1.MdiParent = Program.MainForm; Program.MainForm.RegisterChild(ifrmChild1); ifrmChild1.Show(); } if (this._bagian == PinId.Bagian.OASPV) { MessageBox.Show("Pin Benar, Proses Sudah Selesai"); if (this.Caller is PSReport.frmLaporanAnalisaOA) { PSReport.frmLaporanAnalisaOA frmCaller = (PSReport.frmLaporanAnalisaOA) this.Caller; frmCaller.Getdata(); this.Close(); } } if (this._bagian == PinId.Bagian.OAYYK) { MessageBox.Show("Pin Benar, Proses Sudah Selesai"); if (this.Caller is PSReport.frmLaporanAnalisaOA) { PSReport.frmLaporanAnalisaOA frmCaller = (PSReport.frmLaporanAnalisaOA) this.Caller; frmCaller.Getdata(); this.Close(); } } using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_pin_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@keyNumber", SqlDbType.VarChar, string.Empty)); db.Commands[0].Parameters.Add(new Parameter("@PinNummber", SqlDbType.VarChar, txtPin.Text)); db.Commands[0].Parameters.Add(new Parameter("@id", SqlDbType.Int, _bagian)); db.Commands[0].Parameters.Add(new Parameter("@ket", SqlDbType.Text, txtKet.Text)); dt = db.Commands[0].ExecuteDataTable(); } this.Close(); } else { MessageBox.Show("Pin yang anda masukan salah, cek kembali"); } }
private void prosesclosing_Click(object sender, EventArgs e) { DataTable dtCekRekon = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_Rekon_Cek_Now")); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, tglclosing.DateValue)); dtCekRekon = db.Commands[0].ExecuteDataTable(); } if (dtCekRekon.Rows.Count > 0) { DataTable dtRekonNow = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_Rekon_List_Now")); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, DateTime.Today)); dtRekonNow = db.Commands[0].ExecuteDataTable(); } if (dtRekonNow.Rows.Count > 0) { if (!chekpjt2bkm()) { DisplayReport(); //DisplayReport2(); //chekinden(); Pin.frmPinDaily ifrmChild = new Pin.frmPinDaily(this, (Guid)dtCekRekon.Rows[0]["RowID"], PinId.Bagian.RekonsPJT, DateTime.Today, "Pin rekon PJT "); ifrmChild.MdiParent = Program.MainForm; Program.MainForm.RegisterChild(ifrmChild); ifrmChild.Show(); } #region ditutup inst dwy 20-04-2016 //if (!chekinden() || !chekpjt2bkm()) //{ // MessageBox.Show("Masukkan Pin Rekon PJT"); // Pin.frmPinDaily ifrmChild = new Pin.frmPinDaily(this, (Guid)dtCekRekon.Rows[0]["RowID"], PinId.Bagian.RekonsPJT, DateTime.Today, "Pin rekon PJT "); // ifrmChild.MdiParent = Program.MainForm; // Program.MainForm.RegisterChild(ifrmChild); // ifrmChild.Show(); //} //else //{ // MessageBox.Show("Masukkan Pin Rekon PJK"); // Pin.frmPinDaily ifrmChild2 = new Pin.frmPinDaily(this, (Guid)dtCekRekon.Rows[0]["RowID"], PinId.Bagian.Rekon, DateTime.Today, "Pin rekon PJK "); // ifrmChild2.MdiParent = Program.MainForm; // Program.MainForm.RegisterChild(ifrmChild2); // ifrmChild2.Show(); //} #endregion } else { MessageBox.Show("Sudah Melakukan Closing Rekon"); return; } } else { this.Cursor = Cursors.WaitCursor; int count = 0; #region tutup ////chekrekonAG(); //chekpjt2bkm(); //chekpjvspiut(); //chekinden(); ////chekregister(); ////chekOverdueFU(); //checkOverdue120(); //dt1.Rows.Count >= 1 || dtpj2bkm.Rows.Count >= 1 || dtpjvspiut.Rows.Count >= 1 || dtinden.Rows.Count >=1) //if (!chekinden()) //{ // count = count + 1; //} //if (!chekOverdueFU()) //{ // count = count + 1; //} //if (hari == 1) //{ // if (!checkOverdue120()) // { // count = count + 1; // } //} //if (!chekpjvspiut()) //{ // count = count + 1; //} //if (!chekregister()) //{ // count = count + 1; //} //if (!chekrekonAG()) //{ // count = count + 1; //} #endregion if (!chekpjt2bkm()) { count = count + 1; } if (count > 0) { Save_closing(1, ""); DisplayReport(); //DisplayReport2(); DataTable dtRekonNow = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_Rekon_List_Now")); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, DateTime.Today)); dtRekonNow = db.Commands[0].ExecuteDataTable(); } if (dtRekonNow.Rows.Count > 0) { //if (!chekpjt2bkm()) if (count > 0) { Pin.frmPinDaily ifrmChild = new Pin.frmPinDaily(this, (Guid)dtRekonNow.Rows[0]["RowID"], PinId.Bagian.RekonsPJT, DateTime.Today, "Pin rekon PJT "); ifrmChild.MdiParent = Program.MainForm; Program.MainForm.RegisterChild(ifrmChild); ifrmChild.Show(); } #region ditutup inst dwy 20-04-2016 //if (!chekinden() || !chekpjt2bkm()) //{ // Pin.frmPinDaily ifrmChild = new Pin.frmPinDaily(this, (Guid)dtRekonNow.Rows[0]["RowID"], PinId.Bagian.RekonsPJT, DateTime.Today, "Pin rekon PJT "); // ifrmChild.MdiParent = Program.MainForm; // Program.MainForm.RegisterChild(ifrmChild); // ifrmChild.Show(); //} //else //{ // Pin.frmPinDaily ifrmChild2 = new Pin.frmPinDaily(this, (Guid)dtRekonNow.Rows[0]["RowID"], PinId.Bagian.Rekon, DateTime.Today, "Pin rekon PJK "); // ifrmChild2.MdiParent = Program.MainForm; // Program.MainForm.RegisterChild(ifrmChild2); // ifrmChild2.Show(); //} ////Pin.frmPin ifrmChild = new Pin.frmPin(this, 0, 1, 10, (Guid)dtRekonNow.Rows[0]["RowID"], DateTime.Today); //Pin.frmPinDaily ifrmChild = new Pin.frmPinDaily(this, (Guid)dtRekonNow.Rows[0]["RowID"], PinId.Bagian.Rekon, DateTime.Today, "Pin rekon harian"); //ifrmChild.MdiParent = Program.MainForm; //Program.MainForm.RegisterChild(ifrmChild); //ifrmChild.Show(); #endregion } #region tutup //else //{ // Pin.frmPinDaily ifrmChild = new Pin.frmPinDaily(this, (Guid)dtRekonNow.Rows[0]["RowID"], PinId.Bagian.Rekon, DateTime.Today, "Pin rekon harian PJK"); // ifrmChild.MdiParent = Program.MainForm; // Program.MainForm.RegisterChild(ifrmChild); // ifrmChild.Show(); // Pin.frmPinDaily ifrmChild2 = new Pin.frmPinDaily(this, (Guid)dtRekonNow.Rows[0]["RowID"], PinId.Bagian.RekonsPJT, DateTime.Today, "Pin rekon harian2"); // ifrmChild2.MdiParent = Program.MainForm; // Program.MainForm.RegisterChild(ifrmChild2); // ifrmChild2.Show(); //} #endregion } else { Save_closing(0, ""); } this.Cursor = Cursors.Default; //if (dsOverdouFU.Tables[0].Rows.Count > 0) //{ // MessageBox.Show("Ada toko overdue yang harus di follow up HO. Ambil datanya di c:/Temp/DBFMATCH.DBF lalu kirim ke HO"); //} this.Close(); } }