/// <summary> /// 指定日期,导出单日销售明细数据到DBF /// </summary> public int SalesDayDesignatetoDBF(string date) { int ret = 0; AccessDBF db = new AccessDBF(); DataTable dt = new DataTable(); try { string sql = "select * from sales_xsxb where xsrq = '" + date + "'"; dt = DataAccess.GetDataTable("POSMySQL", sql); if (dt.Rows.Count == 0) { ret = 0; } else { ret = db.UpdateDBF(dt, GlobalParams.xbDesignateLocalPath); } } catch (Exception ex) { Log.WriteErrorLog(ex.Message, ex.Source, "指定日期,导出单日销售明细数据到DBF"); #if DEBUG throw ex; #endif } return(ret); }
/// <summary> /// 读取指定 DBF 文件的数据到指定的表 /// </summary> /// <param name="fileName"></param> /// <param name="dbName"></param> public void DBFtoDB(string fileName, string dbName) { AccessDBF db = new AccessDBF(); DataTable dt = new DataTable(); //从 dbf 文件读取数据 dt = db.RdeadDBFV3(fileName); //追加到指定的表 bool ret = db.WriteDataToDB(dt, dbName); if (!ret) { Log.WriteErrorLog("读取 DBF 文件数据失败", string.Format("DBFtoDB(string fileName, string dbName), fileName:{0}, dbName:{1}", fileName, dbName), ""); } }
/// <summary> /// 导出单次销售明细数据到DBF,>0 为插入成功 /// </summary> public int SalesBackupstoDBF() { int ret = 0; AccessDBF db = new AccessDBF(); DataTable dt = new DataTable(); try { string sql = "select * from sales_backups"; dt = DataAccess.GetDataTable("POSMySQL", sql); if (dt != null) { if (dt.Rows.Count > 0) { #region 加 999 校验行 int jysl = dt.Rows.Count; decimal ssje = 0; for (int i = 0; i < jysl; i++) { ssje += Convert.ToDecimal(dt.Rows[i]["ssje"]); } DataRow dr = dt.NewRow(); dr["tzm"] = "999"; dr["spbh"] = ""; dr["txm"] = ""; dr["jyj"] = 0; dr["jysl"] = jysl; dr["ssje"] = ssje; dr["xsrq"] = ""; dr["xssj"] = ""; dr["syybh"] = ""; dr["xph"] = ""; dr["jsfsbh"] = ""; dr["jh"] = ""; dr["yj"] = 0; dr["zjj"] = 0; dr["mcard"] = ""; dr["yhmx"] = 0; dr["jfmx"] = 0; dr["szbz"] = ""; dr["cxbh"] = ""; dr["xpxh"] = 0; dr["cxid"] = ""; dr["Baka"] = ""; dr["Bakb"] = 0; dt.Rows.Add(dr); #endregion //-1为未找到原始DBF文件;-2为插入异常;1为插入成功 ret = db.UpdateDBF(dt, GlobalParams.xsxbPath); } else { ret = -3; Log.WriteNormalLog("backups 表没有数据, 停止导出", "SalesBackupstoDBF()", ""); } } else { ret = -4; Log.WriteErrorLog("查询 backups 表返回 null", "", "SalesBackupstoDBF()"); } } catch (Exception ex) { ret = -5; Log.WriteErrorLog(ex.Message, ex.Source, "导出单次销售明细数据到DBF"); #if DEBUG throw ex; #endif } return(ret); }