private void ListImages() { ImageFilesDAL obj = new ImageFilesDAL(); DataSet objDataset = new DataSet(); try { //string where = " UserCreated =" + _user.UserID; string where = string.Empty; if (ddlStock.SelectedValue.Trim() != "0") { where += " 1=1 And AuthorID =1 "; } else { where += " 1=1 And (( AuthorID =0 ) OR (AuthorID is null ))"; } if (!string.IsNullOrEmpty(fileName.Text)) { where += " AND ImageFileName like N'%" + fileName.Text + "%'"; } //if (Drop_Chuyenmuc.SelectedValue.Trim() != "0") // where += string.Format(" AND Categorys_ID IN (SELECT * FROM [fn_Return_Category_Tree] ({0}))", this.Drop_Chuyenmuc.SelectedValue); if (!String.IsNullOrEmpty(txt_FromDate.Text.Trim())) { where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)>=0) ", UltilFunc.ToDate(this.txt_FromDate.Value.ToString().Trim(), "MM/dd/yyyy")); } if (!String.IsNullOrEmpty(txt_ToDate.Text.Trim())) { where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)<=0)", UltilFunc.ToDate(this.txt_ToDate.Value.ToString().Trim(), "MM/dd/yyyy")); } else { if (ddlStock.SelectedValue.Trim() == "0") { where += " AND " + string.Format(" DATEDIFF(DAY,DateCreated,'{0}')=0 ", DateTime.Now.ToString("MM/dd/yyyy")); } } where += " ORDER BY DateCreated DESC"; objDataset = obj.ListAllImages(where); if (objDataset != null) { DataView _dv = obj.BindGridListImages(objDataset.Tables[0]); dlImages.DataSource = _dv; dlImages.DataBind(); } objDataset.Clear(); } catch { dlImages.DataSource = null; dlImages.DataBind(); } }
private void ListImages() { ImageFilesDAL obj = new ImageFilesDAL(); DataSet objDataset = new DataSet(); string where = " UserCreated =" + user.UserID; //if (!String.IsNullOrEmpty(txt_FromDate.Text.Trim())) // where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)>=0) ", UltilFunc.ToDate(this.txt_FromDate.Value.ToString().Trim(), "MM/dd/yyyy")); //if (!String.IsNullOrEmpty(txt_ToDate.Text.Trim())) // where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)<=0) ", UltilFunc.ToDate(this.txt_ToDate.Value.ToString().Trim(), "MM/dd/yyyy")); //else where += " AND " + string.Format(" DATEDIFF(DAY,DateCreated,'{0}')=0 ", DateTime.Now.ToString("MM/dd/yyyy")); where += " ORDER BY DateCreated DESC"; objDataset = obj.ListAllImages(where); if (objDataset != null) { DataView _dv = obj.BindGridListImages(objDataset.Tables[0]); dlImages.DataSource = _dv; dlImages.DataBind(); } }
private void ListImages() { ImageFilesDAL obj = new ImageFilesDAL(); DataSet objDataset = new DataSet(); //string where = " UserCreated =" + _user.UserID; string where = ""; if (ddlStock.SelectedValue.Trim() != "0") { where += " 1=1 And AuthorID =1 "; } else { where += " 1=1 And (( AuthorID =0 ) OR (AuthorID is null ))"; } if (!String.IsNullOrEmpty(txt_FromDate.Text.Trim())) { where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)>=0) ", UltilFunc.ToDate(this.txt_FromDate.Value.ToString().Trim(), "MM/dd/yyyy")); } if (!String.IsNullOrEmpty(txt_ToDate.Text.Trim())) { where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)<=0) ", UltilFunc.ToDate(this.txt_ToDate.Value.ToString().Trim(), "MM/dd/yyyy")); } else { if (ddlStock.SelectedValue.Trim() == "0") { where += " AND " + string.Format(" DATEDIFF(DAY,DateCreated,'{0}')=0 ", DateTime.Now.ToString("MM/dd/yyyy")); } } where += " ORDER BY DateCreated DESC"; objDataset = obj.ListAllImages(where); if (objDataset != null) { DataView _dv = obj.BindGridListImages(objDataset.Tables[0]); dlImages.DataSource = _dv; dlImages.DataBind(); } }