private void BindSelect() { var bll = new FlexPlusBLL(); var dt = bll.GetRepairDormTypeList(); ddlDeviceType.DataSource = dt; ddlDeviceType.DataValueField = "Name"; ddlDeviceType.DataTextField = "Name"; var row = dt.NewRow(); row["Name"] = "All"; dt.Rows.InsertAt(row, 0); ddlDeviceType.DataBind(); ddlDeviceType.SelectedIndex = 0; var lst = new List <TNameVal>(); lst.Add(new TNameVal("All", "-1")); lst.Add(new TNameVal("等待处理", "0")); lst.Add(new TNameVal("批准", "1")); lst.Add(new TNameVal("拒绝", "2")); ddlStatus.DataSource = lst; ddlStatus.DataValueField = "Value"; ddlStatus.DataTextField = "Name"; ddlStatus.DataBind(); ddlStatus.SelectedIndex = 0; }
private void InitData(string key) { var bll = new FlexPlusBLL(); var dt = bll.GetDormSuggestByID(key); if (DataTableHelper.IsEmptyDataTable(dt)) { txtResponse.Disabled = false; btnSave.Visible = true; btnSave.Enabled = true; return; } var dr = dt.Rows[0]; txtEmployeeNo.Text = dr["EmployeeNo"].ToString(); txtCName.Text = dr["CName"].ToString(); txtMobileNo.Text = dr["MobileNo"].ToString(); var sDate = (dr["CreateDate"] == null) ? "" : Convert.ToDateTime(dr["CreateDate"]).ToString("yyyy-MM-dd HH:mm"); txtCreateDate.Text = sDate; txtSuggest.Value = dr["Suggest"].ToString(); txtResponse.Value = dr["Response"].ToString(); int nStatus = 0; nStatus = Convert.ToInt32(dr["Status"]); if (nStatus != 0) { txtResponse.Disabled = true; btnSave.Visible = false; btnSave.Enabled = false; } }
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 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; }
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_DormRepair(); mItem.ID = nID; Framework.Pager pager = null; var dt = bll.GetRepairDormList(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(); var sDate = (dr["CreateDate"] == null) ? "" : Convert.ToDateTime(dr["CreateDate"]).ToString("yyyy-MM-dd HH:mm"); txtCreateDate.Text = sDate; sDate = (dr["RepairTime"] == null) ? "" : Convert.ToDateTime(dr["RepairTime"]).ToString("yyyy-MM-dd HH:mm"); txtRepairTime.Text = sDate; txtDeviceType.Text = dr["DeviceType"].ToString(); txtRequireDesc.Value = dr["RequireDesc"].ToString(); var oBatchNo = dr["RefImageBatchNo"]; int nBatchNo = 0; if (null != oBatchNo) { int.TryParse(oBatchNo.ToString(), out nBatchNo); } if (nBatchNo > 0) { lnkView.Enabled = nBatchNo > 0; lnkView.CssClass = "lnkHas"; RefImageBatchNo.Value = oBatchNo.ToString(); } else { lnkView.CssClass = "lnkNoHas"; RefImageBatchNo.Value = string.Empty; lblNoHas.Visible = true; } }
protected void btnExport_Click(object sender, EventArgs e) { //export to excel var mItem = GetParam(); var bll = new FlexPlusBLL(); var sfn = DateTime.Now.ToString("yyMMddHHmmssms_") + "宿舍建议.xls"; string strFileName = bll.ExportDormSugget(mItem, sfn); DownLoadFile(this.Request, this.Response, sfn, File.ReadAllBytes(strFileName), 10240000); }
private void InitData(string batchNo) { var bll = new FlexPlusBLL(); var dt = bll.GetRepairDormImage(batchNo); if (DataTableHelper.IsEmptyDataTable(dt)) { return; } rp_Item.DataSource = dt; rp_Item.DataBind(); }
private void InitData() { var bll = new FlexPlusBLL(); var dt = bll.GetDormNoticeByID(key); if (DataTableHelper.IsEmptyDataTable(dt)) { return; } var dr = dt.Rows[0]; var sTitle = dr["NoticeTitle"] as string; var sContext = dr["NoticeHtml"] as string; txtTitle.Text = sTitle; txtContext.Value = sContext; }
protected void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(key)) { return; } var bll = new FlexPlusBLL(); var sMsg = txtResponse.Value.Trim(); //var sHandlerWorkdayNo = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EmployeeNo); var sEnName = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EName); bll.HandleSuggest(key, sEnName, sMsg); RunScript(this, "myscript", "saveComplete();"); }
private void Bind(int iPage) { var bll = new FlexPlusBLL(); var pager = new Pager(); pager.CurrentPageIndex = iPage; pager.srcOrder = " CreateDate desc"; var dt = bll.GetDormNotice(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; }
protected void btnSave_Click(object sender, EventArgs e) { var sTitle = txtTitle.Text.Trim(); var sContext = txtContext.Value.Trim(); var sCreator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EmployeeNo); var bll = new FlexPlusBLL(); if (string.IsNullOrEmpty(key)) { bll.AddDormNotice(sTitle, sContext, sCreator); } else { bll.EditDormNotice(key, sTitle, sContext, sCreator); } RunScript("myscript", "saveComplete();"); }
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(); } } } }
protected void btnSave_Click(object sender, EventArgs e) { if (null == mKey || 0 == mKey.Length) { return; } var bll = new FlexPlusBLL(); var sHandle = ddlHandle.SelectedValue; var sMsg = txtReply.Value.Trim(); //var sHandlerWorkdayNo = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EmployeeNo); var sEnName = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EName); var kind = (0 == string.Compare("RepairDorm", mKind, true)) ? 0 : 1; bll.HandleRequired(kind, mKey, sEnName, sHandle, sMsg); var sCmd = string.Format("saveComplete({0});", kind); RunScript(this, "myscript", sCmd); }
protected void btnSave_Click(object sender, EventArgs e) { var mKeys = GetKeys(); if (null == mKeys || 0 == mKeys.Length) { return; } var bll = new FlexPlusBLL(); var sDormAreaID = ddlDormArea.SelectedValue; var sHandle = ddlHandle.SelectedValue; var sMsg = txtReply.Value.Trim(); var lst = new List <string>(mKeys); var sHandlerWorkdayNo = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EmployeeNo); var sEnName = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EName); bll.ApplyDorm(lst, sHandlerWorkdayNo, sEnName, sDormAreaID, sHandle, sMsg); RunScript(this, "myscript", "saveComplete();"); }
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(); }
private void InitData(string mKey) { //load old data var bll = new FlexPlusBLL(); var kind = (0 == string.Compare("RepairDorm", mKind, true)) ? 0 : 1; var sAppr = "1"; var sResp = string.Empty; if (bll.IsHandledRequire(kind, mKey, out sAppr, out sResp)) { ddlHandle.SelectedValue = sAppr; txtReply.Value = sResp; txtReply.Disabled = true; ddlHandle.Enabled = false; btnSave.Visible = false; btnSave.Enabled = false; } else { txtReply.Disabled = false; btnSave.Visible = true; } }
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; }
public void DelDormNotice(string key) { var bll = new FlexPlusBLL(); bll.DelDormNotice(key); }
public void SetDormNoticeEnable(string key, bool bEnable) { var bll = new FlexPlusBLL(); bll.SetDormNoticeEnable(key, bEnable); }