public bool AddVideoToCatalog(Guid[] catalogId, Guid itemId) { DataTable mapTable = new DataTable(); mapTable.Columns.Add("VideoStorageid", typeof(Guid)); mapTable.Columns.Add("Catalogid", typeof(Guid)); for (int i = 0; i < catalogId.Length; i++) { DataRow newRow = mapTable.NewRow(); newRow["VideoStorageid"] = itemId; newRow["Catalogid"] = catalogId[i]; mapTable.Rows.Add(newRow); } string sql = "Delete From VideoStorage_Catalogs Where videoStorageId=@itemId"; SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@itemId", SqlDbType.UniqueIdentifier); Parameters[0].Value = itemId; SqlConnection con = null; SqlTransaction trans = null; try { con = new SqlConnection(CommonInfo.ConQJVRMS); con.Open(); trans = con.BeginTransaction(); SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sql, Parameters); SqlHelperExtend.Update("videoStorage_Catalogs", mapTable, trans); trans.Commit(); return(true); } catch (Exception ex) { trans.Rollback(); LogWriter.WriteExceptionLog(ex); return(false); } finally { if (con != null) { con.Close(); } } }
public DataSet SearchByDept(Guid catalogId, Guid userId, Guid deptID, int pageSize, int pageIndex) { //string sqlWhere = "Where i.ItemId = ic.ImageStorageid and ic.catalogId='"+catalogId+"'"; //sqlWhere += " and ic.catalogId not in (select objectId from AccessControlList Where OperatorId='" + userId.ToString() + "' and OperatorMethod=6)"; //sqlWhere += " and ic.catalogId not in (Select objectId from AccessControlList Where OperatorMethod=6 and OperatorId in (Select RoleId From Users_InRoles Where UserId='"+userId.ToString()+"'))"; string tables = string.Empty; string sqlWhere = " Where r.Id = rc.resourceid and rc.catalogId='" + catalogId + "'"; sqlWhere += " and rc.catalogId not in (select objectId from AccessControlList Where OperatorId='" + userId.ToString() + "' and OperatorMethod=6)"; sqlWhere += " and rc.catalogId not in (Select objectId from AccessControlList Where OperatorMethod=6 and OperatorId in (Select RoleId From Users_InRoles Where UserId='" + userId.ToString() + "'))"; if (deptID != Guid.Empty) { //sqlWhere += " and i.GroupId='" + deptID + "'"; //tables = "ImageStorage i,ImageStorage_Catalogs ic"; sqlWhere += " and r.userId in (select userid from users where groupid='" + deptID + "')"; } else { //tables = "ImageStorage i,ImageStorage_Catalogs ic"; } tables = " Resources r,Resource_catalogs rc"; //增加了 filename 信息的输出 by ciqq 2010-4-2 //string columns = "r.Id,r.ItemSerialNumber,r.ServerFolderName,r.serverfilename,r.Caption"; string columns = "r.*"; int pageCount = 0; return(SqlHelperExtend.Paging(new SqlConnection(CommonInfo.ConQJVRMS), tables, columns, sqlWhere, pageSize, pageIndex, "r.Id", out pageCount)); }
public bool AddADUsersToDB(string userListStr, Guid groupid) { DataTable userTable = new DataTable(); userTable.Columns.Add("UserId", typeof(Guid)); userTable.Columns.Add("GroupId", typeof(Guid)); userTable.Columns.Add("loginName", typeof(string)); userTable.Columns.Add("UserName", typeof(string)); userTable.Columns.Add("Tel", typeof(string)); userTable.Columns.Add("Email", typeof(string)); userTable.Columns.Add("uType", typeof(string)); userTable.Columns.Add("password", typeof(string)); userTable.Columns.Add("isLocked", typeof(string)); userTable.Columns.Add("isDownload", typeof(string)); userTable.Columns.Add("isIpValidate", typeof(string)); userTable.Columns.Add("IpAddress", typeof(string)); userTable.Columns.Add("CreateDate", typeof(DateTime)); SerializeObjectFactory sof = new SerializeObjectFactory(); ArrayList userList = (ArrayList)sof.DesializeFromBase64(userListStr); foreach (object ouser in userList) { QJVRMS.Business.User user = ouser as QJVRMS.Business.User; DataRow userRow = userTable.NewRow(); userRow["UserId"] = user.UserId; userRow["GroupId"] = groupid; userRow["loginName"] = user.UserLoginName; userRow["UserName"] = user.UserName; userRow["Tel"] = user.Telphone; userRow["Email"] = user.Email; userRow["uType"] = "1"; userRow["password"] = "******"; userTable.Rows.Add(userRow); } SqlConnection con = null; SqlTransaction trans = null; try { con = new SqlConnection(CommonInfo.ConQJVRMS); con.Open(); trans = con.BeginTransaction(); SqlHelperExtend.Update("Users", userTable, trans); trans.Commit(); return(true); } catch (Exception ex) { trans.Rollback(); LogWriter.WriteExceptionLog(ex); return(false); } finally { if (con != null) { con.Close(); } } }