private bool InsertDataFile(SQLOutboundChanel chn, string fname, DataSet ds, List <string> idList, int count) { int i = 1; foreach (DataTable dt in ds.Tables) { foreach (DataRow dr in dt.Rows) { chn.OperationName = fname; OleDbCommand cmd = Program.db.GetCommand(); MapingHelper.BuildInsertCmd(chn, dr, cmd); cmd.CommandType = CommandType.Text; Program.Log.Write(string.Format("Insert data into file. {0}/{1}", i++, count)); if (!Program.db.ExecCommand(cmd)) { return(false); } string id = Convert.ToString(dr["data_id"]); idList.Add(id); } } return(true); }
/// <summary> /// Write logical: /// 1.check PK field whether is existed or not /// 2.insert new record where PK is not exist /// 3.update record when PK is exist /// 4.delete record TODO:??? /// /// Insert logical: /// 1.select empty DataSet from 3rd database /// 2.insert new record /// 3.SqlAdapter.update /// </summary> /// <param name="ds"></param> /// <param name="ch"></param> /// <returns></returns> private bool WriteTable(DataSet ds, SQLOutboundChanel ch) { //OleDbCommand cmd = Program.db.GetCommand(); // ------ 20070419 ------ string[] data_Id = new string[1]; foreach (DataRow dr in ds.Tables[0].Rows) { try { OleDbCommand cmd = Program.db.GetCommand(); if (!RecordIsExist(dr, ch)) { MapingHelper.BuildInsertCmd(ch, dr, cmd); } else { MapingHelper.BuildUpdateCmd(ch, dr, cmd); } cmd.CommandType = CommandType.Text; if (Program.db.ExecCommand(cmd)) { data_Id[0] = Convert.ToString(dr["data_id"]); OnDataDischarge(data_Id); //TestCase.OnDataDischarge(data_Id); //DEBUG } } catch (Exception Ex) { Program.Log.Write(Ex); Program.Log.Write(LogType.Info, Program.db.ConnectionString); if (!ch.IgnoreDBException) { return(false); } } } return(true); // ---------------------- //try //{ // string[] data_Id =new string[1]; // foreach (DataRow dr in ds.Tables[0].Rows) // { // if (!RecordIsExist(dr, ch)) // MapingHelper.BuildInsertCmd(ch, dr, cmd); // else // MapingHelper.BuildUpdateCmd(ch, dr, cmd); // cmd.CommandType = CommandType.Text; // if (Program.db.ExecCommand(cmd)) // { // data_Id[0] = Convert.ToString(dr["data_id"]); // OnDataDischarge(data_Id); // //TestCase.OnDataDischarge(data_Id); //DEBUG // } // } // return true; //} //catch(Exception Ex) //{ // Program.Log.Write(Ex); // return false; //} }