public static bool IsRegiste() { bool val = false; string serial = Convert.ToString(DBHelperProxy.ExecuteScalar("Select Code From Dept Where ID=-1")); if (string.IsNullOrEmpty(serial)) { val = false; } else { string unitname = Convert.ToString(DBHelperProxy.ExecuteScalar("Select Name From Dept Where ID=1")); if (ALEncrypt.Md5hash(unitname + "sudenggang") == serial) { val = true; } else { val = false; } } return(val); }
public DataTable GetLogStat() { DataTable dtTotal = new DataTable("LogTotal"); DataColumn dc = new DataColumn("Desc"); dtTotal.Columns.Add(dc); dc = new DataColumn("Total"); dtTotal.Columns.Add(dc); string sql = "select * from " + DBHelperProxy.FormatFunction("gettables"); DataTable dt = DBHelperProxy.GetDataTable(sql); DataRow drr; foreach (DataRow dr in dt.Rows) { drr = dtTotal.NewRow(); drr["Desc"] = dr["table_name"]; drr["Total"] = DBHelperProxy.ExecuteScalar(string.Format("select count(*) as total from " + DBHelperProxy.FormatTable("{0}"), dr["Name"].ToString())); dtTotal.Rows.Add(drr); } return(dtTotal); }
/// <summary> /// 检测该部门是否有用户 /// </summary> /// <param name="deptID"></param> /// <returns></returns> public bool IsHavUserInDept(int deptID) { int sCount = 0; string strSQL = "Select Count(*) From " + DBHelperProxy.FormatTable("User") + " Where DeptID=" + deptID; sCount = Convert.ToInt32(DBHelperProxy.ExecuteScalar(strSQL)); return(sCount > 0); }
/// <summary> /// 通过uid获取担任部门负责人的部门名称 /// </summary> /// <param name="leaderid"></param> /// <returns></returns> public string GetDeptName(int leaderid) { string strSQL = "select top 1 Name from Dept where LeaderID=" + leaderid.ToString(); object obj = DBHelperProxy.ExecuteScalar(strSQL); if (obj != null && obj != DBNull.Value) { return(obj.ToString()); } return(string.Empty); }
/// <summary> /// 根据id取部门名称 /// </summary> /// <param name="deptID"></param> /// <returns></returns> public string GetDeptNameByID(int deptID) { string strSQL = "Select Name from " + DBHelperProxy.FormatTable("Dept") + " where ID=" + deptID.ToString(); object name = DBHelperProxy.ExecuteScalar(strSQL); if (name != null && name != DBNull.Value) { return(name.ToString()); } else { return(string.Empty); } }
/// <summary> /// 新建单位时自动产生一个单位管理员 /// </summary> /// <param name="deptID">部门ID</param> /// <param name="unitID">单位ID</param> public void NewAdminOfUnit(long deptID, long unitID, string unitName) { long newUserID; string userName = "******" + unitID; string password = ALEncrypt.Md5hash(AppConfig.GetConfig("InitPassword")); newUserID = DBHelperProxy.GetMaxID("User"); string strSQL = "Insert Into " + DBHelperProxy.FormatTable("User") + "(ID,UserName,LoginName," + DBHelperProxy.FormatField("Password") + ",DeptID,DeptName,UnitID,IsStop," + DBHelperProxy.FormatField("Sequence") + ") Values(" + newUserID.ToString() + ", '管理员[" + unitID + "]','" + userName + "','" + password + "'," + deptID + ",'" + unitName + "'," + unitID + ",1,100);"; DBHelperProxy.ExecuteScalar(strSQL); //添加到管理员角色中 AddUserToAdminRole(newUserID, unitID); }
/// <summary> /// 根据部门id取部门领导id /// </summary> /// <param name="deptID"></param> /// <returns></returns> public void GetLeaderIDByDeptID(int deptID, out int leaderID, out string leaderName) { leaderID = 0; leaderName = ""; string strSQL = "select LeaderID from " + DBHelperProxy.FormatTable("Dept") + " where ID =" + deptID; object leader = DBHelperProxy.ExecuteScalar(strSQL); if (leader != null && leader != DBNull.Value) { leaderID = (int)leader; IUser user = new UserBO(); leaderName = user.GetUserNameByID(leaderID); } }
/// <summary> /// 插入和更新 /// </summary> /// <param name="deptInfo"></param> /// <returns></returns> public long Save(SYSDeptInfo deptInfo) { long id = deptInfo.ID.Value; base.Save(deptInfo); if (deptInfo.IsUnit == 1) { deptInfo.UnitID = deptInfo.ID; deptInfo.ParentID = 0; deptInfo.Layer = 0; deptInfo.Path = ",-1," + deptInfo.ID + ","; } else { DeptInfo tempInfo = GetInfo <DeptInfo>(deptInfo.ParentID.Value); deptInfo.Layer = tempInfo.Layer + 1; deptInfo.Path = tempInfo.Path + deptInfo.ID + ","; } base.Save(deptInfo); if (id != 0) { //更新user表 string strSql = "UPDATE " + DBHelperProxy.FormatTable("User") + " SET DeptName = " + DBHelperProxy.FormatParameter("Name") + " WHERE DeptID=" + DBHelperProxy.FormatParameter("ID") + ";UPDATE " + DBHelperProxy.FormatTable("User") + " SET SLDeptName = " + DBHelperProxy.FormatParameter("Name") + " WHERE SLDeptID=" + DBHelperProxy.FormatParameter("ID") + ";"; DBHelperProxy.ExecuteScalar(strSql, DBHelperProxy.CreateParameter("Name", deptInfo.Name), DBHelperProxy.CreateParameter("ID", deptInfo.ID.Value)); } if (id == 0 && deptInfo.IsUnit == 1) { //新增单位时自动增加一个单位管理员 NewAdminOfUnit(deptInfo.ID.Value, deptInfo.ID.Value, deptInfo.Name); } return(deptInfo.ID.Value); }
/// <summary> /// 获得父部门的UnitID /// </summary> /// <param name="parentID"></param> /// <returns></returns> public int GetUpperUnitID(int parentID) { string strSQL = "Select UnitID From Dept Where id=" + parentID; return(Convert.ToInt32(DBHelperProxy.ExecuteScalar(strSQL))); }
/// <summary> /// 根据UnitID获得单位名称 /// </summary> /// <param name="unitID"></param> /// <returns></returns> public string GetUnitName(int unitID) { string strSQL = "Select Name From Dept Where (UnitID=0 or UnitID=" + unitID + ") And IsUnit=1"; return(DBHelperProxy.ExecuteScalar(strSQL).ToString()); }
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); }
public string GetName(int id) { string strSql = "select name from DictItem where id=" + id; return((string)DBHelperProxy.ExecuteScalar(strSql)); }
/// <summary> /// 通过角色代码获得角色ID /// </summary> /// <param name="code"></param> /// <returns></returns> public int GetRoleIDByCode(string code) { string strSQL = "Select ID From Role Where Code='" + code + "'"; return(Convert.ToInt32(DBHelperProxy.ExecuteScalar(strSQL))); }
/// <summary> /// 判断是否是所有单位通用角色 /// </summary> /// <param name="roleID"></param> /// <returns></returns> public bool IsCommonRole(int roleID) { string strSQL = "Select UnitID From Role Where ID=" + roleID; return(Convert.ToInt32(DBHelperProxy.ExecuteScalar(strSQL)) == 0); }
/// <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()); }