110,536
社区成员
发帖
与我相关
我的任务
分享
private void Handle(DateTime date)
{
//SQLCreator sqlcreator=new SQLCreator();
OLEDBSQLCreator sqlcreator = new OLEDBSQLCreator();
string datestr = date.Month.ToString() + @"/" + date.Day.ToString() + @"/" + date.Year.ToString();
string sqlstr = @"select b." + "\"Date\"" + ",b." + "\"Time\"" + ",b.OrderNo,b.Price,a.CAmount,a.VAmount,a.AAmount,a.MAmount,a.QAmount,a.IAmount,a.DAmount,a.UAmount,a.YAmount,a.OAmount from paybkup.DB a left join ordbkup.DB b on a.OrderNo=b.OrderNo left join itembkup.DB c on a.OrderNo =c.OrderNo where b." + "\"Date\"" + "='" + datestr + "'" + " and c.MenuNo not in ('013001','013002','013003') and b.Price!=0";
StringBuilder sb = new StringBuilder();
using (IDataReader dr =sqlcreator.ExcuteDataReader(sqlstr,configurator.DataBasePath,CommandType.Text))
{
while (dr.Read())
{
sb.Append(configurator.StoreCode+"\r");
sb.Append(configurator.TillID + "\r");
sb.Append(dr[0].ToString() + "\r");
sb.Append(dr[1].ToString() + "\r");
sb.Append("S" + dr[2].ToString().Substring(3) + "\r");
sb.Append(configurator.Plu + "\r");
sb.Append("\r");
sb.Append(dr[4].ToString() + "\r");
sb.Append(dr[5].ToString() + "\r");
sb.Append("0" + "\r");
sb.Append((int.Parse(dr[6].ToString()) + int.Parse(dr[7].ToString()) + int.Parse(dr[8].ToString()) + int.Parse(dr[9].ToString()) + int.Parse(dr[10].ToString()) + int.Parse(dr[11].ToString()) + int.Parse(dr[12].ToString()) + int.Parse(dr[13].ToString())).ToString() + "\r");
sb.Append("0" + "\r");
sb.Append(dr[3].ToString()+System.Environment.NewLine);
}
private bool CreateConnection(string DataBasePath)
{
bool Flags=false;
string connStr = @"Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir="+DataBasePath+";Dbq="+DataBasePath+";CollatingSequence=ASCII;PWD=;";
//string connStr = @"Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir="+DataBasePath+";Dbq="+DataBasePath+";CollatingSequence=ASCII;PWD=;";
//string connStr = @"Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended Properties='DSN=Paradox;DBQ=C:\myDb;DefaultDir="+DataBasePath+";DriverId=538;FIL=Paradox 7.X;MaxBufferSize=2048;PageTimeout=600;';Initial Catalog="+DataBasePath+";";
conn.ConnectionString = connStr;
try
{
conn.Open();
Flags = true;
}
catch (Exception ex)
{
throw ex;
}
return Flags;
}
/