111,123
社区成员
发帖
与我相关
我的任务
分享c# for循环问题！！
要实现的功能是把一个文件夹里的所有文件和文件名信息插入到一张表中
public class Files
{
private string _FileName;
private int _FileSize;
private string _Suffix;
public Files(string FileName, int FileSize, string SortName)
{
this._FileName = FileName;
this._FileSize = FileSize;
this._Suffix = SortName;
}
public string FileName
{
get { return _FileName; }
set { _FileName = value; }
}
public int FileSize
{
get { return _FileSize; }
set { _FileSize = value; }
}
public string Suffix
{
get { return _Suffix; }
set { _Suffix = value; }
}
}
private List<int> listSize = new List<int>(new int[] { 10, 179, 22, 20, 24, 21, 21, 30, 20, 1149 });//表记录列表
private List<string> TableNames = new List<string>(new string[] { "u_DZDA", "u_JNJML", "u_KJJNJML", "u_JJWJ", "u_SBWJ", "u_CPWJ", "u_ZPJNJML", "u_ZPJHZL", "u_SXDA", "u_GDWJML" }); //表列表
private void Insert()
{
List<int> getJLID = new List<int>();
List<Files> GetFile = GetFiles();
string strConn = "Data Source=localhost;DataBase=FH_GSZDY;User ID=sa;Password=";
SqlConnection dbConn = new SqlConnection(strConn);
int count = listSize.Count;
int k = 0;
for (int i = 0; i < count; i++)
{
for (int j = k; j < k+listSize[i]; j++)
{
string xywm = "sdafoigjfgjojwnd" +(j+1);
string time = DateTime.Now.ToString();
string strSql = "select id from " + TableNames[i]; //查询出所有表的所有id
DataSet ds = SqlHelper.ExecuteDataset(dbConn, CommandType.Text, strSql);
DataTable dt = ds.Tables[0];
for (int z = 0; z < dt.Rows.Count; z++)
{
string str = dt.Rows[z][0] + "\n";
getJLID.Add(Convert.ToInt32(str));
} //问题就处在这里，我想把getJLID遍历后插入tYWXX表的JLID字段中，但这样写只能取出最后一个，不知道要怎么写？
string sql = sql = string.Format("insert into tYWXX(BM,JLID,XYWM,JYWM,WJDX,WJKZM,UID,YWLJ,SCSJ,WJLB) values('" + TableNames[i] + "','" + getJLID[z] + "','" + xywm + "','" + GetFile[j].FileName + "','" + GetFile[j].FileSize + "','" + GetFile[j].Suffix + "',10000,'/2009/0000/','" + time.ToString() + "',1)"); //“z”索引不能获取，放入for循环中，插入很多重复的
SqlHelper.ExecuteNonQuery(dbConn, CommandType.Text, sql);
}
k += listSize[i];
}
}
private List<Files> GetFiles() //获取文件名，文件大小，文件后缀名
{
List<Files> listFiles = new List<Files>();
DirectoryInfo Dir = new DirectoryInfo("E:\\3万页");
try
{
foreach (FileInfo f in Dir.GetFiles("*.*"))
{
string strFileExtention = Path.GetExtension(f.ToString());
Files Files = new Files(f.ToString(), Convert.ToInt32(f.Length), strFileExtention);
listFiles.Add(Files);
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return listFiles;
}
...全文
请发表友善的回复…
发表回复
ludeli2004 2009-12-16
- 打赏
- 举报
up
chenkewu520 2009-12-16
- 打赏
- 举报
碰巧解决了，暂时没什么问题！
private void Insert()
{
List<int> getJLID = new List<int>();
List<Files> GetFile = GetFiles();
string strConn = "Data Source=localhost;DataBase=FH_GSZDY;User ID=sa;Password=";
SqlConnection dbConn = new SqlConnection(strConn);
int count = listSize.Count;
int k = 0;
for (int i = 0; i < count; i++)
{
string strSql = "select id from " + TableNames[i];
DataSet ds = SqlHelper.ExecuteDataset(dbConn, CommandType.Text, strSql);
DataTable dt = ds.Tables[0];
for (int z = 0; z < dt.Rows.Count; z++)
{
string str = dt.Rows[z][0] + "\n";
getJLID.Add(Convert.ToInt32(str));
}
for (int j = k; j < k+listSize[i]; j++)
{
string xywm = "sdafoigjfgjojwnd" + (j + 1);
string time = DateTime.Now.ToString();
string sql = string.Format("insert into tYWXX(BM,JLID,XYWM,JYWM,WJDX,WJKZM,UID,YWLJ,SCSJ,WJLB) values('" + TableNames[i] + "','" + getJLID[j] + "','" + xywm + "','" + GetFile[j].FileName + "','" + GetFile[j].FileSize + "','" + GetFile[j].Suffix + "',10000,'/2009/0000/','" + time.ToString() + "',1)");
SqlHelper.ExecuteNonQuery(dbConn, CommandType.Text, sql);
}
k += listSize[i];
}
}
chenkewu520 2009-12-16
- 打赏
- 举报
第一个循环是
private List<int> listSize = new List<int>(new int[] { 10, 179, 22, 20, 24, 21, 21, 30, 20, 1149 });
第二个循环是文件名，文件大小，文件后缀名
第三个循环是
private List<string> TableNames = new List<string>(new string[] { "u_DZDA", "u_JNJML", "u_KJJNJML", "u_JJWJ", "u_SBWJ", "u_CPWJ", "u_ZPJNJML", "u_ZPJHZL", "u_SXDA", "u_GDWJML" });
这些表的所有ID
private List<int> listSize = new List<int>(new int[] { 10, 179, 22, 20, 24, 21, 21, 30, 20, 1149 });
第二个循环是文件名，文件大小，文件后缀名
第三个循环是
private List<string> TableNames = new List<string>(new string[] { "u_DZDA", "u_JNJML", "u_KJJNJML", "u_JJWJ", "u_SBWJ", "u_CPWJ", "u_ZPJNJML", "u_ZPJHZL", "u_SXDA", "u_GDWJML" });
这些表的所有ID
fyanglexh 2009-12-16
- 打赏
- 举报
for (int i = 0; i < count; i++)
{
for (int j = k; j < k+listSize[i]; j++)
{
string xywm = "sdafoigjfgjojwnd" +(j+1);
string time = DateTime.Now.ToString();
string strSql = "select id from " + TableNames[i];
DataSet ds = SqlHelper.ExecuteDataset(dbConn, CommandType.Text, strSql);
DataTable dt = ds.Tables[0];
for (int z = 0; z < dt.Rows.Count; z++)
{
string str = dt.Rows[z][0] + "\n";
getJLID.Add(Convert.ToInt32(str));
string sql = sql = string.Format("insert into tYWXX(BM,JLID,XYWM,JYWM,WJDX,WJKZM,UID,YWLJ,SCSJ,WJLB) values('" + TableNames[i] + "','" + getJLID[z] + "','" + xywm + "','" + GetFile[j].FileName + "','" + GetFile[j].FileSize + "','" + GetFile[j].Suffix + "',10000,'/2009/0000/','" + time.ToString() + "',1)"); //把添加语句写到循环里，会出现重复！然后就不知道怎么写了!
SqlHelper.ExecuteNonQuery(dbConn, CommandType.Text, sql);
}
}
k += listSize[i];
}
你这里嵌套了三个循环。那是为了表达什么意思呢？能逐个说一下吗？
fyanglexh 2009-12-16
- 打赏
- 举报
我也被你的循环搞晕了。。。
liherun 2009-12-16
- 打赏
- 举报
up
chenkewu520 2009-12-16
- 打赏
- 举报
不能把插入语句放在循环里吧？不然三重循环后就会插入很多重复的数据？
chenkewu520 2009-12-16
- 打赏
- 举报
是挺乱的，这个放在for里面，还是会插入很多重复的记录啊！
yanm7788 2009-12-16
- 打赏
- 举报
string str = dt.Rows[z][0] + "\n";
int whatyouwant Convert.ToInt32(str);
string sql = sql = string.Format("insert into tYWXX(BM,JLID,XYWM,JYWM,WJDX,WJKZM,UID,YWLJ,SCSJ,WJLB) values('" + TableNames[i] + "','" + whatyouwant + "','" + xywm + "','" + GetFile[j].FileName + "','" + GetFile[j].FileSize + "','" + GetFile[j].Suffix + "',10000,'/2009/0000/','" + time.ToString() + "',1)"); //把添加语句写到循环里，会出现重复！然后就不知道怎么写了!
SqlHelper.ExecuteNonQuery(dbConn, CommandType.Text, sql);
这样不就行了？你可以加入getJLID，在外面写个for循环一样可以插进去。。呵呵，感觉你的代码挺乱。
平生我自如 2009-12-16
- 打赏
- 举报
帮顶
chenkewu520 2009-12-16
- 打赏
- 举报
private void Insert()
{
List<int> getJLID = new List<int>();
List<Files> GetFile = GetFiles();
string strConn = "Data Source=localhost;DataBase=FH_GSZDY;User ID=sa;Password=";
SqlConnection dbConn = new SqlConnection(strConn);
int count = listSize.Count;
int k = 0;
for (int i = 0; i < count; i++)
{
for (int j = k; j < k+listSize[i]; j++)
{
string xywm = "sdafoigjfgjojwnd" +(j+1);
string time = DateTime.Now.ToString();
string strSql = "select id from " + TableNames[i];
DataSet ds = SqlHelper.ExecuteDataset(dbConn, CommandType.Text, strSql);
DataTable dt = ds.Tables[0];
for (int z = 0; z < dt.Rows.Count; z++)
{
string str = dt.Rows[z][0] + "\n";
getJLID.Add(Convert.ToInt32(str));
string sql = sql = string.Format("insert into tYWXX(BM,JLID,XYWM,JYWM,WJDX,WJKZM,UID,YWLJ,SCSJ,WJLB) values('" + TableNames[i] + "','" + getJLID[z] + "','" + xywm + "','" + GetFile[j].FileName + "','" + GetFile[j].FileSize + "','" + GetFile[j].Suffix + "',10000,'/2009/0000/','" + time.ToString() + "',1)"); //把添加语句写到循环里，会出现重复！然后就不知道怎么写了!
SqlHelper.ExecuteNonQuery(dbConn, CommandType.Text, sql);
}
}
k += listSize[i];
}
}
