Exemple #1
0
        private void BindApplys(int curPageIndex)
        {
            var bll   = new FlexPlusBLL();
            var pager = new Pager();

            pager.CurrentPageIndex = curPageIndex;
            pager.srcOrder         = "  ID desc";

            var mTB_DormAreaApply = new TB_DormAreaApply();

            mTB_DormAreaApply.EmployeeNo = txtWorkDayNo.Text.Trim();
            mTB_DormAreaApply.CName      = txtName.Text.Trim();
            mTB_DormAreaApply.CardNo     = txtScanCardNO.Text.Trim();
            int nVal = 0;

            int.TryParse(ddlRequiredType.SelectedValue, out nVal);
            mTB_DormAreaApply.RequireType = nVal;
            nVal = -1;
            int.TryParse(ddlDormArea.SelectedValue, out nVal);
            mTB_DormAreaApply.DormAreaID = nVal;
            nVal = -1;
            int.TryParse(ddlStatus.SelectedValue, out nVal);
            mTB_DormAreaApply.Status = nVal;

            var dt = bll.GetApplyDorms(mTB_DormAreaApply, 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;
        }
Exemple #2
0
        public DataTable GetApplyDorms(TB_DormAreaApply mVal, Pager pager)
        {
            var       sb = new StringBuilder("select * from V_TB_DormAreaApply ");
            var       db = DBO.GetInstance();
            DataTable dt = null;
            DbCommand dbCommandWrapper = null;

            dbCommandWrapper             = db.DbProviderFactory.CreateCommand();
            dbCommandWrapper.CommandType = CommandType.Text;
            sb.Append("where 1=1 ");

            if (mVal.ID > 0)
            {
                sb.AppendFormat("and id={0} ", mVal.ID);
            }
            if (mVal.DormAreaID > 0)
            {
                sb.AppendFormat("and DormAreaID={0} ", mVal.DormAreaID);
            }
            if (!string.IsNullOrEmpty(mVal.CName))
            {
                sb.AppendFormat("and CName='{0}' ", mVal.CName);
            }
            if (!string.IsNullOrEmpty(mVal.CardNo))
            {
                sb.AppendFormat("and CardNo='{0}' ", mVal.CardNo);
            }
            if (!string.IsNullOrEmpty(mVal.EmployeeNo))
            {
                sb.AppendFormat("and EmployeeNo='{0}' ", mVal.EmployeeNo);
            }
            if (!string.IsNullOrEmpty(mVal.MobileNo))
            {
                sb.AppendFormat("and MobileNo='{0}' ", mVal.MobileNo);
            }
            if (mVal.RequireType > 0)
            {
                sb.AppendFormat("and RequireType={0} ", mVal.RequireType);
            }
            if (mVal.Status > -1)
            {
                sb.AppendFormat("and Status={0} ", mVal.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);
        }
Exemple #3
0
        private void InitData(string[] mKeys)
        {
            if (mKeys.Length > 1)
            {
                ddlDormArea.Enabled = false;
                //txtReply.Disabled = true;
                ddlHandle_SelectedIndexChanged(null, null);
            }
            else
            {
                //加载旧数据,限制提交
                var bll = new FlexPlusBLL();
                var mTB_DormAreaApply = new TB_DormAreaApply();
                int nID = 0;
                int.TryParse(mKeys[0], out nID);
                mTB_DormAreaApply.ID = nID;
                Framework.Pager pager = null;
                var             dt    = bll.GetApplyDorms(mTB_DormAreaApply, ref pager);
                if (!DataTableHelper.IsEmptyDataTable(dt))
                {
                    var dr      = dt.Rows[0];
                    int nStatus = 0;
                    nStatus = Convert.ToInt32(dr["Status"]);
                    if (nStatus != 0)
                    {
                        var sLastResp = dr["Response"].ToString();
                        txtReply.Value = sLastResp;

                        ddlDormArea.Enabled = false;
                        ddlHandle.Enabled   = false;
                        txtReply.Disabled   = true;
                        btnSave.Visible     = false;
                        btnSave.Enabled     = false;
                    }
                    else
                    {
                        ddlHandle_SelectedIndexChanged(null, null);
                        txtReply.Disabled = false;
                        txtReply.Focus();
                    }
                }
            }
        }
Exemple #4
0
        private void InitData(string sid)
        {
            int nID = 0;

            int.TryParse(sid, out nID);
            if (0 == nID)
            {
                return;
            }
            var bll = new FlexPlusBLL();
            var mTB_DormAreaApply = new TB_DormAreaApply();

            mTB_DormAreaApply.ID = nID;
            Framework.Pager pager = null;
            var             dt    = bll.GetApplyDorms(mTB_DormAreaApply, ref pager);

            if (DataTableHelper.IsEmptyDataTable(dt))
            {
                return;
            }
            int nTemp = 0;
            var dr    = dt.Rows[0];

            txtEmployeeNo.Text = dr["EmployeeNo"].ToString();
            txtCName.Text      = dr["CName"].ToString();

            nTemp = 0;
            int.TryParse(dr["Sex"].ToString(), out nTemp);
            txtSex.Text = nTemp > 0 ? "男" : "女";

            txtCardNo.Text     = dr["CardNo"].ToString();
            txtCreateDate.Text = dr["CreateDate"].ToString();
            txtHandler.Text    = dr["ModifyUserID"].ToString();
            txtUpdateDate.Text = dr["UpdateDate"].ToString();
            txtDormArea.Text   = dr["DormArea"].ToString();
            txtGrade.Text      = dr["Grade"].ToString();
            nTemp = 0;
            int.TryParse(dr["HasHousingAllowance"].ToString(), out nTemp);
            txtHasHousingAllowance.Text = nTemp > 0 ? "是" : "否";

            txtmemo.Value          = dr["memo"].ToString();
            txtMobileNo.Text       = dr["MobileNo"].ToString();
            txtRequireReason.Value = dr["RequireReason"].ToString();

            nTemp = 0;
            int.TryParse(dr["RequireType"].ToString(), out nTemp);
            var sTemp = string.Empty;

            switch (nTemp)
            {
            case 2:
                sTemp = "复入住";
                break;

            case 3:
                sTemp = "调房";
                break;

            default:
                sTemp = "新入住";
                break;
            }
            txtRequireType.Text = sTemp;
        }
Exemple #5
0
 public DataTable GetApplyDorms(TB_DormAreaApply mTB_DormAreaApply, ref Pager pager)
 {
     return(_mDAL.GetApplyDorms(mTB_DormAreaApply, pager));
 }