private void LoadList() { TransferOut clsTransferOut = new TransferOut(); DataClass clsDataClass = new DataClass(); Common Common = new Common(); string SortField = "TransferOutID"; if (Request.QueryString["sortfield"] != null) { SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); } SortOption sortoption = SortOption.Ascending; if (Request.QueryString["sortoption"] != null) { sortoption = (SortOption)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); } DateTime dteTransferStartDate = DateTime.MinValue; try { if (txtOrderStartDate.Text != string.Empty) { dteTransferStartDate = Convert.ToDateTime(txtOrderStartDate.Text + " " + txtOrderStartTime.Text); } } catch { } DateTime dteTransferEndDate = DateTime.MinValue; try { if (txtOrderEndDate.Text != string.Empty) { dteTransferEndDate = Convert.ToDateTime(txtOrderEndDate.Text + " " + txtOrderEndTime.Text); } } catch { } DateTime dtePostingStartDate = DateTime.MinValue; try { if (txtPostingStartDate.Text != string.Empty) { dtePostingStartDate = Convert.ToDateTime(txtPostingStartDate.Text + " " + txtPostingStartTime.Text); } } catch { } DateTime dtePostingEndDate = DateTime.MinValue; try { if (txtPostingEndDate.Text != string.Empty) { dtePostingEndDate = Convert.ToDateTime(txtPostingEndDate.Text + " " + txtPostingEndTime.Text); } } catch { } string SearchKey = txtSearch.Text; TransferOutStatus status = (TransferOutStatus)Enum.Parse(typeof(TransferOutStatus), cboStatus.SelectedItem.Value); PageData.DataSource = clsTransferOut.SearchAsDataTable(status, dteTransferStartDate, dteTransferEndDate, dtePostingStartDate, dtePostingEndDate, SearchKey, SortField, sortoption).DefaultView; clsTransferOut.CommitAndDispose(); int iPageSize = Convert.ToInt16(Session["PageSize"]); PageData.AllowPaging = true; PageData.PageSize = iPageSize; try { PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1; lstItem.DataSource = PageData; lstItem.DataBind(); } catch { PageData.CurrentPageIndex = 1; lstItem.DataSource = PageData; lstItem.DataBind(); } cboCurrentPage.Items.Clear(); for (int i = 0; i < PageData.PageCount; i++) { int iValue = i + 1; cboCurrentPage.Items.Add(new ListItem(iValue.ToString(), iValue.ToString())); if (PageData.CurrentPageIndex == i) { cboCurrentPage.Items[i].Selected = true; } else { cboCurrentPage.Items[i].Selected = false; } } lblDataCount.Text = " of " + " " + PageData.PageCount; }
protected void lstItem_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Header) { LoadSortFieldOptions(e); } else if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView dr = (DataRowView)e.Item.DataItem; HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList"); chkList.Value = dr["TransferOutID"].ToString(); TransferOutStatus status = (TransferOutStatus)Enum.Parse(typeof(TransferOutStatus), dr["Status"].ToString()); if (status == TransferOutStatus.Posted || status == TransferOutStatus.Cancelled) { chkList.Attributes.Add("disabled", "false"); ImageButton imgItemDelete = (ImageButton)e.Item.FindControl("imgItemDelete"); ImageButton imgItemEdit = (ImageButton)e.Item.FindControl("imgItemEdit"); ImageButton imgItemPost = (ImageButton)e.Item.FindControl("imgItemPost"); imgItemDelete.Enabled = false; imgItemDelete.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; imgItemEdit.Enabled = false; imgItemEdit.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; imgItemPost.Enabled = false; imgItemPost.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; } HyperLink lnkTransferOutNo = (HyperLink)e.Item.FindControl("lnkTransferOutNo"); lnkTransferOutNo.Text = dr["TransferOutNo"].ToString(); Common Common = new Common(); string stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&transferoutid=" + Common.Encrypt(chkList.Value.ToString(), Session.SessionID); lnkTransferOutNo.NavigateUrl = "Default.aspx" + stParam; Label lblTransferOutDate = (Label)e.Item.FindControl("lblTransferOutDate"); lblTransferOutDate.Text = Convert.ToDateTime(dr["TransferOutDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); Label lblSupplierID = (Label)e.Item.FindControl("lblSupplierID"); lblSupplierID.Text = dr["SupplierID"].ToString(); HyperLink lblSupplierCode = (HyperLink)e.Item.FindControl("lblSupplierCode"); lblSupplierCode.Text = dr["SupplierCode"].ToString(); stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&id=" + Common.Encrypt(lblSupplierID.Text, Session.SessionID); lblSupplierCode.NavigateUrl = Constants.ROOT_DIRECTORY + "/PurchasesAndPayables/_Vendor/Default.aspx" + stParam; Label lblReqDeliveryDate = (Label)e.Item.FindControl("lblReqDeliveryDate"); lblReqDeliveryDate.Text = Convert.ToDateTime(dr["RequiredDeliveryDate"].ToString()).ToString("yyyy-MM-dd"); Label lblBranchID = (Label)e.Item.FindControl("lblBranchID"); lblBranchID.Text = dr["BranchID"].ToString(); Label lblBranchCode = (Label)e.Item.FindControl("lblBranchCode"); lblBranchCode.Text = dr["BranchCode"].ToString(); Label lblTransferOutSubTotal = (Label)e.Item.FindControl("lblTransferOutSubTotal"); lblTransferOutSubTotal.Text = Convert.ToDecimal(dr["SubTotal"].ToString()).ToString("#,##0.#0"); Label lblTransferOutRemarks = (Label)e.Item.FindControl("lblTransferOutRemarks"); lblTransferOutRemarks.Text = dr["Remarks"].ToString(); //For anchor // HtmlGenericControl divExpCollAsst = (HtmlGenericControl) e.Item.FindControl("divExpCollAsst"); // HtmlAnchor anchorDown = (HtmlAnchor) e.Item.FindControl("anchorDown"); // anchorDown.HRef = "javascript:ToggleDiv('" + divExpCollAsst.ClientID + "')"; } }
public System.Data.DataTable SearchAsDataTable(TransferOutStatus TransferOutStatus, DateTime OrderStartDate, DateTime OrderEndDate, DateTime PostingStartDate, DateTime PostingEndDate, string SearchKey, string SortField, SortOption SortOrder) { try { if (SortField == string.Empty || SortField == null) SortField = "TransferOutID"; string SQL = SQLSelect() + "WHERE Status = @Status AND (TransferOutNo LIKE @SearchKey or TransferOutDate LIKE @SearchKey or SupplierCode LIKE @SearchKey " + "or SupplierContact LIKE @SearchKey or BranchCode LIKE @SearchKey or RequiredDeliveryDate LIKE @SearchKey) "; if (OrderStartDate != DateTime.MinValue) SQL += "AND TransferOutDate >= @OrderStartDate "; if (OrderEndDate != DateTime.MinValue) SQL += "AND TransferOutDate <= @OrderEndDate "; if (PostingStartDate != DateTime.MinValue) SQL += "AND TransferOutDate >= @PostingStartDate "; if (PostingEndDate != DateTime.MinValue) SQL += "AND TransferOutDate <= @PostingEndDate "; SQL += "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@Status", TransferOutStatus.ToString("d")); cmd.Parameters.AddWithValue("@SearchKey", "%" + SearchKey + "%"); if (OrderStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderStartDate", OrderStartDate.ToString("yyyy-MM-dd HH:mm:ss")); if (OrderEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderEndDate", OrderEndDate.ToString("yyyy-MM-dd HH:mm:ss")); if (PostingStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingStartDate", PostingStartDate.ToString("yyyy-MM-dd HH:mm:ss")); if (PostingEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingEndDate", PostingEndDate.ToString("yyyy-MM-dd HH:mm:ss")); string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; } catch (Exception ex) { throw base.ThrowException(ex); } }
public MySqlDataReader List(TransferOutStatus TransferOutStatus, DateTime StartDate, DateTime EndDate) { try { string SQL = SQLSelect() + "WHERE Status = @Status AND DeliveryDate BETWEEN @StartDate AND @EndDate ORDER BY TransferOutID ASC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmStartDate = new MySqlParameter("@StartDate",MySqlDbType.DateTime); prmStartDate.Value = StartDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmStartDate); MySqlParameter prmEndDate = new MySqlParameter("@EndDate",MySqlDbType.DateTime); prmEndDate.Value = EndDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmEndDate); MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16); prmStatus.Value = TransferOutStatus.ToString("d"); cmd.Parameters.Add(prmStatus); MySqlDataReader myReader = base.ExecuteReader(cmd); return myReader; } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable SearchAsDataTable(TransferOutStatus TransferOutStatus, string SearchKey, string SortField, SortOption SortOrder) { try { if (SortField == string.Empty || SortField == null) SortField = "TransferOutID"; string SQL = SQLSelect() + "WHERE Status = @Status AND (TransferOutNo LIKE @SearchKey or TransferOutDate LIKE @SearchKey or SupplierCode LIKE @SearchKey " + "or SupplierContact LIKE @SearchKey or BranchCode LIKE @SearchKey or RequiredDeliveryDate LIKE @SearchKey) " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16); prmStatus.Value = TransferOutStatus.ToString("d"); cmd.Parameters.Add(prmStatus); MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String); prmSearchKey.Value = "%" + SearchKey + "%"; cmd.Parameters.Add(prmSearchKey); string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; } catch (Exception ex) { throw base.ThrowException(ex); } }
public MySqlDataReader Search(TransferOutStatus TransferOutStatus, string SearchKey, string SortField, SortOption SortOrder) { try { if (SortField == string.Empty || SortField == null) SortField = "TransferOutID"; string SQL = SQLSelect() + "WHERE Status = @Status AND (TransferOutNo LIKE @SearchKey or TransferOutDate LIKE @SearchKey or SupplierCode LIKE @SearchKey " + "or SupplierContact LIKE @SearchKey or BranchCode LIKE @SearchKey or RequiredDeliveryDate LIKE @SearchKey) " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16); prmStatus.Value = TransferOutStatus.ToString("d"); cmd.Parameters.Add(prmStatus); MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String); prmSearchKey.Value = "%" + SearchKey + "%"; cmd.Parameters.Add(prmSearchKey); MySqlDataReader myReader = base.ExecuteReader(cmd); return myReader; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public MySqlDataReader List(TransferOutStatus TransferOutStatus, long SupplierID, string SortField, SortOption SortOrder) { try { if (SortField == string.Empty || SortField == null) SortField = "TransferOutID"; string SQL = SQLSelect() + "WHERE Status =@Status AND SupplierID = @SupplierID ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16); prmStatus.Value = TransferOutStatus.ToString("d"); cmd.Parameters.Add(prmStatus); MySqlParameter prmSupplierID = new MySqlParameter("@SupplierID",MySqlDbType.Int64); prmSupplierID.Value = SupplierID; cmd.Parameters.Add(prmSupplierID); MySqlDataReader myReader = base.ExecuteReader(cmd); return myReader; } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(TransferOutStatus TransferOutStatus, DateTime OrderStartDate, DateTime OrderEndDate, DateTime PostingStartDate, DateTime PostingEndDate, string SortField, SortOption SortOrder) { if (SortField == string.Empty || SortField == null) SortField = "TransferOutID"; string SQL = SQLSelect() + "WHERE Status = @Status "; if (OrderStartDate != DateTime.MinValue) SQL += "AND TransferOutDate >= @OrderStartDate "; if (OrderEndDate != DateTime.MinValue) SQL += "AND TransferOutDate <= @OrderEndDate "; if (PostingStartDate != DateTime.MinValue) SQL += "AND TransferOutDate >= @PostingStartDate "; if (PostingEndDate != DateTime.MinValue) SQL += "AND TransferOutDate <= @PostingEndDate "; SQL += "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@Status", TransferOutStatus.ToString("d")); if (OrderStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderStartDate", OrderStartDate.ToString("yyyy-MM-dd HH:mm:ss")); if (OrderEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderEndDate", OrderEndDate.ToString("yyyy-MM-dd HH:mm:ss")); if (PostingStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingStartDate", PostingStartDate.ToString("yyyy-MM-dd HH:mm:ss")); if (PostingEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingEndDate", PostingEndDate.ToString("yyyy-MM-dd HH:mm:ss")); string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; }
public System.Data.DataTable ListAsDataTable(TransferOutStatus TransferOutStatus, string SortField, SortOption SortOrder) { if (SortField == string.Empty || SortField == null) SortField = "TransferOutID"; string SQL = SQLSelect() + "WHERE Status = @Status ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16); prmStatus.Value = TransferOutStatus.ToString("d"); cmd.Parameters.Add(prmStatus); string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; }