private string GetYskmStr(string code) { string strisdz = ""; YsManager ysmgr = new YsManager(); string strdydj = "02"; string result = ""; string strsql = ""; if (!string.IsNullOrEmpty(code)) { if (!string.IsNullOrEmpty(Request["isdz"])) { strisdz = Request["isdz"].ToString(); } if (strisdz == "1") { //根据传参billname 获取billcode // strbillcode = server.GetCellValue("select billcode from bill_main where billname='" + code + "'"); strsql = @"select mxGuid ,fykm as yskmCode,(select '['+yskmCode+']'+yskmMc as yskm from bill_yskm where yskmCode=f.fykm ) as yskmMc,isnull(je ,0) as je from bill_ybbxmxb_fykm f where billCode in(select billcode from bill_main where billname='" + code + "')"; } else { strsql = @"select mxGuid ,fykm as yskmCode,(select '['+yskmCode+']'+yskmMc as yskm from bill_yskm where yskmCode=f.fykm ) as yskmMc,isnull(je ,0) as je from bill_ybbxmxb_fykm f where billCode='" + code + "'"; } DataTable dt = server.GetDataTable(strsql, null); if (dt.Rows.Count > 0) { string billDate = lbBillData.Text; string deptCode = lbBillDept.Text; //预算金额 deptCode = string.IsNullOrEmpty(deptCode) ? "" : deptCode.Split(']')[0].Trim('['); StringBuilder sb = new StringBuilder(); for (int i = 0; i < dt.Rows.Count; i++) { string kmCode = string.IsNullOrEmpty(dt.Rows[i]["yskmMc"].ToString()) ? "" : dt.Rows[i]["yskmMc"].ToString().Split(']')[0].Trim('['); string gcbh = ysmgr.GetYsgcCode(DateTime.Parse(billDate)); if (!string.IsNullOrEmpty(Request["flowid"])) { if (Request["flowid"].ToString() == "ybbx") { strdydj = "02"; } } decimal ysje = ysje = ysmgr.GetYueYs(gcbh, deptCode, kmCode); //预算金额 decimal hfje = ysmgr.GetYueHf(gcbh, deptCode, kmCode, strdydj); //花费金额 //是否启用销售提成模块 bool hasSaleRebate = new ConfigBLL().GetValueByKey("HasSaleRebate").Equals("1"); decimal syje = ysje - hfje; sb.Append("<div class='div-yskm'>"); sb.Append("<table class='tab-yskm'>"); sb.Append("<tr><td class=''>" + Convert.ToString(dt.Rows[i]["yskmMc"]) + "预算金额:¥(" + Convert.ToDecimal(ysje).ToString("N02") + ") 剩余金额:¥(" + Convert.ToDecimal(syje).ToString("N02") + ")" + "报销金额:¥(" + Convert.ToDecimal(dt.Rows[i]["je"]).ToString("N02") + ")</td></tr>"); sb.Append("</table>"); sb.Append("</div>"); DataTable temp = server.GetDataTable("select (select '['+deptCode+']'+deptName from bill_departments where deptCode=a.deptCode) as Dept,isnull(je,0) as je from bill_ybbxmxb_fykm_dept a where kmmxGuid ='" + Convert.ToString(dt.Rows[i]["mxGuid"]) + "'", null); if (temp.Rows.Count > 0) { sb.Append("<div class='div-hs'>"); sb.Append("<h5>核算部门</h5>"); sb.Append("<table class='tab-hs ItemTable' style='color:black;font-size:14px;'>"); // sb.Append("<tr><th class='tdOdd'>部门</th><th>核算金额</th></tr>"); for (int j = 0; j < temp.Rows.Count; j++) { sb.Append("<tr><td >" + Convert.ToString(temp.Rows[j]["Dept"]) + ": ¥" + Convert.ToDecimal(temp.Rows[j]["je"]).ToString("N02") + "</td></tr>"); } sb.Append("</table>"); sb.Append("</div>"); } string strdeptsql = @"select distinct '['+b.xmCode+']'+xmName as xmCode,isnull(je,0) as je from bill_ybbxmxb_hsxm a,bill_xm b where a.xmcode=b.xmcode and kmmxGuid='" + Convert.ToString(dt.Rows[i]["mxGuid"]) + "'"; temp = server.GetDataTable(strdeptsql, null); if (temp.Rows.Count > 0) { sb.Append("<div class='div-hs'>"); sb.Append("<h5>核算项目</h5>"); sb.Append("<table class='tab-hs' style='color:black;font-size:14px;'>"); // sb.Append("<tr><th class='tdOdd'>项目</th><th>核算金额</th></tr>"); for (int j = 0; j < temp.Rows.Count; j++) { sb.Append("<tr><td >" + Convert.ToString(temp.Rows[j]["xmCode"]) + ": ¥" + Convert.ToDecimal(temp.Rows[j]["je"]).ToString("N02") + "</td></tr>"); } sb.Append("</table>"); sb.Append("</div>"); } result = sb.ToString(); } } } return(result); }