public void LoadData(string PagesTextbox)
{
int PagesIndex = 0;
bool boolCheckPages = true;
if (PagesTextbox.Length > 0 && UltilFunc.IsNumeric(PagesTextbox.ToString()))
{
if (Convert.ToInt32(PagesTextbox) >= 1)
{
PagesIndex = Convert.ToInt32(PagesTextbox) - 1;
}
else
{
boolCheckPages = false;
}
}
else
{
boolCheckPages = false;
}
string where = " 1=1 and Photo_Status=3 ";//AND Lang_ID IN (SELECT T_Nguoidung_NgonNgu.Ma_Ngonngu FROM T_Nguoidung_NgonNgu WHERE T_Nguoidung_NgonNgu.[Ma_Nguoidung] = " + _user.UserID + ")
if (!String.IsNullOrEmpty(this.txtSearch_Cate.Text.Trim()))
{
where += " AND " + string.Format(" Photo_Name like N'%{0}%'", UltilFunc.SqlFormatText(this.txtSearch_Cate.Text.Trim()));
}
if (cboNgonNgu.SelectedIndex > 0)
{
where += " AND Lang_ID=" + cboNgonNgu.SelectedValue.ToString();
}
if (txt_FromDate.Text.Length > 0 && txt_ToDate.Text.Length == 0)
{
where += " and Date_Create>='" + txt_FromDate.Text + " 00:00:01'";
}
else if (txt_FromDate.Text.Length == 0 && txt_ToDate.Text.Length > 0)
{
where += " AND Date_Update < ='" + txt_ToDate.Text.Trim() + " 23:59:59'";
}
else if (txt_FromDate.Text.Length > 0 && txt_ToDate.Text.Length > 0)
{
where += " and Date_Update>='" + txt_FromDate.Text + " 00:00:01' and Date_Create<='" + txt_ToDate.Text + " 23:59:59'";
}
where += " Order by Date_Update DESC";
pages.PageSize = Global.MembersPerPage;
HPCBusinessLogic.T_Photo_EventDAL _cateDAL = new HPCBusinessLogic.T_Photo_EventDAL();
DataSet _ds;
if (boolCheckPages)
{
_ds = _cateDAL.BindGridT_Photo_Events(PagesIndex, pages.PageSize, where);
}
else
{
_ds = _cateDAL.BindGridT_Photo_Events(pages.PageIndex, pages.PageSize, where);
}
int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString());
int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count);
if (TotalRecord == 0)
{
if (boolCheckPages)
{
_ds = _cateDAL.BindGridT_Photo_Events(PagesIndex - 1, pages.PageSize, where);
}
else
{
_ds = _cateDAL.BindGridT_Photo_Events(pages.PageIndex - 1, pages.PageSize, where);
}
}
grdListCate.DataSource = _ds;
grdListCate.DataBind();
_ds.Clear();
pages.TotalRecords = curentPages.TotalRecords = TotalRecords;
curentPages.TotalPages = pages.CalculateTotalPages();
if (boolCheckPages)
{
curentPages.PageIndex = PagesIndex;
}
else
{
curentPages.PageIndex = pages.PageIndex;
}
}
private void LoadData(int status)
{
string where = " 1=1 ";
if (status == 5 || status == 7)
{
where += " and Creator=" + _userDAL.GetUserByUserName(HPCSecurity.CurrentUser.Identity.Name).UserID + " AND Photo_Status = " + status + " AND Lang_ID IN (SELECT T_Nguoidung_NgonNgu.Ma_Ngonngu FROM T_Nguoidung_NgonNgu WHERE T_Nguoidung_NgonNgu.[Ma_Nguoidung] = " + _user.UserID + ")";
}
else
{
where += " and Photo_Status = " + status + " AND Lang_ID IN (SELECT DISTINCT(T_Nguoidung_NgonNgu.Ma_Ngonngu) FROM T_Nguoidung_NgonNgu WHERE T_Nguoidung_NgonNgu.[Ma_Nguoidung] = " + _user.UserID + ")";
}
where += " Order by Date_Create DESC";
pages.PageSize = 50;
HPCBusinessLogic.T_Photo_EventDAL _untilDAL = new HPCBusinessLogic.T_Photo_EventDAL();
DataSet _ds;
_ds = _untilDAL.BindGridT_Photo_Events(pages.PageIndex, pages.PageSize, where);
int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString());
int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count);
if (TotalRecord == 0)
{
_ds = _untilDAL.BindGridT_Photo_Events(pages.PageIndex - 1, pages.PageSize, where);
}
grdListCate.DataSource = _ds;
grdListCate.DataBind(); _ds.Clear();
if (TotalRecords == 0)
{
pages.Visible = false;
curentPages.Visible = false;
}
pages.TotalRecords = curentPages.TotalRecords = TotalRecords;
curentPages.TotalPages = pages.CalculateTotalPages();
curentPages.PageIndex = pages.PageIndex;
if (grdListCate.Items.Count > 0)
{
int count = 0;
foreach (DataGridItem m_Item in grdListCate.Items)
{
T_Photo_EventDAL _DAL = new T_Photo_EventDAL();
T_Photo_Event _obj = new T_Photo_Event();
ImageButton btnModify = m_Item.FindControl("btnModify") as ImageButton;
ImageButton btnSave = m_Item.FindControl("btnSave") as ImageButton;
ImageButton btnBack = m_Item.FindControl("btnBack") as ImageButton;
Label lblNgonNgu = m_Item.FindControl("lblNgonNgu") as Label;
LinkButton btnEdit = m_Item.FindControl("btnEdit") as LinkButton;
Label lblTacGia = m_Item.FindControl("lblTacGia") as Label;
DropDownList cboNgonNgu = m_Item.FindControl("cboNgonNgu") as DropDownList;
TextBox txtTitle = m_Item.FindControl("txtTitle") as TextBox;
TextBox txtTacGia = m_Item.FindControl("txt_tacgia") as TextBox;
//Image imgView = m_Item.FindControl("imgView") as Image;
//Image imgBrowse = m_Item.FindControl("imgBrowse") as Image;
if (txtTitle.Text.Trim().Length > 0)
{
btnSave.Visible = false;
btnBack.Visible = false;
btnModify.Visible = true;
lblNgonNgu.Visible = true;
lblTacGia.Visible = true;
btnEdit.Visible = true;
cboNgonNgu.Visible = false;
txtTitle.Visible = false;
txtTacGia.Visible = false;
//imgView.Visible = true;
//imgBrowse.Visible = false;
}
else
{
btnSave.Visible = true;
btnBack.Visible = true;
btnModify.Visible = false;
lblNgonNgu.Visible = false;
lblTacGia.Visible = false;
btnEdit.Visible = false;
cboNgonNgu.Visible = true;
txtTitle.Visible = true;
txtTacGia.Visible = true;
//imgView.Visible = false;
//imgBrowse.Visible = true;
if (count == 0)
{
txtTitle.Focus();
}
count++;
}
}
}
}