public void SetKpiNormdistGroupGrid()
{
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Normdist_Group objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Normdist_Group();
objBSC.Iestterm_ref_id = this.IEstTermRefID;
objBSC.Iresult_input_type = ddlResultInput.SelectedValue;
objBSC.Ikpi_code = txtKPICode.Text.Trim();
objBSC.Ikpi_name = txtKPIName.Text.Trim();
objBSC.Ichampion_emp_name = txtChamName.Text.Trim();
int iest_dept_id = (ddlEstDept.SelectedValue.Trim() == "") ? -1 : int.Parse(ddlEstDept.SelectedValue);
objBSC.Iuse_yn = "";
objBSC.Itxr_user = int.Parse(gUserInfo.Emp_Ref_ID.ToString());
objBSC.INormdistGroup = (ddlsNormdistGroup.SelectedValue.Trim() == "") ? "" : ddlsNormdistGroup.SelectedValue.ToString();
objBSC.INormdist_Use_YN = (ddlNormdistYN.SelectedValue.Trim() == "") ? "": ddlNormdistYN.SelectedValue.ToString();
DataSet ds = objBSC.GetNormdistList(
objBSC.Iestterm_ref_id
, objBSC.Iresult_input_type
, objBSC.Ikpi_code
, objBSC.Ikpi_name
, objBSC.Iuse_yn
, objBSC.Ichampion_emp_name
, iest_dept_id
, PageUtility.GetByValueDropDownList(ddlKpiGroupRefID)
, objBSC.INormdistGroup
, objBSC.INormdist_Use_YN
, objBSC.Itxr_user);
ugrdKpiList.Clear();
ugrdKpiList.DataSource = ds;
ugrdKpiList.DataBind();
//lblCountRow.Text = "Total Rows : " + ds.Tables[0].Rows.Count.ToString();
}
protected int UpdateKpiNormdistUseYN()
{
CheckBox chk;
UltraGridRow row;
TemplatedColumn col;
bool isOK = false;
string isSuccessed = "0";
int intTxrUser = gUserInfo.Emp_Ref_ID;
int intRtn = 0;
int intRow = ugrdKpiList.Rows.Count;
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Normdist_Group objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Normdist_Group();
for (int i = 0; i < intRow; i++)
{
row = ugrdKpiList.Rows[i];
col = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox");
if (chk.Checked)
{
chk.Checked = false;
int iEstterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo);
int iKpiCode = Convert.ToInt32(row.Cells.FromKey("KPI_REF_ID").Value.ToString());
string iNormdistGroup = Convert.ToString(row.Cells.FromKey("NORMDIST_GROUP").Value.ToString());
intRtn += objBSC.UpdateData(iEstterm_ref_id
, iKpiCode
, iNormdistGroup
, "N"
, intTxrUser);
}
}
return(intRtn);
}
