2023年6月21日发(作者：)

mysqltext字段like_使⽤like查询text类型字段public bool Exists(GetReadType GRT, ClientMessageGetRead TypeID, string MessageID, stringUserID){int ThisGRT =32(GRT);int ThisTypeID =32(TypeID);string strSql = @"selectcount(1)fromClient_Message_GetReadwhereGetRead = @GetReadandTypeID = @TypeIDandMessageID like '%'+@MessageID+'%'andUserID = @UserID";SqlParameter[] parameters={new SqlParameter("@GetRead", ,4),new SqlParameter("@TypeID",,4),new SqlParameter("@MessageID", ,36),new SqlParameter("@UserID", ,36)};parameters[0].Value =ThisGRT;parameters[1].Value =ThisTypeID;parameters[2].Value =MessageID;parameters[3].Value =UserID;(ng(), parameters);} public DataSet NotExists1(GetReadType GRT, string CompanyID, stringUserID){int ThisGRT =32(GRT);int ThisTypeID =32(ClientMessageGetRead.公益团体消息);string strSql =@"select*fromCompany_Company_MessagewhereCompanyID = @CompanyIDand(selecttop 1 MessageIDfromClient_Message_GetReadwhereGetRead = @GetReadandTypeID = @TypeIDandUserID = @UserID)not like '%'+MessageID +'%'";SqlParameter[] parameters={new SqlParameter("@GetRead", ,4),new SqlParameter("@TypeID",,4),new SqlParameter("@CompanyID", ,36),new SqlParameter("@UserID", ,36)};parameters[0].Value =ThisGRT;parameters[1].Value =ThisTypeID;parameters[2].Value =CompanyID;parameters[3].Value =UserID;(ng(), parameters);}

2023年6月21日发(作者：)

mysqltext字段like_使⽤like查询text类型字段public bool Exists(GetReadType GRT, ClientMessageGetRead TypeID, string MessageID, stringUserID){int ThisGRT =32(GRT);int ThisTypeID =32(TypeID);string strSql = @"selectcount(1)fromClient_Message_GetReadwhereGetRead = @GetReadandTypeID = @TypeIDandMessageID like '%'+@MessageID+'%'andUserID = @UserID";SqlParameter[] parameters={new SqlParameter("@GetRead", ,4),new SqlParameter("@TypeID",,4),new SqlParameter("@MessageID", ,36),new SqlParameter("@UserID", ,36)};parameters[0].Value =ThisGRT;parameters[1].Value =ThisTypeID;parameters[2].Value =MessageID;parameters[3].Value =UserID;(ng(), parameters);} public DataSet NotExists1(GetReadType GRT, string CompanyID, stringUserID){int ThisGRT =32(GRT);int ThisTypeID =32(ClientMessageGetRead.公益团体消息);string strSql =@"select*fromCompany_Company_MessagewhereCompanyID = @CompanyIDand(selecttop 1 MessageIDfromClient_Message_GetReadwhereGetRead = @GetReadandTypeID = @TypeIDandUserID = @UserID)not like '%'+MessageID +'%'";SqlParameter[] parameters={new SqlParameter("@GetRead", ,4),new SqlParameter("@TypeID",,4),new SqlParameter("@CompanyID", ,36),new SqlParameter("@UserID", ,36)};parameters[0].Value =ThisGRT;parameters[1].Value =ThisTypeID;parameters[2].Value =CompanyID;parameters[3].Value =UserID;(ng(), parameters);}