清除重复记录只保留一条 -ag凯发k8国际
static void nj_mf_cleanrepeat(args _args)
{
nj_sinventtable nj_sinventtable; //
nj_ssetting nj_ssetting,curnj_ssetting; //镶口
nj_shead nj_shead,curnj_shead; //围头
nj_sshank nj_sshank,curnj_sshank; //比
nj_sothers nj_sothers,curnj_sothers; //其它
/* nj_shead_tmp tmpnj_shead;
nj_sothers_tmp tmpnj_sothers;
nj_sshank_tmp tmpnj_sshank;
nj_ssetting_tmp tmpnj_ssetting; */
textbuffer txtbuffer = new textbuffer();
int i;
str txtfilepath;
container confilter = ["text files(*.txt)", "*.txt"];
;
/*
insert_recordset tmpnj_ssetting(refrecid, nj_sitemid, nj_ssetting1stoneweight, nj_ssetting1plug, nj_ssetting1size, nj_ssetting1size1,
nj_ssetting1clawqtyid, nj_ssetting1clawsharpid, nj_ssetting1parts, nj_ssetting1shapeid, nj_ssetting1clawoneid,
nj_ssetting1stoneqty, nj_ssetting1stoneqtyweight, inventsettingid, nj_ssettingid, nj_ssetting1shapeid1,
nj_ssetting1setting, nj_ssettingqty)
select refrecid, nj_sitemid, nj_ssetting1stoneweight, nj_ssetting1plug, nj_ssetting1size, nj_ssetting1size1,
nj_ssetting1clawqtyid, nj_ssetting1clawsharpid, nj_ssetting1parts, nj_ssetting1shapeid, nj_ssetting1clawoneid,
nj_ssetting1stoneqty, nj_ssetting1stoneqtyweight, inventsettingid, nj_ssettingid, nj_ssetting1shapeid1,
nj_ssetting1setting, nj_ssettingqty from nj_ssetting group by
refrecid, nj_sitemid, nj_ssetting1stoneweight, nj_ssetting1plug, nj_ssetting1size, nj_ssetting1size1,
nj_ssetting1clawqtyid, nj_ssetting1clawsharpid, nj_ssetting1parts, nj_ssetting1shapeid, nj_ssetting1clawoneid,
nj_ssetting1stoneqty, nj_ssetting1stoneqtyweight, inventsettingid, nj_ssettingid, nj_ssetting1shapeid1,
nj_ssetting1setting, nj_ssettingqty;
insert_recordset tmpnj_shead(refrecid, nj_sitemid, nj_sheadshapeid, nj_sheadstoneqty, nj_sheadstoneqtyweight, nj_sheadsize,
nj_sheadsize1, nj_sheadsettingid, nj_sheadstoneweight, nj_sheadismainstone, nj_sheadid, nj_sheadqty, nj_sheadshapeid2)
select refrecid, nj_sitemid, nj_sheadshapeid, nj_sheadstoneqty, nj_sheadstoneqtyweight, nj_sheadsize,
nj_sheadsize1, nj_sheadsettingid, nj_sheadstoneweight, nj_sheadismainstone, nj_sheadid, nj_sheadqty, nj_sheadshapeid2
from nj_shead group by refrecid, nj_sitemid, nj_sheadshapeid, nj_sheadstoneqty, nj_sheadstoneqtyweight, nj_sheadsize,
nj_sheadsize1, nj_sheadsettingid, nj_sheadstoneweight, nj_sheadismainstone, nj_sheadid, nj_sheadqty, nj_sheadshapeid2;
insert_recordset tmpnj_sothers(refrecid, nj_sitemid, nj_sothersshapeid, nj_sothersstoneqty, nj_sothersstoneqtyweight, nj_sotherssize,
nj_sotherssize1, nj_sotherssettingid, nj_sothersstoneweight)
select refrecid, nj_sitemid, nj_sothersshapeid, nj_sothersstoneqty, nj_sothersstoneqtyweight, nj_sotherssize,
nj_sotherssize1, nj_sotherssettingid, nj_sothersstoneweight
from nj_sothers group by refrecid, nj_sitemid, nj_sothersshapeid,nj_sothersstoneqty, nj_sothersstoneqtyweight, nj_sotherssize,
nj_sotherssize1, nj_sotherssettingid, nj_sothersstoneweight;
insert_recordset tmpnj_sshank(refrecid, nj_sitemid, nj_sshankshapeid, nj_sshankstoneqty, nj_sshankstoneqtyweight, nj_sshanksize, nj_sshanksize1,
nj_sshanksettingid, nj_sshankstoneweight)
select refrecid, nj_sitemid, nj_sshankshapeid, nj_sshankstoneqty, nj_sshankstoneqtyweight, nj_sshanksize, nj_sshanksize1,
nj_sshanksettingid, nj_sshankstoneweight from nj_sshank group by refrecid, nj_sitemid, nj_sshankshapeid, nj_sshankstoneqty,
nj_sshankstoneqtyweight, nj_sshanksize, nj_sshanksize1, nj_sshanksettingid, nj_sshankstoneweight;
*/
//print (select nj_sitemid,count(recid) from nj_shead group by nj_sitemid).nj_sitemid;
while select count(recid),refrecid, nj_sitemid, nj_sheadshapeid, nj_sheadstoneqty, nj_sheadstoneqtyweight, nj_sheadsize,
nj_sheadsize1, nj_sheadsettingid, nj_sheadstoneweight, nj_sheadismainstone, nj_sheadid, nj_sheadqty, nj_sheadshapeid2
from nj_shead
group by refrecid, nj_sitemid, nj_sheadshapeid, nj_sheadstoneqty, nj_sheadstoneqtyweight, nj_sheadsize,
nj_sheadsize1, nj_sheadsettingid, nj_sheadstoneweight, nj_sheadismainstone, nj_sheadid, nj_sheadqty, nj_sheadshapeid2
{
if(nj_shead.recid>1)
{
i = 1;
while select curnj_shead where curnj_shead.nj_sitemid == nj_shead.nj_sitemid
&& curnj_shead.refrecid == nj_shead.refrecid
&& curnj_shead.nj_sheadshapeid == nj_shead.nj_sheadshapeid
&& curnj_shead.nj_sheadstoneqty == nj_shead.nj_sheadstoneqty
&& curnj_shead.nj_sheadstoneqtyweight == nj_shead.nj_sheadstoneqtyweight
&& curnj_shead.nj_sheadsize == nj_shead.nj_sheadsize
&& curnj_shead.nj_sheadsize1 == nj_shead.nj_sheadsize1
&& curnj_shead.nj_sheadsettingid == nj_shead.nj_sheadsettingid
&& curnj_shead.nj_sheadstoneweight ==nj_shead.nj_sheadstoneweight
&& curnj_shead.nj_sheadismainstone == nj_shead.nj_sheadismainstone
&& curnj_shead.nj_sheadid == nj_shead.nj_sheadid
&& curnj_shead.nj_sheadqty == nj_shead.nj_sheadqty
&& curnj_shead.nj_sheadshapeid2 == nj_shead.nj_sheadshapeid2
{
if(i <= nj_shead.recid - 1)
{
//curnj_shead.dodelete();
print strfmt("围头,%1 , %2 , %3" ,curnj_shead.nj_sitemid,curnj_shead.recid,nj_shead.recid);
txtbuffer.appendtext(strfmt("围头,%1 , %2 , %3 \n" ,curnj_shead.nj_sitemid,curnj_shead.recid,nj_shead.recid));
i ;
}
}
}
}
while select count(recid),refrecid, nj_sitemid, nj_ssetting1stoneweight, nj_ssetting1plug, nj_ssetting1size, nj_ssetting1size1,
nj_ssetting1clawqtyid, nj_ssetting1clawsharpid, nj_ssetting1parts, nj_ssetting1shapeid, nj_ssetting1clawoneid,
nj_ssetting1stoneqty, nj_ssetting1stoneqtyweight, inventsettingid, nj_ssettingid, nj_ssetting1shapeid1,
nj_ssetting1setting, nj_ssettingqty
from nj_ssetting
group by refrecid, nj_sitemid, nj_ssetting1stoneweight, nj_ssetting1plug, nj_ssetting1size, nj_ssetting1size1,
nj_ssetting1clawqtyid, nj_ssetting1clawsharpid, nj_ssetting1parts, nj_ssetting1shapeid, nj_ssetting1clawoneid,
nj_ssetting1stoneqty, nj_ssetting1stoneqtyweight, inventsettingid, nj_ssettingid, nj_ssetting1shapeid1,
nj_ssetting1setting, nj_ssettingqty
{
if(nj_ssetting.recid > 1)
{
i = 1;
while select curnj_ssetting where curnj_ssetting.refrecid == nj_ssetting.refrecid
&& curnj_ssetting.nj_sitemid == nj_ssetting.nj_sitemid
&& curnj_ssetting.nj_ssetting1stoneweight == nj_ssetting.nj_ssetting1stoneweight
&& curnj_ssetting.nj_ssetting1plug == nj_ssetting.nj_ssetting1plug
&& curnj_ssetting.nj_ssetting1size == nj_ssetting.nj_ssetting1size
&& curnj_ssetting.nj_ssetting1size1 == nj_ssetting.nj_ssetting1size1
&& curnj_ssetting.nj_ssetting1clawqtyid == nj_ssetting.nj_ssetting1clawqtyid
&& curnj_ssetting.nj_ssetting1clawsharpid == nj_ssetting.nj_ssetting1clawsharpid
&& curnj_ssetting.nj_ssetting1parts == nj_ssetting.nj_ssetting1parts
&& curnj_ssetting.nj_ssetting1shapeid == nj_ssetting.nj_ssetting1shapeid
&& curnj_ssetting.nj_ssetting1clawoneid == nj_ssetting.nj_ssetting1clawoneid
&& curnj_ssetting.nj_ssetting1stoneqty == nj_ssetting.nj_ssetting1stoneqty
&& curnj_ssetting.nj_ssetting1stoneqtyweight == nj_ssetting.nj_ssetting1stoneqtyweight
&& curnj_ssetting.inventsettingid == curnj_ssetting.inventsettingid
&& curnj_ssetting.nj_ssettingid == curnj_ssetting.nj_ssettingid
&& curnj_ssetting.nj_ssetting1shapeid1 == curnj_ssetting.nj_ssetting1shapeid1
&& curnj_ssetting.nj_ssetting1setting == curnj_ssetting.nj_ssetting1setting
&& curnj_ssetting.nj_ssettingqty == curnj_ssetting.nj_ssettingqty
{
if(i <= nj_ssetting.recid - 1)
{
//curnj_ssetting.dodelete();
print strfmt("镶口, %1 , %2 , %3" ,curnj_ssetting.nj_sitemid,curnj_ssetting.recid,nj_ssetting.recid);
txtbuffer.appendtext(strfmt("镶口, %1 , %2 , %3 \n" ,curnj_ssetting.nj_sitemid,curnj_ssetting.recid,nj_ssetting.recid));
i ;
}
}
}
}
while select count(recid),refrecid, nj_sitemid, nj_sothersshapeid, nj_sothersstoneqty, nj_sothersstoneqtyweight, nj_sotherssize,
nj_sotherssize1, nj_sotherssettingid, nj_sothersstoneweight
from nj_sothers
group by refrecid, nj_sitemid, nj_sothersshapeid, nj_sothersstoneqty, nj_sothersstoneqtyweight, nj_sotherssize,
nj_sotherssize1, nj_sotherssettingid, nj_sothersstoneweight
{
if(nj_sothers.recid > 1)
{
i = 1;
while select curnj_sothers where curnj_sothers.refrecid == nj_sothers.refrecid
&& curnj_sothers.nj_sitemid == nj_sothers.nj_sitemid
&& curnj_sothers.nj_sothersshapeid == nj_sothers.nj_sothersshapeid
&& curnj_sothers.nj_sothersstoneqty == nj_sothers.nj_sothersstoneqty
&& curnj_sothers.nj_sothersstoneqtyweight == nj_sothers.nj_sothersstoneqtyweight
&& curnj_sothers.nj_sotherssize == nj_sothers.nj_sotherssize
&& curnj_sothers.nj_sotherssize1 == nj_sothers.nj_sotherssize1
&& curnj_sothers.nj_sotherssettingid == nj_sothers.nj_sotherssettingid
&& curnj_sothers.nj_sothersstoneweight == nj_sothers.nj_sothersstoneweight
{
if (i <= nj_sothers.recid - 1)
{
//curnj_sothers.dodelete();
print strfmt("其它,%1 %2 %3" ,curnj_sothers.nj_sitemid,curnj_sothers.recid,nj_sothers.recid);
txtbuffer.appendtext(strfmt("其它,%1 %2 %3 \n" ,curnj_sothers.nj_sitemid,curnj_sothers.recid,nj_sothers.recid));
i ;
}
}
}
}
while select count(recid),refrecid, nj_sitemid, nj_sshankshapeid, nj_sshankstoneqty, nj_sshankstoneqtyweight, nj_sshanksize, nj_sshanksize1,
nj_sshanksettingid, nj_sshankstoneweight
from nj_sshank group by refrecid, nj_sitemid, nj_sshankshapeid, nj_sshankstoneqty, nj_sshankstoneqtyweight, nj_sshanksize, nj_sshanksize1,
nj_sshanksettingid, nj_sshankstoneweight
{
if(nj_sshank.recid >1)
{
i=1;
while select curnj_sshank where curnj_sshank.refrecid == nj_sshank.refrecid
&& curnj_sshank.nj_sitemid == nj_sshank.nj_sitemid
&& curnj_sshank.nj_sshankshapeid == nj_sshank.nj_sshankshapeid
&& curnj_sshank.nj_sshankstoneqty == nj_sshank.nj_sshankstoneqty
&& curnj_sshank.nj_sshankstoneqtyweight == nj_sshank.nj_sshankstoneqtyweight
&& curnj_sshank.nj_sshanksize == nj_sshank.nj_sshanksize
&& curnj_sshank.nj_sshanksize1 == nj_sshank.nj_sshanksize1
&& curnj_sshank.nj_sshanksettingid == nj_sshank.nj_sshanksettingid
&& curnj_sshank.nj_sshankstoneweight == nj_sshank.nj_sshankstoneweight
{
if(i <= nj_sshank.recid - 1)
{
//curnj_sshank.dodelete();
print strfmt("比, %1 , %2 , %3 " ,curnj_sshank.nj_sitemid,curnj_sshank.recid,nj_sshank.recid);
txtbuffer.appendtext(strfmt("比, %1 , %2 , %3 \n" ,curnj_sshank.nj_sitemid,curnj_sshank.recid,nj_sshank.recid));
i ;
}
}
}
}
txtfilepath = winapi::getsavefilename(0, confilter,"", "specify savefile name", "", "");
if(txtfilepath)
{
txtbuffer.tofile(txtfilepath);
}
pause;
}
转载于:https://www.cnblogs.com/perock/archive/2011/12/22/2297213.html
总结
以上是ag凯发k8国际为你收集整理的清除重复记录只保留一条的全部内容，希望文章能够帮你解决所遇到的问题。
- 上一篇： “个人核心竞争力”与“危机感”
- 下一篇： 手机web开发的感想