项目中用到的关于时间段不能重复的解决方法

最新推荐文章于 2020-09-14 18:17:53 发布

flyingdream123

最新推荐文章于 2020-09-14 18:17:53 发布

阅读量1k

点赞数

分类专栏： Sql

Sql 专栏收录该内容

28 篇文章 0 订阅

订阅专栏

string sql = "select ShipperQuoteMasterNo from SEGShipperQuoteMaster where ShipperQuoteMasterNo not in ( select ShipperQuoteMasterNo "
+ "from SEGShipperQuoteMaster where CONVERT(varchar(10),QuoteEndDate,120)<'" + DataTypeHelper.GetDateTime(shipperQuoteMaster.QuoteStartDate).ToString("yyyy-MM-dd") + "' OR CONVERT(varchar(10),QuoteStartDate,120)>'" + DataTypeHelper.GetDateTime(shipperQuoteMaster.QuoteEndDate).ToString("yyyy-MM-dd") + "' ) and ShipperID='" + shipperQuoteMaster.ShipperID + "'";编辑时:

string sql = "select ShipperQuoteMasterNo from SEGShipperQuoteMaster where ShipperQuoteMasterNo not in ( select ShipperQuoteMasterNo "
+ "from SEGShipperQuoteMaster where CONVERT(varchar(10),QuoteEndDate,120)<'" + DataTypeHelper.GetDateTime(shipperQuoteMaster.QuoteStartDate).ToString("yyyy-MM-dd")
+ "' OR CONVERT(varchar(10),QuoteStartDate,120)>'" + DataTypeHelper.GetDateTime(shipperQuoteMaster.QuoteEndDate).ToString("yyyy-MM-dd") + "' ) and ShipperID='" + shipperQuoteMaster.ShipperID + "' and ShipperQuoteMasterNo<>'" + shipperQuoteMaster.ID + "'";