protected void Page_Load(object sender, EventArgs e) { var sql = umbraco.BusinessLogic.Application.SqlHelper; if (!IsPostBack) { Dictionary <string, string> findDocumentParams = (Dictionary <string, string>)Session[SessionKeys.FindDocumentParams] ?? new Dictionary <string, string>(); String postedValues = "Posted Values:<br/>"; // Check at least 1 filter set. foreach (string name in findDocumentParams.Keys) { string value = findDocumentParams[name]; postedValues += string.Format("Name:{0} Value:{1}<br/>", name, value); } string currentUserLanguage = string.Format("<br/> Current User's Language: {0}", LanguageFacade.CurrentLanguage); searchParams.Text = postedValues + currentUserLanguage; var msg = DBFacade.Echo(DateTime.Now.ToString("s")); searchParams.Text += "<br/>Stored Proc Echo:" + msg; } }
/// <summary> /// Retorna as informações das DLL's SB1Util e Model /// </summary> public void prepare() { try { prepared = true; this.user = DBFacade.getInstance().Connection.Company.UserName; this.companyVersion = "" + DBFacade.getInstance().Connection.Company.Version; Assembly AssLib = Assembly.LoadFrom("SB1Util.dll"); Assembly AssMod = Assembly.LoadFrom("Model.dll"); FileVersionInfo versionInfo = FileVersionInfo.GetVersionInfo("SB1Util.dll"); this.libVersion = versionInfo.FileVersion;// AssLib.GetName().Version.ToString(); versionInfo = FileVersionInfo.GetVersionInfo("Model.dll"); this.addonVersion = versionInfo.FileVersion;// AssMod.GetName().Version.ToString(); System.Attribute attr = System.Attribute.GetCustomAttribute(AssMod, typeof(ModelName)); this.addonName = ((ModelName)attr).Name; }catch (Exception e) { //B1Connection.getInstance().App.SetStatusBarMessage("Erro ao Iniciar Log: " + e.Message, SAPbouiCOM.BoMessageTime.bmt_Long); SB1ControlException.SB1ControlException.Save(e); } }
/// <summary> /// 获取数据库操作对象 /// </summary> /// <param name="dataBaseType">数据库类型</param> /// <returns>数据库操作对象</returns> public static DBFacade GetDBFacade() { string connStr = "persist security info=True;packet size=4096;data source=(LOCAL);Password=huangjinyu;User ID=sa;initial catalog=TestDB"; DBFacade dbFacade = GetMsSqlDBFacadeFromConnectionString(connStr); return(dbFacade); }
public override long loadFromDB(string key, UserObjectFactory oFactory) { long ret = 0; try { DBFacade db = DBFacade.getInstance(); //busca os estagios Recordset rs = db.Query( "SELECT APST.Code " + "FROM [@SB1_APPROVAL] APRV " + "INNER JOIN [@SB1_APPROVAL_STAGE] APST " + "ON APRV.Code = APST.U_ApprovalCode " + "WHERE APRV.Code = " + key ); while (!rs.EoF) { ApprovalStage aps = new ApprovalStage(); aps.loadFromDB((string)rs.Fields.Item("Code").Value, oFactory); stages.AddLast(new LinkedListNode <ApprovalStage>(aps)); rs.MoveNext(); } //busca as condicoes rs = db.Query( "SELECT APCD.Code " + "FROM [@SB1_APPROVAL] APRV " + "INNER JOIN [@SB1_APPROVAL_CONDITION] APCD " + "ON APRV.Code = APCD.U_ApprovalCode " + "WHERE APRV.Code = " + key ); while (!rs.EoF) { ApprovalCondition ac = new ApprovalCondition(); ac.loadFromDB((string)rs.Fields.Item("Code").Value, oFactory); conditions.AddLast(new LinkedListNode <ApprovalCondition>(ac)); rs.MoveNext(); } long r = base.loadFromDB(key, oFactory); isActive = (string)userTable.UserFields.Fields.Item("U_isActive").Value; } catch (Exception e) { ret = -1; } return(ret); }
public void Post(JObject jsonresult) { try { /* * JObject results2 = JObject.Parse(jsonresult.ToString()); * var result = JsonConvert.DeserializeObject(jsonresult.ToString()); * OrderDto order = JsonConvert.DeserializeObject<OrderDto>(jsonresult.ToString()); */ OrderDto order = new OrderDto(); order.OrderPrice = (double)jsonresult["_orderPrice"]; order.Country = (string)jsonresult["_country"]; order.Street = (string)jsonresult["_street"]; order.PostalCode = (string)jsonresult["_postalCode"]; Array products = jsonresult["_products"].ToArray(); foreach (var product in products) { var product2 = (ProductDto)product; order.Products[0].ProductName = product2.ProductName; } //Object List ? order.CardType = (string)jsonresult["_cardType"]; order.CardNumber = (string)jsonresult["_cardNumber"]; order.CardName = (string)jsonresult["_cardName"]; order.CardCVC = (string)jsonresult["_cardCVC"]; order.CardExpiration = (string)jsonresult["_cardExpiration"]; /* * private double _orderPrice; * private string _country; * private string _street; * private string _postalCode; * private List<ProductDto> _products; * private string _cardType; * private string _cardNumber; * private string _cardName; * private string _cardCVC; * private string _cardExpiration; */ DBFacade db = new DBFacade(); //db.StoreOrder(result); } catch (Exception err) { Console.Write(err.ToString()); } }
protected Controller() { this.oConnection = B1Connection.getInstance(); this.oDBFacade = DBFacade.getInstance(); this.uiUtils = new UIUtils(oConnection.Company, oConnection.App); this.modeMonitors = new LinkedList <FormMode>(); this.properties = Properties.getInstance(); this.log = Logger.getInstance(); log.setProperties(properties); log.setUiUtils(uiUtils); initAddon(); log.prepare(); log.log("Addon iniciado", Logger.LogType.INFO, null, false); }
public string Get(int id) { DBFacade db = new DBFacade(); ProductDto product = new ProductDto("Black Hoodie", "cloths", "A Stylish Black Hoodie", 10.99, 1); ProductDto product2 = new ProductDto("Red Hoodie", "cloths", "A Stylish Red Hoodie", 9.99, 2); List <ProductDto> products = new List <ProductDto>(); products.Add(product); products.Add(product2); OrderDto order = new OrderDto(10, "Denmark", "Hedelundvej 112", "6705", products, "CreditCard", "1111222212341234", "Hlynur Geir Agnarsson", "321", "2021"); db.StoreOrder(order); return("Success!"); }
/// <summary> /// Salva o log em banco de dados. Caso ocorra falha, o log será gerado no diretório raiz, dentro do diretório LogSystem /// </summary> /// <param name="text">A mensagem da exceção</param> /// <param name="type">O tipo de exceção</param> private void printText(string text, LogType type) { DateTime dt = DateTime.Now; LoggerData LoggerDataObj = null; string Time = String.Format("{0:HH:mm:ss}", dt); try { LoggerDataObj = new LoggerData(); string form = ""; if (DBFacade.getInstance().Connection.App.Forms.ActiveForm != null) { try { form = DBFacade.getInstance().Connection.App.Forms.ActiveForm.TypeEx; } catch (Exception e) { form = ""; } } UserTable table = DBFacade.getInstance().getUserTable("SB1_ADDON_LOG"); table.Code = "" + (dt.Ticks + 1); table.Name = "" + (dt.Ticks + 1); //Ajusta valores nos campos pois pode ocorrer exception caso esteja NULL addonVersion = addonVersion == null ? "" : addonVersion; addonName = addonName == null ? "" : addonName; companyVersion = companyVersion == null ? "" : companyVersion; libVersion = libVersion == null ? "" : libVersion; type = type == null ? LogType.INFO : type; text = text == null ? "" : text; table.UserFields.Fields.Item("U_AddonVersion").Value = addonVersion; table.UserFields.Fields.Item("U_AddonName").Value = addonName; table.UserFields.Fields.Item("U_CompanyVersion").Value = companyVersion; table.UserFields.Fields.Item("U_Date").Value = dt; table.UserFields.Fields.Item("U_LibVersion").Value = libVersion; table.UserFields.Fields.Item("U_LogType").Value = type.ToString(); table.UserFields.Fields.Item("U_Text").Value = text; table.UserFields.Fields.Item("U_Time").Value = Time; table.UserFields.Fields.Item("U_User").Value = user; table.UserFields.Fields.Item("U_FormID").Value = form; table.UserFields.Fields.Item("U_XMLException").Value = ""; table.UserFields.Fields.Item("U_Operation").Value = (opStack.Count == 0 ? "" : opStack.Peek()); table.Add(); table = null; LoggerDataObj.U_AddonVersion = addonVersion; LoggerDataObj.U_CompanyVersion = companyVersion; LoggerDataObj.U_Date = dt; LoggerDataObj.U_LibVersion = libVersion; LoggerDataObj.U_LogType = type.ToString(); LoggerDataObj.U_Text = text; LoggerDataObj.U_Time = Time; LoggerDataObj.U_User = user; } catch (Exception e) { LogManager.SaveLoggerData(LoggerDataObj); SB1ControlException.SB1ControlException.Save(e); //B1Connection.getInstance().App.SetStatusBarMessage("Erro ao escrever Log: " + e.Message, SAPbouiCOM.BoMessageTime.bmt_Long); } }
private Controller() { dBFacade = new DBFacade(); }
public AlertMessage() { this.logger = Logger.getInstance(); this.dbFacade = DBFacade.getInstance(); }
public List <ProductDto> Get() { DBFacade db = new DBFacade(); return(db.GetProducts()); }
public B1C() { this.connection = B1Connection.getInstance(); this.dbFacade = DBFacade.getInstance(); this.uiUtils = new UIUtils(connection); }
public ApprovalProcedures() { this.oDBFacade = DBFacade.getInstance(); }
public SAPObject() { this.logger = Logger.getInstance(); this.oDBFacade = DBFacade.getInstance(); }
public JournalEntryOp() { this.logger = Logger.getInstance(); this.dbFacade = DBFacade.getInstance(); this.connection = B1Connection.getInstance(); }