//[1]그리드 바인딩
private void DisplayData()
{
//[1]ds
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_NTx nBsl = new Is.Notice.Bsl.Notice_NTx())
{
//[2]Fill
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ListSCM_Sales", "");
if (ds.Tables[0].Rows.Count > 0)
{
//[3]Bind
ctlNoticeList.DataSource = ds;
ctlNoticeList.DataBind();
}
else
{
lblError.Text = "공지사항이 없습니다";
}
}
}
catch (Exception err)
{
//[4]Exception
Response.Write(err.Source + " : " + err.Message);
}
}
//[1]그리드 바인딩
private void DisplayData()
{
//[1]
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_NTx bsl = new Is.Notice.Bsl.Notice_NTx())
{
//[2]Fill
//ds = bsl.ListNotice();
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ListSCM_Sales", salesman1);
if (ds.Tables[0].Rows.Count > 0)
{
//[3]Bind
ctlNoticeList.DataSource = ds;
ctlNoticeList.DataBind();
}
else
{
//lblNoticeError.Text = "공지사항이 없습니다";
}
}
}
catch (Exception err)
{
//
}
}
//[1]그리드 바인딩
private void DisplayData()
{
//[1]
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_NTx bsl = new Is.Notice.Bsl.Notice_NTx())
{
//[2]Fill
ds = bsl.ListNotice();
if (ds.Tables[0].Rows.Count > 0)
{
//[3]Bind
ctlNoticeList.DataSource = ds;
ctlNoticeList.DataBind();
}
else
{
lblNoticeError.Text = "공지사항이 없습니다";
}
}
}
catch (Exception err)
{
//
}
}
//[1]그리드 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_NTx bsl = new Is.Notice.Bsl.Notice_NTx())
{
//[2]Fill
//ds = bsl.SearchNotice(Request["Field"], Request["Query"]);
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_SearchSCM_Order", Request["Field"], Request["Query"]);
if (ds.Tables[0].Rows.Count > 0)
{
//[3]Bind
ctlNoticeList.DataSource = ds;
ctlNoticeList.DataBind();
}
else
{
lblError.Text = "검색결과가 없습니다";
}
}
}
catch (Exception err)
{
//[4]예외
Response.Write(err.Source + " : " + err.Message);
}
}
//[1]
private void DisplayData()
{
//[1]DataSet
DataSet ds = null;
//[2]stringbiulder
StringBuilder strb = new StringBuilder();
try
{
using (Is.Notice.Bsl.Notice_NTx bsl = new Is.Notice.Bsl.Notice_NTx())
{
//[3]Fill
ds = bsl.MainNoticeList();
using (Is.Common.Method.CommonMethod cm = new Is.Common.Method.CommonMethod())
{
//[4]데이타 추출
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strb.AppendFormat(
"<tr><td align='left'>{0}.<a href='Notice/NoticeView.aspx?NoticeID={1}' class='no0'> {2}</a></td><td align='right'>{3}</td><td> </td></tr>",
i + 1,
Convert.ToInt32(ds.Tables[0].Rows[i]["NoticeID"]),
cm.CutString(ds.Tables[0].Rows[i]["Title"].ToString()),
FuncNew(Convert.ToDateTime(ds.Tables[0].Rows[i]["PostDate"])));
}
}
}
//[5]바인딩
ltlNoticeList.Text = strb.ToString();
}
catch (Exception err)
{
Response.Write(err.Source + " : " + err.Message);
}
}
