//<summary> //读取数据库里的HVAC的设置,将所有数据读取缓存 //</summary> public void ReadInfoForDB(int id) { //read all channels information save them to the buffer string str = "select * from dbHVAC where DIndex=" + id.ToString(); OleDbDataReader dr = DataModule.SearchAResultSQLDB(str); if (dr.HasRows) { while (dr.Read()) { bytAutoRun = dr.GetByte(1); bytModeONDelay = dr.GetByte(2); // 模式,风速开关延迟 bytModeOFFDelay = dr.GetByte(3); bytFanONDelay = dr.GetByte(4); bytFanOFFDelay = dr.GetByte(5); bytCOrP = dr.GetByte(6); //电压还是电流输出 bytHigh = dr.GetByte(7); bytMid = dr.GetByte(8); bytLow = dr.GetByte(9); bytSteps = (byte[])dr[10]; } } dr.Close(); }
public static void SaveAllGroupCommandsFrmDatabase() { string str = string.Format("delete * from dbGrpRemark"); DataModule.ExecuteSQLDatabase(str); str = string.Format("delete * from dbGrpCMD"); DataModule.ExecuteSQLDatabase(str); if (CsConst.myTemplates == null) { return; } ////read keys commands to buffer foreach (ControlTemplates oTmp in CsConst.myTemplates) { if (oTmp.GpCMD != null) { string strsql = string.Format("Insert into dbGrpRemark(GrpID,Remark,bytType,bytGpID) values ({0},'{1}',{2},{3})", oTmp.ID, oTmp.Name, oTmp.bytType, oTmp.bytGpID); DataModule.ExecuteSQLDatabase(strsql); for (int i = 0; i < oTmp.GpCMD.Count; i++) { UVCMD.ControlTargets TmpCmds = oTmp.GpCMD[i]; ///// insert into all commands to database strsql = string.Format("Insert into dbGrpCMD(GrpID,objID,KeyFunType,SubNetID,DeviceID,FirstParameter," + "SecondParameter,RunTimeMinute,RunTimeSecond,strHint,Default1) values ({0},{1},{2},{3},{4},{5},{6},{7},{8},'{9}',{10})", oTmp.ID, TmpCmds.ID, TmpCmds.Type, TmpCmds.SubnetID, TmpCmds.DeviceID, TmpCmds.Param1, TmpCmds.Param2, TmpCmds.Param3, TmpCmds.Param4, TmpCmds.Hint, oTmp.bytType); DataModule.ExecuteSQLDatabase(strsql); } } } }
public static bool SaveDatatoDB() { bool result = true; int test = -1; try { if (CsConst.WholeTextsList == null || CsConst.WholeTextsList.Count <= 0) { return(true); } string strsql = ""; foreach (FormDisplayTextList temp in CsConst.WholeTextsList) { // check if it has already exist, if yes ,save to ini #region test = temp.iIndexInWholeList; strsql = string.Format("insert into dbLanguaText(TextIndex,TextLength,English) values ({0},{1},'{2}')", temp.iIndexInWholeList, temp.sMaxLimit, temp.sDisplayName); DataModule.ExecuteSQLDatabase(strsql); #endregion } } catch { MessageBox.Show(test.ToString()); result = false; } return(result); }
public static void LoadButtonCoontrolTypeFromDatabaseToPublicClass() { CsConst.WholeTextsList = new List <FormDisplayTextList>(); try { string strsql = string.Format("select * from dbLanguaText order by TextIndex"); OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrDefaultPath); if (dr != null) { while (dr.Read()) { FormDisplayTextList TmpButtonMode = new FormDisplayTextList(); TmpButtonMode.iIndexInWholeList = dr.GetInt32(0); TmpButtonMode.sMaxLimit = dr.GetInt32(1); if (dr.GetString(CsConst.iLanguageId + 2) != null) { TmpButtonMode.sDisplayName = dr.GetString(CsConst.iLanguageId + 2); } CsConst.WholeTextsList.Add(TmpButtonMode); } dr.Close(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
//<summary> //读取数据库里的调光模块的设置,将所有数据读取缓存 //</summary> public void ReadInfoForDB(int id) { Chans = new List <Chn>(); //read all channels information save them to the buffer string str = "select * from dbTempSensor where DIndex=" + id.ToString() + " order by ChnID"; OleDbDataReader dr = DataModule.SearchAResultSQLDB(str); if (dr.HasRows) { while (dr.Read()) { Chn Tmp = new Chn(); Tmp.bytTheType = dr.GetByte(2); Tmp.bytRValue = new byte[6]; Tmp.bytRValue[0] = byte.Parse((dr.GetInt16(3) / 256).ToString()); Tmp.bytRValue[1] = byte.Parse((dr.GetInt16(3) % 256).ToString()); Tmp.bytRValue[2] = byte.Parse((dr.GetInt16(4) / 256).ToString()); Tmp.bytRValue[3] = byte.Parse((dr.GetInt16(4) % 256).ToString()); Tmp.bytRValue[4] = byte.Parse((dr.GetInt16(5) / 256).ToString()); Tmp.bytRValue[5] = byte.Parse((dr.GetInt16(5) % 256).ToString()); Tmp.blnBroadTemp = dr.GetBoolean(6); Tmp.bytSubID = dr.GetByte(7); Tmp.bytDevID = dr.GetByte(8); Tmp.byAdjustVal = dr.GetByte(9); Chans.Add(Tmp); } } dr.Close(); }
private void btnReName_Click(object sender, EventArgs e) { if (tvEdit.SelectedNode == null) { return; } if (tvEdit.SelectedNode.Level == 0) { return; } if (tbRemark1.Text == null || tbRemark1.Text == "") { return; } string strDevice = tvEdit.SelectedNode.Parent.Text; string strOldRemark = tvEdit.SelectedNode.Text; string strNewRemark = tbRemark1.Text; //更新到数据库 string strsql = string.Format("update tblRemoteCode set Remark='{0}' where ID={1} and RemoteDeviceID = {2} and Remark='{3}'", strNewRemark, tvEdit.SelectedNode.Name, tvEdit.SelectedNode.Parent.Name, strOldRemark); DataModule.ExecuteSQLDatabase(strsql); }
//<summary> //读取数据信息 //</summary> public void ReadDataFrmDBTobuf(int DIndex) { try { #region string strsql = string.Format("select * from dbClassInfomation where DIndex={0} and ClassID={1} order by SenNum", DIndex, 0); OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrCurPath); myACSetting = new List<ThirdPartAC>(); if (dr != null) { while (dr.Read()) { ThirdPartAC temp = new ThirdPartAC(); string str = dr.GetValue(5).ToString(); temp.ID = Convert.ToByte(str.Split('-')[0].ToString()); temp.Enable = Convert.ToByte(str.Split('-')[1].ToString()); temp.ACNO = Convert.ToByte(str.Split('-')[2].ToString()); temp.CoolMasterAddress = Convert.ToByte(str.Split('-')[3].ToString()); temp.GroupID = Convert.ToByte(str.Split('-')[4].ToString()); temp.arayACinfo = (byte[])dr[6]; temp.Remark = dr.GetValue(4).ToString(); myACSetting.Add(temp); } dr.Close(); } #endregion } catch { } }
public String ModeName; //中文 public static void LoadButtonModeFromDatabaseToPublicClass() { CsConst.myPublicButtonMode = new List <ButtonMode>(); string strsql = string.Format("select * from defKeyMode order by KeyModeNO"); OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrDefaultPath); if (dr != null) { while (dr.Read()) { ButtonMode TmpButtonMode = new ButtonMode(); TmpButtonMode.ModeOrder = (Byte)(dr.GetInt16(0)); TmpButtonMode.ModeSaveID = (Byte)(dr.GetInt16(1)); if (CsConst.iLanguageId == 0) // { TmpButtonMode.ModeName = dr.GetString(3); } else { TmpButtonMode.ModeName = dr.GetString(2); } CsConst.myPublicButtonMode.Add(TmpButtonMode); } dr.Close(); } }
private void btnDel_Click(object sender, EventArgs e) { if (tvEdit.SelectedNode == null) { return; } TreeNode oTmp = tvEdit.SelectedNode; if (oTmp.Level == 0 && (oTmp.Nodes == null || oTmp.Nodes.Count == 0)) // 如果是设备 而且本身没有任何红外码 可以直接移除 { oTmp.Remove(); // 删除当前全部类 string strsql = string.Format("Delete from tblRemoteDevice where ID = {0}", oTmp.Name); DataModule.ExecuteSQLDatabase(strsql); } else if (oTmp.Level == 1) // 如果设备中的其中一个红外码 可以直接删除 { string strDevice = oTmp.Parent.Text; string strOldRemark = oTmp.Text; string strInsert = string.Format("Delete from tblRemoteCode where ID = {0} and RemoteDeviceID = {1} and Remark = '{2}'", oTmp.Name, oTmp.Parent.Name, strOldRemark); DataModule.ExecuteSQLDatabase(strInsert); oTmp.Remove(); } }
//<summary> //保存数据库面板设置,将所有数据保存 //</summary> public override void SaveSendIRToDB(int intDeviceType) { base.SaveSendIRToDB(intDeviceType); int wdMaxValue = DeviceTypeList.GetMaxValueFromPublicModeGroup(intDeviceType); Chans = new List <DimmerChannelGenerationTwo>(); for (int i = 0; i < wdMaxValue; i++) { DimmerChannel oChan = Chans[i]; string str = ""; string chid = "", remark = "", loadType = "", MinValue = "", MaxValue = "", MaxLevel = ""; string temp = "", Belongs = ""; if (Chans == null) { return; } temp = "-"; chid += "1" + temp; remark += oChan.remark + temp; loadType += oChan.loadType.ToString() + temp; MinValue += oChan.minValue.ToString() + temp; MaxValue += oChan.maxValue.ToString() + temp; MaxLevel += oChan.maxLevel.ToString() + temp; Belongs += oChan.belongArea.ToString() + temp; str = "insert into dbDevChnsDR(ID,ChannelID,Remark,LoadType,Low,High,MaxValue,AreaID) values(" + "1".ToString() + ",'" + chid + "','" + remark + "','" + loadType + "','" + MinValue + "','" + MaxValue + "','" + MaxLevel + "','" + Belongs + "')"; DataModule.ExecuteSQLDatabase(str); } }
//<summary> //读取数据库面板设置,将所有数据读至缓存 //</summary> public override void ReadMS04FrmDBTobuf(int DIndex, int wdMaxValue) { base.ReadMS04FrmDBTobuf(DIndex, wdMaxValue); Chans = new List <RelayChannel>(); #region //read all channels information save them to the buffer string strsql = "select * from dbDevChnsDR where ID=" + DIndex.ToString() + " order by ChannelID"; OleDbDataReader drChns = DataModule.SearchAResultSQLDB(strsql); if (drChns != null && drChns.HasRows) { drChns.Read(); string[] chanID = drChns.GetString(1).Split('-'); string[] remark = drChns.GetString(2).Split('-'); string[] loadType = drChns.GetString(3).Split('-'); string[] MinValue = drChns.GetString(4).Split('-'); string[] MaxValue = drChns.GetString(5).Split('-'); string[] MaxLevel = drChns.GetString(6).Split('-'); string[] Belongs = drChns.GetString(7).Split('-'); //回路 for (int i = 0; i < chanID.Length; i++) { RelayChannel Ch = new RelayChannel(); Ch.Remark = remark[0]; Ch.LoadType = int.Parse(loadType[0]); Ch.OnDelay = int.Parse(MinValue[0]); Ch.ProtectDelay = int.Parse(MaxValue[0]); Chans.Add(Ch); drChns.Close(); } } #endregion }
public String ControlTypeName; //中文 public static void LoadButtonCoontrolTypeFromDatabaseToPublicClass() { CsConst.myDryGroupControlType = new List <DryControlType>(); string strsql = string.Format("select * from defGroupMemberType order by ID"); OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrDefaultPath); if (dr != null) { while (dr.Read()) { DryControlType TmpButtonMode = new DryControlType(); TmpButtonMode.ControlTypeSaveID = (Byte)dr.GetInt32(0); if (CsConst.iLanguageId == 1) { TmpButtonMode.ControlTypeName = dr.GetString(1); } else { TmpButtonMode.ControlTypeName = dr.GetString(2); } CsConst.myDryGroupControlType.Add(TmpButtonMode); } dr.Close(); } }
//<summary> //读取数据库面板设置,将所有数据读至缓存 //</summary> public override void ReadMS04FrmDBTobuf(int DIndex, int wdMaxValue) { base.ReadMS04FrmDBTobuf(DIndex, wdMaxValue); Chans = new List <DimmerChannelGenerationTwo>(); #region //read all channels information save them to the buffer string strsql = "select * from dbDevChnsDR where ID=" + DIndex.ToString() + " order by ChannelID"; OleDbDataReader drChns = DataModule.SearchAResultSQLDB(strsql); if (drChns != null && drChns.HasRows) { drChns.Read(); string[] chanID = drChns.GetString(1).Split('-'); string[] remark = drChns.GetString(2).Split('-'); string[] loadType = drChns.GetString(3).Split('-'); string[] MinValue = drChns.GetString(4).Split('-'); string[] MaxValue = drChns.GetString(5).Split('-'); string[] MaxLevel = drChns.GetString(6).Split('-'); string[] Belongs = drChns.GetString(7).Split('-'); drChns.Close(); } #endregion }
//<summary> //保存数据库面板设置,将所有数据保存 //</summary> public override void SaveSendIRToDB(int intDeviceType) { base.SaveSendIRToDB(intDeviceType); //insert new channel information if (Chans != null) { #region string str = ""; string chid = "", remark = "", loadType = "", MinValue = "", MaxValue = "", MaxLevel = ""; string temp = "", Belongs = ""; byte bytI = 0; foreach (RelayChannel ch in Chans) { chid += bytI.ToString() + temp; remark += ch.Remark + temp; loadType += ch.LoadType.ToString() + temp; MinValue += ch.OnDelay.ToString() + temp; MaxValue += ch.ProtectDelay.ToString() + temp; bytI++; } str = "insert into dbDevChnsDR(ID,ChannelID,Remark,LoadType,Low,High,MaxValue,AreaID) values(" + DIndex.ToString() + ",'" + chid + "','" + remark + "','" + loadType + "','" + MinValue + "','" + MaxValue + "','" + MaxLevel + "','" + Belongs + "')"; DataModule.ExecuteSQLDatabase(str); #endregion } }
//<summary> //读取IP设置,将所有数据读至缓存 //</summary> public void ReadCurtainFrmDBTobuf(int intDIndex) { // read current device type new or old one string str = "select * from dbIPModule where DIndex=" + intDIndex.ToString(); OleDbDataReader dr = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath); if (dr == null) { return; } if (dr.HasRows) { while (dr.Read()) { bytWorkType = dr.GetByte(5); //0 局域网,1 p2p, 2 server strGroup = dr.GetString(6); strPrjName = dr.GetString(7); strUser = dr.GetString(8); strPWD = dr.GetString(9); strServer1 = dr.GetString(10); intPort1 = dr.GetInt32(11); strServer2 = dr.GetString(12); intPort2 = dr.GetInt32(13); bytTimer = dr.GetByte(14); bytEnDHCP = dr.GetByte(15); } dr.Close(); } }
///<summary> ///保存数据库面板设置,将所有数据保存 ///</summary> public void SaveDevieceInfoToDB() { /// delete all old information and refresh the database string strsql = string.Format("delete from dbBasicBac where DIndex={0}", DIndex); DataModule.ExecuteSQLDatabase(strsql); strsql = string.Format("delete from dbBackNet where DIndex={0}", DIndex); DataModule.ExecuteSQLDatabase(strsql); ///save save basic setup of EIB #region strsql = string.Format("insert into dbBasicBac(DIndex,Remark,strIP,strRouterIP,strMAC,strMaskIP,bytPort,bytSwitch,bytDevID) values({0},'{1}','{2}','{3}','{4}','{5}',{6},{7},{8})", DIndex, DeviceName, "", "", "", ValidCount.ToString(), intPort, Convert.ToByte(blnSwitch), Address); DataModule.ExecuteSQLDatabase(strsql); #endregion //save bus to EIB command #region if (otherInfo == null) { return; } byte bytI = 0; for (int i = 0; i < otherInfo.Count; i++) { bytI++; OtherInfo temp = otherInfo[i]; System.Diagnostics.Debug.WriteLine(otherInfo[1].Param4); string sql = "insert into dbBackNet(DIndex,CurNo,BackNetIDAry,Type,strDevName,Param1,Param2,Param3,Param4,Remark) values(@DIndex,@CurNo,@BackNetIDAry,@Type,@strDevName,@Param1,@Param2,@Param3,@Param4,@Remark)"; //创建一个OleDbConnection对象 OleDbConnection conn; conn = new OleDbConnection(DataModule.ConString + CsConst.mstrDefaultPath); conn.Open(); OleDbCommand cmdTmp = new OleDbCommand(sql, conn); ((OleDbParameter)cmdTmp.Parameters.Add("@DIndex", OleDbType.Integer)).Value = DIndex; ((OleDbParameter)cmdTmp.Parameters.Add("@CurNo", OleDbType.Char)).Value = temp.ID; ((OleDbParameter)cmdTmp.Parameters.Add("@BackNetIDAry", OleDbType.Binary)).Value = temp.BackNetIDAry; ((OleDbParameter)cmdTmp.Parameters.Add("@Type", OleDbType.Integer)).Value = temp.Type; ((OleDbParameter)cmdTmp.Parameters.Add("@strDevName", OleDbType.VarChar)).Value = temp.strDevName; ((OleDbParameter)cmdTmp.Parameters.Add("@Param1", OleDbType.Char)).Value = temp.Param1; ((OleDbParameter)cmdTmp.Parameters.Add("@Param2", OleDbType.Char)).Value = temp.Param2; ((OleDbParameter)cmdTmp.Parameters.Add("@Param3", OleDbType.Char)).Value = temp.Param3; ((OleDbParameter)cmdTmp.Parameters.Add("@Param4", OleDbType.Char)).Value = temp.Param4; ((OleDbParameter)cmdTmp.Parameters.Add("@Remark", OleDbType.VarChar)).Value = temp.Remark; try { cmdTmp.ExecuteNonQuery(); } catch (OleDbException exp) { MessageBox.Show(exp.ToString()); } conn.Close(); } #endregion }
///<summary> ///保存数据库面板设置,将所有数据保存 ///</summary> public void SaveDevieceInfoToDB(int DIndex) { /// delete all old information and refresh the database string strsql = string.Format("delete from dbDeviceInfo where DIndex={0}", DIndex); DataModule.ExecuteSQLDatabase(strsql); strsql = string.Format("delete from dbEIBDev where DIndex={0}", DIndex); DataModule.ExecuteSQLDatabase(strsql); ///save save basic setup of EIB #region strsql = string.Format("insert into dbDeviceInfo(DIndex,Devname,Address) values({0},'{1}','{2}')", DIndex, Devname, Address); DataModule.ExecuteSQLDatabase(strsql); #endregion //save bus to EIB command #region if (otherInfo == null) { return; } byte bytI = 0; for (int i = 0; i < otherInfo.Count; i++) { bytI++; OtherInfo temp = otherInfo[i]; System.Diagnostics.Debug.WriteLine(otherInfo[1].Param4); string sql = "insert into dbEIBDev(DIndex,CurNo,GroupAddress,ControlType,Type,Param1,Param2,Param3,Param4,DestDev) values(@DIndex,@CurNo,@GroupAddress,@ControlType,@Type,@Param1,@Param2,@Param3,@Param4,@DestDev)"; //创建一个OleDbConnection对象 OleDbConnection conn; conn = new OleDbConnection(DataModule.ConString + CsConst.mstrDefaultPath); conn.Open(); OleDbCommand cmdTmp = new OleDbCommand(sql, conn); ((OleDbParameter)cmdTmp.Parameters.Add("@DIndex", OleDbType.Integer)).Value = DIndex; ((OleDbParameter)cmdTmp.Parameters.Add("@CurNo", OleDbType.Char)).Value = i; ((OleDbParameter)cmdTmp.Parameters.Add("@GroupAddress", OleDbType.VarChar)).Value = temp.GroupAddress; ((OleDbParameter)cmdTmp.Parameters.Add("@ControlType", OleDbType.Char)).Value = temp.ControlType; ((OleDbParameter)cmdTmp.Parameters.Add("@Type", OleDbType.Char)).Value = temp.Type; ((OleDbParameter)cmdTmp.Parameters.Add("@Param1", OleDbType.Char)).Value = temp.Param1; ((OleDbParameter)cmdTmp.Parameters.Add("@Param2", OleDbType.Char)).Value = temp.Param2; ((OleDbParameter)cmdTmp.Parameters.Add("@Param3", OleDbType.Char)).Value = temp.Param3; ((OleDbParameter)cmdTmp.Parameters.Add("@Param4", OleDbType.Char)).Value = temp.Param4; ((OleDbParameter)cmdTmp.Parameters.Add("@DestDev", OleDbType.VarChar)).Value = temp.strDevName; try { cmdTmp.ExecuteNonQuery(); } catch (OleDbException exp) { MessageBox.Show(exp.ToString()); } conn.Close(); } #endregion }
public String sSimpleFunctionList; // 简易功能分解列表 public static void LoadButtonCoontrolTypeFromDatabaseToPublicClass() { CsConst.myDeviceTypeLists = new List <DeviceTypeList>(); try { string strsql = string.Format("select * from defDeviceType order by DeviceType"); OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrDefaultPath); if (dr != null) { while (dr.Read()) { DeviceTypeList TmpButtonMode = new DeviceTypeList(); TmpButtonMode.DeviceType = dr.GetInt32(0); if (dr.GetString(1) != null) { TmpButtonMode.sModelChn = dr.GetString(1); } if (dr.GetString(2) != null) { TmpButtonMode.sModelEng = dr.GetString(2); } if (CsConst.iLanguageId == 1) { TmpButtonMode.DeviceName = dr.GetString(3); if (TmpButtonMode.DeviceName.Contains('(')) { TmpButtonMode.DeviceName = TmpButtonMode.DeviceName.Split('(')[0].ToString(); } } else { TmpButtonMode.DeviceName = dr.GetString(4); } TmpButtonMode.iMaxValue = dr.GetInt32(5); if (TmpButtonMode.DeviceType >= 60000) { dr.Close(); return; } else { if (dr.GetString(13) != null) { TmpButtonMode.sSimpleFunctionList = (String)dr.GetString(13); } } CsConst.myDeviceTypeLists.Add(TmpButtonMode); } dr.Close(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
///<summary> ///读取数据库面板设置,将所有数据读至缓存 ///</summary> public void ReadDevieceInfoFromDB(int intDIndex) { //read basic information of bacnet #region string str = "select * from dbBasicBac where DIndex=" + intDIndex.ToString(); OleDbDataReader dr = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath); if (dr == null) { return; } if (dr.HasRows) { while (dr.Read()) { DeviceName = dr.GetString(1); ValidCount = Convert.ToInt32(dr.GetValue(5).ToString()); intPort = dr.GetInt16(6); blnSwitch = (dr.GetByte(7) == 1); Address = dr.GetInt16(8); } dr.Close(); } #endregion //read bacnet to bus #region str = string.Format("select * from dbBackNet where DIndex={0}", intDIndex); dr = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath); otherInfo = new List <OtherInfo>(); if (dr == null) { return; } while (dr.Read()) { OtherInfo tmp = new OtherInfo(); tmp.ID = dr.GetByte(1); tmp.BackNetIDAry = (byte[])dr[2]; tmp.Type = dr.GetInt32(3); tmp.strDevName = dr.GetString(4); tmp.Param1 = dr.GetByte(5); tmp.Param2 = dr.GetByte(6); tmp.Param3 = dr.GetByte(7); tmp.Param4 = dr.GetByte(8); tmp.Remark = dr.GetString(9); otherInfo.Add(tmp); } dr.Close(); #endregion }
//<summary> //保存IP设置,将所有数据保存 //</summary> public void SaveCurtainToDB() { //// delete all old information and refresh the database string strsql = string.Format("delete * from dbIPModule where DIndex=" + DIndex.ToString()); DataModule.ExecuteSQLDatabase(strsql); //// insert curtain Type //strsql = string.Format("insert into dbIPModule(DIndex,strIP,strRouterIP,strMaskIP,strMAC,bytWorkType,strGroup,strPrjName,strUser,strPWD,strServer1,intPort1,strServer2,intPort2," // + "bytTimer,bytEnDHCP ) values({0},'{1}','{2}','{3}','{4}',{5},'{6}','{7}','{8}','{9}','{10}',{11},'{12}',{13},{14},{15})", DIndex,strIP,strRouterIP,strMaskIP,strMAC, // bytWorkType,strGroup,strPrjName,strUser,strPWD,strServer1,intPort1,strServer2,intPort2,bytTimer,bytEnDHCP); //DataModule.ExecuteSQLDatabase(strsql); }
//<summary> //读取数据库面板设置,将所有数据读至缓存 //</summary> public void ReadIRcodesFrmDBTobuf(int DIndex) { try { #region string strsql = string.Format("select * from dbClassInfomation where DIndex={0} and ClassID={1} order by SenNum", DIndex, 0); OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrCurPath); if (dr != null) { while (dr.Read()) { string str = dr.GetValue(5).ToString(); RemoteEnable = Convert.ToByte(str.Split('-')[0].ToString()); mbytOne = Convert.ToByte(str.Split('-')[1].ToString()); mbytTwo = Convert.ToByte(str.Split('-')[2].ToString()); string strRemark = dr.GetValue(4).ToString(); strName = strName.Split('\\')[0].ToString() + "\\" + strRemark; } 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); IRCodes = new List <UVCMD.IRCode>(); if (dr != null) { while (dr.Read()) { string strRemark = dr.GetValue(4).ToString(); string str = dr.GetValue(5).ToString(); UVCMD.IRCode temp = new UVCMD.IRCode(); temp.KeyID = Convert.ToInt32(str.Split('-')[0].ToString()); temp.IRLength = Convert.ToInt32(str.Split('-')[1].ToString()); temp.IRLoation = Convert.ToInt32(str.Split('-')[2].ToString()); temp.Enable = Convert.ToByte(str.Split('-')[3].ToString()); temp.Codes = str.Split('-')[4].ToString(); temp.Remark1 = strRemark; IRCodes.Add(temp); } dr.Close(); } #endregion } catch { } }
//<summary> //读取数据库面板设置,将所有数据读至缓存 //</summary> public void ReadCurtainFrmDBTobuf(int intDIndex) { try { #region string strsql = string.Format("select * from dbClassInfomation where DIndex={0} and ClassID={1} order by SenNum", DIndex, 0); OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrCurPath); if (dr != null) { while (dr.Read()) { string str = dr.GetValue(5).ToString(); bytCurType = Convert.ToByte(str.Split('-')[0].ToString()); intJogTime = Convert.ToByte(str.Split('-')[1].ToString()); intJogTime1 = Convert.ToByte(str.Split('-')[2].ToString()); bytInvert = Convert.ToByte(str.Split('-')[3].ToString()); bytAutoMeasure = Convert.ToByte(str.Split('-')[4].ToString()); bytDragMode = Convert.ToByte(str.Split('-')[5].ToString()); intDragLong = Convert.ToByte(str.Split('-')[6].ToString()); intDragShort = Convert.ToByte(str.Split('-')[7].ToString()); intDragSafe = Convert.ToByte(str.Split('-')[8].ToString()); } dr.Close(); } #endregion #region Curtains = new List <BasicCurtain>(); strsql = string.Format("select * from dbClassInfomation where DIndex={0} and ClassID={1} order by SenNum", DIndex, 1); dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrCurPath); if (dr != null) { while (dr.Read()) { BasicCurtain temp = new BasicCurtain(); string str = dr.GetValue(5).ToString(); temp.runTime = Convert.ToByte(str.Split('-')[0].ToString()); temp.onDelay = Convert.ToByte(str.Split('-')[1].ToString()); temp.offDelay = Convert.ToByte(str.Split('-')[2].ToString()); temp.remark = dr.GetValue(4).ToString(); Curtains.Add(temp); } dr.Close(); } #endregion } catch { } }
//<summary> //保存数据库面板设置,将所有数据保存 //</summary> public override void SaveSendIRToDB(int intDeviceType) { base.SaveSendIRToDB(intDeviceType); //insert new channel information if (Chans != null) { #region String strParam = Chans.runTime.ToString() + "-" + Chans.onDelay.ToString() + "-" + Chans.offDelay.ToString(); String strsql = string.Format("Insert into dbClassInfomation(DIndex,ClassID,ObjectID,SenNum,Remark,strParam1) values ({0},{1},{2},{3},'{4}','{5}')", DIndex, 1, 0, 0, Chans.remark, strParam); DataModule.ExecuteSQLDatabase(strsql); #endregion } }
///<summary> ///读取数据库面板设置,将所有数据读至缓存 ///</summary> public void ReadDevieceInfoFromDB(int DIndex) { //read basic information of EIB #region string str = "select * from dbDeviceInfo where DIndex=" + DIndex.ToString(); OleDbDataReader dr = DataModule.SearchAResultSQLDB(str); if (dr == null) { return; } if (dr.HasRows) { while (dr.Read()) { Address = dr.GetString(2); } dr.Close(); } #endregion //read EIB to bus #region str = string.Format("select * from dbEIBDev where DIndex={0}", DIndex); dr = DataModule.SearchAResultSQLDB(str); otherInfo = new List <OtherInfo>(); if (dr == null) { return; } while (dr.Read()) { OtherInfo tmp = new OtherInfo(); tmp.GroupAddress = dr.GetString(2); tmp.ControlType = dr.GetByte(3); tmp.Type = dr.GetByte(4); tmp.Param1 = dr.GetByte(5); tmp.Param2 = dr.GetByte(6); tmp.Param3 = dr.GetByte(7); tmp.Param4 = dr.GetByte(8); tmp.strDevName = dr.GetString(9); otherInfo.Add(tmp); } dr.Close(); #endregion }
//<summary> //将缓存里所有HVAC的设置存在数据库 //</summary> public void SaveInfoToDb() { //// delete all old information and refresh the database string strsql = string.Format("delete from dbHVAC where DIndex=" + DIndex.ToString()); DataModule.ExecuteSQLDatabase(strsql); strsql = @"Insert into dbHVAC(DIndex,bytAutoRun,bytModeONDelay,bytModeOFFDelay,bytFanONDelay,bytFanOFFDelay,bytCOrP,bytHigh," + "bytMid,bytLow,bytSteps) values(@DIndex,@bytAutoRun,@bytModeONDelay,@bytModeOFFDelay,@bytFanONDelay,@bytFanOFFDelay," + "@bytCOrP,@bytHigh,@bytMid,@bytLow,@bytSteps)"; //创建一个OleDbConnection对象 OleDbConnection conn; conn = new OleDbConnection(DataModule.ConString + CsConst.mstrDefaultPath); conn.Open(); if (bytSteps == null) { bytSteps = new byte[12]; } OleDbCommand cmd = new OleDbCommand(strsql, conn); ((OleDbParameter)cmd.Parameters.Add("@DIndex", OleDbType.Integer)).Value = DIndex; ((OleDbParameter)cmd.Parameters.Add("@bytAutoRun", OleDbType.VarChar)).Value = bytAutoRun; ((OleDbParameter)cmd.Parameters.Add("@bytModeONDelay", OleDbType.VarChar)).Value = bytModeONDelay; ((OleDbParameter)cmd.Parameters.Add("@bytModeOFFDelay", OleDbType.VarChar)).Value = bytModeOFFDelay; ((OleDbParameter)cmd.Parameters.Add("@bytFanONDelay", OleDbType.VarChar)).Value = bytFanONDelay; ((OleDbParameter)cmd.Parameters.Add("@bytFanOFFDelay", OleDbType.VarChar)).Value = bytFanOFFDelay; ((OleDbParameter)cmd.Parameters.Add("@bytCOrP", OleDbType.VarChar)).Value = bytCOrP; ((OleDbParameter)cmd.Parameters.Add("@bytHigh", OleDbType.VarChar)).Value = bytHigh; ((OleDbParameter)cmd.Parameters.Add("@bytMid", OleDbType.VarChar)).Value = bytMid; ((OleDbParameter)cmd.Parameters.Add("@bytLow", OleDbType.VarChar)).Value = bytLow; ((OleDbParameter)cmd.Parameters.Add("@bytSteps", OleDbType.Binary)).Value = bytSteps; try { cmd.ExecuteNonQuery(); } catch (OleDbException exp) { MessageBox.Show(exp.ToString()); } conn.Close(); }
public static void ReadAllGroupCommandsFrmDatabase() { CsConst.myTemplates = new List <ControlTemplates>(); ////read keys commands to buffer string str = string.Format("select * from dbGrpRemark order by GrpID"); OleDbDataReader drKeyCmds = DataModule.SearchAResultSQLDB(str); if (drKeyCmds != null) { while (drKeyCmds.Read()) { ControlTemplates oTmpGrp = new ControlTemplates(); oTmpGrp.ID = drKeyCmds.GetInt16(0); oTmpGrp.Name = drKeyCmds.GetString(1); oTmpGrp.bytType = drKeyCmds.GetByte(2); oTmpGrp.bytGpID = drKeyCmds.GetByte(3); oTmpGrp.GpCMD = new List <UVCMD.ControlTargets>(); str = string.Format("select * from dbGrpCMD where GrpID = {0} order by objID", oTmpGrp.ID); OleDbDataReader drKeyCmds1 = DataModule.SearchAResultSQLDB(str); if (drKeyCmds1 != null) { while (drKeyCmds1.Read()) { UVCMD.ControlTargets TmpCmd = new UVCMD.ControlTargets(); TmpCmd.ID = drKeyCmds1.GetByte(1); TmpCmd.Type = drKeyCmds1.GetByte(2); TmpCmd.SubnetID = drKeyCmds1.GetByte(3); TmpCmd.DeviceID = drKeyCmds1.GetByte(4); TmpCmd.Param1 = drKeyCmds1.GetByte(5); TmpCmd.Param2 = drKeyCmds1.GetByte(6); TmpCmd.Param3 = drKeyCmds1.GetByte(7); TmpCmd.Param4 = drKeyCmds1.GetByte(8); oTmpGrp.GpCMD.Add(TmpCmd); } drKeyCmds1.Close(); } CsConst.myTemplates.Add(oTmpGrp); } drKeyCmds.Close(); } }
//<summary> //保存数据 //</summary> public void SaveDataToDB() { try { #region string strsql = string.Format("delete * from dbClassInfomation where DIndex={0}", DIndex); DataModule.ExecuteSQLDatabase(strsql); if (myACSetting != null) { for (int i = 0; i < myACSetting.Count; i++) { ThirdPartAC temp = myACSetting[i]; string strParam = temp.ID.ToString() + "-" + temp.Enable.ToString() + "-" + temp.ACNO.ToString() + "-" + temp.CoolMasterAddress.ToString() + "-" + temp.GroupID.ToString(); strsql = @"Insert into dbClassInfomation(DIndex,ClassID,ObjectID,SenNum,Remark,strParam1,byteAry1)" + " values(@DIndex,@ClassID,@ObjectID,@SenNum,@Remark,@strParam1,@byteAry1)"; OleDbConnection conn; conn = new OleDbConnection(DataModule.ConString + CsConst.mstrDefaultPath); //OleDbConnection conn = new OleDbConnection(DataModule.ConString + CsConst.mstrCurPath); conn.Open(); OleDbCommand cmd = new OleDbCommand(strsql, conn); ((OleDbParameter)cmd.Parameters.Add("@DIndex", OleDbType.Integer)).Value = DIndex; ((OleDbParameter)cmd.Parameters.Add("@ClassID", OleDbType.Integer)).Value = 0; ((OleDbParameter)cmd.Parameters.Add("@ObjectID", OleDbType.Integer)).Value = 0; ((OleDbParameter)cmd.Parameters.Add("@SenNum", OleDbType.Integer)).Value = i; ((OleDbParameter)cmd.Parameters.Add("@Remark", OleDbType.VarChar)).Value = temp.Remark; ((OleDbParameter)cmd.Parameters.Add("@strParam1", OleDbType.VarChar)).Value = strParam; ((OleDbParameter)cmd.Parameters.Add("@byteAry1", OleDbType.Binary)).Value = temp.arayACinfo; try { cmd.ExecuteNonQuery(); } catch { conn.Close(); } conn.Close(); } } #endregion } catch { } }
public static void WriteIni() { // wirte all to ini string strsql = "select * from defDeviceType order by DeviceType"; OleDbDataReader drPrj = DataModule.SearchAResultSQLDB(strsql); if (drPrj != null) { while (drPrj.Read()) { int intDevType = drPrj.GetInt32(0); if (intDevType != 0) { CsConst.mstrINIDefault.IniWriteValue("DeviceType" + intDevType.ToString(), "Model", drPrj.GetValue(2).ToString()); if (CsConst.iLanguageId == 0) { CsConst.mstrINIDefault.IniWriteValue("DeviceType" + intDevType.ToString(), "Description", drPrj.GetValue(4).ToString()); } else if (CsConst.iLanguageId == 1) { string str = drPrj.GetValue(3).ToString(); if (str.Contains("(")) { str = str.Split('(')[0].ToString(); } CsConst.mstrINIDefault.IniWriteValue("DeviceType" + intDevType.ToString(), "Description", str); } CsConst.mstrINIDefault.IniWriteValue("DeviceType" + intDevType.ToString(), "MaxValue", drPrj.GetInt32(5).ToString()); CsConst.mstrINIDefault.IniWriteValue("DeviceType" + intDevType.ToString(), "IsOnlist", drPrj.GetBoolean(7).ToString()); string strTmp = Convert.ToString(drPrj[8]); string[] ArayTmp = strTmp.Split(';'); if (strTmp != null) { foreach (string strVersion in ArayTmp) { CsConst.mstrINIDefault.IniWriteValue("DeviceType" + intDevType.ToString(), "Version", strTmp); } } } } } }
//<summary> //保存数据库面板设置,将所有数据保存 //</summary> public void SaveCurtainToDB() { try { #region string strsql = string.Format("delete * from dbClassInfomation where DIndex={0}", DIndex); DataModule.ExecuteSQLDatabase(strsql); string strDeviceRemark = ""; if (DeviceName.Contains("\\")) { strDeviceRemark = DeviceName.Split('\\')[1].ToString(); } string strParam = bytCurType.ToString() + "-" + intJogTime.ToString() + "-" + intJogTime1.ToString() + "-" + bytInvert.ToString() + "-" + bytAutoMeasure.ToString() + "-" + bytDragMode.ToString() + "-" + intDragLong.ToString() + "-" + intDragShort.ToString() + "-" + intDragSafe.ToString(); strsql = string.Format("Insert into dbClassInfomation(DIndex,ClassID,ObjectID,SenNum,Remark,strParam1) values ({0},{1},{2},{3},'{4}','{5}')", DIndex, 0, 0, 0, strDeviceRemark, strParam); DataModule.ExecuteSQLDatabase(strsql); #endregion #region if (Curtains != null) { for (int i = 0; i < Curtains.Count; i++) { BasicCurtain temp = Curtains[i]; strParam = temp.runTime.ToString() + "-" + temp.onDelay.ToString() + "-" + temp.offDelay.ToString(); strsql = string.Format("Insert into dbClassInfomation(DIndex,ClassID,ObjectID,SenNum,Remark,strParam1) values ({0},{1},{2},{3},'{4}','{5}')", DIndex, 1, 0, 0, temp.remark, strParam); DataModule.ExecuteSQLDatabase(strsql); } } #endregion } catch { } }
//<summary> //保存数据库面板设置,将所有数据保存 //</summary> public void SaveSendIRToDB() { try { string strsql = string.Format("delete * from dbClassInfomation where DIndex={0}", DIndex); DataModule.ExecuteSQLDatabase(strsql); #region string strDeviceRemark = ""; if (strName.Contains("\\")) { strDeviceRemark = strName.Split('\\')[1].ToString(); } string strBasic = RemoteEnable.ToString() + "-" + mbytOne.ToString() + "-" + mbytTwo.ToString(); strsql = string.Format("Insert into dbClassInfomation(DIndex,ClassID,ObjectID,SenNum,Remark,strParam1) values ({0},{1},{2},{3},'{4}','{5}')", DIndex, 0, 0, 0, strDeviceRemark, strBasic); DataModule.ExecuteSQLDatabase(strsql); #endregion #region if (IRCodes != null) { for (int i = 0; i < IRCodes.Count; i++) { UVCMD.IRCode temp = IRCodes[i]; string strParam = temp.KeyID.ToString() + "-" + temp.IRLength.ToString() + "-" + temp.IRLoation.ToString() + "-" + temp.Enable.ToString() + "-" + temp.Codes.ToString(); strsql = string.Format("Insert into dbClassInfomation(DIndex,ClassID,ObjectID,SenNum,Remark,strParam1) values ({0},{1},{2},{3},'{4}','{5}')", DIndex, 1, 0, i, temp.Remark1, strParam); DataModule.ExecuteSQLDatabase(strsql); } } #endregion } catch { } }