void Link2_CreateMarginalHeaderArea(object sender, CreateAreaEventArgs e)
{
string sHeader = null;
TextBrick brick = default(TextBrick);
sHeader = "Progress Details";
brick = e.Graph.DrawString(sHeader, Color.Navy, new RectangleF(0, 20, 600, 40), BorderSide.None);
brick.Font = new Font("Arial", 11, FontStyle.Bold);
brick.StringFormat = new BrickStringFormat(StringAlignment.Near);
if (Convert.ToInt32(barcboProject.EditValue) > 0)
{
sHeader = "(" + cboCostCentre.GetDisplayText(Convert.ToInt32(barcboProject.EditValue));
}
if (barcboProgress.EditValue.ToString() != "")
{
sHeader = String.Format("{0}-{1}", sHeader, cboType.GetDisplayText(barcboProgress.EditValue));
}
if (barcboFlatType.EditValue.ToString() != "")
{
sHeader = String.Format("{0}-{1}", sHeader, cboFlatType.GetDisplayText(barcboFlatType.EditValue));
}
if (Convert.ToInt32(barcboBlock.EditValue) > 0)
{
sHeader = String.Format("{0}-{1})", sHeader, CboBlock.GetDisplayText(Convert.ToInt32(barcboBlock.EditValue)));
TextBrick brick1 = default(TextBrick);
brick1 = e.Graph.DrawString(sHeader, Color.Navy, new RectangleF(0, 20, 800, 100), BorderSide.None);
brick1.Font = new Font("Arial", 9, FontStyle.Bold);
brick1.StringFormat = new BrickStringFormat(StringAlignment.Near);
}
}
private void PopulateHandingCheckList(int argCCID)
{
m_ds = new DataSet();
string sFlatTypeId = barcboFlatType.EditValue.ToString();
m_ds = m_oProgress.GetHandingCheckList(argCCID, sFlatTypeId, m_sType);
DataTable dtB = new DataTable();
DataTable dtL = new DataTable();
DataTable dtF = new DataTable();
DataTable dtFList = new DataTable();
DataTable dtBTotal = new DataTable();
DataTable dtBComp = new DataTable();
dtB = m_ds.Tables["Block"];
dtL = m_ds.Tables["Level"];
dtF = m_ds.Tables["Flats"];
dtFList = m_ds.Tables["FlatCheckList"];
dtBTotal = m_ds.Tables["BlockTotal"];
dtBComp = m_ds.Tables["BlockComp"];
DataTable dt = new DataTable();
dt = m_ds.Tables["CheckList"];
DataView dv;
int iBlockId = 0;
string sBlockName = "";
int iCheckListId = 0;
int iTotal = 0; int iTTotal = 0;
int iComp = 0; int iTComp = 0;
string sStr = ""; string sTotalStr = "";
DataRow[] drT;
for (int j = 0; j < dtB.Rows.Count; j++)
{
iTTotal = 0;
iTComp = 0;
iBlockId = Convert.ToInt32(dtB.Rows[j]["BlockId"].ToString());
sBlockName = dtB.Rows[j]["BlockName"].ToString();
dt.Columns.Add(sBlockName, typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
iCheckListId = Convert.ToInt32(dt.Rows[i]["CheckListId"].ToString());
iComp = 0;
sStr = "";
dv = new DataView(dtBTotal);
dv.RowFilter = String.Format("BlockId = {0} and CheckListId = {1}", iBlockId, iCheckListId);
if (dv.ToTable().Rows.Count > 0)
{
iTotal = Convert.ToInt32(dv.ToTable().Rows[0]["CFlat"].ToString());
}
else
{
iTotal = 0;
}
dv.Dispose();
if (iTotal > 0)
{
dv = new DataView(dtBComp);
dv.RowFilter = String.Format("BlockId = {0} and CheckListId = {1}", iBlockId, iCheckListId);
if (dv.ToTable().Rows.Count > 0)
{
iComp = Convert.ToInt32(dv.ToTable().Rows[0]["CFlat"].ToString());
}
dv.Dispose();
}
if (iTotal == iComp)
{
sStr = "C";
}
else
{
sStr = String.Format("{0}/{1}", iComp.ToString().Trim(), iTotal.ToString().Trim());
}
drT = dt.Select(String.Format("CheckListId = {0} ", iCheckListId));
if (drT.Length > 0)
{
iTComp = iTComp + iComp; iTTotal = iTTotal + iTotal;
sTotalStr = String.Format("{0}/{1}", iTComp.ToString().Trim(), iTTotal.ToString().Trim());
drT[0][sBlockName] = sStr;
}
}
}
int iCom = 0, iTot = 0;
if (dt.Rows.Count > 0)
{
for (int k = 0; k < dt.Rows.Count; k++)
{
int iTCom = 0, iTTot = 0;
for (int j = 3; j < dt.Columns.Count; j++)
{
string s = dt.Rows[k][j].ToString();
string[] sT = s.Split('/');
if (s == "C")
{
iCom = 0; iTot = 0;
}
else
{
iCom = Convert.ToInt32(CommFun.IsNullCheck(sT[0], CommFun.datatypes.vartypenumeric));
iTot = Convert.ToInt32(CommFun.IsNullCheck(sT[1], CommFun.datatypes.vartypenumeric));
}
iTCom = iTCom + iCom; iTTot = iTTot + iTot;
}
dt.Rows[k]["Total"] = String.Format("{0}/{1}", iTCom.ToString().Trim(), iTTot.ToString().Trim());
}
}
grdAbs.DataSource = dt;
grdAbsView.PopulateColumns();
grdAbsView.Columns["CheckListId"].Visible = false;
grdAbsView.Columns["CheckListName"].Width = 200;
grdAbsView.Columns["Total"].VisibleIndex = dt.Columns.Count - 1;
grdAbsView.Columns["CheckListName"].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
for (int i = 2; i < grdAbsView.Columns.Count; i++)
{
grdAbsView.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
CboBlock.DataSource = dtB;
CboBlock.ValueMember = "BlockId";
CboBlock.DisplayMember = "BlockName";
CboBlock.ForceInitialize();
CboBlock.PopulateColumns();
CboBlock.Columns["BlockId"].Visible = false;
CboBlock.ShowFooter = false;
CboBlock.ShowHeader = false;
barcboBlock.EditValue = null;
cboLevel.DataSource = dtL;
cboLevel.ValueMember = "LevelId";
cboLevel.DisplayMember = "LevelName";
cboLevel.ForceInitialize();
cboLevel.PopulateColumns();
cboLevel.Columns["LevelId"].Visible = false;
cboLevel.Columns["SortOrder"].Visible = false;
cboLevel.ShowFooter = false;
cboLevel.ShowHeader = false;
barcboLevel.EditValue = null;
grdDetails.DataSource = null;
}
