**************************mima_b2b_Login()2022/6/14 5:07:01************************* paramter0:1042 paramter1:oDppT5F3maDh-kvz95wWk33tfqPo Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 05:07:01 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1042' or a.login_no = '1042' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1042","vip_pass":"770625","is_bind":"1","open_id":"oDppT5F3maDh-kvz95wWk33tfqPo"} ************************************************************************************** **************************mima_b2b_Login()2022/6/14 5:07:12************************* paramter0:1042 paramter1:oDppT5F3maDh-kvz95wWk33tfqPo Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 05:07:12 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1042' or a.login_no = '1042' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1042","vip_pass":"770625","is_bind":"1","open_id":"oDppT5F3maDh-kvz95wWk33tfqPo"} ************************************************************************************** **************************mima_b2b_Login()2022/6/14 5:08:20************************* paramter0:1043 paramter1:oDppT5F3maDh-kvz95wWk33tfqPo Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 05:08:20 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1043' or a.login_no = '1043' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1043","vip_pass":"123456","is_bind":"1","open_id":"oDppT5F3maDh-kvz95wWk33tfqPo"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 10:47:28 [错误信息] => 事务(进程 ID 62)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1037';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1037';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000000031' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000000032' and open_id='1037';update tr_shopcart set price='14.30000000',unit_no='斤',amount=14.30000000 * qty where goods_id='0000000000832' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000000871' and open_id='1037';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1037';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1037';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001048' and open_id='1037';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1037';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000001123' and open_id='1037';update tr_shopcart set price='6.67000000',unit_no='包',amount=6.67000000 * qty where goods_id='0000000001146' and open_id='1037';update tr_shopcart set price='12.22000000',unit_no='包',amount=12.22000000 * qty where goods_id='0000000001151' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1037';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001278' and open_id='1037';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000001290' and open_id='1037';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1037';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001746' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001749' and open_id='1037';update tr_shopcart set price='10.00000000',unit_no='包',amount=10.00000000 * qty where goods_id='0000000004604' and open_id='1037';update tr_shopcart set price='3.96000000',unit_no='包',amount=3.96000000 * qty where goods_id='0000000004665' and open_id='1037';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1037';update tr_shopcart set price='5.20000000',unit_no='包',amount=5.20000000 * qty where goods_id='0000000004670' and open_id='1037';update tr_shopcart set price='1.98000000',unit_no='包',amount=1.98000000 * qty where goods_id='0000000004683' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='个',amount=4.00000000 * qty where goods_id='0000000004709' and open_id='1037';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000004718' and open_id='1037';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000004720' and open_id='1037';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000004729' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1037';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000004768' and open_id='1037';update tr_shopcart set price='5.60000000',unit_no='斤',amount=5.60000000 * qty where goods_id='0000000004772' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='200g/盒',amount=4.50000000 * qty where goods_id='0000000004775' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004776' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004779' and open_id='1037';update tr_shopcart set price='11.92000000',unit_no='包',amount=11.92000000 * qty where goods_id='0000000004825' and open_id='1037';update tr_shopcart set price='14.21000000',unit_no='包',amount=14.21000000 * qty where goods_id='0000000004828' and open_id='1037';update tr_shopcart set price='9.63000000',unit_no='包',amount=9.63000000 * qty where goods_id='0000000004831' and open_id='1037';update tr_shopcart set price='12.36000000',unit_no='包',amount=12.36000000 * qty where goods_id='0000000004886' and open_id='1037';update tr_shopcart set price='13.33000000',unit_no='包',amount=13.33000000 * qty where goods_id='0000000004911' and open_id='1037';update tr_shopcart set price='6.60000000',unit_no='包',amount=6.60000000 * qty where goods_id='0000000004943' and open_id='1037';update tr_shopcart set price='14.44000000',unit_no='包',amount=14.44000000 * qty where goods_id='0000000005080' and open_id='1037';update tr_shopcart set price='8.00000000',unit_no='个',amount=8.00000000 * qty where goods_id='0000000005360' and open_id='1037';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1037';update tr_shopcart set price='22.50000000',unit_no='板',amount=22.50000000 * qty where goods_id='0000000005430' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005462' and open_id='1037';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005472' and open_id='1037';update tr_shopcart set price='9.80000000',unit_no='斤',amount=9.80000000 * qty where goods_id='0000000005473' and open_id='1037';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005478' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1037';update tr_shopcart set price='2.87000000',unit_no='斤',amount=2.87000000 * qty where goods_id='0000000005486' and open_id='1037';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1037';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005491' and open_id='1037';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005686' and open_id='1037';update tr_shopcart set price='8.00000000',unit_no='包',amount=8.00000000 * qty where goods_id='0000000005702' and open_id='1037';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1037';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000005709' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005712' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000005715' and open_id='1037';update tr_shopcart set price='8.80000000',unit_no='包',amount=8.80000000 * qty where goods_id='0000000005716' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005717' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1037';update tr_shopcart set price='5.50000000',unit_no='盒',amount=5.50000000 * qty where goods_id='0000000005721' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000005722' and open_id='1037';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='盒',amount=2.00000000 * qty where goods_id='0000000005730' and open_id='1037';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005731' and open_id='1037';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005732' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005733' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005735' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005738' and open_id='1037';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005741' and open_id='1037';update tr_shopcart set price='2.56000000',unit_no='斤',amount=2.56000000 * qty where goods_id='0000000005743' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005745' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005746' and open_id='1037';update tr_shopcart set price='3.20000000',unit_no='斤',amount=3.20000000 * qty where goods_id='0000000005747' and open_id='1037';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000005748' and open_id='1037';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005749' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005752' and open_id='1037';update tr_shopcart set price='1.00000000',unit_no='斤',amount=1.00000000 * qty where goods_id='0000000005753' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005754' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005755' and open_id='1037';update tr_shopcart set price='14.20000000',unit_no='斤',amount=14.20000000 * qty where goods_id='0000000005756' and open_id='1037';update tr_shopcart set price='3.20000000',unit_no='斤',amount=3.20000000 * qty where goods_id='0000000005758' and open_id='1037';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000005759' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005762' and open_id='1037';update tr_shopcart set price='6.80000000',unit_no='斤',amount=6.80000000 * qty where goods_id='0000000005763' and open_id='1037';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005764' and open_id='1037';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005765' and open_id='1037';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005766' and open_id='1037';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005767' and open_id='1037';update tr_shopcart set price='7.30000000',unit_no='斤',amount=7.30000000 * qty where goods_id='0000000005768' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005769' and open_id='1037';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005771' and open_id='1037';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000005772' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005774' and open_id='1037';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000005775' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='包',amount=3.00000000 * qty where goods_id='0000000005776' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005777' and open_id='1037';update tr_shopcart set price='6.60000000',unit_no='斤',amount=6.60000000 * qty where goods_id='0000000005785' and open_id='1037';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005793' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005799' and open_id='1037';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005800' and open_id='1037';update tr_shopcart set price='5.75000000',unit_no='斤',amount=5.75000000 * qty where goods_id='0000000005807' and open_id='1037';update tr_shopcart set price='5.80000000',unit_no='斤',amount=5.80000000 * qty where goods_id='0000000005808' and open_id='1037';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000005809' and open_id='1037';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005810' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005812' and open_id='1037';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005818' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005819' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005821' and open_id='1037';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005822' and open_id='1037';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005823' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005826' and open_id='1037';update tr_shopcart set price='1.00000000',unit_no='斤',amount=1.00000000 * qty where goods_id='0000000005827' and open_id='1037';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005830' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005838' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005839' and open_id='1037';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000005840' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005843' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005844' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005845' and open_id='1037';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1037';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005852' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1037';update tr_shopcart set price='3.20000000',unit_no='斤',amount=3.20000000 * qty where goods_id='0000000005862' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005863' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005864' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005867' and open_id='1037';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000005868' and open_id='1037';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005870' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005871' and open_id='1037'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** **************************mima_b2b_Login()2022/6/14 11:34:21************************* paramter0: paramter1:oDppT5MY5UIXsTFMHCCNAX6MsFBg Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 11:34:21 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '' or a.login_no = '' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"","vip_pass":"","is_bind":"1","open_id":"oDppT5MY5UIXsTFMHCCNAX6MsFBg"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 12:23:49 [错误信息] => 事务(进程 ID 69)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000000001' and open_id='1037';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1037';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1037';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000000031' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000000032' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000000871' and open_id='1037';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1037';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1037';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001048' and open_id='1037';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1037';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000001123' and open_id='1037';update tr_shopcart set price='6.67000000',unit_no='包',amount=6.67000000 * qty where goods_id='0000000001146' and open_id='1037';update tr_shopcart set price='12.22000000',unit_no='包',amount=12.22000000 * qty where goods_id='0000000001151' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1037';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000001290' and open_id='1037';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1037';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001746' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001749' and open_id='1037';update tr_shopcart set price='10.00000000',unit_no='包',amount=10.00000000 * qty where goods_id='0000000004604' and open_id='1037';update tr_shopcart set price='3.96000000',unit_no='包',amount=3.96000000 * qty where goods_id='0000000004665' and open_id='1037';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1037';update tr_shopcart set price='5.20000000',unit_no='包',amount=5.20000000 * qty where goods_id='0000000004670' and open_id='1037';update tr_shopcart set price='1.98000000',unit_no='包',amount=1.98000000 * qty where goods_id='0000000004683' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='个',amount=4.00000000 * qty where goods_id='0000000004709' and open_id='1037';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000004718' and open_id='1037';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000004720' and open_id='1037';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000004729' and open_id='1037';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000004755' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1037';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000004758' and open_id='1037';update tr_shopcart set price='3.99000000',unit_no='斤',amount=3.99000000 * qty where goods_id='0000000004768' and open_id='1037';update tr_shopcart set price='5.60000000',unit_no='斤',amount=5.60000000 * qty where goods_id='0000000004772' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='200g/盒',amount=4.50000000 * qty where goods_id='0000000004775' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004776' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004779' and open_id='1037';update tr_shopcart set price='11.92000000',unit_no='包',amount=11.92000000 * qty where goods_id='0000000004825' and open_id='1037';update tr_shopcart set price='14.21000000',unit_no='包',amount=14.21000000 * qty where goods_id='0000000004828' and open_id='1037';update tr_shopcart set price='9.63000000',unit_no='包',amount=9.63000000 * qty where goods_id='0000000004831' and open_id='1037';update tr_shopcart set price='12.36000000',unit_no='包',amount=12.36000000 * qty where goods_id='0000000004886' and open_id='1037';update tr_shopcart set price='13.33000000',unit_no='包',amount=13.33000000 * qty where goods_id='0000000004911' and open_id='1037';update tr_shopcart set price='16.30000000',unit_no='斤',amount=16.30000000 * qty where goods_id='0000000004923' and open_id='1037';update tr_shopcart set price='6.60000000',unit_no='包',amount=6.60000000 * qty where goods_id='0000000004943' and open_id='1037';update tr_shopcart set price='14.44000000',unit_no='包',amount=14.44000000 * qty where goods_id='0000000005080' and open_id='1037';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1037';update tr_shopcart set price='8.00000000',unit_no='个',amount=8.00000000 * qty where goods_id='0000000005360' and open_id='1037';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1037';update tr_shopcart set price='22.50000000',unit_no='板',amount=22.50000000 * qty where goods_id='0000000005430' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005462' and open_id='1037';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005472' and open_id='1037';update tr_shopcart set price='9.80000000',unit_no='斤',amount=9.80000000 * qty where goods_id='0000000005473' and open_id='1037';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005478' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1037';update tr_shopcart set price='2.87000000',unit_no='斤',amount=2.87000000 * qty where goods_id='0000000005486' and open_id='1037';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1037';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005491' and open_id='1037';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005686' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005701' and open_id='1037';update tr_shopcart set price='8.00000000',unit_no='包',amount=8.00000000 * qty where goods_id='0000000005702' and open_id='1037';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005709' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005712' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000005715' and open_id='1037';update tr_shopcart set price='8.80000000',unit_no='包',amount=8.80000000 * qty where goods_id='0000000005716' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005717' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1037';update tr_shopcart set price='5.50000000',unit_no='盒',amount=5.50000000 * qty where goods_id='0000000005721' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000005722' and open_id='1037';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='盒',amount=2.00000000 * qty where goods_id='0000000005730' and open_id='1037';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005731' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005732' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005733' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005735' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005737' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005738' and open_id='1037';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005741' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005743' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005745' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005746' and open_id='1037';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000005747' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005748' and open_id='1037';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005749' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005750' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005752' and open_id='1037';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005753' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005754' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005755' and open_id='1037';update tr_shopcart set price='14.20000000',unit_no='斤',amount=14.20000000 * qty where goods_id='0000000005756' and open_id='1037';update tr_shopcart set price='3.20000000',unit_no='斤',amount=3.20000000 * qty where goods_id='0000000005758' and open_id='1037';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005759' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005762' and open_id='1037';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005763' and open_id='1037';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005764' and open_id='1037';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005765' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005766' and open_id='1037';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005767' and open_id='1037';update tr_shopcart set price='7.30000000',unit_no='斤',amount=7.30000000 * qty where goods_id='0000000005768' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005769' and open_id='1037';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005771' and open_id='1037';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000005772' and open_id='1037';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005773' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005774' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005775' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='包',amount=3.00000000 * qty where goods_id='0000000005776' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005777' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005778' and open_id='1037';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005780' and open_id='1037';update tr_shopcart set price='6.60000000',unit_no='斤',amount=6.60000000 * qty where goods_id='0000000005785' and open_id='1037';update tr_shopcart set price='1.33000000',unit_no='斤',amount=1.33000000 * qty where goods_id='0000000005790' and open_id='1037';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005791' and open_id='1037';update tr_shopcart set price='19.00000000',unit_no='斤',amount=19.00000000 * qty where goods_id='0000000005792' and open_id='1037';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005793' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005799' and open_id='1037';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005800' and open_id='1037';update tr_shopcart set price='5.75000000',unit_no='斤',amount=5.75000000 * qty where goods_id='0000000005807' and open_id='1037';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000005808' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005809' and open_id='1037';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005810' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005812' and open_id='1037';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005818' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005819' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005821' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005822' and open_id='1037';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005823' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005824' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005826' and open_id='1037';update tr_shopcart set price='1.00000000',unit_no='斤',amount=1.00000000 * qty where goods_id='0000000005827' and open_id='1037';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005828' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005838' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005839' and open_id='1037';update tr_shopcart set price='5.80000000',unit_no='斤',amount=5.80000000 * qty where goods_id='0000000005840' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005843' and open_id='1037';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005844' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005845' and open_id='1037';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005852' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005855' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005859' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005862' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1037';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005864' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005867' and open_id='1037';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000005868' and open_id='1037';update tr_shopcart set price='4.60000000',unit_no='斤',amount=4.60000000 * qty where goods_id='0000000005870' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005871' and open_id='1037';update tr_shopcart set price='28.00000000',unit_no='斤',amount=28.00000000 * qty where goods_id='0000000005906' and open_id='1037'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 12:39:35 [错误信息] => 事务(进程 ID 68)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000000001' and open_id='1037';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1037';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1037';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000000031' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000000032' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000000871' and open_id='1037';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1037';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1037';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001048' and open_id='1037';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1037';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000001123' and open_id='1037';update tr_shopcart set price='6.67000000',unit_no='包',amount=6.67000000 * qty where goods_id='0000000001146' and open_id='1037';update tr_shopcart set price='12.22000000',unit_no='包',amount=12.22000000 * qty where goods_id='0000000001151' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1037';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000001290' and open_id='1037';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1037';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001746' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001749' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000002448' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000004416' and open_id='1037';update tr_shopcart set price='10.00000000',unit_no='包',amount=10.00000000 * qty where goods_id='0000000004604' and open_id='1037';update tr_shopcart set price='3.96000000',unit_no='包',amount=3.96000000 * qty where goods_id='0000000004665' and open_id='1037';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1037';update tr_shopcart set price='5.20000000',unit_no='包',amount=5.20000000 * qty where goods_id='0000000004670' and open_id='1037';update tr_shopcart set price='1.98000000',unit_no='包',amount=1.98000000 * qty where goods_id='0000000004683' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='个',amount=4.00000000 * qty where goods_id='0000000004709' and open_id='1037';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000004718' and open_id='1037';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000004720' and open_id='1037';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000004729' and open_id='1037';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000004755' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1037';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000004758' and open_id='1037';update tr_shopcart set price='3.99000000',unit_no='斤',amount=3.99000000 * qty where goods_id='0000000004768' and open_id='1037';update tr_shopcart set price='5.60000000',unit_no='斤',amount=5.60000000 * qty where goods_id='0000000004772' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='200g/盒',amount=4.50000000 * qty where goods_id='0000000004775' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004776' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004779' and open_id='1037';update tr_shopcart set price='11.92000000',unit_no='包',amount=11.92000000 * qty where goods_id='0000000004825' and open_id='1037';update tr_shopcart set price='14.21000000',unit_no='包',amount=14.21000000 * qty where goods_id='0000000004828' and open_id='1037';update tr_shopcart set price='9.63000000',unit_no='包',amount=9.63000000 * qty where goods_id='0000000004831' and open_id='1037';update tr_shopcart set price='12.36000000',unit_no='包',amount=12.36000000 * qty where goods_id='0000000004886' and open_id='1037';update tr_shopcart set price='13.33000000',unit_no='包',amount=13.33000000 * qty where goods_id='0000000004911' and open_id='1037';update tr_shopcart set price='16.30000000',unit_no='斤',amount=16.30000000 * qty where goods_id='0000000004923' and open_id='1037';update tr_shopcart set price='6.60000000',unit_no='包',amount=6.60000000 * qty where goods_id='0000000004943' and open_id='1037';update tr_shopcart set price='14.44000000',unit_no='包',amount=14.44000000 * qty where goods_id='0000000005080' and open_id='1037';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1037';update tr_shopcart set price='8.00000000',unit_no='个',amount=8.00000000 * qty where goods_id='0000000005360' and open_id='1037';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1037';update tr_shopcart set price='22.50000000',unit_no='板',amount=22.50000000 * qty where goods_id='0000000005430' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005462' and open_id='1037';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005472' and open_id='1037';update tr_shopcart set price='9.80000000',unit_no='斤',amount=9.80000000 * qty where goods_id='0000000005473' and open_id='1037';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005478' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1037';update tr_shopcart set price='2.87000000',unit_no='斤',amount=2.87000000 * qty where goods_id='0000000005486' and open_id='1037';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1037';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005491' and open_id='1037';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005686' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005701' and open_id='1037';update tr_shopcart set price='8.00000000',unit_no='包',amount=8.00000000 * qty where goods_id='0000000005702' and open_id='1037';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005709' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005712' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000005715' and open_id='1037';update tr_shopcart set price='8.80000000',unit_no='包',amount=8.80000000 * qty where goods_id='0000000005716' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005717' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1037';update tr_shopcart set price='5.50000000',unit_no='盒',amount=5.50000000 * qty where goods_id='0000000005721' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000005722' and open_id='1037';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='盒',amount=2.00000000 * qty where goods_id='0000000005730' and open_id='1037';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005731' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005732' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005733' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005735' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005737' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005738' and open_id='1037';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005741' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005743' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005745' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005746' and open_id='1037';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000005747' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005748' and open_id='1037';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005749' and open_id='1037';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005750' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005752' and open_id='1037';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005753' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005754' and open_id='1037';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005755' and open_id='1037';update tr_shopcart set price='14.20000000',unit_no='斤',amount=14.20000000 * qty where goods_id='0000000005756' and open_id='1037';update tr_shopcart set price='3.20000000',unit_no='斤',amount=3.20000000 * qty where goods_id='0000000005758' and open_id='1037';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005759' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005761' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005762' and open_id='1037';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005763' and open_id='1037';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005764' and open_id='1037';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005765' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005766' and open_id='1037';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005767' and open_id='1037';update tr_shopcart set price='7.30000000',unit_no='斤',amount=7.30000000 * qty where goods_id='0000000005768' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005769' and open_id='1037';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005771' and open_id='1037';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005772' and open_id='1037';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005773' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005774' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005775' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='包',amount=3.00000000 * qty where goods_id='0000000005776' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005777' and open_id='1037';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005778' and open_id='1037';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005780' and open_id='1037';update tr_shopcart set price='6.60000000',unit_no='斤',amount=6.60000000 * qty where goods_id='0000000005785' and open_id='1037';update tr_shopcart set price='1.33000000',unit_no='斤',amount=1.33000000 * qty where goods_id='0000000005790' and open_id='1037';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005791' and open_id='1037';update tr_shopcart set price='19.00000000',unit_no='斤',amount=19.00000000 * qty where goods_id='0000000005792' and open_id='1037';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005793' and open_id='1037';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005799' and open_id='1037';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005800' and open_id='1037';update tr_shopcart set price='5.75000000',unit_no='斤',amount=5.75000000 * qty where goods_id='0000000005807' and open_id='1037';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000005808' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005809' and open_id='1037';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005810' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005812' and open_id='1037';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005818' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005819' and open_id='1037';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005821' and open_id='1037';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005822' and open_id='1037';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005823' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005824' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005826' and open_id='1037';update tr_shopcart set price='1.00000000',unit_no='斤',amount=1.00000000 * qty where goods_id='0000000005827' and open_id='1037';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005828' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005838' and open_id='1037';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005839' and open_id='1037';update tr_shopcart set price='5.80000000',unit_no='斤',amount=5.80000000 * qty where goods_id='0000000005840' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005843' and open_id='1037';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005844' and open_id='1037';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005845' and open_id='1037';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005852' and open_id='1037';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005855' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005859' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005862' and open_id='1037';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1037';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005864' and open_id='1037';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005867' and open_id='1037';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000005868' and open_id='1037';update tr_shopcart set price='4.60000000',unit_no='斤',amount=4.60000000 * qty where goods_id='0000000005870' and open_id='1037';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005871' and open_id='1037';update tr_shopcart set price='28.00000000',unit_no='斤',amount=28.00000000 * qty where goods_id='0000000005906' and open_id='1037'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** **************************mima_b2b_Login()2022/6/14 12:56:35************************* paramter0:1060 paramter1:oDppT5B_V7h5qv91xcMlQc1hJDCw Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 12:56:35 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1060' or a.login_no = '1060' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1060","vip_pass":"136606","is_bind":"1","open_id":"oDppT5B_V7h5qv91xcMlQc1hJDCw"} ************************************************************************************** **************************mima_b2b_Login()2022/6/14 13:18:50************************* paramter0:1034 paramter1:oDppT5Gg9zQs9S1uWe8xWZEMyBJ0 Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 13:18:50 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1034' or a.login_no = '1034' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1034","vip_pass":"123457","is_bind":"1","open_id":"oDppT5Gg9zQs9S1uWe8xWZEMyBJ0"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 14:59:48 [错误信息] => 该商品已失效! [sql] => select qty from tr_shopcart where goods_id = '0000000000832' and open_id='1037' [详细] => 在 Api.BLL.b2b.ShopCartService.DeleteQtyOne(tr_shopcart shopcart, Decimal& count, String oper_id, String cus_level) 在 Api.SingOut.b2b.mina.shopcart.delete_qty_one(String goods_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => delete_qty_one [入参] => {"goods_id":"0000000000832"} ************************************************************************************** **************************mima_b2b_Login()2022/6/14 18:01:44************************* paramter0:13533228063 paramter1:oDppT5CYzs2oGYCuwdaAwWQiFm1s Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 18:01:44 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '13533228063' or a.login_no = '13533228063' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"13533228063","vip_pass":"123456","is_bind":"1","open_id":"oDppT5CYzs2oGYCuwdaAwWQiFm1s"} ************************************************************************************** **************************mima_b2b_Login()2022/6/14 19:42:01************************* paramter0:1037 paramter1:oDppT5NVW2KolPOEdA_14gjYYXuE Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 19:42:01 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1037' or a.login_no = '1037' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1037","vip_pass":"123456","is_bind":"1","open_id":"oDppT5NVW2KolPOEdA_14gjYYXuE"} ************************************************************************************** **************************mima_b2b_Login()2022/6/14 20:30:00************************* paramter0:1047 paramter1:oDppT5CYzs2oGYCuwdaAwWQiFm1s Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-14 20:30:00 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1047' or a.login_no = '1047' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1047","vip_pass":"123457","is_bind":"1","open_id":"oDppT5CYzs2oGYCuwdaAwWQiFm1s"} **************************************************************************************