帮忙把这段程序改成sql或者存储过程，谢谢

[xiatianPHP]

RT

public void FindNotesInfo(string userid,string startuserids,int ischecked,DateTime startDate,DateTime endDate,int priority,string msg)
		{
			string query = " select * from  Notes obj where obj.UserId =userid ";
			string condition = string.Empty;

			if(startuserids != null && startuserids.Trim() != string.Empty)
			{
				if(condition.Trim() != string.Empty)
				{
					condition += " and ";
				}
				condition += " obj.StartUserId in (" + startuserids.Trim() + ")" ;
			}
		
			if(condition.Trim() != string.Empty)
			{
				condition += " and ";
			}
			condition += " obj.Checked =ischecked ";

			if(startDate == DateTime.MinValue || startDate == DateTime.MaxValue )
			{
				startDate = DateTime.Now.AddDays(-7).Date;
			}
			if(endDate == DateTime.MinValue || endDate == DateTime.MaxValue)
			{
				endDate = DateTime.Now.AddDays(1).Date;
			}
			
			if(condition.Trim() != string.Empty)
			{
				condition += " and ";
			}
			condition += " cast(obj.CreateTimestamp as DateTime ) >=startDate and cast( obj.CreateTimestamp as DateTime) <=endDate ";		

			if(condition .Trim() != string.Empty)
			{
				condition += " and ";
			}
			if(priority > 0
			{
				condition += " obj.Priority >= 100";
			}
			else
			{
				condition += " obj.Priority < 100";
			}
			if(msg != null && msg.Trim() != string.Empty)
			{
				if(condition .Trim() != string.Empty)
				{
					condition += " and ";
				}
				msg = "%" + msg.Trim() + "%";
				condition += " obj.Message like msg";
			}

			if(condition.Trim() != string.Empty)
			{
				query += " and " + condition.Trim();
			}

			query += " order by obj.Objid Desc ";
		}

[--小F--]

C# 建议去.NET问问

[用心呼吸]

自己找出c#和sql script的差异，改动下就可以了呀

[不懂装懂]

........这就是单纯的拼sql查询啊

[beargo]

用参数把那几个条件列一下。然后在使用CASE WHEN THEN去做！！！