示例#1
0
    private void TxrExtScore()
    {
        DataTable dtScore = new DataTable("BSC_EST_DEPT_EXT_SCORE");

        dtScore.Columns.Add("ESTTERM_REF_ID", typeof(int));
        dtScore.Columns.Add("YMD", typeof(string));
        dtScore.Columns.Add("EST_DEPT_REF_ID", typeof(int));
        dtScore.Columns.Add("WEIGHT_INR", typeof(double));
        dtScore.Columns.Add("WEIGHT_EXT", typeof(double));
        dtScore.Columns.Add("POINTS_EXT", typeof(double));
        dtScore.Columns.Add("TXR_USER", typeof(int));

        DataRow dr     = null;
        int     intRow = ugrdExtScore.Rows.Count;

        for (int i = 0; i < intRow; i++)
        {
            dr = dtScore.NewRow();
            dr["ESTTERM_REF_ID"]  = Convert.ToInt32(ugrdExtScore.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value.ToString());
            dr["YMD"]             = ugrdExtScore.Rows[i].Cells.FromKey("YMD").Value.ToString();
            dr["EST_DEPT_REF_ID"] = Convert.ToInt32(ugrdExtScore.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value.ToString());
            dr["WEIGHT_INR"]      = Convert.ToDouble(ugrdExtScore.Rows[i].Cells.FromKey("WEIGHT_INR").Value.ToString());
            dr["WEIGHT_EXT"]      = Convert.ToDouble(ugrdExtScore.Rows[i].Cells.FromKey("WEIGHT_EXT").Value.ToString());
            dr["POINTS_EXT"]      = Convert.ToDouble(ugrdExtScore.Rows[i].Cells.FromKey("POINTS_EXT").Value.ToString());

            dtScore.Rows.Add(dr);
        }

        Biz_Bsc_Est_Dept_Ext_Score objBSC = new Biz_Bsc_Est_Dept_Ext_Score();
        int intRtn = objBSC.InsertAll(dtScore, gUserInfo.Emp_Ref_ID);

        ltrScript.Text = JSHelper.GetAlertScript("총 [" + intRow.ToString() + "]건중 [" + intRtn.ToString() + "]건이 처리되었습니다.", false);
    }
示例#2
0
    private void SetExtEstScoreGrid()
    {
        Biz_Bsc_Est_Dept_Ext_Score objBSC = new Biz_Bsc_Est_Dept_Ext_Score();
        DataSet rDs = objBSC.GetAllList(this.IEstTermRefID, this.IYMD, this.IDeptTypeRefID);

        ugrdExtScore.Clear();
        ugrdExtScore.DataSource = rDs;
        ugrdExtScore.DataBind();

        chkApplyFirstRow.Checked = false;
    }