/// <summary> /// 删除报销单 /// </summary> /// <param name="id">报销单id</param> private void Del(int id) { AusRottenInfo info = AusRottenInfoManager.GetModel(id); if (info != null) { int jobflowid = info.jobflowid; string strdel = " jobflowid=" + jobflowid; AuditJobFlowManager.Delete(strdel); JobFlowManager.Delete(jobflowid); JobFlowFileManager.Delete(jobflowid); AusDetialInfoManager.Del(jobflowid); //RegReimbursementManager.Delete(id.ToString()); //ReimbursementInvoiceManager; AusRottenInfoManager.Delete(id); } }
/// <summary> /// 得到报销明细 /// </summary> /// <param name="orderid"></param> /// <returns></returns> public string getReimDetail(object orderid) { StringBuilder str = new StringBuilder(); str.Append("<table border='1'>"); str.Append("<tr><th width='100px'>报销单号</th><th width='80px'>报销金额</th><th width='100px'>项目类别</th></tr>"); DataTable dt = AusRottenInfoManager.GetViewList(" orderid= " + orderid); for (int i = 0; i < dt.Rows.Count; i++) { str.Append("<tr><td>" + dt.Rows[i]["jobflowcname"].ToString() + "</td>"); //报销单号 str.Append("<td>" + dt.Rows[i]["totalmoney"].ToString() + "</td>"); str.Append("<td>" + dt.Rows[i]["itemtype"].ToString() + "</td>"); } str.Append("</table>"); return(str.ToString()); }
/// <summary> /// 提示清空 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ibtnDeleteAll_Click(object sender, ImageClickEventArgs e) { string str = ""; if (cbAnnouncement.Checked == true) { AnnouncementInfoManager.Clear(); ClearAuditAndJobflow("04"); str += "公告管理清空完成;\\n"; } if (cbCalendar.Checked == true) { CalendarsManager.Clear(); str += "日程管理清空完成;\\n"; } if (cbCompany.Checked == true) { FactoryManager.Clear(); str += "付款单位清空完成;\\n"; } if (cbCustomer.Checked == true) { CustomerManager.Clear(); ClearAuditAndJobflow("03"); str += "收款单位清空完成;\\n"; } if (cbFinancial.Checked == true) { To_CollectingManager.Clear(); str += "收款管理清空完成;\\n"; } if (cbInfomation.Checked == true) { InformationManager.Clear(); str += "消息管理清空完成;\\n"; } if (cbInvocie.Checked == true) { To_InvoiceManager.Clear(); str += "发票管理清空完成;\\n"; } if (cbLinkInfo.Checked == true) { AddressListInfoManager.Clear(); str += "通讯录清空完成;\\n"; } if (cbPicture.Checked == true) { PictureInfoManager.Clear(); str += "图片管理清空完成;\\n"; } if (cbPolicy.Checked == true) { To_OrderInfoManager.Clear(); // ClearAuditAndJobflow("02"); str += "保单管理清空完成;\\n"; } if (cbReimbursed.Checked == true) { ClearAuditAndJobflow("01"); AusRottenInfoManager.Clear(); str += "报销管理清空完成;\\n"; } // ClientScript.RegisterStartupScript(this.GetType(), "", " <script lanuage=javascript> alert('"+ str +"');</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "page", string.Format("alert('{0}');", str), true); }
/// <summary> /// 报销 /// </summary> /// <param name="id"></param> private decimal LoadRem(int id) { ////tablerem //DataTable dt = To_OrderReimDetialManager.getList(id); //DataTable dtRem = AusOrderInfoManager.GetListBysql(" orderid =" + id); decimal moneyAmount = 0; decimal reimMoney = 0; decimal hasAmount = 0; DataTable dt = AusRottenInfoManager.GetViewList(" orderid= " + id); if (dt.Rows.Count > 0) { HtmlTableRow row = null; HtmlTableCell cell = null; for (int i = 0; i < dt.Rows.Count; i++) { row = new HtmlTableRow(); cell = new HtmlTableCell(); cell.Attributes.CssStyle.Add("height", "20px"); cell.InnerHtml = dt.Rows[i]["jobflowcname"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = dt.Rows[i]["itemtype"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); reimMoney = 0; decimal.TryParse((dt.Rows[i]["totalmoney"]).ToString(), out reimMoney); cell.InnerHtml = reimMoney.ToString("F2"); row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = dt.Rows[i]["remark"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = dt.Rows[i]["auditstutastxt"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = dt.Rows[i]["payStatus"].ToString() == "1" ? "已支付" : "未支付"; row.Controls.Add(cell); this.tablerem.Controls.Add(row); moneyAmount += reimMoney; if (dt.Rows[i]["payStatus"].ToString() == "1") { hasAmount += reimMoney; } } this.lblReimAmount.InnerText = moneyAmount.ToString("F2"); } return(hasAmount); }