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