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); }
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; }