public static void InsertDataIntoTarget1(object o) { CommonFunction.WriteErrorLog("" + DateTime.Now.ToString() + "进行数据导入....详细信息如下"); CommonFunction cf = new CommonFunction(); cf.WaitingThreadStart(); try { DataSet ds = (DataSet)o; //foreach (DataTable dt in ds.Tables) //{ InsertDataIntoTarget(ds); //} } catch (Exception ex) { CommonFunction.WriteErrorLog(ex.ToString()); } cf.WaitingThreadStop(); string mess = ""+DateTime.Now.ToString()+"数据导出完成\n导出成功" + okcount.ToString() + "条; \n 导出失败" + falsecount.ToString() + "条; \n 详情信息查看Errorlog.txt!"; CommonFunction.WriteErrorLog(mess + "\n"); ToolFunction.uctlMessageBox.frmDisappearShow(mess); }
public static void InsertDataIntoTarget1(object o) { CommonFunction cf = new CommonFunction(); cf.WaitingThreadStart(); try {DataSet ds = (DataSet)o; foreach (DataTable dt in ds.Tables) { InsertDataIntoTarget(dt); } } catch (Exception) { throw; } cf.WaitingThreadStop(); }
/// <summary> /// 检查: /// 1.所录入的目标表在目标库是否存在, /// 2.录入的列是否存在 /// 3.是否录入了不存在的字段 /// </summary> /// <param name="dttemp">本地录入的临时表</param> /// <param name="dttarget">目标库的真是表</param> public void CheckTargetDict(DataTable dttemp, DataTable dttarget) { try { CommonFunction cf = new CommonFunction(); cf.WaitingThreadStart(); if (dttarget == null) { needfix = true; CommonFunction.WriteErrorLog("目标表:" + gridView1.GetDataRow(gridView1.FocusedRowHandle)["TABLE_NAME"].ToString() + "不存在!\n"); } DataTable dttemp1 = GetTempColumns(dttemp); if (dttemp1.Columns.Count == 0) { needfix = true; CommonFunction.WriteErrorLog("目标表:" + gridView1.GetDataRow(gridView1.FocusedRowHandle)["TABLE_NAME"].ToString() + "未录入字段!\n"); } else { //判断多余字段 foreach (DataColumn dc in dttemp1.Columns) { if (!dttarget.Columns.Contains(dc.ColumnName)) { needfix = true; CommonFunction.WriteErrorLog("目标表:" + gridView1.GetDataRow(gridView1.FocusedRowHandle)["TABLE_NAME"].ToString() + "不存在名为:【" + dc.ColumnName + "】的字段!\n"); } } //判断缺少字段 foreach (DataColumn dc in dttarget.Columns) { if (!dttemp1.Columns.Contains(dc.ColumnName)) { needfix = true; CommonFunction.WriteErrorLog("字段:【" + dc.ColumnName + "】未录入目标表:" + gridView1.GetDataRow(gridView1.FocusedRowHandle)["TABLE_NAME"].ToString() + "\n"); } } } cf.WaitingThreadStop(); if (needfix) { MessageBox.Show("字段录入有误请核对,详情参照错误日志ErrorLog.txt!"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 2015-01-14 �⺣�� ��dbf�ļ��������� /// </summary> /// <param name="dt">����Դ</param> /// <param name="strFileName">�ļ�·��</param> /// <returns>�����Ƿ�ɹ�</returns> public bool InsertDBF(DataTable dt, string strFileName) { try { string strColumn = ReColumnStr(strFileName);//���Ҫ������ֶ��� DataTable dtColumn = ReadDBF(strFileName);//���Ҫ������ֶ��� int successcount = 0,falsecount = 0; CommonFunction cf = new CommonFunction(); cf.WaitingThreadStart(); foreach (DataRow dr in dt.Rows) { string strsql = "insert into TableName( ";//sql�Ŀ�ͷ strsql += strColumn; strsql += ") values ("; //strsql += ReturnStrValues(dr, dtColumn); strsql += ReturnStrValues(dr); strsql += ")"; if (WriteDBF(strFileName, strsql)) { successcount++; } else { falsecount++; } } cf.WaitingThreadStop(); string mess = "" + DateTime.Now.ToString() + "���ݵ������\n�����ɹ�" + successcount.ToString() + "���� \n ����ʧ��" + falsecount.ToString() + "���� \n ������Ϣ�鿴Errorlog.txt!"; CommonFunction.WriteError(mess + "\n"); ToolFunction.uctlMessageBox.frmDisappearShow(mess); } catch (Exception ex) { CommonFunction.WriteError(ex.Message); } return true; }