/// <summary> /// 根据SQL参数重复执行SQL语句 /// </summary> /// <returns>受影响的行数</returns> public virtual int ExecuteSql() { int rowsCount = -1; Conn = new SqlConnection(this.ConnectionString); Conn.Open(); connIsOpen = true; Sqltrans = Conn.BeginTransaction(IsolationLevel.ReadCommitted, SqlTransactionName); SqlCommand cmd = new SqlCommand(); cmd.Connection = Conn; cmd.CommandText = CmdText; cmd.Transaction = Sqltrans; cmd.CommandType = CommandType.Text;//cmdType; if (CmdParams != null) { cmd.Parameters.AddRange(CmdParams.ToArray()); rowsCount = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } //Sqltrans.Commit(); return(rowsCount); }
/// <summary> /// Creates the command. /// </summary> /// <param name="conn">The conn.</param> /// <param name="commandText">The command text.</param> /// <param name="cmdParams">The CMD params.</param> /// <returns>DbCommand.</returns> public static DbCommand CreateCommand(DbConnection conn, string commandText, CmdParams cmdParams) { if (conn.State == ConnectionState.Closed) { conn.Open(); } var result = conn.CreateCommand(); result.CommandText = commandText; result.CommandType = CommandType.Text; if (cmdParams != null) { foreach (var param in cmdParams) { var value = param.Value switch { Guid guid => guid.ToGuidStr(), bool b => b.ToShort(), _ => param.Value }; result.AddParam(param.Key, value); } } return(result); }
private void btnCheckConnection1C_Click(object sender, EventArgs e) { try { var res = MainSettings.GetExePath1C(txtVersion1C.Text); if (!res.IsComplete) { MessageBox.Show(this, res.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var resLogPath = MainSettings.GetLogPath1C(); if (!resLogPath.IsComplete) { MessageBox.Show(this, resLogPath.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (!Check1CInstallationWithMessage()) { return; } string exceptionMsg; CmdParams cmdParams = new CmdParams(); bool check1C = false; if (_is1CBaseOnServer) { check1C = Checks1C.Check1C_Connection(cmdParams.GetConnectionstring1CServerBase(tbServerOrPath1C.Text, tbBase1C.Text, txtUser1C.Text, txtPass1C.Text), out exceptionMsg); } else { check1C = Checks1C.Check1C_Connection(cmdParams.GetConnectionstring1CFileBase(tbServerOrPath1C.Text, txtUser1C.Text, txtPass1C.Text), out exceptionMsg); } if (check1C) { MessageBox.Show(this, "Успешное подключение к базе 1С", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { string msg = "Ошибка подключения к базе 1С"; if (!string.IsNullOrEmpty(exceptionMsg)) { msg = $"{msg}\r\nПричина: {exceptionMsg}"; } MessageBox.Show(this, msg, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { LogString(ex.ToString()); MessageBox.Show(this, $"Не удалось проверить подключение к 1С. Флаг \"Проверка установки 1С при старте будет снят\".{Environment.NewLine}Причина: {ex.Message}", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); cbIsCheck1C.Checked = false; } }
public static bool Set(Model.UsrRole usrRoleModel, List <string> RoleIdList) { List <CmdParams> parameters = new List <CmdParams>(); /*先清空原有关系*/ CmdParams cpDel = new CmdParams { cmd = "delete from usrrole where usrId=?usrId", param = new DynamicParameters() }; cpDel.param.Add("?usrId", usrRoleModel.usrId); parameters.Add(cpDel); if (RoleIdList == null) { RoleIdList = new List <string>(); } /*默认游客角色编号*/ string strDefaultRole = "4b5df8d4-e422-48b4-8138-7fd6806dd214"; if (!RoleIdList.Contains(strDefaultRole)) { /*添加默认游客角色权限*/ RoleIdList.Add(strDefaultRole); } /*循环赋予角色*/ foreach (string strRoleId in RoleIdList) { if (HelpCenter.Repository.Role.GetModel(strRoleId) == null) { //不存在的角色不允许添加到数据表里 //修改人CJC,2018.12.18.13:29:00 continue; } CmdParams cp = new CmdParams { cmd = "insert into usrrole(usrRoleId,usrId,roleId,usrRoleState,crdt,crUsrId,updt,upUsrId) values (?usrRoleId,?usrId,?roleId,?usrRoleState,?crdt,?crUsrId,?updt,?upUsrId)", param = new DynamicParameters() }; cp.param.Add("?usrRoleId", Guid.NewGuid().ToString()); cp.param.Add("?usrId", usrRoleModel.usrId); cp.param.Add("?roleId", strRoleId); cp.param.Add("?usrRoleState", usrRoleModel.usrRoleState); cp.param.Add("?crdt", usrRoleModel.crdt); cp.param.Add("?crUsrId", usrRoleModel.crUsrId); cp.param.Add("?updt", usrRoleModel.updt); cp.param.Add("?upUsrId", usrRoleModel.upUsrId); parameters.Add(cp); } int rows = mysql.ExcuteNonQueryTransaction <Model.UsrRole>(DapperMySQLHelper.ConnectionString, parameters, false); return(rows > 0); }
public void Add(string constraint, CmdParams Params) { _Constraints.Add(constraint); if(Params != null) { foreach( var p in Params ) { this.Params.Add(p.Key, p.Value); } } }
protected override void InitCommand() { Init = ParseBoolParameter(CmdParams.Get("init")); Target = CmdParams.Get("target"); Tree = ParseBoolParameter(CmdParams.Get("tree")); if (!Init && string.IsNullOrEmpty(Target)) { throw new InvalidOperationException("Terget required where not init"); } }
/// <summary> /// Adds the specified constraint. /// </summary> /// <param name="constraint">The constraint.</param> /// <param name="params">The params.</param> public void Add(string constraint, CmdParams @params) { Constraints.Add(constraint); if (@params != null) { foreach (var p in @params) { Params.Add(p.Key, p.Value); } } }
/// <summary> /// 获取InsUserType信息 /// </summary> /// <param name="InsUserTypeId">主键</param> public InsUserTypeDO GetInsusertype(Guid InsUserTypeId) { var cmd = new CmdParams { { "@InsUserTypeId", InsUserTypeId } }; string sql = String.Format("SELECT * FROM {0}(NOLOCK) WHERE InsUserTypeId=@InsUserTypeId", GetTableName(InsUserTypeDO.TableName)); using (DbConnection conn = GetConn()) { return(DBTools.ExecuteReader <InsUserTypeDO>(conn, sql, cmd)); } }
/// <summary> /// 获取MediaTask信息 /// </summary> /// <param name="MediaTaskId">主键</param> public MediaTaskDO GetMediatask(Guid MediaTaskId) { var cmd = new CmdParams { { "@MediaTaskId", MediaTaskId } }; string sql = String.Format("SELECT * FROM {0}(NOLOCK) WHERE MediaTaskId=@MediaTaskId", GetTableName(MediaTaskDO.TableName)); using (DbConnection conn = GetConn()) { return(DBTools.ExecuteReader <MediaTaskDO>(conn, sql, cmd)); } }
/// <summary> /// 获取DownloadLog信息 /// </summary> /// <param name="LogId">主键</param> public DownloadLogDO GetDownloadlog(Guid LogId) { var cmd = new CmdParams { { "@LogId", LogId } }; string sql = String.Format("SELECT * FROM {0}(NOLOCK) WHERE LogId=@LogId", GetTableName(DownloadLogDO.TableName)); using (DbConnection conn = GetConn()) { return(DBTools.ExecuteReader <DownloadLogDO>(conn, sql, cmd)); } }
/// <summary> /// Executes the reader enum. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="conn">The conn.</param> /// <param name="commandText">The command text.</param> /// <param name="cmdParams">The CMD params.</param> /// <param name="func">The func.</param> /// <returns>IEnumerable{``0}.</returns> public static IEnumerable <T> ExecuteReaderEnum <T>( DbConnection conn, string commandText, CmdParams cmdParams, Func <IDataReader, T> func) { using var cmd = CreateCommand(conn, commandText, cmdParams); using var reader = cmd.ExecuteReader(); while (reader.Read()) { yield return(func(reader)); } }
protected override void InitCommand() { Target = CmdParams.Get("target"); UploadPaths = CmdParams.GetValues("upload_path[]"); MTimes = CmdParams.GetValues("mtime[]"); Names = CmdParams.GetValues("name[]"); Renames = CmdParams.GetValues("renames[]"); Suffix = CmdParams.Get("suffix"); Hashes = ParseDict("hashes", CmdParams); Overwrite = ParseBoolParameter(CmdParams.Get("overwrite")); Chunk = CmdParams.Get("chunk"); ChunkId = CmdParams.Get("cid"); Range = CmdParams.Get("range"); }
/// <summary> /// Executes the reader struct. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="conn">The conn.</param> /// <param name="commandText">The command text.</param> /// <param name="cmdParams">The CMD params.</param> /// <param name="func">The func.</param> /// <returns>``0.</returns> public static T ExecuteReaderStruct <T>( DbConnection conn, string commandText, CmdParams cmdParams, Func <IDataReader, T> func) where T : struct { using var cmd = CreateCommand(conn, commandText, cmdParams); using var reader = cmd.ExecuteReader(); if (reader.Read()) { return(func(reader)); } return(default);
public static bool Add(List <Model.DocUsrRole> docUsrRoleList) { int rows = 0; List <CmdParams> parameters = new List <CmdParams>(); using (var tran = new TransactionScope()) { /*先清空原有关系*/ CmdParams cpDel = new CmdParams { cmd = "delete from docUsrRole where /*roleId=?roleId and */docId=?docId", param = new DynamicParameters() }; //cpDel.param.Add("?roleId", item.roleId); cpDel.param.Add("?docId", docUsrRoleList[0].docId); parameters.Add(cpDel); mysql.ExcuteNonQuery <Model.DocUsrRole>(DapperMySQLHelper.ConnectionString, cpDel.cmd, cpDel.param, false); foreach (var item in docUsrRoleList) { CmdParams cp = new CmdParams { cmd = "insert into docUsrRole(docRoleId,docId,roleId,docRoleState,crdt,crUsrId,updt,upUsrId) values (?docRoleId,?docId,?roleId,?docRoleState,?crdt,?crUsrId,?updt,?upUsrId)", param = new DynamicParameters() }; cp.param.Add("?docRoleId", Guid.NewGuid().ToString()); cp.param.Add("?roleId", item.roleId); cp.param.Add("?docId", item.docId); cp.param.Add("?docRoleState", 1); cp.param.Add("?crdt", item.crdt); cp.param.Add("?crUsrId", item.crUsrId); cp.param.Add("?updt", item.updt); cp.param.Add("?upUsrId", item.upUsrId); //parameters.Add(cp); rows = mysql.ExcuteNonQuery <Model.DocUsrRole>(DapperMySQLHelper.ConnectionString, cp.cmd, cp.param, false); } tran.Complete(); } /*调用事务处理*/ //int rows = mysql.ExcuteNonQueryTransaction<Model.DocUsrRole>(DapperMySQLHelper.ConnectionString, parameters, false); return(rows > 0); }
public static bool Delete(Model.DocUsrRole docUsrRole) { /*先清空原有关系*/ CmdParams cpDel = new CmdParams { cmd = "delete from docUsrRole where roleId=?roleId and docId=?docId", param = new DynamicParameters() }; cpDel.param.Add("?roleId", docUsrRole.roleId); cpDel.param.Add("?docId", docUsrRole.docId); /*调用事务处理*/ int rows = mysql.ExcuteNonQuery <Model.DocUsrRole>(DapperMySQLHelper.ConnectionString, cpDel.cmd, cpDel.param, false); return(rows > 0); }
public static bool Set(Model.RoleSysModule roleSysModule, string[] roleSysModuleList) { List <CmdParams> parameters = new List <CmdParams>(); /*先清空原有关系*/ CmdParams cpDel = new CmdParams { cmd = "delete from roleSysModule where roleId=?roleId", param = new DynamicParameters() }; cpDel.param.Add("?roleId", roleSysModule.RoleId); parameters.Add(cpDel); /*批量更新到最新关系*/ foreach (var item in roleSysModuleList) { CmdParams cp = new CmdParams { cmd = "insert into roleSysModule(roleSysModuleId,sysModuleId,roleId,roleSysModuleState,crdt,crUsrId,updt,upUsrId) values (?roleSysModuleId,?sysModuleId,?roleId,?roleSysModuleState,?crdt,?crUsrId,?updt,?upUsrId)", param = new DynamicParameters() }; cp.param.Add("?roleSysModuleId", Guid.NewGuid().ToString()); cp.param.Add("?sysModuleId", item); cp.param.Add("?roleId", roleSysModule.RoleId); cp.param.Add("?roleSysModuleState", roleSysModule.RoleSysModuleState); cp.param.Add("?crdt", roleSysModule.Crdt); cp.param.Add("?crUsrId", roleSysModule.CrUsrId); cp.param.Add("?updt", roleSysModule.Updt); cp.param.Add("?upUsrId", roleSysModule.UpUsrId); parameters.Add(cp); } /*调用事务处理*/ int rows = mysql.ExcuteNonQueryTransaction <Model.RoleSysModule>(DapperMySQLHelper.ConnectionString, parameters, false); return(rows > 0); }
public static bool Add(Model.DocUsrRole docUsrRole) { List <CmdParams> parameters = new List <CmdParams>(); /*先清空原有关系*/ CmdParams cpDel = new CmdParams { cmd = "delete from docUsrRole where roleId=?roleId and docId=?docId", param = new DynamicParameters() }; cpDel.param.Add("?roleId", docUsrRole.roleId); cpDel.param.Add("?docId", docUsrRole.docId); //parameters.Add(cpDel); mysql.ExcuteNonQuery <Model.DocUsrRole>(DapperMySQLHelper.ConnectionString, cpDel.cmd, cpDel.param, false); CmdParams cp = new CmdParams { cmd = "insert into docUsrRole(docRoleId,docId,roleId,docRoleState,crdt,crUsrId,updt,upUsrId) values (?docRoleId,?docId,?roleId,?docRoleState,?crdt,?crUsrId,?updt,?upUsrId)", param = new DynamicParameters() }; cp.param.Add("?docRoleId", Guid.NewGuid().ToString()); cp.param.Add("?roleId", docUsrRole.roleId); cp.param.Add("?docId", docUsrRole.docId); cp.param.Add("?docRoleState", 1); cp.param.Add("?crdt", docUsrRole.crdt); cp.param.Add("?crUsrId", docUsrRole.crUsrId); cp.param.Add("?updt", docUsrRole.updt); cp.param.Add("?upUsrId", docUsrRole.upUsrId); // parameters.Add(cp); int rows = mysql.ExcuteNonQuery <Model.DocUsrRole>(DapperMySQLHelper.ConnectionString, cp.cmd, cp.param, false); /*调用事务处理*/ //int rows = mysql.ExcuteNonQueryTransaction<Model.DocUsrRole>(DapperMySQLHelper.ConnectionString, parameters, false); return(rows > 0); }
public static bool Set(Model.DocDeptRole docDeptRole, List <string> shareDeptList) { int rows = 0; List <CmdParams> parameters = new List <CmdParams>(); /*先清空原有关系*/ CmdParams cpDel = new CmdParams { cmd = "delete from docdeptrole where docId=?docId", param = new DynamicParameters() }; cpDel.param.Add("?docId", docDeptRole.DocId); mysql.ExcuteNonQuery <Model.DocDeptRole>(DapperMySQLHelper.ConnectionString, cpDel.cmd, cpDel.param, false); /*批量更新到最新关系*/ foreach (var item in shareDeptList) { rows = 0; CmdParams cp = new CmdParams { cmd = "insert into docdeptrole(docDeptRoleId,docId,deptId,docDeptState,crdt,crUsrId,updt,upUsrId) values (?docDeptRoleId,?docId,?deptId,?docDeptState,?crdt,?crUsrId,?updt,?upUsrId)", param = new DynamicParameters() }; cp.param.Add("?docDeptRoleId", docDeptRole.DocDeptRoleId); cp.param.Add("?docId", docDeptRole.DocId); cp.param.Add("?deptId", item); cp.param.Add("?docDeptState", docDeptRole.DocDeptState); cp.param.Add("?crdt", docDeptRole.Crdt); cp.param.Add("?crUsrId", docDeptRole.CrUsrId); cp.param.Add("?updt", docDeptRole.Updt); cp.param.Add("?upUsrId", docDeptRole.CrUsrId); rows = mysql.ExcuteNonQuery <Model.DocDeptRole>(DapperMySQLHelper.ConnectionString, cp.cmd, cp.param, false); } return(rows > 0); }
protected override void InitCommand() { Target = CmdParams.Get("target"); Intersect = CmdParams.GetValues("intersect[]") ?? new string[0]; }
/// <summary> /// Executes the reader. /// </summary> /// <param name="conn">The conn.</param> /// <param name="commandText">The command text.</param> /// <param name="cmdParams">The CMD params.</param> /// <returns>IDataReader.</returns> public static IDataReader ExecuteReader(DbConnection conn, string commandText, CmdParams cmdParams) { using var cmd = CreateCommand(conn, commandText, cmdParams); return(cmd.ExecuteReader()); }
public FilterConstraints() { _Constraints = new List<string>(); Params = new CmdParams(); }
protected override void InitCommand() { Target = CmdParams.Get("target"); Until = CmdParams.Get("until"); }
/// <summary> /// Executes the non query. /// </summary> /// <param name="conn">The conn.</param> /// <param name="commandText">The command text.</param> /// <param name="cmdParams">The CMD params.</param> /// <returns>System.Int32.</returns> public static int ExecuteNonQuery(DbConnection conn, string commandText, CmdParams cmdParams) { using var cmd = CreateCommand(conn, commandText, cmdParams); return(cmd.ExecuteNonQuery()); }
protected override void InitCommand() { Target = CmdParams.Get("target"); DirectoryName = CmdParams.Get("name"); Dirs = CmdParams.GetValues("dirs[]"); }
/// <summary> /// Initializes a new instance of the <see cref="FilterConstraints" /> class. /// </summary> public FilterConstraints() { Constraints = new List <string>(); Params = new CmdParams(); }
public static Hashtable ParameterBasis() { Hashtable x = new Hashtable(System.Enum.GetValues(typeof(NCCFlags)).Length); foreach (NCCFlags e in System.Enum.GetValues(typeof(NCCFlags))) { CmdParams f = new CmdParams(); x.Add(e, f); } return x; }
protected override void InitCommand() { Target = CmdParams.Get("target"); IsDownload = ParseBoolParameter(CmdParams.Get("download")); CookiePath = CmdParams.Get("cpath"); }
protected override void InitCommand() { Targets = CmdParams.GetValues("targets[]"); }
protected override void InitCommand() { Target = CmdParams.Get("target"); NewName = CmdParams.Get("name"); }