/// <summary>
/// 打印寄存 续存记录
/// </summary>
/// <param name="settleId"></param>
public static void PrtRegisterPayRecord(string settleId, int whandle)
{
string sql = @"select max(rc200) rc200,
min(rc020) rc020,
max(rc022) rc022,
sum(nums) nums,
sum(rc030) rc030,
min(rc100) rc100,
rc001,
rc010
from rc04 where rc010 = :rc010 group by rc001,rc010";
OracleCommand oc_command = new OracleCommand(sql, SqlAssist.conn);
OracleParameter op_rc010 = new OracleParameter("rc010", OracleDbType.Varchar2, 10);
op_rc010.Direction = ParameterDirection.Input;
op_rc010.Value = settleId;
oc_command.Parameters.Add(op_rc010);
OracleDataReader reader = oc_command.ExecuteReader();
StringBuilder sb_1 = new StringBuilder(100);
if (reader.HasRows && reader.Read())
{
string s_jbrq = string.Format("{0:yyyy-MM-dd}", reader["RC200"]);
string s_begin = string.Format("{0:yyyy-MM-dd}", reader["RC020"]);
string s_end = string.Format("{0:yyyy-MM-dd}", reader["RC022"]);
string s_rc001 = reader["RC001"].ToString();
sb_1.Append(s_jbrq + "\t"); // 经办日期
sb_1.Append(s_begin + "\t"); // 寄存开始日期
sb_1.Append(s_end + "\t"); // 寄存终止日期
sb_1.Append(RegisterAction.isIncludeLamp(settleId)? "送灯\t" : reader["NUMS"].ToString() + "\t"); // 缴费年限
sb_1.Append(reader["RC030"].ToString() + "\t"); // 缴费金额
sb_1.Append(MiscAction.Mapper_operator(reader["RC100"].ToString()) + "\t"); //经办人
short i_order = Convert.ToSByte(SqlAssist.ExecuteScalar("select count(*) from v_rc04 where rc001 ='" + s_rc001 + "' and rc010 < '" + settleId + "'"));
try
{
int commandNum = GenNewCommandNum();
SendPrtCommand(Envior.prtConnId,
whandle,
commandNum,
"Register_Payrecord",
sb_1.ToString(),
(i_order + 1).ToString()
);
}
catch (Exception ee)
{
XtraMessageBox.Show(ee.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("未找到数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 发送业务请求
/// </summary>
/// <param name="b_json"></param>
/// <returns></returns>
public static string SendRequest(string method, string b_json)
{
StringBuilder s_big = new StringBuilder(200);
StringBuilder sb_url = new StringBuilder(100);
string s_datetime = string.Format("{0:yyyyMMddHHmmssfff}", MiscAction.GetServerTime());
string s_msg_64 = Tools.EncodeBase64("utf-8", b_json);
string s_msg_id = Tools.GetEntityPK("FINREQ");
s_big.Append(Envior.FIN_AGENCY_CODE);
s_big.Append(Envior.FIN_APPID);
s_big.Append(s_datetime);
s_big.Append("0"); //是否加密
s_big.Append("json");
s_big.Append(s_msg_64); //message
s_big.Append(s_msg_id); //message_id
s_big.Append(method); //method
s_big.Append(Envior.FIN_REGION_CODE); //region_code
s_big.Append(Envior.FIN_VERSION); //version
string s_md5 = Tools.EncryptWithMD5(Envior.FIN_APPKEY + s_big.ToString() + Envior.FIN_APPKEY).ToUpper();
sb_url.Append("agency_code=" + Envior.FIN_AGENCY_CODE + "&");
sb_url.Append("app_id=" + Envior.FIN_APPID + "&");
sb_url.Append("datetime=" + s_datetime + "&");
sb_url.Append("encryption=" + "0" + "&");
sb_url.Append("format=" + "json" + "&");
sb_url.Append("message=" + s_msg_64 + "&");
sb_url.Append("message_id=" + s_msg_id + "&");
sb_url.Append("method=" + method + "&");
sb_url.Append("region_code=" + Envior.FIN_REGION_CODE + "&");
sb_url.Append("security=" + s_md5 + "&");
sb_url.Append("version=" + Envior.FIN_VERSION);
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(Envior.FIN_URL);
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded";
byte[] buf = System.Text.Encoding.GetEncoding("UTF-8").GetBytes(sb_url.ToString());
request.ContentLength = buf.Length;
Stream myRequestStream = request.GetRequestStream();
myRequestStream.Write(buf, 0, buf.Length);
myRequestStream.Close();
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream myResponseStream = response.GetResponseStream();
StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.GetEncoding("utf-8"));
string retString = myStreamReader.ReadToEnd();
myStreamReader.Close();
myResponseStream.Close();
return(Tools.DecodeBase64("utf-8", retString));
}
/// <summary>
/// 打印财政发票
/// </summary>
/// <param name="batch_code"></param>
/// <param name="bill_no"></param>
public static void PrintInvoice(string batch_code, string bill_no)
{
//组装业务数据
Dictionary <string, object> bdata = new Dictionary <string, object>();
Dictionary <string, Dictionary <string, object> > msg = new Dictionary <string, Dictionary <string, object> >();
bdata.Add("bill_batch_code", batch_code); //发票注册号
bdata.Add("bill_no", bill_no); //发票号
msg.Add("message", bdata);
StringBuilder sb_paras = new StringBuilder(100);
StringBuilder sb_big = new StringBuilder(100);
string s_datetime = string.Format("{0:yyyyMMddHHmmssfff}", MiscAction.GetServerTime());
string s_bjson = Tools.ConvertObjectToJson(msg);
string s_msg_64 = Tools.EncodeBase64("utf-8", s_bjson);
string s_msg_id = Tools.GetEntityPK("FINREQ");
////// 计算 MD5
sb_big.Append(Envior.FIN_AGENCY_CODE);
sb_big.Append(Envior.FIN_APPID);
sb_big.Append(s_datetime);
sb_big.Append("0"); //是否加密
sb_big.Append("json");
sb_big.Append(s_msg_64); //message
sb_big.Append(s_msg_id); //message_id
sb_big.Append("invoice.print.call"); //method
sb_big.Append(Envior.FIN_REGION_CODE); //region_code
sb_big.Append(Envior.FIN_VERSION); //version
string s_md5 = Tools.EncryptWithMD5(Envior.FIN_APPKEY + sb_big.ToString() + Envior.FIN_APPKEY).ToUpper();
StringBuilder sb_pdata = new StringBuilder(100);
sb_pdata.Append("{\"ParamsStr\":\"" + "app_id=" + Envior.FIN_APPID + "&");
sb_pdata.Append("security=" + s_md5 + "&");
sb_pdata.Append("agency_code=" + Envior.FIN_AGENCY_CODE + "&");
sb_pdata.Append("datetime=" + s_datetime + "&");
sb_pdata.Append("encryption=0&");
sb_pdata.Append("format=json&");
sb_pdata.Append("method=invoice.print.call&");
sb_pdata.Append("message=" + s_msg_64 + "&");
sb_pdata.Append("message_id=" + s_msg_id + "&");
sb_pdata.Append("region_code=" + Envior.FIN_REGION_CODE + "&");
sb_pdata.Append("version=" + Envior.FIN_VERSION + "\"}");
string s_url = @"http://127.0.0.1:13526/NontaxAgencyActuator?dllName=NontaxIndustry&Method=CallRemote&Params=" +
Tools.EncodeBase64("utf-8", sb_pdata.ToString()) + "&" +
"Random=" + new Random().Next().ToString() + "&" +
"ServiceUnit=ServiceUnit";
//string s_url2 = @"http://127.0.0.1:13526/NontaxAgencyActuator?dllName=NontaxIndustry&Method=CallRemote&Params=eyJQYXJhbXNTdHIiOiJhcHBfaWQ9TURKU0RZQllHNzgzODM4NyZzZWN1cml0eT01QzZBREE3NjEzRkNGQUE3ODhEMkVGN0QxNUY4RTVDRiZhZ2VuY3lfY29kZT0wMjEwOTkwMDEmZGF0ZXRpbWU9MjAyMDExMDgyMDEwMTUxMjMmZW5jcnlwdGlvbj0wJmZvcm1hdD1qc29uJm1ldGhvZD1pbnZvaWNlLnByaW50LmNhbGwmbWVzc2FnZT1ld29nSUNKdFpYTnpZV2RsSWlBNklIc0tJQ0FnSUNKaWFXeHNYMkpoZEdOb1gyTnZaR1VpSURvZ0lqTTVNVEFpTEFvZ0lDQWdJbUpwYkd4ZmJtOGlJRG9nSWpBd016VTJNREEwSWdvZ0lIMEtmUT09Jm1lc3NhZ2VfaWQ9MC42MDA4NjExNTk2ODI3MzY1JnJlZ2lvbl9jb2RlPTIzMTAwMSZ2ZXJzaW9uPTEuMC4xIn0=&Random=0.659813784025407&ServiceUnit=ServiceUnit";
LogUtils.Info(s_url);
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(s_url);
request.Method = "GET";
//request.ContentType = "application/json";
request.ContentType = "text/html";
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream myResponseStream = response.GetResponseStream();
StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.GetEncoding("utf-8"));
string retString = myStreamReader.ReadToEnd();
myStreamReader.Close();
myResponseStream.Close();
int i_pos1 = retString.IndexOf("\"ret\":\"");
int i_pos2 = 0;
if (i_pos1 >= 0)
{
i_pos2 = retString.IndexOf("\"", i_pos1 + 7);
if (i_pos2 > i_pos1)
{
string s_base64 = retString.Substring(i_pos1 + 7, i_pos2 - (i_pos1 + 7));
string s_1 = Tools.DecodeBase64("utf-8", s_base64);
if (s_1.IndexOf("0000") >= 0)
{
XtraMessageBox.Show("打印成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
///// <summary>
///// 根据结算流水号开具发票
///// </summary>
///// <param name="fa001"></param>
///// <returns></returns>
public static int Invoice(string fa001)
{
OracleParameter op_fa001 = new OracleParameter("fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
OracleDataReader reader_fa01 = SqlAssist.ExecuteReader("select fa003,fa180 from fa01 where fa001 = :fa001", new OracleParameter[] { op_fa001 });
string s_head = string.Empty;
string s_memo = string.Empty; //备注
decimal dec_hjje = decimal.Zero;
decimal dec_price = decimal.Zero;
while (reader_fa01.Read())
{
//读取交款人
s_head = reader_fa01["FA003"].ToString();
s_memo = reader_fa01["FA180"].ToString();
}
reader_fa01.Dispose();
Dictionary <string, object> bdata = new Dictionary <string, object>();
Dictionary <string, Dictionary <string, object> > msg = new Dictionary <string, Dictionary <string, object> >();
bdata.Add("serial_number", fa001); //业务流水号
bdata.Add("place_code", Envior.FIN_BILL_SITE); //开票点
bdata.Add("payer", s_head); //缴款人单位
bdata.Add("date", string.Format("{0:yyyy-MM-dd}", MiscAction.GetServerTime())); //开票日期
bdata.Add("author", Envior.cur_userName); //开票人
bdata.Add("payer_type", "1"); //缴款人类型：1 个人 2 单位
bdata.Add("credit_code", ""); //组织机构代码
bdata.Add("bill_code", Envior.FIN_CODE); //票据种类编码
bdata.Add("rec_mode", "1"); //收款方式:1现金,2转账,3其它
bdata.Add("memo", s_memo); //备注
string s_sql = @"select sa002,
sa004,
sa003,
price,
nums,
sa020,
sa007,
pkg_business.fun_GetInvoiceCode(sa002,sa004) invcode
from v_sa01
where sa010 = :fa001 order by sa001" ;
OracleDataReader reader_sa01 = SqlAssist.ExecuteReader(s_sql, new OracleParameter[] { op_fa001 });
List <Dictionary <string, object> > detail_list = new List <Dictionary <string, object> >();
Dictionary <string, object> detail_data = null;
while (reader_sa01.Read())
{
if (reader_sa01["SA020"].ToString() != "F")
{
continue; //如果不是财政发票,忽略
}
detail_data = new Dictionary <string, object>();
detail_data.Add("item_code", reader_sa01["INVCODE"].ToString()); //项目名
detail_data.Add("number", reader_sa01["NUMS"]); //数量
if (reader_sa01["SA002"].ToString() == "08")
{
dec_price = Convert.ToDecimal(reader_sa01["SA007"]) / Convert.ToDecimal(reader_sa01["NUMS"]);
detail_data.Add("std", dec_price); //单价
}
else
{
detail_data.Add("std", reader_sa01["PRICE"]); //单价
}
detail_data.Add("amt", reader_sa01["SA007"]); //金额
detail_list.Add(detail_data);
dec_hjje += Convert.ToDecimal(reader_sa01["SA007"]);
}
reader_sa01.Dispose();
bdata.Add("item_details", detail_list);
bdata.Add("total_amt", dec_hjje); //合计金额
msg.Add("message", bdata);
string s_json = Tools.ConvertObjectToJson(msg);
string s_ret = SendRequest("invoice.issue.do", s_json);
Dictionary <string, object> retdata = JsonConvert.DeserializeObject <Dictionary <string, object> >(s_ret);
if (retdata != null)
{
if (retdata.ContainsKey("message"))
{
string s_batch_code = string.Empty;
string s_bill_no = string.Empty;
Dictionary <string, string> success_msg = JsonConvert.DeserializeObject <Dictionary <string, string> >(retdata["message"].ToString());
s_batch_code = success_msg["bill_batch_code"];
s_bill_no = success_msg["bill_no"];
if (FinInvoiceLog(fa001, Envior.FIN_CODE, s_bill_no, s_batch_code, dec_hjje, Envior.cur_userId) > 0)
{
XtraMessageBox.Show("发票开具成功!\r\n" + "注册号:" + s_batch_code + "\r\n" + "票据号:" + s_bill_no, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("发票开具成功!!!但记录日志失败，请与管理员联系！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
XtraMessageBox.Show("票据号:" + s_bill_no + "\r\n注册号:" + s_batch_code + "\r\n");
}
if (XtraMessageBox.Show("现在打印【财政发票】吗?" + "\r\n" + "发票号:" + s_bill_no, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
PrintInvoice(s_batch_code, s_bill_no);
}
return(1);
}
else
{
Dictionary <string, string> error_msg = JsonConvert.DeserializeObject <Dictionary <string, string> >(retdata["error_message"].ToString());
XtraMessageBox.Show("开财政发票失败!" + error_msg["error_msg"] + "\r\n" + "错误代码:" + error_msg["error_code"], "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(-1);
}
}
else
{
XtraMessageBox.Show("未获取到数据!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(-1);
}
}
