/************************************************************
* Function name : BindGrid
* Purpose : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
#region public void BindGrid()
public void BindGrid()
{
try
{
string[] xParams = new string[8];
DataTable xDt = null;
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
if (!string.IsNullOrEmpty(txtRes_From.Text))
{
xParams[2] = txtRes_From.Text.Trim().Replace("'", "''");
}
if (!string.IsNullOrEmpty(txtRes_To.Text))
{
xParams[3] = txtRes_To.Text.Trim().Replace("'", "''");
}
if (!string.IsNullOrEmpty(txtRes_NM.Text))
{
xParams[4] = txtRes_NM.Text.Replace("'", "''");
}
xParams[5] = "Y";
xParams[6] = "GRID";
xParams[7] = "RESULT";
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_m_survey_md",
"GetSurveyInfo",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR",
(object)xParams);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
private void BindGrid()
{
try
{
string[] xParams = null;
DataTable xDt = null;
if (string.IsNullOrEmpty(this.txtCourseNM.Text) && this.ddlCourseLang.SelectedItem.Text == "*" && this.ddlCourseType.SelectedItem.Text == "*")
{
// 조회조건이 없을 경우 처리
xParams = new string[2];
xParams[0] = iPageSize.ToString(); // pageSize
xParams[1] = this.CurrentPageIndex.ToString(); // currentPageIndex
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_course_md",
"GetCourseInfo",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
}
else
{
// 조회조건이 있을 경우 처리
xParams = new string[6];
xParams[0] = iPageSize.ToString(); // pagesize
xParams[1] = this.CurrentPageIndex.ToString(); // currentPageIndex
xParams[2] = this.txtCourseNM.Text; // course_nm
xParams[3] = this.ddlCourseLang.SelectedItem.Value.Replace("*", ""); // course_lang
xParams[4] = this.ddlCourseType.SelectedItem.Value.Replace("*", ""); // course_type
xParams[5] = iCourseType;
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_course_md",
"GetCourseInfoByCondition",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
}
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = iPageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = iPageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow) throw;
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
#region private void BindGrid()
private void BindGrid()
{
try
{
string[] xParams = null;
DataTable xDt = null;
// 조회조건이 있을 경우 처리
xParams = new string[6];
xParams[0] = this.PageSize.ToString(); // pagesize
xParams[1] = this.CurrentPageIndex.ToString(); // currentPageIndex
xParams[2] = this.txtContentsNM.Text; // contents_nm
xParams[3] = this.txtRemark.Text; // remark
xParams[4] = this.ddlContentsLang.SelectedItem.Value.Replace("*", ""); // lang
xParams[5] = this.ddlContentsType.SelectedItem.Value.Replace("*", ""); // contents_type
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_course_md",
"GetPopContentsList",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 특정 (등록)과정의 과목 & 컨텐츠 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
private void BindGrid()
{
try
{
if (!string.IsNullOrEmpty(this.txtCourseID.Value))
{
string[] xParams = new string[1];
xParams[0] = this.txtCourseID.Value; // course_id
DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_content_md",
"GetContentsMixInfoOfCourse",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count > 0)
{
this.txtCourseNM.Text = xDt.Rows[0]["course_nm"].ToString();
}
C1Column col_0 = (C1Column)this.C1WebGrid1.Columns[0];
C1Column col_1 = (C1Column)this.C1WebGrid1.Columns[1];
col_0.Visible = true;
col_0.RowMerge = RowMergeEnum.Free;
col_0.GroupInfo.Position = GroupPositionEnum.None;
col_1.Visible = true;
col_1.RowMerge = RowMergeEnum.Free;
col_1.GroupInfo.Position = GroupPositionEnum.None;
}
else
{
C1WebGrid1.DataSource = null;
C1WebGrid1.DataBind();
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private void BindGrid()
{
try
{
string[] xParams = new string[3];
//xParams[0] = this.PageSize.ToString(); // pagesize
//xParams[1] = this.CurrentPageIndex.ToString(); // pageno
xParams[2] = this.ddlCourseField.SelectedItem.Value.ToString();
iGridDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_manage_md", // Class Name
"GetMenuGroup", // Mehtod Name
LMS_SYSTEM.MAIN, // Project Type
"CLT.WEB.UI.LMS.MANAGE", // NameSpace Name
(object)xParams); // Page Info
C1WebGrid1.DataSource = iGridDt;
C1WebGrid1.DataBind();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
//if (iGridDt.Rows.Count < 1)
//{
// this.PageInfo1.TotalRecordCount = 0;
// this.PageInfo1.PageSize = this.PageSize;
// this.PageNavigator1.TotalRecordCount = 0;
//}
//else
//{
// this.PageInfo1.TotalRecordCount = Convert.ToInt32(iGridDt.Rows[0]["totalrecordcount"]);
// this.PageInfo1.PageSize = this.PageSize;
// this.PageNavigator1.TotalRecordCount = Convert.ToInt32(iGridDt.Rows[0]["totalrecordcount"]);
//}
//this.PageInfo1.RecordCount = iGridDt.Rows.Count; //Convert.ToInt32(iGridDt.Rows[0]["totalrecordcount"]);
//this.PageNavigator1.RecordCount = 0;//iGridDt.Rows.Count; //Convert.ToInt32(iGridDt.Rows[0]["totalrecordcount"]);
}
/************************************************************
* Function name : BindGrid
* Purpose : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
#region public void BindGrid()
public void BindGrid()
{
try
{
string[] xParams = new string[4];
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = this.txtMail_From.Text;
xParams[3] = this.txtMail_To.Text;
DataTable xDt = new DataTable();
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_m_mail_md",
"GetMailListMaster",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION", (object)xParams);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
public void BeginGrid()
{
try
{
string[] xParams = new string[1];
//if (string.IsNullOrEmpty(txtZipcode.Text))
//{
// Response.Write("<script language='javascript'>alert('검색할 회사명을 입력해 주세요!');</script>");
// return;
//}
if (Request.QueryString["USERGROUP"].ToString() != "000001") // 관리자가 아니면
{
xParams[0] = Request.QueryString["COMPANY_ID"].ToString();
}
else
{
xParams[0] = txtZipcode.Text;
}
// 소속회사 검색
DataTable xdt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md",
"GetCompanySearch",
LMS_SYSTEM.MANAGE,
"CLT.WEB.UI.LMS.MANAGE",
(object)xParams);
C1WebGrid1.DataSource = xdt;
C1WebGrid1.DataBind();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 특정 (등록)과정의 과목 & 컨텐츠 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
private void BindGrid()
{
try
{
if (!string.IsNullOrEmpty(this.txtCourseID.Value))
{
string[] xParams = new string[1];
xParams[0] = this.txtCourseID.Value; // course_id
DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_textbook_md",
"GetTextBookMixInfoOfCourse",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count > 0)
{
this.txtCourseNM.Text = xDt.Rows[0]["course_nm"].ToString();
}
}
else
{
C1WebGrid1.DataSource = null;
C1WebGrid1.DataBind();
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
#region BindGrid()
public void BindGrid()
{
try
{
string[] xParams = new string[7];
DataTable xDt = null;
DataTable xDtSocialpos = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_m_survey_md",
"GetUSERSOCIALPOS",
LMS_SYSTEM.COMMUNITY,
"CLT.WEB.UI.LMS.COMMUNITY",
(object)new string[1] {
Session["USER_ID"].ToString()
});
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = Session["USER_ID"].ToString();
xParams[3] = Session["USER_GROUP"].ToString();
xParams[4] = Session["COMPANY_ID"].ToString();
xParams[5] = Session["DUTY_STEP"].ToString();
if (xDtSocialpos.Rows.Count > 0)
{
xParams[6] = xDtSocialpos.Rows[0]["SOCIALPOS"].ToString();
}
else
{
xParams[6] = string.Empty;
}
if (Request.QueryString["OPEN_COURSE_ID"] != null)
{
xParams[3] = Request.QueryString["OPEN_COURSE_ID"].ToString();
//xParams[4] = Request.QueryString["USER_ID"].ToString();
}
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_m_survey_md",
"GetAnswerSuveyInfo",
LMS_SYSTEM.COMMUNITY,
"CLT.WEB.UI.LMS.COMMUNITY",
(object)xParams);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 교재 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
private void BindGrid()
{
try
{
string[] xParams = null;
DataTable xDt = null;
if (string.IsNullOrEmpty(this.txtTextBookNM.Text) && string.IsNullOrEmpty(this.txtBeginDt.Text) && string.IsNullOrEmpty(this.txtEndDt.Text) && this.ddlTextBookType.SelectedItem.Text == "*" && this.ddlCourseGroup.SelectedItem.Text == "*" && this.ddlCourseField.SelectedItem.Text == "*" && this.ddlTextBookLang.SelectedItem.Text == "*")
{
// 조회조건이 없을 경우 처리
xParams = new string[2];
xParams[0] = this.PageSize.ToString(); // pagesize
xParams[1] = this.CurrentPageIndex.ToString(); // currentPageIndex
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_textbook_md",
"GetTextBookInfo",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams);
}
else
{
// 조회조건이 있을 경우 처리
xParams = new string[9];
xParams[0] = this.PageSize.ToString(); // pagesize
xParams[1] = this.CurrentPageIndex.ToString(); // currentPageIndex
xParams[2] = this.txtTextBookNM.Text; // textbook_nm
xParams[3] = this.ddlTextBookType.SelectedItem.Value.Replace("*", ""); // textbook_type
xParams[4] = this.ddlCourseGroup.SelectedItem.Value.Replace("*", ""); // course_group
xParams[5] = this.ddlCourseField.SelectedItem.Value.Replace("*", ""); // course_field
xParams[6] = this.ddlTextBookLang.SelectedItem.Value.Replace("*", ""); // textbook_lang
xParams[7] = this.txtBeginDt.Text; // ins_begin_dt
xParams[8] = this.txtEndDt.Text; // ins_end_dt
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_textbook_md",
"GetTextBookInfoByCondition",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams);
}
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
#region BindGrid()
public void BindGrid()
{
try
{
this.C1WebGrid1.DataBind();
string[] xParams = new string[14];
DataTable xDt = null;
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = string.Empty; // 회사명
xParams[3] = string.Empty; // 직급
xParams[4] = string.Empty; // 신분
xParams[5] = string.Empty; // 입사일자
xParams[6] = string.Empty; // 한글성명
xParams[7] = string.Empty; // 사용자 그룹
xParams[8] = string.Empty; // 주민번호
xParams[9] = string.Empty; // 상태
xParams[10] = Session["USER_GROUP"].ToString(); //string.Empty; // 조회하는 로그인된 사용자그룹 *중요한 정보!!!
xParams[11] = Session["COMPANY_ID"].ToString(); //string.Empty; // 조회하는 로그인된 사용자의 업체ID(Company_ID) *중요한 정보!!!
xParams[12] = Session["USER_ID"].ToString(); //ViewState["UserIDInfo"].ToString(); // 조회하는 로그인된 사용자의 ID
xParams[13] = "Y";
string[] xParamUser = new string[1];
xParamUser[0] = ViewState["UserIDInfo"].ToString();
//DataTable xDtUser = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md",
// "GetUser",
// LMS_SYSTEM.MANAGE,
// "CLT.WEB.UI.LMS.MANAGE.vp_m_manage_user_list_wpg",
// (object)xParamUser);
//if (xDtUser.Rows.Count == 0)
// return;
//DataRow xDrv = xDtUser.Rows[0];
//xParams[10] = xDrv["user_group"].ToString();
//xParams[11] = xDrv["company_id"].ToString();
if (!string.IsNullOrEmpty(txtCompany.Text))
{
xParams[2] = txtCompany.Text.Replace("'", "''");
}
if (ddlDutyStep.SelectedValue != "*")
{
xParams[3] = ddlDutyStep.SelectedValue;
}
if (!string.IsNullOrEmpty(txtUserName.Text))
{
xParams[6] = txtUserName.Text.Replace("'", "''");
}
if (ddlUserGroup.SelectedValue != "*")
{
xParams[7] = ddlUserGroup.SelectedValue;
}
if (!string.IsNullOrEmpty(txtPersonal_No.Text))
{
xParams[8] = txtPersonal_No.Text.Replace("'", "''");
}
if (ddlStatus.SelectedItem.Text != "*")
{
xParams[9] = ddlStatus.SelectedItem.Value;
}
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md",
"GetUserInfo",
LMS_SYSTEM.MANAGE,
"CLT.WEB.UI.LMS.MANAGE",
(object)xParams);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
public void BindGrid(string rMasterCode)
{
try
{
string[] xParams = new string[8];
DataTable xDt = null;
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = string.Empty;
xParams[3] = string.Empty;
xParams[4] = string.Empty;
xParams[5] = string.Empty;
xParams[6] = rMasterCode;
xParams[7] = "GRID";
if (!string.IsNullOrEmpty(this.txtM_CD.Text))
{
xParams[2] = this.txtM_CD.Text.Replace("'", "''"); // Master Code
}
if (!string.IsNullOrEmpty(this.txtM_DESC.Text))
{
xParams[3] = this.txtM_DESC.Text.Replace("'", "''"); // Master Code 명
}
if (!string.IsNullOrEmpty(this.txtM_ENM.Text))
{
xParams[4] = this.txtM_ENM.Text.Replace("'", "''"); // Master Code 영문명
}
if (!string.IsNullOrEmpty(this.txtM_KNM.Text))
{
xParams[5] = this.txtM_KNM.Text.Replace("'", "''"); // Master Code 한글명
}
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_detailcode_md",
"GetDetailCode",
LMS_SYSTEM.MANAGE,
"CLT.WEB.UI.LMS.MANAGE", (object)xParams);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
// 페이지 처리
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : SMS 전송 리스트를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
#region public void BindGrid()
public void BindGrid()
{
try
{
if (!string.IsNullOrEmpty(txtSMS_From.Text) && string.IsNullOrEmpty(txtSMS_To.Text))
{
ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "조회기간" }, new string[] { "Date To" }, Thread.CurrentThread.CurrentCulture)); return;
}
else if (string.IsNullOrEmpty(txtSMS_From.Text) && !string.IsNullOrEmpty(txtSMS_To.Text))
{
ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "조회기간" }, new string[] { "Date From" }, Thread.CurrentThread.CurrentCulture)); return;
}
string[] xParams = new string[5];
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
if (rbBooking.Checked == true) // 예약발송일 경우
{
xParams[2] = "Y";
}
else
{
xParams[2] = "N";
}
xParams[3] = this.txtSMS_From.Text;
xParams[4] = this.txtSMS_To.Text;
DataTable xDt = new DataTable();
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_m_sms_md",
"GetSMSListMaster",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION", (object)xParams);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
#region public void BindGrid()
public void BindGrid()
{
try
{
if (!string.IsNullOrEmpty(txtCurr_From.Text) && string.IsNullOrEmpty(txtCurr_To.Text))
{
ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A039", new string[] { "조회기간" }, new string[] { "Period" }, Thread.CurrentThread.CurrentCulture));
return;
}
else if (string.IsNullOrEmpty(txtCurr_From.Text) && !string.IsNullOrEmpty(txtCurr_To.Text))
{
ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A039", new string[] { "조회기간" }, new string[] { "Period" }, Thread.CurrentThread.CurrentCulture));
return;
}
string[] xParams = new string[9];
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = Session["USER_ID"].ToString();
xParams[3] = this.ddlDate.SelectedValue;
xParams[4] = this.txtCurr_From.Text;
xParams[5] = this.txtCurr_To.Text;
xParams[6] = this.txtCus_ID.Text; // 과정 ID
if (this.ddlCourseType.SelectedValue != "*")
{
xParams[7] = this.ddlCourseType.SelectedValue;
}
else
{
xParams[7] = string.Empty;
}
xParams[8] = Session["USER_GROUP"].ToString();
DataTable xDt = new DataTable();
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_g_courseapplication_md",
"GetCourseApplication",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION.courseapplication", (object)xParams, Thread.CurrentThread.CurrentCulture);
C1WebGrid1.DataSource = xDt;
C1WebGrid1.DataBind();
if (xDt.Rows.Count < 1)
{
this.PageInfo1.TotalRecordCount = 0;
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
this.PageInfo1.PageSize = this.PageSize;
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
