dengyu
/
DS7
1
0
Fork 0
Code Issues Pull Requests Projects 1 Releases Wiki Activity
You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
DS7_HYRD
ShenZhenCHJY
DS7_JinGang
dev
QDHHYT
master
临时发布20240103
DS7_JingHan
DS7Zhanhao
HuanHaiYunTong
shenzhenchjy
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'QDHHYT'
${ noResults }
DS7/DSWebMobileService/ChfeeAuditServer.asmx.cs

360 lines
15 KiB
C#
Raw Permalink Normal View History Unescape Escape

'first'
2 years ago
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using DSWeb.MvcShipping.Models.MsChFee;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Text;
using System.Data;
using DSWeb.EntityDA;
namespace DSWebMobileService
{
/// <summary>
/// ChfeeAuditServer 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
// [System.Web.Script.Services.ScriptService]
public class ChfeeAuditServer : System.Web.Services.WebService
{
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public static List<MsChFee> GetDataList(string gid, string bsno, int type, string optype, string isAll, string userid, string username, string companyid)
{
var rangstr = GetRangDAStr(type, optype, userid, username, companyid);
var WorkFlowNameM = "FeeModifyAudit";
var WorkFlowName = "FeeRecvPayAudit";
if (optype == "op_seae")
{
WorkFlowNameM = "FeeModifyAudit";
WorkFlowName = "FeeRecvPayAudit";
} if (optype == "op_seai")
{
WorkFlowNameM = "FeeSeaiModifyAudit";
WorkFlowName = "FeeSeaiRecvPayAudit";
} if (optype == "op_aire")
{
WorkFlowNameM = "AireFeeModify";
WorkFlowName = "AireFeeAudit";
} if (optype == "op_airi")
{
WorkFlowNameM = "AiriFeeModify";
WorkFlowName = "AiriFeeAudit";
} if (optype == "op_apply")
{
WorkFlowNameM = "ApplyFeeModify";
WorkFlowName = "ApplyFeeAudit";
} if (optype == "op_bulk")
{
WorkFlowNameM = "BulkFeeModify";
WorkFlowName = "BulkFeeAudit";
} if (optype == "op_other" || optype == "tMsWlPcHead")
{
WorkFlowNameM = "FeeOpOtherModifyAudit";
WorkFlowName = "FeeOpOpOtherRecvPayAudit";
} if (optype == "op_railway")
{
WorkFlowNameM = "RailwayFeeModify";
WorkFlowName = "RailwayFeeAudit";
}
if (optype == "op_railway")
{
WorkFlowNameM = "RailwayFeeModify";
WorkFlowName = "RailwayFeeAudit";
}
var strSql = new StringBuilder();
strSql.Append("SELECT top 1 ");
strSql.Append("GId,ch_fee.BsNo,FeeStatus,");
strSql.Append("(select EnumValueName from tSysEnumValue where LangId=0 and EnumTypeID=99024 and EnumValueID=ch_fee.FeeStatus) as FeeStatus_Ref");
strSql.Append(",FeeType,");
strSql.Append("(select EnumValueName from tSysEnumValue where LangId=0 and EnumTypeID=99020 and EnumValueID=ch_fee.FeeType) as FeeType_Ref");
strSql.Append(",FeeName,");
strSql.Append("FeeDescription,CustomerType,CustomerName,");
strSql.Append("Unit,UnitPrice,Quantity,TaxRate,TaxUnitPrice,NoTaxAmount,Amount,AccTaxRate,Currency,ExChangerate,ch_fee.Reason");
strSql.Append(",Remark,Commissionrate,Settlement,Invoice,OrderAmount,OrderInvoice,SubmitDate");
strSql.Append(",Auditoperator,AuditDate,EnteroPerator,EnterDate,DebitNo,IsDebit,IsOpen");
strSql.Append(",(select ShowName from [user] where GID=ch_fee.EnteroPerator) as OpName");
strSql.Append(",IsAdvancedpay,Sort,IsInvoice,FeeFrt,IsCrmOrderFee,AuditStatus,InvoiceNum");
strSql.Append(",ChequeNum,WmsOutBsNo,LineNum");
if (isAll == "1")
{
strSql.Append(",dbo.[GetUsingStep](wu.WORKFLOWID,wu.currentid,'" + userid + "',wu.stepno) as IsAudit ");
strSql.Append(" from ch_fee left join workflow_using wu on wu.bsno=ch_fee.GID ");
strSql.Append(" where ch_fee.GId='" + gid + "' ");
/*if (type != 0)
strSql.Append(" and ch_fee.FeeType=" + type);
strSql.Append(" and dbo.[GetUsingStep](wu.WORKFLOWID,wu.currentid,'" + userid + "',wu.stepno)>0 and (wu.WORKFLOWID=dbo.[GetBSNOWorkFlowID]('" + WorkFlowName + "',ch_fee.GID) or wu.WORKFLOWID=dbo.[GetBSNOWorkFlowID]('" + WorkFlowNameM + "',ch_fee.GID)) ");*/
}
else if (isAll == "2")
{
strSql.Append(",0 as IsAudit ");
strSql.Append(" from ch_fee ");
strSql.Append(" where ch_fee.GId='" + gid + "' ");
/*if (type != 0)
strSql.Append(" and ch_fee.FeeType=" + type);
strSql.Append(" and ch_fee.FeeStatus=0 AND ch_fee.GID IN (select distinct billno from workflow_do where auditor='" + userid + "' ) ");*/
}
else
{
strSql.Append(",dbo.[GetUsingStep](wu.WORKFLOWID,wu.currentid,'" + userid + "',wu.stepno) as IsAudit ");
strSql.Append(" from ch_fee left join workflow_using wu on wu.bsno=ch_fee.GID and wu.FINISHED=0 ");
strSql.Append(" where ch_fee.GId='" + gid + "' ");
/*if (type != 0)
strSql.Append(" and ch_fee.FeeType=" + type);*/
}
strSql.Append(" order by sort,LineNum ");
return SetData(strSql);
}
private static List<MsChFee> SetData(StringBuilder strSql)
{
var bodyList = new List<MsChFee>();
Database db = DatabaseFactory.CreateDatabase();
using (IDataReader reader = db.ExecuteReader(CommandType.Text, strSql.ToString()))
{
while (reader.Read())
{
MsChFee data = new MsChFee();
#region Set DB data to Object
data.GId = Convert.ToString(reader["GId"]);
data.BsNo = Convert.ToString(reader["BsNo"]);
data.FeeStatus = Convert.ToInt16(reader["FeeStatus"]);
data.FeeStatus_Ref = Convert.ToString(reader["FeeStatus_Ref"]);
data.FeeType = Convert.ToDecimal(reader["FeeType"]);
data.FeeName = Convert.ToString(reader["FeeName"]);
data.FeeDescription = Convert.ToString(reader["FeeDescription"]);
data.CustomerType = Convert.ToString(reader["CustomerType"]);
data.CustomerName = Convert.ToString(reader["CustomerName"]);
data.Unit = Convert.ToString(reader["Unit"]);
if (reader["UnitPrice"] != DBNull.Value)
data.UnitPrice = Convert.ToDecimal(reader["UnitPrice"]);
if (reader["Quantity"] != DBNull.Value)
data.Quantity = Convert.ToDecimal(reader["Quantity"]);
if (reader["TaxRate"] != DBNull.Value)
data.TaxRate = Convert.ToDecimal(reader["TaxRate"]);
if (reader["TaxUnitPrice"] != DBNull.Value)
data.TaxUnitPrice = Convert.ToDecimal(reader["TaxUnitPrice"]);
if (reader["NoTaxAmount"] != DBNull.Value)
data.NoTaxAmount = Convert.ToDecimal(reader["NoTaxAmount"]);
data.Amount = Convert.ToDecimal(reader["Amount"]);
if (reader["AccTaxRate"] != DBNull.Value)
data.AccTaxRate = Convert.ToDecimal(reader["AccTaxRate"]);
data.Currency = Convert.ToString(reader["Currency"]);
if (reader["ExChangerate"] != DBNull.Value)
data.ExChangerate = Convert.ToDecimal(reader["ExChangerate"]);
data.Reason = Convert.ToString(reader["Reason"]);
data.Remark = Convert.ToString(reader["Remark"]);
data.Commissionrate = Convert.ToDecimal(reader["Commissionrate"]);
data.Settlement = Convert.ToDecimal(reader["Settlement"]);
if (reader["Invoice"] != DBNull.Value)
data.Invoice = Convert.ToDecimal(reader["Invoice"]);
data.OrderAmount = Convert.ToDecimal(reader["OrderAmount"]);
data.OrderInvoice = Convert.ToDecimal(reader["OrderInvoice"]);
if (reader["SubmitDate"] != DBNull.Value)
data.SubmitDate = Convert.ToDateTime(reader["SubmitDate"]);
data.Auditoperator = Convert.ToString(reader["Auditoperator"]);
if (reader["AuditDate"] != DBNull.Value)
data.AuditDate = Convert.ToDateTime(reader["AuditDate"]);
data.EnteroPerator = Convert.ToString(reader["EnteroPerator"]);
data.OpName = Convert.ToString(reader["OpName"]);
if (reader["EnterDate"] != DBNull.Value)
data.EnterDate = Convert.ToDateTime(reader["EnterDate"]);
data.DebitNo = Convert.ToString(reader["DebitNo"]);
data.IsDebit = Convert.ToString(reader["IsDebit"]);
data.IsOpen = Convert.ToString(reader["IsOpen"]);
data.IsAdvancedpay = Convert.ToString(reader["IsAdvancedpay"]);
data.Sort = Convert.ToString(reader["Sort"]);
data.IsInvoice = Convert.ToString(reader["IsInvoice"]);
data.FeeFrt = Convert.ToString(reader["FeeFrt"]);
data.IsCrmOrderFee = Convert.ToString(reader["IsCrmOrderFee"]);
data.AuditStatus = Convert.ToDecimal(reader["AuditStatus"]);
data.InvoiceNum = Convert.ToString(reader["InvoiceNum"]);
data.ChequeNum = Convert.ToString(reader["ChequeNum"]);
data.WmsOutBsNo = Convert.ToString(reader["WmsOutBsNo"]);
data.LineNum = Convert.ToDecimal(reader["LineNum"]);
if (reader["IsAudit"] != DBNull.Value)
data.IsAudit = Convert.ToString(reader["IsAudit"]);
#endregion
bodyList.Add(data);
}
reader.Close();
}
return bodyList;
}
public static string GetRangDAStr(int type, string optype, string userid, string username, string companyid)
{
string str = "";
string modustr = "";
if (type == 1)
{
if (optype == "op_seae")
{
modustr = "modRecvFeeManagement";
}
else if (optype == "op_apply")
{
modustr = "modApplyRecvFeeManagement";
}
else if (optype == "op_seai")
{
modustr = "modSeaiRecvFeeManagement";
}
else if (optype == "op_aire")
{
modustr = "modAireRecvFeeManagement";
}
else if (optype == "op_airi")
{
modustr = "modAiriRecvFeeManagement";
}
else if (optype == "op_other" || optype == "tMsWlPcHead")
{
modustr = "modOtherRecvFeeManagement";
}
else if (optype == "op_bulk")
{
modustr = "modBulkRecvFeeManagement";
}
else if (optype == "op_railway")
{
modustr = "modRailwayRecvFeeManagement";
}
else if (optype == "import_main")
{
modustr = "modImportTrade";
}
}
else if (type == 2)
{
if (optype == "op_seae")
{
modustr = "modPayFeeManagement";
}
else if (optype == "op_apply")
{
modustr = "modApplyPayFeeManagement";
}
else if (optype == "op_seai")
{
modustr = "modSeaiPayFeeManagement";
}
else if (optype == "op_aire")
{
modustr = "modAirePayFeeManagement";
}
else if (optype == "op_airi")
{
modustr = "modAiriPayFeeManagement";
}
else if (optype == "op_other" || optype == "tMsWlPcHead")
{
modustr = "modOtherPayFeeManagement";
}
else if (optype == "op_bulk")
{
modustr = "modBulkPayFeeManagement";
}
else if (optype == "op_railway")
{
modustr = "modRailwayPayFeeManagement";
}
else if (optype == "import_main")
{
modustr = "modImportTrade";
}
}
var strSql = new StringBuilder();
strSql.Append("SELECT ");
strSql.Append(" VISIBLERANGE,OPERATERANGE ");
strSql.Append(" from VW_User_Authority ");
strSql.Append(" where [NAME]='" + modustr + "' and USERID='" + userid + "' and ISDELETE=0");
string visiblerange = "4";
string operaterange = "4";
Database db = DatabaseFactory.CreateDatabase();
using (IDataReader reader = db.ExecuteReader(CommandType.Text, strSql.ToString()))
{
while (reader.Read())
{
visiblerange = Convert.ToString(reader["VISIBLERANGE"]);
operaterange = Convert.ToString(reader["OPERATERANGE"]);
break;
}
reader.Close();
}
if (visiblerange == "4")
{
str = " ENTEROPERATOR='" + userid + "'";
}
else if (visiblerange == "3")
{
str = " ENTEROPERATOR='" + userid + "'";
}
else if (visiblerange == "2")
{
var rangeDa = new RangeDA();
var deptname = rangeDa.GetDEPTNAME(userid);
str = " ENTEROPERATOR in (select USERID from user_company where COMPANYID='" + companyid + "') and ENTEROPERATOR in (select userid from user_baseinfo where DEPTNAME='" + deptname + "')";
}
else if (visiblerange == "1")
{
str = " ENTEROPERATOR in (select USERID from user_company where COMPANYID='" + companyid + "') ";
}
else if (visiblerange == "0")
{
str = " 1=1 ";
}
return str;
}
}
}