// Token: 0x0600003B RID: 59 RVA: 0x00007510 File Offset: 0x00005710 public frmMasterLevel(string charName) { InitializeComponent(); charName = charName; string text = string.Format("SELECT T_MasterLevelSystem.CHAR_NAME, T_MasterLevelSystem.MASTER_LEVEL, T_MasterLevelSystem.ML_EXP, T_MasterLevelSystem.ML_NEXTEXP, T_MasterLevelSystem.ML_POINT, Character.Class FROM Character INNER JOIN T_MasterLevelSystem ON Character.Name = T_MasterLevelSystem.CHAR_NAME COLLATE Chinese_PRC_CS_AS_KS_WS WHERE (T_MasterLevelSystem.CHAR_NAME = '{0}')", charName); try { OleDbCommand oleDbCommand = new OleDbCommand(text, frmBase.Mu_Conn); OleDbDataReader oleDbDataReader = oleDbCommand.ExecuteReader(); if (oleDbDataReader.Read()) { txtCharacter.Text = Convert.ToString(oleDbDataReader.GetValue(0)); txtLevel.Text = oleDbDataReader.GetInt16(1).ToString(); txtEXP.Text = oleDbDataReader.GetInt64(2).ToString(); txtNextEXP.Text = oleDbDataReader.GetInt64(3).ToString(); txtPoint.Text = oleDbDataReader.GetInt16(4).ToString(); if (oleDbDataReader.GetValue(5) != DBNull.Value) { classID = (int)oleDbDataReader.GetByte(5); } } else { Utils.WarningMessage("对不起,没有找到角色[" + charName + "]对应的帐号信息!"); btnOK.Enabled = false; } oleDbDataReader.Close(); } catch (Exception ex) { Utils.WarningMessage(string.Concat(new string[] { "SQL:", text, "\nError:", ex.Message, "\nSource:", ex.Source, "\nTrace:", ex.StackTrace })); } }
///<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> /// Loads the catalog's settings and sets up the class to take requests. /// </summary> /// <returns></returns> public void Load() { if (sync) { throw(new ContentManagerException("Cannot create a synchronized catalog.", 991)); } StringBuilder s = new StringBuilder("SELECT "); s.Append(catalogFields); s.Append(" FROM kitCms_Catalogs WHERE CatalogID="); s.Append(iD); s.Append(";"); OleDbDataReader r = this.runReader(s.ToString()); if (r.Read()) { name = r.GetString(0); description = r.GetString(1); pressTime = TimeSpan.FromTicks((long)r.GetDouble(2)); pressDate = r.GetDateTime(3); expireTime = TimeSpan.FromTicks((long)r.GetDouble(4)); expireDate = r.GetDateTime(5); archiveTime = TimeSpan.FromTicks((long)r.GetDouble(6)); archiveDate = r.GetDateTime(7); archiveOnExpiration = r.GetBoolean(8); archiveCatalogID = r.GetInt32(9); authorRoleID = r.GetInt32(10); reviewerRoleID = r.GetInt32(11); editorRoleID = r.GetInt32(12); publisherRoleID = r.GetInt32(13); adminRoleID = r.GetInt32(14); authorDisabled = r.GetBoolean(15); reviewDisabled = r.GetBoolean(16); editDisabled = r.GetBoolean(17); publishDisabled = r.GetBoolean(18); dynamicParseTypeDisabled = r.GetBoolean(19); trackChangesDisabled = r.GetBoolean(20); hitCounterDisabled = r.GetBoolean(21); contentType = (ContentType)r.GetByte(22); trackChangesType = (ContentTrackChangesType)r.GetByte(23); hitCounterType = (ContentHitCounterType)r.GetByte(24); enableHtmlAuthoring = r.GetBoolean(25); enableCss = r.GetBoolean(26); enableParagraphStyles = r.GetBoolean(27); enableFontForeColor = r.GetBoolean(28); enableFontBackColor = r.GetBoolean(29); enableFormatting = r.GetBoolean(30); enableImages = r.GetBoolean(31); enableCustomCss = r.GetBoolean(32); cssLink = r.GetString(33); cssStyles = r.GetString(34); cssNames = r.GetString(35); paragraphStyles = r.GetString(36); paragraphNames = r.GetString(37); fontColorValues = r.GetString(38); fontColorNames = r.GetString(39); imageLocation = r.GetString(40); sync = true; } }
///<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 }
private void getItemDetail(string itemName, string date, DataTable stockTable) { string sqlQry = "SELECT * FROM TRANS WHERE PCODE = '" + itemName + "' AND (OUTDATE IS NULL OR OUTDATE > #" + date + "#) ORDER BY PCODE,TNO"; OleDbDataReader reader = dbUtils.fetch(sqlQry); List <string> stoneWeight = null; string path = string.Empty; DataRow row; if (reader.HasRows) { while (reader.Read()) { row = stockTable.NewRow(); if (!reader["Photo"].Equals(DBNull.Value) && reader.GetString(8).Length > 0) { path = Application.StartupPath + "//Data//Images//" + reader.GetString(8); //photo row[0] = path; } else { row[0] = string.Empty; } row[1] = itemName; row[2] = reader.GetDouble(6); stoneWeight = getStoneDetail(reader.GetInt32(0)); row[3] = stoneWeight[0]; row[4] = stoneWeight[1]; row[5] = reader.GetDouble(7); row[6] = reader.GetInt32(3); row[7] = reader.GetInt32(0); stockTable.Rows.Add(row); //MessageBox.Show(reader.GetDataTypeName(11).ToString()); if (chkComposite.Checked && !reader["SubItem"].Equals(DBNull.Value) && reader.GetByte(11) == 1) { getSubItemDetail(reader.GetInt32(0).ToString(), subItemTable); } } } }
public void DoTestTypes(DbTypeParametersCollection row) { testTypesInvocations++; exp = null; string rowId = "43967_" + this.testTypesInvocations.ToString(); OleDbDataReader rdr = null; OleDbConnection con = null; try { row.ExecuteInsert(rowId); row.ExecuteSelectReader(rowId, out rdr, out con); while (rdr.Read()) { //Run over all the columns in the result set row. //For each column, try to read it as a byte. for (int i = 0; i < row.Count; i++) { if (row[i].Value.GetType() == typeof(byte)) //The value in the result set should be a byte. { try { BeginCase(string.Format("Calling GetByte() on a field of dbtype {0}", row[i].DbTypeName)); byte retByte = rdr.GetByte(i); Compare(row[i].Value, retByte); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } } else //The value in the result set should NOT be byte. In this case an Invalid case exception should be thrown. { try { BeginCase(string.Format("Calling GetByte() on a field of dbtype {0}", row[i].DbTypeName)); byte retByte = rdr.GetByte(i); ExpectedExceptionNotCaught("InvalidCastException"); } catch (InvalidCastException ex) { ExpectedExceptionCaught(ex); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } } } } } finally { row.ExecuteDelete(rowId); if ((rdr != null) && (!rdr.IsClosed)) { rdr.Close(); } if ((con != null) && (con.State != ConnectionState.Closed)) { con.Close(); } } }
//<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> /// Populates a list with customer objects from a data reader object /// </summary> /// <param name="reader">Data Reader containing one or more customer records</param> /// <returns></returns> private static List <Customer> LoadCustomerListFromDataReader(OleDbDataReader reader) { var customers = new List <Customer>(); int customerStoreId = -1; try { while (reader.Read()) { var customer = new Customer(); customer.StoreId = reader.GetNullableInt32("KlantID"); if (customer.StoreId != null) { customerStoreId = (int)customer.StoreId; } customer.WebshopId = reader.GetNullableInt32("KlantID_WS"); customer.LastName = reader.GetStringSafe(reader.GetOrdinal("Naam")); customer.FirstName = reader.GetStringSafe(reader.GetOrdinal("Voornaam")); customer.ShippingAddressStreet = reader.GetStringSafe(reader.GetOrdinal("Straat")); customer.ShippingAddressHomeNumber = reader.GetStringSafe(reader.GetOrdinal("Huisnummer")); customer.ShippingAddressZip = reader.GetStringSafe(reader.GetOrdinal("ZIP")); customer.ShippingAddressCity = reader.GetStringSafe(reader.GetOrdinal("Stad")); customer.ShippingAddressState = reader.GetStringSafe(reader.GetOrdinal("Staat")); customer.ShippingAddressCountry = reader.GetStringSafe(reader.GetOrdinal("Land")); customer.Phone = reader.GetStringSafe(reader.GetOrdinal("Telefoon")); customer.Mobile = reader.GetStringSafe(reader.GetOrdinal("GSM")); customer.Email = reader.GetStringSafe(reader.GetOrdinal("Email")); customer.BillingName = reader.GetStringSafe(reader.GetOrdinal("FaktuurNaam")); customer.BillingContact = reader.GetStringSafe(reader.GetOrdinal("FaktuurContact")); customer.BillingAddress1 = reader.GetStringSafe(reader.GetOrdinal("FaktuurAdres1")); customer.BillingAddress2 = reader.GetStringSafe(reader.GetOrdinal("FaktuurAdres2")); customer.BillingAddress3 = reader.GetStringSafe(reader.GetOrdinal("FaktuurAdres3")); customer.VatNumber = reader.GetStringSafe(reader.GetOrdinal("BTW Nummer")); customer.WebshopDiscount6 = reader.GetByte(reader.GetOrdinal("WebshopDiscount_6")); customer.WebshopDiscount21 = reader.GetByte(reader.GetOrdinal("WebshopDiscount_21")); customer.IsTeacher = reader.GetBoolean(reader.GetOrdinal("IsLeraarOfAcademie")); customer.IsReseller = reader.GetBoolean(reader.GetOrdinal("IsReseller")); customer.Institution = reader.GetStringSafe(reader.GetOrdinal("Academie")); customer.TeachingSubjects = reader.GetStringSafe(reader.GetOrdinal("Discipline")); customer.TeacherCardNumber = reader.GetStringSafe(reader.GetOrdinal("TeacherCardNumber")); customer.TeacherCardValidFrom = reader.GetNullableDateTime(reader.GetOrdinal("TeacherCardValidFrom")); customer.TeacherCardValidTo = reader.GetNullableDateTime(reader.GetOrdinal("TeacherCardValidTo")); customer.TeacherRegistrationNote = reader.GetStringSafe(reader.GetOrdinal("TeacherRegistrationNote")); customer.TeacherConfirmed = reader.GetNullableDateTime(reader.GetOrdinal("TeacherConfirmed")); customer.LastLoginDttm = reader.GetNullableDateTime(reader.GetOrdinal("LastLoginDttm")); customer.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); customer.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); customer.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); customer.ForcePasswordReset = reader.GetBoolean(reader.GetOrdinal("ForcePasswordReset")); customer.Test = reader.GetBoolean(reader.GetOrdinal("Test")); customers.Add(customer); } } catch (Exception exception) { log.ErrorFormat("Error in {0} (data record with KlantID={1}, exception={2})", MethodBase.GetCurrentMethod().Name, customerStoreId, exception); throw; } return(customers); }
//<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 }
public List <Auto> GetCars() { OleDbTransaction trans = null; OleDbDataReader kapReader = null; List <Auto> ret = new List <Auto>(); Auto tmp; try { if (connection == null) { GetConnection(); } trans = connection.BeginTransaction(); allCars.Transaction = trans; kapReader = allCars.ExecuteReader(); while (kapReader.Read()) { tmp = new Auto(kapReader.GetString(0)); tmp.Kapacitas = kapReader.GetByte(1); tmp.Fogyasztas = kapReader.GetFloat(3); tmp.Lizingdij = kapReader.GetFloat(2); ret.Add(tmp); } trans.Commit(); } catch (OleDbException ex) { MessageBox.Show("Adatbázis elérési hiba.\nKérem ellenőrizze, hogy az adatbázist más alkalmazás nem használja-e!", "Hiba", MessageBoxButtons.OK, MessageBoxIcon.Error); AppLogger.WriteException(ex); AppLogger.WriteEvent("A kivétel elkapva."); trans.Rollback(); } catch (InvalidOperationException inv) { } catch (Exception e) { AppLogger.WriteException(e); AppLogger.WriteEvent("A kivétel elkapva."); trans.Rollback(); } finally { if (kapReader != null) { kapReader.Close(); } trans = null; } return(ret); }
public List <WorkData> GetWorkData(DateTime date, out List <Auto> autok, out CimOsszesito osszCim) { DateTime tempDate; object realm3; float rm3; string auth = ""; string host; string tmpRsz; string tmpRow; List <WorkData> data = new List <WorkData>(); WorkData tempData = null; Dictionary <string, Auto> autoData = new Dictionary <string, Auto>(); autok = new List <Auto>(); osszCim = new CimOsszesito(); OleDbDataReader latReader = null; OleDbDataReader kapReader = null; OleDbTransaction trans = null; Auto fordAuto; int forduloszam; int kapacitas; int counter = 0; if (connection == null) { GetConnection(); } try { Auto.AutoIndex = 0; System.Net.ServicePointManager.CertificatePolicy = new MyPolicy(); //if (Properties.Settings.Default.userName != "" && Properties.Settings.Default.password != "") { auth = string.Format("{0}:{1}", Properties.Settings.Default.userName, Properties.Settings.Default.password); } host = string.Format("{0}{1}&ok=OK", Properties.Settings.Default.updateURL, date.ToString("yyyy-MM")); try { using (WebClient client = new WebClient(), cl2 = new WebClient()) { cl2.Headers.Set("Authorization", "Basic " + Convert.ToBase64String(Encoding.UTF8.GetBytes(auth))); client.Headers.Set("Authorization", "Basic " + Convert.ToBase64String(Encoding.UTF8.GetBytes(auth))); using (StreamReader reader = new StreamReader(cl2.OpenRead(new Uri(string.Format("https://213.178.99.161/new/letoltes.php?honap={0}&ok=OK", date.ToString("yyyy-MM")))))) { } using (Stream dataStream = client.OpenRead(host)) { using (StreamReader reader = new StreamReader(dataStream, Encoding.UTF7)) { while (!reader.EndOfStream) { tmpRow = reader.ReadLine().Replace('õ', 'ő').Replace('û', 'ű').Replace('Õ', 'Ő').Replace('Û', 'Ű'); string[] parts = tmpRow.Split('\t'); if (parts.Length == 1) { if (parts[0].Trim() == "") { continue; } if (tempData != null) { tempData.Megjegyzes += " " + parts[0]; } } if (parts.Length != 14) { continue; } try { tempDate = DateTime.Parse(parts[4]); } catch (FormatException) { continue; } if (tempDate.Date > date.Date) { break; } if (tempDate.Date == date.Date) { tempData = new WorkData(); tempData.WorksheetNumber = long.Parse(parts[0]); tempData.Number = counter; tmpRsz = parts[1]; if (tmpRsz == "") { tmpRsz = "???"; } try { kapacitas = int.Parse(parts[8]); } catch (Exception) { kapacitas = 5; } if (autoData.ContainsKey(tmpRsz)) { fordAuto = autoData[tmpRsz]; } else { fordAuto = new Auto(tmpRsz); getCar.Parameters[0].Value = tmpRsz; kapReader = getCar.ExecuteReader(); if (kapReader.Read()) { fordAuto.Kapacitas = kapReader.GetByte(0); fordAuto.Fogyasztas = kapReader.GetFloat(1); fordAuto.Lizingdij = kapReader.GetFloat(2); } else { fordAuto.Kapacitas = kapacitas; } kapReader.Close(); fordAuto.Index = Auto.AutoIndex++; fordAuto.Sofor = parts[2]; fordAuto.Seged = parts[3]; autoData.Add(tmpRsz, fordAuto); } try { tempData.IranyitoSzam = int.Parse(parts[5]); } catch (FormatException) { } tempData.Utca = parts[6]; tempData.HazSzam = parts[7]; try { selectProbUtca.Parameters[0].Value = tempData.Utca; if (selectProbUtca.ExecuteScalar() != null) { tempData.Problematic = true; } else { selectProbCim.Parameters[0].Value = tempData.Cim; if (selectProbCim.ExecuteScalar() != null) { tempData.Problematic = true; } } } catch (OleDbException hadit) { } getRealVolume.Parameters[0].Value = tempData.Cim; realm3 = getRealVolume.ExecuteScalar(); try { rm3 = (realm3 == DBNull.Value || realm3 == null) ? 0 : float.Parse(realm3.ToString()); } catch (FormatException) { rm3 = 0; } tempData.TenylegesKobmeter = (int)Math.Ceiling(rm3); tempData.WorkCapacity = kapacitas; try { tempData.Napszak = int.Parse(parts[11]); } catch (FormatException) { } if (tempData.Napszak > 3 || tempData.Napszak < 1) { using (NapszakCorrector nc = new NapszakCorrector(tempData)) { nc.ShowDialog(); } } try { tempData.CsoHossz = int.Parse(parts[9]); } catch (FormatException) { } tempData.CsoStr = parts[9]; tempData.Megjegyzes = parts[13]; osszCim.UpdateWith(tempData); /*if (tempData.Jozsai) * { * forduloszam = fordAuto.GetNapszakFordulok(tempData.Napszak - 1); * fordAuto.SetNapszakFordulok(tempData.Napszak - 1, forduloszam + 1); * fordAuto.AddJozsaiFuvar(tempData); * }*/ GetLatLng(tempData, trans); data.Add(tempData); counter++; } } } } } foreach (string s in autoData.Keys) { autok.Add(autoData[s]); } } catch (WebException se) { MessageBox.Show("A program nem tudott kapcsolatba lépni a távoli géppel.\nEllenőrízze az internetkapcsolatot és a Beállítások panelen levő értékeket!", "Hiba", MessageBoxButtons.OK, MessageBoxIcon.Error); throw; } catch (OleDbException ex) { MessageBox.Show("Adatbázis elérési hiba.\nKérem ellenőrizze, hogy az adatbázist más alkalmazás nem használja-e!", "Hiba", MessageBoxButtons.OK, MessageBoxIcon.Error); throw; } } catch (Exception e) { AppLogger.WriteException(e); AppLogger.WriteEvent("A kivétel elkapva."); data.Clear(); osszCim = new CimOsszesito(); if (ExceptionOccured != null) { ExceptionOccured(); } } finally { if (latReader != null) { latReader.Close(); } if (kapReader != null) { kapReader.Close(); } } return(data); }
void copyOrderTable() { string sql = "SELECT NППЗаказа, NЗаказаЗавода, NЗаказа, ГрафикN, ВидГрафика, ОснованиеЗаказа, ДатаПолученияЗаказа, ОбозначениеТО, КодТО, NИзделия, NДетали, Кол_во, ФКол_во, Заказчик, ПланДатаИзготовления, КодПриоритета, ПланТП, ДатаТП, ДатаПоступленияЦех, ФактДатаИзготовления, ПланТрудоемкость, ЦехИсполнитель, Отчет, ДатаОтчета, Технолог, Слесарь, СодержаниеЗаявки, ФактТрудоемкость, NНакладной, NАкта, СкладПолуч, НеодноврВыпЗак, Конструктор, p_unit, pause, OrderCards, Life, Lifeday, ObjectType, Quckly, MaterialDate, Запчасть, Стойкость, Доп_заказ, TNVED, PriceDate, PeoDate, OtizDate FROM Заказы";// where NППЗаказа=1"; OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.connStr); conn.Open(); OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader r = cmd.ExecuteReader(); while (r.Read()) { Order o = new Order(); o.orderId = r.GetInt32(0); o.orderNumber = r.GetString(1); o.orderFullNumber = r.GetString(2); if (r[3] != DBNull.Value) { o.graphId = r.GetInt32(3); } if (r[4] != DBNull.Value) { o.graphTypeId = r.GetByte(4); } if (r[5] != DBNull.Value) { o.reasonOrder = r.GetByte(5); } if (r[6] != DBNull.Value) { o.orderDate = r.GetDateTime(6); } if (r[7] != DBNull.Value) { o.obozTo = r.GetString(7); } if (r[8] != DBNull.Value) { o.kodTO = r.GetInt16(8); } o.productNumber = r.GetString(9); o.partNumber = r.GetString(10); if (r[11] != DBNull.Value) { o.qty = r.GetInt32(11); } if (r[12] != DBNull.Value) { o.realQty = r.GetInt32(12); } if (r[13] != DBNull.Value) { o.customerId = r.GetInt32(13); } if (r[14] != DBNull.Value) { o.planDate = r.GetDateTime(14); } if (r[15] != DBNull.Value) { o.priorityId = r.GetByte(15); } if (r[16] != DBNull.Value) { o.planTechDate = r.GetDateTime(16); } if (r[17] != DBNull.Value) { o.techDate = r.GetDateTime(17); } if (r[18] != DBNull.Value) { o.shopDate = r.GetDateTime(18); } if (r[19] != DBNull.Value) { o.factReadyDate = r.GetDateTime(19); } if (r[20] != DBNull.Value) { o.planLabourIntensity = r.GetDouble(20); } if (r[21] != DBNull.Value) { o.performerShop = r.GetInt32(21); } if (r[22] != DBNull.Value) { o.includeInReport = r.GetBoolean(22); } if (r[23] != DBNull.Value) { o.reportDate = r.GetDateTime(23); } if (r[24] != DBNull.Value) { o.technologistId = r.GetInt32(24); } if (r[25] != DBNull.Value) { o.locksmithId = r.GetInt32(25); } if (r[26] != DBNull.Value) { o.orderNote = r.GetString(26); } if (r[27] != DBNull.Value) { o.factLabourIntensity = r.GetDouble(27); } if (r[28] != DBNull.Value) { o.consignmentNote = r.GetString(28); } if (r[29] != DBNull.Value) { o.actNumber = r.GetString(29); } if (r[30] != DBNull.Value) { o.destinationStore = r.GetString(30); } if (r[31] != DBNull.Value) { o.anotherTimeReady = r.GetBoolean(31); } if (r[32] != DBNull.Value) { o.designerId = -1; //// !!!!!!!!!!!! r.GetInt32(32); } if (r[33] != DBNull.Value) { o.unitOfMeasureId = -1;/// r.GetInt32(33); } if (r[34] != DBNull.Value) { o.stopped = r.GetBoolean(34); } if (r[35] != DBNull.Value) { o.orderCard = r.GetInt32(35); } if (r[36] != DBNull.Value) { o.serviceLifeYear = r.GetInt16(36); } if (r[37] != DBNull.Value) { o.serviceLifeDay = r.GetInt32(37); } if (r[38] != DBNull.Value) { o.objectType = r.GetByte(38); } if (r[39] != DBNull.Value) { o.urgent = r.GetBoolean(39); } if (r[40] != DBNull.Value) { o.materialDate = r.GetDateTime(40); } if (r[41] != DBNull.Value) { o.spare = r.GetBoolean(41); } if (r[42] != DBNull.Value) { o.resistance = r.GetInt32(42); } if (r[43] != DBNull.Value) { o.additionalOrder = r.GetBoolean(43); } if (r[44] != DBNull.Value) { o.classifier = r.GetDecimal(44).ToString(); } if (r[45] != DBNull.Value) { o.priceDate = r.GetDateTime(45); } if (r[46] != DBNull.Value) { o.peoDate = r.GetDateTime(46); } if (r[47] != DBNull.Value) { o.otizDate = r.GetDateTime(47); } /* * * string json = JsonConvert.SerializeObject(o, Formatting.None, new JsonSerializerSettings * { * NullValueHandling = NullValueHandling.Ignore * }); * */ Order o2 = rest.saveEntity <Order>(o); if (o2.orderId < 1) { break; } // MessageBox.Show(json); } r.Close(); cmd.Dispose(); conn.Close(); MessageBox.Show("Done!"); }
void copyEmployeeTable() { string sql = "SELECT id, NТабельный, Подразделение, Звено, Имя, Фамилия, ФИО, ПрофессияДолжность, Разряд, Операция, ВыполняемыеОперации, ДатаНайма, Работает, Категория, Адрес, ДомашнийТелефон, ДатаРождения, МестоРождения, МестоУчебы, ГодОкУЗ, Факультет, Специальность, ПредМР, Примечания, УслТруда, КТУ, WORKERSUM, UserLogin, Руководитель, PassportSeria, RealAdress, FamilyStatus, PassportNumber, PassportDate, PassportOffice, PersonalNumber, MobilePhoneZone, MobilePhone, Profession1, Profession2, Profession3, Profession4, Profession5, Profession6, Rost, Razmer, RazmerObuvi, ПрофессияСИЗ, КодРазмера, Sex FROM РаботникиЦеха";// where NТабельный=11980"; OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.connStr); conn.Open(); OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader r = cmd.ExecuteReader(); while (r.Read()) { Employee emp = new Employee(); emp.employeeId = r.GetInt32(0); emp.nTabelnyj = r.GetInt32(1); emp.deptId = r.GetInt16(2); if (r[3] != DBNull.Value) { emp.zveno = r.GetString(3); } if (r[4] != DBNull.Value) { emp.firstName = r.GetString(4); } if (r[5] != DBNull.Value) { emp.secondName = r.GetString(5); } if (r[6] != DBNull.Value) { emp.fullName = r.GetString(6); } if (r[7] != DBNull.Value) { emp.position = r.GetInt16(7); } if (r[8] != DBNull.Value) { emp.rank = r.GetByte(8); } if (r[11] != DBNull.Value) { emp.dateOfEmployment = r.GetDateTime(11); } if (r[12] != DBNull.Value) { emp.working = r.GetBoolean(12); } if (r[13] != DBNull.Value) { emp.categoryId = r.GetByte(13); } if (r[14] != DBNull.Value) { emp.address = r.GetString(14); } if (r[15] != DBNull.Value) { emp.homePhone = r.GetString(15); } if (r[16] != DBNull.Value) { emp.birthday = r.GetDateTime(16); } if (r[17] != DBNull.Value) { emp.birthplace = r.GetString(17); } if (r[18] != DBNull.Value) { emp.education = r.GetString(18); } if (r[19] != DBNull.Value) { emp.eduYear = r.GetInt16(19); } if (r[20] != DBNull.Value) { emp.faculty = r.GetString(20); } if (r[21] != DBNull.Value) { emp.specialty = r.GetString(21); } if (r[22] != DBNull.Value) { emp.previousEmployment = r.GetString(22); } if (r[23] != DBNull.Value) { emp.note = r.GetString(23); } if (r[24] != DBNull.Value) { emp.workingConditions = r.GetDouble(24); } if (r[25] != DBNull.Value) { emp.salary = r.GetDouble(25); } if (r[27] != DBNull.Value) { emp.userLogin = r.GetString(27); } if (r[28] != DBNull.Value) { emp.managerId = r.GetInt32(28); } if (r[29] != DBNull.Value) { emp.passportSeries = r.GetString(29); } if (r[30] != DBNull.Value) { emp.realAddress = r.GetString(30); } if (r[31] != DBNull.Value) { emp.familyStatus = r.GetString(31); } if (r[32] != DBNull.Value) { emp.passportNumber = r.GetString(32); } if (r[33] != DBNull.Value) { emp.passportDate = r.GetDateTime(33); } if (r[34] != DBNull.Value) { emp.passportOffice = r.GetString(34); } if (r[35] != DBNull.Value) { emp.personalNumber = r.GetString(35); } if (r[36] != DBNull.Value) { emp.mobilePhoneZone = r.GetString(36); } if (r[37] != DBNull.Value) { emp.mobilePhone = r.GetString(37); } if (r[38] != DBNull.Value) { emp.professionId1 = r.GetInt16(38); } if (r[39] != DBNull.Value) { emp.professionId2 = r.GetInt16(39); } if (r[40] != DBNull.Value) { emp.professionId3 = r.GetInt16(40); } if (r[41] != DBNull.Value) { emp.professionId4 = r.GetInt16(41); } if (r[42] != DBNull.Value) { emp.professionId5 = r.GetInt16(42); } if (r[43] != DBNull.Value) { emp.professionId6 = r.GetInt16(43); } if (r[44] != DBNull.Value) { emp.height = r.GetInt32(44); } if (r[45] != DBNull.Value) { emp.clothingSize = r.GetInt32(45); } if (r[46] != DBNull.Value) { emp.shoeSize = r.GetInt32(46); } if (r[47] != DBNull.Value) { emp.meansOfProtectionByPosition = r.GetInt32(47); } if (r[48] != DBNull.Value) { emp.clothingSizeTypeId = r.GetByte(48); } if (r[49] != DBNull.Value) { emp.gender = r.GetString(49); } /* * string json = JsonConvert.SerializeObject(emp, Formatting.None, new JsonSerializerSettings * { * NullValueHandling = NullValueHandling.Ignore * }); * MessageBox.Show(json); */ Employee emp2 = rest.saveEntity <Employee>(emp); } r.Close(); cmd.Dispose(); conn.Close(); MessageBox.Show("Done!"); }