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