Esempio n. 1
0
        /// <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();
        }
Esempio n. 2
0
        /// <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));
        }
Esempio n. 3
0
        /// <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);
                    }
                }
            }
        }
Esempio n. 4
0
        ///// <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);
            }
        }