private void SetGridBind()
{
MicroBSC.BSC.Biz.Biz_Bsc_Est_Dept_Grade objGrade = new MicroBSC.BSC.Biz.Biz_Bsc_Est_Dept_Grade();
DataSet rDs = objGrade.GetAllList(this.IEstTermRefID, PageUtility.GetIntByValueDropDownList(ddlDeptType));
ugrdGradeList.Clear();
ugrdGradeList.DataSource = rDs;
ugrdGradeList.DataBind();
if (PageUtility.GetIntByValueDropDownList(ddlDeptType) < 1)
{
iBtnUpdate.Visible = false;
ImgBtnAddRow.Visible = false;
}
else
{
iBtnUpdate.Visible = true;
ImgBtnAddRow.Visible = true;
}
}
private int UpdateGrade()
{
UltraGridRow row;
int intTxrUser = gUserInfo.Emp_Ref_ID;
int intRtn = 0;
int intRow = ugrdGradeList.Rows.Count;
MicroBSC.BSC.Biz.Biz_Bsc_Est_Dept_Grade objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Est_Dept_Grade();
CheckBox chkTempGradeYN;
TemplatedColumn grade_col = (TemplatedColumn)ugrdGradeList.Columns.FromKey("MID_GRADE_YN");
DropDownList ddlTempYN;
TemplatedColumn yn_col = (TemplatedColumn)ugrdGradeList.Columns.FromKey("USE_YN");
for (int i = 0; i < intRow; i++)
{
row = ugrdGradeList.Rows[i];
string iType = Convert.ToString(row.Cells.FromKey("ITYPE").Value.ToString());
int iEstterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo);
int iEstDeptType = (row.Cells.FromKey("EST_DEPT_TYPE").Value == null) ? 0 : Convert.ToInt32(row.Cells.FromKey("EST_DEPT_TYPE").Value.ToString());
int iGradeRefId = (row.Cells.FromKey("GRADE_REF_ID").Value == null) ? 0 : Convert.ToInt32(row.Cells.FromKey("GRADE_REF_ID").Value.ToString());
string iGradeName = row.Cells.FromKey("GRADE_NAME").ToString();
double iMinValue = Convert.ToDouble(row.Cells.FromKey("MIN_VALUE").Value);
double iMaxValue = Convert.ToDouble(row.Cells.FromKey("MAX_VALUE").Value);
chkTempGradeYN = (CheckBox)((CellItem)grade_col.CellItems[ugrdGradeList.Rows[i].BandIndex]).FindControl("chkMidGrade_YN");
int iSort_order = Convert.ToInt32(row.Cells.FromKey("SORT_ORDER").Value.ToString());
ddlTempYN = (DropDownList)((CellItem)yn_col.CellItems[ugrdGradeList.Rows[i].BandIndex]).FindControl("ddlUse_YN");
int iuser = intTxrUser;
if (iType == "U")
{
intRtn += objBSC.UpdateData(iEstterm_ref_id
, iEstDeptType
, iGradeRefId
, iGradeName
, iMinValue
, iMaxValue
, (chkTempGradeYN.Checked == true)? "Y": "N"
, iSort_order
, ddlTempYN.SelectedValue.ToString()
, iuser);
}
else if (iType == "A")
{
intRtn += objBSC.InsertData(iEstterm_ref_id
, iEstDeptType
, iGradeRefId
, iGradeName
, iMinValue
, iMaxValue
, (chkTempGradeYN.Checked == true) ? "Y" : "N"
, iSort_order
, ddlTempYN.SelectedValue.ToString()
, iuser);
}
}
return(intRtn);
}
public DataSet GetEstDeptRank(int iestterm_ref_id, string iymd, int idept_type, string isum_type
, int est_dept_id, string showChildDept, bool includeExtScore, int itxr_user)
{
Biz_Bsc_Est_Dept_Grade objGrd = new Biz_Bsc_Est_Dept_Grade();
DataSet dsGrade = objGrd.GetAllList(iestterm_ref_id, idept_type);
DataSet dsRank = new DataSet();
if (includeExtScore)
{
dsRank = base.GetEstDeptRankList(iestterm_ref_id, iymd, idept_type, isum_type, est_dept_id, showChildDept, includeExtScore, itxr_user);
}
else
{
dsRank = base.GetEstDeptRankList(iestterm_ref_id, iymd, idept_type, isum_type, est_dept_id, showChildDept, itxr_user);
}
dsRank.Tables[0].Columns.Add("RANK_PERCENT", typeof(double));
dsRank.Tables[0].Columns.Add("DEPT_GRADE", typeof(string));
int intRankRow = dsRank.Tables[0].Rows.Count;
int intGrdeRow = dsGrade.Tables[0].Rows.Count;
if (intGrdeRow < 1)
{
return(dsRank);
}
double currRank = 0;
double lastRank = 0;
double minValue = 0;
double maxValue = 0;
double grdValue = 0;
double midValue = 0;
grdValue = Math.Round((double.Parse(intRankRow.ToString()) / double.Parse(intGrdeRow.ToString())), 0);
grdValue = (grdValue < 1) ? 1 : grdValue;
midValue = (intGrdeRow * grdValue - intRankRow);
//int intMidRank = -1;
//for (int i = 0; i < intGrdeRow; i++)
//{
// if (dsGrade.Tables[0].Rows[i]["MID_GRADE_YN"].ToString() == "Y")
// {
// intMidRank = i;
// }
// if (intMidRank < i)
// {
// dsGrade.Tables[0].Rows[i]["MIN_VALUE"] = (i + 1) * grdValue;
// }
// else if (intMidRank == i)
// {
// dsGrade.Tables[0].Rows[i]["MIN_VALUE"] = ((i + 1) * grdValue) + midValue * -1;
// }
// else
// {
// dsGrade.Tables[0].Rows[i]["MIN_VALUE"] = ((i + 1) * grdValue) + midValue * -1;
// }
// if (intMidRank >= i)
// {
// intMidRank += 1;
// }
//}
//for (int i = 0; i < intRankRow; i++)
//{
// currRank = Convert.ToDouble(dsRank.Tables[0].Rows[i]["RANK_ID"].ToString());
// dsRank.Tables[0].Rows[i]["RANK_PERCENT"] = currRank ;
// for (int j = 0; j < intGrdeRow; j++)
// {
// minValue = Convert.ToDouble(dsGrade.Tables[0].Rows[j]["MIN_VALUE"].ToString());
// if (currRank <= minValue)
// {
// dsRank.Tables[0].Rows[i]["DEPT_GRADE"] = dsGrade.Tables[0].Rows[j]["GRADE_NAME"].ToString();
// break;
// }
// }
//}
if (intRankRow > 0)
{
try
{
lastRank = Convert.ToDouble(dsRank.Tables[0].Rows[intRankRow - 1]["RANK_ID"].ToString());
}
catch
{
lastRank = 0;
}
if (intRankRow <= intGrdeRow)
{
for (int i = 0; i < intRankRow; i++)
{
dsRank.Tables[0].Rows[i]["DEPT_GRADE"] = dsGrade.Tables[0].Rows[i]["GRADE_NAME"].ToString();
}
}
else
{
for (int i = 0; i < intRankRow; i++)
{
currRank = (lastRank == 0 ? 0 : Math.Round(((i + 1) / lastRank) * 100, 4));
dsRank.Tables[0].Rows[i]["RANK_PERCENT"] = currRank;
double dScore = Convert.ToDouble(dsRank.Tables[0].Rows[i]["SCORE"].ToString());
for (int j = 0; j < intGrdeRow; j++)
{
minValue = Convert.ToDouble(dsGrade.Tables[0].Rows[j]["MIN_VALUE"].ToString());
maxValue = Convert.ToDouble(dsGrade.Tables[0].Rows[j]["MAX_VALUE"].ToString());
if (dScore >= minValue && dScore <= maxValue)
{
dsRank.Tables[0].Rows[i]["DEPT_GRADE"] = dsGrade.Tables[0].Rows[j]["GRADE_NAME"].ToString();
break;
}
}
}
}
}
return(dsRank);
}