110,561
社区成员
发帖
与我相关
我的任务
分享
string Strsqlwxyh = "select uid,wxname,token from tp_wxuser where wxname like '%事业中心%'";
DataSet dswxyh = DbHelperMySQL.Query(Strsqlwxyh);
List<string> listwxyh = new List<string>();
if (dswxyh.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dswxyh.Tables[0].Rows.Count; i++)
{
string Token = dswxyh.Tables[0].Rows[i][2].ToString();//循环Token
listwxyh.Add("delete from tp_img where token='" + Token + "'");
///循环插入
DbHelperMySQL.ExecuteSqlTran(listwxyh);
string Uid = dswxyh.Tables[0].Rows[i][0].ToString();
string Uname = dswxyh.Tables[0].Rows[i][1].ToString();
string Strsqltw = "select uid,uname,keyword,type,text,classid,classname,pic,showpic,info,url,createtime,uptatetime,click,token,title,usort from tp_img where token ='" + Source + "'";
DataSet dstw = DbHelperMySQL.Query(Strsqltw);
List<string> listtw = new List<string>();
if (dstw.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < dstw.Tables[0].Rows.Count; j++)
{
listtw.Add("insert into tp_img (uid,uname,keyword,type,text,classid,classname,pic,showpic,info,url,createtime,uptatetime,click,token,title,usort) values ('" + Uid + "','" + Uname + "','" + dstw.Tables[0].Rows[i][2] + "','" + dstw.Tables[0].Rows[i][3] + "','" + dstw.Tables[0].Rows[i][4] + "','" + dstw.Tables[0].Rows[i][5] + "','" + dstw.Tables[0].Rows[i][6] + "','" + dstw.Tables[0].Rows[i][7] + "','" + dstw.Tables[0].Rows[i][8] + "','" + dstw.Tables[0].Rows[i][9] + "','" + dstw.Tables[0].Rows[i][10] + "','" + dstw.Tables[0].Rows[i][11] + "','" + dstw.Tables[0].Rows[i][12] + "','" + dstw.Tables[0].Rows[i][13] + "','" + Token + "','" + dstw.Tables[0].Rows[i][15] + "','" + dstw.Tables[0].Rows[i][16] + "')");
}
///循环插入
DbHelperMySQL.ExecuteSqlTran(listtw);
}
}
}
1
2
3
4
5
因为上面这5条数据是用来做条件的,比如我第一条业务成功后 就需要删除第一条数据,用第二个数据来做为条件。成功后删除第二个 !以此类推指导走到5的时候成功后就把5页删除 直到业务结束!
List<string> aaa = new List<string>();
aaa.AddRange (new string []{"这","那","这个","那个"});
int aa = aaa.IndexOf("这个");
aaa.Remove("那");
aaa.RemoveAt(aa);
if(执行成功)
listwxyh.RemoveAt(0);