Example #1
0
 public static string AddInsuranceTyre(DInsuranceTyre dInsuranceTyre)
 {
     var sqlParamters = new[] 
     { 
         new SqlParameter("@PID",dInsuranceTyre.PID),
         new SqlParameter("@orderNo",dInsuranceTyre.orderNo),
         new SqlParameter("@orderDate",dInsuranceTyre.orderDate),
         new SqlParameter("@customerName",dInsuranceTyre.customerName??string.Empty),
         new SqlParameter("@customerPhoneNo",dInsuranceTyre.customerPhoneNo??string.Empty),
         new SqlParameter("@plateNumber",dInsuranceTyre.plateNumber??string.Empty),
         new SqlParameter("@storeAddress",dInsuranceTyre.storeAddress??string.Empty),
         new SqlParameter("@storeName",dInsuranceTyre.storeName??string.Empty),
         new SqlParameter("@tyreType",dInsuranceTyre.tyreType??string.Empty),
         new SqlParameter("@tyrePrice",dInsuranceTyre.tyrePrice??string.Empty),
         new SqlParameter("@idType",dInsuranceTyre.idType??string.Empty),
         new SqlParameter("@idNo",dInsuranceTyre.idNo??string.Empty),
         new SqlParameter("@type",dInsuranceTyre.type??string.Empty),
         new SqlParameter("@state",dInsuranceTyre.state),
         new SqlParameter("@tyreBatchNo",dInsuranceTyre.tyreBatchNo??string.Empty),
         new SqlParameter("@tyreId",dInsuranceTyre.tyreId),
         new SqlParameter("@OrderListPkid",dInsuranceTyre.OrderListPkid??string.Empty)
     };
     return DataOp.GetPara(@"insert into tbl_InsuranceTyre(PID,orderNo,orderDate,customerName,customerPhoneNo,plateNumber,storeAddress,storeName,tyreType,tyrePrice,idType,idNo,type,state,tyreBatchNo,tyreId,SentTime,OrderListPkid)
     values(@PID,@orderNo,@orderDate,@customerName,@customerPhoneNo,@plateNumber,@storeAddress,@storeName,@tyreType,@tyrePrice,@idType,@idNo,@type,@state,@tyreBatchNo,@tyreId,GETDATE(),@OrderListPkid);
   SELECT @@IDENTITY", sqlParamters);
 }
Example #2
0
        public static IDictionary <String, String> SendData(DInsuranceTyre dInsuranceTyre)
        {
            string rpsBizContent = string.Empty;
            Dictionary <String, String> newDict = new Dictionary <String, String>();

            //系统级别参数
            newDict.Add("appKey", appkey);
            newDict.Add("charset", "UTF-8");
            newDict.Add("serviceName", appservicename);

            newDict.Add("format", "json");
            newDict.Add("version", "1.0.0");
            newDict.Add("timestamp", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
            newDict.Add("signType", "RSA");
            //应用级别参数
            newDict.Add("orderNo", dInsuranceTyre.orderNo ?? string.Empty);
            newDict.Add("orderDate", dInsuranceTyre.orderDate ?? string.Empty);
            newDict.Add("customerName", dInsuranceTyre.customerName ?? string.Empty);
            newDict.Add("customerPhoneNo", dInsuranceTyre.customerPhoneNo ?? string.Empty);
            newDict.Add("plateNumber", dInsuranceTyre.plateNumber ?? string.Empty);
            newDict.Add("storeAddress", dInsuranceTyre.storeAddress ?? string.Empty);
            newDict.Add("storeName", dInsuranceTyre.storeName ?? string.Empty);
            newDict.Add("tyreType", dInsuranceTyre.tyreType ?? string.Empty);
            newDict.Add("tyrePrice", dInsuranceTyre.tyrePrice ?? string.Empty);
            newDict.Add("tyreBatchNo", dInsuranceTyre.tyreBatchNo ?? string.Empty);
            newDict.Add("tyreId", dInsuranceTyre.tyreId ?? string.Empty);
            newDict.Add("idType", dInsuranceTyre.idType ?? string.Empty);
            newDict.Add("idNo", dInsuranceTyre.idNo ?? string.Empty);
            newDict.Add("type", dInsuranceTyre.type ?? string.Empty);
            //公钥私钥
            string publicKeyPem  = AppDomain.CurrentDomain.BaseDirectory + "Keys\\public-key-zhongan.pem";
            string privateKeyPem = AppDomain.CurrentDomain.BaseDirectory + "Keys\\rsa_private_key.pem";

            //使用 util方法 加密 加签
            IDictionary <String, String> dic = SignatureUtils.encryptAndSign(newDict, publicKeyPem, privateKeyPem, "utf-8", true, true);
            //string dsdsd = SignatureUtils.CheckSignAndDecrypt(dic, publicKeyPem, privateKeyPem, true, true);
            WebUtils webUtil  = new WebUtils();
            string   response = webUtil.DoPost(appurl, dic, "utf-8");

            //使用 util方法 验签,解密
            IDictionary <String, String> resp = JsonConvert.DeserializeObject <Dictionary <String, String> >(response);//泛型反序列化

            if (resp.ContainsKey("bizContent"))
            {// 验签,解密
                rpsBizContent = SignatureUtils.CheckSignAndDecrypt(resp, publicKeyPem, privateKeyPem, true, true);
            }
            else
            {//如果为空则不用解密
                resp.Add("bizContent", "");
                rpsBizContent = SignatureUtils.CheckSignAndDecrypt(resp, publicKeyPem, privateKeyPem, true, false);
            }

            //更新bizContent
            resp.Remove("bizContent");
            resp.Add("bizContent", rpsBizContent);

            return(resp);


            //显示
            //System.Console.WriteLine("Response:{0}", JsonConvert.SerializeObject(resp));
            //System.Console.WriteLine("bizContent:{0}", resp["bizContent"]);
            //IDictionary<String, String> _BizContent = JsonConvert.DeserializeObject<Dictionary<String, String>>(resp["bizContent"]);
            //System.Console.WriteLine("endDate:{0}", _BizContent["endDate"]);
            //System.Console.Read();
        }