294 lines
16 KiB
C#
294 lines
16 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Data.Odbc;
|
|
using System.Drawing;
|
|
using System.Linq;
|
|
using System.Runtime.InteropServices;
|
|
using System.Text;
|
|
using System.Web;
|
|
using System.Windows.Forms;
|
|
using ZXing;
|
|
using ZXing.Common;
|
|
using ZXing.QrCode;
|
|
|
|
namespace DataUpdate
|
|
{
|
|
public partial class ScanAudit : Form
|
|
{
|
|
//调用API
|
|
[DllImport("user32.dll", CharSet = CharSet.Auto, ExactSpelling = true)]
|
|
public static extern IntPtr GetForegroundWindow(); //获得本窗体的句柄
|
|
[DllImport("user32.dll", EntryPoint = "SetForegroundWindow")]
|
|
public static extern bool SetForegroundWindow(IntPtr hWnd);//设置此窗体为活动窗体
|
|
//AppID(应用ID)
|
|
public string AppID = "wxcf4dbe1815d5d872";
|
|
EncodingOptions options = null;
|
|
BarcodeWriter writer = null;
|
|
string _type;
|
|
public string serverpartcode { get { return ConfigUrationValues("serverpartcode", "").Trim(); } }
|
|
public string shopcode { get { return ConfigUrationValues("shopcode", "").Trim(); } }
|
|
public string machinecode { get { return ConfigUrationValues("machinecode", "").Trim(); } }
|
|
public string ScanAuditURL { get { return ConfigUrationValues("ScanAuditURL", "http://syyw.eshangtech.com:8060/ScanUpdate/ScanAudit.html").Trim(); } }
|
|
public ScanAudit(string[] type)
|
|
{
|
|
InitializeComponent();
|
|
_type = type[0];
|
|
QRCodeAudit();
|
|
}
|
|
private void MainTop_Tick(object sender, EventArgs e)
|
|
{
|
|
if (Handle != GetForegroundWindow()) //持续使该窗体置为最前,屏蔽该行则单次置顶
|
|
{
|
|
SetForegroundWindow(Handle);
|
|
}
|
|
}
|
|
private void QRCodeAudit()
|
|
{
|
|
switch (ConfigUrationValues("ScanAuditURL", "http://syyw.eshangtech.com:8060/ScanUpdate/ScanAudit.html"))
|
|
{
|
|
case "http://syyw.eshangtech.com:8060/ScanUpdate/ScanAudit.html":
|
|
AppID = "wx858626d07d286094";
|
|
lblProvince.Text = "当前上传省份：四川";
|
|
break;
|
|
case "http://cloud.eshangtech.com:8000/ScanUpdate/ScanAudit.html":
|
|
AppID = "wx85e69a5fb601be16";
|
|
lblProvince.Text = "当前上传省份：浙江";
|
|
break;
|
|
case "http://cloud.eshangtech.com:8000/ScanUpdate_GZ/ScanAudit.html":
|
|
AppID = "wxeba135b691515795";
|
|
lblProvince.Text = "当前上传省份：贵州";
|
|
break;
|
|
case "http://cloud.eshangtech.com:8000/ScanUpdate_Test/ScanAudit.html":
|
|
AppID = "wxcf4dbe1815d5d872";
|
|
lblProvince.Text = "当前上传省份：驿商测试";
|
|
break;
|
|
case "http://113.16.255.162:6060/ScanUpdate/ScanAudit.html":
|
|
AppID = "wx84783c575daaea05";
|
|
lblProvince.Text = "当前上传省份：广西恒信";
|
|
break;
|
|
case "http://60.191.61.27:8080/ScanUpdate/ScanAudit.html":
|
|
AppID = "wxcafd073c85194384";
|
|
lblProvince.Text = "当前上传省份：广西交投";
|
|
break;
|
|
case "http://47.92.38.105:6060/ScanUpdate/ScanAudit.html":
|
|
AppID = "wx201f8336954afc75";
|
|
lblProvince.Text = "当前上传省份：甘肃";
|
|
break;
|
|
case "http://220.177.42.231:6060/ScanUpdate/ScanAudit.html":
|
|
AppID = "wxc95cc47b53ccf30b";
|
|
lblProvince.Text = "当前上传省份：江西";
|
|
break;
|
|
default:
|
|
lblProvince.Text = "当前上传省份：";
|
|
break;
|
|
}
|
|
string _cashpay = "0";
|
|
PaymentMain paymentMain = new PaymentMain();
|
|
paymentMain.ShowDialog();
|
|
if (paymentMain.DialogResult == DialogResult.OK)
|
|
{
|
|
_cashpay = paymentMain.strpay;
|
|
string _selectsql = "select max(endaccount_startdate) from t_endaccount " +
|
|
"where serverpartcode ='" + serverpartcode + "' and shopcode ='" +
|
|
shopcode + "' and machinecode ='" + machinecode +
|
|
"' and endaccount_date is null and endaccount_startdate < now()";
|
|
DataTable _EndAccountTable = DBHelper.ExecuteDataSet(_selectsql).Tables[0];
|
|
if (_EndAccountTable.Rows.Count > 0)
|
|
{
|
|
if (_EndAccountTable.Rows[0][0].ToString() == "")
|
|
{
|
|
MessageBox.Show("请先登陆收银系统！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
|
Environment.Exit(0);
|
|
}
|
|
_selectsql = "select count(distinct selldata_date) as ticketcount,isnull(sum(sellcount), 0) as totalcount," +
|
|
"isnull(sum(factamount), 0) as totalsellamount,isnull(sum(offprice), 0) as totaloffamount,isnull(sum(cash), 0) as cash," +
|
|
"isnull(sum(creditcard), 0) as creditcard,isnull(sum(ticketbill), 0) as ticketbill,isnull(sum(vipperson), 0) as vipperson ," +
|
|
"isnull(sum(costbill), 0) as costbill,isnull(sum(otherpay), 0) as otherpay from t_selldata where serverpartcode ='" +
|
|
serverpartcode + "' and shopcode ='" + shopcode + "' and machinecode ='" + machinecode +
|
|
"' and selldata_date between ( select max(endaccount_startdate) from t_endaccount where serverpartcode ='" +
|
|
serverpartcode + "' and shopcode ='" + shopcode + "' and machinecode ='" + machinecode +
|
|
"' and endaccount_date is null and endaccount_startdate < now() ) and now()";
|
|
DataTable _CashierAuditTable = DBHelper.ExecuteDataSet(_selectsql).Tables[0];
|
|
if (_CashierAuditTable.Rows.Count > 0)
|
|
{
|
|
string _startdate = _EndAccountTable.Rows[0][0].ToString();
|
|
string _enddate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
|
|
decimal _MaxID = 0;
|
|
decimal _ticketcount = decimal.Parse(_CashierAuditTable.Rows[0]["ticketcount"].ToString());
|
|
decimal _totalcount = decimal.Parse(_CashierAuditTable.Rows[0]["totalcount"].ToString());
|
|
decimal _totalsellamount = decimal.Parse(_CashierAuditTable.Rows[0]["totalsellamount"].ToString());
|
|
decimal _totaloffamount = decimal.Parse(_CashierAuditTable.Rows[0]["totaloffamount"].ToString());
|
|
decimal _cash = decimal.Parse(_CashierAuditTable.Rows[0]["cash"].ToString());
|
|
decimal _creditcard = decimal.Parse(_CashierAuditTable.Rows[0]["creditcard"].ToString());
|
|
decimal _ticketbill = decimal.Parse(_CashierAuditTable.Rows[0]["ticketbill"].ToString());
|
|
decimal _vipperson = decimal.Parse(_CashierAuditTable.Rows[0]["vipperson"].ToString());
|
|
decimal _costbill = decimal.Parse(_CashierAuditTable.Rows[0]["costbill"].ToString());
|
|
decimal _otherpay = decimal.Parse(_CashierAuditTable.Rows[0]["otherpay"].ToString());
|
|
try
|
|
{
|
|
_MaxID = decimal.Parse(DBHelper.ExecuteDataSet("select max(endaccount_id) from t_endaccount").Tables[0].Rows[0][0].ToString());
|
|
}
|
|
catch
|
|
{
|
|
_MaxID = 0;
|
|
}
|
|
string _insertsql = "insert into t_endaccount (endaccount_id, endaccount_startdate, endaccount_date, " +
|
|
"serverpartcode, shopcode, machinecode, endpersoncode, ticketcount, totalcount, totalsellamount, " +
|
|
"totaloffamount, cash, creditcard, ticketbill, vipperson, costbill, otherpay, cashpay, flag) values (" +
|
|
(_MaxID + 1) + ",datetime('" + _startdate + "'),datetime('" + _enddate + "'),'" + serverpartcode +
|
|
"','" + shopcode + "','" + machinecode + "','S9999'," + _ticketcount + "," + _totalcount +
|
|
"," + _totalsellamount + "," + _totaloffamount + "," + _cash + "," + _creditcard + "," + _ticketbill +
|
|
"," + _vipperson + "," + _costbill + "," + _otherpay + "," + (_cashpay == "" ? "0" : _cashpay) + ",5)";
|
|
try
|
|
{
|
|
DBHelper.ExcuteSql(_insertsql);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MessageBox.Show("稽核信息生成失败，请重试！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
|
Environment.Exit(0);
|
|
}
|
|
_startdate = DateTime.Parse(_startdate).ToString("yyyyMMddHHmmss");
|
|
_enddate = DateTime.Parse(_enddate).ToString("yyyyMMddHHmmss");
|
|
string strScanAudit = (_MaxID + 1).ToString() + "|" + _startdate + "|" + _enddate + "|" + serverpartcode +
|
|
"|" + shopcode + "|" + machinecode + "|S9999|" + _ticketcount.ToString("F2") + "|" + _totalcount.ToString("F2") +
|
|
"|" + _totalsellamount.ToString("F2") + "|" + _totaloffamount.ToString("F2") + "|" + _cash.ToString("F2") +
|
|
"|" + _creditcard.ToString("F2") + "|" + _ticketbill.ToString("F2") + "|" + _vipperson.ToString("F2") +
|
|
"|" + _costbill.ToString("F2") + "|" + _otherpay.ToString("F2") + "|" + (_cashpay == "" ? "0" : _cashpay) + "|5";
|
|
strScanAudit = strScanAudit.Replace(".00", "");
|
|
//string text = "ScanAudit=" + HttpUtility.UrlEncode(strScanAudit) + "&Length=" + strScanAudit.Length +
|
|
// "&RowCount=1&RecordCount=1&CheckCode=" + CreateMD5(strScanAudit) + "&ScanIndex=1&ScanCount=1";
|
|
string strurl = "http://mall.eshangtech.com/getcode.html?appid=" + AppID + "&scope=snsapi_base&state=" +
|
|
HttpUtility.UrlEncode("ScanAudit=" + HttpUtility.UrlEncode(strScanAudit) + "&Length=" + strScanAudit.Length +
|
|
"&RowCount=1&RecordCount=1&CheckCode=" + CreateMD5(strScanAudit) + "&ScanIndex=1&ScanCount=1") +
|
|
"&redirect_uri=" + HttpUtility.UrlEncode(ScanAuditURL);
|
|
options = new QrCodeEncodingOptions
|
|
{
|
|
DisableECI = true,
|
|
CharacterSet = "UTF-8",
|
|
Width = picQRCode.Height,
|
|
Height = picQRCode.Width
|
|
};
|
|
writer = new BarcodeWriter();
|
|
writer.Format = BarcodeFormat.QR_CODE;
|
|
writer.Options = options;
|
|
Bitmap bitmap = writer.Write(strurl);
|
|
picQRCode.Image = bitmap;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
#region 方法 --> 获取配置信息
|
|
/// <summary>
|
|
/// 获取配置信息
|
|
/// </summary>
|
|
/// <param name="ConfigUrationName">配置名称</param>
|
|
/// <param name="defaultValue">无配置信息时默认值</param>
|
|
/// <returns></returns>
|
|
public static string ConfigUrationValues(string ConfigUrationName, string defaultValue)
|
|
{
|
|
string strSQL = "select configuration_name,configuration_values from dba.t_configuration where lower(configuration_name) = lcase('" + ConfigUrationName + "')";
|
|
string strValues = "";
|
|
try
|
|
{
|
|
using (DataTable _DataTable = ExecuteDataSet(strSQL).Tables[0])
|
|
{
|
|
if (_DataTable.Rows.Count > 0)
|
|
{
|
|
foreach (DataRow row in _DataTable.Rows)
|
|
{
|
|
if (row["configuration_name"].ToString().ToLower() == ConfigUrationName.ToLower())
|
|
{
|
|
strValues = row["configuration_values"].ToString();
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
strValues = ConfigHelper.Win32API.INIGetStringValue(Environment.CurrentDirectory + "\\setup.ini", "DBCONECT", ConfigUrationName, defaultValue);
|
|
if (strValues == "")
|
|
strValues = ConfigHelper.Win32API.INIGetStringValue(Environment.CurrentDirectory + "\\set.ini", "DBCONECT", ConfigUrationName, defaultValue);
|
|
}
|
|
}
|
|
}
|
|
catch
|
|
{
|
|
strValues = ConfigHelper.Win32API.INIGetStringValue(Environment.CurrentDirectory + "\\setup.ini", "DBCONECT", ConfigUrationName, defaultValue);
|
|
if (strValues == "")
|
|
strValues = ConfigHelper.Win32API.INIGetStringValue(Environment.CurrentDirectory + "\\set.ini", "DBCONECT", ConfigUrationName, defaultValue);
|
|
}
|
|
return strValues;
|
|
}
|
|
#endregion
|
|
|
|
/// <summary>
|
|
/// 本地数据库连接
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static OdbcConnection AnyWhereConn()
|
|
{
|
|
string strConn = "DSN=anysql1;UID=dba;PWD=sql;";
|
|
OdbcConnection Conany = new OdbcConnection(strConn);
|
|
return Conany;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 本地执行SQL语句并返回DataSet
|
|
/// </summary>
|
|
/// <param name="SelectSql">SQL语句</param>
|
|
/// <returns></returns>
|
|
public static DataSet ExecuteDataSet(string SelectSql)
|
|
{
|
|
using (OdbcConnection conany = AnyWhereConn())
|
|
{
|
|
DataSet _DataSet = new DataSet();
|
|
try
|
|
{
|
|
OdbcDataAdapter _OdbcDataAdapter = new OdbcDataAdapter(SelectSql, conany);
|
|
_OdbcDataAdapter.Fill(_DataSet);
|
|
return _DataSet;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new Exception(ex.Message);
|
|
}
|
|
}
|
|
}
|
|
#region 创建md5 16位大写加密
|
|
public static string CreateMD5(string text)
|
|
{
|
|
var md5 = new System.Security.Cryptography.MD5CryptoServiceProvider();
|
|
//换成utf8后对于中文加密也适用
|
|
byte[] output = md5.ComputeHash(System.Text.Encoding.UTF8.GetBytes(text));
|
|
string pass2md5 = BitConverter.ToString(output, 4, 8).Replace("-", "");
|
|
//pass2md5 = pass2md5.ToUpper();
|
|
return pass2md5;
|
|
}
|
|
#endregion
|
|
|
|
private void btnClose_Click(object sender, EventArgs e)
|
|
{
|
|
Close();
|
|
}
|
|
|
|
private void ScanAudit_KeyDown(object sender, KeyEventArgs e)
|
|
{
|
|
if (e.KeyCode == Keys.Escape)
|
|
{
|
|
Close();
|
|
}
|
|
else if (e.KeyCode == Keys.F12)
|
|
{
|
|
ProvinceMain _MessageBox = new ProvinceMain(_type);
|
|
_MessageBox.ShowDialog();
|
|
if (_MessageBox.DialogResult == DialogResult.OK)
|
|
{
|
|
QRCodeAudit();
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|