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));
}
