void Button_Calculte_Click(object sender, EventArgs e)
 {
     //    FormatDataGridViewDisplay();
     DateSelect_Dialog_Form selectDate_Dialog = new DateSelect_Dialog_Form(DateTime.Now.AddDays(1));
     if (selectDate_Dialog.ShowDialog() == DialogResult.OK)
     {
         bool b = KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.Update_SQL_Data(KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.Data_da, KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.Data_dtb);
         if (b)
         {
             DateTime dt = selectDate_Dialog.Select_Date;
             //load data by date
             b = KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.Load_DataBase(MasterDatabase_Connection_Str, String.Format("SELECT * FROM [P_002_PlanForProductionByDate] WHERE [Date] = '{0}' order by SubLine_ID", dt.ToString("yyyy-MMM-dd")));
             if (b)
             {
                 String ret = Calculate(dt);
                 if (!String.IsNullOrEmpty(ret))
                 {
                     MessageBox.Show(ret);
                 }
             }
         }
         else
         {
         }
     }
 }
 private void CreatePlanforDateToolStripMenuItem_Click(object sender, EventArgs e)
 {
     DateTime date;
     DateSelect_Dialog_Form selectDate_Dialog = new DateSelect_Dialog_Form(DateTime.Now.AddDays(1));
     if (selectDate_Dialog.ShowDialog() == DialogResult.OK)
     {
         date = selectDate_Dialog.Select_Date;
         Create_All_Plan_for_Date(date);
     }
 }
 private void btn_Create_All_Plan_Click(object sender, EventArgs e)
 {
     DateTime date;
     // Hien thi chon ngay
     DateSelect_Dialog_Form selectDate_Dialog = new DateSelect_Dialog_Form(DateTime.Now.AddDays(1));
     if (selectDate_Dialog.ShowDialog() == DialogResult.OK)
     {
         date = selectDate_Dialog.Select_Date;
         Create_All_Plan_for_Date(date);
     }
 }
        void P007_Tracking_View_Create_BT_Click(object sender, EventArgs e)
        {
            DateTime date;

            DateSelect_Dialog_Form selectDate_Dialog = new DateSelect_Dialog_Form(DateTime.Now);
            if (selectDate_Dialog.ShowDialog() == DialogResult.OK)
            {
                date = selectDate_Dialog.Select_Date;
                P007_Tracking_Get_Plan_Empl(date);
            }
        }
 void P_003_KeHoachSanXuatTheoLine_AddFRU_BT_Click(object sender, EventArgs e)
 {
     DateTime date;
     // Hien thi chon ngay
     DateSelect_Dialog_Form selectDate_Dialog = new DateSelect_Dialog_Form(DateTime.Now.AddDays(1));
     if (selectDate_Dialog.ShowDialog() == DialogResult.OK)
     {
         date = selectDate_Dialog.Select_Date;
         Add_FRU_For_Line(date);
     }
 }
 void PlanForLine_Empl_Asign_BT_Click(object sender, EventArgs e)
 {
     DateTime date;
     DateSelect_Dialog_Form selectDate_Dialog = new DateSelect_Dialog_Form(DateTime.Now);
     if (selectDate_Dialog.ShowDialog() == DialogResult.OK)
     {
         date = selectDate_Dialog.Select_Date;
         Assign_Empl_for_LinePlan(date);
     }
 }