/// <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);
}
