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