public VoucherBaseResp ExecuteAll(VoucherBaseReq baseReq)
{
if (baseReq == null)
{
return(VoucherBaseResp.CreateNotValidSignResp());
}
var validResp = VoucherBaseResp.CreateErrorResp();
try
{
var requestReqDict = baseReq.ToStringDictionary(true);
validResp = this.VerifyRequest(requestReqDict); //验证签名
if (validResp.isSignValidResp())
{
// 验证通过, 执行方法
validResp = this.Execute(baseReq);
validResp.SetExecuteSuccess(true);
}
}
catch (Exception e)
{
validResp.SetExecuteSuccess(false);
var message = string.Format("Error occured when executing voucher method, message: {0}, source: {1}",
e.Message, e.Source);
validResp.SetMsgAndMsgNo(WebServiceLib.SubStr(message, 1000), "99");
LogHelper.Error(string.Format("Error occured when executing voucher method, message: {0}, source: {1}, stackTrace: {2}", e.Message, e.Source, e.StackTrace));
}
validResp.Sign = this.gate.CreateSign(validResp.ToStringDictionary(true)); //生成签名
return(validResp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newObj = baseReq as VoucherCheckReq; // 强制转换
VoucherCheckResp checkResp = new VoucherCheckResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_VoucherCheck", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNO", OracleType.VarChar)).Value = newObj.VoucherNo;
oralceComm.Parameters.Add(new OracleParameter("P_STORENO", OracleType.VarChar)).Value = newObj.StoreNo;
OracleParameter PItemNo = new OracleParameter("V_DISNO", OracleType.VarChar);
PItemNo.Direction = ParameterDirection.Output;
PItemNo.Size = 50;
oralceComm.Parameters.Add(PItemNo);
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Direction = ParameterDirection.Output;
PRtnMsg.Size = 100;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Direction = ParameterDirection.Output;
PRTNMSGNO.Size = 50;
oralceComm.Parameters.Add(PRTNMSGNO);
oralceComm.ExecuteNonQuery();
checkResp.DisNo = PItemNo.Value.ToString();
checkResp.RtnMsg = PRtnMsg.Value.ToString();
checkResp.RtnMsgNo = PRTNMSGNO.Value.ToString();
}
catch (Exception e)
{
checkResp.RtnMsgNo = "99";
checkResp.RtnMsg = "异常情况：" + e.Message.ToString();
}
}
return(checkResp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newObj = baseReq as VoucherObsoleteReq; // 强制转换
VoucherObsoleteResp resp = new VoucherObsoleteResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_VOUCHER_OBSOLETE", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
oralceComm.Parameters.Clear();
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNO", OracleType.VarChar)).Value = newObj.VoucherNo;
oralceComm.Parameters.Add(new OracleParameter("P_UPDATEDATE", OracleType.VarChar)).Value = newObj.UpdateDate;
oralceComm.Parameters.Add(new OracleParameter("P_REMARKS1", OracleType.VarChar)).Value = newObj.Remarks1;
oralceComm.Parameters.Add(new OracleParameter("P_REMARKS2", OracleType.VarChar)).Value = newObj.Remarks2;
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Size = 100;
PRtnMsg.Direction = ParameterDirection.Output;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Direction = ParameterDirection.Output;
PRTNMSGNO.Size = 50;
oralceComm.Parameters.Add(PRTNMSGNO);
oralceComm.ExecuteNonQuery();
resp.RtnMsg = PRtnMsg.Value.ToString();
resp.RtnMsgNo = PRTNMSGNO.Value.ToString();
}
catch (Exception e)
{
resp.RtnMsgNo = "99";
resp.RtnMsg = "异常情况：" + e.Message.ToString();
}
}
return(resp);
}
abstract protected VoucherBaseResp Execute(VoucherBaseReq baseReq);
//public WebRequestGateway gate = new WebRequestGateway(HttpContext.Current.Request.Headers.Get("version"));
//public VoucherBaseReq o_excute(IDictionary reqData)
//{
// VoucherCodeSyncResp resp = new VoucherCodeSyncResp();
// var sign = "";
// foreach (DictionaryEntry item in reqData)
// {
// if (item.Key.ToString().Equals("sign"))
// {
// if (item.Value != null)
// {
// sign = Convert.ToString(item.Value);
// }
// }
// }
//}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newObj = baseReq as VoucherCodeSyncReq; // 强制转换
VoucherCodeSyncResp resp = new VoucherCodeSyncResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_VOUCHERCODE_SYNCHRONIZE2", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
int qty = 0;
int.TryParse(newObj.VoucherQty, out qty);
oralceComm.Parameters.Clear();
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNAME", OracleType.VarChar)).Value = newObj.VoucherName;
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNO", OracleType.VarChar)).Value = newObj.VoucherNo;
oralceComm.Parameters.Add(new OracleParameter("P_QTY", OracleType.Int32)).Value = qty;
oralceComm.Parameters.Add(new OracleParameter("P_BARCODEUNIT", OracleType.VarChar)).Value = newObj.BarcodeUnit;
oralceComm.Parameters.Add(new OracleParameter("P_STARTDATE", OracleType.VarChar)).Value = newObj.StartDate;
oralceComm.Parameters.Add(new OracleParameter("P_EXPIREDDATE", OracleType.VarChar)).Value = newObj.ExpiredDate;
oralceComm.Parameters.Add(new OracleParameter("P_UPDATEDATE", OracleType.VarChar)).Value = newObj.UpdateDate;
oralceComm.Parameters.Add(new OracleParameter("P_REMARKS1", OracleType.VarChar)).Value = newObj.Remarks1;
oralceComm.Parameters.Add(new OracleParameter("P_REMARKS2", OracleType.VarChar)).Value = newObj.Remarks2;
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Size = 100;
PRtnMsg.Direction = ParameterDirection.Output;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRtnMsgNo = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRtnMsgNo.Direction = ParameterDirection.Output;
PRtnMsgNo.Size = 50;
oralceComm.Parameters.Add(PRtnMsgNo);
//// 返回礼券名称
//OracleParameter PRVoucherName = new OracleParameter("V_VOUCHERNAME",
// OracleType.VarChar, 200, ParameterDirection.Output, "", DataRowVersion.Default, false, "");
//oralceComm.Parameters.Add(PRVoucherName);
//// 返回礼券编码
//OracleParameter PRVoucherNo = new OracleParameter("V_VOUCHERNO", OracleType.VarChar);
//PRVoucherNo.Direction = ParameterDirection.Output;
//PRVoucherNo.Size = 200;
//oralceComm.Parameters.Add(PRVoucherNo);
//// 礼券条码返回
//OracleParameter PRVoucherBcd = new OracleParameter("V_VOUCHERBARCODE", OracleType.VarChar);
//PRVoucherBcd.Direction = ParameterDirection.Output;
//PRVoucherBcd.Size = 500;
//oralceComm.Parameters.Add(PRVoucherBcd);
// 返回礼券文档号
OracleParameter PRVoucherDocNo = new OracleParameter("V_DOC_NO", OracleType.VarChar);
PRVoucherDocNo.Direction = ParameterDirection.Output;
PRVoucherDocNo.Size = 50;
oralceComm.Parameters.Add(PRVoucherDocNo);
oralceComm.ExecuteNonQuery();
resp.RtnMsg = PRtnMsg.Value.ToString();
resp.RtnMsgNo = PRtnMsgNo.Value.ToString();
resp.VoucherDocNo = PRVoucherDocNo.Value.ToString();
}
catch (Exception e)
{
resp.RtnMsgNo = "99";
resp.RtnMsg = "异常情况：" + e.Message.ToString();
}
}
return(resp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newReq = baseReq as VoucherTransRefundReq;
var resp = new VoucherTransRefundResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
// OracleConnection dbConn = new OracleConnection(databasedws);
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_VOUCHERTRANSACTION_RETREAT2", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
//string[] vous = VoucherNo.Split(',');
//for (int i = 0; i < vous.Length; i++)
//{
// if (vous[i].Trim() != "")
// {
oralceComm.Parameters.Clear();
oralceComm.Parameters.Add(new OracleParameter("P_TRANSNO", OracleType.VarChar)).Value = newReq.TransNo;
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNO", OracleType.VarChar)).Value = newReq.VoucherNo;
oralceComm.Parameters.Add(new OracleParameter("P_STORENO", OracleType.VarChar)).Value = newReq.StoreNo;
oralceComm.Parameters.Add(new OracleParameter("P_TILLNO", OracleType.VarChar)).Value = newReq.TillNo;
oralceComm.Parameters.Add(new OracleParameter("P_SALEID", OracleType.Int32)).Value = newReq.SaleId;
oralceComm.Parameters.Add(new OracleParameter("P_SALEDATE", OracleType.VarChar)).Value = newReq.SaleDate;
oralceComm.Parameters.Add(new OracleParameter("P_REMARKS1", OracleType.VarChar)).Value = newReq.Remarks1;
oralceComm.Parameters.Add(new OracleParameter("P_REMARKS2", OracleType.VarChar)).Value = newReq.Remarks2;
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Size = 100;
PRtnMsg.Direction = ParameterDirection.Output;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Direction = ParameterDirection.Output;
PRTNMSGNO.Size = 50;
oralceComm.Parameters.Add(PRTNMSGNO);
oralceComm.ExecuteNonQuery();
resp.RtnMsg = PRtnMsg.Value.ToString();
resp.RtnMsgNo = PRTNMSGNO.Value.ToString();
// }
//}
}
catch (Exception e)
{
resp.RtnMsgNo = "99";
resp.RtnMsg = "异常情况：" + e.Message.ToString();
}
}
return(resp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newReq = baseReq as VoucherQueryNewReq;
var resp = new VoucherQueryNewResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_VOUCHERQUERY_NEW", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNO", OracleType.VarChar)).Value = newReq.VoucherNo;
OracleParameter PVoucherType = new OracleParameter("V_VOUCHERTYPE", OracleType.VarChar);
PVoucherType.Direction = ParameterDirection.Output;
PVoucherType.Size = 500;
oralceComm.Parameters.Add(PVoucherType);
OracleParameter PVoucherItemNo = new OracleParameter("V_VOUCHERITEMNO", OracleType.VarChar);
PVoucherItemNo.Direction = ParameterDirection.Output;
PVoucherItemNo.Size = 500;
oralceComm.Parameters.Add(PVoucherItemNo);
OracleParameter PVoucherNos = new OracleParameter("V_VOUCHERNO", OracleType.VarChar);
PVoucherNos.Direction = ParameterDirection.Output;
PVoucherNos.Size = 500;
oralceComm.Parameters.Add(PVoucherNos);
OracleParameter PVoucherStatus = new OracleParameter("V_VOUCHERSTATUS", OracleType.VarChar);
PVoucherStatus.Direction = ParameterDirection.Output;
PVoucherStatus.Size = 500;
oralceComm.Parameters.Add(PVoucherStatus);
OracleParameter PStoreNo = new OracleParameter("V_STORENO", OracleType.VarChar);
PStoreNo.Direction = ParameterDirection.Output;
PStoreNo.Size = 500;
oralceComm.Parameters.Add(PStoreNo);
OracleParameter PActivedTime = new OracleParameter("V_ACTIVEDTIME", OracleType.VarChar);
PActivedTime.Direction = ParameterDirection.Output;
PActivedTime.Size = 500;
oralceComm.Parameters.Add(PActivedTime);
OracleParameter PCertificatedTime = new OracleParameter("V_CERTIFICATEDTIME", OracleType.VarChar);
PCertificatedTime.Direction = ParameterDirection.Output;
PCertificatedTime.Size = 500;
oralceComm.Parameters.Add(PCertificatedTime);
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Direction = ParameterDirection.Output;
PRtnMsg.Size = 500;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Size = 100;
PRTNMSGNO.Direction = ParameterDirection.Output;
oralceComm.Parameters.Add(PRTNMSGNO);
oralceComm.ExecuteNonQuery();
resp.VoucherType = PVoucherType.Value.ToString();
resp.VoucherItemNo = PVoucherItemNo.Value.ToString();
resp.VoucherNos = PVoucherNos.Value.ToString();
resp.VoucherStatus = PVoucherStatus.Value.ToString();
resp.StoreNo = PStoreNo.Value.ToString();
resp.ActivedTime = PActivedTime.Value.ToString();
resp.CertificatedTime = PCertificatedTime.Value.ToString();
resp.RtnMsg = PRtnMsg.Value.ToString();
//RtnMsg = RtnMsg.Replace("~", "\r\n");
resp.RtnMsgNo = PRTNMSGNO.Value.ToString();
// dbConn.Close();
//result = RtnMsgNo;
//return RtnMsgNo;
}
catch (Exception e)
{
// dbConn.Close();
resp.RtnMsgNo = "0";
resp.RtnMsg = "异常情况：" + e.Message.ToString();
//result = RtnMsgNo;
}
finally
{
resp.RtnMsg = WebServiceLib.NewLineString(resp.RtnMsg);
}
}
return(resp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newReq = baseReq as VoucherQueryReq;
var resp = new VoucherQueryResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
// OracleConnection dbConn = new OracleConnection(databasedws);
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_VOUCHERQUERY", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNO", OracleType.VarChar)).Value = newReq.VoucherNo;
oralceComm.Parameters.Add(new OracleParameter("P_STORENO", OracleType.VarChar)).Value = newReq.StoreNo;
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Direction = ParameterDirection.Output;
PRtnMsg.Size = 500;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Size = 100;
PRTNMSGNO.Direction = ParameterDirection.Output;
oralceComm.Parameters.Add(PRTNMSGNO);
oralceComm.ExecuteNonQuery();
resp.RtnMsg = PRtnMsg.Value.ToString();
//RtnMsg = RtnMsg.Replace("~", "\r\n");
// RtnMsg = RtnMsg + "\r\n sdsaddsa";
resp.RtnMsgNo = PRTNMSGNO.Value.ToString();
// dbConn.Close();
//result = RtnMsgNo;
//return RtnMsgNo;
}
catch (Exception e)
{
// dbConn.Close();
resp.RtnMsg = "异常情况：" + e.Message.ToString();
//Sign = this.serviceCommon.CreateSign(string.Format("rtnMsg={0}&rtnMsgNo={1}", RtnMsg, RtnMsgNo));
resp.RtnMsgNo = "0";
//result = RtnMsgNo;
}
finally
{
resp.RtnMsg = WebServiceLib.NewLineString(resp.RtnMsg);
}
}
return(resp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newReq = baseReq as VoucherCheckReq;
var resp = new VoucherCheckNewResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_VOUCHERCHECK_NEW", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNO", OracleType.VarChar)).Value = newReq.VoucherNo;
oralceComm.Parameters.Add(new OracleParameter("P_STORENO", OracleType.VarChar)).Value = newReq.StoreNo;
OracleParameter PItemNo = new OracleParameter("V_VOUCHERITEMNO", OracleType.VarChar);
PItemNo.Direction = ParameterDirection.Output;
PItemNo.Size = 50;
oralceComm.Parameters.Add(PItemNo);
OracleParameter Pdisc = new OracleParameter("V_DISNO", OracleType.VarChar);
Pdisc.Direction = ParameterDirection.Output;
Pdisc.Size = 50;
oralceComm.Parameters.Add(Pdisc);
OracleParameter PnetAmt = new OracleParameter("V_NETAMT", OracleType.VarChar);
PnetAmt.Direction = ParameterDirection.Output;
PnetAmt.Size = 50;
oralceComm.Parameters.Add(PnetAmt);
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Direction = ParameterDirection.Output;
PRtnMsg.Size = 100;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Direction = ParameterDirection.Output;
PRTNMSGNO.Size = 50;
oralceComm.Parameters.Add(PRTNMSGNO);
oralceComm.ExecuteNonQuery();
resp.VoucherItemNo = PItemNo.Value.ToString();
resp.DisNo = Pdisc.Value.ToString();
resp.NetAmt = PnetAmt.Value.ToString();
resp.RtnMsg = PRtnMsg.Value.ToString();
resp.RtnMsgNo = PRTNMSGNO.Value.ToString();
// dbConn.Close();
//if (DisNo == "")
//{
// result = "";
//}
//else
//{
// result = "1";
//}
}
catch (Exception e)
{
resp.RtnMsgNo = "99";
resp.RtnMsg = "异常情况：" + e.Message.ToString();
}
}
return(resp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newReq = baseReq as VoucherCheckReq;
var resp = new VoucherCheckRetrunResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
// string databasedws = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionStr"].ToString();
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
dbConn.Open();
string step = "";
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_VOUCHERCHECK_RETURN", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
step = "123";
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNO", OracleType.VarChar)).Value = newReq.VoucherNo;
oralceComm.Parameters.Add(new OracleParameter("P_STORENO", OracleType.VarChar)).Value = newReq.StoreNo;
OracleParameter Pdisc = new OracleParameter("V_DISNO", OracleType.VarChar);
Pdisc.Direction = ParameterDirection.Output;
Pdisc.Size = 50;
oralceComm.Parameters.Add(Pdisc);
OracleParameter PNetAmt = new OracleParameter("V_AMT", OracleType.Int32);
PNetAmt.Direction = ParameterDirection.Output;
PNetAmt.Size = 50;
oralceComm.Parameters.Add(PNetAmt);
OracleParameter PItemNo = new OracleParameter("V_ITEM", OracleType.VarChar);
PItemNo.Direction = ParameterDirection.Output;
PItemNo.Size = 50;
oralceComm.Parameters.Add(PItemNo);
OracleParameter Ptender = new OracleParameter("V_TENDERNO", OracleType.VarChar);
Ptender.Direction = ParameterDirection.Output;
Ptender.Size = 50;
oralceComm.Parameters.Add(Ptender);
step = "457";
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Direction = ParameterDirection.Output;
PRtnMsg.Size = 100;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Direction = ParameterDirection.Output;
PRTNMSGNO.Size = 50;
oralceComm.Parameters.Add(PRTNMSGNO);
step = "666";
oralceComm.ExecuteNonQuery();
resp.DisNo = Pdisc.Value.ToString();
resp.NetAmt = PNetAmt.Value.ToString();
resp.TenderNo = Ptender.Value.ToString();
resp.ItemNo = PItemNo.Value.ToString();
resp.RtnMsg = PRtnMsg.Value.ToString();
resp.RtnMsgNo = PRTNMSGNO.Value.ToString();
step = "777";
}
catch (Exception e)
{
resp.RtnMsgNo = "99";
resp.RtnMsg = "异常情况：" + e.Message.ToString() + step;
}
}
return(resp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newObj = baseReq as VoucherStoreSyncReq; // 强制转换
VoucherStoreSyncResp resp = new VoucherStoreSyncResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_STOREINFO_SYNCHRONIZE", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
oralceComm.Parameters.Clear();
oralceComm.Parameters.Add(new OracleParameter("P_PROVINCE", OracleType.VarChar)).Value = newObj.Province;
oralceComm.Parameters.Add(new OracleParameter("P_CITY", OracleType.VarChar)).Value = newObj.City;
oralceComm.Parameters.Add(new OracleParameter("P_COMPANY", OracleType.VarChar)).Value = newObj.Company;
oralceComm.Parameters.Add(new OracleParameter("P_STORENO", OracleType.VarChar)).Value = newObj.StoreNo;
oralceComm.Parameters.Add(new OracleParameter("P_STORENAME", OracleType.VarChar)).Value = newObj.StoreName;
oralceComm.Parameters.Add(new OracleParameter("P_STOREADDR", OracleType.VarChar)).Value = newObj.StoreAddr;
oralceComm.Parameters.Add(new OracleParameter("P_STOREEMAIL", OracleType.VarChar)).Value = newObj.StoreEmail;
oralceComm.Parameters.Add(new OracleParameter("P_STORETEL", OracleType.VarChar)).Value = newObj.StoreTel;
oralceComm.Parameters.Add(new OracleParameter("P_STOREPOSNUM", OracleType.VarChar)).Value = newObj.StorePosNum;
oralceComm.Parameters.Add(new OracleParameter("P_OPERATETYPE", OracleType.VarChar)).Value = newObj.OperateType;
oralceComm.Parameters.Add(new OracleParameter("P_REMARKS1", OracleType.VarChar)).Value = newObj.Remarks1;
oralceComm.Parameters.Add(new OracleParameter("P_REMARKS2", OracleType.VarChar)).Value = newObj.Remarks2;
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Size = 100;
PRtnMsg.Direction = ParameterDirection.Output;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Direction = ParameterDirection.Output;
PRTNMSGNO.Size = 50;
oralceComm.Parameters.Add(PRTNMSGNO);
oralceComm.ExecuteNonQuery();
resp.RtnMsg = PRtnMsg.Value.ToString();
resp.RtnMsgNo = PRTNMSGNO.Value.ToString();
//dbConn.Close();
//result = "1";
}
catch (Exception e)
{
//dbConn.Close();
resp.RtnMsgNo = "99";
resp.RtnMsg = "异常情况：" + e.Message.ToString();
//result = "0";
}
}
return(resp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newReq = baseReq as VoucherTransactionNewReq;
var resp = new VoucherQueryResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
// OracleConnection dbConn = new OracleConnection(databasedws);
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER.SP_VOUCHERTRANSACTION_NEW", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
string[] vous = newReq.VoucherNo.Split(',');
string[] amt = newReq.NetAmt.Split(',');
string[] disc = newReq.Distcount.Split(',');
for (int i = 0; i < vous.Length; i++)
{
if (vous[i].Trim() != "")
{
oralceComm.Parameters.Clear();
oralceComm.Parameters.Add(new OracleParameter("P_ISSALE", OracleType.Int32)).Value = newReq.IsSale;
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHERNO", OracleType.VarChar)).Value = vous[i].Trim();
oralceComm.Parameters.Add(new OracleParameter("P_STORENO", OracleType.VarChar)).Value = newReq.StoreNo;
oralceComm.Parameters.Add(new OracleParameter("P_TILLNO", OracleType.VarChar)).Value = newReq.TillNo;
oralceComm.Parameters.Add(new OracleParameter("P_SALEID", OracleType.Int32)).Value = newReq.SaleId;
oralceComm.Parameters.Add(new OracleParameter("P_USERCODE", OracleType.VarChar)).Value = newReq.UserCode;
oralceComm.Parameters.Add(new OracleParameter("P_SALEDATE", OracleType.VarChar)).Value = newReq.SaleDate;
oralceComm.Parameters.Add(new OracleParameter("P_NEAMT", OracleType.Double)).Value = System.Convert.ToDecimal(amt[i].ToString());
oralceComm.Parameters.Add(new OracleParameter("P_DISTCOUNT", OracleType.VarChar)).Value = disc[i].Trim();;
oralceComm.Parameters.Add(new OracleParameter("P_TENDER", OracleType.VarChar)).Value = newReq.Tender;
oralceComm.Parameters.Add(new OracleParameter("P_TRANSNO", OracleType.VarChar)).Value = newReq.TtransNo;
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Size = 100;
PRtnMsg.Direction = ParameterDirection.Output;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Direction = ParameterDirection.Output;
PRTNMSGNO.Size = 50;
oralceComm.Parameters.Add(PRTNMSGNO);
oralceComm.ExecuteNonQuery();
resp.RtnMsg = PRtnMsg.Value.ToString();
resp.RtnMsgNo = PRTNMSGNO.Value.ToString();
}
}
//result = "1";
}
catch (Exception e)
{
resp.RtnMsgNo = "99";
resp.RtnMsg = "异常情况：" + e.Message.ToString();
//result = "0";
}
//finally
//{
// Sign = requestGateway.CreateSign(string.Format("rtnMsg={0}&rtnMsgNo={1}", RtnMsg, RtnMsgNo));
//}
}
return(resp);
}
protected override VoucherBaseResp Execute(VoucherBaseReq baseReq)
{
var newObj = baseReq as VoucherOOReq; // 强制转换
VoucherOOResp resp = new VoucherOOResp();
string databasedws = System.Configuration.ConfigurationManager.AppSettings["DbConn"];
using (OracleConnection dbConn = new OracleConnection(databasedws))
{
dbConn.Open();
OracleCommand oralceComm = new OracleCommand("PG_VOUCHER_OO.SP_VOUCHER_OO", dbConn); //调用存储过程的方法
oralceComm.CommandType = CommandType.StoredProcedure; //存储过程名称
try
{
oralceComm.Parameters.Add(new OracleParameter("P_TRANS_TP", OracleType.VarChar)).Value = newObj.trans_tp;
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHER_NO", OracleType.VarChar)).Value = newObj.voucher_no;
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHER_QTY", OracleType.VarChar)).Value = newObj.voucher_qty;
oralceComm.Parameters.Add(new OracleParameter("P_VOUCHER_BCD", OracleType.VarChar)).Value = newObj.voucher_bcd;
try
{
oralceComm.Parameters.Add(new OracleParameter("P_BIZDT_ORD", OracleType.DateTime)).Value = System.Convert.ToDateTime(newObj.bizdt_ord);
}
catch
{
oralceComm.Parameters.Add(new OracleParameter("P_BIZDT_ORD", OracleType.DateTime)).Value = System.DateTime.Now;
}
//oralceComm.Parameters.Add(new OracleParameter("P_BIZDT_ORD", OracleType.VarChar)).Value = bizdt_ord;
oralceComm.Parameters.Add(new OracleParameter("P_NET_NO_ORD", OracleType.VarChar)).Value = newObj.net_no_ord;
oralceComm.Parameters.Add(new OracleParameter("P_CUST_NAME", OracleType.VarChar)).Value = newObj.cust_name;
oralceComm.Parameters.Add(new OracleParameter("P_CUST_TEL", OracleType.VarChar)).Value = newObj.cust_tel;
oralceComm.Parameters.Add(new OracleParameter("P_CUST_RMK", OracleType.VarChar)).Value = newObj.cust_rmk;
oralceComm.Parameters.Add(new OracleParameter("P_RMK", OracleType.VarChar)).Value = newObj.rmk;
OracleParameter PRTNtranstp = new OracleParameter("V_TRANS_TP", OracleType.VarChar);
PRTNtranstp.Direction = ParameterDirection.Output;
PRTNtranstp.Size = 50;
oralceComm.Parameters.Add(PRTNtranstp);
OracleParameter PRtnMsg = new OracleParameter("V_RTNMSG", OracleType.VarChar);
PRtnMsg.Direction = ParameterDirection.Output;
PRtnMsg.Size = 100;
oralceComm.Parameters.Add(PRtnMsg);
OracleParameter PRTNMSGNO = new OracleParameter("V_RTNMSGNO", OracleType.VarChar);
PRTNMSGNO.Direction = ParameterDirection.Output;
PRTNMSGNO.Size = 50;
oralceComm.Parameters.Add(PRTNMSGNO);
OracleParameter PRtnVoucherBcd = new OracleParameter("V_VOUCHER_BCD", OracleType.VarChar);
PRtnVoucherBcd.Direction = ParameterDirection.Output;
PRtnVoucherBcd.Size = 250;
oralceComm.Parameters.Add(PRtnVoucherBcd);
OracleParameter PRtnVoucherItem = new OracleParameter("V_VOUCHER_ITEM", OracleType.VarChar);
PRtnVoucherItem.Direction = ParameterDirection.Output;
PRtnVoucherItem.Size = 800;
oralceComm.Parameters.Add(PRtnVoucherItem);
oralceComm.ExecuteNonQuery();
resp.RtnTransTp = PRTNtranstp.Value.ToString();
resp.RtnMsg = PRtnMsg.Value.ToString();
resp.RtnMsgNo = PRTNMSGNO.Value.ToString();
resp.RtnVoucherBcd = PRtnVoucherBcd.Value.ToString();
resp.RtnVoucherItem = PRtnVoucherItem.Value.ToString();
////成功 存储过程返回 00
//if (RtnMsgNo == "1")
//{
// // CheckStatus = "1";
// return "1";
//}
//else
//{
// // CheckStatus = "0";
// return "0";
//}
}
catch (Exception e)
{
resp.RtnTransTp = newObj.trans_tp;
resp.RtnMsgNo = "99";
// RtnMsg = StoreNo;
resp.RtnMsg = "异常情况：" + e.Message.ToString();
resp.RtnVoucherBcd = "";
resp.RtnVoucherItem = "";
}
}
return(resp);
}
