private void btnModify_Click(object sender, EventArgs e)
{
string strFileName = HDLPF.OpenFileDialog("mdb files (*.mdb)|*.mdb", "mdb Files");
if (strFileName == null)
{
return;
}
this.strPath = strFileName;
CsConst.mstrCurPath = strPath;
// lbPathValue.Text = strFileName;
dgOnline.Rows.Clear();
try
{
string strsql = "select * from dbBasicInfo";
OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, strPath);
if (dr != null)
{
while (dr.Read())
{
string strname = dr.GetValue(1).ToString();
int DeviceType = Convert.ToInt32(dr.GetValue(2).ToString());
object[] obj = new object[] { false,
strname.Split('\\')[0].ToString().Split('-')[0].ToString(),
strname.Split('\\')[0].ToString().Split('-')[1].ToString(),
strname.Split('\\')[1].ToString(),
CsConst.mstrINIDefault.IniReadValue("DeviceType" + DeviceType.ToString(), "Description", ""),
CsConst.mstrINIDefault.IniReadValue("DeviceType" + DeviceType.ToString(), "Model", ""),
CsConst.mstrINIDefault.IniReadValue("Public", "99933", ""),
dr.GetValue(0).ToString(), DeviceType.ToString() };
dgOnline.Rows.Add(obj);
}
dr.Close();
}
}
catch
{
}
}
//<summary>
//读取数据库面板设置，将所有数据读至缓存
//</summary>
public override void ReadMS04FrmDBTobuf(int DIndex, int wdMaxValue)
{
base.ReadMS04FrmDBTobuf(DIndex, wdMaxValue);
Chans = new BasicCurtain();
#region
String strsql = string.Format("select * from dbClassInfomation where DIndex={0} and ClassID={1} order by SenNum", DIndex, 1);
OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrCurPath);
if (dr != null)
{
while (dr.Read())
{
string str = dr.GetValue(5).ToString();
Chans.runTime = Convert.ToByte(str.Split('-')[0].ToString());
Chans.onDelay = Convert.ToByte(str.Split('-')[1].ToString());
Chans.offDelay = Convert.ToByte(str.Split('-')[2].ToString());
Chans.remark = dr.GetValue(4).ToString();
}
dr.Close();
}
#endregion
}
///<summary>
///读取数据库面板设置，将所有数据读至缓存
///</summary>
public void ReadHaiInfoFromDB(int DIndex)
{
//read HAI Unit inofomation
units = new List <Unit>();
#region
string str = string.Format("select * from dbKeyTargets where DIndex ={0} and KeyIndex = {1} order by objID", DIndex, 1);
OleDbDataReader drKeyCmds = DataModule.SearchAResultSQLDB(str);
if (drKeyCmds != null)
{
while (drKeyCmds.Read())
{
Unit oTmp = new Unit();
oTmp.bytID = drKeyCmds.GetByte(2);
UVCMD.ControlTargets TmpCmd = new UVCMD.ControlTargets();
oTmp.Command = "^A" + String.Format("{0:D3} ", drKeyCmds.GetByte(2));
TmpCmd.ID = 1;
TmpCmd.Type = drKeyCmds.GetByte(3);
TmpCmd.SubnetID = drKeyCmds.GetByte(4);
TmpCmd.DeviceID = drKeyCmds.GetByte(5);
TmpCmd.Param1 = drKeyCmds.GetByte(6);
TmpCmd.Param2 = drKeyCmds.GetByte(7);
TmpCmd.Param3 = drKeyCmds.GetByte(8);
TmpCmd.Param4 = drKeyCmds.GetByte(9);
oTmp.oUnit = TmpCmd;
units.Add(oTmp);
}
}
#endregion
scen = new List <Scene>();
//read HAI Scene infomation
#region
str = string.Format("select * from dbKeyTargets where DIndex ={0} and KeyIndex = {1} order by objID", DIndex, 2);
drKeyCmds = DataModule.SearchAResultSQLDB(str);
if (drKeyCmds != null)
{
while (drKeyCmds.Read())
{
Scene oTmp = new Scene();
oTmp.bytID = drKeyCmds.GetByte(2);
UVCMD.ControlTargets TmpCmd = new UVCMD.ControlTargets();
oTmp.Command = "^C" + String.Format("{0:D3} ", drKeyCmds.GetByte(2));
TmpCmd.ID = 1;
TmpCmd.Type = drKeyCmds.GetByte(3);
TmpCmd.SubnetID = drKeyCmds.GetByte(4);
TmpCmd.DeviceID = drKeyCmds.GetByte(5);
TmpCmd.Param1 = drKeyCmds.GetByte(6);
TmpCmd.Param2 = drKeyCmds.GetByte(7);
TmpCmd.Param3 = drKeyCmds.GetByte(8);
TmpCmd.Param4 = drKeyCmds.GetByte(9);
oTmp.oUnit = TmpCmd;
scen.Add(oTmp);
}
}
#endregion
buttonstatus = new List <ButtonStatus>();
///read HAI buttonstatus infomation
#region
str = string.Format("select * from dbKeyTargets where DIndex ={0} and KeyIndex = {1} order by objID", DIndex, 3);
drKeyCmds = DataModule.SearchAResultSQLDB(str);
if (drKeyCmds != null)
{
while (drKeyCmds.Read())
{
ButtonStatus oTmp = new ButtonStatus();
oTmp.bytID = drKeyCmds.GetByte(2);
UVCMD.ControlTargets TmpCmd = new UVCMD.ControlTargets();
oTmp.Command = String.Format("{0:D3} ", drKeyCmds.GetByte(2)) + " Button Tab/Press<-->OFF/ON";
TmpCmd.ID = 1;
TmpCmd.Type = drKeyCmds.GetByte(3);
TmpCmd.SubnetID = drKeyCmds.GetByte(4);
TmpCmd.DeviceID = drKeyCmds.GetByte(5);
TmpCmd.Param1 = drKeyCmds.GetByte(6);
TmpCmd.Param2 = drKeyCmds.GetByte(7);
TmpCmd.Param3 = drKeyCmds.GetByte(8);
TmpCmd.Param4 = drKeyCmds.GetByte(9);
oTmp.oUnit = TmpCmd;
buttonstatus.Add(oTmp);
}
}
#endregion
}
//<summary>
//读取数据信息
//</summary>
public void ReadDataFrmDBTobuf(int DIndex)
{
try
{
#region
string strsql = string.Format("select * from dbBasicInfo where DIndex={0}", DIndex);
OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrCurPath);
if (dr != null)
{
while (dr.Read())
{
string str = dr.GetValue(1).ToString();
DeviceName = DeviceName.Split('\\')[0].ToString() + "\\"
+ str.Split('\\')[1].ToString();
}
dr.Close();
}
#endregion
#region
strsql = string.Format("select * from dbClassInfomation where DIndex={0} and ClassID=0 order by SenNum", DIndex);
dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrCurPath);
if (dr != null)
{
while (dr.Read())
{
string str = dr.GetValue(5).ToString();
Backlight = Convert.ToByte(str.Split('-')[0].ToString());
Ledlight = Convert.ToByte(str.Split('-')[1].ToString());
arayButtonColor = (byte[])dr[6];
arayButtonBalance = (byte[])dr[7];
arayButtonSensitiVity = (byte[])dr[8];
arayHotel = (byte[])dr[9];
}
dr.Close();
}
#endregion
#region
strsql = string.Format("select * from dbClassInfomation where DIndex={0} and ClassID={1} order by SenNum", DIndex, 1);
dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrCurPath);
myKeySetting = new List <Key>();
if (dr != null)
{
while (dr.Read())
{
Key temp = new Key();
string str = dr.GetValue(5).ToString();
temp.ID = Convert.ToByte(str.Split('-')[0].ToString());
temp.Mode = Convert.ToByte(str.Split('-')[1].ToString());
temp.Delay = Convert.ToByte(str.Split('-')[2].ToString());
temp.Remark = dr.GetValue(4).ToString();
str = string.Format("select * from dbKeyTargets where DIndex ={0} and KeyIndex = {1} and Ms04State = {2}", DIndex, temp.ID, 0);
OleDbDataReader drKeyCmds = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath);
temp.KeyTargets = new List <UVCMD.ControlTargets>();
while (drKeyCmds.Read())
{
UVCMD.ControlTargets TmpCmd = new UVCMD.ControlTargets();
TmpCmd.ID = drKeyCmds.GetByte(2);
TmpCmd.Type = drKeyCmds.GetByte(3);
TmpCmd.SubnetID = drKeyCmds.GetByte(4);
TmpCmd.DeviceID = drKeyCmds.GetByte(5);
TmpCmd.Param1 = drKeyCmds.GetByte(6);
TmpCmd.Param2 = drKeyCmds.GetByte(7);
TmpCmd.Param3 = drKeyCmds.GetByte(8);
TmpCmd.Param4 = drKeyCmds.GetByte(9);
temp.KeyTargets.Add(TmpCmd);
}
drKeyCmds.Close();
myKeySetting.Add(temp);
}
dr.Close();
}
#endregion
}
catch
{
}
}
//<summary>
//读取数据库面板设置，将所有数据读至缓存
//</summary>
public void ReadSecurityFrmDBTobuf(int DIndex)
{
if (LogicPos == null)
{
LogicPos = new byte[50]; //存储位置经纬度
}
if (MyDesign == null)
{
MyDesign = new LogicBlock[12]; //十二个逻辑块设置
}
//读取经纬度
#region
string str = string.Format("select * from dbLogic where DIndex={0}", DIndex);
OleDbDataReader dr = DataModule.SearchAResultSQLDB(str);
if (dr != null)
{
while (dr.Read())
{
LogicPos = (byte[])dr[1];
LogicSummerTime = (byte[])dr[2];
DateTimeAry = (byte[])dr[3];
isBroadcastTime = (bool)dr[4];
}
dr.Close();
}
#endregion
for (int intI = 1; intI <= 12; intI++)
{
MyDesign[intI - 1] = new LogicBlock();
//读取基本信息
#region
str = string.Format("select * from dbLogicTable where DIndex={0}", DIndex);
dr = DataModule.SearchAResultSQLDB(str);
if (dr != null)
{
while (dr.Read())
{
MyDesign[intI - 1].Remark = dr.GetString(1);
MyDesign[intI - 1].TableIDs = (byte[])dr[2];
MyDesign[intI - 1].MyPins = new List <byte[]>();
MyDesign[intI - 1].Remarks = (string[])dr[3];
for (byte bytI = 0; bytI < 12; bytI++)
{
byte[] Tmp = (byte[])dr[4 + bytI];
if (Tmp != null)
{
MyDesign[intI - 1].MyPins.Add(Tmp);
}
}
}
}
#endregion
//读取目标设置
#region
MyDesign[intI - 1].ArmCmds = new List <UVCMD.ControlTargets> [20];
str = string.Format("select * from dbKeyTargets where DIndex ={0} and KeyIndex = {1} and Ms04State >= 1 and Ms04State <= 20 order by objID", DIndex, intI);
OleDbDataReader drKeyCmds = DataModule.SearchAResultSQLDB(str);
if (drKeyCmds != null)
{
while (drKeyCmds.Read())
{
int intIndex = drKeyCmds.GetInt16(10); //对应逻辑表号
UVCMD.ControlTargets TmpCmd = new UVCMD.ControlTargets();
TmpCmd.ID = drKeyCmds.GetByte(2);
TmpCmd.Type = drKeyCmds.GetByte(3);
TmpCmd.SubnetID = drKeyCmds.GetByte(4);
TmpCmd.DeviceID = drKeyCmds.GetByte(5);
TmpCmd.Param1 = drKeyCmds.GetByte(6);
TmpCmd.Param2 = drKeyCmds.GetByte(7);
TmpCmd.Param3 = drKeyCmds.GetByte(8);
TmpCmd.Param4 = drKeyCmds.GetByte(9);
TmpCmd.Hint = drKeyCmds.GetString(11);
if (MyDesign[intI - 1].ArmCmds[intIndex - 1] == null)
{
MyDesign[intI - 1].ArmCmds[intIndex - 1] = new List <UVCMD.ControlTargets>();
}
MyDesign[intI - 1].ArmCmds[intIndex - 1].Add((UVCMD.ControlTargets)TmpCmd);
}
drKeyCmds.Close();
}
#endregion
}
}
///<summary>
///读取数据库面板设置，将所有数据读至缓存
///</summary>
public void ReadSensorInfoFromDB(int DIndex)
{
//read GPRS Info
#region
string str = string.Format("select * from dbGPRSbasic where DIndex={0}", DIndex);
OleDbDataReader dr = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath);
if (dr == null)
{
return;
}
while (dr.Read())
{
strIP = dr.GetString(1);
strRouterIP = dr.GetString(2);
strMAC = dr.GetString(3);
strSevCentre = dr.GetString(4);
strCode = dr.GetString(5);
strIMEI = dr.GetString(6);
blnTo485 = dr.GetBoolean(7);
}
dr.Close();
#endregion
//read GPRS Control Info
#region
MyControls = new List <SMSControls>();
str = string.Format("select * from dbGPRSControls where DIndex={0} order by SenNum", DIndex);
dr = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath);
if (dr != null)
{
while (dr.Read())
{
SMSControls temp = new SMSControls();
temp.MyVerify = new List <PhoneInF>();
temp.MyTargets = new List <UVCMD.ControlTargets>();
temp.ID = dr.GetInt16(1);
temp.strRemark = dr.GetString(2);
temp.strSMSContent = dr.GetString(3);
temp.blnIsVerify = dr.GetBoolean(4);
temp.blnReply = dr.GetBoolean(5);
#region
if (temp.blnIsVerify == true)
{
str = string.Format("select * from dbGPRSVerify where DIndex={0} and SenNum ={1} order by VerifyNum", DIndex, temp.ID);
OleDbDataReader drVerify = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath);
if (drVerify != null)
{
while (drVerify.Read())
{
PhoneInF tmp = new PhoneInF();
tmp.ID = drVerify.GetInt16(2);
tmp.Remark = drVerify.GetString(3);
tmp.PhoneNum = drVerify.GetString(4);
temp.MyVerify.Add(tmp);
}
drVerify.Close();
}
}
#endregion
str = string.Format("select * from dbKeyTargets where DIndex ={0} and KeyIndex = {1} order by objID", DIndex, temp.ID);
OleDbDataReader drKeyCmds = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath);
if (drKeyCmds != null)
{
while (drKeyCmds.Read())
{
UVCMD.ControlTargets TmpCmd = new UVCMD.ControlTargets();
TmpCmd.ID = drKeyCmds.GetByte(2);
TmpCmd.Type = drKeyCmds.GetByte(3);
TmpCmd.SubnetID = drKeyCmds.GetByte(4);
TmpCmd.DeviceID = drKeyCmds.GetByte(5);
TmpCmd.Param1 = drKeyCmds.GetByte(6);
TmpCmd.Param2 = drKeyCmds.GetByte(7);
TmpCmd.Param3 = drKeyCmds.GetByte(8);
TmpCmd.Param4 = drKeyCmds.GetByte(9);
temp.MyTargets.Add(TmpCmd);
}
drKeyCmds.Close();
MyControls.Add(temp);
}
}
dr.Close();
}
#endregion
//read GPRS SMS Send Info
#region
MySendSMS = new List <SendSMS>();
str = string.Format("select * from dbGPRSSendSMS where DIndex = {0} order by SenNum", DIndex);
dr = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath);
if (dr != null)
{
while (dr.Read())
{
SendSMS temp = new SendSMS();
temp.MyGuests = new List <PhoneInF>();
temp.ID = dr.GetInt16(1);
temp.strRemark = dr.GetString(2);
str = string.Format("select * from dbGPRSSendSMSInfo where DIndex={0} and SenNum ={1} order by TargetNum", DIndex, temp.ID);
OleDbDataReader drSend = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath);
if (drSend != null)
{
while (drSend.Read())
{
PhoneInF tmp = new PhoneInF();
tmp.ID = drSend.GetInt16(2);
tmp.Remark = drSend.GetString(3);
tmp.PhoneNum = drSend.GetString(4);
tmp.strSMS = drSend.GetString(5);
temp.MyGuests.Add(tmp);
}
drSend.Close();
}
MySendSMS.Add(temp);
}
dr.Close();
}
#endregion
}