private void BtnRepealCost_Click(object sender, EventArgs e) { if (DgvCostApply.SelectedRows.Count != 1) { MessageBox.Show("请仅选择一个费用单进行撤销!", "信息意识", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int costId = (int)DgvCostApply.SelectedRows[0].Cells["cost_id"].Value; List <cost> costList = new CostApplyBLL().Query(new Dictionary <string, object> { { "id", costId } }); if (costList.Count != 0) { if (costList[0].Main.status != 0) { MessageBox.Show("该费用单已审核,不可撤销", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } DialogResult dialogResult = MessageBox.Show("您确定要撤销费用单" + costId + "吗?", "撤销提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { Result res = new CostApplyBLL().Del(costId); MessageBox.Show(res.Message, "撤销结果提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } BtnSearchCostApply_Click(null, null); }
private void CostApplyForm_Load(object sender, EventArgs e) { List <string> listApprover = new CostApplyBLL().ApproverInfo(UserInfoBLL.UserId); CmbApprover.Items.Clear(); CmbApprover.Items.AddRange(listApprover.ToArray()); }
private void BtnAudit_Click(object sender, EventArgs e) { if (DgvCostApprove.SelectedRows.Count != 1) { MessageBox.Show("请仅选择一个费用单进行审批!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int costId = (int)DgvCostApprove.SelectedRows[0].Cells["ApprCostId"].Value; cost cost = new CostApplyBLL().Query(new Dictionary <string, object> { { "id", costId } })[0]; foreach (cost_approval approval in cost.ApprovalList) { if (approval.result != null && approval.approval_id == UserInfoBLL.UserId) { MessageBox.Show("该费用单已审批!不可再次审批", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } CostApprovalForm costApprovalForm = new CostApprovalForm(costId); costApprovalForm.ShowDialog(); BtnSearchCostApply_Click(null, null); }
private void BtnUpdateCost_Click(object sender, EventArgs e) { if (DgvCostApply.SelectedRows.Count != 1) { MessageBox.Show("请仅选择一个费用单进行修改!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int costId = (int)DgvCostApply.SelectedRows[0].Cells["cost_id"].Value; List <cost> costList = new CostApplyBLL().Query(new Dictionary <string, object> { { "id", costId } }); if (costList.Count != 0) { if (costList[0].Main.status != 0) { MessageBox.Show("该费用单已审核,不可修改", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } CostApplyForm costApplyForm = new CostApplyForm(costId); costApplyForm.Text = "费用单修改"; costApplyForm.ShowDialog(); BtnSearchCostApply_Click(null, null); }
private void BtnCostApply_Click(object sender, EventArgs e) { if (CmbApprover.SelectedItem == null) { MessageBox.Show("请选择一个审批人负责您的费用申请", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } CostApplyBLL costApplyBLL = new CostApplyBLL(); List <cost_detail> listDetail = new List <cost_detail>(); decimal applyMoney = 0; foreach (DataGridViewRow row in this.DgvCostDetail.Rows) { if (row.Cells[0].Value == null) { continue; } int type = int.Parse((((string)row.Cells[0].Value).Split('.')[0])); decimal money = decimal.Parse((string)row.Cells[1].Value); listDetail.Add(new cost_detail { cost_type_id = type, money = money }); applyMoney += money; } cost_main main = new cost_main { apply_money = applyMoney, apply_time = DateTime.Now, apply_id = UserInfoBLL.UserId, status = 0, remark = TexRemark.Text }; List <cost_approval> ListApproval = new List <cost_approval> { new cost_approval { approval_id = int.Parse(CmbApprover.SelectedItem.ToString().Split('.')[0]) } }; cost cost = new cost { Main = main, DetailList = listDetail, ApprovalList = ListApproval }; Result res = costApplyBLL.Add(cost); DialogResult dialogResult = MessageBox.Show(res.Message, "添加费用申请单状态提示", MessageBoxButtons.OK, MessageBoxIcon.Information); if (dialogResult == DialogResult.OK) { if (res.Code == RES.OK) { this.DgvCostDetail.Rows.Clear(); this.Close(); } } }
private void BtnSearchCostApply_Click(object sender, EventArgs e) { Dictionary <string, object> conditions = new Dictionary <string, object>(); conditions.Add("apply_id", UserInfoBLL.UserId); int status = -1; if (CmbApplyStatus.SelectedItem != null) { if (!CmbApplyStatus.SelectedItem.ToString().Trim().Equals(" ")) { switch (CmbApplyStatus.SelectedItem.ToString()) { case "未审核": status = 0; break; case "正在审核": status = 1; break; case "审核通过": status = 2; break; case "审核驳回": status = 3; break; } } } if (status >= 0) { conditions.Add("status", status); } conditions.Add("start_time", TimeApplyStart.Value); conditions.Add("end_time", TimeApplyEnd.Value); List <cost> ListCost = new CostApplyBLL().Query(conditions); List <CostApplyData> DataList = new List <CostApplyData>(); foreach (cost cost in ListCost) { string applicant = new SysUserDAL().SelectById(cost.Main.apply_id)[0].name; string statusStr = null; switch (cost.Main.status) { case 0: statusStr = "未审核"; break; case 1: statusStr = "正在审核"; break; case 2: statusStr = "审核通过"; break; case 3: statusStr = "审核驳回"; break; } DataList.Add(new CostApplyData { Number = 1, cost_id = cost.Main.id, applicant = applicant, apply_money = cost.Main.apply_money, apply_time = cost.Main.apply_time, status = statusStr }); } DgvCostApply.DataSource = DataList; }
private void BtnCostApplyUpdate_Click(object sender, EventArgs e) { List <cost_detail> listDetail = new List <cost_detail>(); decimal applyMoney = 0; foreach (DataGridViewRow row in this.DgvCostDetail.Rows) { if (row.Cells[0].Value == null) { continue; } int type = int.Parse((((string)row.Cells[0].Value).Split('.')[0])); decimal money = decimal.Parse((string)row.Cells[1].Value); listDetail.Add(new cost_detail { cost_type_id = type, money = money }); applyMoney += money; } Result res = new CostApplyBLL().Update(new cost { Main = new cost_main { id = costId, apply_money = applyMoney, remark = TexRemark.Text }, DetailList = listDetail }); DialogResult dialogResult = MessageBox.Show(res.Message, "修改费用申请单状态提示", MessageBoxButtons.OK, MessageBoxIcon.Information); if (dialogResult == DialogResult.OK) { if (res.Code == RES.OK) { this.DgvCostDetail.Rows.Clear(); this.Close(); } } }
private void CostApprovalForm_Load(object sender, EventArgs e) { cost cost = new CostApplyBLL().Query(new Dictionary <string, object> { { "id", costId } }).First(); cost_main main = cost.Main; view_sys_u2g applicant = new SysUserDAL().SelectById(main.apply_id).First(); TexApplicant.Text = applicant.name; foreach (cost_detail detail in cost.DetailList) { int index = this.DgvCostDetail.Rows.Add(); this.DgvCostDetail.Rows[index].SetValues(new CostApplyDAL().GetCostTypeById(detail.cost_type_id), detail.money); } foreach (cost_approval approval in cost.ApprovalList) { int index = this.DgvApproval.Rows.Add(); string approver = approval.approval_id + "." + new SysUserDAL().SelectById(approval.approval_id).First().name; this.DgvApproval.Rows[index].SetValues(approver, approval.result, approval.time, approval.opinion); } int userId = UserInfoBLL.UserId; List <string> approverList = new CostApplyDAL().GetApprovalInfo(userId); if (approverList.Count == 0) { LblNextApprover.Visible = false; CmbNextApprover.Visible = false; return; } else { LblNextApprover.Visible = true; CmbNextApprover.Visible = true; } CmbNextApprover.Items.Clear(); CmbNextApprover.Items.AddRange(approverList.ToArray()); }
private void CostApplyDetailForm_Load(object sender, EventArgs e) { cost cost = new CostApplyBLL().Query(new Dictionary <string, object> { { "id", costId } }).First(); cost_main main = cost.Main; LblCostId.Text = main.id.ToString(); view_sys_u2g applicant = new SysUserDAL().SelectById(main.apply_id).First(); LblApplicant.Text = applicant.name; LblApplicantOrg.Text = applicant.org_name; LblApplyTime.Text = main.apply_time.ToString("yyyy-MM-dd HH:mm:ss"); LblApplyMoney.Text = main.apply_money.ToString(); foreach (cost_detail detail in cost.DetailList) { int index = this.DgvCostDetail.Rows.Add(); this.DgvCostDetail.Rows[index].SetValues(new CostApplyDAL().GetCostTypeById(detail.cost_type_id), detail.money); } switch (main.status) { case 0: LblStatus.Text = "未审核"; break; case 1: LblStatus.Text = "正在审核"; break; case 2: LblStatus.Text = "审核通过"; break; case 3: LblStatus.Text = "审核驳回"; break; } foreach (cost_approval approval in cost.ApprovalList) { int index = this.DgvApproval.Rows.Add(); string approver = approval.approval_id + "." + new SysUserDAL().SelectById(approval.approval_id).First().name; this.DgvApproval.Rows[index].SetValues(approver, approval.result, approval.time, approval.opinion); } }
private void BtnSearchApprove_Click(object sender, EventArgs e) { Dictionary <string, object> conditions = new Dictionary <string, object>(); conditions.Add("start_time", TimeApproveStart.Value); conditions.Add("end_time", TimeApproveEnd.Value); int result = -1; switch (CmbApporveStatus.Text.ToString().Trim()) { case "通过": result = 0; break; case "驳回": result = 1; break; case "未审核": result = 2; break; } List <CostApprovalData> ListData = new List <CostApprovalData>(); List <cost> CostList = new CostApplyBLL().Query(conditions); foreach (cost cost in CostList) { foreach (cost_approval approval in cost.ApprovalList) { if (result == 0 && (approval == null || approval.result == false)) { continue; } if (result == 1 && (approval == null || approval.result == true)) { continue; } if (result == 2 && (approval != null)) { continue; } if (approval.approval_id != UserInfoBLL.UserId) { continue; } CostApprovalData data = new CostApprovalData { ApprNumber = 1, ApprCostId = cost.Main.id, ApprApplicant = new SysUserDAL().SelectById(cost.Main.apply_id)[0].name, ApprApplyMoney = cost.Main.apply_money, ApprApplyTime = cost.Main.apply_time, ApprApprovalTime = approval.time, ApprOpinion = approval.opinion }; if (approval.result == null) { data.ApprResult = "未审批"; } else { data.ApprResult = (bool)approval.result ? "通过" : "驳回"; } ListData.Add(data); } } DgvCostApprove.DataSource = ListData; }