/// <summary>
///
/// </summary>
private void UpdateQRCode2AliCloud()
{
//取得所有的缓存数据
DataTable dtAllData = new DataTable();
dtAllData = AccessHelper.ExecuteDataTable(connAccess, "SELECT [FCodeID],[FQRCode], [FBillNoEntryId] FROM T_QRCODE");
//得到唯一的单据行号
string[] DistinctBillNo = GetDistinctBillNo(dtAllData, "FBillNoEntryId").Split(';');
//对每一行进行处理
foreach (string billNo in DistinctBillNo)
{
//过滤只留下一行数据
DataTable dtFilteredData = FilterData(dtAllData, "FBillNoEntryId = '" + billNo + "'");
//生成插入语句
sql = BuildDetailSql(dtFilteredData);
//写入云
int ret = SqlHelper.ExecuteNonQuery(connALiClouds, sql);
//如果返回值等于一行数据的个数，表示该行数据已经到云
if (ret == dtFilteredData.Rows.Count)
{
// 更新主表中已扫个数
string billNoEntryID = dtFilteredData.Rows[0]["FBillNoEntryId"].ToString();
int retUpdateQty = UpdateCloudQty(billNoEntryID, ret);
//更新成功
if (retUpdateQty > 0)
{
//删除ACCESS数据库中的该行数据
sql = string.Format("Delete from t_QRCode where FBillNoEntryId = '{0}'", billNoEntryID);
int retInt = AccessHelper.ExecuteNonQuery(connAccess, sql);
if (retInt == ret)
{
//删除成功，则是上传成功
CustomDesktopAlert.H2("数据上传成功！");
}
else
{
//删除失败，则是上传失败
CustomDesktopAlert.H2("数据上传失败！");
}
}
else
{
//更新个数失败
CustomDesktopAlert.H2("更新主表失败！");
}
}
else
{
CustomDesktopAlert.H2("保存数据出错！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string dbPath = Server.MapPath("/App_Data/nq.mdb");
DataTable dt = AccessHelper.ExecuteDataTable(dbPath, "select * from comclass");
// Response.Write(dt.Rows.Count);
PageModel pm = AccessHelper.Paging(dbPath, "*", "comclass", "", "idx", "desc", 3, 3);
foreach (DataRow dr in pm.DataTable.Rows)
{
Response.Write(dr["idx"].ToString() + "<br/>");
}
}
/// <summary>
/// 根据输入值，返回相应的语句
/// </summary>
/// <param name="inputTxt"></param>
/// <returns></returns>
static string GetResponse(string inputTxt)
{
string content = null;
DataRow dataRow = null;
//string dbconnection = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=MyMSN.mdb";
//这里的CHARINDEX换成INSTR
//string sql = "SELECT CategoryID FROM RobotKeywords WHERE (INSTR( '" + Regex.Replace(inputTxt, "'", "''") + "',KeywordContent) <> 0)";
string sql = "SELECT top 1 * FROM RobotKeywords WHERE KeywordContent like '%" + inputTxt + "%'";
DataTable dt = AccessHelper.ExecuteDataTable(sql);
if (dt.Rows.Count > 0)
{
dataRow = dt.Rows[0];
content = dataRow["CategoryID"].ToString();
}
if (content != null && content != "")
{
dt = AccessHelper.ExecuteDataTable("SELECT TOP 1 * FROM RobotResponses WHERE (CategoryID = " + content + ") ORDER BY [ResponseID]");
if (dt.Rows.Count > 0)
{
dataRow = dt.Rows[0];
content = dataRow["ResponseContent"].ToString();
}
}
if (content == null || content == "")
{
dt = AccessHelper.ExecuteDataTable("SELECT TOP 1 * FROM RobotResponses WHERE (CategoryID = 5) ORDER BY [ResponseID]");
if (dt.Rows.Count > 0)
{
dataRow = dt.Rows[0];
content = dataRow["ResponseContent"].ToString();
}
}
return(content);
}
//不带参数，查找所有日常工作
public static DataSet SearchDailyWork()
{
DataSet a = new DataSet();
DataTable tb1, tb2, tb3 = new DataTable();
try
{
tb1 = AccessHelper.ExecuteDataTable(CommandType.Text, "select * from WeekRule");//第一个
a.Tables.Add(tb1);
tb2 = AccessHelper.ExecuteDataTable(CommandType.Text, "select * from MonthRule"); //第二个
a.Tables.Add(tb2);
tb3 = AccessHelper.ExecuteDataTable(CommandType.Text, "select * from YearRule"); //第三个
a.Tables.Add(tb3);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return(a);
}
/// <summary>
/// 返回DataTable对像
/// </summary>
/// <param name="commandText">SQL语句</param>
/// <returns></returns>
public static DataTable ExecuteDataTable(string commandText)
{
return(accessHelper.ExecuteDataTable(commandText));
}
