private void Bind(int iPage) { var bll = new FlexPlusBLL(); var pager = new Pager(); pager.CurrentPageIndex = iPage; pager.srcOrder = " CreateDate desc"; var mItem = new TB_DormReissueKey(); var sSel = ddlKeyType.SelectedItem.Text; if (0 != string.Compare("all", sSel, true)) { mItem.KeyTypes = sSel; } mItem.Status = Convert.ToInt32(ddlStatus.SelectedValue); var dt = bll.GetReissueKeyList(mItem, ref pager); GridView1.DataSource = dt; GridView1.DataBind(); this.Pager1.ItemCount = pager.TotalRecord; this.Pager1.PageCount = pager.TotalPage; this.Pager1.CurrentIndex = pager.CurrentPageIndex; this.Pager1.PageSize = pager.PageSize; }
private void InitData(string sid) { int nID = 0; int.TryParse(sid, out nID); if (0 == nID) { return; } var bll = new FlexPlusBLL(); var mItem = new TB_DormReissueKey(); mItem.ID = nID; Framework.Pager pager = null; var dt = bll.GetReissueKeyList(mItem, ref pager); if (DataTableHelper.IsEmptyDataTable(dt)) { return; } var dr = dt.Rows[0]; txtEmployeeNo.Text = dr["EmployeeNo"].ToString(); txtCName.Text = dr["CName"].ToString(); txtMobileNo.Text = dr["MobileNo"].ToString(); txtDormAddress.Text = dr["DormAddress"].ToString(); txtKeyTypes.Text = dr["KeyTypes"].ToString(); txtMoney.Text = dr["Money"].ToString(); var sDate = (dr["CreateDate"] == null) ? "" : Convert.ToDateTime(dr["CreateDate"]).ToString("yyyy-MM-dd HH:mm"); txtCreateDate.Text = sDate; txtReason.Value = dr["Reason"].ToString(); txtMemo.Value = dr["Memo"].ToString(); }
public DataTable GetReissueKeyList(TB_DormReissueKey mItem, Pager pager) { var sb = new StringBuilder("select * from TB_DormReissueKey "); var db = DBO.GetInstance(); DataTable dt = null; DbCommand dbCommandWrapper = null; dbCommandWrapper = db.DbProviderFactory.CreateCommand(); dbCommandWrapper.CommandType = CommandType.Text; sb.Append("where 1=1 "); if (mItem.ID > 0) { sb.AppendFormat("and id={0} ", mItem.ID); } if (!string.IsNullOrEmpty(mItem.KeyTypes)) { sb.AppendFormat("and KeyTypes like N'%{0}%' ", mItem.KeyTypes); } if (mItem.Status > -1) { sb.AppendFormat("and Status='{0}' ", mItem.Status); } if (pager != null && !pager.IsNull) { dbCommandWrapper.CommandText = pager.GetPagerSql4Count(sb.ToString()); dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0]; pager.TotalRecord = Convert.ToInt32(dt.Rows[0][0]); dbCommandWrapper.CommandText = pager.GetPagerSql4Data(sb.ToString(), DataBaseTypeEnum.sqlserver); } else { dbCommandWrapper.CommandText = sb.ToString(); } dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0]; return(dt); }
public DataTable GetReissueKeyList(TB_DormReissueKey mItem, ref Pager pager) { return(_mDAL.GetReissueKeyList(mItem, pager)); }