public static List <MyFileInfo> Insert(ArrayList list) { List <MyFileInfo> duplicateList = new List <MyFileInfo>(); duplicateList.Clear(); string sql1 = "insert cd values (getdate())"; string sql2 = "delete from cd where cdid=(select max(cdID) from [cd])"; DBHelper.ExecuteSql(sql1); foreach (MyFileInfo fi in list) { //if(Validate(fi)) //if (!Check(fi)) //{ // //sql = "insert into files values('" + fi.FileName + "','1" + fi.Extension + "','" + fi.DirectoryName + "','" + fi.DirectoryName + "'," + fi.Length / 1024 / 1024 + ",'" + fi.LastAccessTime + "','" + fi.LastWriteTime + "')"; //} //else if (Check(fi)) { duplicateList.Add(fi); //DBHelper.ExecuteSql(sql2); } cdNo = DBHelper.ExecuteInsert_SP("dbo.sp_InsertCD", fi); } return(duplicateList); }
public static List <MyFileInfo> Insert(ArrayList list) { List <MyFileInfo> duplicateList = new List <MyFileInfo>(); foreach (MyFileInfo fi in list) { if (Check(fi)) { duplicateList.Add(fi); } cdNo = DBHelper.ExecuteInsert_SP("dbo.sp_InsertCD", fi); } return(duplicateList); }