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