}
else if (key == “PaymentStatement” && innerid != “”)
{
result = PaymentStatement(innerid);
context.Response.Write(result);
}
#region 结算单信息
public string PaymentStatement(string _innerid)
{
try
{
string sql = @”select InnerID,pFinalClient,pOrderNo from se_ProjectMain where InnerID='” + _innerid + “‘”;
DataTable dt = SqlShift.GetDataTable(sql);
if (!CommonClass.DTRow.CheckDtIsEmpty(dt))
{
StringBuilder json = new StringBuilder();
json.Append(“”innerid”:””+dt.Rows[0][“InnerID”].ToString()+”””);
json.Append(“,”finalclient”:”” + dt.Rows[0][“pFinalClient”].ToString() + “””);
json.Append(“,”orderno”:”” + dt.Rows[0][“pOrderNo”].ToString() + “””);
json.Append(“,”workinghours”:” + GetWorkingHours(_innerid));
return “{” + json.ToString().Trim(‘,’) + “}”;
}
else
{
