/// <summary> /// 得到一个对象实体 /// </summary> public BWJSLog.Model.OperationLog GetModel(int OperationLogId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select OperationLogId, DepartmentName, RoleId, RoleName, GroupId, GroupName, BusinessType, RelationId, LogContent, Ip, UserId, RealName, CreateDate, DepartmentId "); strSql.Append(" from dbo.[OperationLog] "); strSql.Append(" where OperationLogId=@OperationLogId"); SqlParameter[] parameters = { new SqlParameter("@OperationLogId", SqlDbType.Int, 4) }; parameters[0].Value = OperationLogId; BWJSLog.Model.OperationLog model = new BWJSLog.Model.OperationLog(); DataSet ds = BWJSLogHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// datarow转成对象实体 /// </summary> public BWJSLog.Model.OperationLog DataRowToModel(DataRow row) { BWJSLog.Model.OperationLog model = new BWJSLog.Model.OperationLog(); if (row != null) { if (row["OperationLogId"].ToString() != "") { model.OperationLogId = int.Parse(row["OperationLogId"].ToString()); } model.DepartmentName = row["DepartmentName"].ToString(); if (row["RoleId"].ToString() != "") { model.RoleId = int.Parse(row["RoleId"].ToString()); } model.RoleName = row["RoleName"].ToString(); if (row["GroupId"].ToString() != "") { model.GroupId = int.Parse(row["GroupId"].ToString()); } model.GroupName = row["GroupName"].ToString(); if (row["BusinessType"].ToString() != "") { model.BusinessType = int.Parse(row["BusinessType"].ToString()); } if (row["RelationId"].ToString() != "") { model.RelationId = int.Parse(row["RelationId"].ToString()); } model.LogContent = row["LogContent"].ToString(); model.Ip = row["Ip"].ToString(); if (row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } model.RealName = row["RealName"].ToString(); if (row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["DepartmentId"].ToString() != "") { model.DepartmentId = int.Parse(row["DepartmentId"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BWJSLog.Model.OperationLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dbo.[OperationLog] set "); strSql.Append(" DepartmentName = @DepartmentName , "); strSql.Append(" RoleId = @RoleId , "); strSql.Append(" RoleName = @RoleName , "); strSql.Append(" GroupId = @GroupId , "); strSql.Append(" GroupName = @GroupName , "); strSql.Append(" BusinessType = @BusinessType , "); strSql.Append(" RelationId = @RelationId , "); strSql.Append(" LogContent = @LogContent , "); strSql.Append(" Ip = @Ip , "); strSql.Append(" UserId = @UserId , "); strSql.Append(" RealName = @RealName , "); strSql.Append(" CreateDate = @CreateDate , "); strSql.Append(" DepartmentId = @DepartmentId "); strSql.Append(" where OperationLogId=@OperationLogId "); SqlParameter[] parameters = { new SqlParameter("@OperationLogId", model.OperationLogId), new SqlParameter("@DepartmentName", model.DepartmentName), new SqlParameter("@RoleId", model.RoleId), new SqlParameter("@RoleName", model.RoleName), new SqlParameter("@GroupId", model.GroupId), new SqlParameter("@GroupName", model.GroupName), new SqlParameter("@BusinessType", model.BusinessType), new SqlParameter("@RelationId", model.RelationId), new SqlParameter("@LogContent", model.LogContent), new SqlParameter("@Ip", model.Ip), new SqlParameter("@UserId", model.UserId), new SqlParameter("@RealName", model.RealName), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@DepartmentId", model.DepartmentId) }; int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJSLog.Model.OperationLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[OperationLog]("); strSql.Append("DepartmentName,RoleId,RoleName,GroupId,GroupName,BusinessType,RelationId,LogContent,Ip,UserId,RealName,CreateDate,DepartmentId"); strSql.Append(") values ("); strSql.Append("@DepartmentName,@RoleId,@RoleName,@GroupId,@GroupName,@BusinessType,@RelationId,@LogContent,@Ip,@UserId,@RealName,@CreateDate,@DepartmentId"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@DepartmentName", model.DepartmentName), new SqlParameter("@RoleId", model.RoleId), new SqlParameter("@RoleName", model.RoleName), new SqlParameter("@GroupId", model.GroupId), new SqlParameter("@GroupName", model.GroupName), new SqlParameter("@BusinessType", model.BusinessType), new SqlParameter("@RelationId", model.RelationId), new SqlParameter("@LogContent", model.LogContent), new SqlParameter("@Ip", model.Ip), new SqlParameter("@UserId", model.UserId), new SqlParameter("@RealName", model.RealName), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@DepartmentId", model.DepartmentId) }; object obj = BWJSLogHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }