/// <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");
}
