/// <summary> /// 绑定Grid /// </summary> protected void BindGrid() { GCalendarArrangeBB calendarArrangeBB = new GCalendarArrangeBB(); DataSet ds = new DataSet(); try { ds = calendarArrangeBB.GetVList(this.StrWhere); // 组合列表属性 StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("主题|@subject|@|@left"); sBuilder.Append("|!时间|@arisesDt|@|@left"); sBuilder.Append("|!地点|@locus|@|@left"); sBuilder.Append("|!已读|@isReadDesc|@|@center"); //关联属性 this.dataGrid.TitleDescription = sBuilder.ToString(); this.dataGrid.DataSource = ds.Tables[0]; } finally { calendarArrangeBB.Dispose(); } }
private void ShowInfo(int id) { GCalendarArrangeBB calendarArrangeBB = new GCalendarArrangeBB(); vGCalendarArrangeData model = new vGCalendarArrangeData(); try { model = calendarArrangeBB.GetVModel(id); this.remindEmpId.Text = model.remindEmpNm; this.subject.Text = model.subject; if (model.arisesDt != string.Empty && model.arisesDt != null) { DateTime arisesDt = Convert.ToDateTime(model.arisesDt); this.arisesDt.Text = arisesDt.ToString("yyyy��MM��dd�� HHʱmm��"); } this.locus.Text = model.locus; this.content.Text = model.content; this.aheadRemindMinutes.Text = model.aheadRemindMinutes.ToString(); if (model.remindTime != string.Empty && model.remindTime != null) { DateTime remindTime = Convert.ToDateTime(model.remindTime); this.remindTime.Text = remindTime.ToString("yyyy��MM��dd�� HHʱmm��"); } } finally { calendarArrangeBB.Dispose(); } }
/// <summary> /// 加载审批页 /// </summary> /// <param name="arrangeId">日程安排Id</param> private void LoadAuditPage(string arrangeId) { DataSet ds = new DataSet(); GCalendarArrangeBB calendarArrangeBB = new GCalendarArrangeBB(); try { if (arrangeId == null || arrangeId == "") { throw new Exception("当前日程安排没有传入参数!"); } //取得日程安排页面 ds = calendarArrangeBB.GetList("id=" + arrangeId); if (ds.Tables[0].Rows.Count > 0) { calendarArrangeBB.SetReaded(Convert.ToInt32(arrangeId)); string functionUrl = ""; int windowHeight; int windowWidth; string url = ""; functionUrl = "Page/System/GCalendarArrange/GCalendarArrangeShow.aspx"; windowHeight = 400; windowWidth = 540; //得到连接地址 url = "../../../" + functionUrl; url += "?id=" + HttpUtility.UrlEncode(arrangeId); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("<script language=\"javascript\">\r\n"); stringBuilder.Append(" OpenWindowCenter('" + url + "', '" + windowWidth.ToString() + "', '" + windowHeight.ToString() + "');\r\n"); stringBuilder.Append(" window.close();\r\n"); stringBuilder.Append("</script>\r\n"); if (!this.ClientScript.IsStartupScriptRegistered("BusinessScript")) { this.ClientScript.RegisterStartupScript(this.GetType(), "BusinessScript", stringBuilder.ToString()); } } else { throw new Exception("找不到记录,请关闭重新刷新日程安排列表!"); } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); } finally { calendarArrangeBB.Dispose(); } }
protected void btnReaded_Click(object sender, EventArgs e) { GCalendarArrangeBB calendarArrangeBB = new GCalendarArrangeBB(); try { calendarArrangeBB.SetReadedByEmp(this.currentUser.empId); } finally { calendarArrangeBB.Dispose(); } this.ClientScript.RegisterStartupScript(this.GetType(), "close", "close()", true); }
/// <summary> /// ��Grid /// </summary> protected void BindGrid() { GCalendarArrangeBB calendarArrangeBB = new GCalendarArrangeBB(); DataSet ds = new DataSet(); try { ds = calendarArrangeBB.GetVList(this.StrWhere); this.grid.DataSource = ds.Tables[0]; this.grid.DataBind(); HS.Function.CommFunction.SetColWidth(this.grid, 5, 20); //��ֵ��¼������ҳ������ this.Label3.Text = ds.Tables[0].Rows.Count.ToString(); this.Label2.Text = this.grid.PageCount.ToString(); this.currPage.Text = (this.grid.PageIndex + 1).ToString(); } finally { calendarArrangeBB.Dispose(); } }
/// <summary> /// ɾ�� /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDel_Click(object sender, EventArgs e) { bool retChecked = false; GCalendarArrangeBB calendarArrangeBB = new GCalendarArrangeBB(); try { //��ȡѡ�е�����Id foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { retChecked = true; int id = int.Parse(chkId.ValidationGroup); GCalendarArrangeData calendarArrangeData = new GCalendarArrangeData(); calendarArrangeData = calendarArrangeBB.GetModel(id); calendarArrangeData.isDel = true; calendarArrangeBB.ModifyRecord(calendarArrangeData); } } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { calendarArrangeBB.Dispose(); } if (retChecked) { this.BindGrid(); } }
protected void btnAdd_Click(object sender, EventArgs e) { GCalendarArrangeData model = new GCalendarArrangeData(); GCalendarArrangeBB calendarArrangeBB = new GCalendarArrangeBB(); try { if (this.State == "1") { this.SetModel(ref model); model.isrtDt = DateTime.Now.ToString(); model.isrtEmpId = this.currentUser.empId; model.isDel = false; model.isRead = false; this.IdValue = calendarArrangeBB.AddRecord(model); } else if (this.State == "2") { model = calendarArrangeBB.GetModel(this.IdValue); this.SetModel(ref model); model.updtDt = DateTime.Now.ToString(); model.updtEmpId = this.currentUser.empId; calendarArrangeBB.ModifyRecord(model); } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { calendarArrangeBB.Dispose(); } Response.Redirect("GCalendarArrangeList.aspx?itemNo=" + this.itemNo + "&pTypeNo=main", false); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { this.BindDateList(); if (Request.Params["id"] != null && Request.Params["id"].Trim() != "") { this.IdValue = Convert.ToInt32(Request.Params["id"]); } if (Request.Params["state"] != null && Request.Params["state"].Trim() != string.Empty) { this.State = Request.Params["state"].ToString(); switch (this.State) { case "1": //add break; case "2": //update //���ؿؼ� GCalendarArrangeBB calendarArrangeBB = new GCalendarArrangeBB(); GCalendarArrangeData calendarArrangeData = new GCalendarArrangeData(); try { calendarArrangeData = calendarArrangeBB.GetModel(this.IdValue); this.ShowInfo(this.IdValue); } finally { calendarArrangeBB.Dispose(); } break; default: break; } } } }
private void ShowInfo(int id) { GCalendarArrangeBB calendarArrangeBB = new GCalendarArrangeBB(); vGCalendarArrangeData model = new vGCalendarArrangeData(); try { model = calendarArrangeBB.GetVModel(id); this.remindEmpId.Value = model.remindEmpId.ToString(); this.remindEmpNm.Value = model.remindEmpNm; this.subject.Text = model.subject; if (model.arisesDt != string.Empty && model.arisesDt != null) { DateTime arisesDt = Convert.ToDateTime(model.arisesDt); this.arisesDt.Text = arisesDt.ToShortDateString(); if (this.arisesDtH.Items.FindByValue(arisesDt.Hour.ToString()) != null) { this.arisesDtH.SelectedValue = arisesDt.Hour.ToString(); } if (this.arisesDtM.Items.FindByValue(arisesDt.Minute.ToString()) != null) { this.arisesDtM.SelectedValue = arisesDt.Minute.ToString(); } } this.locus.Text = model.locus; this.content.Text = model.content; this.aheadRemindMinutes.Text = model.aheadRemindMinutes.ToString(); if (model.remindTime != string.Empty && model.remindTime != null) { DateTime remindTime = Convert.ToDateTime(model.remindTime); this.remindTime.Text = remindTime.ToShortDateString(); if (this.remindTimeH.Items.FindByValue(remindTime.Hour.ToString()) != null) { this.remindTimeH.SelectedValue = remindTime.Hour.ToString(); } if (this.remindTimeM.Items.FindByValue(remindTime.Minute.ToString()) != null) { this.remindTimeM.SelectedValue = remindTime.Minute.ToString(); } } } finally { calendarArrangeBB.Dispose(); } }