62,074
社区成员
发帖
与我相关
我的任务
分享
public static string PrintSortSQl(string pkeyTable, string pkey, string pkeyCode, string pkeysql, string typeid,string seqfilename)
{
string InsertSQL = "";
InsertSQL = InsertSQL + "declare @currPkey as varchar(50),@prePkey as varchar(50),@nextPkey as varchar(50)";
InsertSQL = InsertSQL + " " + " declare @currSeq as int,@preSeq as int,@nextSeq as int";
InsertSQL = InsertSQL + " " + "set @currPkey='" + pkey + "'";
InsertSQL = InsertSQL + " " + "select @currSeq=" + seqfilename + " from " + pkeyTable + " where " + pkeyCode + "=@currPkey";
InsertSQL = InsertSQL + " " + " select @nextSeq=" + seqfilename + ",@nextPkey=" + pkeyCode + " from " + pkeyTable + " where " + pkeyCode + "=(select top 1 A." + pkeyCode + " from " + pkeyTable + " AS A where A." + seqfilename + ">@currSeq " + pkeysql + " order by a." + seqfilename + " asc)";
InsertSQL = InsertSQL + " " + " select @preSeq =" + seqfilename + ",@prePkey=" + pkeyCode + " from " + pkeyTable + " where " + pkeyCode + "=(select top 1 A." + pkeyCode + " from " + pkeyTable + " AS A where A." + seqfilename + "<@currSeq " + pkeysql + " order by a." + seqfilename + " desc)";
if (typeid == "1")
{
InsertSQL = InsertSQL + " " + "update " + pkeyTable + " set " + seqfilename + " = @preSeq where " + pkeyCode + " = @currPkey";
InsertSQL = InsertSQL + " " + "update " + pkeyTable + " set " + seqfilename + " = @currSeq where " + pkeyCode + " =@prePkey";
}
else
{
InsertSQL = InsertSQL + " " + "update " + pkeyTable + " set " + seqfilename + " = @nextSeq where " + pkeyCode + " = @currPkey";
InsertSQL = InsertSQL + " " + "update " + pkeyTable + " set " + seqfilename + " = @currSeq where " + pkeyCode + " =@nextPkey";
}
return InsertSQL;
}