/// <summary> /// /// </summary> /// <param name="bindTableID"></param> /// <param name="bindTableName"></param> /// <param name="customType"></param> public void DeleteAttach(int?bindTableID, string bindTableName, int?customType) { if (string.IsNullOrEmpty(bindTableName)) { throw new Exception("BindTableName不允许为空"); } List <SysAttachInfo> list = BiAttachHelper.GetSysAttachList(bindTableName, bindTableID, customType); foreach (SysAttachInfo attach in list) { if (attach.Mode == 1) { string filepath = this.MapPath(attach.FilePath); if (File.Exists(filepath)) { File.Delete(filepath); } } } string sql = "DELETE FROM SysAttach WHERE BindTableName = '" + bindTableName + "'"; if (bindTableID.HasValue) { sql += " AND BindTableID = " + bindTableID; } if (customType.HasValue) { sql += " AND CustomType = " + customType; } DBHelperProxy.ExecuteNonQuery(sql); }
public static long Save(int unitid, OperateEnum.OperateType operateType, int userID, string userName, string tableBind, string operateContent) { long id = DBHelperProxy.GetMaxID("OperateLog"); DBHelperProxy.ExecuteNonQuery(string.Format("INSERT INTO OperateLog(ID,UnitID,OperateType,UserID,UserName,TableBind,OperateTime,OperateContent) VALUES({0},{1},{2},{3},'{4}','{5}','{6}','{7}') ", id, unitid, Convert.ToInt32(operateType), userID, userName, tableBind, DateTime.Now, operateContent)); return(id); }
public void AddUserToAdminRole(long userID, long unitID) { RoleBO role = new RoleBO(); long roleID = Convert.ToInt32(role.GetRoleIDByCode("Admin")); string strSQL = "Insert Into RoleUser(RoleID, UserID, UnitID) Values(" + roleID + "," + userID + "," + unitID + ")"; DBHelperProxy.ExecuteNonQuery(strSQL); }
/// <summary> /// 保存排序 /// </summary> /// <param name="IDs"></param> /// <param name="values"></param> public void SaveSequence(List <int> ids, List <int> values) { StringBuilder sbSql = new StringBuilder(); for (int i = 0; i < ids.Count; i++) { sbSql.Append("update Dept set Sequence=" + values[i] + " where ID=" + ids[i] + ";"); } DBHelperProxy.ExecuteNonQuery(sbSql.ToString()); }
public void SaveAccess(List <int> rids, int role, int unitid) { StringBuilder sbSql = new StringBuilder("delete from ActionSourceAccess where RoleID =" + role + " And UnitID=" + unitid + "; "); foreach (int id in rids) { sbSql.Append("insert into ActionSourceAccess(RoleID,SourceID, UnitID) values(" + role + "," + id + "," + unitid + "); "); } DBHelperProxy.ExecuteNonQuery(sbSql.ToString()); }
/// <summary> /// 保存角色用户 /// </summary> /// <param name="iRoleID"></param> /// <param name="lstUserIDs"></param> public void SaveUserIDs(int iRoleID, List <int> lstUserIDs, int sUnitID) { StringBuilder sbSql = new StringBuilder(); sbSql.Append("delete from RoleUser where RoleID=" + iRoleID + " And UnitID=" + sUnitID); foreach (int iUserID in lstUserIDs) { sbSql.Append(";insert into RoleUser(RoleID,UserID, UnitID) values(" + iRoleID + "," + iUserID + ", " + sUnitID + ") "); } DBHelperProxy.ExecuteNonQuery(sbSql.ToString()); }
/// <summary> /// 保存角色模块集合 /// </summary> /// <param name="iRoleID"></param> /// <param name="lstModuleIDs"></param> public void SaveModuleIDs(int iRoleID, List <int> lstModuleIDs, int sUnitID) { StringBuilder sbSql = new StringBuilder("delete from ModuleAccess where flag=1 and UserRoleID =" + iRoleID + " And UnitID=" + sUnitID + "; "); foreach (int id in lstModuleIDs) { sbSql.Append("insert into ModuleAccess(UserRoleID,ModuleID,flag, UnitID) values(" + iRoleID + "," + id + ",1, " + sUnitID + "); "); } DBHelperProxy.ExecuteNonQuery(sbSql.ToString()); }
/// <summary> /// 删除角色 /// </summary> /// <param name="lstSelectIDs"></param> public void Delete(List <int> lstSelectIDs) { string strIDs = "0"; foreach (int id in lstSelectIDs) { strIDs += "," + id; } string strSql = "delete from Role where id IN(" + strIDs + ");delete from RoleUser where RoleID IN(" + strIDs + ");"; DBHelperProxy.ExecuteNonQuery(strSql); }
/// <summary> /// 将用户从角色用户表中剔除 /// </summary> /// <param name="DelUserIDS"></param> /// <param name="UnitID"></param> public void DelUserFromRole(List <int> delUserIDS, int unitID) { string strIDS = "0"; foreach (int id in delUserIDS) { strIDS += "," + id; } string strSQL = "Delete From RoleUser Where UserID In (" + strIDS + ") And UnitID=" + unitID; DBHelperProxy.ExecuteNonQuery(strSQL); }
public static bool Registe(string serial, string unitName) { if (ALEncrypt.Md5hash(unitName + "sudenggang") != serial) { return(false); } else { DBHelperProxy.ExecuteNonQuery(string.Format("Update Dept set Code='{0}',Name='{1}' Where ID=-1;Update Dept set Name='{1}' Where ID=1;", serial, unitName)); // DBHelperProxy.ExecuteNonQuery(string.Format("Update ContactDir set Name='{0}' Where DeptID=1;",unitName)); return(true); } }
/// <summary> /// 获得根ID /// </summary> /// <returns></returns> public static int GetRootID() { string strSql = "select ID from Dept where ParentID=0"; DataTable dt = DBHelperProxy.GetDataSet(strSql).Tables[0]; int iRootID; if (dt.Rows.Count > 0) { iRootID = (int)dt.Rows[0]["ID"]; } else { strSql = "insert into Dept ( Name, ParentID, Layer, Path, Sequence, IsStop) " + "values('根部门',0,0,',',0,1)"; DBHelperProxy.ExecuteNonQuery(strSql); iRootID = GetRootID(); } return(iRootID); }
public bool ImportDictXml(XmlDocument doc) { //因为专用数据字典表的,不想再建数据字典的数据实体了,所以用sql语句写死了 XmlElement root = doc.DocumentElement; foreach (XmlNode nodeDictType in root.ChildNodes) { if (nodeDictType.Attributes.Count == 0) { continue; } string attDictTypeNameValue = nodeDictType.Attributes["Name"].Value; string strSql = "select ID from DictType where name=" + DBHelperProxy.FormatParameter("DictTypeName"); var parDictTypeName = DBHelperProxy.CreateParameter("DictTypeName", attDictTypeNameValue); long dictTypeID = Convert.ToInt32(DBHelperProxy.ExecuteScalar(strSql, parDictTypeName)); var parDictTypeID = DBHelperProxy.CreateParameter("DictTypeID", dictTypeID); if (dictTypeID <= 0)//if no exists then add 'DictType ' { dictTypeID = DBHelperProxy.GetMaxID("DictType"); parDictTypeID.Value = dictTypeID; strSql = "insert into DictType(ID,Name) values (" + DBHelperProxy.FormatParameter("DictTypeID") + "," + DBHelperProxy.FormatParameter("DictTypeName") + ");"; if (DBHelperProxy.ExecuteNonQuery(strSql, parDictTypeID, parDictTypeName) == 0) { return(false); } } foreach (XmlNode nodeDictDir in nodeDictType.ChildNodes) { if (nodeDictDir.Attributes.Count == 0) { continue; } strSql = "if exists(select ID from DictDir where name=" + DBHelperProxy.FormatParameter("DictDirName") + " and TypeID=" + DBHelperProxy.FormatParameter("DictTypeID") + ")begin delete DictItem where DirID in (select ID from DictDir where name=" + DBHelperProxy.FormatParameter("DictDirName") + " and TypeID=" + DBHelperProxy.FormatParameter("DictTypeID") + ");delete DictDir where name=" + DBHelperProxy.FormatParameter("DictDirName") + " and TypeID=" + DBHelperProxy.FormatParameter("DictTypeID") + ";end;";//if exists then delete 'DictDir' and 'DictItem' strSql += "insert into DictDir(ID,UnitID,Name,TypeID,Remark) values (" + DBHelperProxy.FormatParameter("DictDirID") + "," + DBHelperProxy.FormatParameter("UnitID") + "," + DBHelperProxy.FormatParameter("DictDirName") + "," + DBHelperProxy.FormatParameter("DictTypeID") + "," + DBHelperProxy.FormatParameter("Remark") + ");"; var parDictDirID = DBHelperProxy.CreateParameter("DictDirID", DBHelperProxy.GetMaxID("DictDir")); var parDictDirName = getSqlParameter("DictDirName", nodeDictDir.Attributes["Name"]); var parUnitID = getSqlParameter("UnitID", nodeDictDir.Attributes["UnitID"]); var parDictDirRemark = getSqlParameter("Remark", nodeDictDir.Attributes["Remark"]); if (DBHelperProxy.ExecuteNonQuery(strSql, parDictDirName, parDictDirID, parUnitID, parDictTypeID, parDictDirRemark) == 0) { return(false); } foreach (XmlNode nodeDictItem in nodeDictDir.ChildNodes) { if (nodeDictItem.Attributes.Count == 0) { continue; } strSql = "insert into DictItem (ID,DirID,Name,Code,Sequence) values (" + DBHelperProxy.FormatParameter("DictItemID") + "," + DBHelperProxy.FormatParameter("DictDirID") + "," + DBHelperProxy.FormatParameter("DictItemName") + "," + DBHelperProxy.FormatParameter("DictItemCode") + "," + DBHelperProxy.FormatParameter("DictItemSequence") + ");"; var parDictItemID = DBHelperProxy.CreateParameter("DictItemID", DBHelperProxy.GetMaxID("DictItem")); var parDictItemName = getSqlParameter("DictItemName", nodeDictItem.Attributes["Name"]); var parDictItemCode = getSqlParameter("DictItemCode", nodeDictItem.Attributes["Code"]); var parDictItemSequence = getSqlParameter("DictItemSequence", nodeDictItem.Attributes["Sequence"]); if (DBHelperProxy.ExecuteNonQuery(strSql, parDictItemID, parDictItemName, parDictDirID, parDictItemCode, parDictItemSequence) == 0) { return(false); } } } } return(true); }
/// <summary> /// 保存角色用户到指定角色里 /// </summary> /// <param name="roleCode"></param> /// <param name="userID"></param> /// <param name="sUnitID"></param> public void SaveRoleUser(string roleCode, int userID, int sUnitID) { string sbSql = "insert into RoleUser(RoleID,UserID, UnitID) values(" + Convert.ToInt32(DBHelperProxy.ExecuteScalar("Select ID From Role where code='" + roleCode + "'")) + "," + userID + ", " + sUnitID + ")"; DBHelperProxy.ExecuteNonQuery(sbSql.ToString()); }