protected void txtBorrowNo_TextChanged(object sender, EventArgs e) { ddlName.Items.Clear(); int borrowNo = Convert.ToInt32(this.txtBorrowNo.Text.Trim()); IList <ApplicationResourseInfo> ari = new List <ApplicationResourseInfo>(); IList <ResourceInfo> resources = new List <ResourceInfo>(); ari = ApplicationResourceManager.GetAllApplicationResource(1, borrowNo); foreach (ApplicationResourseInfo item in ari) { if (item.Borrow != new BorrowApplication()) { resources.Add(item.Resource); } } this.ddlName.DataSource = resources; ddlName.DataTextField = "RIName"; ddlName.DataValueField = "RIID"; ddlName.DataBind(); BorrowApplication borrow = BorrowApplicationManager.Get(borrowNo); if (borrow != new BorrowApplication() && borrow != null) { this.txtUser.Text = borrow.User.Name; this.hfUID.Value = borrow.User.UID.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { ucPager.onLoadPageIndexChaning += new _Controls_Pager.MyDele(ucPager_onLoadPageIndexChaning); if (!IsPostBack) { UserInfo user = new UserInfo(); if (Session["user"] != null) { user = (UserInfo)Session["user"]; this.txtUser.Text = ((UserInfo)Session["user"]).Name; //"单哥!HOW ARE YOU?"; } else { Response.Redirect("../login.aspx"); return; } int id = Convert.ToInt32(this.Request.QueryString["id"]); BorrowApplication borrow = BorrowApplicationManager.Get(id); this.txtApplyNum.Text = borrow.BAID.ToString(); this.txtBATime.Value = borrow.BATime; this.txtExigentGrade.Text = borrow.ExigentGrade; this.txtUser.Text = borrow.User.Name; this.txtMark.Text = borrow.BARemark; this.txtExamine.Text = borrow.IsExamine; ucPager_onLoadPageIndexChaning(ucPager.PageIndex); } }
public static IList <BorrowApplication> SearchBorrowApplication(int baid, int type, string time, int uid) { UserInfo user = new UserInfo(); user.UID = uid; BorrowApplication item = new BorrowApplication(baid, user, time, type, "", "", ""); return(borrowService.GetAllBorrowApplication(item)); }
object IDAL.IBaseFace.Get(int id) { BorrowApplication item = null; using (SqlDataReader reader = DBHelper.ExecuteReaderProc(GET_BORROWAPPLICATION, new SqlParameter("@BAID", id))) { if (reader.Read()) { item = new BorrowApplication(reader.GetInt32(0), (UserInfo)uis.GetAllUserById(reader.GetInt32(1)), reader.GetDateTime(2).ToString(), reader.GetInt32(3), reader.GetString(4), reader.GetString(5), reader.GetString(6)); } } return(item); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = Convert.ToInt32(this.Request.QueryString["id"]); BorrowApplication borrow = BorrowApplicationManager.Get(id); this.txtBorrowNo.Text = borrow.BAID.ToString(); this.txtBATime.Value = borrow.BATime; this.txtExigentGrade.Text = borrow.ExigentGrade; this.txtUser.Text = borrow.User.Name; this.txtMark.Text = borrow.BARemark; this.txtExamine.Text = borrow.IsExamine; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (IsValid) { UserInfo user = new UserInfo(); if (Session["user"] != null) { user = (UserInfo)Session["user"]; } else { Response.Redirect("../login.aspx"); return; } if (ApplicationResources.GetItems.Count == 0) { this.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('你还没有选择资源!')</script>"); return; } else { BorrowApplication borrow = new BorrowApplication(); borrow.User.UID = ((UserInfo)Session["user"]).UID /*1*/; borrow.BATime = this.txtBorrowTime.Value.Trim(); borrow.BAType = Convert.ToInt32(this.ddlType.SelectedValue); borrow.ExigentGrade = this.txtExigentGrade.Text.Trim(); borrow.BARemark = this.txtMark.Text.Trim(); borrow.IsExamine = "待办"; int id = BorrowApplicationManager.Add(borrow); borrow.BAID = id; Hashtable list = ApplicationResources.GetItems; foreach (int str in list.Keys) { ApplicationResourseInfo item = (ApplicationResourseInfo)list[str]; item.Borrow = borrow; ApplicationResourceManager.add(item); } list.Clear(); Response.Redirect("ApplyBorrowList.aspx"); } } }
int IDAL.IBaseFace.Add(object obj) { int val = 0; if (obj is BorrowApplication) { BorrowApplication item = (BorrowApplication)obj; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@UID", item.User.UID), new SqlParameter("@BATime", item.BATime), new SqlParameter("@BAType", item.BAType), new SqlParameter("@ExigentGrade", item.ExigentGrade), new SqlParameter("@BARemark", item.BARemark), new SqlParameter("@IsExamine", item.IsExamine) }; val = DBHelper.ExecuteScalarProc(ADD_BORROWAPPLICATION, parms); } return(val); }
IList <BorrowApplication> IBorrowApplicationService.GetAllBorrowApplication(BorrowApplication item) { IList <BorrowApplication> items = new List <BorrowApplication>(); SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@BAID", item.BAID), new SqlParameter("@UID", item.User.UID), new SqlParameter("@BATime", item.BATime), new SqlParameter("@BAType", item.BAType), new SqlParameter("@ExigentGrade", item.ExigentGrade), new SqlParameter("@BARemark", item.BARemark), new SqlParameter("@IsExamine", item.IsExamine) }; using (SqlDataReader reader = DBHelper.ExecuteReaderProc(SEARCH_BORROWAPPLICATION, parms)) { while (reader.Read()) { BorrowApplication var = new BorrowApplication(reader.GetInt32(0), (UserInfo)uis.GetAllUserById(reader.GetInt32(1)), reader.GetDateTime(2).ToString(), reader.GetInt32(3), reader.GetString(4), reader.GetString(5), reader.GetString(6)); items.Add(var); } } return(items); }
/// <summary> /// 添加审批记录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { Examine em = new Examine(); em.RequisitionID = Convert.ToInt32(txtApplicationId.Text); em.RequisitionType = txtType.Text; em.ExamineUID.UID = Convert.ToInt32(((UserInfo)Session["user"]).UID); em.ExamineIdea = this.txtCause.Text; em.EndTime = Convert.ToDateTime(txtTime.Value); em.IsApproved = rdoAccess.SelectedValue == "未过" ? "未过" : "通过"; //不管是否通过,都在审批记录表中添加一条审批记录 if (ExamineManager.AddExamine(em) > 0) { //判断审批是否通过, if (rdoAccess.SelectedValue == "通过") { if (txtType.Text == "会议申请") { try { MeetingApplication ma = MeetingApplicationManager.GetMeetingApplicationById(Convert.ToInt32(txtApplicationId.Text)); //获取所有与会人员, string applicationMan = ma.WithinEnlistMan; LeaveWord lw = new LeaveWord(); lw.MsgTitle = ma.MeetTitle; //会议标题 lw.MsgContent = ma.MeetContent; //会议内容 lw.MsgSendTime = Convert.ToDateTime(DateTime.Now.ToShortDateString()); //发送时间 lw.MsgState = "未读"; lw.MsgTypeId.Id = 1; //1代表会议申请 lw.SenderUser = user; //发送者 lw.MeetingBeginTime = ma.BeginTime; //开会时间 lw.MeetingAddr = ma.RoomInfo.RomeAddr; //会议地点 lw.ChargeMan = ma.Compere; //会议负责人 lw.MeetingType = ma.MeetType; //用“,”号分割与会人员 string[] array = applicationMan.Split(new char[] { ',' }); for (int i = 0; i < array.Length; i++) { int uid = UserInfoManager.GetLeaveIDByMName(array[i]); lw.ReceiverUser.UID = uid; int flag = LeaveWordManager.AddLeaveWord(lw); } //更新会议申请的状态 MeetingApplicationManager.ModifyMeetingState(Convert.ToInt32(txtApplicationId.Text), "已办"); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('已审核!');location.href='CheckNote.aspx'", true); } catch (Exception) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('审核失败!');", true); return; } } else if (txtType.Text == "用车申请") { try { //更新用车申请状态 int flag = CarByapplyManager.UpadteByapplySate(Convert.ToInt32(txtApplicationId.Text), "已办"); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('已审核!');location.href='CheckNote.aspx'", true); } catch (Exception) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('审核失败!');", true); return; } } } else //不通过,终结申请 { if (txtType.Text == "会议申请") { MeetingApplicationManager.ModifyMeetingState(Convert.ToInt32(txtApplicationId.Text), "终结"); } else if (txtType.Text == "用车申请") { //终结用车申请 int flag = CarByapplyManager.UpadteByapplySate(Convert.ToInt32(txtApplicationId.Text), "终结"); } Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('已终结!');window.location='Matter.aspx'</script>", true); } if (txtType.Text == "任务申请") //根据实际完成金额更新任务总体完成进度 { try { if (em.IsApproved == "通过") { TaskManager.UpdateTaskNowStatus(Convert.ToInt32(txtApplicationId.Text));//更新任务状态 //更新任务的完成比例 TaskManager.UpdateTaskFinshStatus(Convert.ToInt32(txtApplicationId.Text)); //更新申请单状态为通过 new RolePowerManager().UpdatePaddingStatus("已办", Convert.ToInt32(txtApplicationId.Text.Trim())); } else { //更新申请单状态为终结 new RolePowerManager().UpdatePaddingStatus("终结", Convert.ToInt32(txtApplicationId.Text.Trim())); } } catch (Exception) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新任务状态失败!');", true); return; } } if (txtType.Text == "资源采购") { StockApplication stock = StockApplicationManager.Get((int)em.RequisitionID); if (em.IsApproved == "通过") { stock.IsExamine = "已办"; IList <ApplicationResourseInfo> items = ApplicationResourceManager.GetAllApplicationResource(2, stock.SAID); foreach (ApplicationResourseInfo item in items) { item.Resource.Number += item.Number; ResourceInfoManager.UpdateResourceInfo(item.Resource); } } else { stock.IsExamine = "终结"; } StockApplicationManager.Update(stock); } else if (txtType.Text == "资源借用") { BorrowApplication borrow = BorrowApplicationManager.Get((int)em.RequisitionID); if (em.IsApproved == "通过") { borrow.IsExamine = "已办"; IList <ApplicationResourseInfo> items = ApplicationResourceManager.GetAllApplicationResource(1, borrow.BAID); foreach (ApplicationResourseInfo item in items) { item.Resource.Number -= item.Number; ResourceInfoManager.UpdateResourceInfo(item.Resource); } } else { borrow.IsExamine = "终结"; } BorrowApplicationManager.Update(borrow); } Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('已审核!');location.href='CheckNote.aspx'", true); // Response.Redirect(""); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('审核失败!');", true); } }
public static int Update(BorrowApplication item) { return(borrowService.Update(item)); }
public static int Add(BorrowApplication item) { return(borrowService.Add(item)); }