private bool KeHoachSanXuatTheoTramList_Init() { if (KeHoachSanXuatTheoTramList_Exist == true) { if (tabControl1.TabPages.Contains(KeHoachSanXuatTheoTramList_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, KeHoachSanXuatTheoTramList_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("KeHoachSanXuatTheoTram"); return true; } KeHoachSanXuatTheoTramList_Exist = true; Init_KeHoachSanXuatTheoTram_Excel(); KeHoachSanXuatTheoTramList_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "KeHoachSanXuatTheoTram", ProductionPlanByWorkStation_Index, MasterDatabase_Connection_Str, KeHoachSanXuatTheoTramList_Init_Database_CMD, KeHoachSanXuatTheoTramList_Select_CMD, 3, KeHoachSanXuatTheoTram_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; KeHoachSanXuatTheoTramList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; PosSize possize = new PosSize(); possize.pos_x = 6; possize.pos_y = 6; //Dho-Fixme: Do we need to use the button "Check_BT"? //Check_BT = new Button_Lbl(1, KeHoachSanXuatTheoTramList_MasterDatabase.MasterDatabase_Tab, "Check", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); return true; }
private bool R_007_Emlpoyee_In_WST_Count_Init() { if (R_007_Emlpoyee_In_WST_Count_Exist == true) { if (tabControl1.TabPages.Contains(R_007_Emlpoyee_In_WST_Count_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, R_007_Emlpoyee_In_WST_Count_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("R_007_Emlpoyee_In_WST_Count"); return true; } R_007_Emlpoyee_In_WST_Count_Exist = true; R_007_Emlpoyee_In_WST_Count_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "R_007_Emlpoyee_In_WST_Count", R_007_Emlpoyee_In_WST_Count_Index, MasterDatabase_Connection_Str, R_007_Emlpoyee_In_WST_Count_Init_Database_CMD, R_007_Emlpoyee_In_WST_Count_Select_CMD, 3, R_007_Emlpoyee_In_WST_Excel_Count_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); R_007_Emlpoyee_In_WST_Count_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; R_007_Emlpoyee_In_WST_Count_MasterDatabase.MasterDatabase_GridviewTBL.Privot_BT.Visible = false; R_007_Emlpoyee_In_WST_Count_MasterDatabase.MasterDatabase_GridviewTBL.Delete_All_BT.Visible = false; R_007_Emlpoyee_In_WST_Count_MasterDatabase.MasterDatabase_GridviewTBL.Export_BT.Visible = false; R_007_Emlpoyee_In_WST_Count_MasterDatabase.MasterDatabase_GridviewTBL.Import_BT.Visible = false; R_007_Emlpoyee_In_WST_Count_MasterDatabase.MasterDatabase_GridviewTBL.Submit_BT.Visible = false; PosSize possize = new PosSize(); possize.pos_x = 200; possize.pos_y = 90; R_007_Emlpoyee_In_WST_Count_Create_BT = new Button_Lbl(1, R_007_Emlpoyee_In_WST_Count_MasterDatabase.MasterDatabase_Tab, "Create Report", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); R_007_Emlpoyee_In_WST_Count_Create_BT.My_Button.Click += new EventHandler(R_007_Emlpoyee_In_WST_Count_Create01_BT_Click); return true; }
private bool R_008_Employee_Current_On_Line_Init() { if (R_008_Employee_Current_On_Line_Exist == true) { if (tabControl1.TabPages.Contains(R_008_Employee_Current_On_Line_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, R_008_Employee_Current_On_Line_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("R_008_Employee_Current_On_Line"); return true; } R_008_Employee_Current_On_Line_Exist = true; R_008_Employee_Current_On_Line_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "R_008_Employee_Current_On_Line", R_008_Employee_Current_On_Line_Index, MasterDatabase_Connection_Str, R_008_Employee_Current_On_Line_Select_CMD, R_008_Employee_Current_On_Line_Select_CMD, 3, R_008_Employee_Current_On_Line_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); R_008_Employee_Current_On_Line_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; R_008_Employee_Current_On_Line_MasterDatabase.MasterDatabase_GridviewTBL.GridView.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(R_008_Employee_Current_On_Line_MasterDatabase_GridView_DataBindingComplete); R_008_Employee_Current_On_Line_MasterDatabase.MasterDatabase_GridviewTBL.Privot_BT.Visible = true; R_008_Employee_Current_On_Line_MasterDatabase.MasterDatabase_GridviewTBL.Delete_All_BT.Visible = false; R_008_Employee_Current_On_Line_MasterDatabase.MasterDatabase_GridviewTBL.Submit_BT.Visible = false; R_008_Employee_Current_On_Line_MasterDatabase.MasterDatabase_GridviewTBL.Import_BT.Visible = false; R_008_Employee_Current_On_Line_MasterDatabase.MasterDatabase_GridviewTBL.Export_BT.Visible = false; return true; }
private bool Skill_Mapping_Init() { if (Skill_Mapping_Exist == true) { if (tabControl1.TabPages.Contains(Skill_Mapping_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, Skill_Mapping_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("Skill_Mapping"); return true; } Skill_Mapping_Exist = true; // Init_Line_Desciption_Excel(); Skill_Mapping_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "Skill_Mapping", 0, MasterDatabase_Connection_Str, Skill_Mapping_Init_Database_CMD, Skill_Mapping_Select_CMD, 3, null, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; Skill_Mapping_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; Skill_Mapping_MasterDatabase.MasterDatabase_GridviewTBL.Import_BT.Visible = false; //set role string moduleId = "R_002"; RoleHelper.SetRole(Skill_Mapping_MasterDatabase, moduleId); return true; }
// private void Init_InputFromPlanner_Excel() // { // if (InputFromPlanner_Excel_Struct == null) // { // InputFromPlanner_Excel_Struct = new ExcelImportStruct[5]; // InputFromPlanner_Excel_Struct[0] = new ExcelImportStruct(0, "Date", "Date", Excel_Col_Type.COL_DATE, 20, true); // InputFromPlanner_Excel_Struct[1] = new ExcelImportStruct(1, "PO", "PO", Excel_Col_Type.COL_STRING, 20, false); // InputFromPlanner_Excel_Struct[2] = new ExcelImportStruct(2, "PartNumber", "PartNumber", Excel_Col_Type.COL_STRING, 50, false); // InputFromPlanner_Excel_Struct[3] = new ExcelImportStruct(3, "Qty", "Qty", Excel_Col_Type.COL_INT, 20, false); // InputFromPlanner_Excel_Struct[4] = new ExcelImportStruct(4, "Priority", "Priority", Excel_Col_Type.COL_INT, 20, false); // } // } private bool KittingDatabase_Init() { if (KittingDatabase_Exist == true) { if (tabControl1.TabPages.Contains(KittingDatabase_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, KittingDatabase_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("Kitting"); return true; } KittingDatabase_Exist = true; Init_InputFromPlanner_Excel(); KittingDatabase_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "Kitting", KittingDatabase_Index, Kitting_Connection_Str, KittingDatabase_Init_Database_CMD, KittingDatabase_Select_CMD, 3, null, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; KittingDatabase_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; KittingDatabase_MasterDatabase.MasterDatabase_GridviewTBL.Import_BT.Visible = false; KittingDatabase_MasterDatabase.MasterDatabase_GridviewTBL.Delete_All_BT.Visible = false; KittingDatabase_MasterDatabase.MasterDatabase_GridviewTBL.Delete_Rows_BT.Visible = false; KittingDatabase_MasterDatabase.MasterDatabase_GridviewTBL.Submit_BT.Visible = false; //Dho-Fixme: Do we need to use the button "Check_BT"? // PosSize possize = new PosSize(); // possize.pos_x = 200; // possize.pos_y = 90; // KittingDatabase_Create_BT = new Button_Lbl(1, KittingDatabase_MasterDatabase.MasterDatabase_Tab, "Create", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); // KittingDatabase_Create_BT.My_Button.Click += new EventHandler(KittingDatabase_Create_BT_Click); return true; }
public PlanByDateController(MaterDatabase _masterDb) { masterDb = _masterDb; SqlDataAdapter sqlAdapterLineDescription = null; DataSet dsLineDescription = new DataSet(); tbLineDescription = masterDb.Get_SQL_Data(ApplicationSetting.GetInstance().MasterDatabaseConnectionString, "select * from MDB_003_Line_Desciption", ref sqlAdapterLineDescription, ref dsLineDescription); }
private bool R_007_Emlpoyee_In_WST_Init() { LoadInternalData(); if (R_007_Emlpoyee_In_WST_Exist == true) { if (tabControl1.TabPages.Contains(R_007_Emlpoyee_In_WST_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, R_007_Emlpoyee_In_WST_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("R_007_Emlpoyee_In_WST"); return true; } R_007_Emlpoyee_In_WST_Exist = true; //R_007_Emlpoyee_In_WST_Excel(); R_007_Emlpoyee_In_WST_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "R_007_Emlpoyee_In_WST", R_007_Emlpoyee_In_WST_Index, MasterDatabase_Connection_Str, R_007_Emlpoyee_In_WST_Init_Database_CMD, R_007_Emlpoyee_In_WST_Select_CMD, 3, R_007_Emlpoyee_In_WST_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; R_007_Emlpoyee_In_WST_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; //R_007_Emlpoyee_In_WST_MasterDatabase.MasterDatabase_GridviewTBL.GridView.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(R_007_Emlpoyee_In_WST_Control_MasterDatabase_GridView_DataBindingComplete); R_007_Emlpoyee_In_WST_MasterDatabase.MasterDatabase_GridviewTBL.Privot_BT.Visible = true; PosSize possize = new PosSize(); possize.pos_x = 200; possize.pos_y = 90; R_007_Emlpoyee_In_WST_Create_BT = new Button_Lbl(1, R_007_Emlpoyee_In_WST_MasterDatabase.MasterDatabase_Tab, "Create Report", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); R_007_Emlpoyee_In_WST_Create_BT.My_Button.Click += new EventHandler(R_007_Emlpoyee_In_WST_Create_BT_Click); possize.pos_x = 300; possize.pos_y = 90; R_007_Emlpoyee_In_WST_CountA_Create_BT = new Button_Lbl(1, R_007_Emlpoyee_In_WST_MasterDatabase.MasterDatabase_Tab, "Count", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); R_007_Emlpoyee_In_WST_CountA_Create_BT.My_Button.Click += new EventHandler(R_007_Emlpoyee_In_WST_Count_Create_BT_Click); //set role string moduleId = "R_007"; RoleHelper.SetRole(R_007_Emlpoyee_In_WST_MasterDatabase, moduleId); R_007_Emlpoyee_In_WST_Create_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); R_007_Emlpoyee_In_WST_CountA_Create_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); return true; }
private bool LineLayout_Init() { if (LineLayout_Exist == true) { tabControl1.SelectTab("LineLayout"); return true; } LineLayout_Exist = true; Init_LineLayout_Excel(); LineLayout_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "LineLayout", LineLayout_Index, MasterDatabase_Connection_Str, LineLayout_Init_Database_CMD, LineLayout_Select_CMD, 3, LineLayout_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; LineLayout_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; return true; }
private bool Tracking_View_Init() { if (Tracking_View_Exist == true) { tabControl1.SelectTab("Tracking View"); return true; } Tracking_View_Exist = true; // Init_Line_Desciption_Excel(); Tracking_View_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "Tracking View", 0, MasterDatabase_Connection_Str, Tracking_View_Init_Database_CMD, Tracking_View_Select_CMD, 3, null, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; Tracking_View_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; Tracking_View_MasterDatabase.MasterDatabase_GridviewTBL.Import_BT.Visible = false; return true; }
private bool Empl_Skill_List_Init() { if (Empl_Skill_List_Exist == true) { if (tabControl1.TabPages.Contains(Empl_Skill_List_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, Empl_Skill_List_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("Employee_vs_Skill"); return true; } Empl_Skill_List_Exist = true; Init_Empl_Skill_Excel(); Empl_Skill_List_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "Employee_vs_Skill", SkillList_Index, MasterDatabase_Connection_Str, Empl_Skill_List_Init_Database_CMD, Empl_Skill_List_Select_CMD, 3, Empl_Skill_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; All_Skill_List = new SQL_API.SQL_ATC(MasterDatabase_Connection_Str); string sql_cmd = @"SELECT [Skill_ID] ,[Skill_Name] FROM [MDB_001_Skill_List_Tbl]"; All_Skill_List.GET_SQL_DATA(sql_cmd); DataGridViewMultiColumnComboBoxColumn col = new DataGridViewMultiColumnComboBoxColumn(); col.Name = "Skill_ID"; col.DataPropertyName = "Skill_ID"; col.ValueMember = "Skill_ID"; col.DataSource = All_Skill_List.DaTable; col.ColumnWidths = new List<string>() { "60", "150" }; if (Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns.Contains("Skill_ID")) { int index = Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Skill_ID"].Index; Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns.RemoveAt(index); Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns.Insert(index, col); col.HeaderCell = new DataGridViewAutoFilterColumnHeaderCell(col.HeaderCell); } Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.GridView.CellValueChanged += new DataGridViewCellEventHandler(Empl_Skill_List_MasterDatabase_GridView_CellValueChanged); return true; }
private bool SkillList_Init() { if (SkillList_Exist == true) { if (tabControl1.TabPages.Contains(SkillList_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, SkillList_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("Skill_List"); return true; } SkillList_Exist = true; Init_Skill_Excel(); SkillList_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "Skill_List", SkillList_Index, MasterDatabase_Connection_Str, SkillList_Init_Database_CMD, SkillList_Select_CMD, 3, Skill_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; SkillList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; return true; }
private bool Employee_Working_on_Sunday_Init() { if (Employee_Working_on_Sunday_Exist == true) { if (tabControl1.TabPages.Contains(Employee_Working_on_Sunday_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, Employee_Working_on_Sunday_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("Employee Working on Sunday"); return true; } Employee_Working_on_Sunday_Exist = true; Init_Employee_Working_on_Sunday_Excel(); Employee_Working_on_Sunday_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "Employee Working on Sunday", Employee_Working_on_Sunday_Index, MasterDatabase_Connection_Str, Employee_Working_on_Sunday_Init_Database_CMD, Employee_Working_on_Sunday_Select_CMD, 3, Employee_Working_on_Sunday_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); Employee_Working_on_Sunday_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; return true; }
private bool Leave_Info_Init() { if (Leave_Info_Exist == true) { if (tabControl1.TabPages.Contains(Leave_Info_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, Leave_Info_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("Leave_Info"); return true; } Leave_Info_Exist = true; Init_Leave_Info_Excel(); Leave_Info_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "Leave_Info", Leave_Info_Index, LeaveRegister_Connection_Str, Leave_Info_Init_Database_CMD, Leave_Info_Select_CMD, 3, Leave_Info_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); Leave_Info_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; return true; }
public static void SetRole(MaterDatabase master, string moduleId) { UserInfo userInfo = ApplicationSession.UserLoginInfo; if (userInfo == null) return; if (GetCurrentUserLoginRole(UserRoleName.VIEW_ONLY, moduleId)) { master.MasterDatabase_GridviewTBL.Import_BT.Enabled = false; // sao mình không dùng visible cho nó mất luôn master.MasterDatabase_GridviewTBL.Submit_BT.Enabled = false; master.MasterDatabase_GridviewTBL.Export_BT.Enabled = false; master.MasterDatabase_GridviewTBL.Delete_All_BT.Enabled = false; master.MasterDatabase_GridviewTBL.Delete_Rows_BT.Enabled = false; } else { master.MasterDatabase_GridviewTBL.Import_BT.Enabled = GetCurrentUserLoginRole(UserRoleName.IMPORT, moduleId); //master.MasterDatabase_GridviewTBL.Import_BT.Enabled = userInfo.Roles[moduleId].IsCreate; } }
private bool P001_InputFromPlanner_Init() { if (InputFromPlannerList_Exist == true) { if (tabControl1.TabPages.Contains(InputFromPlannerList_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, InputFromPlannerList_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("P001_InputFromPlanner"); return true; } InputFromPlannerList_Exist = true; Init_InputFromPlanner_Excel(); InputFromPlannerList_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "P001_InputFromPlanner", InputFromPlannerList_Index, MasterDatabase_Connection_Str, InputFromPlannerList_Init_Database_CMD, InputFromPlannerList_Select_CMD, 3, InputFromPlanner_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; InputFromPlannerList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; //Dho-Fixme: Do we need to use the button "Check_BT"? PosSize possize = new PosSize(); possize.pos_x = 200; possize.pos_y = 90; InputFromPlannerList_Create_BT = new Button_Lbl(1, InputFromPlannerList_MasterDatabase.MasterDatabase_Tab, "Create", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); InputFromPlannerList_Create_BT.My_Button.Click += new EventHandler(InputFromPlannerList_Create_BT_Click); //InputFromPlannerList_MasterDatabase.MasterDatabase_GridviewTBL.Import_BT.Enabled RoleHelper.SetRole(InputFromPlannerList_MasterDatabase, "P_001"); InputFromPlannerList_Create_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, "P_001"); //set role string moduleId = "P_001"; RoleHelper.SetRole(InputFromPlannerList_MasterDatabase, moduleId); InputFromPlannerList_Create_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); return true; }
private bool R_009_Line_Status_Init() { if (R_009_Line_Status_Exist == true) { if (tabControl1.TabPages.Contains(R_009_Line_Status_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, R_009_Line_Status_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("R_009_Line_Status"); return true; } R_009_Line_Status_Exist = true; R_009_Line_Status_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "R_009_Line_Status", R_009_Line_Status_Index, MasterDatabase_Connection_Str, R_009_Line_Status_Init_Database_CMD, R_009_Line_Status_Select_CMD, 3, R_009_Line_Status_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); R_009_Line_Status_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; R_009_Line_Status_MasterDatabase.MasterDatabase_GridviewTBL.Privot_BT.Visible = true; R_009_Line_Status_MasterDatabase.MasterDatabase_GridviewTBL.Submit_BT.Visible = false; R_009_Line_Status_MasterDatabase.MasterDatabase_GridviewTBL.Import_BT.Visible = false; R_009_Line_Status_MasterDatabase.MasterDatabase_GridviewTBL.Delete_All_BT.Visible = false; R_009_Line_Status_MasterDatabase.MasterDatabase_GridviewTBL.Review_BT.Visible = false; //R_009_Line_Status_MasterDatabase.MasterDatabase_GridviewTBL.GridView.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(R_009_Line_Status_MasterDatabase_GridView_DataBindingComplete); R_009_Line_Status_MasterDatabase.MasterDatabase_GridviewTBL.GridView.ReadOnly = true; PosSize possize = new PosSize(); possize.pos_x = 200; possize.pos_y = 90; R_009_Line_Status_Create_BT = new Button_Lbl(1, R_009_Line_Status_MasterDatabase.MasterDatabase_Tab, "Refresh", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); R_009_Line_Status_Create_BT.My_Button.Click += new EventHandler(R_009_Line_Status_Create_BT_Click); //set role //string moduleId = "R_009"; //RoleHelper.SetRole(R_009_Line_Status_MasterDatabase, moduleId); //R_009_Line_Status_Create_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); return true; }
private bool P005_EmplWorkingPlan_Init() { if (EmplWorkingPlan_Exist == true) { if (tabControl1.TabPages.Contains(EmplWorkingPlan_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, EmplWorkingPlan_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("P005_EmplPlan"); return true; } EmplWorkingPlan_Exist = true; // Init_EmplWorkingPlan_Excel(); EmplWorkingPlan_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "P005_EmplPlan", EmplWorkingPlan_Index, MasterDatabase_Connection_Str, EmplWorkingPlan_Init_Database_CMD, EmplWorkingPlan_Select_CMD, 3, EmplWorkingPlan_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; EmplWorkingPlan_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; EmplWorkingPlan_MasterDatabase.MasterDatabase_GridviewTBL.Import_BT.Visible = false; EmplWorkingPlan_MasterDatabase.MasterDatabase_GridviewTBL.Review_BT.Visible = false; EmplWorkingPlan_MasterDatabase.MasterDatabase_GridviewTBL.Delete_Rows_BT.Visible = false; PosSize possize = new PosSize(); possize.pos_x = 200; possize.pos_y = 90; EmplWorkingPlan_Create_BT = new Button_Lbl(1, EmplWorkingPlan_MasterDatabase.MasterDatabase_Tab, "Create", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); EmplWorkingPlan_Create_BT.My_Button.Click += new EventHandler(EmplWorkingPlan_Create_BT_Click); EmplWorkingPlan_Create_BT.My_Button.Visible = true; //set role string moduleId = "P_005"; RoleHelper.SetRole(EmplWorkingPlan_MasterDatabase, moduleId); EmplWorkingPlan_Create_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); return true; }
private bool P007_Tracking_View_Init() { if (P007_Tracking_View_Exist == true) { if (tabControl1.TabPages.Contains(P007_Tracking_View_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, P007_Tracking_View_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("P007_Tracking_View"); return true; } P007_Tracking_View_Exist = true; // Init_P007_Tracking_View_Excel(); P007_Tracking_View_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "P007_Tracking_View", P007_Tracking_View_Index, MasterDatabase_Connection_Str, P007_Tracking_View_Init_Database_CMD, P007_Tracking_View_Select_CMD, 3, P007_Tracking_View_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; P007_Tracking_View_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; P007_Tracking_View_MasterDatabase.MasterDatabase_GridviewTBL.GridView.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(P_007_Tracking_Control_MasterDatabase_GridView_DataBindingComplete); //Dho-Fixme: Do we need to use the button "Check_BT"? //PosSize possize = new PosSize(); //possize.pos_x = 200; //possize.pos_y = 90; //P007_Tracking_View_Create_BT = new Button_Lbl(1, P007_Tracking_View_MasterDatabase.MasterDatabase_Tab, "Plan_Empl", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); //P007_Tracking_View_Create_BT.My_Button.Click += new EventHandler(P007_Tracking_View_Create_BT_Click); // khong set role được, vì chưa có tạo nút button nào cả //set role //string moduleId = "P_007"; //RoleHelper.SetRole(P007_Tracking_View_MasterDatabase, moduleId); //P007_Tracking_View_Create_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); return true; }
private bool LineWorkStationMapping_Init() { if (LineWorkStationMapping_Exist == true) { if (tabControl1.TabPages.Contains(LineWorkStationMapping_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, LineWorkStationMapping_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("WorkStationDescription"); return true; } LineWorkStationMapping_Exist = true; Init_LineWorkStationMapping_Excel(); LineWorkStationMapping_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "WorkStationDescription", WorkStationDescription_Index, MasterDatabase_Connection_Str, LineWorkStationMapping_Init_Database_CMD, LineWorkStationMapping_Select_CMD, 3, LineSkillRequest_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; LineWorkStationMapping_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; return true; }
private bool P003_AssignEmpl_Init() { if (P_003_KeHoachSanXuatTheoLine_Exist == true) { if (tabControl1.TabPages.Contains(P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("P003_AssignEmployee"); return true; } if (Running_Mode == Run_Mode.DEBUG) { P_003_KeHoachSanXuatTheoLine_Select_CMD = @"SELECT * FROM [P_003_KeHoachSanXuatTheoLine_Test] "; P_003_KeHoachSanXuatTheoLine_Init_Database_CMD = @"SELECT * FROM [P_003_KeHoachSanXuatTheoLine_Test] WHERE [Date] = ''"; } P_003_KeHoachSanXuatTheoLine_Exist = true; Init_P_003_KeHoachSanXuatTheoLine_Excel(); P_003_KeHoachSanXuatTheoLine_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "P003_AssignEmployee", P_003_KeHoachSanXuatTheoLine_INDEX, MasterDatabase_Connection_Str, P_003_KeHoachSanXuatTheoLine_Init_Database_CMD, P_003_KeHoachSanXuatTheoLine_Select_CMD, 3, P_003_KeHoachSanXuatTheoLine_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.Import_BT.Visible = true; P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.Delete_All_BT.Visible = false; P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.Privot_BT.Visible = true; //Dho-Fixme: Do we need to use the button "Check_BT"? PosSize possize = new PosSize(); possize.pos_x = 200; possize.pos_y = 90; PlanForLine_Create_BT = new Button_Lbl(1, P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_Tab, "Create", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); PlanForLine_Create_BT.My_Button.Click += new EventHandler(PlanForLine_Create_BT_Click); possize.pos_x = 300; possize.pos_y = 90; PlanForLine_Empl_Asign_BT = new Button_Lbl(2, P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_Tab, "Add FRU", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); PlanForLine_Empl_Asign_BT.My_Button.Click += new EventHandler(P_003_KeHoachSanXuatTheoLine_AddFRU_BT_Click); possize.pos_x = 400; possize.pos_y = 90; PlanForLine_Create_FRU_BT = new Button_Lbl(2, P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_Tab, "Assign", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); PlanForLine_Create_FRU_BT.My_Button.Click += new EventHandler(PlanForLine_Empl_Asign_BT_Click); possize.pos_x = 700; possize.pos_y = 90; PlanForLine_DuplicateRow_BT = new Button_Lbl(3, P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_Tab, "Duplicate Current Row", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); PlanForLine_DuplicateRow_BT.My_Button.Click += new EventHandler(PlanForLine_DuplicateRow_BT_Click); //Chỉ cần load danh sách nhân viên available ? //DataTable leave_info = Load_Leave_Register(date); P_003_KeHoachSanXuatTheoLine_tbAllEmployee = Load_All_Empl(); P_003_KeHoachSanXuatTheoLine_tbAllEmployee.PrimaryKey = new DataColumn[] { P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns["Empl_ID"] }; if (P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns.Contains("Cur_Line") == false) { P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns.Add("Cur_Line", typeof(String)); } if (P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns.Contains("Cur_Shift") == false) { P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns.Add("Cur_Shift", typeof(String)); } if (P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns.Contains("Date") == false) { P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns.Add("Date", typeof(DateTime)); } //P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns.Add("Cur_Line", typeof(String)); //P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns.Add("Cur_Shift", typeof(String)); //P_003_KeHoachSanXuatTheoLine_tbAllEmployee.Columns.Add("Date", typeof(DateTime)); DataGridViewMultiColumnComboBoxColumn col = new DataGridViewMultiColumnComboBoxColumn(); col.Name = "Empl_ID"; col.DataPropertyName = "Empl_ID"; col.ValueMember = "Empl_ID"; col.DataSource = P_003_KeHoachSanXuatTheoLine_tbAllEmployee; col.ColumnWidths = new List<string>() { "55", "150", "60", "50", "65" }; if (P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns.Contains("Empl_ID")) { int index = P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Empl_ID"].Index; P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns.RemoveAt(index); P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns.Insert(index, col); col.HeaderCell = new DataGridViewAutoFilterColumnHeaderCell(col.HeaderCell); } P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.GridView.CellValueChanged += new DataGridViewCellEventHandler(P_003_KeHoachSanXuatTheoLine_MasterDatabase_GridView_CellValueChanged); P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.GridView.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(P_003_KeHoachSanXuatTheoLine_MasterDatabase_GridView_DataBindingComplete); //P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.GridView.DataSourceChanged += new EventHandler(P_003_KeHoachSanXuatTheoLine_MasterDatabase_GridView_DataSourceChanged); P_003_KeHoachSanXuatTheoLine_MasterDatabase.MasterDatabase_GridviewTBL.GridView.CellBeginEdit += new DataGridViewCellCancelEventHandler(P_003_KeHoachSanXuatTheoLine_MasterDatabase_GridView_CellBeginEdit); //set role string moduleId = "P_003"; RoleHelper.SetRole(P_003_KeHoachSanXuatTheoLine_MasterDatabase, moduleId); PlanForLine_Create_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); PlanForLine_Empl_Asign_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); PlanForLine_Create_FRU_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); return true; }
private bool P002_PlanByDate_Init() { if (KeHoachSanXuatTheoNgayList_Exist == true) { if (tabControl1.TabPages.Contains(KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_Tab) == false) { tabControl1.TabPages.Insert(tabControl1.TabPages.Count, KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_Tab); } tabControl1.SelectTab("P002_PlanByDate"); return true; } KeHoachSanXuatTheoNgayList_Exist = true; Init_KeHoachSanXuatTheoNgay_Excel(); KeHoachSanXuatTheoNgayList_MasterDatabase = new MaterDatabase(OpenXL, tabControl1, "P002_PlanByDate", ProductionPlanByDate_Index, MasterDatabase_Connection_Str, KeHoachSanXuatTheoNgayList_Init_Database_CMD, KeHoachSanXuatTheoNgayList_Select_CMD, 3, KeHoachSanXuatTheoNgay_Excel_Struct, filterStatusLabel, showAllLabel, StatusLabel1, StatusLabel2, ProgressBar1); // Empl_Skill_List_MasterDatabase.MasterDatabase_GridviewTBL.dataGridView_View.Columns["Line_ID"].Frozen = true; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.BackgroundColor = Color.White; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.Privot_BT.Visible = true; planByDateController = new PlanByDateController(KeHoachSanXuatTheoNgayList_MasterDatabase); //Dho-Fixme: Do we need to use the button "Check_BT"? PosSize possize = new PosSize(); possize.pos_x = 200; possize.pos_y = 90; PlanByDate_Create_BT = new Button_Lbl(1, KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_Tab, "Create", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); PlanByDate_Create_BT.My_Button.Click += new EventHandler(PlanByDate_Create_BT_Click); possize.pos_x = 300; possize.pos_y = 90; PlanByDate_Calculate_BT = new Button_Lbl(1, KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_Tab, "Calculate", possize, (AnchorStyles)AnchorStyles.Left | AnchorStyles.Top); PlanByDate_Calculate_BT.My_Button.Click += new EventHandler(Button_Calculte_Click); possize.pos_x = 700; possize.pos_y = 90; txtTotalRequireResource = new TextBox_Lbl(1, KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_Tab, "Total", TextBox_Type.TEXT, possize, AnchorType.LEFT); txtTotalRequireResource.My_TextBox.ReadOnly = true; txtTotalRequireResource.My_TextBox.TextAlign = HorizontalAlignment.Right; txtTotalRequireResource.My_TextBox.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); possize.pos_x = 880; txtInterestRequireResource = new TextBox_Lbl(1, KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_Tab, "Ratio increasing", TextBox_Type.TEXT, possize, AnchorType.LEFT); txtInterestRequireResource.My_TextBox.Location = new Point(possize.pos_x + 100, possize.pos_y); txtInterestRequireResource.My_TextBox.ReadOnly = true; txtInterestRequireResource.My_TextBox.TextAlign = HorizontalAlignment.Right; txtInterestRequireResource.My_TextBox.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); dtOneShiftGroup = planByDateController.GetShiftGroup(PlanByDateController.SHIFT_GROUP_TYPE_ONE); dtThreeShiftGroup = planByDateController.GetShiftGroup(PlanByDateController.SHIFT_GROUP_TYPE_THREE); dtTwoShiftGroup = planByDateController.GetShiftGroup(PlanByDateController.SHIFT_GROUP_TYPE_TWO); //add column ShiftNamePerLine -> allow manual shiftname on line DataGridViewMultiColumnComboBoxColumn col = new DataGridViewMultiColumnComboBoxColumn(); col.Name = "ShiftNamePerLine"; col.DataPropertyName = "ShiftNamePerLine"; col.DataSource = dtThreeShiftGroup; col.ValueMember = "GroupName"; col.ColumnNames = new List<string> { "GroupName" }; col.ColumnWidths = new List<string>() { "200" }; if (KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns.Contains("ShiftNamePerLine")) { int index = KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["ShiftNamePerLine"].Index; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns.RemoveAt(index); KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns.Insert(index, col); } //end add column ShiftNamePerLine KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.ColumnHeadersHeight = 50; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["TotalShiftPerLine"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Capacity"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["NumOfShift"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["NumOfPerson_Per_Day"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_1_Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_2_Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_3_Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["NumOfPerson_Per_Day"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["TotalShiftPerLine"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Capacity"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["NumOfShift"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Priority"].Width = 50; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_1_From"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_1_To"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_1_Qty"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_1_Main"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_2_From"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_2_To"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_2_Main"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_2_Qty"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_3_From"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_3_To"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_3_Qty"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_3_Main"].Width = 70; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["ShiftNamePerLine"].HeaderText = "Shift name per line"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["TotalShiftPerLine"].HeaderText = "Total shift per line"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["NumOfShift"].HeaderText = "Num of shift"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["NumOfPerson_Per_Day"].HeaderText = "Num Of Person Per Day"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_1_From"].HeaderText = "Shift_1 From"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_1_To"].HeaderText = "Shift_1 To"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_1_Qty"].HeaderText = "Shift_1 Qty"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_1_Main"].HeaderText = "Shift_1 Main"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_2_From"].HeaderText = "Shift_2 From"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_2_To"].HeaderText = "Shift_2 To"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_2_Qty"].HeaderText = "Shift_2 Qty"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_2_Main"].HeaderText = "Shift_2 Main"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_3_From"].HeaderText = "Shift_3 From"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_3_To"].HeaderText = "Shift_3 To"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_3_Qty"].HeaderText = "Shift_3 Qty"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.Columns["Shift_3_Main"].HeaderText = "Shift_3 Main"; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.EditMode = DataGridViewEditMode.EditOnEnter; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.Delete_Rows_BT.Visible = true; KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.CellValueChanged += new DataGridViewCellEventHandler(KeHoachSanXuatTheoNgayList_MasterDatabase_GridView_CellValueChanged); KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.CellContentClick += new DataGridViewCellEventHandler(KeHoachSanXuatTheoNgayList_MasterDatabase_GridView_CellContentClick); KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(KeHoachSanXuatTheoNgayList_MasterDatabase_GridView_DataBindingComplete); KeHoachSanXuatTheoNgayList_MasterDatabase.MasterDatabase_GridviewTBL.GridView.CellBeginEdit += new DataGridViewCellCancelEventHandler(KeHoachSanXuatTheoNgayList_MasterDatabase_GridView_CellBeginEdit); //set role string moduleId = "P_002"; RoleHelper.SetRole(KeHoachSanXuatTheoNgayList_MasterDatabase, moduleId); PlanByDate_Create_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); PlanByDate_Calculate_BT.My_Button.Enabled = RoleHelper.GetCurrentUserLoginRole(UserRoleName.CREATE, moduleId); return true; }