private ProcName ParseProcName( ) { ProcName procName = new ProcName(); procName.FileContext = this.fileMY.FileContext; while (tape.CurrentKind != TokenKind.EOF && tape.CurrentKind != TokenKind.NewLine) { if (tape.CurrentKind == TokenKind.LBS) { var arg = ParseProcArg(); if (arg != null) { procName.AddArg(arg); } } else if (tape.CurrentKind == TokenKind.Ident) { procName.AddNamePart(tape.Current); tape.MoveNext(); } else if (tape.CurrentKind == TokenKind.Colon) { break; } } return(procName); }
public static int FieldCode_InsertUpdate(string strConn, int?FieldCodeId, int FieldClassId, string FieldCodeName, string FieldCodeAlias, string FieldCodeOrder, Guid?CompanyId) { const string ProcName = "FieldCode_InsertUpdate()"; SqlConnection connection = null; SqlParameter param; DateTime startDate = DateTime.Now; Guid LoginID = Guid.Empty; string strMessage = string.Empty; DataTable dt = new DataTable(); int rowsEffected; int returnValue; try { connection = DataSource.GetConnection(strConn); using (SqlCommand command = new SqlCommand()) { command.CommandText = ProcName.Substring(0, ProcName.Length - 2); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; param = command.Parameters.Add("@FieldCodeId", SqlDbType.Int); param.Value = FieldCodeId; param = command.Parameters.Add("@FieldClassId", SqlDbType.Int); param.Value = FieldClassId; param = command.Parameters.Add("@FieldCodeName", SqlDbType.VarChar); param.Value = FieldCodeName; param = command.Parameters.Add("@FieldCodeAlias", SqlDbType.VarChar); param.Value = FieldCodeAlias; param = command.Parameters.Add("@FieldCodeOrder", SqlDbType.VarChar); param.Value = FieldCodeOrder; param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier); param.Value = CompanyId; param = command.Parameters.Add("@ReturnValue", SqlDbType.Int); param.Direction = ParameterDirection.ReturnValue; rowsEffected = command.ExecuteNonQuery(); returnValue = (int)command.Parameters["@ReturnValue"].Value; } } finally { DataSource.CloseConnection(connection); TimeSpan timeSpan = DateTime.Now.Subtract(startDate); } return(returnValue); }
/// <summary> /// DataDic窗体refresh事件。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public virtual void cmd_refresh_ClickEvent(object sender, System.EventArgs e) { if (ProcName.CompareTo("") > 0) { Gf_DD_ReSelctDisp(GeneralCommon.M_CN1, "{call " + ProcName + "(" + ReComposeProcParam() + ")}", false); } else { Gf_DD_ReSelctDisp(GeneralCommon.M_CN1, QuerySQL + ReComposeWhereSQL(), false); } }
/// <summary> /// Converts to string. /// </summary> /// <returns> /// A <see cref="string" /> that represents this instance. /// </returns> public override string ToString() { var formalsString = string.Join(", ", Formals.Select(f => $"({f.ToString()})")); var localsString = string.Join(", ", Locals.Select(l => $"{l.ToString()}")); return($@"{{ ProcName: {ProcName.ToString()} Access: {Access.ToString()} Formals: {formalsString} Location: {Loc.ToString()} Locals: {localsString} ReturnType: {RetType.ToString()} }}"); }
/// <summary> /// DataDic窗体加载事件。 ///1设置页面的位置信息。 ///2调用ComposeWhereSQL(),生成完整where语句。 ///3 调用ssResult_Init(),ssWhere_Init()函数,初始化窗体,将sql语句传到数据库执行,并将结果返回到窗体中。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DataDic_Load(object sender, System.EventArgs e) { GeneralCommon.Gp_FormLoc_Get(this, "ETC"); if (ProcName.CompareTo("") > 0) { Gf_DD_ReSelctDisp(GeneralCommon.M_CN1, "{call " + ProcName + "(" + ComposeProcParam() + ")}", false); } else { ComposeWhereSQL(); Gf_DD_ReSelctDisp(GeneralCommon.M_CN1, QuerySQL + " " + ComposeWhereSQL(), false); } this.KeyPreview = true; this.DataDic_Activated(sender, e); }
public static int Delete_Process(string strConn, int ProcessId) { const string ProcName = "PROCESS_Delete()"; SqlConnection connection = null; SqlParameter param; DateTime startDate = DateTime.Now; Guid LoginID = Guid.Empty; string strMessage = string.Empty; DataTable dt = new DataTable(); int rowsEffected; int returnValue; try { connection = DataSource.GetConnection(strConn); using (SqlCommand command = new SqlCommand()) { command.CommandText = ProcName.Substring(0, ProcName.Length - 2); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; param = command.Parameters.Add("@ProcessId", SqlDbType.Int); param.Value = ProcessId; param = command.Parameters.Add("@ReturnValue", SqlDbType.Int); param.Direction = ParameterDirection.ReturnValue; rowsEffected = command.ExecuteNonQuery(); returnValue = (int)command.Parameters["@ReturnValue"].Value; } } finally { DataSource.CloseConnection(connection); TimeSpan timeSpan = DateTime.Now.Subtract(startDate); } return(returnValue); }
/// <summary> /// The cdata inner-text of the sql-query hbm.xml node. /// </summary> /// <returns></returns> public string ToHbmSql() { var hbmSql = new StringBuilder(); hbmSql.AppendLine(); hbmSql.Append(EXEC); if (ProcName.Contains(".")) { //schema names may have periods within them looking like [my.schema].[MyStoredProc] //so put braces around everything to the left and right of the last period var procNameParts = ProcName.Split('.').Where(x => !string.IsNullOrWhiteSpace(x)).ToList(); if (procNameParts.Count == 1) { hbmSql.AppendFormat("[{0}]", procNameParts[0]); } else if (procNameParts.Count == 2) { hbmSql.AppendFormat("[{0}].[{1}]", procNameParts[0], procNameParts[1]); } else { var leftSide = string.Format("[{0}]", string.Join(".", procNameParts.Take(procNameParts.Count - 1))); var rightSide = string.Format("[{0}]", procNameParts[(procNameParts.Count - 1)]); hbmSql.AppendFormat("{0}.{1}", leftSide, rightSide); } } else { hbmSql.AppendFormat("[{0}]", ProcName); } hbmSql.AppendLine(); if (Parameters != null && Parameters.Count > 0) { hbmSql.AppendLine(string.Join(",\n", Parameters.Select(x => x.ParamName.Replace("@", "\t:")))); } return(hbmSql.ToString()); }
private void ParseRequest(string requestMethod, string thePath, string rawUrl, string soapAction) { string requestPath = thePath.Substring(1); DadSpecifiedInRequest = true; IsFlexibleParams = false; IsPathAlias = false; string[] pathElements = requestPath.Split('/'); if (pathElements.Length >= 2) { ModuleName = pathElements[0]; DadName = pathElements[1]; if (DadName.Length == 0 || !DadConfiguration.IsValidDad(DadName)) { DadSpecifiedInRequest = false; DadName = DadConfiguration.DefaultDad; } // get dad-specific configuration settings DadConfig = new DadConfiguration(DadName); if (pathElements.Length >= 3) { ProcName = pathElements[2]; if (ProcName.Length > 0) { if (ProcName.Substring(0, 1) == "!") { IsFlexibleParams = true; } else if (ProcName == DadConfig.PathAlias) { IsPathAlias = true; PathAliasValue = GetAliasValue(ProcName, thePath); } else if (ProcName == DadConfig.XdbAlias) { IsXdbAlias = true; XdbAliasValue = GetAliasValue(ProcName, thePath); } else if (ProcName == DadConfig.DocumentPath) { IsDocumentPath = true; } } } else { // missing trailing slash in request ProcName = ""; } if (ProcName.Length == 0) { ProcName = DadConfig.DefaultPage; } if (DadConfig.InvocationProtocol == DadConfiguration.INVOCATION_PROTOCOL_SOAP) { IsSoapRequest = true; IsWsdlRequest = requestMethod.ToUpper() == "GET" && rawUrl.ToLower().EndsWith("?wsdl"); } if (IsSoapRequest && !IsWsdlRequest) { // get the procedure name from the SOAPAction header string methodName = soapAction.Replace("\"", ""); methodName = methodName.Substring(methodName.LastIndexOf("/") + 1); ProcName = ProcName + "." + StringUtil.ReversePrettyStr(methodName); } ProcName = SanitizeProcName(ProcName, DadConfig.ExclusionList); } else { ModuleName = ""; DadName = ""; ProcName = ""; } if (DadName.Length > 0 && ProcName.Length > 0) { string[] urlProcElements = ProcName.Split('.'); if (urlProcElements.Length == 3) { // schema, package and procedure specified OraSchema = urlProcElements[0]; OraPackage = urlProcElements[1]; OraProc = urlProcElements[2]; } else if (urlProcElements.Length == 2) { // assume package and procedure specified (although it could also be schema and procedure, but there is no way to be certain) OraSchema = ""; OraPackage = urlProcElements[0]; OraProc = urlProcElements[1]; } else { // just the procedure is specified OraSchema = ""; OraPackage = ""; OraProc = ProcName; } logger.Debug("Parsed module = " + ModuleName + ", dad = " + DadName + ", proc = " + ProcName); } }
public static int Rights_InsertUpdate(string strConn, int?RoleRightsId, int RoleId, int ModuleId, bool View, bool Edit, bool Create, bool Delete, Guid?CompanyId) { const string ProcName = "RoleRights_InsertUpdate()"; SqlConnection connection = null; SqlParameter param; DateTime startDate = DateTime.Now; Guid LoginID = Guid.Empty; string strMessage = string.Empty; DataTable dt = new DataTable(); int rowsEffected; int returnValue; try { connection = DataSource.GetConnection(strConn); using (SqlCommand command = new SqlCommand()) { command.CommandText = ProcName.Substring(0, ProcName.Length - 2); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; param = command.Parameters.Add("@RoleRightsId", SqlDbType.Int); param.Value = RoleRightsId; param = command.Parameters.Add("@RoleId", SqlDbType.Int); param.Value = RoleId; param = command.Parameters.Add("@ModuleId", SqlDbType.Int); param.Value = ModuleId; param = command.Parameters.Add("@View", SqlDbType.Bit); param.Value = View; param = command.Parameters.Add("@Edit", SqlDbType.Bit); param.Value = Edit; param = command.Parameters.Add("@Create", SqlDbType.Bit); param.Value = Create; param = command.Parameters.Add("@Delete", SqlDbType.Bit); param.Value = Delete; param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier); param.Value = CompanyId; param = command.Parameters.Add("@ReturnValue", SqlDbType.Int); param.Direction = ParameterDirection.ReturnValue; rowsEffected = command.ExecuteNonQuery(); returnValue = (int)command.Parameters["@ReturnValue"].Value; } } finally { DataSource.CloseConnection(connection); TimeSpan timeSpan = DateTime.Now.Subtract(startDate); } return(returnValue); }
public static int ProductInsert(string strConn, int?Productid, string ProductName, int UOM, int Colour, int Texture, Guid CreatedBy, string Processid, int BuyProductId, int BuyProductPacking, int Catagory, Guid CompanyId) { const string ProcName = "ProductMaster_InsertUpdate()"; SqlConnection connection = null; SqlParameter param; DateTime startDate = DateTime.Now; Guid LoginID = Guid.Empty; string strMessage = string.Empty; DataTable dt = new DataTable(); int rowsEffected; int returnValue; try { connection = DataSource.GetConnection(strConn); using (SqlCommand command = new SqlCommand()) { command.CommandText = ProcName.Substring(0, ProcName.Length - 2); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; param = command.Parameters.Add("@Productid", SqlDbType.Int); param.Value = Productid; param = command.Parameters.Add("@ProductName", SqlDbType.VarChar); param.Value = ProductName; param = command.Parameters.Add("@UOM", SqlDbType.Int); param.Value = UOM; param = command.Parameters.Add("@Colour", SqlDbType.Int); param.Value = Colour; param = command.Parameters.Add("@Texture", SqlDbType.Int); param.Value = Texture; param = command.Parameters.Add("@CreatedBy", SqlDbType.UniqueIdentifier); param.Value = CreatedBy; param = command.Parameters.Add("@ProcessId", SqlDbType.VarChar); param.Value = Processid; param = command.Parameters.Add("@BuyProductId", SqlDbType.Int); param.Value = BuyProductId; param = command.Parameters.Add("@Catagory", SqlDbType.Int); param.Value = Catagory; param = command.Parameters.Add("@BuyProductPacking", SqlDbType.Int); param.Value = BuyProductPacking; param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier); param.Value = CompanyId; param = command.Parameters.Add("@ReturnValue", SqlDbType.Int); param.Direction = ParameterDirection.ReturnValue; rowsEffected = command.ExecuteNonQuery(); returnValue = (int)command.Parameters["@ReturnValue"].Value; } } finally { DataSource.CloseConnection(connection); TimeSpan timeSpan = DateTime.Now.Subtract(startDate); } return(returnValue); }
public static int UOMMaster_InsertUpdate(string strConn, int UOMId, int UOMTypeId, string UOMName, string UOMCode, int DecimalPoints, bool BaseUnit, decimal ConversionRation, Guid?CreatedBy, Guid?ModifiedBy, Guid?CompanyId) { const string ProcName = "UOMMaster_InsertUpdate()"; SqlConnection connection = null; SqlParameter param; DateTime startDate = DateTime.Now; Guid LoginID = Guid.Empty; string strMessage = string.Empty; DataTable dt = new DataTable(); int rowsEffected; int returnValue; try { connection = DataSource.GetConnection(strConn); using (SqlCommand command = new SqlCommand()) { command.CommandText = ProcName.Substring(0, ProcName.Length - 2); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; param = command.Parameters.Add("@UOMId", SqlDbType.Int); param.Value = UOMId; param = command.Parameters.Add("@UOMTypeId", SqlDbType.Int); param.Value = UOMTypeId; param = command.Parameters.Add("@UOMName", SqlDbType.VarChar); param.Value = UOMName; param = command.Parameters.Add("@UOMCode", SqlDbType.VarChar); param.Value = UOMCode; param = command.Parameters.Add("@DecimalPoints", SqlDbType.Int); param.Value = DecimalPoints; param = command.Parameters.Add("@BaseUnit", SqlDbType.Bit); param.Value = BaseUnit; param = command.Parameters.Add("@ConversionRation", SqlDbType.Decimal); param.Value = ConversionRation; param = command.Parameters.Add("@CreatedBy", SqlDbType.UniqueIdentifier); param.Value = CreatedBy; param = command.Parameters.Add("@ModifiedBy", SqlDbType.UniqueIdentifier); param.Value = ModifiedBy; param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier); param.Value = CompanyId; param = command.Parameters.Add("@ReturnValue", SqlDbType.Int); param.Direction = ParameterDirection.ReturnValue; rowsEffected = command.ExecuteNonQuery(); returnValue = (int)command.Parameters["@ReturnValue"].Value; } } finally { DataSource.CloseConnection(connection); TimeSpan timeSpan = DateTime.Now.Subtract(startDate); } return(returnValue); }
public static int ProcessInsert(string strConn, int?ProcessId, string ProcessName, bool QuantityFlag, bool PackingFlag, String ProcessDuration, float ProcessVolume, bool WastageFlag, int ProcessUnit, Guid?CompanyId, bool byProduct) { const string ProcName = "ProcessMaster_InserUpdate()"; SqlConnection connection = null; SqlParameter param; DateTime startDate = DateTime.Now; Guid LoginID = Guid.Empty; string strMessage = string.Empty; DataTable dt = new DataTable(); int rowsEffected; int returnValue; try { connection = DataSource.GetConnection(strConn); using (SqlCommand command = new SqlCommand()) { command.CommandText = ProcName.Substring(0, ProcName.Length - 2); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; param = command.Parameters.Add("@ProcessId", SqlDbType.Int); param.Value = ProcessId; param = command.Parameters.Add("@ProcessName", SqlDbType.VarChar); param.Value = ProcessName; param = command.Parameters.Add("@QuantityFlag", SqlDbType.Bit); param.Value = QuantityFlag; param = command.Parameters.Add("@PackingFlag", SqlDbType.Bit); param.Value = PackingFlag; param = command.Parameters.Add("@ProcessDuration", SqlDbType.Time); param.Value = ProcessDuration; param = command.Parameters.Add("@WastageFlag", SqlDbType.Bit); param.Value = WastageFlag; param = command.Parameters.Add("@QuantityFlag", SqlDbType.Bit); param.Value = QuantityFlag; param = command.Parameters.Add("@ByProduct", SqlDbType.Bit); param.Value = byProduct; param = command.Parameters.Add("@ProcessVolume", SqlDbType.Float); param.Value = ProcessVolume; param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier); param.Value = CompanyId; param = command.Parameters.Add("@ReturnValue", SqlDbType.Int); param.Direction = ParameterDirection.ReturnValue; param = command.Parameters.Add("@ProcessUnit", SqlDbType.Int); param.Value = ProcessUnit; rowsEffected = command.ExecuteNonQuery(); returnValue = (int)command.Parameters["@ReturnValue"].Value; } } finally { DataSource.CloseConnection(connection); TimeSpan timeSpan = DateTime.Now.Subtract(startDate); } return(returnValue); }
static void Main(string[] args) { Application.SetHighDpiMode(HighDpiMode.SystemAware); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.SetUnhandledExceptionMode(UnhandledExceptionMode.CatchException); AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(UnhandledExceptionMessageBox); Application.ThreadException += new ThreadExceptionEventHandler(UIThreadUnhandledExceptionMessageBox); TheMutex = new Mutex(true, "GFEAppManager"); if (!TheMutex.WaitOne(TimeSpan.Zero, true)) { MessageBox.Show(owner: null, text: "An instance of application is already running!", caption: "Error", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); System.Environment.Exit(1); } if (args.Length >= 1) { if (args[0] == "startup") { // Lets make sure that the tray icon is visible after login by restarting the app with significant delay ProcessStartInfo Info = new ProcessStartInfo(); string ThePath = System.Reflection.Assembly.GetExecutingAssembly().Location.Remove(System.Reflection.Assembly.GetExecutingAssembly().Location.Length - 4) + ".exe"; Info.Arguments = "/C ping 127.0.0.1 -n 4 && start \"\" \"" + ThePath + "\""; Info.WindowStyle = ProcessWindowStyle.Hidden; Info.CreateNoWindow = true; Info.FileName = "cmd.exe"; Process.Start(Info); System.Environment.Exit(0); } } try { TheServiceOperations.CheckService(); } catch (InvalidOperationException) { MessageBox.Show(owner: null, text: "Could not find the GeForce® Experience™ service!", caption: "Error", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); System.Environment.Exit(1); } try { string[] Lines = File.ReadAllLines(ConfigFileLocation); foreach (string ProcName in Lines) { if (!ProcName.EndsWith(".exe")) { MessageBox.Show(owner: null, text: "You need to enter a process with .exe extension!", caption: "Error", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); System.Environment.Exit(1); } if (ListOfApplicationsToDisableService.Keys.Any(x => x.ToLower() == ProcName.ToLower())) { MessageBox.Show(owner: null, text: "The process is already in list!", caption: "Error", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); System.Environment.Exit(1); } ListOfApplicationsToDisableService.TryAdd(ProcName, ProcName); } } catch (FileNotFoundException) { // Default example app list ListOfApplicationsToDisableService.TryAdd("vmplayer.exe", "vmplayer.exe"); ListOfApplicationsToDisableService.TryAdd("WindowsTerminal.exe", "WindowsTerminal.exe"); SaveConfigFile(); } TheMainAppContext = new MainAppContext(); TheServiceOperations.BeginListening(); Application.Run(TheMainAppContext); }