private void BindData()
{
string code = Convert.ToString(Request["billCode"]);
if (!string.IsNullOrEmpty(code))
{
ltrTitle.Text = GetTitleByFlowid(Request["flowid"]);
DataTable dt = server.GetDataTable("select (select top 1 (xmmc) from bill_ysgc a,bill_ysmxb b where a.gcbh=b.gcbh and b.billcode=bill_main.billcode ) as ysgc, billCode,billName,convert(varchar(10),billDate,121) as billDate,isnull((select '['+userCode+']'+userName from bill_users where usercode=billUser),billUser) as billuser,isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=billDept),billDept)as billDept,billje from bill_main where billCode=@code", new SqlParameter[] { new SqlParameter("@code", code) });
if (dt.Rows.Count > 0)
{
lbBillCode.Text = Convert.ToString(dt.Rows[0]["ysgc"]);
lbBillData.Text = Convert.ToString(dt.Rows[0]["billDate"]);
lbBillUser.Text = Convert.ToString(dt.Rows[0]["billUser"]);
lbBillDept.Text = Convert.ToString(dt.Rows[0]["billDept"]);
lbBillje.Text = Convert.ToDecimal(dt.Rows[0]["billje"]).ToString("N02");
lbMx.Text = GetYskmStr(code);
}
}
string type = Request["type"];
if (!string.IsNullOrEmpty(type))
{
if (type == "View")
{
aduittr.Visible = false;
btn_audit.Visible = false;
btn_cancel.Visible = false;
//判断是否已提交
DataTable dt = server.GetDataTable("select * from workflowrecord where billCode='" + code + "'", null);
if (dt.Rows.Count > 0)
{
btn_submit.Visible = false;
btn_delete.Visible = false;
if (dt.Rows[0]["rdState"].ToString() == "3")
{
btn_revoke.Visible = true;
}
}
}
if (type == "audit")
{
btn_submit.Visible = false;
btn_delete.Visible = false;
aduittr.Visible = true;
}
}
}
/// <summary>
/// 删除子项
/// </summary>
/// <param name="strMainCode"></param>
/// <returns></returns>
public int DeleteI(string id)
{
DataTable dt = server.GetDataTable("select * from t_returnnote where listid=" + id, null);
string billcode = dt.Rows[0]["billcode"].ToString();
// decimal je=Convert.ToDecimal(dt.Rows[0]["je"]);
if (string.IsNullOrEmpty(id) || string.IsNullOrEmpty(billcode))
{
return(0);
}
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
//删除main
new MainDal().DeleteMain(billcode, tran);
////删除 修改主表已还款金额
//LoanDal.UpdateYhkje(billcode, je, tran);
//删除子表
DataHelper.ExcuteNonQuery("delete from t_returnnote where billcode='" + billcode + "'", tran, null, false);
//LoanDal.DeleteItem(id, tran);
tran.Commit();
return(1);
}
catch
{
tran.Rollback();
throw;
}
}
}
private void BindModel()
{
string code = Convert.ToString(Request["billCode"]);
DataTable dt = server.GetDataTable("select * from bill_lscg where cgbh='" + code + "'", null);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lb_cgbh.Text = ObjectToStr(dr["cgbh"]);
lb_sj.Text = Convert.ToDateTime(ObjectToStr(dr["sj"])).ToString("yyyy-MM-dd");
lb_cbr.Text = server.GetCellValue("select '['+usercode+']'+userName from bill_users where usercode='" + ObjectToStr(dr["cbr"]) + "'");
lb_yjfy.Text = Convert.ToDecimal(ObjectToStr(dr["yjfy"])).ToString("N02");
lb_dept.Text = server.GetCellValue("select '['+deptcode+']'+deptName from bill_departments where deptcode='" + ObjectToStr(dr["cgDept"]) + "'");
lb_cglb.Text = ObjectToStr(dr["cglb"]);
lb_zynr.Text = ObjectToStr(dr["zynr"]);
lb_sm.Text = ObjectToStr(dr["sm"]);
}
string type = Request["type"];
if (!string.IsNullOrEmpty(type))
{
if (type == "View")
{
aduittr.Visible = false;
btn_audit.Visible = false;
btn_cancel.Visible = false;
//判断是否已提交
DataTable dt1 = server.GetDataTable("select * from workflowrecord where billCode='" + code + "'", null);
if (dt1.Rows.Count > 0)
{
btn_submit.Visible = false;
btn_delete.Visible = false;
if (dt1.Rows[0]["rdState"].ToString() == "3")
{
btn_revoke.Visible = true;
}
}
}
if (type == "audit")
{
btn_submit.Visible = false;
btn_delete.Visible = false;
aduittr.Visible = true;
}
}
}
private void BindGk()
{
DataTable dt = server.GetDataTable("select deptCode,'['+deptCode+']'+deptName as deptName from bill_departments where sjDeptCode=(select top 1 deptCode from bill_departments where isnull(sjDeptCode,'')='')", null);
ddlGkDept.DataSource = dt;
ddlGkDept.DataTextField = "deptName";
ddlGkDept.DataValueField = "deptCode";
ddlGkDept.DataBind();
ddlGkDept.Items.Insert(0, new ListItem("请选择", ""));
}
private void BindData()
{
string code = Convert.ToString(Request["billCode"]);
DataTable dt = server.GetDataTable("select distinct maincode,typecode,arrdess,travelDate,reasion,travelplan,needAmount,transport,moreThanStandard,reportCode,jiaotongfei,zhusufei,yewuzhaodaifei,huiyifei,yinshuafei,qitafei,sendDept,b.billCode as billCode,b.billName as billName, convert(varchar(10),b.billdate,121) as billDate,b.billDept as billDept ,b.billje as billje ,b.billuser from bill_travelApplication a, bill_main b where a.mainCode=b.billCode and a.mainCode='" + code + "'", null);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
txt_bh.Text = ObjectToStr(dr["billCode"]);
txt_bm.Text = server.GetCellValue("select '['+deptcode+']'+deptName from bill_departments where deptcode='" + ObjectToStr(dr["sendDept"]) + "'");
txt_billDate.Text = Convert.ToDateTime(ObjectToStr(dr["billDate"])).ToString("yyyy-MM-dd");
txt_userDept.Text = server.GetCellValue("select '['+deptcode+']'+deptName from bill_departments where deptcode='" + ObjectToStr(dr["billDept"]) + "'");
txt_billUser.Text = server.GetCellValue("select '['+usercode+']'+userName from bill_users where usercode='" + ObjectToStr(dr["billuser"]) + "'");
txt_travelDate.Text = ObjectToStr(dr["travelDate"]);
string persons = "";
DataTable pdt = server.GetDataTable("select travelPersionCode as p from bill_travelApplication where mainCode='" + code + "' ", null);
if (pdt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < pdt.Rows.Count; i++)
{
DataTable itemdt = server.GetDataTable("select '['+usercode+']'+userName as userCode,(select '['+deptCode+']'+deptName from bill_departments where deptCode=userDept) as deptCode from bill_users where usercode='" + pdt.Rows[i]["p"].ToString() + "'", null);
sb.Append("<tr><td class='mytdEnenRight tdborder'>" + itemdt.Rows[0]["userCode"] + "</td><td class='mytdEnenRight tdborder'>" + itemdt.Rows[0]["deptCode"] + "</td><td class='tdborder'><input type='button' data-iconpos='notext' data-icon='delete' onclick='RemoveRow(this);'/></td></tr>");
}
persons = sb.ToString();
}
hfpersons.Value = persons;
txt_address.Text = ObjectToStr(dr["arrdess"]);
txt_reasion.Text = ObjectToStr(dr["reasion"]);
txt_plan.Text = ObjectToStr(dr["travelplan"]);
txt_zje.Text = NullToNUm(dr["billje"]);
txt_jtf.Text = NullToNUm(dr["jiaotongfei"]);
txt_zsf.Text = NullToNUm(dr["zhusufei"]);
txt_zdf.Text = NullToNUm(dr["yewuzhaodaifei"]);
txt_ysf.Text = NullToNUm(dr["yinshuafei"]);
txt_qt.Text = NullToNUm(dr["qitafei"]);
txt_jtgj.Text = ObjectToStr(dr["transport"]);
txt_hyf.Text = NullToNUm(dr["huiyifei"]);
ddlIsbz.SelectedValue = ObjectToStr(dr["moreThanStandard"]);
}
}
/// <summary>
///
/// </summary>
/// <param name="stryear">年</param>
/// <param name="strdept">部门</param>
/// <param name="stryskmcode">预算科目编号</param>
/// <returns></returns>
public System.Data.DataTable GetDt(string stryear, string strdept, string stryskmcode)
{
string strselectsql = @"select *,@gkdeptcode as gkdeptcode,(select deptname from bill_departments where deptcode=@gkdeptcode) as gkdeptname from (select yskmcode,(select yskmmc from bill_yskm where yskmCode=bill_yskm_dept.yskmcode) as yskmmc,deptcode,(select deptname from bill_departments where deptcode=bill_yskm_dept.deptcode) as deptname from bill_yskm_dept where yskmcode=@yskmcode) a
left join ( select nian,yskmcode,fjdeptcode,fjbl,(select deptname from bill_departments where deptcode=bili.fjdeptcode) as fjdeptname
from bill_gkfjbili bili where nian=@nian and gkdeptcode=@gkdeptcode and yskmcode=@yskmcode) b
on a.deptcode=b.fjdeptcode";
SqlParameter[] arrsp = new SqlParameter[] { new SqlParameter("@nian", stryear), new SqlParameter("@gkdeptcode", strdept), new SqlParameter("@yskmcode", stryskmcode) };
DataTable dtRel = sqlHelper.GetDataTable(strselectsql, arrsp);
return(dtRel);
}
private void BindData()
{
string userCode = Session["userCode"].ToString();
string strsql = @"select * from ph_sysmenu where menuid in(select distinct menuid from ph_menuRight where objectID='" + userCode + "' and rightType='1' or rightType='2' and objectID = (select userGroup from bill_users where usercode='" + userCode + "')) and isnull(menuState,'0')!='0' order by convert(int, menuOrder )asc";
DataTable dtMenu = server.GetDataTable(strsql, null);
rptMenu.DataSource = dtMenu;
rptMenu.DataBind();
if (dtMenu.Rows.Count < 1)
{
msg.InnerText = "您暂时没有任何操作权限，请联系系统管理员为您分配权限！";
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Header && e.Item.ItemType != ListItemType.Footer)
{
HiddenField hf = e.Item.FindControl("hfCode") as HiddenField;
string code = hf.Value.Trim();
if (!string.IsNullOrEmpty(code))
{
StringBuilder sb = new StringBuilder();
string status = "";
DataTable workflow = server.GetDataTable("select * from workflowrecord where billCode='" + code + "'", null);
if (workflow.Rows.Count == 0)
{
sb.Append("<div class='checkStatus' ><lable>审批状态：未提交</lable></div>");
}
else
{
status = workflow.Rows[0]["rdState"].ToString();
if (status == "1")
{
WorkFlowRecordManager bll = new WorkFlowRecordManager();
string state = bll.WFState(code);
sb.Append("<div class='checkStatus' ><lable>审批状态：" + state + "</lable></div>");
}
else if (status == "2")
{
sb.Append("<div class='checkStatus'><lable>审批状态：审核通过</lable></div>");
}
else if (status == "3")
{
string flowid = server.GetCellValue("select flowid from bill_main where billCode='" + code + "'");
sb.Append("<div class='checkStatus'><lable>审批状态：驳回</lable></div>");
sb.Append("<div style='text-align:center'><a data-role='button' data-inline='true' data-theme='d' onclick=\"RevokeCheck(this,'" + flowid + "','" + code + "')\"><img src='../images/metro/Editor.png' />审核撤销</a></div>");
}
}
Label lb = e.Item.FindControl("lbmx") as Label;
lb.Text = sb.ToString();
HtmlContainerControl hcc = e.Item.FindControl("optionDiv") as HtmlContainerControl;
if (status == "3")
{
hcc.Attributes.CssStyle.Add("display", "none");
}
else if (!string.IsNullOrEmpty(status))
{
hcc.Visible = false;
}
}
}
}
private string GetCodes(string billCode, string dbString)
{
string ret = "";
DataTable dt = server.GetDataTable("select rkCodes from bill_yksq where billCode='" + billCode + "'", null);
for (int i = 0; i < dt.Rows.Count; i++)
{
ret = "" + Convert.ToString(dt.Rows[i]["rkCodes"]) + ",";
}
if (ret.Length > 1)
{
ret = ret.Substring(0, ret.Length - 1);
}
return(ret);
}
private void BindModel()
{
server.ExecuteNonQuery("update bill_msg set readTimes=readtimes+1 where id=" + Request["id"]);
DataTable dt = server.GetDataTable("select * from bill_msg where id=" + Request["id"], null);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lb_tilte.Text = ObjectToStr(dr["title"]);
lb_count.Text = ObjectToStr(dr["readTimes"]);
lb_writer.Text = ObjectToStr(dr["writer"]);
lb_type.Text = ObjectToStr(dr["mstype"]);
lb_addTime.Text = Convert.ToDateTime(dr["date"]).ToString("yyyy-MM-dd");
lb_endTime.Text = Convert.ToDateTime(dr["endtime"]).ToString("yyyy-MM-dd");
lb_content.Text = ObjectToStr(dr["contents"]);
}
}
private void BindData()
{
string code = Convert.ToString(Request["billCode"]);
DataTable dt = server.GetDataTable("select * from bill_lscg where cgbh='" + code + "'", null);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
txt_cgbh.Text = ObjectToStr(dr["cgbh"]);
txt_sj.Text = Convert.ToDateTime(dr["sj"]).ToString("yyyy-MM-dd");
txt_cbr.Text = server.GetCellValue("select '['+usercode+']'+userName from bill_users where usercode='" + ObjectToStr(dr["cbr"]) + "'");
txt_yjfy.Text = ObjectToStr(dr["yjfy"]);
txt_dept.Text = server.GetCellValue("select '['+deptcode+']'+deptName from bill_departments where deptcode='" + ObjectToStr(dr["cgDept"]) + "'");
ddlType.SelectedValue = ObjectToStr(dr["cglb"]);
txt_content.Text = ObjectToStr(dr["zynr"]);
txt_sm.Text = ObjectToStr(dr["sm"]);
}
}
/// <summary>
/// 获取报销金额
/// </summary>
/// <param name="year"></param>
/// <param name="moth"></param>
/// <param name="kmbh"></param>
/// <returns></returns>
public string getbxje(string year, string moth, string kmbh, string deptcode)
{
string strbeg = "";
string strend = "";
string strbx = "0";
string strtimesql = @" select * from bill_Cnpz where year_CN='" + year + "' and year_moth='" + moth + "' ";
DataTable dt = server.GetDataTable(strtimesql, null);
if (dt != null && dt.Rows.Count > 0)
{
strbeg = dt.Rows[0]["beg_time"].ToString();
strend = dt.Rows[0]["end_time"].ToString();
}
string strsql = @" exec dz_hfje '" + strbeg + "','" + strend + "','" + deptcode + "','" + kmbh + "'";
strbx = server.GetCellValue(strsql);
return(strbx);
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Header && e.Item.ItemType != ListItemType.Footer)
{
HiddenField hf = e.Item.FindControl("hfCode") as HiddenField;
string code = hf.Value.Trim();
if (!string.IsNullOrEmpty(code))
{
DataTable dt = server.GetDataTable(" select billcode,(select left(xmmc,8) from bill_ysgc where gcbh=f.gcbh) as ysgc ,yskm as yskmCode,(select '['+yskmCode+']'+yskmMc as yskm from bill_yskm where yskmCode=f.yskm ) as yskmMc,isnull(ysje ,0) as je from bill_ysmxb f where billCode='"+ code + "'", null);
if (dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append(SetKm(dt, "预算过程"));
Label lb = e.Item.FindControl("lbmx") as Label;
lb.Text = sb.ToString();
}
}
}
}
private void BindData()
{
string id = Request["id"];
DataTable dt = server.GetDataTable("select * from bill_msg where id=" + Request["id"], null);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
txt_title.Text = ObjectToStr(dr["title"]);
txt_writer.Text = ObjectToStr(dr["writer"]);
lbType.Text = ObjectToStr(dr["mstype"]);
//ddlType.SelectedValue = ObjectToStr(dr["mstype"]);
txt_addTime.Text = Convert.ToDateTime(dr["date"]).ToString("yyyy-MM-dd");
txt_endTime.Text = Convert.ToDateTime(dr["endtime"]).ToString("yyyy-MM-dd");
txt_content.Text = ObjectToStr(dr["contents"]);
hffj.Value = ObjectToStr(dr["Accessories"]);
hftzr.Value = ObjectToStr(dr["notifiername"]);
txt_addTime.ReadOnly = false;
txt_addTime.BackColor = System.Drawing.Color.FromName("#D9D9D9");
}
}
private void BindData()
{
string code = Convert.ToString(Request["billCode"]);
if (!string.IsNullOrEmpty(code))
{
DataTable dt = server.GetDataTable("select (select top 1 (xmmc) from bill_ysgc a,bill_ysmxb b where a.gcbh=b.gcbh and b.billcode=bill_main.billcode ) as ysgc, billCode,billName,convert(varchar(10),billDate,121) as billDate,isnull((select '['+userCode+']'+userName from bill_users where usercode=billUser),billUser) as billuser,isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=billDept),billDept)as billDept,billje from bill_main where billCode=@code", new SqlParameter[] { new SqlParameter("@code", code) });
if (dt.Rows.Count > 0)
{
lbBillCode.Text = Convert.ToString(dt.Rows[0]["ysgc"]);
lbBillData.Text = Convert.ToString(dt.Rows[0]["billDate"]);
lbBillUser.Text = Convert.ToString(dt.Rows[0]["billUser"]);
lbBillDept.Text = Convert.ToString(dt.Rows[0]["billDept"]);
lbBillje.Text = Convert.ToDecimal(dt.Rows[0]["billje"]).ToString("N02");
lbMx.Text = GetYskmStr(code);
}
//显示附件
string fujian = "";
fujian = server.GetCellValue(" select note2 from bill_main where billcode='" + code + "'");
if (!string.IsNullOrEmpty(fujian))
{
string[] arrTemp = fujian.Split('|');
string[] arrname = arrTemp[0].Split(';');
string[] arrfile = arrTemp[1].Split(';');
for (int i = 0; i < arrname.Length; i++)
{
if (!string.IsNullOrEmpty(arrname[i]))
{
{
this.lalFuJian.Text += "<a href='../AFrame/download.aspx?filename=" + Server.UrlEncode(arrname[i]) + "&filepath=" + Server.UrlEncode(arrfile[i]) + "' target='_blank'>" + arrname[i] + "下载;</a>";
}
}
}
}
else
{
this.lalFuJian.Text = "无";
}
}
string type = Request["type"];
if (!string.IsNullOrEmpty(type))
{
if (type == "View")
{
aduittr.Visible = false;
btn_audit.Visible = false;
btn_cancel.Visible = false;
//判断是否已提交
DataTable dt = server.GetDataTable("select * from workflowrecord where billCode='" + code + "'", null);
if (dt.Rows.Count > 0)
{
btn_submit.Visible = false;
btn_delete.Visible = false;
if (dt.Rows[0]["rdState"].ToString() == "3")
{
btn_revoke.Visible = true;
}
}
}
if (type == "audit")
{
btn_submit.Visible = false;
btn_delete.Visible = false;
aduittr.Visible = true;
}
}
}
private void BindModel()
{
string code = Convert.ToString(Request["billCode"]);
DataTable dt = server.GetDataTable("select distinct maincode,typecode,arrdess,travelDate,reasion,travelplan,needAmount,transport,moreThanStandard,reportCode,jiaotongfei,zhusufei,yewuzhaodaifei,huiyifei,yinshuafei,qitafei,sendDept,b.billCode as billCode,b.billName as billName, convert(varchar(10),b.billdate,121) as billDate,b.billDept as billDept ,b.billje as billje ,b.billuser from bill_travelApplication a, bill_main b where a.mainCode=b.billCode and a.mainCode='" + code + "'", null);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lb_bm.Text = server.GetCellValue("select '['+deptcode+']'+deptName from bill_departments where deptcode='" + ObjectToStr(dr["sendDept"]) + "'");
lb_billDate.Text = Convert.ToDateTime(ObjectToStr(dr["billDate"])).ToString("yyyy-MM-dd");
lb_billUser.Text = server.GetCellValue("select '['+usercode+']'+userName from bill_users where usercode='" + ObjectToStr(dr["billuser"]) + "'");
lb_travelDate.Text = ObjectToStr(dr["travelDate"]);
string persons = "";
DataTable pdt = server.GetDataTable("select travelPersionCode as p from bill_travelApplication where mainCode='" + code + "' ", null);
if (pdt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("<h5>出差人<h5>");
sb.Append("<table class='tab-hs' style='color: Black; font-family: 微软雅黑;'>");
for (int i = 0; i < pdt.Rows.Count; i++)
{
DataTable itemdt = server.GetDataTable("select '['+usercode+']'+userName as userCode,(select '['+deptCode+']'+deptName from bill_departments where deptCode=userDept) as deptCode from bill_users where usercode='" + pdt.Rows[i]["p"].ToString() + "'", null);
//sb.Append("<tr><td class='tdborder'>" + itemdt.Rows[0]["userCode"] + ": " + itemdt.Rows[0]["deptCode"] + "</td><td class='tdborder'></tr>");
sb.Append("<tr><td class='tdborder' style='min-width:120px'>" + itemdt.Rows[0]["userCode"] + "</td><td class='tdborder'>" + itemdt.Rows[0]["deptCode"] + "</td><td class='tdborder'></tr>");
}
sb.Append("</table>");
persons = sb.ToString();
}
chr.InnerHtml = persons;
lb_address.Text = ObjectToStr(dr["arrdess"]);
lb_reasion.Text = ObjectToStr(dr["reasion"]);
lb_plan.Text = ObjectToStr(dr["travelplan"]);
lb_zje.Text = NullToNUm(dr["billje"]);
lb_jtf.Text = NullToNUm(dr["jiaotongfei"]);
lb_zsf.Text = NullToNUm(dr["zhusufei"]);
lb_zdf.Text = NullToNUm(dr["yewuzhaodaifei"]);
lb_hyf.Text = NullToNUm(dr["huiyifei"]);
lb_ysf.Text = NullToNUm(dr["yinshuafei"]);
lb_qt.Text = NullToNUm(dr["qitafei"]);
lb_jtgj.Text = ObjectToStr(dr["transport"]);
lb_isbz.Text = ObjectToStr(dr["moreThanStandard"]) == "0"?"否":"是";
}
string type = Request["type"];
if (!string.IsNullOrEmpty(type))
{
if (type == "View")
{
aduittr.Visible = false;
btn_audit.Visible = false;
btn_cancel.Visible = false;
//判断是否已提交
DataTable dt1 = server.GetDataTable("select * from workflowrecord where billCode='" + code + "'", null);
if (dt1.Rows.Count > 0)
{
btn_submit.Visible = false;
btn_delete.Visible = false;
if (dt1.Rows[0]["rdState"].ToString() == "3")
{
btn_revoke.Visible = true;
}
}
}
if (type == "audit")
{
btn_submit.Visible = false;
btn_delete.Visible = false;
aduittr.Visible = true;
}
}
}
/// <summary>
/// 根据参数获取dataTable 并返回页面导航字符串
/// </summary>
/// <param name="sql">获取数据的sql</param>
/// <param name="parms">sql参数（方便参数化查询）</param>
/// <param name="url">url</param>
/// <param name="pageNav">输出参数 页码导航</param>
/// <returns>请求页面的数据，并返回页面导航</returns>
public static DataTable GetPageData(string sql, string url, out string pageNav)
{
sqlHelper.sqlHelper server = new sqlHelper.sqlHelper();
string pageStr = HttpContext.Current.Request["page"];
int pageIndex = 0;
if (!string.IsNullOrEmpty(pageStr))
{
pageIndex = Convert.ToInt32(pageStr);
}
DataTable dt;
int count = 0;
if (string.IsNullOrEmpty(sql))
{
pageNav = "";
return(null);
}
string conSql = "select count(*) from (" + sql + ") as t";
string dtSql = "select * from ({0}) as t where t.crow>{1} and t.crow <={2}";
dtSql = string.Format(dtSql, sql, pageIndex * 10, (pageIndex + 1) * 10);
count = Convert.ToInt32(server.GetCellValue(conSql));
dt = server.GetDataTable(dtSql, null);
StringBuilder sb = new StringBuilder();
int pageCount = count % 10 == 0 ? (count / 10) : (count / 10 + 1);
int prevNum = pageIndex - 1;
int nextNum = pageIndex + 1;
sb.Append("<p id='page'>");
if (prevNum >= 0)
{
if (url.IndexOf("?") == -1)
{
sb.Append("<a href='" + url + "?page=" + prevNum + "' class='n'><上一页</a>");
}
else
{
sb.Append("<a href='" + url + "&page=" + prevNum + "' class='n'><上一页</a>");
}
}
if (pageCount > 1)
{
if (pageCount <= 7)
{
for (int i = 0; i < pageCount; i++)
{
sb.Append("<a href='" + url + "'> <span class='pc'>" + (i + 1) + "</span></a> ");
if (i == pageIndex)
{
sb.Append("<strong><span class='pc'>" + (i + 1) + "</span></strong> ");
}
}
}
else
{
if (pageIndex + 1 < 5)
{
for (int i = 0; i < 5; i++)
{
sb.Append("<a href='" + url + "'> <span class='pc'>" + (i + 1) + "</span></a> ");
if (i == pageIndex)
{
sb.Append("<strong><span class='pc'>" + (i + 1) + "</span></strong> ");
}
}
sb.Append("…<a href='" + url + "'> <span class='pc'>" + pageCount + "</span></a> ");
}
else if (pageIndex + 1 > pageCount - 4)
{
sb.Append("<a href='" + url + "'> <span class='pc'>" + 1 + "</span></a> …");
for (int i = pageCount - 5; i < pageCount; i++)
{
sb.Append("<a href='" + url + "'> <span class='pc'>" + (i + 1) + "</span></a> ");
if (i == pageIndex)
{
sb.Append("<strong><span class='pc'>" + (i + 1) + "</span></strong> ");
}
}
}
else
{
sb.Append("<a href='" + url + "'> <span class='pc'>" + 1 + "</span></a> …");
for (int i = pageIndex - 2; i <= pageIndex + 2; i++)
{
sb.Append("<a href='" + url + "'> <span class='pc'>" + (i + 1) + "</span></a> ");
if (pageIndex == i)
{
sb.Append("<strong><span class='pc'>" + (i + 1) + "</span></strong> ");
}
}
sb.Append("…<a href='" + url + "'> <span class='pc'>" + pageCount + "</span></a> ");
}
}
}
if (nextNum <= pageCount - 1)
{
if (url.IndexOf("?") == -1)
{
sb.Append("<a href='" + url + "?page=" + nextNum + "' class='n'>下一页></a>");
}
else
{
sb.Append("<a href='" + url + "&page=" + nextNum + "' class='n'>下一页></a>");
}
}
sb.Append("<span class='nums'>共" + count + "条</span>");
sb.Append("</p>");
pageNav = sb.ToString();
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userCode"] == null || Session["userCode"].ToString().Trim() == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "window.location.href='../Login.aspx','_self';", true);
return;
}
string billCode = Request["billCode"];
if (string.IsNullOrEmpty(billCode))
{
Response.Redirect("ybbxEditMain.aspx");
}
string mainStr = "";
if (!string.IsNullOrEmpty(Request["type"]) && Request["type"] == "addmx")
{
btn_save.Visible = false;
mainStr = "select a.billCode,a.billName,a.flowID,a.stepID,a.billUser,b.bxr,convert(varchar(10),a.billDate,121) as billDate,a.billDept,a.loopTimes,a.isgk,a.gkdept,b.bxmxlx,b.bxzy,b.bxsm from bill_main a inner join bill_ybbxmxb b on a.billCode=b.billCode and a.billCode=@billCode";
}
else
{
btn_saveAndMx.Value = "保存并添加明细";
mainStr = "select * from ph_main where billCode=@billCode";
// btn_saveAndMx.Visible=false;
}
main = server.GetDataTable(mainStr, new SqlParameter[] { new SqlParameter("@billCode", billCode) });
//if (main.Rows.Count==0)
//{
// main=server.GetDataTable("select * from ph_main where billCode='"+billCode+"'",null);
//}
//if(main.Rows.Count==0)
//{
// main = server.GetDataTable("select a.billCode,a.billName,a.flowID,a.stepID,a.billUser,b.bxr,convert(varchar(10),a.billDate,121) as billDate,a.billDept,a.loopTimes,a.isgk,a.gkdept,b.bxmxlx,b.bxzy,b.bxsm from bill_main a inner join bill_ybbxmxb b on a.billCode=b.billCode and a.billCode='"+billCode+"'", null);
//}
Label1.Text = main.Rows[0]["billName"].ToString();
if (main.Rows.Count == 0)
{
Response.Redirect("../Login.aspx");
return;
}
if (!IsPostBack)
{
string sql = "";;
if (Convert.ToString(main.Rows[0]["isgk"]) == "1")
{
sql += "select yskmCode,('['+yskmcode+']'+yskmMc)as yskmMc ,isnull(left(yskmCode,len(yskmCode)-2),'') as parentID,(case (select count(*) from bill_yskm where yskmcode like a.yskmcode+'%') when 1 then 1 else 0 end ) as islast from Bill_Yskm a where a.yskmcode in (select yskmcode from bill_yskm_dept where deptcode='" + Convert.ToString(main.Rows[0]["gkDept"]) + "') and kmStatus='1' and dydj='02' and gkfy='1' ";
}
else
{
sql += "select yskmCode, ('['+yskmcode+']'+yskmMc)as yskmMc ,isnull(left(yskmCode,len(yskmCode)-2),'') as parentID ,(case (select count(*) from bill_yskm where yskmcode like a.yskmcode+'%') when 1 then 1 else 0 end ) as islast from Bill_Yskm a where a.yskmcode in (select yskmcode from bill_yskm_dept where deptcode='" + Convert.ToString(main.Rows[0]["billDept"]) + "') and kmStatus='1' and dydj='02' ";
}
if (!string.IsNullOrEmpty(Request["type"]) && Request["type"] == "addmx")
{
sql += " and yskmCode not in(select fykm from bill_main a inner join bill_ybbxmxb_fykm b on a.billCode =b.billCode and a.billCode='" + billCode + "')";
}
DataTable dt = server.GetDataTable(sql, null);
DropDownListHelp ddlHelper = new DropDownListHelp();
ddlHelper.createDropDownTree(dt, "parentID", "", "yskmCode", "yskmMc", "yskmCode asc", DropDownList1);
hfDept.Value = Convert.ToString(main.Rows[0]["billDept"]);
hfIsgk.Value = Convert.ToString(main.Rows[0]["isgk"]);
hfBillDate.Value = Convert.ToString(main.Rows[0]["billDate"]);
hfDydj.Value = "02";
hfBxlx.Value = Convert.ToString(main.Rows[0]["bxmxlx"]);
DropDownList1.Items[0].Text = "请选择报销费用";
}
}
private void BindData()
{
ltrTitle.Text = GetTitleByFlowid(Request["flowid"]);
string code = Convert.ToString(Request["billCode"]);
string strisdz = "";
if (!string.IsNullOrEmpty(Request["isdz"]))
{
strisdz = Request["isdz"].ToString();
}
if (!string.IsNullOrEmpty(code))
{
DataTable dt = new DataTable();
if (strisdz == "1")
{
dt = server.GetDataTable("select a.billCode,a.billName,convert(varchar(10),a.billDate,121) as billDate,isnull((select '['+userCode+']'+userName from bill_users where usercode=a.billUser),a.billUser) as billuser,isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=a.billDept),a.billDept)as billDept,(case a.isgk when '1' then '是' else '否' end ) as isgk, isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=a.gkdept),a.gkdept)as gkdept,isnull((select dicName from bill_dataDic where dicType='02' and dicCode=b.bxmxlx),b.bxmxlx) as bxmxlx,b.bxzy,b.bxsm,a.billje,b.note0 as xyxx,b.note1 as bxfy,b.Bxrzh from bill_main a,bill_ybbxmxb b where a.billCode=b.billCode and a.billname=@code", new SqlParameter[] { new SqlParameter("@code", code) });
}
else
{
dt = server.GetDataTable("select a.billCode,a.billName,convert(varchar(10),a.billDate,121) as billDate,isnull((select '['+userCode+']'+userName from bill_users where usercode=a.billUser),a.billUser) as billuser,isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=a.billDept),a.billDept)as billDept,(case a.isgk when '1' then '是' else '否' end ) as isgk, isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=a.gkdept),a.gkdept)as gkdept,isnull((select dicName from bill_dataDic where dicType='02' and dicCode=b.bxmxlx),b.bxmxlx) as bxmxlx,b.bxzy,b.bxsm,a.billje from bill_main a,bill_ybbxmxb b where a.billCode=b.billCode and a.billCode=@code", new SqlParameter[] { new SqlParameter("@code", code) });
}
if (dt.Rows.Count > 0)
{
lbBillCode.Text = Convert.ToString(dt.Rows[0]["billName"]);
lbBillData.Text = Convert.ToString(dt.Rows[0]["billDate"]);
lbBillUser.Text = Convert.ToString(dt.Rows[0]["billUser"]);
lbBillDept.Text = Convert.ToString(dt.Rows[0]["billDept"]);
lbIsgk.Text = Convert.ToString(dt.Rows[0]["isgk"]);
if (lbIsgk.Text == "否")
{
tdgk.Visible = false;
}
lbGkdept.Text = Convert.ToString(dt.Rows[0]["gkdept"]);
lbBillType.Text = Convert.ToString(dt.Rows[0]["bxmxlx"]);
lbBxzy.Text = Convert.ToString(dt.Rows[0]["bxzy"]);
lbBxsm.Text = Convert.ToString(dt.Rows[0]["bxsm"]);
lbBillje.Text = Convert.ToDecimal(dt.Rows[0]["billje"]).ToString("N02");
//录入信息
string[] arrxyxx = dt.Rows[0]["xyxx"].ToString().Split(new string[] { "|&|" }, StringSplitOptions.None);
if (arrxyxx.Length > 1)
{
if (!string.IsNullOrEmpty(arrxyxx[0]))
{
lblszfx.Text = arrxyxx[0];
}
if (!string.IsNullOrEmpty(arrxyxx[1]))
{
lblxyxm.Text = arrxyxx[1];
}
if (!string.IsNullOrEmpty(arrxyxx[2]))
{
lblsznj.Text = arrxyxx[2];
}
if (!string.IsNullOrEmpty(arrxyxx[3]))
{
lblxybh.Text = arrxyxx[3];
}
if (!string.IsNullOrEmpty(arrxyxx[4]))
{
lblqdsj.Text = arrxyxx[4];
}
}
string[] arr = dt.Rows[0]["Bxrzh"].ToString().Split(new string[] { "|&|" }, StringSplitOptions.None);
if (arr.Length > 1)
{
if (arr.Length == 3)
{
lblhm.Text = arr[1];
lbljhzh.Text = arr[0];
}
else if (arr.Length == 2)
{
lblhm.Text = arr[1];
lbljhzh.Text = arr[0];
}
}
//报销费用
string[] arrbxfy = dt.Rows[0]["bxfy"].ToString().Split(new string[] { "|&|" }, StringSplitOptions.None);
if (arrbxfy.Length > 1)
{
if (!string.IsNullOrEmpty(arrbxfy[0]))
{
lblxyfdfy.Text = arrbxfy[0];
}
if (!string.IsNullOrEmpty(arrbxfy[1]))
{
lblyxfks.Text = arrbxfy[1];
}
if (!string.IsNullOrEmpty(arrbxfy[2]))
{
lbldyksdj.Text = arrbxfy[2];
}
if (!string.IsNullOrEmpty(arrbxfy[3]))
{
lblyxffy.Text = arrbxfy[3];
}
if (!string.IsNullOrEmpty(arrbxfy[4]))
{
lblykqtfy.Text = arrbxfy[4];
}
}
lbMx.Text = GetYskmStr(code);
}
//显示附件
string fujian = "";
if (strisdz == "1")
{
string strfjsql = @"select fujian from bill_ybbxmxb where billCode in (select billcode from bill_main where billname='" + code + "')";
fujian = server.GetCellValue(strfjsql);
}
else
{
fujian = server.GetCellValue("select fujian from bill_ybbxmxb where billCode ='" + Request["billCode"] + "'");
}
if (!string.IsNullOrEmpty(fujian))
{
string[] arrTemp = fujian.Split('|');
string[] arrname = arrTemp[0].Split(';');
string[] arrfile = arrTemp[1].Split(';');
for (int i = 0; i < arrname.Count(); i++)
{
if (!string.IsNullOrEmpty(arrname[i]))
{
{
this.lalFuJian.Text += "<a href='../AFrame/download.aspx?filename=" + Server.UrlEncode(arrname[i]) + "&filepath=" + Server.UrlEncode(arrfile[i]) + "' target='_blank'>" + arrname[i] + "下载;</a>";
}
}
}
}
else
{
this.lalFuJian.Text = "无";
}
}
string type = Request["type"];
if (!string.IsNullOrEmpty(type))
{
if (type == "View")
{
aduittr.Visible = false;
btn_audit.Visible = false;
btn_cancel.Visible = false;
//判断是否已提交
DataTable dt = server.GetDataTable("select * from workflowrecord where billCode='" + code + "'", null);
if (dt.Rows.Count > 0)
{
btn_submit.Visible = false;
btn_delete.Visible = false;
if (dt.Rows[0]["rdState"].ToString() == "3")
{
btn_revoke.Visible = true;
}
}
}
if (type == "audit")
{
btn_submit.Visible = false;
btn_delete.Visible = false;
aduittr.Visible = true;
}
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Header && e.Item.ItemType != ListItemType.Footer)
{
HiddenField hf = e.Item.FindControl("hfCode") as HiddenField;
if (Request["isdz"].ToString() == "1")
{
hf = e.Item.FindControl("hfname") as HiddenField;
}
string code = hf.Value.Trim();
HiddenField billdate = e.Item.FindControl("hiddatetime") as HiddenField;
HiddenField hiddeptCode = e.Item.FindControl("hidbillDept") as HiddenField;
string billDate = billdate.Value;
string deptCode = hiddeptCode.Value;
if (!string.IsNullOrEmpty(code))
{
string 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 1=1";
if (Request["isdz"].ToString() == "1")
{
strsql += " and billCode in(select billcode from bill_main where billname=('" + code + "'))";
}
else
{
strsql += " and billCode='" + code + "'";
}
DataTable dt = server.GetDataTable(strsql, null);
if (dt.Rows.Count > 0)
{
string strworksql = @"select * from workflowrecord where billCode='" + code + "'";
DataTable workflow = server.GetDataTable(strworksql, null);
string status = "";
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
//预算金额
string strdydj = "02";
deptCode = string.IsNullOrEmpty(deptCode) ? "" : deptCode.Split(']')[0].Trim('[');
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='tdOdd'>费用科目:</td><td>" + Convert.ToString(dt.Rows[i]["yskmMc"]) + "</td></tr>");
sb.Append("<tr><td>" + 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'>");
// sb.Append("<tr><th class='tdOdd'>部门</th><th>核算金额</th></tr>");
for (int j = 0; j < temp.Rows.Count; j++)
{
sb.Append("<tr><td class='tdOdd'>" + Convert.ToString(temp.Rows[j]["Dept"]) + ": " + Convert.ToDecimal(temp.Rows[j]["je"]).ToString("N02") + "￥</td></tr>");
}
sb.Append("</table>");
sb.Append("</div>");
}
temp = server.GetDataTable("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"]) + "'", null);
if (temp.Rows.Count > 0)
{
sb.Append("<div class='div-hs'>");
sb.Append("<h5>核算项目</h5>");
sb.Append("<table class='tab-hs ItemTable'>");
// sb.Append("<tr><th class='tdOdd'>项目</th><th>核算金额</th></tr>");
for (int j = 0; j < temp.Rows.Count; j++)
{
sb.Append("<tr><td class='tdOdd'>" + Convert.ToString(temp.Rows[j]["xmCode"]) + ": " + Convert.ToDecimal(temp.Rows[j]["je"]).ToString("N02") + "￥</td></tr>");
}
sb.Append("</table>");
sb.Append("</div>");
}
}
if (workflow.Rows.Count == 0)
{
sb.Append("<div class='checkStatus' ><lable>审批状态：未提交</lable></div>");
}
else
{
status = workflow.Rows[0]["rdState"].ToString();
if (status == "1")
{
WorkFlowRecordManager bll = new WorkFlowRecordManager();
string state = bll.WFState(code);
sb.Append("<div class='checkStatus' ><lable>审批状态：" + state + "</lable></div>");
}
else if (status == "2")
{
sb.Append("<div class='checkStatus'><lable>审批状态：审核通过</lable></div>");
}
else if (status == "3")
{
string flowid = server.GetCellValue("select flowid from bill_main where billCode='" + code + "'");
sb.Append("<div class='checkStatus'><lable>审批状态：驳回</lable></div>");
sb.Append("<div style='text-align:center'><a data-role='button' data-inline='true' data-theme='d' onclick=\"RevokeCheck(this,'" + flowid + "','" + code + "')\"><img src='../images/metro/Editor.png' />审核撤销</a></div>");
}
}
Label lb = e.Item.FindControl("lbmx") as Label;
lb.Text = sb.ToString();
HtmlContainerControl hcc = e.Item.FindControl("optionDiv") as HtmlContainerControl;
if (status == "3")
{
hcc.Attributes.CssStyle.Add("display", "none");
}
else if (!string.IsNullOrEmpty(status))
{
hcc.Visible = false;
}
}
}
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Header && e.Item.ItemType != ListItemType.Footer)
{
HiddenField hf = e.Item.FindControl("hfCode") as HiddenField;
HiddenField billdate = e.Item.FindControl("hiddatetime") as HiddenField;
HiddenField hiddeptCode = e.Item.FindControl("hidbillDept") as HiddenField;
string billDate = billdate.Value;
string deptCode = hiddeptCode.Value;
string code = hf.Value.Trim();
string strdydj = "02";
if (!string.IsNullOrEmpty(code))
{
//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 + "'
string strkmsql = @"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 + "')";
DataTable dt = server.GetDataTable(strkmsql, null);
if (dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
//预算金额
deptCode = string.IsNullOrEmpty(deptCode) ? "" : deptCode.Split(']')[0].Trim('[');
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'>");
// 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>");
}
temp = server.GetDataTable("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"]) + "'", null);
if (temp.Rows.Count > 0)
{
sb.Append("<div class='div-hs'>");
sb.Append("<h5>核算项目</h5>");
sb.Append("<table class='tab-hs'>");
// 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>");
}
}
Label lb = e.Item.FindControl("lbmx") as Label;
lb.Text = sb.ToString();
}
}
}
}
private void BindData()
{
ltrTitle.Text = GetTitleByFlowid(Request["flowid"]);
string code = Convert.ToString(Request["Code"]);
string strisdz = "";
if (!string.IsNullOrEmpty(Request["isdz"]))
{
strisdz = Request["isdz"].ToString();
}
if (!string.IsNullOrEmpty(code))
{
DataTable dt = new DataTable();
//if (strisdz == "1")
//{
// dt = server.GetDataTable("select a.billCode,a.billName,convert(varchar(10),a.billDate,121) as billDate,isnull((select '['+userCode+']'+userName from bill_users where usercode=a.billUser),a.billUser) as billuser,isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=a.billDept),a.billDept)as billDept,(case a.isgk when '1' then '是' else '否' end ) as isgk, isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=a.gkdept),a.gkdept)as gkdept,isnull((select dicName from bill_dataDic where dicType='02' and dicCode=b.bxmxlx),b.bxmxlx) as bxmxlx,b.bxzy,b.bxsm,a.billje,b.note0 as xyxx,b.note1 as bxfy,b.Bxrzh from bill_main a,bill_ybbxmxb b where a.billCode=b.billCode and a.billname=@code", new SqlParameter[] { new SqlParameter("@code", code) });
//}
//else
//{
dt = server.GetDataTable("select a.billCode,a.billName,a.BillName2,a.Note2,convert(varchar(10),a.billDate,121) as billDate,isnull((select '['+userCode+']'+userName from bill_users where usercode=a.billUser),a.billUser) as billuser,isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=a.billDept),a.billDept)as billDept,(case a.isgk when '1' then '是' else '否' end ) as isgk, isnull((select '['+deptCode+']'+deptname from bill_departments where deptCode=a.gkdept),a.gkdept)as gkdept,a.billje from bill_main a where a.billCode=@code", new SqlParameter[] { new SqlParameter("@code", code) });
//}
if (dt.Rows.Count > 0)
{
lbBillCode.Text = Convert.ToString(dt.Rows[0]["billName"]);
lbBillData.Text = Convert.ToString(dt.Rows[0]["billDate"]);
lbBillUser.Text = Convert.ToString(dt.Rows[0]["billuser"]);
lbBillDept.Text = Convert.ToString(dt.Rows[0]["billDept"]);
lbBillje.Text = Convert.ToDecimal(dt.Rows[0]["billje"]).ToString("N02");
txtSm.Text = Convert.ToString(dt.Rows[0]["BillName2"]);
lbBxsm.Text = Convert.ToString(dt.Rows[0]["Note2"]);
}
//显示附件
string fujian = "";
//if (strisdz == "1")
//{
fujian = server.GetCellValue("select top 1 note3 from bill_main where billcode='" + code + "'");
// string strfjsql = @"select fujian from bill_ybbxmxb where billCode in (select billcode from bill_main where billname='" + code + "')";
// fujian = server.GetCellValue(strfjsql);
//}
//else
//{
//fujian = server.GetCellValue("select fujian from bill_ybbxmxb where billCode ='" + Request["billCode"] + "'");
// }
if (!string.IsNullOrEmpty(fujian))
{
string[] arrTemp = fujian.Split('|');
string[] arrname = arrTemp[0].Split(';');
string[] arrfile = arrTemp[1].Split(';');
for (int i = 0; i < arrname.Count(); i++)
{
if (!string.IsNullOrEmpty(arrname[i]))
{
{
this.lalFuJian.Text += "<a href='../AFrame/download.aspx?filename=" + Server.UrlEncode(arrname[i]) + "&filepath=" + Server.UrlEncode(arrfile[i]) + "' target='_blank'>" + arrname[i] + "下载;</a>";
}
}
}
}
else
{
this.lalFuJian.Text = "无";
}
}
string type = Request["type"];
if (!string.IsNullOrEmpty(type))
{
if (type == "View")
{
aduittr.Visible = false;
btn_audit.Visible = false;
btn_cancel.Visible = false;
//判断是否已提交
DataTable dt = server.GetDataTable("select * from workflowrecord where billCode='" + code + "'", null);
if (dt.Rows.Count > 0)
{
btn_submit.Visible = false;
btn_delete.Visible = false;
if (dt.Rows[0]["rdState"].ToString() == "3")
{
btn_revoke.Visible = true;
}
}
}
if (type == "audit")
{
btn_submit.Visible = false;
btn_delete.Visible = false;
aduittr.Visible = true;
}
}
}
