private void FormMain_Load(object sender, EventArgs e)
{
FormMain.m_mq = new MQ();
saveDataToLog = string.Equals(bool.TrueString, System.Configuration.ConfigurationManager.AppSettings["SaveDataToLog"], StringComparison.CurrentCultureIgnoreCase);
//初始化数据解析类
bool iniCheck = CheckIniConfig();
DataBase = new MySQLDBHelper();
dataHelper = new DataDealHelper(DataBase);
//初始化处理线程
dealThread = new Thread(dataHelper.DealStatus);
saveThread = new Thread(dataHelper.SaveStatus);
textTcpPort.Text = ini.ReadValue("LocalHost", "TCPLocalPort");
textUdpPort.Text = ini.ReadValue("LocalHost", "UDPLocalPort");
//初始化存储数据库的计时器（5秒更新一次数据库）
dbTimer = new System.Timers.Timer(10000);
dbTimer.AutoReset = true;
dbTimer.Elapsed += DbTimer_Elapsed;
EquipmentHelper.MyEvent += new EquipmentHelper.MyDelegate(SendDataResponse);
DataDealHelper.MyEvent += new DataDealHelper.MyDelegate(SendDataResponse);
this.timercounter = 0;
}
private void LoginMysqlbutton_Click(object sender, EventArgs e)
{
ip = ipAddressControl1.Text;
user = UserNametextBox.Text;
pwd = PwdtextBox.Text;
basedb = BaseDatatextBox.Text;
try
{
string ConnectMysql = null;
MySQLDBHelper _Mysql = new MySQLDBHelper();
ConnectMysql = MySQLDBHelper.GetConnectString(ipAddressControl1.Text, UserNametextBox.Text, PwdtextBox.Text, BaseDatatextBox.Text);
if (0 == _Mysql.Open(ConnectMysql, null))
{
this.Visible = false;
DataMakerFm fm = new DataMakerFm(_Mysql);
fm.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Mysql连接失败!!!");
}
}
catch (Exception ex)
{
string info = StringUtil.buildExceptionInfo(ex);
MessageBox.Show(info);
}
}
public iot_storageFm(MySQLDBHelper Mysql)
{
_Mysql = Mysql;
InitializeComponent();
// 加入这行多线程操作控件
Control.CheckForIllegalCrossThreadCalls = false;
}
public EventFm(string NodeTag, string NodeName, MySQLDBHelper Mysql)
{
_NodeTag = NodeTag;
_NodeName = NodeName;
_Mysql = Mysql;
InitializeComponent();
DataInit();
}
public static void attach(MySQLDBHelper db, string orgId)
{
QuickLoadUtil.attach(db, orgId);//预加载机构相关信息
DataTable dt = db.GetDataTable("SELECT id from acs_doorfbsconfig");
acsCfgList = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
acsCfgList.Add(dt.Rows[i]["id"].ToString());
}
dt.Dispose();
}
//已弃用的执行方法
public virtual new void excute(MySQLDBHelper db)
{
deviceBase.excute(db);
db.ExcuteNoneQuery(buildSqlStr());
if (childList != null && childList.Count > 0)
{
foreach (List <Device> childs in childList)
{
AddDeviceHelper.multiExcute(db, childs);
}
}
Console.WriteLine("====================添加一条数据：" + this.getId());
}
/// <summary>
/// 初始化数据库信息
/// </summary>
public void InitDatabase()
{
if (DataBase == null)
{
DataBase = new MySQLDBHelper();
}
string serverName = ini.ReadValue("Database", "ServerName");
string database = ini.ReadValue("Database", "DataBase");
string logID = ini.ReadValue("Database", "LogID");
string logPass = ini.ReadValue("Database", "LogPass");
DataBase.SetConnectString(serverName, logID, logPass, database);
}
public DataMakerFm(MySQLDBHelper Mysql)
{
try
{
//string a = GetClientLocalIPv4Address();
_Mysql = Mysql;
InitializeComponent();
OrgtreeView.Nodes.Clear();
OrgbindTreeView1();
}
catch (Exception)
{
}
}
public static void attach(MySQLDBHelper db, string orgId)
{
if (curOrg != null && orgId == curOrg.id)
{
return;
}
curOrg = new Organization(orgId);
//获取机构信息
DataTable orgTable = db.GetDataTable("SELECT Code,name from org_Dept WHERE id='" + orgId + "'");
if (orgTable.Rows.Count == 0)
{
return;
}
curOrg.num = orgTable.Rows[0]["Code"].ToString(); //机构编号
curOrg.name = orgTable.Rows[0]["name"].ToString(); //机构名称
orgTable.Dispose();
//获取机构的区域点位信息
areaList = new List <string>();
sitePoints = new List <List <string> >();
//查找机构下的区域
DataTable dt = db.GetDataTable("SELECT id from Institution_area_BaseInfo WHERE jigoumingchen='" + orgId + "'");
for (int i = 0; i < dt.Rows.Count; i++)
{
areaList.Add(dt.Rows[i]["id"].ToString());
}
curOrg.areaList = areaList;
dt.Dispose();
//查找区域下的点位
for (int i = 0; i < areaList.Count; i++)
{
DataTable position = db.GetDataTable("SELECT id from Institution_area_Position WHERE AreaId='" + areaList[i] + "'");
List <string> pointList = new List <string>();
for (int j = 0; j < position.Rows.Count; j++)
{
pointList.Add(dt.Rows[j]["id"].ToString());
}
sitePoints.Add(pointList);
position.Dispose();
}
curOrg.pointList = sitePoints;
}
public static MySQLDBHelper getNewDbHelper()
{
try
{
string ConnectMysql = null;
MySQLDBHelper _Mysql = new MySQLDBHelper();
ConnectMysql = MySQLDBHelper.GetConnectString(ip, user, pwd, basedb);
if (0 == _Mysql.Open(ConnectMysql, null))
{
return(_Mysql);
}
}
catch (Exception ex)
{
Console.WriteLine(StringUtil.buildExceptionInfo(ex));
}
return(null);
}
public new void excute(MySQLDBHelper db)
{
asset.excute(db);
db.ExcuteNoneQuery(buildSqlStr());
Console.WriteLine("====================创建设备基类表数据:id = " + getId());
}
public AddPersonnel(string NodeTag, MySQLDBHelper Mysql)
{
_NodeTag = NodeTag;
_Mysql = Mysql;
InitializeComponent();
}
//多合一insert
public static void multiExcute(MySQLDBHelper db, List <Device> devices)
{
if (devices == null || devices.Count <= 0)
{
return;
}
//父设备列表<子设备种类<子设备列表<子设备>>>
List <List <List <Device> > > allChilds = new List <List <List <Device> > >();
StringBuilder asset = new StringBuilder(devices[0].deviceBase.asset.initHead());
StringBuilder assetState = new StringBuilder(devices[0].deviceBase.asset.state.initHead());
StringBuilder deviceBase = new StringBuilder(devices[0].deviceBase.buildSQLHead());
StringBuilder device = new StringBuilder(devices[0].initHead());
foreach (Device d in devices)
{
asset.Append(d.deviceBase.asset.buildSQLValue() + ",");
assetState.Append(d.deviceBase.asset.state.buildSQLValue() + ",");
deviceBase.Append(d.deviceBase.buildSQLValue() + ",");
device.Append(d.buildSQLValue() + ",");
if (d.getChildList() != null && d.getChildList().Count > 0)
{
allChilds.Add(d.getChildList());
}
}
asset.Remove(asset.Length - 1, 1);
assetState.Remove(assetState.Length - 1, 1);
deviceBase.Remove(deviceBase.Length - 1, 1);
device.Remove(device.Length - 1, 1);
Console.WriteLine("==========excute:-----Asset--------:" + "asset.ToString()");
db.ExcuteNoneQuery(asset.ToString());
Console.WriteLine("==========excute:-----AssetState---:" + "assetState.ToString()");
db.ExcuteNoneQuery(assetState.ToString());
Console.WriteLine("==========excute:-----DeviceBase---:" + "deviceBase.ToString()");
db.ExcuteNoneQuery(deviceBase.ToString());
Console.WriteLine("==========excute:-----Device-------:" + "device.ToString()");
db.ExcuteNoneQuery(device.ToString());
if (allChilds != null && allChilds.Count > 0)
{
Console.WriteLine("====excute:开始添加子设备：设备种类：" + allChilds[0].Count);
//子设备种类<子设备列表<子设备>>
List <List <Device> > allChildDevices = new List <List <Device> >(allChilds[0].Count);
for (int c = 0; c < allChilds[0].Count; c++)
{
allChildDevices.Add(new List <Device>());
}
foreach (List <List <Device> > childDevices in allChilds)
{
for (int i = 0; i < childDevices.Count; i++)
{
allChildDevices[i].AddRange(childDevices[i]);
}
}
int num = 1;
foreach (List <Device> deviceList in allChildDevices)
{
Console.WriteLine("-----添加第" + num++ + "种子设备----");
multiExcute(db, deviceList);
}
Console.WriteLine("==========excute:-----子设备添加完成-------\n\n");
}
}
public new void excute(MySQLDBHelper db)
{
db.ExcuteNoneQuery(buildSqlStr() + ";" + state.buildSqlStr());
Console.WriteLine("====================创建资产及公有附属表数据：资产id = " + getId());
}
static void Main(string[] args)
{
IBase _cb = new IBase();
MySQLDBHelper db = new MySQLDBHelper();
//db.ConnStr = "sl";
List <SLCourse> list = XlsxOpe.ReadSLCourseXlsx(@"C:\Users\admin\Desktop\2017级第2期课表4.16.xlsx", 0, 6, 0, (cname, type) => {
string str = string.Empty;
if (cname.Length < 3)
{
cname = "0" + cname;
}
if (type == "1")//学生
{
DataTable dt = db.ExecuteDataTable("select u.ri_realname,u.ri_studentid,u.ri_realname from map_classes m left join ri_user u on m.ri_classid=u.ri_classid where m.ri_classname='" + cname + "' and m.ri_gradeid='G2017' and m.ri_delflag='0' and u.ri_delflag='0'");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
str += dt.Rows[i][0].ToString() + "/" + dt.Rows[i][1].ToString() + ",";
}
str = str.Substring(0, str.Length - 1);
}
}
if (type == "2")
{
DataTable dt = db.ExecuteDataTable("select u.ri_realname,u.ri_tel from map_classes m left join ri_user u on m.ri_teacher=u.ri_userid where m.ri_classname='" + cname + "' and m.ri_gradeid='G2017' and m.ri_delflag='0' and u.ri_delflag='0'");
if (dt.Rows.Count > 0)
{
str = dt.Rows[0][0].ToString() + "/" + dt.Rows[0][1].ToString();
}
}
return(str);
});
XlsxOpe.WriteXlsxFile(list);
/*XlsxOpe.ReadXlsx1(@"D:\工作夹\单科试卷得分明细表110 - 副本.xls", 1, 2, 0, (rname,ac) =>
* {
* //db.ConnStr = "connStr";
* if (rname == "罗壁嘉华")
* {
* rname = "罗璧嘉华";
* }
* if(rname== "蔡沁坤")
* {
* rname = "花生米";
* }
* if (rname == "陈冠廷")
* {
* rname = "陈冠西";
* }
* if (rname == "赖楚汉")
* {
* rname = "路星河";
* }
* if (rname == "文阅政")
* {
* rname = "文跃帧";
* }
* if (rname == "车林嵘")
* {
* rname = "车";
* }
* if (rname == "高航1"|| rname == "高航2")
* {
* rname = "高航";
* }
* DataTable dt= db.ExecuteDataTable("select ri_examcode,c.RI_ClassName from ri_user u LEFT JOIN map_classes c ON u.RI_ClassId=c.RI_ClassId where ri_realname like '%" + rname+ "%' and u.ri_type='0' and u.ri_gradeid='G2017' and u.ri_delflag='0'");
* if (dt.Rows.Count > 0)
* {
* ac(dt.Rows[0]["RI_ClassName"].ToString());
* if (rname == "高航1")
* {
* return "510117300311";
* }
* if (rname == "高航2")
* {
* return "510117300312";
* }
* return dt.Rows[0]["ri_examcode"].ToString();
* }
* return "";
* });*/
//IBase _cb = new IBase();
//MySQLDBHelper db = new MySQLDBHelper();
////课表数据
//List<Model.Schedule> slist = XlsOperate.ReadXlsxFile(@"D:\asp.net\workspace\2017级第2期课表3.5 - 副本.xlsx");
////教师上课对应班级数据
//List<Model.TeacherCourse> tlist = XlsOperate.ReadXlsxFile1(@"D:\asp.net\workspace\教室上课对应班级表 - 副本 - 副本.xlsx");
////合并数据
//for (int i = 0; i < slist.Count; i++)
//{
// string tname = "";
// if (slist[i].CourseName.IndexOf('/') != -1)
// {
// string[] temp = slist[i].CourseName.Split('/');
// var tc0 = tlist.Find(t => t.ClassName.Equals(slist[i].ClassName) && t.CourseName.Equals(temp[0]));
// var tc1 = tlist.Find(t => t.ClassName.Equals(slist[i].ClassName) && t.CourseName.Equals(temp[1]));
// tname = (tc0 == null ? "" : tc0.TeacherName) + "/" + (tc1 == null ? "" : tc1.TeacherName);
// slist[i].TeacherName = tname;
// if (slist[i].CourseName.IndexOf("数学")!=-1)
// {
// slist[i].CourseName = slist[i].CourseName.Replace("数学", slist[i].SubjectType + "科" + slist[i].CourseName);
// }
// continue;
// }
// var tc = tlist.Find(t => t.ClassName.Equals(slist[i].ClassName) && t.CourseName.Equals(slist[i].CourseName));
// tname = tc == null ? "" : tc.TeacherName;
// slist[i].TeacherName = tname;
// if (slist[i].CourseName == "数学")
// {
// slist[i].CourseName = slist[i].SubjectType + "科" + slist[i].CourseName;
// }
//}
////XlsOperate.WriteXlsxFile(slist);
//DateTime dt = Convert.ToDateTime("2018-3-5");
//DateTime dt1 = Convert.ToDateTime("2018-7-31");
//int flag = 1;
//int type = 1;
//while (dt < dt1)
//{
// List<Model.Map_Coursegroup_Beta> mcblist = GetOneData(GetData(slist, type), dt);
// for (int i = 0; i < mcblist.Count; i++)
// {
// db.ConnStr = "connStr";
// string sql = _cb.InsertModel<Model.Map_Coursegroup_Beta>(mcblist[i]);
// db.ExecuteNonQuery(sql);
// }
// dt = dt.AddDays(1);
// if (flag % 7 == 0)
// {
// type = -type;
// flag = 1;
// }
// else
// {
// flag++;
// }
//}
}
public CascadeFm(MySQLDBHelper Mysql)
{
_Mysql = Mysql;
InitializeComponent();
}
/// <summary>
/// 执行insert操作，已弃用，由AddDeviceHelper统一调度执行
/// </summary>
/// <param name="db"></param>
public virtual void excute(MySQLDBHelper db)
{
db.ExcuteNoneQuery(buildSqlStr());
Console.WriteLine("====================添加一条数据：" + id);
}
public AddAlmDevFm(string NodeTag, MySQLDBHelper Mysql)
{
_NodeTag = NodeTag;
_Mysql = Mysql;
InitializeComponent();
}
