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);
}
/// <summary>
/// 2015-01-14 吴海龙 向dbf文件插入数据
/// </summary>
/// <param name="dt">数据源</param>
/// <param name="strFileName">文件路径</param>
/// <returns>插入是否成功</returns>
public bool InsertDBF(DataTable p_dtSource, string p_strTempletFileFullName)
{
try
{
string _strFileName = p_strTempletFileFullName.Substring(p_strTempletFileFullName.LastIndexOf('\\') + 1);
string _strTarget = CommonFunction.GetConfig("DbfOutPutDir") + "\\" + _strFileName;
CommonFunction.CopyFile(p_strTempletFileFullName, _strTarget,false);
string strColumn = GetColumnStr(_strTarget);//存放要插入的字段名
DataTable dtColumn = ReadDBF(_strTarget);//存放要插入的字段名
CommonFunction cf = new CommonFunction();
foreach (DataRow dr in p_dtSource.Rows)
{
string strsql = "insert into TableName( ";//sql的开头
strsql += strColumn;
strsql += ") values (";
strsql += ReturnStrValues(dr, dtColumn);
//strsql += ReturnStrValues(dr, strColumn);
strsql += ")";
if (WriteDBF(_strTarget, strsql))
{
PublicVar.m_nSuccessCount++;
RemoteMessage.SendMessage("插入成功...");
}
else
{
PublicVar.m_nFalseCount++;
RemoteMessage.SendMessage("插入失败...");
}
}
//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;
}
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;
}
public void Export()
{
CommonFunction cf = new CommonFunction();
string dbfpath = PublicProperty.ExportParam[0].ToString();
DataTable dt = (DataTable)PublicProperty.ExportParam[1];
InsertDBF(dt, dbfpath);
}
