private int RunCommandWithTransatcion(VSM.Entities.BuWFRelationship ent, string vSql, IDbTransaction TRANS)
{
if (null == TRANS)
{
MySqlParameter[] paras = new MySqlParameter[ent.Column.Count];
for (int i = 0; i < ent.Column.Count; i++)
{
paras[i] = new MySqlParameter();
paras[i].ParameterName = ent.Column[i].FieldName;
paras[i].DbType = ent.Column[i].FieldType;
paras[i].Value = ent.Column[i].FieldValue;
}
return(DataBaseManage.ExecuteSql(vSql, paras));
}
else
{
System.Data.IDbCommand CM = TRANS.Connection.CreateCommand();
CM.CommandText = vSql;
CM.CommandType = CommandType.Text;
CM.Transaction = TRANS;
GetEntityDeleteParameter(CM, ent);
try
{
return(CM.ExecuteNonQuery());
}
catch (System.Exception e)
{
if (isDebug)
{
throw new Exception(e.Message);
}
return(0);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool ModifyDictType(DictTypeInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append("Update dicttypeinfo ");
sql.Append(" Set Name = '" + info.Name + "'");
sql.Append(" Where code = '" + info.Code + "'");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///修改密码
/// </summary>
/// <param name="UserId"></param>
/// <param name="OldPassword"></param>
/// <param name="NewPassword"></param>
/// <returns></returns>
public bool ModifyPassword(string UserCode, string NewPassword)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Update userinfo ");
sql.Append(" Set Password = '******'");
sql.Append(" Where usercode = '" + UserCode + "'");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool ModifyPower(PowerInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Update powerinfo ");
sql.Append(" Set powername = '" + info.PowerName + "',");
sql.Append(" powervalue = '" + info.PowerValue.ToString() + "' ");
sql.Append(" Where powerid = '" + info.PowerId.ToString() + "'");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool ModifyDept(DeptInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Update deptinfo ");
sql.Append(" Set deptname = '" + info.DeptName + "',");
sql.Append(" parentid = '" + info.ParentId + "', ");
sql.Append(" remark = '" + info.Remark + "', ");
sql.Append(" DEPTTYPE = '" + info.DeptType + "' ");
sql.Append(" Where deptid = '" + info.DeptId + "'");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool ModifyDict(DictInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append("Update dictinfo ");
sql.Append(" Set Name = '" + info.Name + "',");
sql.Append(" Type = '" + info.TypeCode + "',");
sql.Append(" remark = '" + info.Remark + "',");
sql.Append(" Sort = '" + info.Sort + "',");
sql.Append(" isenable = '" + info.IsEnable + "'");
sql.Append(" Where code = '" + info.Code + "' and Type='" + info.TypeCode + "'");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool CreatePower(PowerInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Insert Into powerinfo ");
sql.Append(" ( powername, powervalue, moudleid) ");
sql.Append(" Values( ");
sql.Append(" '" + info.PowerName + "',");
sql.Append(" '" + info.PowerValue.ToString() + "',");
sql.Append(" '" + info.MoudleId.ToString() + "'");
sql.Append(" ) ");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
public bool CreateDictType(DictTypeInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Insert Into dicttypeinfo ");
sql.Append(" (code, Name) ");
sql.Append(" Values ");
sql.Append(" ( ");
sql.Append(" '" + info.Code + "',");
sql.Append(" '" + info.Name + "'");
sql.Append(" )");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
public bool CreateDept(DeptInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Insert Into deptinfo ");
sql.Append(" ( deptid,deptname, parentid, remark,DEPTTYPE) ");
sql.Append(" Values( ");
sql.Append(" '" + info.DeptId + "',");
sql.Append(" '" + info.DeptName + "',");
sql.Append(" '" + info.ParentId + "',");
sql.Append(" '" + info.Remark + "',");
sql.Append(" '" + info.DeptType + "'");
sql.Append(" ) ");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool ModifyMoudle(MoudleInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Update moudleinfo ");
sql.Append(" Set moudlename = '" + info.MoudleName + "',");
sql.Append(" url = '" + info.Url + "', ");
sql.Append(" parentid = '" + info.ParentId + "', ");
sql.Append(" img = '" + info.Img + "', ");
sql.Append(" isenable = '" + info.IsEnable + "',");
sql.Append(" isroot = '" + info.IsRoot + "',");
sql.Append(" ywlx = '" + info.YWLX + "',");
sql.Append(" Sort = '" + info.Sort + "'");
sql.Append(" Where moudleid = '" + info.MoudleId + "'");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool CreatePost(PostInfo info)
{
StringBuilder Sql = new StringBuilder();
Sql.Append(" Insert Into postinfo ");
Sql.Append(" (code, Name,remark,isenable) ");
Sql.Append(" Values ");
Sql.Append(" ( ");
Sql.Append(" '" + info.Code + "', ");
Sql.Append(" '" + info.Name + "' , ");
Sql.Append(" '" + info.Remark + "' , ");
Sql.Append(" '" + info.IsEnable + "' ");
Sql.Append(" ) ");
return(DataBaseManage.ExecuteSql(Sql.ToString()) > 0);
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool ModifyUser(UserInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Update userinfo ");
sql.Append(" Set ");
sql.Append(" username = '******', ");
sql.Append(" email = '" + info.Email + "', ");
sql.Append(" address = '" + info.Address + "', ");
sql.Append(" deptid = '" + info.DeptId + "',");
sql.Append(" postcode = '" + info.PostCode + "',");
sql.Append(" telephone = '" + info.Telephone + "',");
sql.Append(" ZD = '" + info.ZD + "',");
sql.Append(" mobile = '" + info.Mobile + "'");
sql.Append(" Where userid = '" + info.UserId + "'");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool CreateDict(DictInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Insert Into dictinfo ");
sql.Append(" (code, Name, Type, remark, Sort, isenable) ");
sql.Append(" Values ");
sql.Append(" ( ");
sql.Append(" '" + info.Code + "',");
sql.Append(" '" + info.Name + "',");
sql.Append(" '" + info.TypeCode + "',");
sql.Append(" '" + info.Remark + "',");
sql.Append(" '" + info.Sort + "',");
sql.Append(" '" + info.IsEnable + "'");
sql.Append(" )");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool CreateMoudle(MoudleInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Insert Into moudleinfo ");
sql.Append(" ( moudlename, url, parentid, img, isenable, isroot,ywlx,Sort) ");
sql.Append(" Values( ");
sql.Append(" '" + info.MoudleName + "',");
sql.Append(" '" + info.Url + "',");
sql.Append(" '" + info.ParentId + "',");
sql.Append(" '" + info.Img + "',");
sql.Append(" '" + info.IsEnable + "',");
sql.Append(" '" + info.IsRoot + "',");
sql.Append(" '" + info.YWLX + "',");
sql.Append(" '" + info.Sort + "'");
sql.Append(" ) ");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
/// 创建新用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool CreateUser(UserInfo info)
{
StringBuilder sql = new StringBuilder();
sql.Append(" Insert Into userinfo ");
sql.Append(" ( usercode, username, Password, email, address, deptid, postcode, telephone, mobile,ZD) ");
sql.Append(" Values( ");
sql.Append(" '" + info.UserCode + "',");
sql.Append(" '" + info.UserName + "',");
sql.Append(" '123',");
sql.Append(" '" + info.Email + "',");
sql.Append(" '" + info.Address + "',");
sql.Append(" '" + info.DeptId + "',");
sql.Append(" '" + info.PostCode + "',");
sql.Append(" '" + info.Telephone + "',");
sql.Append(" '" + info.Mobile + "',");
sql.Append(" '" + info.ZD + "'");
sql.Append(" ) ");
return(DataBaseManage.ExecuteSql(sql.ToString()) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public bool DeleteDept(string DeptId)
{
string sql = "Delete deptinfo Where deptid = '" + DeptId + "' Or parentid='" + DeptId + "'";
return(DataBaseManage.ExecuteSql(sql) > 0);
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public bool DeleteUser(string UserId)
{
string Sql = string.Format("Delete userinfo Where userid = '{0}'", UserId);
return(DataBaseManage.ExecuteSql(Sql) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public bool DeletePower(string PowerId)
{
string sql = "Delete powerinfo Where powerid = '" + PowerId + "'";
return(DataBaseManage.ExecuteSql(sql) > 0);
}
/// <summary>
/// 逻辑删除
/// </summary>
/// <param name="Code"></param>
/// <returns></returns>
public bool DeleteDict(string Code, string Type)
{
string sql = string.Format(" Update dictinfo Set isenable = 'N' Where code = '{0}' and Type='{1}'", Code, Type);
return(DataBaseManage.ExecuteSql(sql) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="Code"></param>
/// <returns></returns>
public bool DeleteDictType(string Code)
{
string sql = string.Format("Delete dicttypeinfo Where code = '{0}'", Code);
return(DataBaseManage.ExecuteSql(sql) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public bool DeleteMoudle(string MoudleId)
{
string sql = "Delete moudleinfo Where moudleid = '" + MoudleId + "'";
return(DataBaseManage.ExecuteSql(sql) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public bool CreateRole(RoleInfo role)
{
string Sql = string.Format("Insert Into roleinfo(rolename,remark)Values('{0}','{1}')", role.RoleName, role.Remark);
return(DataBaseManage.ExecuteSql(Sql) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="Code"></param>
/// <returns></returns>
public bool DeletePost(string Code)
{
string Sql = string.Format("Delete postinfo Where code = '{0}'", Code.Trim());
return(DataBaseManage.ExecuteSql(Sql) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool ModifyPost(PostInfo info)
{
string Sql = string.Format("Update postinfo Set Name = '{1}',remark='{2}', isenable = '{3}' Where code = '{0}'", info.Code, info.Name, info.Remark, info.IsEnable);
return(DataBaseManage.ExecuteSql(Sql) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="RoleId"></param>
/// <returns></returns>
public bool DeleteRole(string RoleId)
{
string sql = "Delete roleinfo Where roleid = '" + RoleId + "'";
return(DataBaseManage.ExecuteSql(sql) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public bool ModifyRole(RoleInfo role)
{
string Sql = string.Format("Update roleinfo Set rolename = '{0}',remark = '{1}' Where roleid = '{2}'", role.RoleName, role.Remark, role.RoleId);
return(DataBaseManage.ExecuteSql(Sql) > 0);
}
