2022-07-29 03:48:47 [10] INFO lp.shop.core.MsgAPI 发送手机号码:18716873309,短信模板:1,内容:{"phone":"18716873309","code":"2667"} 2022-07-29 03:48:47 [10] INFO lp.shop.core.MsgAPI 18716873309短信执行返回:{"RequestId":"5A4DDFED-E51E-570C-BA40-7BF8EFD477C5","BizId":"712923559037727337^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"5A4DDFED-E51E-570C-BA40-7BF8EFD477C5","x-acs-trace-id":"53f0e4b214d21f79b455afae4f5f4aab","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Thu, 28 Jul 2022 19:48:47 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18716873309&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2218716873309%22%2c%22code%22:%222667%22%7D&OutId=202207290348471228&Timestamp=2022-07-28T19:48:47Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=1655eeb6-70ea-4012-a5c9-28e488acab17&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=V4nz8Q4N4NYHIchNAHegHocDZAA%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+NUE0RERGRUQtRTUxRS01NzBDLUJBNDAtN0JGOEVGRDQ3N0M1PC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjcxMjkyMzU1OTAzNzcyNzMzN14wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 10:06:17 [46] INFO lp.shop.core.MsgAPI 发送手机号码:13341364712,短信模板:1,内容:{"phone":"13341364712","code":"2513"} 2022-07-29 10:06:18 [46] INFO lp.shop.core.MsgAPI 13341364712短信执行返回:{"RequestId":"6CC113C7-F9A6-51FE-90FB-C4149B6856E6","BizId":"269721859060377948^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"6CC113C7-F9A6-51FE-90FB-C4149B6856E6","x-acs-trace-id":"07439dde01cdadaed7c2c5fd27c0defe","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 02:06:18 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13341364712&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2213341364712%22%2c%22code%22:%222513%22%7D&OutId=202207291006174397&Timestamp=2022-07-29T02:06:17Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=67e867f7-6fc2-4ae3-9d42-1c28b9d37c97&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=5GxDYy%2f%2fedOF9DPz7ONRJuswjrE%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+NkNDMTEzQzctRjlBNi01MUZFLTkwRkItQzQxNDlCNjg1NkU2PC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjI2OTcyMTg1OTA2MDM3Nzk0OF4wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 11:36:04 [80] INFO lp.shop.core.MsgAPI 发送手机号码:15034383535,短信模板:1,内容:{"phone":"15034383535","code":"4106"} 2022-07-29 11:36:05 [80] INFO lp.shop.core.MsgAPI 15034383535短信执行返回:{"RequestId":"0EF28844-62D3-5BAF-875E-EBC85FD6C920","BizId":"724001559065764965^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"0EF28844-62D3-5BAF-875E-EBC85FD6C920","x-acs-trace-id":"ffaf0e7be715f71ef0bc327badd15a34","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 03:36:05 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=15034383535&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2215034383535%22%2c%22code%22:%224106%22%7D&OutId=202207291136049595&Timestamp=2022-07-29T03:36:04Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=dd6d6df4-902e-4fe8-bcd5-7d166fac28c2&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=%2btm9oT%2fHb7qz8DVcFe%2b0ALVXc%2fo%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+MEVGMjg4NDQtNjJEMy01QkFGLTg3NUUtRUJDODVGRDZDOTIwPC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjcyNDAwMTU1OTA2NTc2NDk2NV4wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 11:55:45 [29] INFO lp.shop.core.MsgAPI 发送手机号码:18752565391,短信模板:1,内容:{"phone":"18752565391","code":"4452"} 2022-07-29 11:55:46 [29] INFO lp.shop.core.MsgAPI 18752565391短信执行返回:{"RequestId":"31AF4CB2-0E16-5DB8-B10F-DD7B3FDC5AE8","BizId":"709006159066945861^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"31AF4CB2-0E16-5DB8-B10F-DD7B3FDC5AE8","x-acs-trace-id":"be06c7a6d2e8fc62270d991739b57080","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 03:55:46 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18752565391&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2218752565391%22%2c%22code%22:%224452%22%7D&OutId=202207291155455493&Timestamp=2022-07-29T03:55:45Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=4acefaf1-8394-4dda-8454-7ad56c2e1497&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=oneSJsZKyVSZwpPjw6vGwS58YkU%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+MzFBRjRDQjItMEUxNi01REI4LUIxMEYtREQ3QjNGREM1QUU4PC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjcwOTAwNjE1OTA2Njk0NTg2MV4wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 13:19:29 [17] INFO lp.shop.core.MsgAPI 发送手机号码:15851851676,短信模板:1,内容:{"phone":"15851851676","code":"6062"} 2022-07-29 13:19:29 [17] INFO lp.shop.core.MsgAPI 15851851676短信执行返回:{"RequestId":"57E8408F-7018-5424-9175-96C5FAC66177","BizId":"139322259071969250^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"57E8408F-7018-5424-9175-96C5FAC66177","x-acs-trace-id":"608fbfd3870973f1ba8fd84b05e03c1a","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 05:19:29 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=15851851676&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2215851851676%22%2c%22code%22:%226062%22%7D&OutId=202207291319294676&Timestamp=2022-07-29T05:19:29Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=c47aac84-00e8-4133-9746-5142957fcd80&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=FoKrL9UszZ%2btF5r16TD%2fRgz4sjo%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+NTdFODQwOEYtNzAxOC01NDI0LTkxNzUtOTZDNUZBQzY2MTc3PC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjEzOTMyMjI1OTA3MTk2OTI1MF4wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 15:19:47 [24] INFO lp.shop.core.MsgAPI 发送手机号码:18602711363,短信模板:1,内容:{"phone":"18602711363","code":"6758"} 2022-07-29 15:19:48 [24] INFO lp.shop.core.MsgAPI 18602711363短信执行返回:{"RequestId":"2E716536-C827-573A-925E-70F724620E69","BizId":"889805259079188085^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"2E716536-C827-573A-925E-70F724620E69","x-acs-trace-id":"48a531acfcf8bed581c52b57c338fc86","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 07:19:48 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18602711363&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2218602711363%22%2c%22code%22:%226758%22%7D&OutId=202207291519472443&Timestamp=2022-07-29T07:19:47Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=51e94e24-e9c0-4c39-a129-b9c9dd295600&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=QJaILVtFNGfphpP%2fP%2b8LRbzKHGw%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+MkU3MTY1MzYtQzgyNy01NzNBLTkyNUUtNzBGNzI0NjIwRTY5PC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjg4OTgwNTI1OTA3OTE4ODA4NV4wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 15:46:10 [15] INFO lp.shop.core.MsgAPI 发送手机号码:18087650745,短信模板:1,内容:{"phone":"18087650745","code":"6803"} 2022-07-29 15:46:10 [15] INFO lp.shop.core.MsgAPI 18087650745短信执行返回:{"RequestId":"046E0C7D-0EDD-5AEF-8E03-CA885A3034B9","BizId":"649918659080770247^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"046E0C7D-0EDD-5AEF-8E03-CA885A3034B9","x-acs-trace-id":"683bb706557fe6f3121c6b9cdcddaba7","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 07:46:10 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18087650745&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2218087650745%22%2c%22code%22:%226803%22%7D&OutId=202207291546101212&Timestamp=2022-07-29T07:46:10Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=6c91ea67-3044-4033-b065-fda67c8d3508&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=LTuN%2fxGLIXg9Jw%2bQtltAAa1cthE%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+MDQ2RTBDN0QtMEVERC01QUVGLThFMDMtQ0E4ODVBMzAzNEI5PC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjY0OTkxODY1OTA4MDc3MDI0N14wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 15:54:30 [26] ERROR lp.shop.core.LogBase 【GetProductYSListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.ITEM_PF_F from t_bd_item_ys s LEFT JOIN system_dictionary sd ON s.ITEM_TYPE = ' at line 1 在 lp.shop.db.SQLHelper.ExecuteTable(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 275 在 lp.shop.db.SQLHelper.ExecuteTable(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 287 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 95 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_t_bd_item_ys_bll.get_t_bd_item_ys_list(String shopcode, String ITEM_NAME, String ITEM_MODEL, String ITEM_TYPE, String ISUPDATE, String yscode, String ysname, String is_enable, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_t_bd_item_ys_bll.cs:行号 89 在 lp.shop.api.Controllers.web.WebProductYSController.GetProductYSListPage(ProductYSListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebProductYSController.cs:行号 42 2022-07-29 15:54:44 [30] ERROR lp.shop.core.LogBase 【GetProductYSListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.ITEM_PF_F from t_bd_item_ys s LEFT JOIN system_dictionary sd ON s.ITEM_TYPE = ' at line 1 在 lp.shop.db.SQLHelper.ExecuteTable(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 275 在 lp.shop.db.SQLHelper.ExecuteTable(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 287 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 95 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_t_bd_item_ys_bll.get_t_bd_item_ys_list(String shopcode, String ITEM_NAME, String ITEM_MODEL, String ITEM_TYPE, String ISUPDATE, String yscode, String ysname, String is_enable, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_t_bd_item_ys_bll.cs:行号 89 在 lp.shop.api.Controllers.web.WebProductYSController.GetProductYSListPage(ProductYSListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebProductYSController.cs:行号 42 2022-07-29 19:10:54 [31] INFO lp.shop.core.MsgAPI 发送手机号码:15820662599,短信模板:1,内容:{"phone":"15820662599","code":"5270"} 2022-07-29 19:10:54 [31] INFO lp.shop.core.MsgAPI 15820662599短信执行返回:{"RequestId":"8DDC538E-9044-5584-81D6-FD95D474020D","BizId":"851103459093054693^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"8DDC538E-9044-5584-81D6-FD95D474020D","x-acs-trace-id":"e1766be3595f15480c76d9930973c172","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 11:10:54 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=15820662599&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2215820662599%22%2c%22code%22:%225270%22%7D&OutId=202207291910546026&Timestamp=2022-07-29T11:10:54Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=02125d6c-7ba7-428b-9978-c5b08defd647&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=PZsM1pIPH3RkQuwmUuU70GHz31g%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+OEREQzUzOEUtOTA0NC01NTg0LTgxRDYtRkQ5NUQ0NzQwMjBEPC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjg1MTEwMzQ1OTA5MzA1NDY5M14wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 20:08:49 [86] INFO lp.shop.core.MsgAPI 发送手机号码:18913933345,短信模板:1,内容:{"phone":"18913933345","code":"2425"} 2022-07-29 20:08:49 [86] INFO lp.shop.core.MsgAPI 18913933345短信执行返回:{"RequestId":"98B7C6B1-64CC-5AAE-A4CE-B5A13ADD8CFF","BizId":"312302559096529301^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"98B7C6B1-64CC-5AAE-A4CE-B5A13ADD8CFF","x-acs-trace-id":"e998ac5019163af302a79a21d45bb176","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 12:08:49 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18913933345&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2218913933345%22%2c%22code%22:%222425%22%7D&OutId=202207292008493179&Timestamp=2022-07-29T12:08:49Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=b417fdcb-4c1a-4d21-80a7-229a2cb58930&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=oIinaA6PnFqm%2b9gfW7M3XgeQG58%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+OThCN0M2QjEtNjRDQy01QUFFLUE0Q0UtQjVBMTNBREQ4Q0ZGPC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjMxMjMwMjU1OTA5NjUyOTMwMV4wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 20:59:53 [97] INFO lp.shop.core.MsgAPI 发送手机号码:17704826566,短信模板:1,内容:{"phone":"17704826566","code":"3824"} 2022-07-29 20:59:53 [97] INFO lp.shop.core.MsgAPI 17704826566短信执行返回:{"RequestId":"6C80B224-C4EF-5575-B6B2-4C79012122FD","BizId":"529116759099593487^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"6C80B224-C4EF-5575-B6B2-4C79012122FD","x-acs-trace-id":"1ecf220c0de9749d5df1f26f4ac66f97","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 12:59:53 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=17704826566&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2217704826566%22%2c%22code%22:%223824%22%7D&OutId=202207292059537822&Timestamp=2022-07-29T12:59:53Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=a9f2ef61-44dd-4f72-8021-4dc17bf34635&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=TeB5fcxyykciZSCvHzFl%2fCl2wfk%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+NkM4MEIyMjQtQzRFRi01NTc1LUI2QjItNEM3OTAxMjEyMkZEPC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjUyOTExNjc1OTA5OTU5MzQ4N14wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-07-29 22:54:02 [69] ERROR lp.shop.core.LogBase 【GetShopProductAuthorizeByCompanyidStoredid】======MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'f.ITEM_PF' in 'field list' 在 lp.shop.db.SQLHelper.ExecuteTable(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 275 在 lp.shop.db.SQLHelper.ExecuteTable(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 287 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 95 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shopproduct_bll.get_shop_product_authorize_list(String companyid, String storedid, String shopproductid, String shopproductName, String code, String catetype, String cateid, String brandid, String styleid, String model, String sku_specs, String iserp, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shopproduct_bll.cs:行号 540 在 lp.shop.api.Controllers.app.AppShopProductController.GetShopProductAuthorizeByCompanyidStoredid(ShopProductAuthorizePageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\app\AppShopProductController.cs:行号 81 2022-07-29 23:03:39 [8] INFO lp.shop.core.MsgAPI 发送手机号码:13426793236,短信模板:1,内容:{"phone":"13426793236","code":"1737"} 2022-07-29 23:03:40 [8] INFO lp.shop.core.MsgAPI 13426793236短信执行返回:{"RequestId":"72206C5A-7DEC-5892-BDAF-E7D1A2932B47","BizId":"142213759107020152^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"72206C5A-7DEC-5892-BDAF-E7D1A2932B47","x-acs-trace-id":"d9b1354b9f0bae4fbe38f4bf269187f4","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Fri, 29 Jul 2022 15:03:40 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13426793236&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2213426793236%22%2c%22code%22:%221737%22%7D&OutId=202207292303404352&Timestamp=2022-07-29T15:03:40Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=6f43ff60-4ac8-431a-bd71-cca4bfa0b148&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=KWGkTW473kenfv2IMc2t%2fAI2m4Q%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPk9LPC9NZXNzYWdlPjxSZXF1ZXN0SWQ+NzIyMDZDNUEtN0RFQy01ODkyLUJEQUYtRTdEMUEyOTMyQjQ3PC9SZXF1ZXN0SWQ+PENvZGU+T0s8L0NvZGU+PEJpeklkPjE0MjIxMzc1OTEwNzAyMDE1Ml4wPC9CaXpJZD48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}