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