private void ArrangeGrid()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("#", 50); //0
dct.Add("Theme", 80); //1
dct.Add("Strategy", 190); //2
dct.Add("Description", 270); //3
dct.Add("Org.Budget", 120); //4
dct.Add("Rev.Budget", 120); //5
dct.Add("Service Plan", 210); //6
dct.Add("Manager", 210); //7
dct.Add("cpwID", 0); //8
dct.Add("ThemeID", 0); //9
dct.Add("Strat_Obj_id", 0); //10
dct.Add("DirectorID", 0); //11
dct.Add("ServicePlanID", 0); //12
dct.Add("ManagerID", 0); //13
dct.Add("ThemeColor", 0); //14
dct.Add("JobNo", 100); //15
dct.Add("CarryOver", 0); //16
int[] hiddenRows = { 8, 9, 10, 11, 12, 13, 14, 16 };
//int[] hiddenRows = { };
MyGridUtils.ArrangeDataGrid(dgv01, dct, hiddenRows, Color.LightGray, Color.LightSteelBlue);
this.dgv01.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv01.RowTemplate.MinimumHeight = 28;
dgv01.ReadOnly = true;
}
private void ArrangeGrid()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("ID", 50); //0
dct.Add("Description", 400); //1
dct.Add("Source", 100); //2
dct.Add("Prefix", 130); //3
dct.Add("Target", 100); //4
dct.Add("Unit", 130); //5
dct.Add("ReportFrequency", 150); //6
dct.Add("Department", 200); //7
dct.Add("HowMeasured", 0); //8
dct.Add("Year", 0); //9
dct.Add("StrategyID", 0); //10
dct.Add("ManagerID", 0); //11
dct.Add("DirectorID", 0); //12
dct.Add("PrefixID", 0); //13
dct.Add("UnitID", 0); //14
int[] hiddenRows = { 8, 9, 10, 11, 12, 13, 14 };
MyGridUtils.ArrangeDataGrid(dgv01, dct, hiddenRows, Color.LightGray, Color.LightSteelBlue);
this.dgv01.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgv01.RowTemplate.MinimumHeight = 28;
dgv01.ReadOnly = true;
}
private void GrdAction()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("ID", 100);
dct.Add("action_rank", 0);
dct.Add("Description", 790);
dct.Add("Performance Indicator", 0);
dct.Add("action_partner_org", 0);
dct.Add("strategy_id", 0);
dct.Add("performance_indicator_id", 0);
dct.Add("ramanager_id", 0);
dct.Add("manager_name", 0);
dct.Add("director_id", 0);
dct.Add("director_name", 0);
dct.Add("Color", 0);
dct.Add("Service Plan", 200);
dct.Add("spid", 0);
dct.Add("Council Plan", 200);
dct.Add("CouncilPlanID", 0);
int[] hiddenRows = { 1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15 };
MyGridUtils.ArrangeDataGrid(grdAction, dct, hiddenRows, Color.LightGray, Color.LightSteelBlue);
grdAction.ReadOnly = true;
}
private void ArrangeCWPGrid()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("ID", 100); //0
dct.Add("Description", 800); //1
//---------INSERT CHECKBOX COULMN-- //
//dct.Add("Check", 100); //2
int[] hiddenRows = { };
int[] readonlyrows = { 0, 1 };
MyGridUtils.ArrangeDataGrid(dgv03, dct, hiddenRows);
dgv03.RowTemplate.MinimumHeight = 28;
dgv03.DefaultCellStyle.BackColor = Color.Beige;
foreach (int i in readonlyrows)
{
dgv03.Columns[i].ReadOnly = true;
dgv03.Columns[i].DefaultCellStyle.BackColor = Color.LightGray;
dgv03.Columns[i].DefaultCellStyle.ForeColor = Color.Black;
}
//----ADD Check box column---
AddCheckBoxColumn(dgv03, "dgv03X");
dgv03.SelectionMode = DataGridViewSelectionMode.CellSelect;
}
private void ArrangeGrid()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("#", 35); //0
dct.Add("cpwID", 0); //1
dct.Add("Service", 200); //2
dct.Add("Description", 530); //3
dct.Add("Org.Budget", 120); //4
dct.Add("Rev.Budget", 120); //5
dct.Add("Projected", 120); //6
int[] hiddenRows = { 1 };
int[] readonlyrows = { 0, 1, 2, 3, 4, 5 };
MyGridUtils.ArrangeDataGrid(dgv01, dct, hiddenRows);
dgv01.DefaultCellStyle.BackColor = Color.Beige;
this.dgv01.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv01.RowTemplate.MinimumHeight = 28;
foreach (int i in readonlyrows)
{
this.dgv01.Columns[i].ReadOnly = true;
this.dgv01.Columns[i].DefaultCellStyle.BackColor = Color.LightGray;
this.dgv01.Columns[i].DefaultCellStyle.ForeColor = Color.Black;
}
dgv01.SelectionMode = DataGridViewSelectionMode.CellSelect;
}
private void ArrangeKPMGrid()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("ID", 100); //1
dct.Add("Description", 800); //2
//---------INSERT CHECKBOX COULMN-- //
int[] hiddenRows = { };
int[] readonlyrows = { 0, 1 };
for (int i = 0; i < dgvList.Count; i++)
{
MyGridUtils.ArrangeDataGrid(dgvList[i], dct, hiddenRows);
dgvList[i].RowTemplate.MinimumHeight = 28;
dgvList[i].DefaultCellStyle.BackColor = Color.Beige;
foreach (int j in readonlyrows)
{
dgvList[i].Columns[j].ReadOnly = true;
dgvList[i].Columns[j].DefaultCellStyle.BackColor = Color.LightGray;
dgvList[i].Columns[j].DefaultCellStyle.ForeColor = Color.Black;
}
//----ADD Check box column---
AddCheckBoxColumn(dgvList[i], dgvList[i].Name.ToString() + "X");
dgvList[i].SelectionMode = DataGridViewSelectionMode.CellSelect;
}
}
private void ArrangeDataGridView()
{
Dictionary <string, int> coloumnDict = new Dictionary <string, int>();
coloumnDict.Add("Code", 0); //0
coloumnDict.Add("Measure", 500); //1
coloumnDict.Add("Measured Against", 250); //2
coloumnDict.Add("Target June-2021", 120); //3
coloumnDict.Add("Progress", 100); //4
coloumnDict.Add("Comments", 500); //5
coloumnDict.Add("strategy_id", 0); //6
coloumnDict.Add("Exist", 100); //7
int[] hiddenRows = { 0, 6, 7 };
//int[] readonlyrows = { 0, 1, 2, 3, 6 };
MyGridUtils.ArrangeDataGrid(dgv, coloumnDict, hiddenRows);
dgv.RowTemplate.MinimumHeight = 28;
dgv.DefaultCellStyle.BackColor = Color.Beige;
foreach (int i in readonlyrows)
{
dgv.Columns[i].ReadOnly = true;
dgv.Columns[i].DefaultCellStyle.BackColor = Color.LightGray;
dgv.Columns[i].DefaultCellStyle.ForeColor = Color.Black;
}
dgv.SelectionMode = DataGridViewSelectionMode.CellSelect;
}
private void ArrangeGrid()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("JCNo", 80); //1
dct.Add("CarryOver", 100); //2
int[] hiddenRows = { };
int[] readonlyrows = { };
MyGridUtils.ArrangeDataGrid(dg1, dct, hiddenRows);
}
private void ArrangeGridParam()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("ID", 50);
dct.Add("Year", 100);
dct.Add("Month", 100);
int[] hiddenRows = { };
MyGridUtils.ArrangeDataGrid(grd1, dct, hiddenRows, Color.LightGray, Color.LightSteelBlue);
grd1.ReadOnly = true;
}
private void ArrangeDataGridView()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("#", 60); //0
dct.Add("Theme", 0); //1
dct.Add("Action_id", 0); //2
dct.Add("Action", 750); //3
dct.Add("Target Date", 100); //4
dct.Add("manager_id", 0); //5
dct.Add("Responsible Manager", 200); //6
//---------INSERT COMBOBOXCOLOUMN-- //7
dct.Add("", 10); //8
dct.Add("Progress", 60); //9
dct.Add("Remarks", 500); //10
dct.Add("theme_color", 0); //10
dct.Add("Status_color", 0); //11
dct.Add("NEW_Flag", 0); //12
dct.Add("BStatus", 0); //13
dct.Add("BProgress", 0); //14
dct.Add("BRemarks", 0); //15
int[] hiddenRows = { 1, 2, 5, 10, 11, 12, 13, 14, 15 };
int[] readonlyrows = { 0, 1, 2, 3, 4, 5, 6, 10, 11, 12, 13, 14, 15 };
MyGridUtils.ArrangeDataGrid(dgv01, dct, hiddenRows);
dgv01.RowTemplate.MinimumHeight = 28;
dgv01.DefaultCellStyle.BackColor = Color.Beige;
foreach (int i in readonlyrows)
{
dgv01.Columns[i].ReadOnly = true;
dgv01.Columns[i].DefaultCellStyle.BackColor = Color.LightGray;
dgv01.Columns[i].DefaultCellStyle.ForeColor = Color.Black;
}
//dgv01.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv01.SelectionMode = DataGridViewSelectionMode.CellSelect;
}
private void ArrangeGrid()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("#", 30); //0
dct.Add("cpwID", 0); //1
dct.Add("Service", 150); //2
dct.Add("Description", 400); //3
dct.Add("Revised-Council", 120); //4
dct.Add("YTD", 120); //5
dct.Add("Projected", 120); //6
dct.Add("% Comp.", 120); //7
dct.Add("Comment", 300); //8
dct.Add("BProjected", 100); //9
dct.Add("B% Comp.", 100); //10
dct.Add("BComment", 100); //11
dct.Add("NEFlag", 50); //12 //0-NEW 1-EDIT
int[] hiddenRows = { 1, 9, 10, 11, 12 };
//int[] hiddenRows = { };
int[] readonlyrows = { 0, 1, 2, 3, 4, 5, 9, 10, 11, 12 };
//int[] hiddenRows = { 1 };
MyGridUtils.ArrangeDataGrid(dgv01, dct, hiddenRows);
dgv01.RowTemplate.MinimumHeight = 28;
dgv01.DefaultCellStyle.BackColor = Color.Beige;
foreach (int i in readonlyrows)
{
dgv01.Columns[i].ReadOnly = true;
this.dgv01.Columns[i].DefaultCellStyle.BackColor = Color.LightGray;
this.dgv01.Columns[i].DefaultCellStyle.ForeColor = Color.Black;
}
this.dgv01.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv01.SelectionMode = DataGridViewSelectionMode.CellSelect;
}
private void GrdDelivery()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
//dct.Add("-", 30);
dct.Add("Year", 100);
int[] hiddenRows = { };
MyGridUtils.ArrangeDataGrid(grdDelivery, dct, hiddenRows, Color.LightGray, Color.LightSteelBlue);
//DataGridViewCalendarColumn col = new DataGridViewCalendarColumn();
//col.HeaderText = "Target Date";
//col.Width = 100;
//this.grdDelivery.Columns.Add(col);
grdDelivery.ReadOnly = false;
grdDelivery.Columns[0].ReadOnly = true;
}
private void ArrangeGrids()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("#", 50); //0
dct.Add("kpi_id", 0); //1
dct.Add("Description", 550); //2
dct.Add("Prefix", 50); //3
dct.Add("Est.", 60); //4
dct.Add("Unit", 50); //5
dct.Add("ManagerID", 0); //6
dct.Add("Progress", 80); //7
dct.Add("Remarks", 600); //8
dct.Add("kpm_id", 0); //9
dct.Add("BProgress", 0); //7
dct.Add("BRemarks", 0); //8
int[] hiddenRows = { 1, 6, 9, 10, 11 };
//int[] hiddenRows = { };
int[] readonlyrows = { 0, 1, 2, 3, 4, 5, 6, 9, 10, 11 };
for (int x = 0; x < 3; x++)
{
MyGridUtils.ArrangeDataGrid(dgv[x], dct, hiddenRows);
dgv[x].RowTemplate.MinimumHeight = 28;
dgv[x].DefaultCellStyle.BackColor = Color.Beige;
foreach (int i in readonlyrows)
{
dgv[x].Columns[i].ReadOnly = true;
dgv[x].Columns[i].DefaultCellStyle.BackColor = Color.LightGray;
dgv[x].Columns[i].DefaultCellStyle.ForeColor = Color.Black;
}
dgv[x].Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv[x].Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv[x].Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgv[x].Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv[x].SelectionMode = DataGridViewSelectionMode.CellSelect;
}
}
private void ArrangeGrid()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("JCNo", 80); //1
dct.Add("Description", 490); //2
dct.Add("Org.Budget", 90); //3
dct.Add("Rev.Budget", 90); //4
dct.Add("Service", 150); //5
dct.Add("Directore", 150); //6
dct.Add("Manager", 150); //7
dct.Add("ServiceID", 50); //8
dct.Add("DirectorID", 50); //9
dct.Add("ManagerID", 50); //10
dct.Add("YTD", 50); //11
int[] hiddenRows = { };
int[] readonlyrows = { };
MyGridUtils.ArrangeDataGrid(dg1, dct, hiddenRows);
}
private void ArrangeGrids()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("#", 50); //0
dct.Add("ID", 0); //1
dct.Add("Description", 500); //2
dct.Add("PrefixID", 0); //3
dct.Add("Prefix", 130); //4
dct.Add("Value", 55); //5
dct.Add("UnitID", 0); //6
dct.Add("Unit", 45); //7
dct.Add("ManagerID", 0); //8
dct.Add("Manager", 230); //9
dct.Add("Est.Year", 60); //10
dct.Add("SP_ID", 0); //11
dct.Add("Service Plan", 230); //12
dct.Add("STATUS", 50); //13
dct.Add("BDescription", 0); //2
dct.Add("BPrefixID", 0); //3
dct.Add("BValue", 0); //5
dct.Add("BUnitID", 0); //6
dct.Add("BManagerID", 0); //8
dct.Add("BSP_ID", 0); //11
dct.Add("BSTATUS", 0); //13
int[] hiddenRows = { 1, 3, 6, 8, 11, 14, 15, 16, 17, 18, 19, 20 };
//int[] hiddenRows = { };
for (int i = 0; i < dgvList.Count; i++)
{
MyGridUtils.ArrangeDataGrid(dgvList[i], dct, hiddenRows, Color.LightGray, Color.LightSteelBlue);
dgvList[i].RowTemplate.MinimumHeight = 28;
dgvList[i].ReadOnly = true;
}
}
private void ArrangeGrid()
{
Dictionary <string, int> dct = new Dictionary <string, int>();
dct.Add("#", 35); //0
dct.Add("cpwID", 0); //1
dct.Add("Service", 250); //2
dct.Add("Description", 490); //3
dct.Add("Org.Budget", 150); //4
dct.Add("Rev.Budget", 150); //5
dct.Add("YTD", 150); //6
dct.Add("YtoD copy", 0); //7
dct.Add("NEFlag", 0); //8 == 0-NEW, 1-EDIT
dct.Add("jobno", 0); //9
int[] hiddenRows = { 1, 7, 8, 9 };
int[] readonlyrows = { 0, 1, 2, 3, 4, 5, 7, 8, 9 };
MyGridUtils.ArrangeDataGrid(dgv01, dct, hiddenRows);
dgv01.RowTemplate.MinimumHeight = 28;
dgv01.DefaultCellStyle.BackColor = Color.Beige;
this.dgv01.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgv01.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
foreach (int i in readonlyrows)
{
dgv01.Columns[i].ReadOnly = true;
this.dgv01.Columns[i].DefaultCellStyle.BackColor = Color.LightGray;
this.dgv01.Columns[i].DefaultCellStyle.ForeColor = Color.Black;
}
dgv01.SelectionMode = DataGridViewSelectionMode.CellSelect;
}
