东方仙盟-数据中心
数据库机器翻译
同步密码： 仙界界牌: 冥界界牌: 仙盟界牌:
| 编号 | 商品名称 | 生产批号 | 生产日期 | 有效日期 | 系列号 | 溯源 | 子商品 | 价格 | 单位 | 库存 | 最后操作时间 | 操作 | 删除 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 标签打印 | CyberWinPrintLabel | 单机版、独立打印工具 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getGoodsList(NameValueCollection obj){ try{ string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); // MessageBox.Show( db.Count().ToString()); db.where("cyber_id > 0"); DataTable dt = db.Select(); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"id\":"+"\""+dr["cyber_id"]+"\","; json=json+"\"name\":"+"\""+dr["name"]+"\","; json=json+"\"sort_id\":"+"\""+dr["sort_id"]+"\","; json=json+"\"unit\":"+"\""+dr["unit"]+"\","; json=json+"\"price\":"+"\""+dr["price"]+"\","; json=json+"\"goods_barcodes\":"+"\""+dr["goods_barcodes"]+"\","; json=json+"\"item_size\":"+"\""+dr["item_size"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string shop_addgoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("goods_barcodes", arr[0]); data_add.Add("unit", arr[1]); data_add.Add("price", arr[2]); data_add.Add("name", arr[3]); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.Add(data_add); return "添加成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 2 | 未来之窗插件中心 | CyberWinPlusCenter | 插件安装前必须安装此插件，已经安装的不需要 | using System;
using System.Collections.Generic;
using System.Text;
using System.Collections.Specialized;
using System.Windows.Forms;
using System.Data.SQLite;
using System.IO;
using System.Data;
using System.Data.Common;
using System.Net;
//引用数据库
//using CyberSnow.VB.NET.Data.Helper;
//
using System.Text.RegularExpressions;
using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData;
//故障排查系统查询
namespace CyberPHP_Dynamic
{
class APP
{
public string start(NameValueCollection obj){
string 车牌号码="";
NameValueCollection d=obj;
车牌号码 = d["carNO"];
string s="随机预安装插件";
return s;
}
public string InitRunTimeByAppName(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
string path = Application.StartupPath + "/CyberWinPHP/CyberPHP_Application/CyberWin_App/"+param;
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
return "初始化插件环境成功";
}
public string InitDownloadPath(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
string path =param;
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
return "初始化下载环境成功";
}
public string downloadFile(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
NameValueCollection obj_d = CyberPHPGetParm(param);
string path =obj_d["save_path"];
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
string filesace = path + "/"+ obj_d["save_name"];
string url=obj_d["url"];
WebClient webClient = new WebClient();
webClient.DownloadFile(url, filesace);
return "初始化下载环境成功";
}
public string InstallApp(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
NameValueCollection obj_d = CyberPHPGetParm(param);
string path = Application.StartupPath+"/CyberWinPHP/CyberPHP_Application/CyberWin_App/"+obj_d["appname"];
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
string filesace = path + "/"+ obj_d["save_name"];
string url=obj_d["url"];
WebClient webClient = new WebClient();
webClient.DownloadFile(url, filesace);
// string D= CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinNet.Http.CyberHttpDownload.OpenReadWithHttpsByInnerAgentALL(url, "","UTF-8", "GET");
UTF8toGBK(filesace);
// string strapp= System.Text.Encoding.GetEncoding("GB2312").GetString(System.Text.Encoding.GetEncoding("UTF-8").GetBytes(D));
// System.IO.File.WriteAllText(@filesace, strapp, Encoding.ASCII);
//https://51.onelink.ynwlzc.cn/o2o/index.php?g=TradeOpenSource&c=AppStoreClientCenter&a=intsallapp&app_id=90049
return "下载成功";
}
public void UTF8toGBK(string filePath)//UTF8 转 GBK
{
var buffer = File.ReadAllBytes(filePath);//读取文件内容
buffer = Encoding.Convert(Encoding.UTF8, Encoding.GetEncoding("gbk"), buffer);//转码
File.WriteAllBytes(filePath, buffer);//写入文件
}
public void GBKtoUTF8(string filePath)//GBK 转 UTF8
{
var buffer = File.ReadAllBytes(filePath);//读取文件内容
buffer = Encoding.Convert(Encoding.GetEncoding("gbk"), Encoding.UTF8, buffer);//转码
File.WriteAllBytes(filePath, buffer);//写入文件
toolStripStatusLabel1.Text = "转码成功";
}
//读取高级参数
public NameValueCollection CyberPHPGetParm(string input)
{
NameValueCollection d = new NameValueCollection();
string str = input;// "aaajsbbbjsccc";
string split_param = "CyberPHP->Param:";
string split_value = "CyberPHP->Value:";
string[] sArray = Regex.Split(str, split_param, RegexOptions.IgnoreCase);
int j = 0;
foreach (string i in sArray)
{
// Response.Write(i.ToString() + " "); string[] valueArrat = Regex.Split(i, split_value, RegexOptions.IgnoreCase); if (valueArrat.Length < 2) { d.Add(j.ToString(), valueArrat[0]); } else { d.Add(valueArrat[0], valueArrat[1]); } j = j + 1; } //输出结果： //aaa //bbb //ccc //ccc return d; } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } |
1970-01-01 08:00 | 翻译 | |||||||
| 9001 | 神思者身份证识别 | CyberWinConsumessz | 酒店管理、身份证 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.IO; // using System.Text.RegularExpressions; //using CardIO; namespace CyberPHP_Dynamic { class APP { public string start(NameValueCollection obj){ NameValueCollection d=obj; // write_log("CyberPHP_App","华视身份证","在线"); CyberWin_CardIO.CyberWinReader cio=new CyberWin_CardIO.CyberWinReader(); //Run cio.init(); string ret = cio.RunFile(); return ret;//"身份证读取"; } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 9002 | 大华电子秤同步 | DahauScale | 条码秤、通讯称 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getGoodsList(NameValueCollection obj){ try{ string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); // MessageBox.Show( db.Count().ToString()); db.where("cyber_id > 0"); DataTable dt = db.Select(); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"id\":"+"\""+dr["cyber_id"]+"\","; json=json+"\"name\":"+"\""+dr["name"]+"\","; json=json+"\"sort_id\":"+"\""+dr["sort_id"]+"\","; json=json+"\"unit\":"+"\""+dr["unit"]+"\","; json=json+"\"price\":"+"\""+dr["price"]+"\","; json=json+"\"goods_barcodes\":"+"\""+dr["goods_barcodes"]+"\","; json=json+"\"item_size\":"+"\""+dr["item_size"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string shop_addgoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("goods_barcodes", arr[0]); data_add.Add("unit", arr[1]); data_add.Add("price", arr[2]); data_add.Add("name", arr[3]); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.Add(data_add); return "添加成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 9003 | 华为路由器调试插件 | huawei | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getGoodsList(NameValueCollection obj){ try{ string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); // MessageBox.Show( db.Count().ToString()); db.where("cyber_id > 0"); DataTable dt = db.Select(); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"id\":"+"\""+dr["cyber_id"]+"\","; json=json+"\"name\":"+"\""+dr["name"]+"\","; json=json+"\"sort_id\":"+"\""+dr["sort_id"]+"\","; json=json+"\"unit\":"+"\""+dr["unit"]+"\","; json=json+"\"price\":"+"\""+dr["price"]+"\","; json=json+"\"goods_barcodes\":"+"\""+dr["goods_barcodes"]+"\","; json=json+"\"item_size\":"+"\""+dr["item_size"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string shop_addgoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("goods_barcodes", arr[0]); data_add.Add("unit", arr[1]); data_add.Add("price", arr[2]); data_add.Add("name", arr[3]); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.Add(data_add); return "添加成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | ||||||||
| 9004 | dd | dd | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getGoodsList(NameValueCollection obj){ try{ string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); // MessageBox.Show( db.Count().ToString()); db.where("cyber_id > 0"); DataTable dt = db.Select(); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"id\":"+"\""+dr["cyber_id"]+"\","; json=json+"\"name\":"+"\""+dr["name"]+"\","; json=json+"\"sort_id\":"+"\""+dr["sort_id"]+"\","; json=json+"\"unit\":"+"\""+dr["unit"]+"\","; json=json+"\"price\":"+"\""+dr["price"]+"\","; json=json+"\"goods_barcodes\":"+"\""+dr["goods_barcodes"]+"\","; json=json+"\"item_size\":"+"\""+dr["item_size"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string shop_addgoods(NameValueCollection obj) { //11 try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("goods_barcodes", arr[0]); data_add.Add("unit", arr[1]); data_add.Add("price", arr[2]); data_add.Add("name", arr[3]); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.Add(data_add); return "添加成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | ||||||||
| 90048 | 团餐机器设备管理 | CyberWinConsumeMachine | 团餐机器报表连接云端 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getGoodsList(NameValueCollection obj){ try{ string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); // MessageBox.Show( db.Count().ToString()); db.where("cyber_id > 0"); DataTable dt = db.Select(); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"id\":"+"\""+dr["cyber_id"]+"\","; json=json+"\"name\":"+"\""+dr["name"]+"\","; json=json+"\"sort_id\":"+"\""+dr["sort_id"]+"\","; json=json+"\"unit\":"+"\""+dr["unit"]+"\","; json=json+"\"price\":"+"\""+dr["price"]+"\","; json=json+"\"goods_barcodes\":"+"\""+dr["goods_barcodes"]+"\","; json=json+"\"item_size\":"+"\""+dr["item_size"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string shop_addgoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("goods_barcodes", arr[0]); data_add.Add("unit", arr[1]); data_add.Add("price", arr[2]); data_add.Add("name", arr[3]); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.Add(data_add); return "添加成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 90049 | 移动工单照片下载 | ChinamobileQJGMDownloadHelper | 移动工单照片下载核心 | using System;
using System.Collections.Generic;
using System.Text;
using System.Collections.Specialized;
using System.Windows.Forms;
using System.Data.SQLite;
using System.IO;
using System.Net;
using System.Data;
using System.Data.Common;
//引用数据库
//using CyberSnow.VB.NET.Data.Helper;
//
using System.Text.RegularExpressions;
using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData;
//故障排查系统查询
namespace CyberPHP_Dynamic
{
class APP
{
public string start(NameValueCollection obj){
string 车牌号码="";
NameValueCollection d=obj;
车牌号码 = d["carNO"];
string s="随机预安装插件";
return s;
}
public string InitRunTimeByAppName(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
string path = Application.StartupPath + "/CyberWinPHP/CyberPHP_Application/CyberWin_App/"+param;
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
return "初始化插件环境成功";
}
public string InitDownloadPath(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
string path =param;
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
return "初始化下载环境成功";
}
public string downloadFile(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
NameValueCollection obj_d = CyberPHPGetParm(param);
string path =obj_d["save_path"];
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
string filesace = path + "/"+ obj_d["save_name"];
string url=obj_d["url"];
WebClient webClient = new WebClient();
webClient.DownloadFile(url, filesace);
return "下载成功";
}
//读取高级参数
public NameValueCollection CyberPHPGetParm(string input)
{
NameValueCollection d = new NameValueCollection();
string str = input;// "aaajsbbbjsccc";
string split_param = "CyberPHP->Param:";
string split_value = "CyberPHP->Value:";
string[] sArray = Regex.Split(str, split_param, RegexOptions.IgnoreCase);
int j = 0;
foreach (string i in sArray)
{
// Response.Write(i.ToString() + " "); string[] valueArrat = Regex.Split(i, split_value, RegexOptions.IgnoreCase); if (valueArrat.Length < 2) { d.Add(j.ToString(), valueArrat[0]); } else { d.Add(valueArrat[0], valueArrat[1]); } j = j + 1; } //输出结果： //aaa //bbb //ccc //ccc return d; } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } |
1970-01-01 08:00 | 翻译 | |||||||
| 90050 | 自助机打印COM | CyberWinPrintWithCom | 自助机 | using System;
using System.Collections.Generic;
using System.Text;
using System.Collections.Specialized;
using System.Windows.Forms;
using System.Data.SQLite;
using System.IO;
using System.Net;
using System.IO.Ports;
using System.Drawing;
using System.Data;
using System.Data.Common;
//引用数据库
//using CyberSnow.VB.NET.Data.Helper;
//
using System.Text.RegularExpressions;
using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData;
//故障排查系统查询
namespace CyberPHP_Dynamic
{
class APP
{
private static SerialPort serialPort; //串口
public string start(NameValueCollection obj){
string 车牌号码="";
NameValueCollection d=obj;
车牌号码 = d["carNO"];
string s="随机预安装插件";
return s;
}
public string InitRunTimeByAppName(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
string path = Application.StartupPath + "/CyberWinPHP/CyberPHP_Application/CyberWin_App/"+param;
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
return "初始化插件环境成功";
}
public string InitDownloadPath(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
string path =param;
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
return "初始化下载环境成功";
}
public string print(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
NameValueCollection obj_d = CyberPHPGetParm(param);
string port =obj_d["port"];
string printerdata =obj_d["printerdata"];
initPort(port);
Write(printerdata);//发送字符串
return "打印成功";
}
public void initPort(string portName)
{
try
{
//
//串口初始化
//
serialPort = new SerialPort();
serialPort.PortName = portName;
serialPort.BaudRate = 9600;//波特率
serialPort.Parity = System.IO.Ports.Parity.Odd;//奇校验
serialPort.StopBits = System.IO.Ports.StopBits.One;//停止位
OpenPort();
}
catch
{
MessageBox.Show(e.ToString());
}
}
private void OpenPort()
{
if (null != serialPort)
{
try
{
if (!serialPort.IsOpen)
serialPort.Open();
}
catch
{
MessageBox.Show(e.ToString());
}
}
}
private void ClosePort()
{
try
{
if (serialPort.IsOpen)
serialPort.Close();
serialPort.Dispose();
}
catch
{
MessageBox.Show(e.ToString());
}
}
public void Write(byte[] data,int len)
{
try
{
serialPort.Write(data, 0, len);
}
catch(Exception e)
{
MessageBox.Show(e.ToString());
}
}
/// "); string[] valueArrat = Regex.Split(i, split_value, RegexOptions.IgnoreCase); if (valueArrat.Length < 2) { d.Add(j.ToString(), valueArrat[0]); } else { d.Add(valueArrat[0], valueArrat[1]); } j = j + 1; } //输出结果： //aaa //bbb //ccc //ccc return d; } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } |
1970-01-01 08:00 | 翻译 | |||||||
| 90051 | 纸币识别插件 | CyberWinDRCurrencyITL | 自助机 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.IO; // using System.Text.RegularExpressions; //using CardIO; namespace CyberPHP_Dynamic { class APP { public string start(NameValueCollection obj){ NameValueCollection d=obj; // write_log("CyberPHP_App","华视身份证","在线"); CyberWin_CardIO.CyberWinReader cio=new CyberWin_CardIO.CyberWinReader(); //Run cio.init(); string ret = cio.RunFile(); return ret;//"身份证读取"; } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 90052 | 纸币识别插件D | CyberWinDRCurrencyITLDemo | 自助机 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.IO; // using System.Text.RegularExpressions; //using CardIO; namespace CyberPHP_Dynamic { class APP { public string start(NameValueCollection obj){ NameValueCollection d=obj; Thread t = new Thread(new ThreadStart(Poll)); t.IsBackground = true; t.Start(); string ret = ""; return ret;//"身份证读取"; } //收钱方法 public void Poll() { //重启 t_send.Text = "02 03 06 30 41 B3"; byte[] temp1 = mysendb(); SendPackage(temp1); / t_send.Text = "02 03 06 37 FE C7"; temp1 = mysendb(); mycom1.Write(temp1); msg.AppendText("\r\n发送数据包：" + dis_package(temp1)); t_send.Text = "02 03 06 41 4F D1"; temp1 = mysendb(); mycom1.Write(temp1); msg.AppendText("\r\n发送数据包：" + dis_package(temp1)); / string temp = ""; while ("02 03 06 19 82 0F "!=temp) { //申请接收 t_send.Text = "02 03 06 33 DA 81"; temp1 = mysendb(); mycom1.Write(temp1); msg.AppendText("\r\n发送数据包：" + dis_package(temp1)); Thread.Sleep(50); temp = dis_package(mycom1.Read(50)); msg.AppendText("\r\n接收到数据包：" + temp); } //收钱主要 t_send.Text = "02 03 0C 34 FF FF FF 00 00 00 B5 C1"; temp1 = mysendb(); SendPackage(temp1); // while (true) { Thread.Sleep(80); if ("02 03 06 14 67 D4 " != temp && "02 03 06 15 EE C5 " != temp && "02 03 06 17 FC E6 " != temp) { //计算钱数 switch (temp) { case "02 03 07 81 00 54 2A ": money += 1; break; //一块 case "02 03 07 81 02 46 09 ": money += 5; break; //五块 case "02 03 07 81 03 CF 18 ": money += 10; break; //十块 case "02 03 07 81 04 70 6C ": money += 20; break; //二十块 case "02 03 07 81 05 F9 7D ": money += 50; break; //五十块 case "02 03 07 81 06 62 4F ": money += 100; break; //一百块 } button14.Text = "金额：" + money + "元"; } if("" == temp) { //申请接收 t_send.Text = "02 03 06 33 DA 81"; temp1 = mysendb(); mycom1.Write(temp1); msg.AppendText("\r\n发送数据包：" + dis_package(temp1)); Thread.Sleep(50); temp = dis_package(mycom1.Read(50)); msg.AppendText("\r\n接收到数据包：" + temp); } else if ("02 03 06 14 67 D4 " == temp) { if ("02 03 06 19 82 0F " ==temp) { //收钱主要 t_send.Text = "02 03 0C 34 FF FF FF 00 00 00 B5 C1"; temp1 = mysendb(); SendPackage(temp1); } //申请接收 t_send.Text = "02 03 06 33 DA 81"; temp1 = mysendb(); mycom1.Write(temp1); msg.AppendText("\r\n发送数据包：" + dis_package(temp1)); Thread.Sleep(50); temp = dis_package(mycom1.Read(50)); msg.AppendText("\r\n接收到数据包：" + temp); } else { //申请接收2 t_send.Text = "02 03 06 00 C2 82"; temp1 = mysendb(); mycom1.Write(temp1); msg.AppendText("\r\n发送数据包：" + dis_package(temp1)); Thread.Sleep(50); temp = dis_package(mycom1.Read(50)); msg.AppendText("\r\n接收到数据包：" + temp); } } // } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 90053 | 餐饮打印日志 | CyberWinDishPrintLog | 中餐 | using System;
using System.Collections.Generic;
using System.Text;
using System.Collections.Specialized;
using System.Windows.Forms;
using System.Data.SQLite;
using System.IO;
using System.Data;
using System.Data.Common;
using System.Net;
//引用数据库
//using CyberSnow.VB.NET.Data.Helper;
//
using System.Text.RegularExpressions;
using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData;
//故障排查系统查询
namespace CyberPHP_Dynamic
{
class APP
{
public string start(NameValueCollection obj){
string 车牌号码="";
NameValueCollection d=obj;
车牌号码 = d["carNO"];
string s="随机预安装插件";
return s;
}
public string PrintLog(NameValueCollection obj){
NameValueCollection d=obj;
string param = d["param"];
NameValueCollection obj_d = CyberPHPGetParm(param);
string logpath = obj_d["logpath"];
string printername = obj_d["printername"];
string orderid = obj_d["orderid"];
string tablename = obj_d["tablename"];
string d_y=DateTime.Now.ToString("yyyy"); // 2008-09-04
string d_m=DateTime.Now.ToString("MM");
string d_d=DateTime.Now.ToString("dd");
string path=logpath+"/"+d_y+"/"+d_m+"/"+d_d+"/"+printername;//
string printdata = obj_d["printdata"];
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
string 文件路径 = path + "/"+ orderid+"_"+printername+"_"+tablename+".log";
FileStream fs = new FileStream(文件路径, FileMode.Append);
StreamWriter sw = new StreamWriter(fs);
//开始写入
sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<");
sw.WriteLine(printdata);
sw.WriteLine("");
//清空缓冲区
sw.Flush();
//关闭流
sw.Close();
fs.Close();
return "保存成功";
}
public void UTF8toGBK(string filePath)//UTF8 转 GBK
{
var buffer = File.ReadAllBytes(filePath);//读取文件内容
buffer = Encoding.Convert(Encoding.UTF8, Encoding.GetEncoding("gbk"), buffer);//转码
File.WriteAllBytes(filePath, buffer);//写入文件
}
public void GBKtoUTF8(string filePath)//GBK 转 UTF8
{
var buffer = File.ReadAllBytes(filePath);//读取文件内容
buffer = Encoding.Convert(Encoding.GetEncoding("gbk"), Encoding.UTF8, buffer);//转码
File.WriteAllBytes(filePath, buffer);//写入文件
toolStripStatusLabel1.Text = "转码成功";
}
//读取高级参数
public NameValueCollection CyberPHPGetParm(string input)
{
NameValueCollection d = new NameValueCollection();
string str = input;// "aaajsbbbjsccc";
string split_param = "CyberPHP->Param:";
string split_value = "CyberPHP->Value:";
string[] sArray = Regex.Split(str, split_param, RegexOptions.IgnoreCase);
int j = 0;
foreach (string i in sArray)
{
// Response.Write(i.ToString() + " "); string[] valueArrat = Regex.Split(i, split_value, RegexOptions.IgnoreCase); if (valueArrat.Length < 2) { d.Add(j.ToString(), valueArrat[0]); } else { d.Add(valueArrat[0], valueArrat[1]); } j = j + 1; } //输出结果： //aaa //bbb //ccc //ccc return d; } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } |
1970-01-01 08:00 | 翻译 | |||||||
| 90054 | 消费机管理插件, | CyberWinConsumManger | 人员管理 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getEmpList(NameValueCollection obj){ try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); DataTable dt = db.Select(); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"id\":"+"\""+dr["EmpSysID"]+"\","; json=json+"\"no\":"+"\""+dr["EmpNo"]+"\","; json=json+"\"name\":"+"\""+dr["EmpName"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string sync_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("EmpSysID", "57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]);//88876584-id data_add.Add("EmpNo", arr[0]);//E000001 data_add.Add("EmpName", arr[1]);//姓名 data_add.Add("EmpHireDate", "2021-01-25 00:00:00.000"); data_add.Add("EmpPositiveDate", "2021-01-25 00:00:00.000"); data_add.Add("DepartSysID", "9074d4cb-15e0-11e3-a35e-ca181935be1c");//部门 data_add.Add("SexSysID", "d6dbd292-1610-11e3-a35e-ca181935be1c");//性别 固定 data_add.Add("RateSysID", "b9698dbe-15f6-11e3-a35e-ca181935be1c");//性别 data_add.Add("JobSysID", "b117a3dd-15f6-11e3-a35e-ca181935be1c");//固定 data_add.Add("StatusSysID", "94608794-15f6-11e3-a35e-ca181935be1c");//固定 // data_add.Add("EmpLeaveStatus", "0"); data_add.Add("EmpStatusID", "10");//性别 string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "已经存在"; }else{ db.Add(data_add); return "添加成功"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string check_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "存在"; }else{ return "不存在"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 90055 | 消费机管理插件,.SQLSERVER,本地数据操作 | CyberWinConsumManger | 人员管理 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getEmpList(NameValueCollection obj){ try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); DataTable dt = db.Select(); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"id\":"+"\""+dr["EmpSysID"]+"\","; json=json+"\"no\":"+"\""+dr["EmpNo"]+"\","; json=json+"\"name\":"+"\""+dr["EmpName"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string sync_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("EmpSysID", "57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]);//88876584-id data_add.Add("EmpNo", arr[0]);//E000001 data_add.Add("EmpName", arr[1]);//姓名 data_add.Add("EmpHireDate", "2021-01-25 00:00:00.000"); data_add.Add("EmpPositiveDate", "2021-01-25 00:00:00.000"); data_add.Add("DepartSysID", "9074d4cb-15e0-11e3-a35e-ca181935be1c");//部门 data_add.Add("SexSysID", "d6dbd292-1610-11e3-a35e-ca181935be1c");//性别 固定 data_add.Add("RateSysID", "b9698dbe-15f6-11e3-a35e-ca181935be1c");//性别 data_add.Add("JobSysID", "b117a3dd-15f6-11e3-a35e-ca181935be1c");//固定 data_add.Add("StatusSysID", "94608794-15f6-11e3-a35e-ca181935be1c");//固定 // data_add.Add("EmpLeaveStatus", "0"); data_add.Add("EmpStatusID", "10");//性别 string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "已经存在"; }else{ db.Add(data_add); return "添加成功"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp2(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string check_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "存在"; }else{ return "不存在"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 90056 | 自助售票机 | CyberWinSelfserviceTicketHelper | 打印，排号 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getTicketNewList(NameValueCollection obj){ try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] ="D:/TerminalApp/Data/js_tl.db"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("trade_ticket", "js_"); string sqllast="select * from js_trade_ticket where queue_number <>0 order by pay_time desc LIMIT 0,20 "; DataTable dt = db.QueryDataTable(sqllast); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"ticket_no\":"+"\""+dr["ticket_no"]+"\","; json=json+"\"dev_id\":"+"\""+dr["dev_id"]+"\","; json=json+"\"enterprise_uid\":"+"\""+dr["enterprise_uid"]+"\","; json=json+"\"queue_number\":"+"\""+dr["queue_number"]+"\","; json=json+"\"store_uid\":"+"\""+dr["store_uid"]+"\","; json=json+"\"add_time\":"+"\""+dr["add_time"]+"\","; json=json+"\"pay_time\":"+"\""+dr["pay_time"]+"\","; json=json+"\"product_uid\":"+"\""+dr["product_uid"]+"\","; json=json+"\"product_quantity\":"+"\""+dr["product_quantity"]+"\","; json=json+"\"product_price\":"+"\""+dr["product_price"]+"\","; json=json+"\"receive_money\":"+"\""+dr["receive_money"]+"\","; json=json+"\"qr_code\":"+"\""+dr["qr_code"]+"\","; json=json+"\"product_name\":"+"\""+dr["product_name"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string sync_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("EmpSysID", "57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]);//88876584-id data_add.Add("EmpNo", arr[0]);//E000001 data_add.Add("EmpName", arr[1]);//姓名 data_add.Add("EmpHireDate", "2021-01-25 00:00:00.000"); data_add.Add("EmpPositiveDate", "2021-01-25 00:00:00.000"); data_add.Add("DepartSysID", "9074d4cb-15e0-11e3-a35e-ca181935be1c");//部门 data_add.Add("SexSysID", "d6dbd292-1610-11e3-a35e-ca181935be1c");//性别 固定 data_add.Add("RateSysID", "b9698dbe-15f6-11e3-a35e-ca181935be1c");//性别 data_add.Add("JobSysID", "b117a3dd-15f6-11e3-a35e-ca181935be1c");//固定 data_add.Add("StatusSysID", "94608794-15f6-11e3-a35e-ca181935be1c");//固定 // data_add.Add("EmpLeaveStatus", "0"); data_add.Add("EmpStatusID", "10");//性别 string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "已经存在"; }else{ db.Add(data_add); return "添加成功"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp2(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string check_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "存在"; }else{ return "不存在"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 90057 | 华视身份证识别 | CyberWinIDCardCVR100A | 打印，排号 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getTicketNewList(NameValueCollection obj){ try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] ="D:/TerminalApp/Data/js_tl.db"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("trade_ticket", "js_"); string sqllast="select * from js_trade_ticket where queue_number <>0 order by pay_time desc LIMIT 0,20 "; DataTable dt = db.QueryDataTable(sqllast); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"ticket_no\":"+"\""+dr["ticket_no"]+"\","; json=json+"\"dev_id\":"+"\""+dr["dev_id"]+"\","; json=json+"\"enterprise_uid\":"+"\""+dr["enterprise_uid"]+"\","; json=json+"\"queue_number\":"+"\""+dr["queue_number"]+"\","; json=json+"\"store_uid\":"+"\""+dr["store_uid"]+"\","; json=json+"\"add_time\":"+"\""+dr["add_time"]+"\","; json=json+"\"pay_time\":"+"\""+dr["pay_time"]+"\","; json=json+"\"product_uid\":"+"\""+dr["product_uid"]+"\","; json=json+"\"product_quantity\":"+"\""+dr["product_quantity"]+"\","; json=json+"\"product_price\":"+"\""+dr["product_price"]+"\","; json=json+"\"receive_money\":"+"\""+dr["receive_money"]+"\","; json=json+"\"qr_code\":"+"\""+dr["qr_code"]+"\","; json=json+"\"product_name\":"+"\""+dr["product_name"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string sync_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("EmpSysID", "57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]);//88876584-id data_add.Add("EmpNo", arr[0]);//E000001 data_add.Add("EmpName", arr[1]);//姓名 data_add.Add("EmpHireDate", "2021-01-25 00:00:00.000"); data_add.Add("EmpPositiveDate", "2021-01-25 00:00:00.000"); data_add.Add("DepartSysID", "9074d4cb-15e0-11e3-a35e-ca181935be1c");//部门 data_add.Add("SexSysID", "d6dbd292-1610-11e3-a35e-ca181935be1c");//性别 固定 data_add.Add("RateSysID", "b9698dbe-15f6-11e3-a35e-ca181935be1c");//性别 data_add.Add("JobSysID", "b117a3dd-15f6-11e3-a35e-ca181935be1c");//固定 data_add.Add("StatusSysID", "94608794-15f6-11e3-a35e-ca181935be1c");//固定 // data_add.Add("EmpLeaveStatus", "0"); data_add.Add("EmpStatusID", "10");//性别 string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "已经存在"; }else{ db.Add(data_add); return "添加成功"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp2(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string check_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "存在"; }else{ return "不存在"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 90058 | 人脸门禁 | CyberWinFaceCheckManager | 打印，排号 | using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getTicketNewList(NameValueCollection obj){ try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] ="D:/TerminalApp/Data/js_tl.db"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("trade_ticket", "js_"); string sqllast="select * from js_trade_ticket where queue_number <>0 order by pay_time desc LIMIT 0,20 "; DataTable dt = db.QueryDataTable(sqllast); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"ticket_no\":"+"\""+dr["ticket_no"]+"\","; json=json+"\"dev_id\":"+"\""+dr["dev_id"]+"\","; json=json+"\"enterprise_uid\":"+"\""+dr["enterprise_uid"]+"\","; json=json+"\"queue_number\":"+"\""+dr["queue_number"]+"\","; json=json+"\"store_uid\":"+"\""+dr["store_uid"]+"\","; json=json+"\"add_time\":"+"\""+dr["add_time"]+"\","; json=json+"\"pay_time\":"+"\""+dr["pay_time"]+"\","; json=json+"\"product_uid\":"+"\""+dr["product_uid"]+"\","; json=json+"\"product_quantity\":"+"\""+dr["product_quantity"]+"\","; json=json+"\"product_price\":"+"\""+dr["product_price"]+"\","; json=json+"\"receive_money\":"+"\""+dr["receive_money"]+"\","; json=json+"\"qr_code\":"+"\""+dr["qr_code"]+"\","; json=json+"\"product_name\":"+"\""+dr["product_name"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string sync_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("EmpSysID", "57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]);//88876584-id data_add.Add("EmpNo", arr[0]);//E000001 data_add.Add("EmpName", arr[1]);//姓名 data_add.Add("EmpHireDate", "2021-01-25 00:00:00.000"); data_add.Add("EmpPositiveDate", "2021-01-25 00:00:00.000"); data_add.Add("DepartSysID", "9074d4cb-15e0-11e3-a35e-ca181935be1c");//部门 data_add.Add("SexSysID", "d6dbd292-1610-11e3-a35e-ca181935be1c");//性别 固定 data_add.Add("RateSysID", "b9698dbe-15f6-11e3-a35e-ca181935be1c");//性别 data_add.Add("JobSysID", "b117a3dd-15f6-11e3-a35e-ca181935be1c");//固定 data_add.Add("StatusSysID", "94608794-15f6-11e3-a35e-ca181935be1c");//固定 // data_add.Add("EmpLeaveStatus", "0"); data_add.Add("EmpStatusID", "10");//性别 string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "已经存在"; }else{ db.Add(data_add); return "添加成功"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp2(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string check_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "存在"; }else{ return "不存在"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 90059 | 报钟器 | CyberWinFootbathBaozhongqi | 打印，排号 | ausing System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getTicketNewList(NameValueCollection obj){ try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] ="D:/TerminalApp/Data/js_tl.db"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("trade_ticket", "js_"); string sqllast="select * from js_trade_ticket where queue_number <>0 order by pay_time desc LIMIT 0,20 "; DataTable dt = db.QueryDataTable(sqllast); if(dt.Rows.Count>0){ string json="["; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"ticket_no\":"+"\""+dr["ticket_no"]+"\","; json=json+"\"dev_id\":"+"\""+dr["dev_id"]+"\","; json=json+"\"enterprise_uid\":"+"\""+dr["enterprise_uid"]+"\","; json=json+"\"queue_number\":"+"\""+dr["queue_number"]+"\","; json=json+"\"store_uid\":"+"\""+dr["store_uid"]+"\","; json=json+"\"add_time\":"+"\""+dr["add_time"]+"\","; json=json+"\"pay_time\":"+"\""+dr["pay_time"]+"\","; json=json+"\"product_uid\":"+"\""+dr["product_uid"]+"\","; json=json+"\"product_quantity\":"+"\""+dr["product_quantity"]+"\","; json=json+"\"product_price\":"+"\""+dr["product_price"]+"\","; json=json+"\"receive_money\":"+"\""+dr["receive_money"]+"\","; json=json+"\"qr_code\":"+"\""+dr["qr_code"]+"\","; json=json+"\"product_name\":"+"\""+dr["product_name"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string sync_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("EmpSysID", "57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]);//88876584-id data_add.Add("EmpNo", arr[0]);//E000001 data_add.Add("EmpName", arr[1]);//姓名 data_add.Add("EmpHireDate", "2021-01-25 00:00:00.000"); data_add.Add("EmpPositiveDate", "2021-01-25 00:00:00.000"); data_add.Add("DepartSysID", "9074d4cb-15e0-11e3-a35e-ca181935be1c");//部门 data_add.Add("SexSysID", "d6dbd292-1610-11e3-a35e-ca181935be1c");//性别 固定 data_add.Add("RateSysID", "b9698dbe-15f6-11e3-a35e-ca181935be1c");//性别 data_add.Add("JobSysID", "b117a3dd-15f6-11e3-a35e-ca181935be1c");//固定 data_add.Add("StatusSysID", "94608794-15f6-11e3-a35e-ca181935be1c");//固定 // data_add.Add("EmpLeaveStatus", "0"); data_add.Add("EmpStatusID", "10");//性别 string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "已经存在"; }else{ db.Add(data_add); return "添加成功"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp2(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string check_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "存在"; }else{ return "不存在"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 | |||||||
| 90060 | 人脸、自助登记，体温检测，动态数据 | CyberWinFaceCheckManagerAndIDCardVR100UA | 体温检测，人脸识别，一键登记 |
未来之窗身份证登记测试demo未来之窗身份证语音测试读卡 读卡成功 读卡失败未来之窗智能物联-上万家设备接入未来之窗智慧城市——只有你想不到，没有不能实现 |
using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; using System.Drawing; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; using System.Runtime.InteropServices;//这是用到DllImport时候要引入的包 //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; private string 身份证照片保存路径=""; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string getCardInfoAndSyncFace(NameValueCollection obj){ NameValueCollection d=obj; string param = d["param"]; 身份证照片保存路径=param; try { int iPort, iRetUSB = 0; for (iPort = 1001; iPort <= 1016; iPort++) { iRetUSB = CVR_InitComm(iPort); if (iRetUSB == 1) { break; } } if (iRetUSB == 1) { //this.labelOpResult.Text = "初始化成功！"; } else { //this.labelOpResult.Text = "初始化失败！"; } int authenticate = CVR_Authenticate(); if (authenticate == 1) { int readContent = CVR_Read_FPContent(); if (readContent == 1) { //this.labelOpResult.Text = "读卡操作成功！"; string ret=FillData(); return ret; } else { //this.labelOpResult.Text = "读卡操作失败！"; return "9"; } } else { //MessageBox.Show(""); return "9"; } CVR_CloseComm(); return "操作完成！"; } catch (Exception ex) { //MessageBox.Show(ex.ToString()); //return ex.ToString(); return "4"; } } public string FillData() { try { string json=""; byte[] imgData = new byte[40960]; int length = 40960; GetBMPData(ref imgData[0], ref length); MemoryStream myStream = new MemoryStream(); for (int i = 0; i < length;i++ ) { myStream.WriteByte(imgData[i]); } Image myImage = Image.FromStream(myStream); //照片不要 pictureBoxPhoto.Image = myImage; byte[] name = new byte[128]; length = 128; GetPeopleName(ref name[0], ref length); byte[] cnName = new byte[128]; length = 128; GetPeopleChineseName(ref cnName[0], ref length); byte[] number = new byte[128]; length = 128; GetPeopleIDCode(ref number[0], ref length); byte[] peopleNation = new byte[128]; length = 128; GetPeopleNation(ref peopleNation[0], ref length); byte[] peopleNationCode = new byte[128]; length = 128; GetNationCode(ref peopleNationCode[0], ref length); byte[] validtermOfStart = new byte[128]; length = 128; GetStartDate(ref validtermOfStart[0], ref length); byte[] birthday = new byte[128]; length = 128; GetPeopleBirthday(ref birthday[0], ref length); byte[] address = new byte[128]; length = 128; GetPeopleAddress(ref address[0], ref length); byte[] validtermOfEnd = new byte[128]; length = 128; GetEndDate(ref validtermOfEnd[0], ref length); byte[] signdate = new byte[128]; length = 128; GetDepartment(ref signdate[0], ref length); byte[] sex = new byte[128]; length = 128; GetPeopleSex(ref sex[0], ref length); byte[] samid = new byte[128]; CVR_GetSAMID(ref samid[0]); bool bCivic = true; byte[] certType = new byte[32]; length = 32; GetCertType(ref certType[0], ref length); string strType = System.Text.Encoding.ASCII.GetString(certType); int nStart = strType.IndexOf("I"); if (nStart != -1) bCivic = false; NameValueCollection data_idobj = new NameValueCollection(); if (bCivic) { string labelName =System.Text.Encoding.GetEncoding("GB2312").GetString(name).Replace("\0", "").Trim();; string labelSex =System.Text.Encoding.GetEncoding("GB2312").GetString(sex).Replace("\0", "").Trim(); string labelNation = System.Text.Encoding.GetEncoding("GB2312").GetString(peopleNation).Replace("\0", "").Trim(); string labelNationCode = System.Text.Encoding.GetEncoding("GB2312").GetString(peopleNationCode).Replace("\0", "").Trim(); string labelBirthday = System.Text.Encoding.GetEncoding("GB2312").GetString(birthday).Replace("\0", "").Trim(); string labelIdCardNo = System.Text.Encoding.GetEncoding("GB2312").GetString(number).Replace("\0", "").Trim(); string labelAddress =System.Text.Encoding.GetEncoding("GB2312").GetString(address).Replace("\0", "").Trim(); string labelDepartment = System.Text.Encoding.GetEncoding("GB2312").GetString(signdate).Replace("\0", "").Trim(); string labelValidDate =System.Text.Encoding.GetEncoding("GB2312").GetString(validtermOfStart).Replace("\0", "").Trim() + "-" + System.Text.Encoding.GetEncoding("GB2312").GetString(validtermOfEnd).Replace("\0", "").Trim(); string labelSamID = System.Text.Encoding.GetEncoding("GB2312").GetString(samid).Replace("\0", "").Trim(); Bitmap bmp = new Bitmap(myImage); string 身份证照片保存路径_wj=身份证照片保存路径+"/"+labelIdCardNo+".jpg"; //保存到磁盘文件 bmp.Save(身份证照片保存路径_wj, System.Drawing.Imaging.ImageFormat.Jpeg); bmp.Dispose(); json=json+"{"; json=json+"\"name\":"+"\""+labelName+"\","; json=json+"\"sex\":"+"\""+labelSex+"\","; json=json+"\"nation\":"+"\""+labelNation+"\","; json=json+"\"birthday\":"+"\""+labelBirthday+"\","; json=json+"\"idcardno\":"+"\""+labelIdCardNo+"\","; json=json+"\"address\":"+"\""+labelAddress+"\","; json=json+"\"department\":"+"\""+labelDepartment+"\","; json=json+"\"validdate\":"+"\""+labelValidDate+"\","; json=json+"\"samiD\":"+"\""+labelSamID+"\""; json=json+"}"; data_idobj.Add("name", labelName); data_idobj.Add("sex", labelSex); data_idobj.Add("nation", labelNation); data_idobj.Add("idcardno", labelIdCardNo); data_idobj.Add("address", labelAddress); data_idobj.Add("department", labelDepartment); data_idobj.Add("validdate", labelValidDate); data_idobj.Add("samiD", labelSamID); } else { string labelCnName = "中文姓名：" + System.Text.Encoding.GetEncoding("GB2312").GetString(cnName).Replace("\0", "").Trim(); string labelSex = "性别：" + System.Text.Encoding.GetEncoding("GB2312").GetString(sex).Replace("\0", "").Trim(); string labelNation = "国籍：" + System.Text.Encoding.GetEncoding("GB2312").GetString(peopleNation).Replace("\0", "").Trim(); string labelNationCode = "国籍代码：" + System.Text.Encoding.GetEncoding("GB2312").GetString(peopleNationCode).Replace("\0", "").Trim(); string labelBirthday = "出生日期：" + System.Text.Encoding.GetEncoding("GB2312").GetString(birthday).Replace("\0", "").Trim(); string labelIdCardNo = "证件号码：" + System.Text.Encoding.GetEncoding("GB2312").GetString(number).Replace("\0", "").Trim(); string labelDepartment = "签发机关：" + System.Text.Encoding.GetEncoding("GB2312").GetString(signdate).Replace("\0", "").Trim(); string labelValidDate = "有效期限：" + System.Text.Encoding.GetEncoding("GB2312").GetString(validtermOfStart).Replace("\0", "").Trim() + "-" + System.Text.Encoding.GetEncoding("GB2312").GetString(validtermOfEnd).Replace("\0", "").Trim(); string labelSamID = "安全模块号：" + System.Text.Encoding.GetEncoding("GB2312").GetString(samid).Replace("\0", "").Trim(); json=json+"{"; /* json=json+"\"name\":"+"\""labelCnName"\","; json=json+"\"sex\":"+"\""labelSex"\","; json=json+"\"nation\":"+"\""labelNationCode"\","; json=json+"\"birthday\":"+"\""labelBirthday"\","; json=json+"\"idcardno\":"+"\""labelIdCardNo"\","; json=json+"\"address\":"+"\""labelDepartment"\","; json=json+"\"validdate\":"+"\""labelValidDate"\","; json=json+"\"samiD\":"+"\""labelSamID"\""; */ json=json+"}"; } json=json+"]"; addFaceCheckPeople(data_idobj); return json; } catch (Exception ex) { // MessageBox.Show(ex.ToString()); return ex.ToString(); } } //人脸进库 public string addFaceCheckPeople(NameValueCollection idobj){ string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] ="."; conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="FaceCheck"; string 未来之窗itime=CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinPC.PHPutility.function.DateTimeToUnixTimeStamp(System.DateTime.Now).ToString(); Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db_PersonInfo = new Cyber_M("ersonInfo", "P"); NameValueCollection data_PersonInfo = new NameValueCollection();//基础信息 NameValueCollection data_PersonInfo_D = new NameValueCollection(); NameValueCollection data_PowerPerson_Settings = new NameValueCollection(); string labelIdCardNo=idobj.Get("idcardno"); data_PersonInfo.Add("PersonID",未来之窗itime); data_PersonInfo.Add("PersonName",idobj.Get("name")); data_PersonInfo.Add("Sex","0");//idobj.Get("sex") data_PersonInfo.Add("IdentityNo",idobj.Get("idcardno")); data_PersonInfo.Add("Address",idobj.Get("address")); data_PersonInfo.Add("SubSystem","01000000"); data_PersonInfo.Add("BirthDate","2021-01-27 21:14:19.137");//idobj.Get("sex") data_PersonInfo.Add("Telephone","");//idobj.Get("sex") db_PersonInfo.where(" IdentityNo = '"+idobj.Get("idcardno")+"' "); if(db_PersonInfo.Count()>0){ // return "已经存在"; return "已经存在，全部取消"; }else{ db_PersonInfo.Add(data_PersonInfo); // return "添加成功"; } //门禁信息属性 db_PersonInfo.where(" IdentityNo = '"+idobj.Get("idcardno")+"' "); string PersonInfo_ID = db_PersonInfo.GetField("ID"); data_PersonInfo_D.Add("PersonInfo_ID",PersonInfo_ID); data_PersonInfo_D.Add("people_identitytype","0");// data_PersonInfo_D.Add("People_IdentityStartDate","2021-01-27 21:14:19.137");//idobj.Get("sex") data_PersonInfo_D.Add("People_IdentityEndDate","2099-01-27 21:14:19.137");//idobj.Get("sex") data_PersonInfo_D.Add("People_IdentityIssue"," ");// data_PersonInfo_D.Add("People_CurrentAddress"," ");// data_PersonInfo_D.Add("People_Nation","0");// data_PersonInfo_D.Add("People_StartDate","2021-01-27 21:14:19.137");//idobj.Get("sex") data_PersonInfo_D.Add("People_EndDate","2099-01-27 21:14:19.137");//idobj.Get("sex") data_PersonInfo_D.Add("People_IdentityImg"," ");// data_PersonInfo_D.Add("People_ShootImg","");// data_PersonInfo_D.Add("People_Type","0");// data_PersonInfo_D.Add("Device_NoArray"," ");// data_PersonInfo_D.Add("People_Delete","0");// data_PersonInfo_D.Add("People_Sync"," ");// data_PersonInfo_D.Add("People_Creater","1");// data_PersonInfo_D.Add("People_CreateTime","2021-01-27 21:14:19.137");// data_PersonInfo_D.Add("People_LastModifier","1");// data_PersonInfo_D.Add("People_LastTime","2021-01-27 21:14:19.137");// data_PersonInfo_D.Add("WhiteGroup","");// data_PersonInfo_D.Add("CompanyName","wenti");// data_PersonInfo_D.Add("DepartMentName","bumenq");// data_PersonInfo_D.Add("People_IdNo","");// data_PersonInfo_D.Add("People_CarNo","");// data_PersonInfo_D.Add("People_QR_Code","");// string 身份证照片保存路径_wj=身份证照片保存路径+"/"+labelIdCardNo+".jpg"; data_PersonInfo_D.Add("people_ShootImgPath1",身份证照片保存路径_wj);// data_PersonInfo_D.Add("people_ShootImgPath2","");// data_PersonInfo_D.Add("people_ShootImgPath3","");// data_PersonInfo_D.Add("people_ShootImgPath4","");// data_PersonInfo_D.Add("DownLoadSignal","00000000000000000000000000000000000000000000000000");// data_PersonInfo_D.Add("people_Device","");// data_PersonInfo_D.Add("isVisitorPeople","0");// data_PersonInfo_D.Add("personPhone","");// data_PersonInfo_D.Add("TimeGroupId","0");// data_PersonInfo_D.Add("CompanyID","1");// data_PersonInfo_D.Add("DepartMentID","2");// data_PersonInfo_D.Add("KQGroupID","1");// data_PersonInfo_D.Add("specialTime_Type","0");// data_PersonInfo_D.Add("PersonPwd","");// Cyber_M db_PersonInfo_D = new Cyber_M("ersonInfo_D", "P"); string where_pd=" PersonInfo_ID = '"+PersonInfo_ID+"' "; db_PersonInfo_D.where(where_pd); //MessageBox.Show(where_pd+db_PersonInfo_D.getCurrentSQL()); int count_pd = db_PersonInfo_D.Count(); if(count_pd>0){ // return "已经存在"; // MessageBox.Show(where_pd+db_PersonInfo_D.getCurrentSQL()); }else{ // MessageBox.Show(where_pd+db_PersonInfo_D.getCurrentSQL()); db_PersonInfo_D.Add(data_PersonInfo_D); // MessageBox.Show("添加后"+db_PersonInfo_D.getCurrentSQL()); // return "添加成功"; } //门禁权限 Cyber_M db_PowerPerson_Settings = new Cyber_M("PowerPerson_Settings", "MJ_"); data_PowerPerson_Settings.Add("MJ_Permission_Group_ID","1"); data_PowerPerson_Settings.Add("Person_Name",idobj.Get("name")); data_PowerPerson_Settings.Add("Person_No",未来之窗itime); data_PowerPerson_Settings.Add("Person_IdentityNo",labelIdCardNo); db_PowerPerson_Settings.where(" Person_IdentityNo = '"+labelIdCardNo+"' "); if(db_PowerPerson_Settings.Count()>0){ // return "已经存在"; }else{ db_PowerPerson_Settings.Add(data_PersonInfo_D); // return "添加成功"; } return "登记成功"; } // CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinNet.Http.CyberHttpDownload.OpenReadWithHttpsByInnerAgentALL() //人脸进库 public string addFaceCheckPeopleTodevice(NameValueCollection idobj){ string url=" http://192.168.1.243:9090/addDeviceWhiteList"; string data=""; CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinNet.Http.CyberHttpDownload.OpenReadWithHttpsByInnerAgentALL(url,data,"UTF-8","POST"); return "0"; } //通用数据库操作 public string getCommonData(NameValueCollection obj){ NameValueCollection d=obj; string param = d["param"]; string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] ="."; conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="FaceCheck"; string 未来之窗itime=CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinPC.PHPutility.function.DateTimeToUnixTimeStamp(System.DateTime.Now).ToString(); Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); //门禁权限 Cyber_M db_default = new Cyber_M("PowerPerson_Settings", "MJ_"); DataTable dt1 = db_default.QueryDataTable(param); string ret = DataTableToJson(dt1); return ret; } public string DataTableToJson(DataTable table) { var JsonString = new StringBuilder(); if (table.Rows.Count > 0) { JsonString.Append("["); for (int i = 0; i < table.Rows.Count; i++) { JsonString.Append("{"); for (int j = 0; j < table.Columns.Count; j++) { if (j < table.Columns.Count - 1) { JsonString.Append("\"" + table.Columns[j].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][j].ToString() + "\","); } else if (j == table.Columns.Count - 1) { JsonString.Append("\"" + table.Columns[j].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][j].ToString() + "\""); } } if (i == table.Rows.Count - 1) { JsonString.Append("}"); } else { JsonString.Append("},"); } } JsonString.Append("]"); } return JsonString.ToString(); } public string getTicketNewList(NameValueCollection obj){ try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "SQLite"; string[] conn = new string[1]; conn[0] ="D:/TerminalApp/Data/js_tl.db"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("trade_ticket", "js_"); string sqllast="select * from js_trade_ticket where queue_number <>0 order by pay_time desc LIMIT 0,20 "; DataTable dt = db.QueryDataTable(sqllast); if(dt.Rows.Count>0){ string json=""; foreach(DataRow dr in dt.Rows){ json=json+"{"; json=json+"\"ticket_no\":"+"\""+dr["ticket_no"]+"\","; json=json+"\"dev_id\":"+"\""+dr["dev_id"]+"\","; json=json+"\"enterprise_uid\":"+"\""+dr["enterprise_uid"]+"\","; json=json+"\"queue_number\":"+"\""+dr["queue_number"]+"\","; json=json+"\"store_uid\":"+"\""+dr["store_uid"]+"\","; json=json+"\"add_time\":"+"\""+dr["add_time"]+"\","; json=json+"\"pay_time\":"+"\""+dr["pay_time"]+"\","; json=json+"\"product_uid\":"+"\""+dr["product_uid"]+"\","; json=json+"\"product_quantity\":"+"\""+dr["product_quantity"]+"\","; json=json+"\"product_price\":"+"\""+dr["product_price"]+"\","; json=json+"\"receive_money\":"+"\""+dr["receive_money"]+"\","; json=json+"\"qr_code\":"+"\""+dr["qr_code"]+"\","; json=json+"\"product_name\":"+"\""+dr["product_name"]+"\""; json=json+"},"; } json=json+"]"; return json; }else{ return "没有数据"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); string s= ex.InnerException+ex.Source+ex.StackTrace; return "异常"+s; } } //param public string sync_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); NameValueCollection data_add = new NameValueCollection(); data_add.Add("EmpSysID", "57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]);//88876584-id data_add.Add("EmpNo", arr[0]);//E000001 data_add.Add("EmpName", arr[1]);//姓名 data_add.Add("EmpHireDate", "2021-01-25 00:00:00.000"); data_add.Add("EmpPositiveDate", "2021-01-25 00:00:00.000"); data_add.Add("DepartSysID", "9074d4cb-15e0-11e3-a35e-ca181935be1c");//部门 data_add.Add("SexSysID", "d6dbd292-1610-11e3-a35e-ca181935be1c");//性别 固定 data_add.Add("RateSysID", "b9698dbe-15f6-11e3-a35e-ca181935be1c");//性别 data_add.Add("JobSysID", "b117a3dd-15f6-11e3-a35e-ca181935be1c");//固定 data_add.Add("StatusSysID", "94608794-15f6-11e3-a35e-ca181935be1c");//固定 // data_add.Add("EmpLeaveStatus", "0"); data_add.Add("EmpStatusID", "10");//性别 string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "已经存在"; }else{ db.Add(data_add); return "添加成功"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string delete_emp2(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } public string check_emp(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '57AD4CB2-1F1F-0874-85DF-68CB"+arr[0]+"' "); if(db.Count()>0){ return "存在"; }else{ return "不存在"; } }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //shop_deletegoods public string shop_deletegoods(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string dbType = "SQLite"; string[] conn = new string[1]; conn[0] =cyber_db_shopgoods; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("shop_goods", "cwpdcms_"); db.where("cyber_id = '"+param +"'"); db.Delete(); return "删除成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } [DllImport("Termb.dll", EntryPoint = "CVR_InitComm", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int CVR_InitComm(int Port);//声明外部的标准动态库, 跟Win32API是一样的 [DllImport("Termb.dll", EntryPoint = "CVR_Authenticate", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int CVR_Authenticate(); [DllImport("Termb.dll", EntryPoint = "CVR_Read_Content", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int CVR_Read_Content(int Active); [DllImport("Termb.dll", EntryPoint = "CVR_Read_FPContent", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int CVR_Read_FPContent(); [DllImport("Termb.dll", EntryPoint = "CVR_FindCard", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int CVR_FindCard(); [DllImport("Termb.dll", EntryPoint = "CVR_SelectCard", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int CVR_SelectCard(); [DllImport("Termb.dll", EntryPoint = "CVR_CloseComm", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int CVR_CloseComm(); [DllImport("Termb.dll", EntryPoint = "GetCertType", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int GetCertType(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetPeopleName", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int GetPeopleName(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetPeopleChineseName", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int GetPeopleChineseName(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetPeopleNation", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int GetPeopleNation(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetNationCode", CharSet = CharSet.Ansi, SetLastError = false)] public static extern int GetNationCode(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetPeopleBirthday", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int GetPeopleBirthday(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetPeopleAddress", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int GetPeopleAddress(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetPeopleIDCode", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int GetPeopleIDCode(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetDepartment", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int GetDepartment(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetStartDate", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int GetStartDate(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetEndDate", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int GetEndDate(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "GetPeopleSex", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int GetPeopleSex(ref byte strTmp, ref int strLen); [DllImport("Termb.dll", EntryPoint = "CVR_GetSAMID", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int CVR_GetSAMID(ref byte strTmp); [DllImport("Termb.dll", EntryPoint = "GetBMPData", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int GetBMPData(ref byte btBmp, ref int nLen); [DllImport("Termb.dll", EntryPoint = "GetJpgData", CharSet = CharSet.Ansi, SetLastError = false, CallingConvention = CallingConvention.StdCall)] public static extern int GetJpgData(ref byte btBmp, ref int nLen); } } | 1970-01-01 08:00 | 翻译 | ||||||
| 90061 | 人脸门禁终端管理 | CyberWinFaceCheckDevice | 人脸门禁终端管理 |
未来之窗身份证登记测试demo未来之窗身份证语音测试读卡 读卡成功 读卡失败未来之窗智能物联-上万家设备接入未来之窗智慧城市——只有你想不到，没有不能实现 |
using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Windows.Forms; using System.Data.SQLite; using System.IO; using System.Drawing; // using System.Data; using System.Data.Common; //引用数据库 //using CyberSnow.VB.NET.Data.Helper; // using System.Text.RegularExpressions; using CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinWeb.WebData; using System.Runtime.InteropServices;//这是用到DllImport时候要引入的包 //故障排查系统查询 namespace CyberPHP_Dynamic { class APP { private string cyber_db_shopgoods = Application.StartupPath + "/CyberWinPHP/CyberPHP_DataBase/cwpd_local_shopnew.cyberphp"; private string 身份证照片保存路径=""; public string start(NameValueCollection obj){ string 车牌号码=""; NameValueCollection d=obj; 车牌号码 = d["carNO"]; string s="随机预安装插件"+cyber_db_shopgoods; return s; } public string facedevcomm(NameValueCollection idobj){ NameValueCollection d=idobj; string param = d["param"]; CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinProtocol.Cl_CyberWinAPPProtocolPackage clApp = new CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinProtocol.Cl_CyberWinAPPProtocolPackage(); clApp.formatString(param); string url=clApp.get("address")+clApp.get("action"); //" http://192.168.1.243:9090/addDeviceWhiteList"; string data=clApp.get("data");//""; string ret = CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinNet.Http.CyberHttpDownload.OpenReadWithHttpsByInnerAgentALL(url,data,"UTF-8","POST"); return ret; } // CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinNet.Http.CyberHttpDownload.OpenReadWithHttpsByInnerAgentALL() //人脸进库 public string addFaceCheckPeopleTodevice(NameValueCollection idobj){ string url=" http://192.168.1.243:9090/addDeviceWhiteList"; string data=""; CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinNet.Http.CyberHttpDownload.OpenReadWithHttpsByInnerAgentALL(url,data,"UTF-8","POST"); return "0"; } //通用数据库操作 public string getCommonData(NameValueCollection obj){ NameValueCollection d=obj; string param = d["param"]; string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] ="."; conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="FaceCheck"; string 未来之窗itime=CyberWin.CSHARP.YNWLZC.WebFrame.CyberPHP.CyberWinPC.PHPutility.function.DateTimeToUnixTimeStamp(System.DateTime.Now).ToString(); Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); //门禁权限 Cyber_M db_default = new Cyber_M("PowerPerson_Settings", "MJ_"); DataTable dt1 = db_default.QueryDataTable(param); string ret = DataTableToJson(dt1); return ret; } public string DataTableToJson(DataTable table) { var JsonString = new StringBuilder(); if (table.Rows.Count > 0) { JsonString.Append("["); for (int i = 0; i < table.Rows.Count; i++) { JsonString.Append("{"); for (int j = 0; j < table.Columns.Count; j++) { if (j < table.Columns.Count - 1) { JsonString.Append("\"" + table.Columns[j].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][j].ToString() + "\","); } else if (j == table.Columns.Count - 1) { JsonString.Append("\"" + table.Columns[j].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][j].ToString() + "\""); } } if (i == table.Rows.Count - 1) { JsonString.Append("}"); } else { JsonString.Append("},"); } } JsonString.Append("]"); } return JsonString.ToString(); } public string delete_emp2(NameValueCollection obj) { try{ NameValueCollection d=obj; string param = d["param"]; string[] arr = param.Split('|'); string dbType = "MSSQL"; string[] conn = new string[4]; conn[0] =".";//\\sqlexpress conn[1] ="sa"; conn[2] ="cybersnow"; conn[3] ="ECardcyber"; Cyber_DataBase cdb = new Cyber_DataBase(dbType, conn); Cyber_M db = new Cyber_M("emp", "rs_"); db.where(" EmpSysID = '"+arr[0]+"' "); db.Delete(); return "删除成功成功"; }catch(Exception ex){ write_log("CyberPHP_App","sqltest","数据库:"+ex.Message); return ex.Message; } } //日志 public static void write_log(string capturetype, string type, string s) { string logPath = Application.StartupPath + "/log/" + capturetype + "/" + DateTime.Now.ToLongDateString() + "/"; if (System.IO.Directory.Exists(logPath) == false) { System.IO.Directory.CreateDirectory(logPath); } string 文件路径 = logPath + type + "_log.log"; FileStream fs = new FileStream(文件路径, FileMode.Append); StreamWriter sw = new StreamWriter(fs); //开始写入 sw.WriteLine("==============================\r\n" + DateTime.Now.ToLongDateString() + "<<<<<<<<<<<<<<<<<<<<<<<<<<"); sw.WriteLine(s); sw.WriteLine(""); //清空缓冲区 sw.Flush(); //关闭流 sw.Close(); fs.Close(); } } } | 1970-01-01 08:00 | 翻译 |
5704 条记录 1/286页