**************************mima_b2b_Login()2022/6/8 9:57:25************************* 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-08 09:57:25 [错误信息] => 密码错误 [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"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 10:18:28************************* paramter0:1028 paramter1:oDppT5NgDqi9RzKaP11NQ08qNB-I 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-08 10:18:28 [错误信息] => 密码错误 [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 = '1028' or a.login_no = '1028' [详细] => 在 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":"1028","vip_pass":"888888","is_bind":"1","open_id":"oDppT5NgDqi9RzKaP11NQ08qNB-I"} ************************************************************************************** ************************************************************************************** [意料之内的错误] ----- 2022-06-08 12:02:18 [错误信息] => 登录已失效 [详细] => 在 Api.BaseService.GetMethod(MethodInfo method, Dictionary`2 pairs) 在 Api.BaseService.ProcessRequest(HttpContext context) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之内的错误] ----- 2022-06-08 12:02:18 [错误信息] => 登录已失效 [详细] => 在 Api.BaseService.GetMethod(MethodInfo method, Dictionary`2 pairs) 在 Api.BaseService.ProcessRequest(HttpContext context) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** **************************mima_b2b_Login()2022/6/8 12:49:09************************* paramter0:1101 paramter1:oDppT5K2u9IXz87NkfMFH_f5U_OU 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-08 12:49:09 [错误信息] => 密码错误 [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 = '1101' or a.login_no = '1101' [详细] => 在 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":"1101","vip_pass":"124456","is_bind":"1","open_id":"oDppT5K2u9IXz87NkfMFH_f5U_OU"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 12:49:10************************* paramter0:1101 paramter1:oDppT5K2u9IXz87NkfMFH_f5U_OU 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-08 12:49:10 [错误信息] => 密码错误 [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 = '1101' or a.login_no = '1101' [详细] => 在 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":"1101","vip_pass":"124456","is_bind":"1","open_id":"oDppT5K2u9IXz87NkfMFH_f5U_OU"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-08 13:12:36 [错误信息] => 商品数量不能小于零！ [sql] => select qty from tr_shopcart where goods_id = '0000000005753' and open_id='1020' [详细] => 在 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":"0000000005753"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-08 13:12:38 [错误信息] => 商品数量不能小于零！ [sql] => select qty from tr_shopcart where goods_id = '0000000005753' and open_id='1020' [详细] => 在 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":"0000000005753"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-08 13:15:03 [错误信息] => 该商品已失效！ [sql] => select qty from tr_shopcart where goods_id = '0000000005494' and open_id='1092' [详细] => 在 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":"0000000005494"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-08 14:23:44 [错误信息] => 事务(进程 ID 70)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='14.50000000',unit_no='斤',amount=14.50000000 * qty where goods_id='0000000000055' and open_id='1113';update tr_shopcart set price='21.50000000',unit_no='斤',amount=21.50000000 * qty where goods_id='0000000005917' and open_id='1113';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1113';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1113';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1113';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1113';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005859' and open_id='1113';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005868' and open_id='1113';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005935' and open_id='1113';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005922' and open_id='1113';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005931' and open_id='1113';update tr_shopcart set price='13.00000000',unit_no='斤',amount=13.00000000 * qty where goods_id='0000000005947' and open_id='1113';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005932' and open_id='1113';update tr_shopcart set price='12.80000000',unit_no='斤',amount=12.80000000 * qty where goods_id='0000000005015' and open_id='1113';update tr_shopcart set price='28.00000000',unit_no='斤',amount=28.00000000 * qty where goods_id='0000000005906' and open_id='1113';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1113';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005871' and open_id='1113';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1113';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1113'; [详细] => 在 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/8 15:10:04************************* paramter0:9024 paramter1:oDppT5IqQjL5tc8SXv5U77joK1vc 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-08 15:10:04 [错误信息] => 用户不存在 [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 = '9024' or a.login_no = '9024' [详细] => 在 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":"9024","vip_pass":"123456","is_bind":"1","open_id":"oDppT5IqQjL5tc8SXv5U77joK1vc"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 15:10:05************************* paramter0:9024 paramter1:oDppT5IqQjL5tc8SXv5U77joK1vc 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-08 15:10:05 [错误信息] => 用户不存在 [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 = '9024' or a.login_no = '9024' [详细] => 在 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":"9024","vip_pass":"123456","is_bind":"1","open_id":"oDppT5IqQjL5tc8SXv5U77joK1vc"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 15:21:34************************* paramter0:q123455 paramter1:oDppT5ECg7vdhTxTbtBByZyGOs_g 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-08 15:21:34 [错误信息] => 用户不存在 [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 = 'q123455' or a.login_no = 'q123455' [详细] => 在 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":"q123455","vip_pass":"123456","is_bind":"1","open_id":"oDppT5ECg7vdhTxTbtBByZyGOs_g"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-08 15:23:30 [错误信息] => 事务(进程 ID 68)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1041';update tr_shopcart set price='2.85000000',unit_no='斤',amount=2.85000000 * qty where goods_id='0000000005490' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005491' and open_id='1041';update tr_shopcart set price='21.25000000',unit_no='板',amount=21.25000000 * qty where goods_id='0000000005504' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='板',amount=6.25000000 * qty where goods_id='0000000005431' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005501' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005808' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005464' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005478' and open_id='1041';update tr_shopcart set price='3.12000000',unit_no='个',amount=3.12000000 * qty where goods_id='0000000005429' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000005493' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000004755' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1041';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000004720' and open_id='1041';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005767' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1041';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005765' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005717' and open_id='1041';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005712' and open_id='1041';update tr_shopcart set price='8.60000000',unit_no='斤',amount=8.60000000 * qty where goods_id='0000000005768' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000004730' and open_id='1041';update tr_shopcart set price='7.20000000',unit_no='斤',amount=7.20000000 * qty where goods_id='0000000005763' and open_id='1041';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000000031' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005713' and open_id='1041';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005709' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005839' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005838' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004776' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005741' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004779' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000001247' and open_id='1041';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005822' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005758' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1041';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005778' and open_id='1041';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000004758' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005759' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005813' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005823' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000004689' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005750' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1041';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1041';update tr_shopcart set price='2.87000000',unit_no='斤',amount=2.87000000 * qty where goods_id='0000000005486' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005785' and open_id='1041';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005830' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1041';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005832' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005800' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005773' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005761' and open_id='1041';update tr_shopcart set price='16.00000000',unit_no='斤',amount=16.00000000 * qty where goods_id='0000000000880' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005706' and open_id='1041';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1041';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005503' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005743' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000004744' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005762' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1041';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005784' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005777' and open_id='1041';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005821' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005755' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='包',amount=6.25000000 * qty where goods_id='0000000001511' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005803' and open_id='1041';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1041';update tr_shopcart set price='15.00000000',unit_no='斤',amount=15.00000000 * qty where goods_id='0000000005794' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005782' and open_id='1041';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1041'; [详细] => 在 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-08 15:23:35 [错误信息] => 事务(进程 ID 66)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1041';update tr_shopcart set price='2.85000000',unit_no='斤',amount=2.85000000 * qty where goods_id='0000000005490' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005491' and open_id='1041';update tr_shopcart set price='21.25000000',unit_no='板',amount=21.25000000 * qty where goods_id='0000000005504' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='板',amount=6.25000000 * qty where goods_id='0000000005431' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005501' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005808' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005464' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005478' and open_id='1041';update tr_shopcart set price='3.12000000',unit_no='个',amount=3.12000000 * qty where goods_id='0000000005429' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000005493' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000004755' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1041';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000004720' and open_id='1041';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005767' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1041';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005765' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005717' and open_id='1041';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005712' and open_id='1041';update tr_shopcart set price='8.60000000',unit_no='斤',amount=8.60000000 * qty where goods_id='0000000005768' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000004730' and open_id='1041';update tr_shopcart set price='7.20000000',unit_no='斤',amount=7.20000000 * qty where goods_id='0000000005763' and open_id='1041';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000000031' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005713' and open_id='1041';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005709' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005839' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005838' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004776' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005741' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004779' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000001247' and open_id='1041';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005822' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005758' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1041';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005778' and open_id='1041';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000004758' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005759' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005813' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005823' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000004689' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005750' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1041';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1041';update tr_shopcart set price='2.87000000',unit_no='斤',amount=2.87000000 * qty where goods_id='0000000005486' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005785' and open_id='1041';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005830' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1041';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005832' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005800' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005773' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005761' and open_id='1041';update tr_shopcart set price='16.00000000',unit_no='斤',amount=16.00000000 * qty where goods_id='0000000000880' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005706' and open_id='1041';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1041';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005503' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005743' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000004744' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005762' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1041';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005784' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005777' and open_id='1041';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005821' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005755' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='包',amount=6.25000000 * qty where goods_id='0000000001511' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005803' and open_id='1041';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1041';update tr_shopcart set price='15.00000000',unit_no='斤',amount=15.00000000 * qty where goods_id='0000000005794' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005782' and open_id='1041';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1041'; [详细] => 在 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-08 15:23:40 [错误信息] => 事务(进程 ID 70)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1041';update tr_shopcart set price='2.85000000',unit_no='斤',amount=2.85000000 * qty where goods_id='0000000005490' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005491' and open_id='1041';update tr_shopcart set price='21.25000000',unit_no='板',amount=21.25000000 * qty where goods_id='0000000005504' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='板',amount=6.25000000 * qty where goods_id='0000000005431' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005501' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005808' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005464' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005478' and open_id='1041';update tr_shopcart set price='3.12000000',unit_no='个',amount=3.12000000 * qty where goods_id='0000000005429' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000005493' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000004755' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1041';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000004720' and open_id='1041';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005767' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1041';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005765' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005717' and open_id='1041';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005712' and open_id='1041';update tr_shopcart set price='8.60000000',unit_no='斤',amount=8.60000000 * qty where goods_id='0000000005768' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000004730' and open_id='1041';update tr_shopcart set price='7.20000000',unit_no='斤',amount=7.20000000 * qty where goods_id='0000000005763' and open_id='1041';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000000031' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005713' and open_id='1041';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005709' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005839' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005838' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004776' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005741' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004779' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000001247' and open_id='1041';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005822' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005758' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1041';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005778' and open_id='1041';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000004758' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005759' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005813' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005823' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000004689' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005750' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1041';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1041';update tr_shopcart set price='2.87000000',unit_no='斤',amount=2.87000000 * qty where goods_id='0000000005486' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005785' and open_id='1041';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005830' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1041';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005832' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005800' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005773' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005761' and open_id='1041';update tr_shopcart set price='16.00000000',unit_no='斤',amount=16.00000000 * qty where goods_id='0000000000880' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005706' and open_id='1041';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1041';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005503' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005743' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000004744' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005762' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1041';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005784' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005777' and open_id='1041';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005821' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005755' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='包',amount=6.25000000 * qty where goods_id='0000000001511' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005803' and open_id='1041';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1041';update tr_shopcart set price='15.00000000',unit_no='斤',amount=15.00000000 * qty where goods_id='0000000005794' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005782' and open_id='1041';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1041'; [详细] => 在 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-08 15:25:44 [错误信息] => 事务(进程 ID 70)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1041';update tr_shopcart set price='2.85000000',unit_no='斤',amount=2.85000000 * qty where goods_id='0000000005490' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005491' and open_id='1041';update tr_shopcart set price='21.25000000',unit_no='板',amount=21.25000000 * qty where goods_id='0000000005504' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='板',amount=6.25000000 * qty where goods_id='0000000005431' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005501' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005808' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005464' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005478' and open_id='1041';update tr_shopcart set price='3.12000000',unit_no='个',amount=3.12000000 * qty where goods_id='0000000005429' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000005493' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000004755' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1041';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000004720' and open_id='1041';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005767' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1041';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005765' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005717' and open_id='1041';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005712' and open_id='1041';update tr_shopcart set price='8.60000000',unit_no='斤',amount=8.60000000 * qty where goods_id='0000000005768' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000004730' and open_id='1041';update tr_shopcart set price='7.20000000',unit_no='斤',amount=7.20000000 * qty where goods_id='0000000005763' and open_id='1041';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000000031' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005713' and open_id='1041';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005709' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005839' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005838' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004776' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005741' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004779' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000001247' and open_id='1041';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005822' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005758' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1041';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005778' and open_id='1041';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000004758' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005759' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005813' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005823' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000004689' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005750' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1041';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1041';update tr_shopcart set price='2.87000000',unit_no='斤',amount=2.87000000 * qty where goods_id='0000000005486' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005785' and open_id='1041';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005830' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1041';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005832' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005800' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005773' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005761' and open_id='1041';update tr_shopcart set price='16.00000000',unit_no='斤',amount=16.00000000 * qty where goods_id='0000000000880' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005706' and open_id='1041';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1041';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005503' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005743' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000004744' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005762' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1041';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005784' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005777' and open_id='1041';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005821' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005755' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='包',amount=6.25000000 * qty where goods_id='0000000001511' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005803' and open_id='1041';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1041';update tr_shopcart set price='15.00000000',unit_no='斤',amount=15.00000000 * qty where goods_id='0000000005794' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005782' and open_id='1041';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1041'; [详细] => 在 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-08 15:28:10 [错误信息] => 事务(进程 ID 69)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1041';update tr_shopcart set price='2.85000000',unit_no='斤',amount=2.85000000 * qty where goods_id='0000000005490' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005491' and open_id='1041';update tr_shopcart set price='21.25000000',unit_no='板',amount=21.25000000 * qty where goods_id='0000000005504' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='板',amount=6.25000000 * qty where goods_id='0000000005431' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005501' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005808' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005464' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005478' and open_id='1041';update tr_shopcart set price='3.12000000',unit_no='个',amount=3.12000000 * qty where goods_id='0000000005429' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000005493' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000004755' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1041';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000004720' and open_id='1041';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005767' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1041';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005765' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005717' and open_id='1041';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005712' and open_id='1041';update tr_shopcart set price='8.60000000',unit_no='斤',amount=8.60000000 * qty where goods_id='0000000005768' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000004730' and open_id='1041';update tr_shopcart set price='7.20000000',unit_no='斤',amount=7.20000000 * qty where goods_id='0000000005763' and open_id='1041';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000000031' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005713' and open_id='1041';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000005709' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005839' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005838' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004776' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005741' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004779' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000001247' and open_id='1041';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005822' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005758' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1041';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005778' and open_id='1041';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000004758' and open_id='1041';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1041';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005759' and open_id='1041';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1041';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005813' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005823' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='斤',amount=6.25000000 * qty where goods_id='0000000004689' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005750' and open_id='1041';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1041';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1041';update tr_shopcart set price='2.87000000',unit_no='斤',amount=2.87000000 * qty where goods_id='0000000005486' and open_id='1041';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005785' and open_id='1041';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005830' and open_id='1041';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1041';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005832' and open_id='1041';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005800' and open_id='1041';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005773' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005761' and open_id='1041';update tr_shopcart set price='16.00000000',unit_no='斤',amount=16.00000000 * qty where goods_id='0000000000880' and open_id='1041';update tr_shopcart set price='11.50000000',unit_no='斤',amount=11.50000000 * qty where goods_id='0000000004715' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005706' and open_id='1041';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005757' and open_id='1041';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1041';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005503' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005743' and open_id='1041';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000004744' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005762' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1041';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1041';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005784' and open_id='1041';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1041';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005777' and open_id='1041';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005821' and open_id='1041';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1041';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1041';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1041';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005755' and open_id='1041';update tr_shopcart set price='6.25000000',unit_no='包',amount=6.25000000 * qty where goods_id='0000000001511' and open_id='1041';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1041';update tr_shopcart set price='15.00000000',unit_no='斤',amount=15.00000000 * qty where goods_id='0000000005794' and open_id='1041';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1041';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005782' and open_id='1041';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1041';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000004769' and open_id='1041'; [详细] => 在 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/8 16:00:11************************* paramter0:1027 paramter1:oDppT5HC1yFwmH-lQ4602MhtxMqw 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-08 16:00:11 [错误信息] => 密码错误 [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 = '1027' or a.login_no = '1027' [详细] => 在 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":"1027","vip_pass":"123446","is_bind":"1","open_id":"oDppT5HC1yFwmH-lQ4602MhtxMqw"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 16:00:29************************* paramter0:1027 paramter1:oDppT5HC1yFwmH-lQ4602MhtxMqw 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-08 16:00:29 [错误信息] => 密码错误 [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 = '1027' or a.login_no = '1027' [详细] => 在 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":"1027","vip_pass":"123446","is_bind":"1","open_id":"oDppT5HC1yFwmH-lQ4602MhtxMqw"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 16:00:52************************* paramter0:1027 paramter1:oDppT5HC1yFwmH-lQ4602MhtxMqw 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-08 16:00:52 [错误信息] => 密码错误 [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 = '1027' or a.login_no = '1027' [详细] => 在 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":"1027","vip_pass":"123446","is_bind":"1","open_id":"oDppT5HC1yFwmH-lQ4602MhtxMqw"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 16:04:23************************* paramter0:13692294427 paramter1:oDppT5Bt8hK1rRVZ_NhyLkp2_Ldo 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-08 16:04:23 [错误信息] => 用户不存在 [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 = '13692294427' or a.login_no = '13692294427' [详细] => 在 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":"13692294427","vip_pass":"13692294427","is_bind":"1","open_id":"oDppT5Bt8hK1rRVZ_NhyLkp2_Ldo"} ************************************************************************************** ************************************************************************************** [意料之内的错误] ----- 2022-06-08 16:29:51 [错误信息] => 登录已失效 [详细] => 在 Api.BaseService.GetMethod(MethodInfo method, Dictionary`2 pairs) 在 Api.BaseService.ProcessRequest(HttpContext context) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.order , [方法] => get_order_list [入参] => {"keyword":"","day_num":"1000"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 16:36:05************************* paramter0:1027 paramter1:oDppT5HC1yFwmH-lQ4602MhtxMqw 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-08 16:36:05 [错误信息] => 密码错误 [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 = '1027' or a.login_no = '1027' [详细] => 在 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":"1027","vip_pass":"1234t6","is_bind":"1","open_id":"oDppT5HC1yFwmH-lQ4602MhtxMqw"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 17:06:37************************* paramter0:123456 paramter1:oDppT5GCq-4zp_r9HWKeg6NV0rOc 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-08 17:06:37 [错误信息] => 用户不存在 [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 = '123456' or a.login_no = '123456' [详细] => 在 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":"123456","vip_pass":"1002","is_bind":"1","open_id":"oDppT5GCq-4zp_r9HWKeg6NV0rOc"} ************************************************************************************** **************************mima_b2b_Login()2022/6/8 18:57:26************************* paramter0:1001 paramter1:oDppT5LuY8tCVDeFTX7JyGlnkmTk 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-08 18:57:26 [错误信息] => 密码错误 [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 = '1001' or a.login_no = '1001' [详细] => 在 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":"1001","vip_pass":"124456","is_bind":"1","open_id":"oDppT5LuY8tCVDeFTX7JyGlnkmTk"} **************************************************************************************